/
Wassabi
/
Karolina
Обзор
Документация
Войти
/
Wassabi
/
Karolina
Код
Запросы
0
Задачи
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
Lab2
43 строки
1 KB
Wassabi
create Lab2
02 окт 2024, 16:27
02 окт 2024, 16:27
579042e
Код
Авторство
О чём код?
CREATE TABLE Users ( user_id INT PRIMARY KEY AUTO_INCREMENT, username VARCHAR(50) NOT NULL UNIQUE, password VARCHAR(255) NOT NULL, role ENUM('player', 'coach', 'admin') NOT NULL, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ); CREATE TABLE Teams ( team_id INT PRIMARY KEY AUTO_INCREMENT, team_name VARCHAR(100) NOT NULL ); CREATE TABLE Players ( player_id INT PRIMARY KEY AUTO_INCREMENT, name VARCHAR(100) NOT NULL, team_id INT, FOREIGN KEY (team_id) REFERENCES Teams(team_id) ); CREATE TABLE Games ( game_id INT PRIMARY KEY AUTO_INCREMENT, date DATE, notes TEXT ); CREATE TABLE Statistics ( stat_id INT PRIMARY KEY AUTO_INCREMENT, player_id INT, game_id INT, attacks INT, blocks INT, serves INT, FOREIGN KEY (player_id) REFERENCES Players(player_id), FOREIGN KEY (game_id) REFERENCES Games(game_id) ); CREATE TABLE AnalyticsContacts ( contact_id INT PRIMARY KEY AUTO_INCREMENT, name VARCHAR(100), speciality VARCHAR(100), contact_info VARCHAR(255) );