f7Nana0N

1drop database if exists sportclubs;
2create database sportclubs;
3use sportclubs;
4
5CREATE TABLE sports(
6id INT AUTO_INCREMENT PRIMARY KEY,
7name varchar(255) NOT NULL
8);
9 
10CREATE TABLE coaches(
11id INT AUTO_INCREMENT PRIMARY KEY,
12name VARCHAR(255) NOT NULL 
13);
14
15CREATE TABLE students(
16id INT AUTO_INCREMENT PRIMARY KEY,
17name VARCHAR(255) NOT NULL,
18fNum VARCHAR(20) NOT NULL,
19egn VARCHAR(10) NOT NULL UNIQUE,
20phone VARCHAR(55) NULL DEFAULT NULL,
21class VARCHAR(55) NOT NULL
22);