/
erddrsf
/
Pyhse
Обзор
Документация
Войти
/
erddrsf
/
Pyhse
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
CI/CD
Аналитика
Безопасность
master
tables.sql
49 строк
1 KB
erddrsf
Проект Sql
01 май 2026, 23:16
Верифицирован
01 май 2026, 23:16
a80bcad
Код
Авторство
О чём код?
create table "group" ( id serial primary key ); create table exams ( id serial primary key, subject varchar(255) not null, allowance_conditions int, optional boolean default false, assessment_or_mark boolean, semester int default 1 ); -- create table ExamRequirements1 create table students ( id serial primary key, course int, name varchar(255) not null ); create table group_students ( group_id int not null references "group"(id) on delete cascade, student_id int not null references students(id) on delete cascade, primary key (group_id, student_id) ); create table group_exams ( group_id int not null references "group"(id) on delete cascade, exam_id int not null references exams(id) on delete cascade, primary key (group_id, exam_id) ); create table exam_depts ( student_id int not null references students(id) on delete cascade, exam_id int not null references exams(id) on delete cascade, allow_to_pass boolean default false, passed boolean default false, mark int, primary key (student_id, exam_id) ); create table seminars (id serial primary key, exam_name varchar(255) not null ); create table exams_seminars (exam_id int not null references exams(id) on delete cascade, seminars_id int not null references seminars(id) on delete cascade, primary key(exam_id,seminars_id));