AmrLJsCT

1;
2CREATE USER IF NOT EXISTS SA SALT '400e22ac457b75d3' HASH 'ca9ad593b9ba6cc18a72b918f88efb3d31602935f25d74f79c788d0eb5da09c3' ADMIN;
3DROP TABLE IF EXISTS PUBLIC.COMPOSITION CASCADE;
4DROP TABLE IF EXISTS PUBLIC.COMPOSITION_COMPOSITION_VALEUR_LIST CASCADE;
5DROP TABLE IF EXISTS PUBLIC.COMPOSITION_VALEUR CASCADE;
6DROP TABLE IF EXISTS PUBLIC.CRITERE_VALEUR CASCADE;
7DROP TABLE IF EXISTS PUBLIC.CRITERE_VALEUR_DPT CASCADE;
8DROP TABLE IF EXISTS PUBLIC.DEPARTEMENT CASCADE;
9DROP TABLE IF EXISTS PUBLIC.JT_COMPO_VALEUR_CRITERE_VALEUR CASCADE;
10DROP TABLE IF EXISTS PUBLIC.JT_COMPOSITION_CRITERE CASCADE;
11DROP TABLE IF EXISTS PUBLIC.OPERATION CASCADE;
12DROP TABLE IF EXISTS PUBLIC.OPERATION_PERIODE CASCADE;
13DROP TABLE IF EXISTS PUBLIC.OPERATION_PERIODE_CRITERE CASCADE;
14DROP TABLE IF EXISTS PUBLIC.OPERATION_PERIODE_CRITERE_VAL CASCADE;
15DROP TABLE IF EXISTS PUBLIC.PERIODE_ELIGIBILITE CASCADE;
16DROP TABLE IF EXISTS PUBLIC.DOCUMENT CASCADE;
17DROP VIEW IF EXISTS PUBLIC.V_OPERATION_PERIODE CASCADE;
18DROP TABLE IF EXISTS PUBLIC.CRITERE CASCADE;
19DROP SEQUENCE IF EXISTS PUBLIC.SEQ_COMPOSITION;
20CREATE SEQUENCE PUBLIC.SEQ_COMPOSITION START WITH 10000;
21DROP SEQUENCE IF EXISTS PUBLIC.SEQ_COMPOSITION_VALEUR;
22CREATE SEQUENCE PUBLIC.SEQ_COMPOSITION_VALEUR START WITH 10000;
23DROP SEQUENCE IF EXISTS PUBLIC.SEQ_PERIODE_ELIGIBILITE;
24CREATE SEQUENCE PUBLIC.SEQ_PERIODE_ELIGIBILITE START WITH 10004;
25DROP SEQUENCE IF EXISTS PUBLIC.SEQ_OPERATION;
26CREATE SEQUENCE PUBLIC.SEQ_OPERATION START WITH 10005;
27DROP SEQUENCE IF EXISTS PUBLIC.SEQ_DOCUMENT;
28CREATE SEQUENCE PUBLIC.SEQ_DOCUMENT START WITH 10000;
29DROP SEQUENCE IF EXISTS PUBLIC.SEQ_CRITERE;
30CREATE SEQUENCE PUBLIC.SEQ_CRITERE START WITH 10008;
31DROP SEQUENCE IF EXISTS PUBLIC.SEQ_CRITERE_VALEUR;
32CREATE SEQUENCE PUBLIC.SEQ_CRITERE_VALEUR START WITH 10025;
33CREATE MEMORY TABLE PUBLIC.COMPOSITION(
34    ID_COMPOSITION BIGINT NOT NULL,
35    NOM_COMPOSITION VARCHAR(255),
36    NOM_VARIABLE VARCHAR(255),
37    OPERATION_FK BIGINT
38);
39ALTER TABLE PUBLIC.COMPOSITION ADD CONSTRAINT PUBLIC.CONSTRAINT_4 PRIMARY KEY(ID_COMPOSITION);
40-- 3 +/- SELECT COUNT(*) FROM PUBLIC.COMPOSITION;
41CREATE MEMORY TABLE PUBLIC.COMPOSITION_COMPOSITION_VALEUR_LIST(
42    COMPOSITION_ID_COMPOSITION BIGINT NOT NULL,
43    COMPOSITION_VALEUR_LIST_ID_COMPOSITION_VALEUR BIGINT NOT NULL
44);
45-- 0 +/- SELECT COUNT(*) FROM PUBLIC.COMPOSITION_COMPOSITION_VALEUR_LIST;
46CREATE MEMORY TABLE PUBLIC.COMPOSITION_VALEUR(
47    ID_COMPOSITION_VALEUR BIGINT NOT NULL,
48    VALEUR DOUBLE,
49    COMPOSITION_FK BIGINT
50);
51ALTER TABLE PUBLIC.COMPOSITION_VALEUR ADD CONSTRAINT PUBLIC.CONSTRAINT_A PRIMARY KEY(ID_COMPOSITION_VALEUR);
52-- 14 +/- SELECT COUNT(*) FROM PUBLIC.COMPOSITION_VALEUR;
53CREATE MEMORY TABLE PUBLIC.CRITERE_VALEUR(
54    ID_CRITERE_VALEUR BIGINT NOT NULL,
55    AUXILIAIRE_ID VARCHAR(255),
56    COMPLEMENT VARCHAR(255),
57    MAX DOUBLE,
58    MAX_EQUAL DOUBLE,
59    MIN DOUBLE,
60    MIN_EQUAL DOUBLE,
61    REFERENCE_VALEUR_EMMY BIGINT,
62    VALEUR VARCHAR(255),
63    ID_CRITERE_FK BIGINT
64);
65ALTER TABLE PUBLIC.CRITERE_VALEUR ADD CONSTRAINT PUBLIC.CONSTRAINT_1 PRIMARY KEY(ID_CRITERE_VALEUR);
66-- 1239 +/- SELECT COUNT(*) FROM PUBLIC.CRITERE_VALEUR;
67CREATE MEMORY TABLE PUBLIC.CRITERE_VALEUR_DPT(
68    CRITERE_VALEUR_DPT VARCHAR(255) NOT NULL,
69    DEPARTEMENT VARCHAR(255) NOT NULL,
70    NOM_USAGE_CRITERE VARCHAR(255) NOT NULL
71);
72ALTER TABLE PUBLIC.CRITERE_VALEUR_DPT ADD CONSTRAINT PUBLIC.CONSTRAINT_16 PRIMARY KEY(CRITERE_VALEUR_DPT, DEPARTEMENT, NOM_USAGE_CRITERE);
73-- 311 +/- SELECT COUNT(*) FROM PUBLIC.CRITERE_VALEUR_DPT;
74CREATE MEMORY TABLE PUBLIC.DEPARTEMENT(
75    DEPARTEMENT VARCHAR(255) NOT NULL,
76    CODE_POSTAL VARCHAR(255) NOT NULL,
77    NOM VARCHAR(255),
78    OUTRE_MER BOOLEAN,
79    ZNI BOOLEAN
80);
81ALTER TABLE PUBLIC.DEPARTEMENT ADD CONSTRAINT PUBLIC.CONSTRAINT_9 PRIMARY KEY(DEPARTEMENT, CODE_POSTAL);
82-- 120 +/- SELECT COUNT(*) FROM PUBLIC.DEPARTEMENT;
83CREATE MEMORY TABLE PUBLIC.JT_COMPO_VALEUR_CRITERE_VALEUR(
84    COMPOSITION_VALEUR_FK BIGINT NOT NULL,
85    CRITERE_VALEUR_FK BIGINT NOT NULL
86);
87ALTER TABLE PUBLIC.JT_COMPO_VALEUR_CRITERE_VALEUR ADD CONSTRAINT PUBLIC.CONSTRAINT_97 PRIMARY KEY(COMPOSITION_VALEUR_FK, CRITERE_VALEUR_FK);
88-- 20 +/- SELECT COUNT(*) FROM PUBLIC.JT_COMPO_VALEUR_CRITERE_VALEUR;
89CREATE MEMORY TABLE PUBLIC.JT_COMPOSITION_CRITERE(
90    COMPOSITION_FK BIGINT NOT NULL,
91    CRITERE_FK BIGINT NOT NULL,
92    OPERATION_FK BIGINT NOT NULL,
93    PERIODE_ELIGIBILITE_FK BIGINT NOT NULL
94);
95-- 4 +/- SELECT COUNT(*) FROM PUBLIC.JT_COMPOSITION_CRITERE;
96CREATE MEMORY TABLE PUBLIC.OPERATION(
97    ID_OPERATION BIGINT NOT NULL,
98    CREATED_BY VARCHAR(50) NOT NULL,
99    CREATED_DATE TIMESTAMP NOT NULL,
100    LAST_MODIFIED_BY VARCHAR(50),
101    LAST_MODIFIED_DATE TIMESTAMP,
102    DUREE_VIE_CONVENTIONNELLE INTEGER,
103    FORMULE_CALCUL VARCHAR(255),
104    FORMULE_DOCUMENT VARCHAR(255),
105    FORMULE_ELIGIBILITE VARCHAR(255),
106    FOS_ID VARCHAR(255),
107    NOM_OPERATION VARCHAR(255),
108    LIBELLE_OPERATION VARCHAR(255),
109    TYPE_OPERATION VARCHAR(255),
110    ZONE_OPERATION VARCHAR(255),
111    ID_OPERATION_FK BIGINT
112);
113ALTER TABLE PUBLIC.OPERATION ADD CONSTRAINT PUBLIC.CONSTRAINT_93 PRIMARY KEY(ID_OPERATION);
114-- 174 +/- SELECT COUNT(*) FROM PUBLIC.OPERATION;
115CREATE MEMORY TABLE PUBLIC.OPERATION_PERIODE(
116    OPERATION_FK BIGINT NOT NULL,
117    PERIODE_ELIGIBILITE_FK BIGINT NOT NULL,
118    ID_FICHIER_IMPORT BIGINT,
119    STATUT VARCHAR(255),
120    PRESTATION_FK varchar(255),
121);
122ALTER TABLE PUBLIC.OPERATION_PERIODE ADD CONSTRAINT PUBLIC.CONSTRAINT_9C PRIMARY KEY(OPERATION_FK, PERIODE_ELIGIBILITE_FK);
123-- 190 +/- SELECT COUNT(*) FROM PUBLIC.OPERATION_PERIODE;
124CREATE MEMORY TABLE PUBLIC.OPERATION_PERIODE_CRITERE(
125    CRITERE_FK BIGINT NOT NULL,
126    OPERATION_FK BIGINT NOT NULL,
127    PERIODE_ELIGIBILITE_FK BIGINT NOT NULL,
128    CC BOOLEAN,
129    CE BOOLEAN,
130    NOM_VARIABLE VARCHAR(255)
131);
132ALTER TABLE PUBLIC.OPERATION_PERIODE_CRITERE ADD CONSTRAINT PUBLIC.CONSTRAINT_B PRIMARY KEY(CRITERE_FK, OPERATION_FK, PERIODE_ELIGIBILITE_FK);
133-- 834 +/- SELECT COUNT(*) FROM PUBLIC.OPERATION_PERIODE_CRITERE;
134CREATE MEMORY TABLE PUBLIC.OPERATION_PERIODE_CRITERE_VAL(
135    CRITERE_VALEUR_FK BIGINT NOT NULL,
136    OPERATION_FK BIGINT NOT NULL,
137    PERIODE_ELIGIBILITE_FK BIGINT NOT NULL,
138    ELIGIBLE BOOLEAN
139);
140ALTER TABLE PUBLIC.OPERATION_PERIODE_CRITERE_VAL ADD CONSTRAINT PUBLIC.CONSTRAINT_71 PRIMARY KEY(CRITERE_VALEUR_FK, OPERATION_FK, PERIODE_ELIGIBILITE_FK);
141-- 1028 +/- SELECT COUNT(*) FROM PUBLIC.OPERATION_PERIODE_CRITERE_VAL;
142CREATE MEMORY TABLE PUBLIC.PERIODE_ELIGIBILITE(
143    ID_PERIODE_ELIGIBILITE BIGINT NOT NULL,
144    CREATED_BY VARCHAR(50) NOT NULL,
145    CREATED_DATE TIMESTAMP NOT NULL,
146    LAST_MODIFIED_BY VARCHAR(50),
147    LAST_MODIFIED_DATE TIMESTAMP,
148    DATE_DEBUT DATE,
149    DATE_FIN DATE,
150    NUM_ARRETE VARCHAR(255),
151    ID_OPERATION_FK BIGINT
152);
153ALTER TABLE PUBLIC.PERIODE_ELIGIBILITE ADD CONSTRAINT PUBLIC.CONSTRAINT_90 PRIMARY KEY(ID_PERIODE_ELIGIBILITE);
154-- 68 +/- SELECT COUNT(*) FROM PUBLIC.PERIODE_ELIGIBILITE;
155CREATE MEMORY TABLE PUBLIC.DOCUMENT(
156    ID_DOCUMENT BIGINT NOT NULL,
157    LIBELLE VARCHAR(255),
158    MENTION_LIST VARCHAR(255),
159    ID_OPERATION_FK BIGINT NOT NULL,
160    CREATED_BY VARCHAR(50) NOT NULL,
161    CREATED_DATE TIMESTAMP NOT NULL,
162    LAST_MODIFIED_BY VARCHAR(50),
163    LAST_MODIFIED_DATE TIMESTAMP
164);
165ALTER TABLE PUBLIC.DOCUMENT ADD CONSTRAINT PUBLIC.CONSTRAINT_62 PRIMARY KEY(ID_DOCUMENT);
166-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DOCUMENT;
167CREATE FORCE VIEW PUBLIC.V_OPERATION_PERIODE(ID_OPERATION, CREATED_BY, CREATED_DATE, LAST_MODIFIED_BY, LAST_MODIFIED_DATE, DUREE_VIE_CONVENTIONNELLE, FORMULE_CALCUL, FORMULE_DOCUMENT, FORMULE_ELIGIBILITE, FOS_ID, NOM_OPERATION, LIBELLE_OPERATION, TYPE_OPERATION, ZONE_OPERATION, ID_OPERATION_FK, ID_PERIODE_ELIGIBILITE, DATE_DEBUT, DATE_FIN, NUM_ARRETE, STATUT) AS
168SELECT
169    OPERATION.ID_OPERATION,
170    OPERATION.CREATED_BY,
171    OPERATION.CREATED_DATE,
172    OPERATION.LAST_MODIFIED_BY,
173    OPERATION.LAST_MODIFIED_DATE,
174    OPERATION.DUREE_VIE_CONVENTIONNELLE,
175    OPERATION.FORMULE_CALCUL,
176    OPERATION.FORMULE_DOCUMENT,
177    OPERATION.FORMULE_ELIGIBILITE,
178    OPERATION.FOS_ID,
179    OPERATION.NOM_OPERATION,
180    OPERATION.LIBELLE_OPERATION,
181    OPERATION.TYPE_OPERATION,
182    OPERATION.ZONE_OPERATION,
183    OPERATION.ID_OPERATION_FK,
184    PERIODE.ID_PERIODE_ELIGIBILITE,
185    PERIODE.DATE_DEBUT,
186    PERIODE.DATE_FIN,
187    PERIODE.NUM_ARRETE,
188    OPERATION_PERIODE.STATUT
189FROM PUBLIC.OPERATION OPERATION
190LEFT OUTER JOIN PUBLIC.OPERATION_PERIODE OPERATION_PERIODE
191    ON OPERATION_PERIODE.OPERATION_FK = OPERATION.ID_OPERATION
192LEFT OUTER JOIN PUBLIC.PERIODE_ELIGIBILITE PERIODE
193    ON OPERATION_PERIODE.PERIODE_ELIGIBILITE_FK = PERIODE.ID_PERIODE_ELIGIBILITE;
194CREATE MEMORY TABLE PUBLIC.CRITERE(
195    ID_CRITERE BIGINT NOT NULL SELECTIVITY 100,
196    CREATED_BY VARCHAR(50) NOT NULL SELECTIVITY 1,
197    CREATED_DATE TIMESTAMP NOT NULL SELECTIVITY 100,
198    LAST_MODIFIED_BY VARCHAR(50) SELECTIVITY 1,
199    LAST_MODIFIED_DATE TIMESTAMP SELECTIVITY 100,
200    ID_FICHIER_IMPORT BIGINT SELECTIVITY 100,
201    LIBELLE VARCHAR(1024) SELECTIVITY 33,
202    PRECISION BIGINT SELECTIVITY 1,
203    REFERENCE_CRITERE_EMMY VARCHAR(255) SELECTIVITY 1,
204    REFERENCE_TABLEAU_EMMY BIGINT SELECTIVITY 1,
205    SYMBOLE VARCHAR(255) SELECTIVITY 3,
206    TYPE_CRITERE VARCHAR(255) SELECTIVITY 1,
207    UNITE VARCHAR(255) SELECTIVITY 1,
208    QUALIFIANT BOOLEAN SELECTIVITY 1
209);
210ALTER TABLE PUBLIC.CRITERE ADD CONSTRAINT PUBLIC.CONSTRAINT_6 PRIMARY KEY(ID_CRITERE);
211-- 709 +/- SELECT COUNT(*) FROM PUBLIC.CRITERE;
212ALTER TABLE PUBLIC.COMPOSITION_COMPOSITION_VALEUR_LIST ADD CONSTRAINT PUBLIC.UK_C6F5UVYNPWM1V2Y122NE0W6RI UNIQUE(COMPOSITION_VALEUR_LIST_ID_COMPOSITION_VALEUR);
213ALTER TABLE PUBLIC.COMPOSITION_VALEUR ADD CONSTRAINT PUBLIC.FK2K8RE8OVKHQ1QFPB5B8TKXF9P FOREIGN KEY(COMPOSITION_FK) REFERENCES PUBLIC.COMPOSITION(ID_COMPOSITION) NOCHECK;
214ALTER TABLE PUBLIC.PERIODE_ELIGIBILITE ADD CONSTRAINT PUBLIC.FKPO4W6FHSUCNNHRNI8WX6BTETP FOREIGN KEY(ID_OPERATION_FK) REFERENCES PUBLIC.OPERATION(ID_OPERATION) NOCHECK;
215ALTER TABLE PUBLIC.COMPOSITION ADD CONSTRAINT PUBLIC.FKEY01Q1W6DOPWPBWS7N1T1AL4I FOREIGN KEY(OPERATION_FK) REFERENCES PUBLIC.OPERATION(ID_OPERATION) NOCHECK;
216ALTER TABLE PUBLIC.OPERATION ADD CONSTRAINT PUBLIC.FKIVNH7D39JI1Y4LVUVIJ7K8EEF FOREIGN KEY(ID_OPERATION_FK) REFERENCES PUBLIC.OPERATION(ID_OPERATION) NOCHECK;
217ALTER TABLE PUBLIC.OPERATION_PERIODE_CRITERE ADD CONSTRAINT PUBLIC.FK9IYBNUF8MY1COOQNBEA6K419M FOREIGN KEY(PERIODE_ELIGIBILITE_FK) REFERENCES PUBLIC.PERIODE_ELIGIBILITE(ID_PERIODE_ELIGIBILITE) NOCHECK;
218ALTER TABLE PUBLIC.JT_COMPO_VALEUR_CRITERE_VALEUR ADD CONSTRAINT PUBLIC.FKLCBG508C6OJ3HCW26O9AIPLYT FOREIGN KEY(CRITERE_VALEUR_FK) REFERENCES PUBLIC.CRITERE_VALEUR(ID_CRITERE_VALEUR) NOCHECK;
219ALTER TABLE PUBLIC.COMPOSITION_COMPOSITION_VALEUR_LIST ADD CONSTRAINT PUBLIC.FKAVMF7PFYIJ7DUQNRBJHV7GBBO FOREIGN KEY(COMPOSITION_VALEUR_LIST_ID_COMPOSITION_VALEUR) REFERENCES PUBLIC.COMPOSITION_VALEUR(ID_COMPOSITION_VALEUR) NOCHECK;
220ALTER TABLE PUBLIC.OPERATION_PERIODE_CRITERE_VAL ADD CONSTRAINT PUBLIC.FKOQM4M3K1D4URTH8RQF9W9KISW FOREIGN KEY(PERIODE_ELIGIBILITE_FK) REFERENCES PUBLIC.PERIODE_ELIGIBILITE(ID_PERIODE_ELIGIBILITE) NOCHECK;
221ALTER TABLE PUBLIC.COMPOSITION_COMPOSITION_VALEUR_LIST ADD CONSTRAINT PUBLIC.FKCGT6OQ4DF4V6AW8J0QB2EGUVS FOREIGN KEY(COMPOSITION_ID_COMPOSITION) REFERENCES PUBLIC.COMPOSITION(ID_COMPOSITION) NOCHECK;
222ALTER TABLE PUBLIC.OPERATION_PERIODE_CRITERE ADD CONSTRAINT PUBLIC.FK2S7G7F0A5SPSPOWQFX1SAL2AJ FOREIGN KEY(OPERATION_FK) REFERENCES PUBLIC.OPERATION(ID_OPERATION) NOCHECK;
223ALTER TABLE PUBLIC.JT_COMPO_VALEUR_CRITERE_VALEUR ADD CONSTRAINT PUBLIC.FKMBPK0PUCAP06D63BQL38VC48C FOREIGN KEY(COMPOSITION_VALEUR_FK) REFERENCES PUBLIC.COMPOSITION_VALEUR(ID_COMPOSITION_VALEUR) NOCHECK;
224ALTER TABLE PUBLIC.OPERATION_PERIODE_CRITERE_VAL ADD CONSTRAINT PUBLIC.FKHRFKPMWM1C8GEFX17QJB3GUA5 FOREIGN KEY(CRITERE_VALEUR_FK) REFERENCES PUBLIC.CRITERE_VALEUR(ID_CRITERE_VALEUR) NOCHECK;
225ALTER TABLE PUBLIC.OPERATION_PERIODE_CRITERE_VAL ADD CONSTRAINT PUBLIC.FK5E237G4JCE876NNTTFSF0YC0L FOREIGN KEY(OPERATION_FK) REFERENCES PUBLIC.OPERATION(ID_OPERATION) NOCHECK;
226ALTER TABLE PUBLIC.CRITERE_VALEUR ADD CONSTRAINT PUBLIC.FKMAEP92P8ME5NKI2UAEPB2M2U6 FOREIGN KEY(ID_CRITERE_FK) REFERENCES PUBLIC.CRITERE(ID_CRITERE) NOCHECK;
227ALTER TABLE PUBLIC.JT_COMPOSITION_CRITERE ADD CONSTRAINT PUBLIC.FKHDC458CIWCAE4GMQ9L4A6HSGA FOREIGN KEY(CRITERE_FK, OPERATION_FK, PERIODE_ELIGIBILITE_FK) REFERENCES PUBLIC.OPERATION_PERIODE_CRITERE(CRITERE_FK, OPERATION_FK, PERIODE_ELIGIBILITE_FK) NOCHECK;
228ALTER TABLE PUBLIC.DOCUMENT ADD CONSTRAINT PUBLIC.FKJ051JWB78Q2GOR73DPPPRVLJU FOREIGN KEY(ID_OPERATION_FK) REFERENCES PUBLIC.OPERATION(ID_OPERATION) NOCHECK;
229ALTER TABLE PUBLIC.JT_COMPOSITION_CRITERE ADD CONSTRAINT PUBLIC.FKRQXTDVFQ272L68H2U75M04BGT FOREIGN KEY(COMPOSITION_FK) REFERENCES PUBLIC.COMPOSITION(ID_COMPOSITION) NOCHECK;
230ALTER TABLE PUBLIC.OPERATION_PERIODE ADD CONSTRAINT PUBLIC.FK3GFX08DS81P0I0L3336BCQ3KQ FOREIGN KEY(OPERATION_FK) REFERENCES PUBLIC.OPERATION(ID_OPERATION) NOCHECK;
231ALTER TABLE PUBLIC.OPERATION_PERIODE ADD CONSTRAINT PUBLIC.FKPPAQQ3B98SS8630MMAURMG92P FOREIGN KEY(PERIODE_ELIGIBILITE_FK) REFERENCES PUBLIC.PERIODE_ELIGIBILITE(ID_PERIODE_ELIGIBILITE) NOCHECK;
232ALTER TABLE PUBLIC.OPERATION_PERIODE_CRITERE ADD CONSTRAINT PUBLIC.FKOT6YDR25FG79RD1ONC3V5CPM5 FOREIGN KEY(CRITERE_FK) REFERENCES PUBLIC.CRITERE(ID_CRITERE) NOCHECK;
233
234-- COMMERCIAL
235
236DROP TABLE IF EXISTS PUBLIC.com_critere CASCADE;
237DROP TABLE IF EXISTS PUBLIC.com_critere_valeur CASCADE;
238DROP TABLE IF EXISTS PUBLIC.com_prestation CASCADE;
239DROP TABLE IF EXISTS PUBLIC.com_prestation_critere CASCADE;
240
241create table com_critere (id_critere_commercial varchar(255) not null, created_by varchar(50) not null, created_date timestamp not null, last_modified_by varchar(50), last_modified_date timestamp, icon clob, libelle varchar(255), type_critere varchar(255), primary key (id_critere_commercial));
242create table com_critere_valeur (id_critere_val varchar(255) not null, created_by varchar(50) not null, created_date timestamp not null, last_modified_by varchar(50), last_modified_date timestamp, icon blob, libelle varchar(255), id_critere_fk varchar(255), primary key (id_critere_val));
243create table com_prestation (id_prestation varchar(255) not null, created_by varchar(50) not null, created_date timestamp not null, last_modified_by varchar(50), last_modified_date timestamp, affichee boolean, fos_id varchar(255), icon blob, libelle varchar(255), primary key (id_prestation));
244create table com_prestation_critere (id_critere_fk varchar(255) not null, id_critere_val_fk varchar(255) not null, id_prestation_fk varchar(255) not null, primary key (id_critere_fk, id_critere_val_fk, id_prestation_fk));
245
246alter table com_critere_valeur add constraint FK2ad4j5yjyfe900m7ioevqxn7j foreign key (id_critere_fk) references com_critere;
247alter table com_prestation_critere add constraint FKd01dtrcc6ptxjffqrc4b7raw2 foreign key (id_critere_fk) references com_critere;
248alter table com_prestation_critere add constraint FK964yhh1gathcfrg5anqtc5hig foreign key (id_critere_val_fk) references com_critere_valeur;
249alter table com_prestation_critere add constraint FKjjj3yef1a7rl5u1gdrnnattrq foreign key (id_prestation_fk) references com_prestation;
250
251ALTER TABLE PUBLIC.OPERATION_PERIODE ADD CONSTRAINT FKjjj3yef1a7rl5u1gdrnnatdsq FOREIGN KEY(PRESTATION_FK) REFERENCES com_prestation;