ALTER TABLE ville ADD CONSTRAINT ville_codepostal_pk
                         PRIMARY KEY (codepostal) ;

   ALTER TABLE rue ADD CONSTRAINT adresse_numrue_pk
                       PRIMARY KEY (numrue) ;
   ALTER TABLE rue ADD CONSTRAINT adresse_codepostal_fk
                       FOREIGN KEY (codepostal)
                       REFERENCES ville (codepostal)  ;

   ALTER TABLE citoyen ADD CONSTRAINT citoyen_numuniv_pk
                           PRIMARY KEY (numuniv) ;
   ALTER TABLE citoyen ADD CONSTRAINT citoyen_sexe_ck
                           CHECK (sexe in ('M','F')) ;
   ALTER TABLE citoyen ADD CONSTRAINT citoyen_pere_fk
                           FOREIGN KEY (pere)
                           REFERENCES citoyen (numuniv) ;
   ALTER TABLE citoyen ADD CONSTRAINT citoyen_mere_fk
                           FOREIGN KEY (mere)
                           REFERENCES citoyen (numuniv) ;

   ALTER TABLE habite ADD CONSTRAINT habite_citoyen_fk
                          FOREIGN KEY (citoyen)
                          REFERENCES citoyen(numuniv) ;
   ALTER TABLE habite ADD CONSTRAINT habite_rue_fk
                          FOREIGN KEY (rue)
                          REFERENCES rue (numrue) ;
   ALTER TABLE habite ADD CONSTRAINT habite_serv_pk
                          PRIMARY KEY (citoyen,numero,rue) ;

   ALTER TABLE maladie ADD CONSTRAINT maladie_nummaladie_pk
                           PRIMARY KEY (nummaladie) ;
   ALTER TABLE maladie ADD CONSTRAINT maladie_gravite_ck
                           CHECK (gravite in (0,1,2,3,4,5,6,7,8,9,10)) ;

   ALTER TABLE listemaladie ADD CONSTRAINT listemaladie_cit_moy_deb_pk
                                PRIMARY KEY (citoyen,maladie,debut) ;
   ALTER TABLE listemaladie ADD CONSTRAINT listemaladie_citoyen_fk
                                FOREIGN KEY (citoyen)
                                REFERENCES citoyen (numuniv) ;
   ALTER TABLE listemaladie ADD CONSTRAINT listemaladie_maladie_fk
                                FOREIGN KEY (maladie)
                                REFERENCES maladie(nummaladie) ;

   ALTER TABLE service ADD CONSTRAINT service_numservice_pk
                           PRIMARY KEY (numservice) ;

   ALTER TABLE ministere ADD CONSTRAINT ministere_numministere_pk
                             PRIMARY KEY (numministere) ;

   ALTER TABLE travaillepour ADD CONSTRAINT travaillepour_cit_serv_pk
                                 PRIMARY KEY (citoyen,service,debut) ;
   ALTER TABLE travaillepour ADD CONSTRAINT travaillepour_citoyen_fk
                                 FOREIGN KEY (citoyen)
                                 REFERENCES citoyen(numuniv) ;
   ALTER TABLE travaillepour ADD CONSTRAINT travaillepour_service_fk
                                 FOREIGN KEY (service)
                                 REFERENCES service (numservice) ;

   ALTER TABLE serviceproduit ADD CONSTRAINT serviceproduit_serv_mini_pk
                                  PRIMARY KEY (service,ministere,debut) ;
   ALTER TABLE serviceproduit ADD CONSTRAINT serviceproduit_service_fk
                                  FOREIGN KEY (service)
                                  REFERENCES service (numservice) ;
   ALTER TABLE serviceproduit ADD CONSTRAINT serviceproduit_ministere_fk
                                  FOREIGN KEY (ministere)
                                  REFERENCES ministere (numministere) ;

   ALTER TABLE serviceappartient ADD CONSTRAINT serviceappartient_serv_mini_pk
                                     PRIMARY KEY (service,ministere,debut) ;
   ALTER TABLE serviceappartient ADD CONSTRAINT serviceappartient_service_fk
                                     FOREIGN KEY (service)
                                     REFERENCES service (numservice) ;
   ALTER TABLE serviceappartient ADD CONSTRAINT serviceappartient_ministere_fk
                                     FOREIGN KEY (ministere)
                                     REFERENCES ministere (numministere) ;

   ALTER TABLE servicecontrole ADD CONSTRAINT servicecontrole_serv_mini_pk
                                   PRIMARY KEY (service,ministere,debut) ;
   ALTER TABLE servicecontrole ADD CONSTRAINT servicecontrole_service_fk
                                   FOREIGN KEY (service)
                                   REFERENCES service(numservice) ;
   ALTER TABLE servicecontrole ADD CONSTRAINT servicecontrole_ministere_fk
                                   FOREIGN KEY (ministere)
                                   REFERENCES ministere(numministere) ;

   ALTER TABLE dirige ADD CONSTRAINT dirige_cit_serv_pk
                          PRIMARY KEY (citoyen,ministere,debut);
   ALTER TABLE dirige ADD CONSTRAINT dirige_citoyen_fk
                          FOREIGN KEY (citoyen)
                          REFERENCES citoyen(numuniv);
   ALTER TABLE dirige ADD CONSTRAINT dirige_ministere_fk
                          FOREIGN KEY (ministere)
                          REFERENCES ministere(numministere) ;