SHARE
TWEET

svp

a guest Dec 12th, 2019 83 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE TABLE MEDECIN(
  2.    ID_MEDECIN INT,
  3.    CIVILITE VARCHAR(3),
  4.    NOM VARCHAR(50),
  5.    PRENOM VARCHAR(50),
  6.    PRIMARY KEY(ID_MEDECIN)
  7. );
  8.  
  9. CREATE TABLE PATIENT(
  10.    N_SECU CHAR(15),
  11.    CIVILITE VARCHAR(3),
  12.    NOM VARCHAR(50),
  13.    PRENOM VARCHAR(50),
  14.    ADRESSE VARCHAR(50),
  15.    CP VARCHAR(50),
  16.    VILLE VARCHAR(50),
  17.    DATE_NAISSANCE VARCHAR(50),
  18.    LIEU_NAISSANCE VARCHAR(50),
  19.    ID_MEDECIN INT,
  20.    PRIMARY KEY(N_SECU),
  21.    FOREIGN KEY(ID_MEDECIN) REFERENCES MEDECIN(ID_MEDECIN)
  22. );
  23.  
  24. CREATE TABLE RDV(
  25.    ID_RDV INT,
  26.    DATE_H_RDV DATETIME,
  27.    DUREE INT,
  28.    ID_MEDECIN INT NOT NULL,
  29.    N_SECU CHAR(15) NOT NULL,
  30.    PRIMARY KEY(ID_RDV),
  31.    FOREIGN KEY(ID_MEDECIN) REFERENCES MEDECIN(ID_MEDECIN),
  32.    FOREIGN KEY(N_SECU) REFERENCES PATIENT(N_SECU)
  33. );
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top