<?php
require_once __DIR__ . '/../database/Database.php';
$db = Database::getInstance();
$tables = ['payments', 'payment_attempts', 'payment_slips', 'payment_accounts', 'refunds'];

foreach ($tables as $t) {
    $stmt = $db->query("DESCRIBE `$t`");
    echo "=== TABLE: {$t} ===" . PHP_EOL;
    foreach ($stmt->fetchAll(PDO::FETCH_ASSOC) as $col) {
        echo sprintf("  %-25s %-20s Null:%-4s Key:%-4s Def:%s\n", 
            $col['Field'], $col['Type'], $col['Null'], $col['Key'], (string)$col['Default']);
    }
    echo PHP_EOL;
}