/
zark
/
WebSocketChat
Обзор
Документация
Войти
/
zark
/
WebSocketChat
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
src/main/resources/sql/schema.sql
42 строки
1 KB
Zark94
first_commit
18 окт 2024, 14:57
18 окт 2024, 14:57
42c483f
Код
Авторство
О чём код?
CREATE TABLE CHAT_USER ( id BIGINT PRIMARY KEY AUTO_INCREMENT, status BOOLEAN NOT NULL, login VARCHAR(255) NOT NULL, first_name VARCHAR(255), last_name VARCHAR(255), email VARCHAR(255), password VARCHAR(255) NOT NULL ); CREATE TABLE Message ( id identity, text VARCHAR(255) NOT NULL, sender_id INT NOT NULL, RECIPIENT_ID INT NOT NULL, room_id INT NOT NULL, time_sent TIMESTAMP NOT NULL -- FOREIGN KEY (sender_id) REFERENCES User(id), -- FOREIGN KEY (room_id) REFERENCES Rooms(id) ); CREATE TABLE Rooms ( id identity, name VARCHAR(255) NOT NULL, last_active TIMESTAMP NOT NULL ); CREATE TABLE Room_User ( id identity, room_id INT NOT NULL, room_user_id INT NOT NULL -- FOREIGN KEY (room_id) REFERENCES Room(id), -- FOREIGN KEY (user_id) REFERENCES User(id) ); CREATE TABLE Message_Room ( message_id INT NOT NULL, room_id INT NOT NULL -- FOREIGN KEY (message_id) REFERENCES Message(id), -- FOREIGN KEY (room_id) REFERENCES Room(id) );