<?php
require_once __DIR__ . '/includes/db.php';
global $pdo;

echo "Columns in 'deals' table:\n";
$stmt = $pdo->query("SHOW COLUMNS FROM deals");
while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
    print_r($row);
}

echo "\nForeign Keys in 'deals' table:\n";
try {
    $stmt = $pdo->query("SELECT 
        TABLE_NAME, 
        COLUMN_NAME, 
        CONSTRAINT_NAME, 
        REFERENCED_TABLE_NAME, 
        REFERENCED_COLUMN_NAME
    FROM
        INFORMATION_SCHEMA.KEY_COLUMN_USAGE
    WHERE
        REFERENCED_TABLE_SCHEMA = 'aibenproperties' AND
        TABLE_NAME = 'deals'");
    while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
        print_r($row);
    }
} catch (Exception $e) {
    echo "Error checking foreign keys: " . $e->getMessage() . "\n";
}