]>
iEval git - gruntmaster-data.git/blob - db.sql
1 CREATE TYPE ULEVEL
AS ENUM ('Highschool', 'Undergraduate', 'Master', 'Doctorate', 'Other');
2 CREATE TYPE PLEVEL
AS ENUM ('beginner', 'easy', 'medium', 'hard');
3 CREATE TYPE GENERATOR
AS ENUM ('File', 'Run', 'Undef');
4 CREATE TYPE RUNNER
AS ENUM ('File', 'Verifier', 'Interactive');
5 CREATE TYPE JUDGE
AS ENUM ('Absolute', 'Points');
9 name TEXT, -- NOT NULL,
10 email
TEXT, -- NOT NULL,
11 phone
TEXT, -- NOT NULL,
12 town
TEXT, -- NOT NULL,
13 university
TEXT, -- NOT NULL,
14 level TEXT, --ULEVEL NOT NULL,
18 CREATE TABLE contests (
23 owner TEXT NOT NULL REFERENCES users
,
24 CONSTRAINT positive_duration
CHECK (stop
> start)
27 CREATE TABLE problems (
31 generator GENERATOR
NOT NULL,
33 level PLEVEL
NOT NULL,
36 owner TEXT NOT NULL REFERENCES users
,
37 private
BOOLEAN NOT NULL DEFAULT FALSE,
38 runner RUNNER
NOT NULL,
39 statement TEXT NOT NULL,
42 timeout
REAL NOT NULL,
50 CREATE TABLE contest_problems (
51 contest
TEXT REFERENCES contests
,
52 problem
TEXT NOT NULL REFERENCES problems
,
53 PRIMARY KEY (contest
, problem
)
57 id SERIAL
PRIMARY KEY,
58 contest
TEXT REFERENCES contests
,
62 extension
TEXT NOT NULL,
64 private
BOOLEAN NOT NULL DEFAULT FALSE,
65 problem
TEXT NOT NULL REFERENCES problems
,
70 owner TEXT NOT NULL REFERENCES users
74 contest
TEXT NOT NULL REFERENCES contests
,
75 problem
TEXT NOT NULL REFERENCES problems
,
76 owner TEXT NOT NULL REFERENCES users
,
78 PRIMARY KEY (contest
, problem
, owner)
This page took 0.044211 seconds and 4 git commands to generate.