[sql] tesst
Viewer
- CREATE TABLE Restaurant(
- ID_imatricualtion INT PRIMARY KEY NOT NULL,
- Adresse CHAR(50) NOT NULL,
- Horaire CHAR(50) NOT NULL
- );
- CREATE TABLE Personelle(
- ID_personelle INT PRIMARY KEY NOT NULL,
- Nom CHAR(50) NOT NULL,
- Prenom CHAR(50) NOT NULL,
- Heure_activie INT,
- ID_imatricualtion INT,
- FOREIGN KEY (ID_imatricualtion) REFERENCES Restaurant(ID_imatricualtion)
- );
- CREATE TABLE Gerant(
- ID_gerant INT PRIMARY KEY NOT NULL,
- ID_personelle INT,
- FOREIGN KEY (ID_personelle) REFERENCES Personelle(ID_personelle)
- );
- CREATE TABLE Employer(
- ID_employer INT PRIMARY KEY NOT NULL,
- Date_embauche DATE NOT NULL,
- Type_contrat CHAR(20) NOT NULL,
- Heure_activie INT,
- ID_personelle INT,
- FOREIGN KEY (ID_personelle) REFERENCES Personelle(ID_personelle)
- );
- CREATE TABLE Cuisinier(
- ID_cuisinier INT PRIMARY KEY NOT NULL,
- Specialite CHAR(50) NOT NULL,
- ID_employer INT,
- FOREIGN KEY (ID_employer) REFERENCES Employer(ID_employer)
- );
- CREATE TABLE Serveur(
- ID_serveur INT PRIMARY KEY NOT NULL,
- Poste CHAR(50) NOT NULL,
- ID_employer INT,
- FOREIGN KEY (ID_employer) REFERENCES Employer(ID_employer)
- );
- CREATE TABLE Client(
- ID_client INT PRIMARY KEY NOT NULL,
- Age CHAR(50) NOT NULL,
- ID_serveur INT,
- FOREIGN KEY (ID_serveur) REFERENCES Employer(ID_serveur)
- );
- CREATE TABLE Repas(
- ID_repas INT PRIMARY KEY NOT NULL,
- Type_repas CHAR(50) NOT NULL,
- Calorie NOT NULL,
- Piquant BOOLEAN
- );
- CREATE TABLE Cuisine(
- ID_cuisinier INT,
- ID_repas INT,
- FOREIGN KEY (ID_cuisinier) REFERENCES Employer(ID_cuisinier)
- FOREIGN KEY (ID_repas) REFERENCES Employer(ID_repas)
- );
- CREATE TABLE Servir(
- ID_client INT,
- ID_repas INT,
- FOREIGN KEY (ID_client) REFERENCES Employer(ID_client)
- FOREIGN KEY (ID_repas) REFERENCES Employer(ID_repas)
- );
- CREATE TABLE Boisson(
- Taille FLOAT NOT NULL,
- Teneur_alcool INT,
- Arome CHAR(50)
- );
- CREATE TABLE Table_restaurant(
- Nombre_Place INT NOT NULL
- );
Editor
You can edit this paste and save as new: