<?php
require_once '../config/database.php';
$database = new Database();
$db = $database->getConnection();

$query = "DESCRIBE offers";
$stmt = $db->prepare($query);
$stmt->execute();
$columns = $stmt->fetchAll(PDO::FETCH_ASSOC);

echo "Columns in offers table:\n";
foreach ($columns as $column) {
    echo "- " . $column['Field'] . " (" . $column['Type'] . ")\n";
}
?>