<?php
require __DIR__ . '/../../vendor/autoload.php';
$dotenv = Dotenv\Dotenv::createImmutable(__DIR__ . '/../../');
$dotenv->load();
$pdo = new PDO(
    'mysql:host=' . getenv('DB_HOST') . ';port=' . getenv('DB_PORT') . ';dbname=' . getenv('DB_DATABASE') . ';charset=utf8mb4',
    getenv('DB_USERNAME'),
    getenv('DB_PASSWORD')
);
$stmt = $pdo->query("SELECT table_name, column_name, collation_name FROM information_schema.columns WHERE table_schema = DATABASE() AND column_name = 'tenant_id' AND collation_name LIKE 'utf8mb4%' ORDER BY table_name");
foreach ($stmt as $row) {
    print_r($row);
}
