create database ClubTenis;
use ClubTenis;
create table Pistas(
IdPista Varchar(20) Primary key not null,
DescPista Double,
Grada Bool,
Homolog Bool
)engine =InnoDB;
create table Socios(
NIFS Varchar(20) Primary key not null,
NomS Varchar(20),
ApeS Varchar(50),
DirS Varchar(50),
TelS int,
CC_S Varchar(40),
Accion Bool
)engine =InnoDB;
create table Profes(
NIFPro Varchar(20) Primary key not null,
NumFed Varchar(30),
NomPro Varchar(20),
ApePro Varchar(50),
DirPro Varchar(50),
TelPro int
)engine =InnoDB;
create table Curso(
IdCurso Varchar(20) Primary key not null,
Nom_Curso Varchar(50),
Max_Alu int,
NIFPro Varchar(20),
Foreign key(NIFPro) references Profes(NIFPro) on Update Cascade on Delete
Cascade
)engine =InnoDB;
create table Reservas(
IdPista Varchar(20) not null,
FechaRe Date not null,
Hora_ent Time not null,
Hora_sal Time,
Pagado Bool,
Luz Bool,
Foreign key(IdPista) references Pistas(IdPista) on Update Cascade on Delete
Cascade,
Primary Key (IdPista,FechaRe,Hora_ent)
)engine =InnoDB;
create table Horario(
IdCurso Varchar(20) not null,
Dia Date not null,
H_Ini Time,
H_Fin Time,
Foreign key(IdCurso) references Curso(IdCurso) on Update Cascade on Delete
Cascade,
Primary Key (IdCurso,Dia)
)engine =InnoDB;
create table Recibos(
IdCurso Varchar(20) not null,
NIFS Varchar(20) not null,
FechaRec Date not null,
PagadoR Bool,
Cuota Double,
Foreign key(IdCurso) references Curso(IdCurso) on Update Cascade on Delete
Cascade,
Foreign key(NIFS) references Socios(NIFS) on Update Cascade on Delete
Cascade,
Primary Key (IdCurso, NIFS,FechaRec)
)engine =InnoDB;
create table Juega(
NIFS Varchar(20) not null,
IdPista Varchar(20) not null,
FechaRe Date not null,
Hora_ent Time not null,
Foreign key(NIFS) references Socios(NIFS) on Update Cascade on Delete
Cascade,
Foreign key(IdPista) references Pistas(IdPista) on Update Cascade on Delete
Cascade,
Foreign key(IdPista,FechaRe,Hora_ent) references
Reservas(IdPista,FechaRe,Hora_ent) on Update Cascade on Delete Cascade,
Primary Key(NIFS,IdPista,FechaRe,Hora_ent)
)engine =InnoDB;