create table TICKET
(
ID_TICKET int not null AUTO_INCREMENT PRIMARY KEY,
STATUT varchar(10),
CHECK STATUT IN ('ouvert','en cours','fermer'),
DESCRIPTION varchar(500)
);
create table CONTRAT_CLIENT
(
ID_CLIENT int not null AUTO_INCREMENT PRIMARY KEY,
NOM varchar (20),
PRENOM varchar (20),
ADRESSE varchar (40),
CONTACT_1 varchar (40),
CONTACT_2 varchar (40),
MAIL varchar (30),
TEL int(14),
FAX int (14),
DATE_DEBUT date,
DATE_FIN date,
ID_TICKET INT,
INDEX(ID_TICKET),
CONSTRAINT fk_id_ticket FOREIGN KEY(ID_TICKET) references TICKET(ID_TICKET)
);
create table TYPE_CONTRAT
(
ID_TYPE_CONTRAT int not null AUTO_INCREMENT PRIMARY KEY,
LIBELLE varchar (20),
ID_CLIENT INT,
INDEX(ID_CLIENT),
CONSTRAINT fk_id_client FOREIGN KEY(ID_CLIENT) references CONTRAT_CLIENT(ID_CLIENT)
);
create table PERSONNE_SUPPORT
(
ID_PERSONNE int not null AUTO_INCREMENT PRIMARY KEY,
NOM varchar (20),
PRENOM varchar (20),
TEL int (14),
MAIL varchar (30)
);
Partager