eE2EDPRK

1PRAGMA FOREIGN_KEYS=OFF;
2DROP TABLE IF EXISTS users;
3DROP TABLE IF EXISTS logs;
4DROP TABLE IF EXISTS records;
5PRAGMA FOREIGN_KEYS=ON;
6
7
8CREATE TABLE users (
9name VARCHAR(50),
10occupation VARCHAR(50),
11division VARCHAR(50),
12user_id INTEGER,
13PRIMARY KEY (user_id)
14);
15
16CREATE TABLE logs (
17times TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
18action VARCHAR(50),
19file_id INTEGER,
20user_id INTEGER,
21FOREIGN_KEY (file_id) REFERENCES records(file_id),
22FOREIGN_KEY (user_id) REFERENCES users(user_id)
23);
24
25CREATE TABLE records (
26person VARCHAR(50),
27nurse VARCHAR(50),
28doctor VARCHAR(50),
29division VARCHAR(50),
30time_of_creation TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
31file_id INTEGER,
32FOREIGN_KEY (division) REFERENCES users(division),
33PRIMARY KEY (file_id)
34);