File size: 773 Bytes
4fcd019 | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 | CREATE TABLE IF NOT EXISTS app_user (
id INTEGER PRIMARY KEY AUTOINCREMENT,
name TEXT NOT NULL,
preferred_language TEXT NOT NULL,
role TEXT NOT NULL CHECK (role IN ('patient', 'provider'))
);
CREATE TABLE IF NOT EXISTS session (
id INTEGER PRIMARY KEY AUTOINCREMENT,
user_id INTEGER NOT NULL,
start_time TEXT NOT NULL,
end_time TEXT,
FOREIGN KEY (user_id) REFERENCES app_user (id)
);
CREATE TABLE IF NOT EXISTS interaction (
id INTEGER PRIMARY KEY AUTOINCREMENT,
user_id INTEGER NOT NULL,
input_text TEXT,
detected_language TEXT,
translated_text TEXT,
nlu_summary TEXT,
provider_response TEXT,
translated_response TEXT,
timestamp TEXT NOT NULL,
FOREIGN KEY (user_id) REFERENCES app_user (id)
);
|