import sqlite3
conn = sqlite3.connect('it_smart_desk.db')
cursor = conn.cursor()
cursor.execute('PRAGMA table_info(conversations)')
cols = [row[1] for row in cursor.fetchall()]
print('Columns in conversations table:')
for c in cols:
    print(f'  {c}')
print()
missing = ['impact_scope', 'is_blocking', 'emotion_state']
for m in missing:
    status = "EXISTS" if m in cols else "MISSING!"
    print(f'{m}: {status}')
conn.close()
