diff options
Diffstat (limited to '')
-rw-r--r-- | sql/schema.sql | 10 |
1 files changed, 9 insertions, 1 deletions
diff --git a/sql/schema.sql b/sql/schema.sql index 06f4091..099e79e 100644 --- a/sql/schema.sql +++ b/sql/schema.sql @@ -1,5 +1,5 @@ CREATE TABLE courses ( - id INTEGER PRIMARY KEY, + id INTEGER GENERATED ALWAYS AS IDENTITY PRIMARY KEY, nmax INTEGER NOT NULL, title TEXT, ctype TEXT, @@ -14,3 +14,11 @@ CREATE TABLE users ( session TEXT, expr INTEGER ); +CREATE TABLE choices ( + id INTEGER GENERATED ALWAYS AS IDENTITY, + seltime BIGINT NOT NULL, -- microseconds + userid TEXT NOT NULL, + courseid INTEGER NOT NULL, + FOREIGN KEY(userid) REFERENCES users(id), + FOREIGN KEY(courseid) REFERENCES courses(id) +); |