import sys
sys.path.append('Backend')
from app.config.database import engine
from sqlalchemy import inspect, text

inspector = inspect(engine)
columns = inspector.get_columns('tracer_responses')
print("Columns in tracer_responses:")
for col in columns:
    print(f"  {col['name']}: {col['type']}")

print("\nColumns in alumni:")
for col in inspector.get_columns('alumni'):
    print(f"  {col['name']}: {col['type']}")