svp

CREATE TABLE MEDECIN(
   ID_MEDECIN INT,
   CIVILITE VARCHAR(3),
   NOM VARCHAR(50),
   PRENOM VARCHAR(50),
   PRIMARY KEY(ID_MEDECIN)
);

CREATE TABLE PATIENT(
   N_SECU CHAR(15),
   CIVILITE VARCHAR(3),
   NOM VARCHAR(50),
   PRENOM VARCHAR(50),
   ADRESSE VARCHAR(50),
   CP VARCHAR(50),
   VILLE VARCHAR(50),
   DATE_NAISSANCE VARCHAR(50),
   LIEU_NAISSANCE VARCHAR(50),
   ID_MEDECIN INT,
   PRIMARY KEY(N_SECU),
   FOREIGN KEY(ID_MEDECIN) REFERENCES MEDECIN(ID_MEDECIN)
);

CREATE TABLE RDV(
   ID_RDV INT,
   DATE_H_RDV DATETIME,
   DUREE INT,
   ID_MEDECIN INT NOT NULL,
   N_SECU CHAR(15) NOT NULL,
   PRIMARY KEY(ID_RDV),
   FOREIGN KEY(ID_MEDECIN) REFERENCES MEDECIN(ID_MEDECIN),
   FOREIGN KEY(N_SECU) REFERENCES PATIENT(N_SECU)
);