EXO

[crepin2026]

BEGIN;

CREATE TABLE IF NOT EXISTS public."ANALYSE_LABO"
(
"SELLES" character varying,
"GE" character varying,
"GLYCEMIE" double precision,
"CALCEMIE" integer
);

CREATE TABLE IF NOT EXISTS public."PATIENTS"
(
id_pateint serial,
nom character(50),
prenom character(100),
age integer,
sexe character varying
);

CREATE TABLE IF NOT EXISTS public."PRESCRIPTEUR"
(
id_prescript serial,
nom_prenom character(150)
);

CREATE TABLE IF NOT EXISTS public."CAISSSE"
(
id_analyse serial,
id_patient serial,
PRIMARY KEY (id_patient)
);

CREATE TABLE IF NOT EXISTS public."PRESCRIPTEUR_ANALYSE_LABO"
(
"PRESCRIPTEUR_id_prescript" serial,
"ANALYSE_LABO_GLYCEMIE" double precision
);

ALTER TABLE IF EXISTS public."PATIENTS"
ADD FOREIGN KEY (id_pateint)
REFERENCES public."ANALYSE_LABO" ("SELLES") MATCH SIMPLE
ON UPDATE NO ACTION
ON DELETE NO ACTION
NOT VALID;

ALTER TABLE IF EXISTS public."PRESCRIPTEUR"
ADD FOREIGN KEY (id_prescript)
REFERENCES public."PATIENTS" (id_pateint) MATCH SIMPLE
ON UPDATE NO ACTION
ON DELETE NO ACTION
NOT VALID;

ALTER TABLE IF EXISTS public."CAISSSE"
ADD FOREIGN KEY (id_patient)
REFERENCES public."PATIENTS" (id_pateint) MATCH SIMPLE
ON UPDATE NO ACTION
ON DELETE NO ACTION
NOT VALID;

ALTER TABLE IF EXISTS public."CAISSSE"
ADD FOREIGN KEY (id_analyse)
REFERENCES public."ANALYSE_LABO" ("GLYCEMIE") MATCH SIMPLE
ON UPDATE NO ACTION
ON DELETE NO ACTION
NOT VALID;

ALTER TABLE IF EXISTS public."PRESCRIPTEUR_ANALYSE_LABO"
ADD FOREIGN KEY ("PRESCRIPTEUR_id_prescript")
REFERENCES public."PRESCRIPTEUR" (id_prescript) MATCH SIMPLE
ON UPDATE NO ACTION
ON DELETE NO ACTION
NOT VALID;

ALTER TABLE IF EXISTS public."PRESCRIPTEUR_ANALYSE_LABO"
ADD FOREIGN KEY ("ANALYSE_LABO_GLYCEMIE")
REFERENCES public."ANALYSE_LABO" ("GLYCEMIE") MATCH SIMPLE
ON UPDATE NO ACTION
ON DELETE NO ACTION
NOT VALID;

END;

[anilsahoo20]

@crepin2026
Can you please explain the issue?