Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE ORGANISME(
- organisme_id COUNTER PRIMARY KEY,
- libelle VARCHAR(50)
- );
- CREATE TABLE TELEPHONE(
- telephone_id COUNTER PRIMARY KEY,
- telephone VARCHAR(50),
- organisme_id INT REFERENCES ORGANISME(organisme_id) NOT NULL
- );
- CREATE TABLE CONTACT(
- contact_id COUNTER PRIMARY KEY,
- contact VARCHAR(50),
- organisme_id INT REFERENCES ORGANISME(organisme_id) NOT NULL
- );
- CREATE TABLE ORGANISME_STATUS(
- organisme_sta_id COUNTER PRIMARY KEY,
- status VARCHAR(50),
- organisme_id INT REFERENCES ORGANISME(organisme_id) NOT NULL
- );
- CREATE TABLE MAIL(
- mail_id COUNTER PRIMARY KEY,
- mail VARCHAR(50),
- organisme_id INT REFERENCES ORGANISME(organisme_id) NOT NULL
- );
- CREATE TABLE ADRESSE(
- adresse_id COUNTER PRIMARY KEY,
- rue1 VARCHAR(50),
- rue2 VARCHAR(50),
- lat DOUBLE,
- lng DOUBLE,
- organisme_id INT REFERENCES ORGANISME(organisme_id) NOT NULL
- );
- CREATE TABLE FORMATION_ORGANISME(
- formation_id COUNTER PRIMARY KEY,
- libelle VARCHAR(50),
- capacite INT,
- niv_requis VARCHAR(50),
- modalite_spe_recrutement VARCHAR(50),
- organisme_id INT REFERENCES ORGANISME(organisme_id) NOT NULL
- );
- CREATE TABLE VILLE(
- ville_id COUNTER PRIMARY KEY,
- libelleville VARCHAR(50),
- adresse_id INT REFERENCES ADRESSE(adresse_id) NOT NULL
- );
- CREATE TABLE CODEPOSTAL(
- cp_id COUNTER PRIMARY KEY,
- libellecp INT
- );
- CREATE TABLE CPDEVILLE(
- ville_id INT REFERENCES VILLE(ville_id) NOT NULL,
- cp_id INT REFERENCES CODEPOSTAL(cp_id) NOT NULL,
- PRIMARY KEY(ville_id, cp_id)
- );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement