CREATE TABLE professeur (
    prof_id integer NOT NULL,
    prof_nom character varying(64) NOT NULL,
    prof_prenom character varying(64) NOT NULL
);

CREATE TABLE matiere (
    mat_id integer NOT NULL,
    mat_nom character varying(64) NOT NULL
);

CREATE TABLE j_mat_prof (
    jmp_id integer NOT NULL,
    jmp_mat_k bigint NOT NULL,
    jmp_prof_k bigint NOT NULL
);

CREATE TABLE j_cls_jmp (
    jcm_id integer NOT NULL,
    jcm_cls_k bigint NOT NULL,
    jcm_jmp_k bigint NOT NULL
);

CREATE TABLE eleve (
    elv_id integer NOT NULL,
    elv_nom character varying(64) NOT NULL,
    elv_prenom character varying(64) NOT NULL,
    elv_cls_k bigint NOT NULL
);

CREATE TABLE classe (
    cls_id integer NOT NULL,
    cls_nom character varying(64) NOT NULL
);

<!--****************************************************************************************-->

ALTER TABLE ONLY classe
    ADD CONSTRAINT "clé primaire" PRIMARY KEY (cls_id);
--
ALTER TABLE ONLY eleve
    ADD CONSTRAINT eleve_pkey PRIMARY KEY (elv_id);
--
ALTER TABLE ONLY j_cls_jmp
    ADD CONSTRAINT j_cls_jmp_pkey PRIMARY KEY (jcm_id);
--
ALTER TABLE ONLY j_mat_prof
    ADD CONSTRAINT j_mat_prof_jmp_mat_k_key UNIQUE (jmp_mat_k, jmp_prof_k);
--
ALTER TABLE ONLY j_mat_prof
    ADD CONSTRAINT j_mat_prof_pkey PRIMARY KEY (jmp_id);
--
ALTER TABLE ONLY matiere
    ADD CONSTRAINT matiere_pkey PRIMARY KEY (mat_id);
--
ALTER TABLE ONLY professeur
    ADD CONSTRAINT professeur_pkey PRIMARY KEY (prof_id);
--
ALTER TABLE ONLY eleve
    ADD CONSTRAINT eleve_elv_cls_k_fkey FOREIGN KEY (elv_cls_k) REFERENCES classe(cls_id);
--
ALTER TABLE ONLY j_cls_jmp
    ADD CONSTRAINT j_cls_jmp_jcm_cls_k_fkey FOREIGN KEY (jcm_cls_k) REFERENCES classe(cls_id);
--
ALTER TABLE ONLY j_cls_jmp
    ADD CONSTRAINT j_cls_jmp_jcm_jmp_k_fkey FOREIGN KEY (jcm_jmp_k) REFERENCES j_mat_prof(jmp_id);
--
ALTER TABLE ONLY j_mat_prof
    ADD CONSTRAINT j_mat_prof_jmp_mat_k_fkey FOREIGN KEY (jmp_mat_k) REFERENCES matiere(mat_id);
--
ALTER TABLE ONLY j_mat_prof
    ADD CONSTRAINT j_mat_prof_jmp_prof_k_fkey FOREIGN KEY (jmp_prof_k) REFERENCES professeur(prof_id);