<?php
require_once 'config/database.php';
$tableName = 'mail_activity';
$schema = $pdo->query("PRAGMA table_info($tableName)")->fetchAll();
foreach ($schema as $col) {
    echo "COL:{$col['name']}:{$col['type']}:" . ($col['notnull'] ? 'NOTNULL' : 'NULLABLE') . ":" . ($col['pk'] ? 'PK' : '') . "\n";
}
?>
