KnowledgeBase/check_schema.js

const Database = require('better-sqlite3');
const db = new Database('d:/workspace/AuraK/server/data/metadata.db');

try {
    const tableInfo = db.prepare('PRAGMA table_info(assessment_sessions)').all();
    console.log('TABLE INFO:');
    tableInfo.forEach(col => {
        console.log(`- ${col.name} (${col.type})`);
    });
} catch (e) {
    console.error(e);
} finally {
    db.close();
}