CREATE TABLE client(
   Id_client COUNTER,
   pseudo VARCHAR(50),
   nom VARCHAR(50),
   passworrd VARCHAR(50),
   email VARCHAR(50),
   cp VARCHAR(50),
   adresse VARCHAR(50),
   tel INT,
   ville VARCHAR(50),
   role VARCHAR(50),
   registerdate DATETIME,
   PRIMARY KEY(Id_client)
);

CREATE TABLE commande(
   Id_commande COUNTER,
   commande VARCHAR(50),
   datecommande DATETIME,
   prix INT,
   nomPlat VARCHAR(50),
   region VARCHAR(50),
   nomCuisinier VARCHAR(50),
   service LOGICAL,
   PRIMARY KEY(Id_commande)
);

CREATE TABLE plats(
   Id_plats COUNTER,
   nomPlat VARCHAR(50),
   photoPlat TEXT,
   descriptifPlat TEXT,
   prix INT,
   PRIMARY KEY(Id_plats)
);

CREATE TABLE cuisinier(
   Id_cuisinier COUNTER,
   region VARCHAR(50),
   pseudo VARCHAR(50),
   passworrd VARCHAR(255),
   nomCuisinier VARCHAR(50),
   photo VARCHAR(50),
   tel INT,
   PRIMARY KEY(Id_cuisinier)
);

CREATE TABLE facture(
   Id_facture COUNTER,
   commande VARCHAR(50),
   nom VARCHAR(50),
   adresse VARCHAR(50),
   cp VARCHAR(50),
   ville VARCHAR(50),
   PRIMARY KEY(Id_facture)
);

CREATE TABLE consulte(
   Id_client INT,
   Id_plats INT,
   PRIMARY KEY(Id_client, Id_plats),
   FOREIGN KEY(Id_client) REFERENCES client(Id_client),
   FOREIGN KEY(Id_plats) REFERENCES plats(Id_plats)
);

CREATE TABLE panier(
   Id_commande INT,
   Id_plats INT,
   quantité VARCHAR(50),
   PRIMARY KEY(Id_commande, Id_plats),
   FOREIGN KEY(Id_commande) REFERENCES commande(Id_commande),
   FOREIGN KEY(Id_plats) REFERENCES plats(Id_plats)
);

CREATE TABLE propose(
   Id_plats INT,
   Id_cuisinier INT,
   quantite VARCHAR(50),
   nationalitéPlat VARCHAR(50),
   PRIMARY KEY(Id_plats, Id_cuisinier),
   FOREIGN KEY(Id_plats) REFERENCES plats(Id_plats),
   FOREIGN KEY(Id_cuisinier) REFERENCES cuisinier(Id_cuisinier)
);

CREATE TABLE reserve(
   Id_commande INT,
   Id_facture INT,
   calendrierRdv DATETIME,
   PRIMARY KEY(Id_commande, Id_facture),
   FOREIGN KEY(Id_commande) REFERENCES commande(Id_commande),
   FOREIGN KEY(Id_facture) REFERENCES facture(Id_facture)
);

CREATE TABLE recoive(
   Id_cuisinier INT,
   Id_facture INT,
   PRIMARY KEY(Id_cuisinier, Id_facture),
   FOREIGN KEY(Id_cuisinier) REFERENCES cuisinier(Id_cuisinier),
   FOREIGN KEY(Id_facture) REFERENCES facture(Id_facture)
);

CREATE TABLE envoie(
   Id_client INT,
   Id_facture INT,
   PRIMARY KEY(Id_client, Id_facture),
   FOREIGN KEY(Id_client) REFERENCES client(Id_client),
   FOREIGN KEY(Id_facture) REFERENCES facture(Id_facture)
);