/
eelamimi
/
SberJavaCourseBeginner
Обзор
Документация
Войти
/
eelamimi
/
SberJavaCourseBeginner
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
hw5/create tables.sql
24 строки
1 KB
glebka
changed fields
16 апр 2025, 23:30
16 апр 2025, 23:30
221c883
Код
Авторство
О чём код?
CREATE TABLE IF NOT EXISTS teachers ( contract_teacher VARCHAR(6) PRIMARY KEY NOT NULL, last_name_teacher VARCHAR(255) NOT NULL, first_name_teacher VARCHAR(255) NOT NULL, middle_name_teacher VARCHAR(255) NOT NULL, department_teacher VARCHAR(255) DEFAULT '-' ); CREATE TABLE IF NOT EXISTS courses ( id_course UUID PRIMARY KEY DEFAULT gen_random_uuid(), title_course VARCHAR(255) NOT NULL, description_course TEXT DEFAULT 'Описание отсутствует', teacher_course VARCHAR(6) REFERENCES teachers(contract) ON DELETE NO ACTION ON UPDATE CASCADE UNIQUE NOT NULL ); CREATE TABLE IF NOT EXISTS students ( id_student UUID PRIMARY KEY DEFAULT gen_random_uuid(), last_name_student VARCHAR(255) NOT NULL, first_name_student VARCHAR(255) NOT NULL, middle_name_student VARCHAR(255) NOT NULL, group_student VARCHAR(7) DEFAULT '-', student_card_student VARCHAR(10) NOT NULL, course_student UUID REFERENCES courses(id) ON DELETE NO ACTION ON UPDATE CASCADE DEFAULT NULL );