/
Iligiz
/
sQL_3
Обзор
Документация
Войти
/
Iligiz
/
sQL_3
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
CI/CD
Аналитика
Безопасность
master
code.sql
53 строки
2 KB
Iligiz
upload files
16 апр 2025, 16:04
16 апр 2025, 16:04
05b8e14
Код
Авторство
О чём код?
CREATE TABLE Users ( id INTEGER NOT NULL AUTO_INCREMENT UNIQUE, Name VARCHAR(255), Password VARCHAR(255), PRIMARY KEY(id) ); CREATE TABLE Grubs ( id INTEGER NOT NULL AUTO_INCREMENT UNIQUE, Name VARCHAR(255), PRIMARY KEY(id) ); CREATE TABLE SMS ( id INTEGER NOT NULL AUTO_INCREMENT UNIQUE, status BOOLEAN, text VARCHAR(255), File VARCHAR(255), Time DATETIME, PRIMARY KEY(id) ); CREATE TABLE participants ( id INTEGER NOT NULL AUTO_INCREMENT UNIQUE, User_id INTEGER, PRIMARY KEY(id), FOREIGN KEY (User _id) REFERENCES Users(id) ON UPDATE NO ACTION ON DELETE NO ACTION ); CREATE TABLE Pos ( id INTEGER NOT NULL AUTO_INCREMENT UNIQUE, Pos VARCHAR(255), Skills VARCHAR(255), PRIMARY KEY(id), FOREIGN KEY (id) REFERENCES participants(id) ON UPDATE NO ACTION ON DELETE NO ACTION ); -- Промежуточные таблицы для связи Grubs и SMS с participants CREATE TABLE GrubParticipants ( Grub_id INTEGER, Participant_id INTEGER, PRIMARY KEY (Grub_id, Participant_id), FOREIGN KEY (Grub_id) REFERENCES Grubs(id) ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY (Participant_id) REFERENCES participants(id) ON UPDATE NO ACTION ON DELETE NO ACTION ); CREATE TABLE SMSParticipants ( SMS_id INTEGER, Participant_id INTEGER, PRIMARY KEY (SMS_id, Participant_id), FOREIGN KEY (SMS_id) REFERENCES SMS(id) ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY (Participant_id) REFERENCES participants(id) ON UPDATE NO ACTION ON DELETE NO ACTION );