Skip to content
Snippets Groups Projects

Student grading

Merged Martin Mareš requested to merge student-grading into master
1 file
+ 8
1
Compare changes
  • Side-by-side
  • Inline
+ 8
1
@@ -22,7 +22,8 @@ CREATE TABLE owl_courses (
cid serial PRIMARY KEY,
ident varchar(255) UNIQUE NOT NULL,
name varchar(255) NOT NULL,
enroll_token varchar(255) UNIQUE NOT NULL
enroll_token varchar(255) UNIQUE NOT NULL,
student_grading boolean NOT NULL DEFAULT FALSE
);
CREATE TABLE owl_enroll (
@@ -50,6 +51,12 @@ CREATE TABLE owl_topics (
UNIQUE(cid, ident)
);
CREATE TABLE owl_student_graders (
tid int NOT NULL REFERENCES owl_topics(tid) ON DELETE CASCADE,
uid int NOT NULL REFERENCES owl_users(uid) ON DELETE CASCADE,
UNIQUE(tid, uid)
);
CREATE TABLE owl_posts (
pid serial PRIMARY KEY,
tid int NOT NULL REFERENCES owl_topics(tid) ON DELETE CASCADE,
Loading