/[openfoncier]/trunk/data/pgsql/init_metier.sql
ViewVC logotype

Annotation of /trunk/data/pgsql/init_metier.sql

Parent Directory Parent Directory | Revision Log Revision Log

Revision 2052 - (hide annotations)
Fri Jun 28 18:14:01 2013 UTC (11 years, 7 months ago) by vpihour
File size: 117625 byte(s) 
Fichier de préparation de la release 3.6.0-a1
1 fmichon 1801 --------------------------------------------------------------------------------
2     -- Instructions de base de l'applicatif
3     --
4     -- Génération de ce fichier :
5 fmichon 1844 -- pg_dump -s -O -n openads -T openads.om_* openads > /tmp/init_metier.sql
6 fmichon 1801 -- REMPLACER : START WITH * by START WITH 1
7     -- SUPPRIMER : CONSTRAINT *geom*
8 fmichon 1844 -- REMPLACER : public.geometry by text sur les champs geom
9 fmichon 1801 --
10     -- @package openfoncier
11     -- @version SVN : $Id$
12     --------------------------------------------------------------------------------
13    
14     --
15     -- PostgreSQL database dump
16     --
17    
18 vpihour 2052 CREATE SCHEMA openads;
19    
20    
21     SET search_path = openads, pg_catalog;
22    
23 fmichon 1801 --
24 vpihour 2052 -- Name: fn_fixsequences(); Type: FUNCTION; Schema: openads; Owner: -
25     --
26    
27     CREATE FUNCTION fn_fixsequences() RETURNS integer
28     LANGUAGE plpgsql
29     AS $$
30     DECLARE
31     themax BIGINT;
32     mytables RECORD;
33     num integer;
34     BEGIN
35     num := 0;
36     FOR mytables IN
37     SELECT S.relname as seq, C.attname as attname, T.relname as relname
38     FROM pg_class AS S, pg_depend AS D, pg_class AS T, pg_attribute AS C
39     WHERE S.relkind = 'S'
40     AND S.oid = D.objid
41     AND D.refobjid = T.oid
42     AND D.refobjid = C.attrelid
43     AND D.refobjsubid = C.attnum
44     LOOP
45     EXECUTE 'SELECT MAX('||mytables.attname||') FROM '||mytables.relname||';' INTO themax;
46     IF (themax is null OR themax < 0) THEN
47     themax := 0;
48     END IF;
49     themax := themax +1;
50     EXECUTE 'ALTER SEQUENCE ' || mytables.seq || ' RESTART WITH '||themax;
51     num := num + 1;
52     END LOOP;
53    
54     RETURN num;
55    
56     END;
57     $$;
58    
59    
60     SET default_tablespace = '';
61    
62     SET default_with_oids = false;
63    
64     --
65 fmichon 1801 -- Name: action; Type: TABLE; Schema: openads; Owner: -; Tablespace:
66     --
67    
68     CREATE TABLE action (
69     action character varying(20) NOT NULL,
70     libelle character varying(60) NOT NULL,
71     regle_etat character varying(60),
72     regle_delai character varying(60),
73     regle_accord_tacite character varying(60),
74     regle_avis character varying(60),
75     regle_date_limite character varying(60),
76     regle_date_notification_delai character varying(60),
77     regle_date_complet character varying(60),
78     regle_date_validite character varying(60),
79     regle_date_decision character varying(60),
80     regle_date_chantier character varying(60),
81     regle_date_achevement character varying(60),
82     regle_date_conformite character varying(60),
83     regle_date_rejet character varying(60),
84     regle_date_dernier_depot character varying(60),
85     regle_date_limite_incompletude character varying(60),
86     regle_delai_incompletude character varying(60)
87     );
88    
89    
90     --
91     -- Name: affectation_automatique; Type: TABLE; Schema: openads; Owner: -; Tablespace:
92     --
93    
94     CREATE TABLE affectation_automatique (
95     affectation_automatique integer NOT NULL,
96     arrondissement integer,
97     quartier integer,
98     section character varying(2),
99     instructeur integer NOT NULL,
100     dossier_autorisation_type_detaille integer
101     );
102    
103    
104     --
105     -- Name: affectation_automatique_seq; Type: SEQUENCE; Schema: openads; Owner: -
106     --
107    
108     CREATE SEQUENCE affectation_automatique_seq
109     START WITH 1
110     INCREMENT BY 1
111     NO MINVALUE
112     NO MAXVALUE
113     CACHE 1;
114    
115    
116     --
117     -- Name: affectation_automatique_seq; Type: SEQUENCE OWNED BY; Schema: openads; Owner: -
118     --
119    
120     ALTER SEQUENCE affectation_automatique_seq OWNED BY affectation_automatique.affectation_automatique;
121    
122    
123     --
124     -- Name: architecte; Type: TABLE; Schema: openads; Owner: -; Tablespace:
125     --
126    
127     CREATE TABLE architecte (
128     architecte integer NOT NULL,
129     nom character varying(40) NOT NULL,
130     prenom character varying(40) DEFAULT ''::character varying NOT NULL,
131     adresse1 character varying(40) DEFAULT ''::character varying NOT NULL,
132     adresse2 character varying(40) DEFAULT ''::character varying NOT NULL,
133     cp character varying(5) DEFAULT ''::character varying NOT NULL,
134     ville character varying(40) DEFAULT ''::character varying NOT NULL,
135     pays character varying(40) DEFAULT ''::character varying NOT NULL,
136     inscription character varying(20) DEFAULT ''::character varying NOT NULL,
137     telephone character varying(14) DEFAULT ''::character varying NOT NULL,
138     fax character varying(14) DEFAULT ''::character varying NOT NULL,
139     email character varying(40) DEFAULT ''::character varying NOT NULL,
140     note text
141     );
142    
143    
144     --
145     -- Name: architecte_seq; Type: SEQUENCE; Schema: openads; Owner: -
146     --
147    
148     CREATE SEQUENCE architecte_seq
149     START WITH 1
150     INCREMENT BY 1
151     NO MINVALUE
152     NO MAXVALUE
153     CACHE 1;
154    
155    
156     --
157     -- Name: architecte_seq; Type: SEQUENCE OWNED BY; Schema: openads; Owner: -
158     --
159    
160     ALTER SEQUENCE architecte_seq OWNED BY architecte.architecte;
161    
162    
163     --
164     -- Name: arrondissement; Type: TABLE; Schema: openads; Owner: -; Tablespace:
165     --
166    
167     CREATE TABLE arrondissement (
168     arrondissement integer NOT NULL,
169     libelle character varying(3) NOT NULL,
170     code_postal character varying(5) NOT NULL
171     );
172    
173    
174     --
175     -- Name: arrondissement_seq; Type: SEQUENCE; Schema: openads; Owner: -
176     --
177    
178     CREATE SEQUENCE arrondissement_seq
179     START WITH 1
180     INCREMENT BY 1
181     NO MINVALUE
182     NO MAXVALUE
183     CACHE 1;
184    
185    
186     --
187     -- Name: arrondissement_seq; Type: SEQUENCE OWNED BY; Schema: openads; Owner: -
188     --
189    
190     ALTER SEQUENCE arrondissement_seq OWNED BY arrondissement.arrondissement;
191    
192    
193     --
194     -- Name: autorite_competente; Type: TABLE; Schema: openads; Owner: -; Tablespace:
195     --
196    
197     CREATE TABLE autorite_competente (
198     autorite_competente integer NOT NULL,
199     code character varying(20),
200     libelle character varying(100),
201     description text
202     );
203    
204    
205     --
206     -- Name: autorite_competente_seq; Type: SEQUENCE; Schema: openads; Owner: -
207     --
208    
209     CREATE SEQUENCE autorite_competente_seq
210     START WITH 1
211     INCREMENT BY 1
212     NO MINVALUE
213     NO MAXVALUE
214     CACHE 1;
215    
216    
217     --
218     -- Name: autorite_competente_seq; Type: SEQUENCE OWNED BY; Schema: openads; Owner: -
219     --
220    
221     ALTER SEQUENCE autorite_competente_seq OWNED BY autorite_competente.autorite_competente;
222    
223    
224     --
225     -- Name: avis_consultation; Type: TABLE; Schema: openads; Owner: -; Tablespace:
226     --
227    
228     CREATE TABLE avis_consultation (
229     libelle character varying(30) NOT NULL,
230     abrege character varying(10),
231     om_validite_debut date,
232     om_validite_fin date,
233     avis_consultation integer NOT NULL
234     );
235    
236    
237     --
238     -- Name: avis_consultation_seq; Type: SEQUENCE; Schema: openads; Owner: -
239     --
240    
241     CREATE SEQUENCE avis_consultation_seq
242     START WITH 1
243     INCREMENT BY 1
244     NO MINVALUE
245     NO MAXVALUE
246     CACHE 1;
247    
248    
249     --
250     -- Name: avis_consultation_seq; Type: SEQUENCE OWNED BY; Schema: openads; Owner: -
251     --
252    
253     ALTER SEQUENCE avis_consultation_seq OWNED BY avis_consultation.avis_consultation;
254    
255    
256     --
257     -- Name: avis_decision; Type: TABLE; Schema: openads; Owner: -; Tablespace:
258     --
259    
260     CREATE TABLE avis_decision (
261     libelle character varying(30) NOT NULL,
262     typeavis character(1) DEFAULT ''::bpchar NOT NULL,
263     sitadel character(1) DEFAULT ''::bpchar NOT NULL,
264     sitadel_motif character(1) DEFAULT ''::bpchar NOT NULL,
265     avis_decision integer NOT NULL
266     );
267    
268    
269     --
270     -- Name: avis_decision_seq; Type: SEQUENCE; Schema: openads; Owner: -
271     --
272    
273     CREATE SEQUENCE avis_decision_seq
274     START WITH 1
275     INCREMENT BY 1
276     NO MINVALUE
277     NO MAXVALUE
278     CACHE 1;
279    
280    
281     --
282     -- Name: avis_decision_seq; Type: SEQUENCE OWNED BY; Schema: openads; Owner: -
283     --
284    
285     ALTER SEQUENCE avis_decision_seq OWNED BY avis_decision.avis_decision;
286    
287    
288     --
289     -- Name: bible; Type: TABLE; Schema: openads; Owner: -; Tablespace:
290     --
291    
292     CREATE TABLE bible (
293     bible integer NOT NULL,
294     libelle character varying(60) NOT NULL,
295     evenement integer,
296     contenu text NOT NULL,
297     complement integer,
298     automatique character(3) DEFAULT ''::bpchar NOT NULL,
299     dossier_autorisation_type integer
300     );
301    
302    
303     --
304     -- Name: bible_seq; Type: SEQUENCE; Schema: openads; Owner: -
305     --
306    
307     CREATE SEQUENCE bible_seq
308     START WITH 1
309     INCREMENT BY 1
310     NO MINVALUE
311     NO MAXVALUE
312     CACHE 1;
313    
314    
315     --
316     -- Name: bible_seq; Type: SEQUENCE OWNED BY; Schema: openads; Owner: -
317     --
318    
319     ALTER SEQUENCE bible_seq OWNED BY bible.bible;
320    
321    
322     --
323     -- Name: blocnote; Type: TABLE; Schema: openads; Owner: -; Tablespace:
324     --
325    
326     CREATE TABLE blocnote (
327     blocnote integer NOT NULL,
328     categorie character varying(20) NOT NULL,
329     note text NOT NULL,
330     dossier character varying(20)
331     );
332    
333    
334     --
335     -- Name: blocnote_seq; Type: SEQUENCE; Schema: openads; Owner: -
336     --
337    
338     CREATE SEQUENCE blocnote_seq
339     START WITH 1
340     INCREMENT BY 1
341     NO MINVALUE
342     NO MAXVALUE
343     CACHE 1;
344    
345    
346     --
347     -- Name: blocnote_seq; Type: SEQUENCE OWNED BY; Schema: openads; Owner: -
348     --
349    
350     ALTER SEQUENCE blocnote_seq OWNED BY blocnote.blocnote;
351    
352    
353     --
354     -- Name: categorie_demandeur; Type: TABLE; Schema: openads; Owner: -; Tablespace:
355     --
356    
357     CREATE TABLE categorie_demandeur (
358     categorie_demandeur integer NOT NULL,
359     libelle character varying(40) NOT NULL
360     );
361    
362    
363     --
364     -- Name: categorie_demandeur_seq; Type: SEQUENCE; Schema: openads; Owner: -
365     --
366    
367     CREATE SEQUENCE categorie_demandeur_seq
368     START WITH 1
369     INCREMENT BY 1
370     NO MINVALUE
371     NO MAXVALUE
372     CACHE 1;
373    
374    
375     --
376     -- Name: categorie_demandeur_seq; Type: SEQUENCE OWNED BY; Schema: openads; Owner: -
377     --
378    
379     ALTER SEQUENCE categorie_demandeur_seq OWNED BY categorie_demandeur.categorie_demandeur;
380    
381    
382     --
383     -- Name: cerfa; Type: TABLE; Schema: openads; Owner: -; Tablespace:
384     --
385    
386     CREATE TABLE cerfa (
387     cerfa integer NOT NULL,
388     libelle character varying(200),
389     code character varying(20),
390     om_validite_debut date,
391     om_validite_fin date,
392     avap_co_elt_pro boolean,
393     avap_nouv_haut_surf boolean,
394     avap_co_clot boolean,
395     avap_aut_coup_aba_arb boolean,
396     avap_ouv_infra boolean,
397     avap_aut_inst_mob boolean,
398     avap_aut_plant boolean,
399     avap_aut_auv_elec boolean,
400     tr_total boolean,
401     tr_partiel boolean,
402     tr_desc boolean,
403     am_lotiss boolean,
404     am_autre_div boolean,
405     am_camping boolean,
406     am_caravane boolean,
407     am_carav_duree boolean,
408     am_statio boolean,
409     am_statio_cont boolean,
410     am_affou_exhau boolean,
411     am_affou_exhau_sup boolean,
412     am_affou_prof boolean,
413     am_exhau_haut boolean,
414     am_coupe_abat boolean,
415     am_prot_plu boolean,
416     am_prot_muni boolean,
417     am_mobil_voyage boolean,
418     am_voyage_deb boolean,
419     am_voyage_fin boolean,
420     am_aire_voyage boolean,
421     am_rememb_afu boolean,
422     am_parc_resid_loi boolean,
423     am_sport_moto boolean,
424     am_sport_attrac boolean,
425     am_sport_golf boolean,
426     am_mob_art boolean,
427     am_modif_voie_esp boolean,
428     am_plant_voie_esp boolean,
429     am_chem_ouv_esp boolean,
430     am_agri_peche boolean,
431     am_crea_voie boolean,
432     am_modif_voie_exist boolean,
433     am_crea_esp_sauv boolean,
434     am_modif_amgt boolean,
435     am_crea_esp_class boolean,
436     am_projet_desc boolean,
437     am_terr_surf boolean,
438     am_tranche_desc boolean,
439     am_lot_max_nb boolean,
440     am_lot_max_shon boolean,
441     am_lot_max_shob boolean,
442     am_lot_cstr_cos boolean,
443     am_lot_cstr_plan boolean,
444     am_lot_cstr_vente boolean,
445     am_lot_fin_diff boolean,
446     am_lot_consign boolean,
447     am_lot_gar_achev boolean,
448     am_lot_vente_ant boolean,
449     am_empl_nb boolean,
450     am_tente_nb boolean,
451     am_carav_nb boolean,
452     am_mobil_nb boolean,
453     am_pers_nb boolean,
454     am_empl_hll_nb boolean,
455     am_hll_shon boolean,
456     am_periode_exploit boolean,
457     am_exist_agrand boolean,
458     am_exist_date boolean,
459     am_exist_num boolean,
460     am_exist_nb_avant boolean,
461     am_exist_nb_apres boolean,
462     am_coupe_bois boolean,
463     am_coupe_parc boolean,
464     am_coupe_align boolean,
465     am_coupe_ess boolean,
466     am_coupe_age boolean,
467     am_coupe_dens boolean,
468     am_coupe_qual boolean,
469     am_coupe_trait boolean,
470     am_coupe_autr boolean,
471     co_archi_recours boolean,
472     co_cstr_nouv boolean,
473     co_cstr_exist boolean,
474     co_modif_aspect boolean,
475     co_modif_struct boolean,
476     co_cloture boolean,
477     co_ouvr_elec boolean,
478     co_elec_tension boolean,
479     co_ouvr_infra boolean,
480     co_trx_imm boolean,
481     co_div_terr boolean,
482     co_projet_desc boolean,
483     co_cstr_shob boolean,
484     co_anx_pisc boolean,
485     co_anx_gara boolean,
486     co_anx_veran boolean,
487     co_anx_abri boolean,
488     co_anx_autr boolean,
489     co_anx_autr_desc boolean,
490     co_tot_log_nb boolean,
491     co_tot_ind_nb boolean,
492     co_tot_coll_nb boolean,
493     co_mais_piece_nb boolean,
494     co_mais_niv_nb boolean,
495     co_fin_lls_nb boolean,
496     co_fin_aa_nb boolean,
497     co_fin_ptz_nb boolean,
498     co_fin_autr_nb boolean,
499     co_fin_autr_desc boolean,
500     co_mais_contrat_ind boolean,
501     co_uti_pers boolean,
502     co_uti_vente boolean,
503     co_uti_loc boolean,
504     co_uti_princ boolean,
505     co_uti_secon boolean,
506     co_resid_agees boolean,
507     co_resid_etud boolean,
508     co_resid_tourism boolean,
509     co_resid_hot_soc boolean,
510     co_resid_soc boolean,
511     co_resid_hand boolean,
512     co_resid_autr boolean,
513     co_resid_autr_desc boolean,
514     co_foyer_chamb_nb boolean,
515     co_log_1p_nb boolean,
516     co_log_2p_nb boolean,
517     co_log_3p_nb boolean,
518     co_log_4p_nb boolean,
519     co_log_5p_nb boolean,
520     co_log_6p_nb boolean,
521     co_bat_niv_nb boolean,
522     co_trx_exten boolean,
523     co_trx_surelev boolean,
524     co_trx_nivsup boolean,
525     co_trx_amgt boolean,
526     co_demont_periode boolean,
527     co_sp_transport boolean,
528     co_sp_enseign boolean,
529     co_sp_act_soc boolean,
530     co_sp_ouvr_spe boolean,
531     co_sp_sante boolean,
532     co_sp_culture boolean,
533     co_statio_avt_nb boolean,
534     co_statio_apr_nb boolean,
535     co_statio_avt_shob boolean,
536     co_statio_apr_shob boolean,
537     co_statio_avt_surf boolean,
538     co_statio_apr_surf boolean,
539     co_statio_adr boolean,
540     co_statio_place_nb boolean,
541     co_statio_tot_surf boolean,
542     co_statio_tot_shob boolean,
543     co_statio_comm_cin_surf boolean,
544     tab_surface integer,
545     dm_constr_dates boolean,
546     dm_total boolean,
547     dm_partiel boolean,
548     dm_projet_desc boolean,
549     dm_tot_log_nb boolean,
550     tax_surf_tot boolean,
551     tax_surf boolean,
552     tax_surf_suppr_mod boolean,
553     tax_dest_loc_tr boolean,
554     tab_tax_su_princ integer,
555     tab_tax_su_heber integer,
556     tab_tax_su_secon integer,
557     tab_tax_su_tot integer,
558     tax_ext_pret boolean,
559     tax_ext_desc boolean,
560     tax_surf_tax_exist_cons boolean,
561     tax_log_exist_nb boolean,
562     tax_trx_presc_ppr boolean,
563     tax_monu_hist boolean,
564     tax_comm_nb boolean,
565     tab_tax_su_non_habit_surf integer,
566     tab_tax_am integer,
567     vsd_surf_planch_smd boolean,
568     vsd_unit_fonc_sup boolean,
569     vsd_unit_fonc_constr_sup boolean,
570     vsd_val_terr boolean,
571     vsd_const_sxist_non_dem_surf boolean,
572     vsd_rescr_fisc boolean,
573     pld_val_terr boolean,
574     pld_const_exist_dem boolean,
575     pld_const_exist_dem_surf boolean,
576     code_cnil boolean,
577     co_archi_nom boolean,
578     co_archi_prenom boolean,
579     co_archi_adr_num boolean,
580     co_archi_adr_voie boolean,
581     co_archi_adr_lieu_dit boolean,
582     co_archi_adr_localite boolean,
583     co_archi_adr_cp boolean,
584     co_archi_adr_bp boolean,
585     co_archi_adr_cedex boolean,
586     co_archi_no_incri boolean,
587     co_archi_cg boolean,
588     co_archi_tel1 boolean,
589     co_archi_tel2 boolean,
590     co_archi_mail boolean,
591     terr_juri_titul boolean,
592     terr_juri_lot boolean,
593     terr_juri_zac boolean,
594     terr_juri_afu boolean,
595     terr_juri_pup boolean,
596     terr_juri_oin boolean,
597     terr_juri_desc boolean,
598     terr_div_surf_etab boolean,
599 fmichon 1844 terr_div_surf_av_div boolean,
600     doc_date boolean,
601     doc_tot_trav boolean,
602     doc_tranche_trav boolean,
603     doc_tranche_trav_desc boolean,
604     doc_surf boolean,
605     doc_nb_log boolean,
606     doc_nb_log_indiv boolean,
607     doc_nb_log_coll boolean,
608     doc_nb_log_lls boolean,
609     doc_nb_log_aa boolean,
610     doc_nb_log_ptz boolean,
611     doc_nb_log_autre boolean,
612     daact_date boolean,
613     daact_date_chgmt_dest boolean,
614     daact_tot_trav boolean,
615     daact_tranche_trav boolean,
616     daact_tranche_trav_desc boolean,
617     daact_surf boolean,
618     daact_nb_log boolean,
619     daact_nb_log_indiv boolean,
620     daact_nb_log_coll boolean,
621     daact_nb_log_lls boolean,
622     daact_nb_log_aa boolean,
623     daact_nb_log_ptz boolean,
624 fmichon 1970 daact_nb_log_autre boolean,
625     mod_desc boolean
626 fmichon 1801 );
627    
628    
629     --
630     -- Name: cerfa_seq; Type: SEQUENCE; Schema: openads; Owner: -
631     --
632    
633     CREATE SEQUENCE cerfa_seq
634     START WITH 1
635     INCREMENT BY 1
636     NO MINVALUE
637     NO MAXVALUE
638     CACHE 1;
639    
640    
641     --
642     -- Name: cerfa_seq; Type: SEQUENCE OWNED BY; Schema: openads; Owner: -
643     --
644    
645     ALTER SEQUENCE cerfa_seq OWNED BY cerfa.cerfa;
646    
647    
648     --
649     -- Name: civilite; Type: TABLE; Schema: openads; Owner: -; Tablespace:
650     --
651    
652     CREATE TABLE civilite (
653     code character varying(20) NOT NULL,
654     civilite integer NOT NULL,
655     libelle character varying(100),
656     om_validite_debut date,
657     om_validite_fin date
658     );
659    
660    
661     --
662     -- Name: civilite_seq; Type: SEQUENCE; Schema: openads; Owner: -
663     --
664    
665     CREATE SEQUENCE civilite_seq
666     START WITH 1
667     INCREMENT BY 1
668     NO MINVALUE
669     NO MAXVALUE
670     CACHE 1;
671    
672    
673     --
674     -- Name: civilite_seq; Type: SEQUENCE OWNED BY; Schema: openads; Owner: -
675     --
676    
677     ALTER SEQUENCE civilite_seq OWNED BY civilite.civilite;
678    
679    
680     --
681     -- Name: commission; Type: TABLE; Schema: openads; Owner: -; Tablespace:
682     --
683    
684     CREATE TABLE commission (
685     commission integer NOT NULL,
686     code character varying(20),
687     commission_type integer NOT NULL,
688     libelle character varying(100),
689     date_commission date NOT NULL,
690     heure_commission character varying(5),
691     lieu_adresse_ligne1 character varying(100),
692     lieu_adresse_ligne2 character varying(100),
693     lieu_salle character varying(100),
694     listes_de_diffusion text,
695 fmichon 1970 participants text,
696     om_fichier_commission_ordre_jour character varying(64),
697     om_final_commission_ordre_jour boolean,
698     om_fichier_commission_compte_rendu character varying(64),
699     om_final_commission_compte_rendu boolean
700 fmichon 1801 );
701    
702    
703     --
704     -- Name: commission_seq; Type: SEQUENCE; Schema: openads; Owner: -
705     --
706    
707     CREATE SEQUENCE commission_seq
708     START WITH 1
709     INCREMENT BY 1
710     NO MINVALUE
711     NO MAXVALUE
712     CACHE 1;
713    
714    
715     --
716     -- Name: commission_seq; Type: SEQUENCE OWNED BY; Schema: openads; Owner: -
717     --
718    
719     ALTER SEQUENCE commission_seq OWNED BY commission.commission;
720    
721    
722     --
723     -- Name: commission_type; Type: TABLE; Schema: openads; Owner: -; Tablespace:
724     --
725    
726     CREATE TABLE commission_type (
727     commission_type integer NOT NULL,
728     code character varying(10),
729     libelle character varying(100),
730     lieu_adresse_ligne1 character varying(100),
731     lieu_adresse_ligne2 character varying(100),
732     lieu_salle character varying(100),
733     listes_de_diffusion text,
734     participants text,
735     corps_du_courriel text,
736     om_validite_debut date,
737     om_validite_fin date
738     );
739    
740    
741     --
742     -- Name: commission_type_seq; Type: SEQUENCE; Schema: openads; Owner: -
743     --
744    
745     CREATE SEQUENCE commission_type_seq
746     START WITH 1
747     INCREMENT BY 1
748     NO MINVALUE
749     NO MAXVALUE
750     CACHE 1;
751    
752    
753     --
754     -- Name: commission_type_seq; Type: SEQUENCE OWNED BY; Schema: openads; Owner: -
755     --
756    
757     ALTER SEQUENCE commission_type_seq OWNED BY commission_type.commission_type;
758    
759    
760     --
761     -- Name: consultation; Type: TABLE; Schema: openads; Owner: -; Tablespace:
762     --
763    
764     CREATE TABLE consultation (
765     consultation integer NOT NULL,
766     dossier character varying(20) NOT NULL,
767     date_envoi date NOT NULL,
768     date_retour date,
769     date_limite date,
770     service integer NOT NULL,
771     avis_consultation integer,
772     date_reception date,
773     motivation text DEFAULT ''::text,
774     fichier character varying(100),
775 fmichon 1844 lu boolean,
776 fmichon 1970 code_barres character varying(12),
777     om_fichier_consultation character varying(64),
778     om_final_consultation boolean
779 fmichon 1801 );
780    
781    
782     --
783     -- Name: consultation_seq; Type: SEQUENCE; Schema: openads; Owner: -
784     --
785    
786     CREATE SEQUENCE consultation_seq
787     START WITH 1
788     INCREMENT BY 1
789     NO MINVALUE
790     NO MAXVALUE
791     CACHE 1;
792    
793    
794     --
795     -- Name: consultation_seq; Type: SEQUENCE OWNED BY; Schema: openads; Owner: -
796     --
797    
798     ALTER SEQUENCE consultation_seq OWNED BY consultation.consultation;
799    
800    
801     --
802     -- Name: demande; Type: TABLE; Schema: openads; Owner: -; Tablespace:
803     --
804    
805     CREATE TABLE demande (
806     demande integer NOT NULL,
807     dossier_autorisation_type_detaille integer NOT NULL,
808     demande_type integer NOT NULL,
809     dossier_instruction character varying(20),
810     dossier_autorisation character varying(20),
811     date_demande date NOT NULL,
812     terrain_references_cadastrales character varying(100),
813     terrain_adresse_voie_numero integer,
814     complement character varying(30),
815     terrain_adresse_lieu_dit character varying(30),
816     terrain_adresse_localite character varying(30),
817     terrain_adresse_code_postal character varying(5),
818     terrain_adresse_bp character varying(15),
819     terrain_adresse_cedex character varying(15),
820     terrain_superficie double precision,
821     instruction_recepisse integer,
822     arrondissement integer
823     );
824    
825    
826     --
827     -- Name: demande_nature; Type: TABLE; Schema: openads; Owner: -; Tablespace:
828     --
829    
830     CREATE TABLE demande_nature (
831     demande_nature integer NOT NULL,
832     code character varying(20),
833     libelle character varying(100),
834     description text
835     );
836    
837    
838     --
839     -- Name: demande_nature_seq; Type: SEQUENCE; Schema: openads; Owner: -
840     --
841    
842     CREATE SEQUENCE demande_nature_seq
843     START WITH 1
844     INCREMENT BY 1
845     NO MINVALUE
846     NO MAXVALUE
847     CACHE 1;
848    
849    
850     --
851     -- Name: demande_nature_seq; Type: SEQUENCE OWNED BY; Schema: openads; Owner: -
852     --
853    
854     ALTER SEQUENCE demande_nature_seq OWNED BY demande_nature.demande_nature;
855    
856    
857     --
858     -- Name: demande_seq; Type: SEQUENCE; Schema: openads; Owner: -
859     --
860    
861     CREATE SEQUENCE demande_seq
862     START WITH 1
863     INCREMENT BY 1
864     NO MINVALUE
865     NO MAXVALUE
866     CACHE 1;
867    
868    
869     --
870     -- Name: demande_seq; Type: SEQUENCE OWNED BY; Schema: openads; Owner: -
871     --
872    
873     ALTER SEQUENCE demande_seq OWNED BY demande.demande;
874    
875    
876     --
877     -- Name: demande_type; Type: TABLE; Schema: openads; Owner: -; Tablespace:
878     --
879    
880     CREATE TABLE demande_type (
881     demande_type integer NOT NULL,
882     code character varying(20),
883     libelle character varying(100),
884     description text,
885     demande_nature integer,
886     groupe integer,
887     dossier_instruction_type integer,
888     dossier_autorisation_type_detaille integer,
889     contraintes character varying(20),
890     qualification boolean,
891     evenement integer NOT NULL
892     );
893    
894    
895     --
896     -- Name: demande_type_seq; Type: SEQUENCE; Schema: openads; Owner: -
897     --
898    
899     CREATE SEQUENCE demande_type_seq
900     START WITH 1
901     INCREMENT BY 1
902     NO MINVALUE
903     NO MAXVALUE
904     CACHE 1;
905    
906    
907     --
908     -- Name: demande_type_seq; Type: SEQUENCE OWNED BY; Schema: openads; Owner: -
909     --
910    
911     ALTER SEQUENCE demande_type_seq OWNED BY demande_type.demande_type;
912    
913    
914     --
915     -- Name: demandeur; Type: TABLE; Schema: openads; Owner: -; Tablespace:
916     --
917    
918     CREATE TABLE demandeur (
919     demandeur integer NOT NULL,
920     type_demandeur character varying(40),
921     qualite character varying(40),
922     particulier_nom character varying(40),
923     particulier_prenom character varying(40),
924     particulier_date_naissance date,
925     particulier_commune_naissance character varying(30),
926     particulier_departement_naissance character varying(80),
927 fmichon 1970 personne_morale_denomination character varying(40),
928     personne_morale_raison_sociale character varying(40),
929 fmichon 1801 personne_morale_siret character varying(15),
930     personne_morale_categorie_juridique character varying(15),
931     personne_morale_nom character varying(40),
932     personne_morale_prenom character varying(40),
933     numero character varying(5),
934     voie character varying(40),
935     complement character varying(39),
936     lieu_dit character varying(39),
937     localite character varying(30),
938     code_postal character varying(5),
939     bp character varying(5),
940     cedex character varying(5),
941     pays character varying(40),
942     division_territoriale character varying(40),
943     telephone_fixe character varying(14),
944     telephone_mobile character varying(14),
945     indicatif character varying(5),
946     courriel character varying(40),
947     notification boolean,
948     frequent boolean,
949     particulier_civilite integer,
950     personne_morale_civilite integer
951     );
952    
953    
954     --
955     -- Name: demandeur_seq; Type: SEQUENCE; Schema: openads; Owner: -
956     --
957    
958     CREATE SEQUENCE demandeur_seq
959     START WITH 1
960     INCREMENT BY 1
961     NO MINVALUE
962     NO MAXVALUE
963     CACHE 1;
964    
965    
966     --
967     -- Name: demandeur_seq; Type: SEQUENCE OWNED BY; Schema: openads; Owner: -
968     --
969    
970     ALTER SEQUENCE demandeur_seq OWNED BY demandeur.demandeur;
971    
972    
973     --
974     -- Name: destination; Type: TABLE; Schema: openads; Owner: -; Tablespace:
975     --
976    
977     CREATE TABLE destination (
978     destination character varying(2) NOT NULL,
979     libelle character varying(80) NOT NULL
980     );
981    
982    
983     --
984     -- Name: destination_seq; Type: SEQUENCE; Schema: openads; Owner: -
985     --
986    
987     CREATE SEQUENCE destination_seq
988     START WITH 1
989     INCREMENT BY 1
990     NO MINVALUE
991     NO MAXVALUE
992     CACHE 1;
993    
994    
995     --
996     -- Name: destination_seq; Type: SEQUENCE OWNED BY; Schema: openads; Owner: -
997     --
998    
999     ALTER SEQUENCE destination_seq OWNED BY destination.destination;
1000    
1001    
1002     --
1003     -- Name: direction; Type: TABLE; Schema: openads; Owner: -; Tablespace:
1004     --
1005    
1006     CREATE TABLE direction (
1007     direction integer NOT NULL,
1008     code character varying(20) NOT NULL,
1009     libelle character varying(100) NOT NULL,
1010     description text,
1011     chef character varying(100) NOT NULL,
1012     om_validite_debut date,
1013     om_validite_fin date
1014     );
1015    
1016    
1017     --
1018     -- Name: direction_seq; Type: SEQUENCE; Schema: openads; Owner: -
1019     --
1020    
1021     CREATE SEQUENCE direction_seq
1022     START WITH 1
1023     INCREMENT BY 1
1024     NO MINVALUE
1025     NO MAXVALUE
1026     CACHE 1;
1027    
1028    
1029     --
1030     -- Name: direction_seq; Type: SEQUENCE OWNED BY; Schema: openads; Owner: -
1031     --
1032    
1033     ALTER SEQUENCE direction_seq OWNED BY direction.direction;
1034    
1035    
1036     --
1037     -- Name: division; Type: TABLE; Schema: openads; Owner: -; Tablespace:
1038     --
1039    
1040     CREATE TABLE division (
1041     division integer NOT NULL,
1042     code character varying(20) NOT NULL,
1043     libelle character varying(100) NOT NULL,
1044     description text,
1045     chef character varying(100) NOT NULL,
1046     direction integer NOT NULL,
1047     om_validite_debut date,
1048     om_validite_fin date
1049     );
1050    
1051    
1052     --
1053     -- Name: division_seq; Type: SEQUENCE; Schema: openads; Owner: -
1054     --
1055    
1056     CREATE SEQUENCE division_seq
1057     START WITH 1
1058     INCREMENT BY 1
1059     NO MINVALUE
1060     NO MAXVALUE
1061     CACHE 1;
1062    
1063    
1064     --
1065     -- Name: division_seq; Type: SEQUENCE OWNED BY; Schema: openads; Owner: -
1066     --
1067    
1068     ALTER SEQUENCE division_seq OWNED BY division.division;
1069    
1070    
1071     --
1072 fmichon 1844 -- Name: document_numerise; Type: TABLE; Schema: openads; Owner: -; Tablespace:
1073     --
1074    
1075     CREATE TABLE document_numerise (
1076     document_numerise integer NOT NULL,
1077     uid character varying(64) NOT NULL,
1078 fmichon 1970 dossier character varying(20) NOT NULL,
1079     nom_fichier character varying(255) NOT NULL,
1080     date_creation date NOT NULL,
1081     document_numerise_type integer NOT NULL
1082 fmichon 1844 );
1083    
1084    
1085     --
1086     -- Name: document_numerise_seq; Type: SEQUENCE; Schema: openads; Owner: -
1087     --
1088    
1089     CREATE SEQUENCE document_numerise_seq
1090     START WITH 1
1091     INCREMENT BY 1
1092     NO MINVALUE
1093     NO MAXVALUE
1094     CACHE 1;
1095    
1096    
1097     --
1098     -- Name: document_numerise_seq; Type: SEQUENCE OWNED BY; Schema: openads; Owner: -
1099     --
1100    
1101     ALTER SEQUENCE document_numerise_seq OWNED BY document_numerise.document_numerise;
1102    
1103    
1104     --
1105     -- Name: document_numerise_type; Type: TABLE; Schema: openads; Owner: -; Tablespace:
1106     --
1107    
1108     CREATE TABLE document_numerise_type (
1109     document_numerise_type integer NOT NULL,
1110     code character varying(6) NOT NULL,
1111 fmichon 1970 libelle character varying(255) NOT NULL,
1112     document_numerise_type_categorie integer NOT NULL
1113     );
1114    
1115    
1116     --
1117     -- Name: document_numerise_type_categorie; Type: TABLE; Schema: openads; Owner: -; Tablespace:
1118     --
1119    
1120     CREATE TABLE document_numerise_type_categorie (
1121     document_numerise_type_categorie integer NOT NULL,
1122 fmichon 1844 libelle character varying(255) NOT NULL
1123     );
1124    
1125    
1126     --
1127 fmichon 1970 -- Name: document_numerise_type_categorie_seq; Type: SEQUENCE; Schema: openads; Owner: -
1128     --
1129    
1130     CREATE SEQUENCE document_numerise_type_categorie_seq
1131     START WITH 1
1132     INCREMENT BY 1
1133     NO MINVALUE
1134     NO MAXVALUE
1135     CACHE 1;
1136    
1137    
1138     --
1139     -- Name: document_numerise_type_categorie_seq; Type: SEQUENCE OWNED BY; Schema: openads; Owner: -
1140     --
1141    
1142     ALTER SEQUENCE document_numerise_type_categorie_seq OWNED BY document_numerise_type_categorie.document_numerise_type_categorie;
1143    
1144    
1145     --
1146 fmichon 1844 -- Name: document_numerise_type_seq; Type: SEQUENCE; Schema: openads; Owner: -
1147     --
1148    
1149     CREATE SEQUENCE document_numerise_type_seq
1150     START WITH 1
1151     INCREMENT BY 1
1152     NO MINVALUE
1153     NO MAXVALUE
1154     CACHE 1;
1155    
1156    
1157     --
1158     -- Name: document_numerise_type_seq; Type: SEQUENCE OWNED BY; Schema: openads; Owner: -
1159     --
1160    
1161     ALTER SEQUENCE document_numerise_type_seq OWNED BY document_numerise_type.document_numerise_type;
1162    
1163    
1164     --
1165 fmichon 1801 -- Name: donnees_techniques; Type: TABLE; Schema: openads; Owner: -; Tablespace:
1166     --
1167    
1168     CREATE TABLE donnees_techniques (
1169     donnees_techniques integer NOT NULL,
1170     dossier_instruction character varying(20),
1171     lot integer,
1172     avap_co_elt_pro boolean,
1173     avap_nouv_haut_surf boolean,
1174     avap_co_clot boolean,
1175     avap_aut_coup_aba_arb boolean,
1176     avap_ouv_infra boolean,
1177     avap_aut_inst_mob boolean,
1178     avap_aut_plant boolean,
1179     avap_aut_auv_elec boolean,
1180     tr_total boolean,
1181     tr_partiel boolean,
1182     tr_desc text,
1183     am_lotiss boolean,
1184     am_autre_div boolean,
1185     am_camping boolean,
1186     am_caravane boolean,
1187     am_carav_duree integer,
1188     am_statio boolean,
1189     am_statio_cont integer,
1190     am_affou_exhau boolean,
1191     am_affou_exhau_sup numeric,
1192     am_affou_prof numeric,
1193     am_exhau_haut numeric,
1194     am_coupe_abat boolean,
1195     am_prot_plu boolean,
1196     am_prot_muni boolean,
1197     am_mobil_voyage boolean,
1198     am_voyage_deb date,
1199     am_voyage_fin date,
1200     am_aire_voyage boolean,
1201     am_rememb_afu boolean,
1202     am_parc_resid_loi boolean,
1203     am_sport_moto boolean,
1204     am_sport_attrac boolean,
1205     am_sport_golf boolean,
1206     am_mob_art boolean,
1207     am_modif_voie_esp boolean,
1208     am_plant_voie_esp boolean,
1209     am_chem_ouv_esp boolean,
1210     am_agri_peche boolean,
1211     am_crea_voie boolean,
1212     am_modif_voie_exist boolean,
1213     am_crea_esp_sauv boolean,
1214     am_modif_amgt boolean,
1215     am_crea_esp_class boolean,
1216     am_projet_desc text,
1217     am_terr_surf numeric,
1218     am_tranche_desc text,
1219     am_lot_max_nb integer,
1220     am_lot_max_shon numeric,
1221     am_lot_max_shob numeric,
1222     am_lot_cstr_cos boolean,
1223     am_lot_cstr_plan boolean,
1224     am_lot_cstr_vente boolean,
1225     am_lot_fin_diff boolean,
1226     am_lot_consign boolean,
1227     am_lot_gar_achev boolean,
1228     am_lot_vente_ant boolean,
1229     am_empl_nb integer,
1230     am_tente_nb integer,
1231     am_carav_nb integer,
1232     am_mobil_nb integer,
1233     am_pers_nb integer,
1234     am_empl_hll_nb integer,
1235     am_hll_shon numeric,
1236     am_periode_exploit text,
1237     am_exist_agrand boolean,
1238     am_exist_date date,
1239     am_exist_num character varying(100),
1240     am_exist_nb_avant integer,
1241     am_exist_nb_apres integer,
1242     am_coupe_bois boolean,
1243     am_coupe_parc boolean,
1244     am_coupe_align boolean,
1245     am_coupe_ess character varying(100),
1246     am_coupe_age character varying(15),
1247     am_coupe_dens character varying(100),
1248     am_coupe_qual character varying(100),
1249     am_coupe_trait character varying(100),
1250     am_coupe_autr character varying(100),
1251     co_archi_recours boolean,
1252     co_cstr_nouv boolean,
1253     co_cstr_exist boolean,
1254     co_modif_aspect boolean,
1255     co_modif_struct boolean,
1256     co_cloture boolean,
1257     co_ouvr_elec boolean,
1258     co_elec_tension numeric,
1259     co_ouvr_infra boolean,
1260     co_trx_imm boolean,
1261     co_div_terr boolean,
1262     co_projet_desc text,
1263     co_cstr_shob numeric,
1264     co_anx_pisc boolean,
1265     co_anx_gara boolean,
1266     co_anx_veran boolean,
1267     co_anx_abri boolean,
1268     co_anx_autr boolean,
1269     co_anx_autr_desc text,
1270     co_tot_log_nb integer,
1271     co_tot_ind_nb integer,
1272     co_tot_coll_nb integer,
1273     co_mais_piece_nb integer,
1274     co_mais_niv_nb integer,
1275     co_fin_lls_nb integer,
1276     co_fin_aa_nb integer,
1277     co_fin_ptz_nb integer,
1278     co_fin_autr_nb integer,
1279     co_fin_autr_desc text,
1280     co_mais_contrat_ind boolean,
1281     co_uti_pers boolean,
1282     co_uti_vente boolean,
1283     co_uti_loc boolean,
1284     co_uti_princ boolean,
1285     co_uti_secon boolean,
1286     co_resid_agees boolean,
1287     co_resid_etud boolean,
1288     co_resid_tourism boolean,
1289     co_resid_hot_soc boolean,
1290     co_resid_soc boolean,
1291     co_resid_hand boolean,
1292     co_resid_autr boolean,
1293     co_resid_autr_desc text,
1294     co_foyer_chamb_nb integer,
1295     co_log_1p_nb integer,
1296     co_log_2p_nb integer,
1297     co_log_3p_nb integer,
1298     co_log_4p_nb integer,
1299     co_log_5p_nb integer,
1300     co_log_6p_nb integer,
1301     co_bat_niv_nb integer,
1302     co_trx_exten boolean,
1303     co_trx_surelev boolean,
1304     co_trx_nivsup boolean,
1305     co_trx_amgt boolean,
1306     co_demont_periode text,
1307     co_sp_transport boolean,
1308     co_sp_enseign boolean,
1309     co_sp_act_soc boolean,
1310     co_sp_ouvr_spe boolean,
1311     co_sp_sante boolean,
1312     co_sp_culture boolean,
1313     co_statio_avt_nb integer,
1314     co_statio_apr_nb integer,
1315     co_statio_avt_shob numeric,
1316     co_statio_apr_shob numeric,
1317     co_statio_avt_surf numeric,
1318     co_statio_apr_surf numeric,
1319     co_statio_adr text,
1320     co_statio_place_nb integer,
1321     co_statio_tot_surf numeric,
1322     co_statio_tot_shob numeric,
1323     co_statio_comm_cin_surf numeric,
1324     su_avt_shon1 numeric,
1325     su_avt_shon2 numeric,
1326     su_avt_shon3 numeric,
1327     su_avt_shon4 numeric,
1328     su_avt_shon5 numeric,
1329     su_avt_shon6 numeric,
1330     su_avt_shon7 numeric,
1331     su_avt_shon8 numeric,
1332     su_avt_shon9 numeric,
1333     su_cstr_shon1 numeric,
1334     su_cstr_shon2 numeric,
1335     su_cstr_shon3 numeric,
1336     su_cstr_shon4 numeric,
1337     su_cstr_shon5 numeric,
1338     su_cstr_shon6 numeric,
1339     su_cstr_shon7 numeric,
1340     su_cstr_shon8 numeric,
1341     su_cstr_shon9 numeric,
1342     su_trsf_shon1 numeric,
1343     su_trsf_shon2 numeric,
1344     su_trsf_shon3 numeric,
1345     su_trsf_shon4 numeric,
1346     su_trsf_shon5 numeric,
1347     su_trsf_shon6 numeric,
1348     su_trsf_shon7 numeric,
1349     su_trsf_shon8 numeric,
1350     su_trsf_shon9 numeric,
1351     su_chge_shon1 numeric,
1352     su_chge_shon2 numeric,
1353     su_chge_shon3 numeric,
1354     su_chge_shon4 numeric,
1355     su_chge_shon5 numeric,
1356     su_chge_shon6 numeric,
1357     su_chge_shon7 numeric,
1358     su_chge_shon8 numeric,
1359     su_chge_shon9 numeric,
1360     su_demo_shon1 numeric,
1361     su_demo_shon2 numeric,
1362     su_demo_shon3 numeric,
1363     su_demo_shon4 numeric,
1364     su_demo_shon5 numeric,
1365     su_demo_shon6 numeric,
1366     su_demo_shon7 numeric,
1367     su_demo_shon8 numeric,
1368     su_demo_shon9 numeric,
1369     su_sup_shon1 numeric,
1370     su_sup_shon2 numeric,
1371     su_sup_shon3 numeric,
1372     su_sup_shon4 numeric,
1373     su_sup_shon5 numeric,
1374     su_sup_shon6 numeric,
1375     su_sup_shon7 numeric,
1376     su_sup_shon8 numeric,
1377     su_sup_shon9 numeric,
1378     su_tot_shon1 numeric,
1379     su_tot_shon2 numeric,
1380     su_tot_shon3 numeric,
1381     su_tot_shon4 numeric,
1382     su_tot_shon5 numeric,
1383     su_tot_shon6 numeric,
1384     su_tot_shon7 numeric,
1385     su_tot_shon8 numeric,
1386     su_tot_shon9 numeric,
1387     su_avt_shon_tot numeric,
1388     su_cstr_shon_tot numeric,
1389     su_trsf_shon_tot numeric,
1390     su_chge_shon_tot numeric,
1391     su_demo_shon_tot numeric,
1392     su_sup_shon_tot numeric,
1393     su_tot_shon_tot numeric,
1394     dm_constr_dates text,
1395     dm_total boolean,
1396     dm_partiel boolean,
1397     dm_projet_desc text,
1398     dm_tot_log_nb integer,
1399     tax_surf_tot numeric,
1400     tax_surf numeric,
1401     tax_surf_suppr_mod numeric,
1402     tax_dest_loc_tr text,
1403     tax_su_princ_log_nb1 numeric,
1404     tax_su_princ_log_nb2 numeric,
1405     tax_su_princ_log_nb3 numeric,
1406     tax_su_princ_log_nb4 numeric,
1407     tax_su_princ_log_nb_tot1 numeric,
1408     tax_su_princ_log_nb_tot2 numeric,
1409     tax_su_princ_log_nb_tot3 numeric,
1410     tax_su_princ_log_nb_tot4 numeric,
1411     tax_su_princ_surf1 numeric,
1412     tax_su_princ_surf2 numeric,
1413     tax_su_princ_surf3 numeric,
1414     tax_su_princ_surf4 numeric,
1415     tax_su_princ_surf_sup1 numeric,
1416     tax_su_princ_surf_sup2 numeric,
1417     tax_su_princ_surf_sup3 numeric,
1418     tax_su_princ_surf_sup4 numeric,
1419     tax_su_heber_log_nb1 integer,
1420     tax_su_heber_log_nb2 integer,
1421     tax_su_heber_log_nb3 integer,
1422     tax_su_heber_log_nb_tot1 integer,
1423     tax_su_heber_log_nb_tot2 integer,
1424     tax_su_heber_log_nb_tot3 integer,
1425     tax_su_heber_surf1 numeric,
1426     tax_su_heber_surf2 numeric,
1427     tax_su_heber_surf3 numeric,
1428     tax_su_heber_surf_sup1 numeric,
1429     tax_su_heber_surf_sup2 numeric,
1430     tax_su_heber_surf_sup3 numeric,
1431     tax_su_secon_log_nb integer,
1432     tax_su_tot_log_nb integer,
1433     tax_su_secon_log_nb_tot integer,
1434     tax_su_tot_log_nb_tot integer,
1435     tax_su_secon_surf numeric,
1436     tax_su_tot_surf numeric,
1437     tax_su_secon_surf_sup numeric,
1438     tax_su_tot_surf_sup numeric,
1439     tax_ext_pret boolean,
1440     tax_ext_desc text,
1441     tax_surf_tax_exist_cons numeric,
1442     tax_log_exist_nb integer,
1443     tax_am_statio_ext integer,
1444     tax_sup_bass_pisc numeric,
1445     tax_empl_ten_carav_mobil_nb integer,
1446     tax_empl_hll_nb integer,
1447     tax_eol_haut_nb integer,
1448     tax_pann_volt_sup numeric,
1449     tax_am_statio_ext_sup integer,
1450     tax_sup_bass_pisc_sup numeric,
1451     tax_empl_ten_carav_mobil_nb_sup integer,
1452     tax_empl_hll_nb_sup integer,
1453     tax_eol_haut_nb_sup integer,
1454     tax_pann_volt_sup_sup numeric,
1455     tax_trx_presc_ppr boolean,
1456     tax_monu_hist boolean,
1457     tax_comm_nb integer,
1458     tax_su_non_habit_surf1 numeric,
1459     tax_su_non_habit_surf2 numeric,
1460     tax_su_non_habit_surf3 numeric,
1461     tax_su_non_habit_surf4 numeric,
1462     tax_su_non_habit_surf5 numeric,
1463     tax_su_non_habit_surf6 numeric,
1464     tax_su_non_habit_surf7 numeric,
1465     tax_su_non_habit_surf_sup1 numeric,
1466     tax_su_non_habit_surf_sup2 numeric,
1467     tax_su_non_habit_surf_sup3 numeric,
1468     tax_su_non_habit_surf_sup4 numeric,
1469     tax_su_non_habit_surf_sup5 numeric,
1470     tax_su_non_habit_surf_sup6 numeric,
1471     tax_su_non_habit_surf_sup7 numeric,
1472     vsd_surf_planch_smd boolean,
1473     vsd_unit_fonc_sup numeric,
1474     vsd_unit_fonc_constr_sup numeric,
1475     vsd_val_terr numeric,
1476     vsd_const_sxist_non_dem_surf numeric,
1477     vsd_rescr_fisc date,
1478     pld_val_terr numeric,
1479     pld_const_exist_dem boolean,
1480     pld_const_exist_dem_surf numeric,
1481     code_cnil boolean,
1482     co_archi_nom character varying(80),
1483     co_archi_prenom character varying(80),
1484     co_archi_adr_num character varying(10),
1485     co_archi_adr_voie character varying(80),
1486     co_archi_adr_lieu_dit character varying(80),
1487     co_archi_adr_localite character varying(80),
1488     co_archi_adr_cp character varying(5),
1489     co_archi_adr_bp character varying(3),
1490     co_archi_adr_cedex character varying(2),
1491     co_archi_no_incri character varying(40),
1492     co_archi_cg character varying(80),
1493     co_archi_tel1 character varying(10),
1494     co_archi_tel2 character varying(10),
1495     co_archi_mail character varying(150),
1496     terr_juri_titul character varying(20),
1497     terr_juri_lot character varying(20),
1498     terr_juri_zac character varying(20),
1499     terr_juri_afu character varying(20),
1500     terr_juri_pup character varying(20),
1501     terr_juri_oin character varying(20),
1502     terr_juri_desc text,
1503     terr_div_surf_etab numeric,
1504 fmichon 1844 terr_div_surf_av_div numeric,
1505     doc_date date,
1506     doc_tot_trav boolean,
1507     doc_tranche_trav boolean,
1508     doc_tranche_trav_desc text,
1509     doc_surf numeric,
1510     doc_nb_log integer,
1511     doc_nb_log_indiv integer,
1512     doc_nb_log_coll integer,
1513     doc_nb_log_lls integer,
1514     doc_nb_log_aa integer,
1515     doc_nb_log_ptz integer,
1516     doc_nb_log_autre integer,
1517     daact_date date,
1518     daact_date_chgmt_dest date,
1519     daact_tot_trav boolean,
1520     daact_tranche_trav boolean,
1521     daact_tranche_trav_desc text,
1522     daact_surf numeric,
1523     daact_nb_log integer,
1524     daact_nb_log_indiv integer,
1525     daact_nb_log_coll integer,
1526     daact_nb_log_lls integer,
1527     daact_nb_log_aa integer,
1528     daact_nb_log_ptz integer,
1529 fmichon 1970 daact_nb_log_autre integer,
1530     mod_desc text
1531 fmichon 1801 );
1532    
1533    
1534     --
1535     -- Name: donnees_techniques_seq; Type: SEQUENCE; Schema: openads; Owner: -
1536     --
1537    
1538     CREATE SEQUENCE donnees_techniques_seq
1539     START WITH 1
1540     INCREMENT BY 1
1541     NO MINVALUE
1542     NO MAXVALUE
1543     CACHE 1;
1544    
1545    
1546     --
1547     -- Name: donnees_techniques_seq; Type: SEQUENCE OWNED BY; Schema: openads; Owner: -
1548     --
1549    
1550     ALTER SEQUENCE donnees_techniques_seq OWNED BY donnees_techniques.donnees_techniques;
1551    
1552    
1553     SET default_with_oids = true;
1554    
1555     --
1556     -- Name: dossier; Type: TABLE; Schema: openads; Owner: -; Tablespace:
1557     --
1558    
1559     CREATE TABLE dossier (
1560     dossier character varying(20) NOT NULL,
1561     annee character(2) DEFAULT ''::bpchar NOT NULL,
1562     etat character varying(20),
1563     instructeur integer,
1564     date_demande date,
1565     date_depot date NOT NULL,
1566     date_complet date,
1567     date_rejet date,
1568     date_notification_delai date,
1569     delai integer DEFAULT 0 NOT NULL,
1570     date_limite date,
1571     accord_tacite character(3) DEFAULT ''::bpchar NOT NULL,
1572     date_decision date,
1573     date_validite date,
1574     date_chantier date,
1575     date_achevement date,
1576     date_conformite date,
1577     parcelle character varying(20),
1578     pos character varying(10),
1579     sig character varying(3) DEFAULT ''::character varying NOT NULL,
1580     batiment_nombre integer,
1581     logement_nombre integer,
1582     shon double precision,
1583     shon_calcul double precision,
1584     shob double precision,
1585     lot integer,
1586     hauteur double precision,
1587     piece_nombre integer,
1588     amenagement character varying(12) DEFAULT ''::character varying NOT NULL,
1589     parcelle_lot integer,
1590     parcelle_lot_lotissement character varying(60) DEFAULT ''::character varying NOT NULL,
1591     description text DEFAULT ''::text NOT NULL,
1592     temp1 character varying(100) DEFAULT ''::character varying NOT NULL,
1593     temp2 character varying(100) DEFAULT ''::character varying NOT NULL,
1594     temp3 character varying(100) DEFAULT ''::character varying NOT NULL,
1595     temp4 character varying(100) DEFAULT ''::character varying NOT NULL,
1596     temp5 character varying(100) DEFAULT ''::character varying NOT NULL,
1597     servitude text,
1598     erp boolean,
1599     avis_decision integer,
1600     enjeu_erp boolean,
1601     enjeu_urba boolean,
1602     division integer,
1603     autorite_competente integer,
1604     a_qualifier boolean,
1605     terrain_references_cadastrales character varying(100),
1606     terrain_adresse_voie_numero integer,
1607     complement character varying(30),
1608     terrain_adresse_lieu_dit character varying(30),
1609     terrain_adresse_localite character varying(30),
1610     terrain_adresse_code_postal character varying(5),
1611     terrain_adresse_bp character varying(15),
1612     terrain_adresse_cedex character varying(15),
1613     terrain_superficie double precision,
1614     dossier_autorisation character varying(20) NOT NULL,
1615     dossier_instruction_type integer NOT NULL,
1616     date_dernier_depot date NOT NULL,
1617     version integer,
1618     incompletude boolean DEFAULT false NOT NULL,
1619     evenement_suivant_tacite integer,
1620     evenement_suivant_tacite_incompletude integer,
1621     etat_pendant_incompletude character varying(20),
1622     date_limite_incompletude date,
1623     delai_incompletude integer,
1624 vpihour 2052 geom public.geometry(Point,2154),
1625     geom1 public.geometry(MultiPolygon,2154)
1626 fmichon 1801 );
1627    
1628    
1629     SET default_with_oids = false;
1630    
1631     --
1632     -- Name: dossier_autorisation; Type: TABLE; Schema: openads; Owner: -; Tablespace:
1633     --
1634    
1635     CREATE TABLE dossier_autorisation (
1636     dossier_autorisation character varying(20) NOT NULL,
1637     dossier_autorisation_type_detaille integer,
1638     exercice integer,
1639     insee integer,
1640     terrain_references_cadastrales character varying(100),
1641     terrain_adresse_voie_numero integer,
1642     complement character varying(30),
1643     terrain_adresse_lieu_dit character varying(30),
1644     terrain_adresse_localite character varying(30),
1645     terrain_adresse_code_postal character varying(5),
1646     terrain_adresse_bp character varying(15),
1647     terrain_adresse_cedex character varying(15),
1648     terrain_superficie double precision,
1649     arrondissement integer,
1650     depot_initial date,
1651     erp_numero_batiment integer,
1652     erp_ouvert boolean,
1653     erp_date_ouverture date,
1654     erp_arrete_decision boolean,
1655     erp_date_arrete_decision date,
1656     numero_version integer DEFAULT 0,
1657     etat_dossier_autorisation integer,
1658     date_depot date,
1659     date_decision date,
1660     date_validite date,
1661     date_chantier date,
1662     date_achevement date,
1663     avis_decision integer,
1664     etat_dernier_dossier_instruction_accepte integer
1665     );
1666    
1667 fmichon 1844
1668 fmichon 1801 --
1669     -- Name: dossier_autorisation_type; Type: TABLE; Schema: openads; Owner: -; Tablespace:
1670     --
1671    
1672     CREATE TABLE dossier_autorisation_type (
1673     dossier_autorisation_type integer NOT NULL,
1674     code character varying(20) NOT NULL,
1675     libelle character varying(100),
1676     description text,
1677     confidentiel boolean DEFAULT false,
1678     groupe integer
1679     );
1680    
1681    
1682     --
1683     -- Name: dossier_autorisation_type_detaille; Type: TABLE; Schema: openads; Owner: -; Tablespace:
1684     --
1685    
1686     CREATE TABLE dossier_autorisation_type_detaille (
1687     dossier_autorisation_type_detaille integer NOT NULL,
1688     code character varying(20),
1689     libelle character varying(100),
1690     description text,
1691     dossier_autorisation_type integer NOT NULL
1692     );
1693    
1694    
1695     --
1696     -- Name: dossier_autorisation_type_detaille_seq; Type: SEQUENCE; Schema: openads; Owner: -
1697     --
1698    
1699     CREATE SEQUENCE dossier_autorisation_type_detaille_seq
1700     START WITH 1
1701     INCREMENT BY 1
1702     NO MINVALUE
1703     NO MAXVALUE
1704     CACHE 1;
1705    
1706    
1707     --
1708     -- Name: dossier_autorisation_type_detaille_seq; Type: SEQUENCE OWNED BY; Schema: openads; Owner: -
1709     --
1710    
1711     ALTER SEQUENCE dossier_autorisation_type_detaille_seq OWNED BY dossier_autorisation_type_detaille.dossier_autorisation_type_detaille;
1712    
1713    
1714     --
1715     -- Name: dossier_autorisation_type_seq; Type: SEQUENCE; Schema: openads; Owner: -
1716     --
1717    
1718     CREATE SEQUENCE dossier_autorisation_type_seq
1719     START WITH 1
1720     INCREMENT BY 1
1721     NO MINVALUE
1722     NO MAXVALUE
1723     CACHE 1;
1724    
1725    
1726     --
1727     -- Name: dossier_autorisation_type_seq; Type: SEQUENCE OWNED BY; Schema: openads; Owner: -
1728     --
1729    
1730     ALTER SEQUENCE dossier_autorisation_type_seq OWNED BY dossier_autorisation_type.dossier_autorisation_type;
1731    
1732    
1733     --
1734     -- Name: dossier_az_seq; Type: SEQUENCE; Schema: openads; Owner: -
1735     --
1736    
1737     CREATE SEQUENCE dossier_az_seq
1738     START WITH 1
1739     INCREMENT BY 1
1740     NO MINVALUE
1741     NO MAXVALUE
1742     CACHE 1;
1743    
1744    
1745     --
1746     -- Name: dossier_commission; Type: TABLE; Schema: openads; Owner: -; Tablespace:
1747     --
1748    
1749     CREATE TABLE dossier_commission (
1750     dossier_commission integer NOT NULL,
1751     dossier character varying(20) NOT NULL,
1752     commission_type integer NOT NULL,
1753     date_souhaitee date NOT NULL,
1754     motivation text,
1755     commission integer,
1756     avis text,
1757     lu boolean DEFAULT false
1758     );
1759    
1760    
1761     --
1762     -- Name: dossier_commission_seq; Type: SEQUENCE; Schema: openads; Owner: -
1763     --
1764    
1765     CREATE SEQUENCE dossier_commission_seq
1766     START WITH 1
1767     INCREMENT BY 1
1768     NO MINVALUE
1769     NO MAXVALUE
1770     CACHE 1;
1771    
1772    
1773     --
1774     -- Name: dossier_commission_seq; Type: SEQUENCE OWNED BY; Schema: openads; Owner: -
1775     --
1776    
1777     ALTER SEQUENCE dossier_commission_seq OWNED BY dossier_commission.dossier_commission;
1778    
1779    
1780     --
1781     -- Name: dossier_cu_seq; Type: SEQUENCE; Schema: openads; Owner: -
1782     --
1783    
1784     CREATE SEQUENCE dossier_cu_seq
1785     START WITH 1
1786     INCREMENT BY 1
1787     NO MINVALUE
1788     NO MAXVALUE
1789     CACHE 1;
1790    
1791    
1792     --
1793     -- Name: dossier_dat_seq; Type: SEQUENCE; Schema: openads; Owner: -
1794     --
1795    
1796     CREATE SEQUENCE dossier_dat_seq
1797     START WITH 1
1798     INCREMENT BY 1
1799     NO MINVALUE
1800     NO MAXVALUE
1801     CACHE 1;
1802    
1803    
1804     --
1805     -- Name: dossier_dp_seq; Type: SEQUENCE; Schema: openads; Owner: -
1806     --
1807    
1808     CREATE SEQUENCE dossier_dp_seq
1809     START WITH 1
1810     INCREMENT BY 1
1811     NO MINVALUE
1812     NO MAXVALUE
1813     CACHE 1;
1814    
1815    
1816     --
1817     -- Name: dossier_instruction_type; Type: TABLE; Schema: openads; Owner: -; Tablespace:
1818     --
1819    
1820     CREATE TABLE dossier_instruction_type (
1821     dossier_instruction_type integer NOT NULL,
1822     code character varying(20),
1823     libelle character varying(100),
1824     description text,
1825     dossier_autorisation_type_detaille integer NOT NULL,
1826     suffixe boolean DEFAULT false,
1827     cerfa integer,
1828 fmichon 1844 cerfa_lot integer,
1829     mouvement_sitadel character varying(20)
1830 fmichon 1801 );
1831    
1832    
1833     --
1834     -- Name: dossier_instruction_type_seq; Type: SEQUENCE; Schema: openads; Owner: -
1835     --
1836    
1837     CREATE SEQUENCE dossier_instruction_type_seq
1838     START WITH 1
1839     INCREMENT BY 1
1840     NO MINVALUE
1841     NO MAXVALUE
1842     CACHE 1;
1843    
1844    
1845     --
1846     -- Name: dossier_instruction_type_seq; Type: SEQUENCE OWNED BY; Schema: openads; Owner: -
1847     --
1848    
1849     ALTER SEQUENCE dossier_instruction_type_seq OWNED BY dossier_instruction_type.dossier_instruction_type;
1850    
1851    
1852     --
1853     -- Name: dossier_message; Type: TABLE; Schema: openads; Owner: -; Tablespace:
1854     --
1855    
1856     CREATE TABLE dossier_message (
1857     dossier_message integer NOT NULL,
1858     dossier character varying(20),
1859     type character varying(60),
1860     emetteur character varying(40),
1861     date_emission timestamp without time zone NOT NULL,
1862     lu boolean DEFAULT false,
1863     contenu text
1864     );
1865    
1866    
1867     --
1868     -- Name: dossier_message_seq; Type: SEQUENCE; Schema: openads; Owner: -
1869     --
1870    
1871     CREATE SEQUENCE dossier_message_seq
1872     START WITH 1
1873     INCREMENT BY 1
1874     NO MINVALUE
1875     NO MAXVALUE
1876     CACHE 1;
1877    
1878    
1879     --
1880     -- Name: dossier_message_seq; Type: SEQUENCE OWNED BY; Schema: openads; Owner: -
1881     --
1882    
1883     ALTER SEQUENCE dossier_message_seq OWNED BY dossier_message.dossier_message;
1884    
1885    
1886     --
1887     -- Name: dossier_pa_seq; Type: SEQUENCE; Schema: openads; Owner: -
1888     --
1889    
1890     CREATE SEQUENCE dossier_pa_seq
1891     START WITH 1
1892     INCREMENT BY 1
1893     NO MINVALUE
1894     NO MAXVALUE
1895     CACHE 1;
1896    
1897    
1898     --
1899     -- Name: dossier_pc_seq; Type: SEQUENCE; Schema: openads; Owner: -
1900     --
1901    
1902     CREATE SEQUENCE dossier_pc_seq
1903     START WITH 1
1904     INCREMENT BY 1
1905     NO MINVALUE
1906     NO MAXVALUE
1907     CACHE 1;
1908    
1909    
1910     --
1911     -- Name: dossier_pd_seq; Type: SEQUENCE; Schema: openads; Owner: -
1912     --
1913    
1914     CREATE SEQUENCE dossier_pd_seq
1915     START WITH 1
1916     INCREMENT BY 1
1917     NO MINVALUE
1918     NO MAXVALUE
1919     CACHE 1;
1920    
1921    
1922     --
1923     -- Name: etat; Type: TABLE; Schema: openads; Owner: -; Tablespace:
1924     --
1925    
1926     CREATE TABLE etat (
1927     etat character varying(20) NOT NULL,
1928     libelle character varying(50) NOT NULL,
1929     statut character varying(60)
1930     );
1931    
1932    
1933     --
1934     -- Name: etat_dossier_autorisation; Type: TABLE; Schema: openads; Owner: -; Tablespace:
1935     --
1936    
1937     CREATE TABLE etat_dossier_autorisation (
1938     etat_dossier_autorisation integer NOT NULL,
1939     libelle character varying(100)
1940     );
1941    
1942    
1943     --
1944     -- Name: etat_dossier_autorisation_seq; Type: SEQUENCE; Schema: openads; Owner: -
1945     --
1946    
1947     CREATE SEQUENCE etat_dossier_autorisation_seq
1948     START WITH 1
1949     INCREMENT BY 1
1950     NO MINVALUE
1951     NO MAXVALUE
1952     CACHE 1;
1953    
1954    
1955     --
1956     -- Name: etat_dossier_autorisation_seq; Type: SEQUENCE OWNED BY; Schema: openads; Owner: -
1957     --
1958    
1959     ALTER SEQUENCE etat_dossier_autorisation_seq OWNED BY etat_dossier_autorisation.etat_dossier_autorisation;
1960    
1961    
1962     --
1963     -- Name: evenement; Type: TABLE; Schema: openads; Owner: -; Tablespace:
1964     --
1965    
1966     CREATE TABLE evenement (
1967     evenement integer NOT NULL,
1968     libelle character varying(70) NOT NULL,
1969     action character varying(20),
1970     etat character varying(20),
1971     delai integer,
1972     accord_tacite character(3) DEFAULT ''::bpchar NOT NULL,
1973     delai_notification integer,
1974     lettretype character varying(60) DEFAULT ''::character varying NOT NULL,
1975     consultation character(3) DEFAULT ''::bpchar NOT NULL,
1976     avis_decision integer,
1977     restriction character varying(60),
1978     type character varying(100),
1979     evenement_retour_ar integer,
1980     evenement_suivant_tacite integer,
1981     evenement_retour_signature integer
1982     );
1983    
1984    
1985     --
1986     -- Name: evenement_seq; Type: SEQUENCE; Schema: openads; Owner: -
1987     --
1988    
1989     CREATE SEQUENCE evenement_seq
1990     START WITH 1
1991     INCREMENT BY 1
1992     NO MINVALUE
1993     NO MAXVALUE
1994     CACHE 1;
1995    
1996    
1997     --
1998     -- Name: evenement_seq; Type: SEQUENCE OWNED BY; Schema: openads; Owner: -
1999     --
2000    
2001     ALTER SEQUENCE evenement_seq OWNED BY evenement.evenement;
2002    
2003    
2004     --
2005     -- Name: genre; Type: TABLE; Schema: openads; Owner: -; Tablespace:
2006     --
2007    
2008     CREATE TABLE genre (
2009     genre integer NOT NULL,
2010     code character varying(20),
2011     libelle character varying(100),
2012     description text
2013     );
2014    
2015    
2016     --
2017     -- Name: genre_seq; Type: SEQUENCE; Schema: openads; Owner: -
2018     --
2019    
2020     CREATE SEQUENCE genre_seq
2021     START WITH 1
2022     INCREMENT BY 1
2023     NO MINVALUE
2024     NO MAXVALUE
2025     CACHE 1;
2026    
2027    
2028     --
2029     -- Name: genre_seq; Type: SEQUENCE OWNED BY; Schema: openads; Owner: -
2030     --
2031    
2032     ALTER SEQUENCE genre_seq OWNED BY genre.genre;
2033    
2034    
2035     --
2036     -- Name: groupe; Type: TABLE; Schema: openads; Owner: -; Tablespace:
2037     --
2038    
2039     CREATE TABLE groupe (
2040     groupe integer NOT NULL,
2041     code character varying(20),
2042     libelle character varying(100),
2043     description text,
2044     genre integer NOT NULL
2045     );
2046    
2047    
2048     --
2049     -- Name: groupe_seq; Type: SEQUENCE; Schema: openads; Owner: -
2050     --
2051    
2052     CREATE SEQUENCE groupe_seq
2053     START WITH 1
2054     INCREMENT BY 1
2055     NO MINVALUE
2056     NO MAXVALUE
2057     CACHE 1;
2058    
2059    
2060     --
2061     -- Name: groupe_seq; Type: SEQUENCE OWNED BY; Schema: openads; Owner: -
2062     --
2063    
2064     ALTER SEQUENCE groupe_seq OWNED BY groupe.groupe;
2065    
2066    
2067     --
2068     -- Name: instructeur; Type: TABLE; Schema: openads; Owner: -; Tablespace:
2069     --
2070    
2071     CREATE TABLE instructeur (
2072     instructeur integer NOT NULL,
2073     nom character varying(100) NOT NULL,
2074     telephone character varying(14),
2075     division integer NOT NULL,
2076     om_utilisateur integer,
2077     om_validite_debut date,
2078     om_validite_fin date
2079     );
2080    
2081    
2082     --
2083     -- Name: instructeur_seq; Type: SEQUENCE; Schema: openads; Owner: -
2084     --
2085    
2086     CREATE SEQUENCE instructeur_seq
2087     START WITH 1
2088     INCREMENT BY 1
2089     NO MINVALUE
2090     NO MAXVALUE
2091     CACHE 1;
2092    
2093    
2094     --
2095     -- Name: instructeur_seq; Type: SEQUENCE OWNED BY; Schema: openads; Owner: -
2096     --
2097    
2098     ALTER SEQUENCE instructeur_seq OWNED BY instructeur.instructeur;
2099    
2100    
2101     --
2102     -- Name: instruction; Type: TABLE; Schema: openads; Owner: -; Tablespace:
2103     --
2104    
2105     CREATE TABLE instruction (
2106     instruction integer NOT NULL,
2107     destinataire character varying(30) DEFAULT ''::character varying NOT NULL,
2108     date_evenement date NOT NULL,
2109     evenement integer NOT NULL,
2110     lettretype character varying(40) DEFAULT ''::character varying NOT NULL,
2111     complement text,
2112     complement2 text,
2113     dossier character varying(20),
2114     action character varying(20),
2115     delai integer,
2116     etat character varying(20),
2117     accord_tacite character(3) DEFAULT ''::bpchar NOT NULL,
2118     delai_notification integer DEFAULT 0 NOT NULL,
2119     archive_delai bigint DEFAULT (0)::bigint NOT NULL,
2120     archive_date_complet date,
2121     archive_date_rejet date,
2122     archive_date_limite date,
2123     archive_date_notification_delai date,
2124     archive_accord_tacite character(3) DEFAULT ''::bpchar NOT NULL,
2125     archive_etat character varying(20) DEFAULT ''::character varying NOT NULL,
2126     archive_date_decision date,
2127     archive_avis character varying(20) DEFAULT ''::character varying NOT NULL,
2128     archive_date_validite date,
2129     archive_date_achevement date,
2130     archive_date_chantier date,
2131     archive_date_conformite date,
2132     complement3 text,
2133     complement4 text,
2134     complement5 text,
2135     complement6 text,
2136     complement7 text,
2137     complement8 text,
2138     complement9 text,
2139     complement10 text,
2140     complement11 text,
2141     complement12 text,
2142     complement13 text,
2143     complement14 text,
2144     complement15 text,
2145     avis_decision integer,
2146     date_finalisation_courrier date,
2147     date_envoi_signature date,
2148     date_retour_signature date,
2149     date_envoi_rar date,
2150     date_retour_rar date,
2151     date_envoi_controle_legalite date,
2152     date_retour_controle_legalite date,
2153     signataire_arrete integer,
2154     numero_arrete character varying(100),
2155     archive_date_dernier_depot date,
2156     archive_incompletude boolean DEFAULT false NOT NULL,
2157     archive_evenement_suivant_tacite integer,
2158     archive_evenement_suivant_tacite_incompletude integer,
2159     archive_etat_pendant_incompletude character varying(20),
2160     archive_date_limite_incompletude date,
2161 fmichon 1844 archive_delai_incompletude integer,
2162 fmichon 1970 code_barres character varying(12),
2163     om_fichier_instruction character varying(64),
2164     om_final_instruction boolean,
2165 vpihour 2052 document_numerise integer
2166 fmichon 1801 );
2167    
2168    
2169     --
2170     -- Name: instruction_seq; Type: SEQUENCE; Schema: openads; Owner: -
2171     --
2172    
2173     CREATE SEQUENCE instruction_seq
2174     START WITH 1
2175     INCREMENT BY 1
2176     NO MINVALUE
2177     NO MAXVALUE
2178     CACHE 1;
2179    
2180    
2181     --
2182     -- Name: instruction_seq; Type: SEQUENCE OWNED BY; Schema: openads; Owner: -
2183     --
2184    
2185     ALTER SEQUENCE instruction_seq OWNED BY instruction.instruction;
2186    
2187    
2188     --
2189     -- Name: lien_demande_demandeur; Type: TABLE; Schema: openads; Owner: -; Tablespace:
2190     --
2191    
2192     CREATE TABLE lien_demande_demandeur (
2193     lien_demande_demandeur integer NOT NULL,
2194     petitionnaire_principal boolean,
2195     demande integer,
2196     demandeur integer
2197     );
2198    
2199    
2200     --
2201     -- Name: lien_demande_demandeur_seq; Type: SEQUENCE; Schema: openads; Owner: -
2202     --
2203    
2204     CREATE SEQUENCE lien_demande_demandeur_seq
2205     START WITH 1
2206     INCREMENT BY 1
2207     NO MINVALUE
2208     NO MAXVALUE
2209     CACHE 1;
2210    
2211    
2212     --
2213     -- Name: lien_demande_demandeur_seq; Type: SEQUENCE OWNED BY; Schema: openads; Owner: -
2214     --
2215    
2216     ALTER SEQUENCE lien_demande_demandeur_seq OWNED BY lien_demande_demandeur.lien_demande_demandeur;
2217    
2218    
2219     --
2220     -- Name: lien_demande_type_etat_dossier_autorisation; Type: TABLE; Schema: openads; Owner: -; Tablespace:
2221     --
2222    
2223     CREATE TABLE lien_demande_type_etat_dossier_autorisation (
2224     lien_demande_type_etat_dossier_autorisation integer NOT NULL,
2225     demande_type integer NOT NULL,
2226     etat_dossier_autorisation integer NOT NULL
2227     );
2228    
2229    
2230     --
2231     -- Name: lien_demande_type_etat_dossier_autorisation_seq; Type: SEQUENCE; Schema: openads; Owner: -
2232     --
2233    
2234     CREATE SEQUENCE lien_demande_type_etat_dossier_autorisation_seq
2235     START WITH 1
2236     INCREMENT BY 1
2237     NO MINVALUE
2238     NO MAXVALUE
2239     CACHE 1;
2240    
2241    
2242     --
2243     -- Name: lien_demande_type_etat_dossier_autorisation_seq; Type: SEQUENCE OWNED BY; Schema: openads; Owner: -
2244     --
2245    
2246     ALTER SEQUENCE lien_demande_type_etat_dossier_autorisation_seq OWNED BY lien_demande_type_etat_dossier_autorisation.lien_demande_type_etat_dossier_autorisation;
2247    
2248    
2249     --
2250     -- Name: lien_dossier_autorisation_demandeur; Type: TABLE; Schema: openads; Owner: -; Tablespace:
2251     --
2252    
2253     CREATE TABLE lien_dossier_autorisation_demandeur (
2254     lien_dossier_autorisation_demandeur integer NOT NULL,
2255     petitionnaire_principal boolean,
2256     dossier_autorisation character varying(20),
2257     demandeur integer
2258     );
2259    
2260    
2261     --
2262     -- Name: lien_dossier_autorisation_demandeur_seq; Type: SEQUENCE; Schema: openads; Owner: -
2263     --
2264    
2265     CREATE SEQUENCE lien_dossier_autorisation_demandeur_seq
2266     START WITH 1
2267     INCREMENT BY 1
2268     NO MINVALUE
2269     NO MAXVALUE
2270     CACHE 1;
2271    
2272    
2273     --
2274     -- Name: lien_dossier_autorisation_demandeur_seq; Type: SEQUENCE OWNED BY; Schema: openads; Owner: -
2275     --
2276    
2277     ALTER SEQUENCE lien_dossier_autorisation_demandeur_seq OWNED BY lien_dossier_autorisation_demandeur.lien_dossier_autorisation_demandeur;
2278    
2279    
2280     --
2281     -- Name: lien_dossier_demandeur; Type: TABLE; Schema: openads; Owner: -; Tablespace:
2282     --
2283    
2284     CREATE TABLE lien_dossier_demandeur (
2285     lien_dossier_demandeur integer NOT NULL,
2286     petitionnaire_principal boolean,
2287     dossier character varying(20),
2288     demandeur integer
2289     );
2290    
2291    
2292     --
2293     -- Name: lien_dossier_demandeur_seq; Type: SEQUENCE; Schema: openads; Owner: -
2294     --
2295    
2296     CREATE SEQUENCE lien_dossier_demandeur_seq
2297     START WITH 1
2298     INCREMENT BY 1
2299     NO MINVALUE
2300     NO MAXVALUE
2301     CACHE 1;
2302    
2303    
2304     --
2305     -- Name: lien_dossier_demandeur_seq; Type: SEQUENCE OWNED BY; Schema: openads; Owner: -
2306     --
2307    
2308     ALTER SEQUENCE lien_dossier_demandeur_seq OWNED BY lien_dossier_demandeur.lien_dossier_demandeur;
2309    
2310    
2311     --
2312     -- Name: lien_dossier_instruction_type_evenement; Type: TABLE; Schema: openads; Owner: -; Tablespace:
2313     --
2314    
2315     CREATE TABLE lien_dossier_instruction_type_evenement (
2316     lien_dossier_instruction_type_evenement integer NOT NULL,
2317     dossier_instruction_type integer,
2318     evenement integer
2319     );
2320    
2321    
2322     --
2323     -- Name: lien_dossier_instruction_type_evenement_seq; Type: SEQUENCE; Schema: openads; Owner: -
2324     --
2325    
2326     CREATE SEQUENCE lien_dossier_instruction_type_evenement_seq
2327     START WITH 1
2328     INCREMENT BY 1
2329     NO MINVALUE
2330     NO MAXVALUE
2331     CACHE 1;
2332    
2333    
2334     --
2335     -- Name: lien_dossier_instruction_type_evenement_seq; Type: SEQUENCE OWNED BY; Schema: openads; Owner: -
2336     --
2337    
2338     ALTER SEQUENCE lien_dossier_instruction_type_evenement_seq OWNED BY lien_dossier_instruction_type_evenement.lien_dossier_instruction_type_evenement;
2339    
2340    
2341     --
2342     -- Name: lien_dossier_lot; Type: TABLE; Schema: openads; Owner: -; Tablespace:
2343     --
2344    
2345     CREATE TABLE lien_dossier_lot (
2346     lien_dossier_lot integer NOT NULL,
2347     dossier character varying(20),
2348     lot integer
2349     );
2350    
2351    
2352     --
2353     -- Name: lien_dossier_lot_seq; Type: SEQUENCE; Schema: openads; Owner: -
2354     --
2355    
2356     CREATE SEQUENCE lien_dossier_lot_seq
2357     START WITH 1
2358     INCREMENT BY 1
2359     NO MINVALUE
2360     NO MAXVALUE
2361     CACHE 1;
2362    
2363    
2364     --
2365     -- Name: lien_dossier_lot_seq; Type: SEQUENCE OWNED BY; Schema: openads; Owner: -
2366     --
2367    
2368     ALTER SEQUENCE lien_dossier_lot_seq OWNED BY lien_dossier_lot.lien_dossier_lot;
2369    
2370    
2371     --
2372     -- Name: lien_evenement_dossier_autorisation_type; Type: TABLE; Schema: openads; Owner: -; Tablespace:
2373     --
2374    
2375     CREATE TABLE lien_evenement_dossier_autorisation_type (
2376     lien_evenement_dossier_autorisation_type integer NOT NULL,
2377     evenement integer,
2378     dossier_autorisation_type integer
2379     );
2380    
2381    
2382     --
2383     -- Name: lien_evenement_dossier_autorisation_type_seq; Type: SEQUENCE; Schema: openads; Owner: -
2384     --
2385    
2386     CREATE SEQUENCE lien_evenement_dossier_autorisation_type_seq
2387     START WITH 1
2388     INCREMENT BY 1
2389     NO MINVALUE
2390     NO MAXVALUE
2391     CACHE 1;
2392    
2393    
2394     --
2395     -- Name: lien_evenement_dossier_autorisation_type_seq; Type: SEQUENCE OWNED BY; Schema: openads; Owner: -
2396     --
2397    
2398     ALTER SEQUENCE lien_evenement_dossier_autorisation_type_seq OWNED BY lien_evenement_dossier_autorisation_type.lien_evenement_dossier_autorisation_type;
2399    
2400    
2401     --
2402     -- Name: lien_lot_demandeur; Type: TABLE; Schema: openads; Owner: -; Tablespace:
2403     --
2404    
2405     CREATE TABLE lien_lot_demandeur (
2406     lien_lot_demandeur integer NOT NULL,
2407     lot integer,
2408     demandeur integer,
2409     petitionnaire_principal boolean
2410     );
2411    
2412    
2413     --
2414     -- Name: lien_lot_demandeur_seq; Type: SEQUENCE; Schema: openads; Owner: -
2415     --
2416    
2417     CREATE SEQUENCE lien_lot_demandeur_seq
2418     START WITH 1
2419     INCREMENT BY 1
2420     NO MINVALUE
2421     NO MAXVALUE
2422     CACHE 1;
2423    
2424    
2425     --
2426     -- Name: lien_lot_demandeur_seq; Type: SEQUENCE OWNED BY; Schema: openads; Owner: -
2427     --
2428    
2429     ALTER SEQUENCE lien_lot_demandeur_seq OWNED BY lien_lot_demandeur.lien_lot_demandeur;
2430    
2431    
2432     --
2433     -- Name: lien_service_om_utilisateur; Type: TABLE; Schema: openads; Owner: -; Tablespace:
2434     --
2435    
2436     CREATE TABLE lien_service_om_utilisateur (
2437     lien_service_om_utilisateur integer NOT NULL,
2438     om_utilisateur bigint,
2439     service integer
2440     );
2441    
2442    
2443     --
2444     -- Name: lien_service_om_utilisateur_seq; Type: SEQUENCE; Schema: openads; Owner: -
2445     --
2446    
2447     CREATE SEQUENCE lien_service_om_utilisateur_seq
2448     START WITH 1
2449     INCREMENT BY 1
2450     NO MINVALUE
2451     NO MAXVALUE
2452     CACHE 1;
2453    
2454    
2455     --
2456     -- Name: lien_service_om_utilisateur_seq; Type: SEQUENCE OWNED BY; Schema: openads; Owner: -
2457     --
2458    
2459     ALTER SEQUENCE lien_service_om_utilisateur_seq OWNED BY lien_service_om_utilisateur.lien_service_om_utilisateur;
2460    
2461    
2462     --
2463     -- Name: lien_service_service_categorie; Type: TABLE; Schema: openads; Owner: -; Tablespace:
2464     --
2465    
2466     CREATE TABLE lien_service_service_categorie (
2467     lien_service_service_categorie integer NOT NULL,
2468     service_categorie integer,
2469     service integer
2470     );
2471    
2472    
2473     --
2474     -- Name: lien_service_service_categorie_seq; Type: SEQUENCE; Schema: openads; Owner: -
2475     --
2476    
2477     CREATE SEQUENCE lien_service_service_categorie_seq
2478     START WITH 1
2479     INCREMENT BY 1
2480     NO MINVALUE
2481     NO MAXVALUE
2482     CACHE 1;
2483    
2484    
2485     --
2486     -- Name: lien_service_service_categorie_seq; Type: SEQUENCE OWNED BY; Schema: openads; Owner: -
2487     --
2488    
2489     ALTER SEQUENCE lien_service_service_categorie_seq OWNED BY lien_service_service_categorie.lien_service_service_categorie;
2490    
2491    
2492     --
2493     -- Name: lot; Type: TABLE; Schema: openads; Owner: -; Tablespace:
2494     --
2495    
2496     CREATE TABLE lot (
2497     lot integer NOT NULL,
2498     libelle character varying(80) NOT NULL,
2499     dossier_autorisation character varying(20)
2500     );
2501    
2502    
2503     --
2504     -- Name: lot_seq; Type: SEQUENCE; Schema: openads; Owner: -
2505     --
2506    
2507     CREATE SEQUENCE lot_seq
2508     START WITH 1
2509     INCREMENT BY 1
2510     NO MINVALUE
2511     NO MAXVALUE
2512     CACHE 1;
2513    
2514    
2515     --
2516     -- Name: lot_seq; Type: SEQUENCE OWNED BY; Schema: openads; Owner: -
2517     --
2518    
2519     ALTER SEQUENCE lot_seq OWNED BY lot.lot;
2520    
2521    
2522     --
2523     -- Name: parametre; Type: TABLE; Schema: openads; Owner: -; Tablespace:
2524     --
2525    
2526     CREATE TABLE parametre (
2527     parametre character varying(20) NOT NULL,
2528     libelle character varying(50) NOT NULL,
2529     actif character(3),
2530     sitadel character(3),
2531     longueur_champ integer,
2532     type_champ character varying(20),
2533     valeur_autorisee character varying(50)
2534     );
2535    
2536    
2537     SET default_with_oids = true;
2538    
2539     --
2540     -- Name: parcelle; Type: TABLE; Schema: openads; Owner: -; Tablespace:
2541     --
2542    
2543     CREATE TABLE parcelle (
2544     parcelle character varying(20) NOT NULL,
2545     debut character varying(4) DEFAULT ''::character varying NOT NULL,
2546     rivoli character varying(4),
2547     proprietaire character varying(6),
2548     pos character varying(6),
2549     surface double precision,
2550     section character varying(7),
2551     commune character varying(5),
2552 vpihour 2052 geom public.geometry(Polygon,2154)
2553 fmichon 1801 );
2554    
2555    
2556     SET default_with_oids = false;
2557    
2558     --
2559     -- Name: parcelle_lot; Type: TABLE; Schema: openads; Owner: -; Tablespace:
2560     --
2561    
2562     CREATE TABLE parcelle_lot (
2563     parcelle_lot integer NOT NULL,
2564     lotissement character varying(50) NOT NULL,
2565     numero character varying(16),
2566     surface numeric(10,3),
2567 vpihour 2052 geom public.geometry(Polygon,2154)
2568 fmichon 1801 );
2569    
2570    
2571     --
2572     -- Name: parcelle_lot_seq; Type: SEQUENCE; Schema: openads; Owner: -
2573     --
2574    
2575     CREATE SEQUENCE parcelle_lot_seq
2576     START WITH 1
2577     INCREMENT BY 1
2578     NO MINVALUE
2579     NO MAXVALUE
2580     CACHE 1;
2581    
2582    
2583     --
2584     -- Name: parcelle_lot_seq; Type: SEQUENCE OWNED BY; Schema: openads; Owner: -
2585     --
2586    
2587     ALTER SEQUENCE parcelle_lot_seq OWNED BY parcelle_lot.parcelle_lot;
2588    
2589    
2590     --
2591     -- Name: pos; Type: TABLE; Schema: openads; Owner: -; Tablespace:
2592     --
2593    
2594     CREATE TABLE pos (
2595     pos character varying(10) NOT NULL,
2596     libelle character varying(40) NOT NULL,
2597 vpihour 2052 geom public.geometry(Polygon,2154)
2598 fmichon 1801 );
2599    
2600    
2601     --
2602     -- Name: proprietaire; Type: TABLE; Schema: openads; Owner: -; Tablespace:
2603     --
2604    
2605     CREATE TABLE proprietaire (
2606     proprietaire character varying(6) NOT NULL,
2607     nom character varying(36) DEFAULT ''::character varying NOT NULL,
2608     prenom character varying(36) DEFAULT ''::character varying NOT NULL,
2609     adresse1 character varying(36) DEFAULT ''::character varying NOT NULL,
2610     adresse2 character varying(36) DEFAULT ''::character varying NOT NULL,
2611     cp character varying(5) DEFAULT ''::character varying NOT NULL,
2612     ville character varying(36) DEFAULT ''::character varying NOT NULL,
2613     civilite integer
2614     );
2615    
2616    
2617     --
2618     -- Name: quartier; Type: TABLE; Schema: openads; Owner: -; Tablespace:
2619     --
2620    
2621     CREATE TABLE quartier (
2622     quartier integer NOT NULL,
2623     arrondissement integer NOT NULL,
2624     code_impots character varying(3) NOT NULL,
2625     libelle character varying(40) NOT NULL
2626     );
2627    
2628    
2629     --
2630     -- Name: quartier_seq; Type: SEQUENCE; Schema: openads; Owner: -
2631     --
2632    
2633     CREATE SEQUENCE quartier_seq
2634     START WITH 1
2635     INCREMENT BY 1
2636     NO MINVALUE
2637     NO MAXVALUE
2638     CACHE 1;
2639    
2640    
2641     --
2642     -- Name: quartier_seq; Type: SEQUENCE OWNED BY; Schema: openads; Owner: -
2643     --
2644    
2645     ALTER SEQUENCE quartier_seq OWNED BY quartier.quartier;
2646    
2647    
2648     --
2649     -- Name: rapport_instruction; Type: TABLE; Schema: openads; Owner: -; Tablespace:
2650     --
2651    
2652     CREATE TABLE rapport_instruction (
2653     rapport_instruction integer NOT NULL,
2654     dossier_instruction character varying(20),
2655     analyse_reglementaire text,
2656     description_projet text,
2657 fmichon 1970 proposition_decision text,
2658     om_fichier_rapport_instruction character varying(64),
2659     om_final_rapport_instruction boolean
2660 fmichon 1801 );
2661    
2662    
2663     --
2664     -- Name: rapport_instruction_seq; Type: SEQUENCE; Schema: openads; Owner: -
2665     --
2666    
2667     CREATE SEQUENCE rapport_instruction_seq
2668     START WITH 1
2669     INCREMENT BY 1
2670     NO MINVALUE
2671     NO MAXVALUE
2672     CACHE 1;
2673    
2674    
2675     --
2676     -- Name: rapport_instruction_seq; Type: SEQUENCE OWNED BY; Schema: openads; Owner: -
2677     --
2678    
2679     ALTER SEQUENCE rapport_instruction_seq OWNED BY rapport_instruction.rapport_instruction;
2680    
2681    
2682     --
2683     -- Name: regle; Type: TABLE; Schema: openads; Owner: -; Tablespace:
2684     --
2685    
2686     CREATE TABLE regle (
2687     regle integer NOT NULL,
2688     sens character varying(5) NOT NULL,
2689     ordre integer NOT NULL,
2690     controle character varying(20) DEFAULT ''::character varying NOT NULL,
2691     id integer DEFAULT 0 NOT NULL,
2692     champ character varying(30) NOT NULL,
2693     operateur character(2) NOT NULL,
2694     valeur double precision NOT NULL,
2695     message character varying(80) NOT NULL
2696     );
2697    
2698    
2699     --
2700     -- Name: regle_seq; Type: SEQUENCE; Schema: openads; Owner: -
2701     --
2702    
2703     CREATE SEQUENCE regle_seq
2704     START WITH 1
2705     INCREMENT BY 1
2706     NO MINVALUE
2707     NO MAXVALUE
2708     CACHE 1;
2709    
2710    
2711     --
2712     -- Name: regle_seq; Type: SEQUENCE OWNED BY; Schema: openads; Owner: -
2713     --
2714    
2715     ALTER SEQUENCE regle_seq OWNED BY regle.regle;
2716    
2717    
2718     --
2719     -- Name: rivoli; Type: TABLE; Schema: openads; Owner: -; Tablespace:
2720     --
2721    
2722     CREATE TABLE rivoli (
2723     rivoli character varying(4) NOT NULL,
2724     libelle character varying(40) NOT NULL
2725     );
2726    
2727    
2728     --
2729     -- Name: service; Type: TABLE; Schema: openads; Owner: -; Tablespace:
2730     --
2731    
2732     CREATE TABLE service (
2733     abrege character varying(5) NOT NULL,
2734     libelle character varying(70) NOT NULL,
2735     adresse character varying(40) DEFAULT ''::character varying NOT NULL,
2736     adresse2 character varying(39) DEFAULT ''::character varying NOT NULL,
2737     cp character varying(5) DEFAULT ''::character varying NOT NULL,
2738     ville character varying(30) DEFAULT ''::character varying NOT NULL,
2739     email character varying(50) DEFAULT ''::character varying NOT NULL,
2740     delai integer,
2741     service integer NOT NULL,
2742     consultation_papier boolean,
2743     notification_email boolean,
2744     om_validite_debut date,
2745     om_validite_fin date,
2746     type_consultation character varying(70) DEFAULT 'avec_avis_attendu'::character varying NOT NULL
2747     );
2748    
2749    
2750     --
2751     -- Name: service_categorie; Type: TABLE; Schema: openads; Owner: -; Tablespace:
2752     --
2753    
2754     CREATE TABLE service_categorie (
2755     service_categorie integer NOT NULL,
2756     libelle character varying(70) DEFAULT ''::character varying NOT NULL
2757     );
2758    
2759    
2760     --
2761     -- Name: service_categorie_seq; Type: SEQUENCE; Schema: openads; Owner: -
2762     --
2763    
2764     CREATE SEQUENCE service_categorie_seq
2765     START WITH 1
2766     INCREMENT BY 1
2767     NO MINVALUE
2768     NO MAXVALUE
2769     CACHE 1;
2770    
2771    
2772     --
2773     -- Name: service_categorie_seq; Type: SEQUENCE OWNED BY; Schema: openads; Owner: -
2774     --
2775    
2776     ALTER SEQUENCE service_categorie_seq OWNED BY service_categorie.service_categorie;
2777    
2778    
2779     --
2780     -- Name: service_seq; Type: SEQUENCE; Schema: openads; Owner: -
2781     --
2782    
2783     CREATE SEQUENCE service_seq
2784     START WITH 1
2785     INCREMENT BY 1
2786     NO MINVALUE
2787     NO MAXVALUE
2788     CACHE 1;
2789    
2790    
2791     --
2792     -- Name: service_seq; Type: SEQUENCE OWNED BY; Schema: openads; Owner: -
2793     --
2794    
2795     ALTER SEQUENCE service_seq OWNED BY service.service;
2796    
2797    
2798     --
2799     -- Name: servitude_ligne; Type: TABLE; Schema: openads; Owner: -; Tablespace:
2800     --
2801    
2802     CREATE TABLE servitude_ligne (
2803     servitude_ligne integer NOT NULL,
2804     libelle character varying(20) NOT NULL,
2805     observation character varying(80),
2806     perimetre integer,
2807     description text,
2808 vpihour 2052 geom public.geometry(LineString,2154)
2809 fmichon 1801 );
2810    
2811    
2812     --
2813     -- Name: servitude_ligne_seq; Type: SEQUENCE; Schema: openads; Owner: -
2814     --
2815    
2816     CREATE SEQUENCE servitude_ligne_seq
2817     START WITH 1
2818     INCREMENT BY 1
2819     NO MINVALUE
2820     NO MAXVALUE
2821     CACHE 1;
2822    
2823    
2824     --
2825     -- Name: servitude_ligne_seq; Type: SEQUENCE OWNED BY; Schema: openads; Owner: -
2826     --
2827    
2828     ALTER SEQUENCE servitude_ligne_seq OWNED BY servitude_ligne.servitude_ligne;
2829    
2830    
2831     --
2832     -- Name: servitude_point; Type: TABLE; Schema: openads; Owner: -; Tablespace:
2833     --
2834    
2835     CREATE TABLE servitude_point (
2836     servitude_point integer NOT NULL,
2837     libelle character varying(20) NOT NULL,
2838     observation character varying(80),
2839     perimetre integer,
2840     description text,
2841 vpihour 2052 geom public.geometry(Point,2154)
2842 fmichon 1801 );
2843    
2844    
2845     --
2846     -- Name: servitude_point_seq; Type: SEQUENCE; Schema: openads; Owner: -
2847     --
2848    
2849     CREATE SEQUENCE servitude_point_seq
2850     START WITH 1
2851     INCREMENT BY 1
2852     NO MINVALUE
2853     NO MAXVALUE
2854     CACHE 1;
2855    
2856    
2857     --
2858     -- Name: servitude_point_seq; Type: SEQUENCE OWNED BY; Schema: openads; Owner: -
2859     --
2860    
2861     ALTER SEQUENCE servitude_point_seq OWNED BY servitude_point.servitude_point;
2862    
2863    
2864     --
2865     -- Name: servitude_surfacique; Type: TABLE; Schema: openads; Owner: -; Tablespace:
2866     --
2867    
2868     CREATE TABLE servitude_surfacique (
2869     servitude_surfacique integer NOT NULL,
2870     libelle character varying(20) NOT NULL,
2871     observation character varying(80),
2872     perimetre integer,
2873     description text,
2874 vpihour 2052 geom public.geometry(Polygon,2154)
2875 fmichon 1801 );
2876    
2877    
2878     --
2879     -- Name: servitude_surfacique_seq; Type: SEQUENCE; Schema: openads; Owner: -
2880     --
2881    
2882     CREATE SEQUENCE servitude_surfacique_seq
2883     START WITH 1
2884     INCREMENT BY 1
2885     NO MINVALUE
2886     NO MAXVALUE
2887     CACHE 1;
2888    
2889    
2890     --
2891     -- Name: servitude_surfacique_seq; Type: SEQUENCE OWNED BY; Schema: openads; Owner: -
2892     --
2893    
2894     ALTER SEQUENCE servitude_surfacique_seq OWNED BY servitude_surfacique.servitude_surfacique;
2895    
2896    
2897     --
2898     -- Name: signataire_arrete; Type: TABLE; Schema: openads; Owner: -; Tablespace:
2899     --
2900    
2901     CREATE TABLE signataire_arrete (
2902     signataire_arrete integer NOT NULL,
2903     civilite integer,
2904     nom character varying(80),
2905     prenom character varying(80),
2906     qualite character varying(80),
2907     signature text,
2908     defaut boolean,
2909     om_validite_debut date,
2910     om_validite_fin date
2911     );
2912    
2913    
2914     --
2915     -- Name: signataire_arrete_seq; Type: SEQUENCE; Schema: openads; Owner: -
2916     --
2917    
2918     CREATE SEQUENCE signataire_arrete_seq
2919     START WITH 1
2920     INCREMENT BY 1
2921     NO MINVALUE
2922     NO MAXVALUE
2923     CACHE 1;
2924    
2925    
2926     --
2927     -- Name: signataire_arrete_seq; Type: SEQUENCE OWNED BY; Schema: openads; Owner: -
2928     --
2929    
2930     ALTER SEQUENCE signataire_arrete_seq OWNED BY signataire_arrete.signataire_arrete;
2931    
2932    
2933     --
2934     -- Name: terrain; Type: TABLE; Schema: openads; Owner: -; Tablespace:
2935     --
2936    
2937     CREATE TABLE terrain (
2938     terrain integer NOT NULL,
2939     dossier character varying(20),
2940     parcelle character varying(20),
2941     nom character varying(60) DEFAULT ''::character varying NOT NULL
2942     );
2943    
2944    
2945     --
2946     -- Name: terrain_seq; Type: SEQUENCE; Schema: openads; Owner: -
2947     --
2948    
2949     CREATE SEQUENCE terrain_seq
2950     START WITH 1
2951     INCREMENT BY 1
2952     NO MINVALUE
2953     NO MAXVALUE
2954     CACHE 1;
2955    
2956    
2957     --
2958     -- Name: terrain_seq; Type: SEQUENCE OWNED BY; Schema: openads; Owner: -
2959     --
2960    
2961     ALTER SEQUENCE terrain_seq OWNED BY terrain.terrain;
2962    
2963    
2964     --
2965     -- Name: transition; Type: TABLE; Schema: openads; Owner: -; Tablespace:
2966     --
2967    
2968     CREATE TABLE transition (
2969     transition integer NOT NULL,
2970     etat character varying(20) NOT NULL,
2971     evenement integer NOT NULL
2972     );
2973    
2974    
2975     --
2976     -- Name: transition_seq; Type: SEQUENCE; Schema: openads; Owner: -
2977     --
2978    
2979     CREATE SEQUENCE transition_seq
2980     START WITH 1
2981     INCREMENT BY 1
2982     NO MINVALUE
2983     NO MAXVALUE
2984     CACHE 1;
2985    
2986    
2987     --
2988     -- Name: transition_seq; Type: SEQUENCE OWNED BY; Schema: openads; Owner: -
2989     --
2990    
2991     ALTER SEQUENCE transition_seq OWNED BY transition.transition;
2992    
2993    
2994     --
2995     -- Name: travaux; Type: TABLE; Schema: openads; Owner: -; Tablespace:
2996     --
2997    
2998     CREATE TABLE travaux (
2999     travaux integer NOT NULL,
3000     libelle character varying(80) NOT NULL,
3001     codelascot character(1) DEFAULT ''::bpchar NOT NULL,
3002     solde character(3) DEFAULT ''::bpchar NOT NULL,
3003     dossier_autorisation_type integer
3004     );
3005    
3006    
3007     --
3008     -- Name: travaux_seq; Type: SEQUENCE; Schema: openads; Owner: -
3009     --
3010    
3011     CREATE SEQUENCE travaux_seq
3012     START WITH 1
3013     INCREMENT BY 1
3014     NO MINVALUE
3015     NO MAXVALUE
3016     CACHE 1;
3017    
3018    
3019     --
3020     -- Name: travaux_seq; Type: SEQUENCE OWNED BY; Schema: openads; Owner: -
3021     --
3022    
3023     ALTER SEQUENCE travaux_seq OWNED BY travaux.travaux;
3024    
3025    
3026     --
3027     -- Name: transition; Type: DEFAULT; Schema: openads; Owner: -
3028     --
3029    
3030     ALTER TABLE ONLY transition ALTER COLUMN transition SET DEFAULT nextval('transition_seq'::regclass);
3031    
3032    
3033     --
3034     -- Name: action_pkey; Type: CONSTRAINT; Schema: openads; Owner: -; Tablespace:
3035     --
3036    
3037     ALTER TABLE ONLY action
3038     ADD CONSTRAINT action_pkey PRIMARY KEY (action);
3039    
3040    
3041     --
3042     -- Name: affectation_automatique_pkey; Type: CONSTRAINT; Schema: openads; Owner: -; Tablespace:
3043     --
3044    
3045     ALTER TABLE ONLY affectation_automatique
3046     ADD CONSTRAINT affectation_automatique_pkey PRIMARY KEY (affectation_automatique);
3047    
3048    
3049     --
3050     -- Name: architecte_pkey; Type: CONSTRAINT; Schema: openads; Owner: -; Tablespace:
3051     --
3052    
3053     ALTER TABLE ONLY architecte
3054     ADD CONSTRAINT architecte_pkey PRIMARY KEY (architecte);
3055    
3056    
3057     --
3058     -- Name: arrondissement_pkey; Type: CONSTRAINT; Schema: openads; Owner: -; Tablespace:
3059     --
3060    
3061     ALTER TABLE ONLY arrondissement
3062     ADD CONSTRAINT arrondissement_pkey PRIMARY KEY (arrondissement);
3063    
3064    
3065     --
3066     -- Name: autorite_competente_pkey; Type: CONSTRAINT; Schema: openads; Owner: -; Tablespace:
3067     --
3068    
3069     ALTER TABLE ONLY autorite_competente
3070     ADD CONSTRAINT autorite_competente_pkey PRIMARY KEY (autorite_competente);
3071    
3072    
3073     --
3074     -- Name: avis_consultation_pkey; Type: CONSTRAINT; Schema: openads; Owner: -; Tablespace:
3075     --
3076    
3077     ALTER TABLE ONLY avis_consultation
3078     ADD CONSTRAINT avis_consultation_pkey PRIMARY KEY (avis_consultation);
3079    
3080    
3081     --
3082     -- Name: avis_decision_pkey; Type: CONSTRAINT; Schema: openads; Owner: -; Tablespace:
3083     --
3084    
3085     ALTER TABLE ONLY avis_decision
3086     ADD CONSTRAINT avis_decision_pkey PRIMARY KEY (avis_decision);
3087    
3088    
3089     --
3090     -- Name: bible_pkey; Type: CONSTRAINT; Schema: openads; Owner: -; Tablespace:
3091     --
3092    
3093     ALTER TABLE ONLY bible
3094     ADD CONSTRAINT bible_pkey PRIMARY KEY (bible);
3095    
3096    
3097     --
3098     -- Name: blocnote_pkey; Type: CONSTRAINT; Schema: openads; Owner: -; Tablespace:
3099     --
3100    
3101     ALTER TABLE ONLY blocnote
3102     ADD CONSTRAINT blocnote_pkey PRIMARY KEY (blocnote);
3103    
3104    
3105     --
3106     -- Name: categorie_demandeur_pkey; Type: CONSTRAINT; Schema: openads; Owner: -; Tablespace:
3107     --
3108    
3109     ALTER TABLE ONLY categorie_demandeur
3110     ADD CONSTRAINT categorie_demandeur_pkey PRIMARY KEY (categorie_demandeur);
3111    
3112    
3113     --
3114     -- Name: cerfa_pkey; Type: CONSTRAINT; Schema: openads; Owner: -; Tablespace:
3115     --
3116    
3117     ALTER TABLE ONLY cerfa
3118     ADD CONSTRAINT cerfa_pkey PRIMARY KEY (cerfa);
3119    
3120    
3121     --
3122     -- Name: civilite_pkey; Type: CONSTRAINT; Schema: openads; Owner: -; Tablespace:
3123     --
3124    
3125     ALTER TABLE ONLY civilite
3126     ADD CONSTRAINT civilite_pkey PRIMARY KEY (civilite);
3127    
3128    
3129     --
3130     -- Name: code_unique; Type: CONSTRAINT; Schema: openads; Owner: -; Tablespace:
3131     --
3132    
3133     ALTER TABLE ONLY dossier_autorisation_type
3134     ADD CONSTRAINT code_unique UNIQUE (code);
3135    
3136    
3137     --
3138     -- Name: commission_pkey; Type: CONSTRAINT; Schema: openads; Owner: -; Tablespace:
3139     --
3140    
3141     ALTER TABLE ONLY commission
3142     ADD CONSTRAINT commission_pkey PRIMARY KEY (commission);
3143    
3144    
3145     --
3146     -- Name: commission_type_pkey; Type: CONSTRAINT; Schema: openads; Owner: -; Tablespace:
3147     --
3148    
3149     ALTER TABLE ONLY commission_type
3150     ADD CONSTRAINT commission_type_pkey PRIMARY KEY (commission_type);
3151    
3152    
3153     --
3154     -- Name: consultation_pkey; Type: CONSTRAINT; Schema: openads; Owner: -; Tablespace:
3155     --
3156    
3157     ALTER TABLE ONLY consultation
3158     ADD CONSTRAINT consultation_pkey PRIMARY KEY (consultation);
3159    
3160    
3161     --
3162     -- Name: demande_nature_pkey; Type: CONSTRAINT; Schema: openads; Owner: -; Tablespace:
3163     --
3164    
3165     ALTER TABLE ONLY demande_nature
3166     ADD CONSTRAINT demande_nature_pkey PRIMARY KEY (demande_nature);
3167    
3168    
3169     --
3170     -- Name: demande_pkey; Type: CONSTRAINT; Schema: openads; Owner: -; Tablespace:
3171     --
3172    
3173     ALTER TABLE ONLY demande
3174     ADD CONSTRAINT demande_pkey PRIMARY KEY (demande);
3175    
3176    
3177     --
3178     -- Name: demande_type_pkey; Type: CONSTRAINT; Schema: openads; Owner: -; Tablespace:
3179     --
3180    
3181     ALTER TABLE ONLY demande_type
3182     ADD CONSTRAINT demande_type_pkey PRIMARY KEY (demande_type);
3183    
3184    
3185     --
3186     -- Name: demandeur_pkey; Type: CONSTRAINT; Schema: openads; Owner: -; Tablespace:
3187     --
3188    
3189     ALTER TABLE ONLY demandeur
3190     ADD CONSTRAINT demandeur_pkey PRIMARY KEY (demandeur);
3191    
3192    
3193     --
3194     -- Name: destination_pkey; Type: CONSTRAINT; Schema: openads; Owner: -; Tablespace:
3195     --
3196    
3197     ALTER TABLE ONLY destination
3198     ADD CONSTRAINT destination_pkey PRIMARY KEY (destination);
3199    
3200    
3201     --
3202     -- Name: direction_pkey; Type: CONSTRAINT; Schema: openads; Owner: -; Tablespace:
3203     --
3204    
3205     ALTER TABLE ONLY direction
3206     ADD CONSTRAINT direction_pkey PRIMARY KEY (direction);
3207    
3208    
3209     --
3210     -- Name: division_pkey; Type: CONSTRAINT; Schema: openads; Owner: -; Tablespace:
3211     --
3212    
3213     ALTER TABLE ONLY division
3214     ADD CONSTRAINT division_pkey PRIMARY KEY (division);
3215    
3216    
3217     --
3218 fmichon 1970 -- Name: document_numerise_dossier_nom_fichier_key; Type: CONSTRAINT; Schema: openads; Owner: -; Tablespace:
3219     --
3220    
3221     ALTER TABLE ONLY document_numerise
3222     ADD CONSTRAINT document_numerise_dossier_nom_fichier_key UNIQUE (dossier, nom_fichier);
3223    
3224    
3225     --
3226 fmichon 1844 -- Name: document_numerise_pkey; Type: CONSTRAINT; Schema: openads; Owner: -; Tablespace:
3227     --
3228    
3229     ALTER TABLE ONLY document_numerise
3230     ADD CONSTRAINT document_numerise_pkey PRIMARY KEY (document_numerise);
3231    
3232    
3233     --
3234 fmichon 1970 -- Name: document_numerise_type_categorie_pkey; Type: CONSTRAINT; Schema: openads; Owner: -; Tablespace:
3235     --
3236    
3237     ALTER TABLE ONLY document_numerise_type_categorie
3238     ADD CONSTRAINT document_numerise_type_categorie_pkey PRIMARY KEY (document_numerise_type_categorie);
3239    
3240    
3241     --
3242 fmichon 1844 -- Name: document_numerise_type_pkey; Type: CONSTRAINT; Schema: openads; Owner: -; Tablespace:
3243     --
3244    
3245     ALTER TABLE ONLY document_numerise_type
3246     ADD CONSTRAINT document_numerise_type_pkey PRIMARY KEY (document_numerise_type);
3247    
3248    
3249     --
3250     -- Name: document_numerise_uid_key; Type: CONSTRAINT; Schema: openads; Owner: -; Tablespace:
3251     --
3252    
3253     ALTER TABLE ONLY document_numerise
3254     ADD CONSTRAINT document_numerise_uid_key UNIQUE (uid);
3255    
3256    
3257     --
3258 fmichon 1801 -- Name: donnees_techniques_pkey; Type: CONSTRAINT; Schema: openads; Owner: -; Tablespace:
3259     --
3260    
3261     ALTER TABLE ONLY donnees_techniques
3262     ADD CONSTRAINT donnees_techniques_pkey PRIMARY KEY (donnees_techniques);
3263    
3264    
3265     --
3266     -- Name: dossier_autorisation_pkey; Type: CONSTRAINT; Schema: openads; Owner: -; Tablespace:
3267     --
3268    
3269     ALTER TABLE ONLY dossier_autorisation
3270     ADD CONSTRAINT dossier_autorisation_pkey PRIMARY KEY (dossier_autorisation);
3271    
3272    
3273     --
3274     -- Name: dossier_autorisation_type_detaille_pkey; Type: CONSTRAINT; Schema: openads; Owner: -; Tablespace:
3275     --
3276    
3277     ALTER TABLE ONLY dossier_autorisation_type_detaille
3278     ADD CONSTRAINT dossier_autorisation_type_detaille_pkey PRIMARY KEY (dossier_autorisation_type_detaille);
3279    
3280    
3281     --
3282     -- Name: dossier_autorisation_type_pkey; Type: CONSTRAINT; Schema: openads; Owner: -; Tablespace:
3283     --
3284    
3285     ALTER TABLE ONLY dossier_autorisation_type
3286     ADD CONSTRAINT dossier_autorisation_type_pkey PRIMARY KEY (dossier_autorisation_type);
3287    
3288    
3289     --
3290     -- Name: dossier_commission_pkey; Type: CONSTRAINT; Schema: openads; Owner: -; Tablespace:
3291     --
3292    
3293     ALTER TABLE ONLY dossier_commission
3294     ADD CONSTRAINT dossier_commission_pkey PRIMARY KEY (dossier_commission);
3295    
3296    
3297     --
3298     -- Name: dossier_instruction_type_pkey; Type: CONSTRAINT; Schema: openads; Owner: -; Tablespace:
3299     --
3300    
3301     ALTER TABLE ONLY dossier_instruction_type
3302     ADD CONSTRAINT dossier_instruction_type_pkey PRIMARY KEY (dossier_instruction_type);
3303    
3304    
3305     --
3306     -- Name: dossier_message_pkey; Type: CONSTRAINT; Schema: openads; Owner: -; Tablespace:
3307     --
3308    
3309     ALTER TABLE ONLY dossier_message
3310     ADD CONSTRAINT dossier_message_pkey PRIMARY KEY (dossier_message);
3311    
3312    
3313     --
3314     -- Name: dossier_pkey; Type: CONSTRAINT; Schema: openads; Owner: -; Tablespace:
3315     --
3316    
3317     ALTER TABLE ONLY dossier
3318     ADD CONSTRAINT dossier_pkey PRIMARY KEY (dossier);
3319    
3320    
3321     --
3322     -- Name: etat_dossier_autorisation_pkey; Type: CONSTRAINT; Schema: openads; Owner: -; Tablespace:
3323     --
3324    
3325     ALTER TABLE ONLY etat_dossier_autorisation
3326     ADD CONSTRAINT etat_dossier_autorisation_pkey PRIMARY KEY (etat_dossier_autorisation);
3327    
3328    
3329     --
3330     -- Name: etat_pkey; Type: CONSTRAINT; Schema: openads; Owner: -; Tablespace:
3331     --
3332    
3333     ALTER TABLE ONLY etat
3334     ADD CONSTRAINT etat_pkey PRIMARY KEY (etat);
3335    
3336    
3337     --
3338     -- Name: evenement_pkey; Type: CONSTRAINT; Schema: openads; Owner: -; Tablespace:
3339     --
3340    
3341     ALTER TABLE ONLY evenement
3342     ADD CONSTRAINT evenement_pkey PRIMARY KEY (evenement);
3343    
3344    
3345     --
3346     -- Name: genre_pkey; Type: CONSTRAINT; Schema: openads; Owner: -; Tablespace:
3347     --
3348    
3349     ALTER TABLE ONLY genre
3350     ADD CONSTRAINT genre_pkey PRIMARY KEY (genre);
3351    
3352    
3353     --
3354     -- Name: groupe_pkey; Type: CONSTRAINT; Schema: openads; Owner: -; Tablespace:
3355     --
3356    
3357     ALTER TABLE ONLY groupe
3358     ADD CONSTRAINT groupe_pkey PRIMARY KEY (groupe);
3359    
3360    
3361     --
3362     -- Name: instructeur_pkey; Type: CONSTRAINT; Schema: openads; Owner: -; Tablespace:
3363     --
3364    
3365     ALTER TABLE ONLY instructeur
3366     ADD CONSTRAINT instructeur_pkey PRIMARY KEY (instructeur);
3367    
3368    
3369     --
3370     -- Name: instruction_pkey; Type: CONSTRAINT; Schema: openads; Owner: -; Tablespace:
3371     --
3372    
3373     ALTER TABLE ONLY instruction
3374     ADD CONSTRAINT instruction_pkey PRIMARY KEY (instruction);
3375    
3376    
3377     --
3378     -- Name: lien_demande_demandeur_pkey; Type: CONSTRAINT; Schema: openads; Owner: -; Tablespace:
3379     --
3380    
3381     ALTER TABLE ONLY lien_demande_demandeur
3382     ADD CONSTRAINT lien_demande_demandeur_pkey PRIMARY KEY (lien_demande_demandeur);
3383    
3384    
3385     --
3386     -- Name: lien_demande_type_etat_dossier_autorisation_pkey; Type: CONSTRAINT; Schema: openads; Owner: -; Tablespace:
3387     --
3388    
3389     ALTER TABLE ONLY lien_demande_type_etat_dossier_autorisation
3390     ADD CONSTRAINT lien_demande_type_etat_dossier_autorisation_pkey PRIMARY KEY (lien_demande_type_etat_dossier_autorisation);
3391    
3392    
3393     --
3394     -- Name: lien_dossier_autorisation_demandeur_pkey; Type: CONSTRAINT; Schema: openads; Owner: -; Tablespace:
3395     --
3396    
3397     ALTER TABLE ONLY lien_dossier_autorisation_demandeur
3398     ADD CONSTRAINT lien_dossier_autorisation_demandeur_pkey PRIMARY KEY (lien_dossier_autorisation_demandeur);
3399    
3400    
3401     --
3402     -- Name: lien_dossier_demandeur_pkey; Type: CONSTRAINT; Schema: openads; Owner: -; Tablespace:
3403     --
3404    
3405     ALTER TABLE ONLY lien_dossier_demandeur
3406     ADD CONSTRAINT lien_dossier_demandeur_pkey PRIMARY KEY (lien_dossier_demandeur);
3407    
3408    
3409     --
3410     -- Name: lien_dossier_instruction_type_evenement_pkey; Type: CONSTRAINT; Schema: openads; Owner: -; Tablespace:
3411     --
3412    
3413     ALTER TABLE ONLY lien_dossier_instruction_type_evenement
3414     ADD CONSTRAINT lien_dossier_instruction_type_evenement_pkey PRIMARY KEY (lien_dossier_instruction_type_evenement);
3415    
3416    
3417     --
3418     -- Name: lien_dossier_lot_pkey; Type: CONSTRAINT; Schema: openads; Owner: -; Tablespace:
3419     --
3420    
3421     ALTER TABLE ONLY lien_dossier_lot
3422     ADD CONSTRAINT lien_dossier_lot_pkey PRIMARY KEY (lien_dossier_lot);
3423    
3424    
3425     --
3426     -- Name: lien_evenement_dossier_autorisation_type_pkey; Type: CONSTRAINT; Schema: openads; Owner: -; Tablespace:
3427     --
3428    
3429     ALTER TABLE ONLY lien_evenement_dossier_autorisation_type
3430     ADD CONSTRAINT lien_evenement_dossier_autorisation_type_pkey PRIMARY KEY (lien_evenement_dossier_autorisation_type);
3431    
3432    
3433     --
3434     -- Name: lien_lot_demandeur_pkey; Type: CONSTRAINT; Schema: openads; Owner: -; Tablespace:
3435     --
3436    
3437     ALTER TABLE ONLY lien_lot_demandeur
3438     ADD CONSTRAINT lien_lot_demandeur_pkey PRIMARY KEY (lien_lot_demandeur);
3439    
3440    
3441     --
3442     -- Name: lien_service_om_utilisateur_pkey; Type: CONSTRAINT; Schema: openads; Owner: -; Tablespace:
3443     --
3444    
3445     ALTER TABLE ONLY lien_service_om_utilisateur
3446     ADD CONSTRAINT lien_service_om_utilisateur_pkey PRIMARY KEY (lien_service_om_utilisateur);
3447    
3448    
3449     --
3450     -- Name: lien_service_service_categorie_pkey; Type: CONSTRAINT; Schema: openads; Owner: -; Tablespace:
3451     --
3452    
3453     ALTER TABLE ONLY lien_service_service_categorie
3454     ADD CONSTRAINT lien_service_service_categorie_pkey PRIMARY KEY (lien_service_service_categorie);
3455    
3456    
3457     --
3458     -- Name: lot_pkey; Type: CONSTRAINT; Schema: openads; Owner: -; Tablespace:
3459     --
3460    
3461     ALTER TABLE ONLY lot
3462     ADD CONSTRAINT lot_pkey PRIMARY KEY (lot);
3463    
3464    
3465     --
3466     -- Name: parametre_pkey; Type: CONSTRAINT; Schema: openads; Owner: -; Tablespace:
3467     --
3468    
3469     ALTER TABLE ONLY parametre
3470     ADD CONSTRAINT parametre_pkey PRIMARY KEY (parametre);
3471    
3472    
3473     --
3474     -- Name: parcelle_lot_pkey; Type: CONSTRAINT; Schema: openads; Owner: -; Tablespace:
3475     --
3476    
3477     ALTER TABLE ONLY parcelle_lot
3478     ADD CONSTRAINT parcelle_lot_pkey PRIMARY KEY (parcelle_lot);
3479    
3480    
3481     --
3482     -- Name: parcelle_pkey; Type: CONSTRAINT; Schema: openads; Owner: -; Tablespace:
3483     --
3484    
3485     ALTER TABLE ONLY parcelle
3486     ADD CONSTRAINT parcelle_pkey PRIMARY KEY (parcelle);
3487    
3488    
3489     --
3490     -- Name: pos_pkey; Type: CONSTRAINT; Schema: openads; Owner: -; Tablespace:
3491     --
3492    
3493     ALTER TABLE ONLY pos
3494     ADD CONSTRAINT pos_pkey PRIMARY KEY (pos);
3495    
3496    
3497     --
3498     -- Name: proprietaire_pkey; Type: CONSTRAINT; Schema: openads; Owner: -; Tablespace:
3499     --
3500    
3501     ALTER TABLE ONLY proprietaire
3502     ADD CONSTRAINT proprietaire_pkey PRIMARY KEY (proprietaire);
3503    
3504    
3505     --
3506     -- Name: quartier_pkey; Type: CONSTRAINT; Schema: openads; Owner: -; Tablespace:
3507     --
3508    
3509     ALTER TABLE ONLY quartier
3510     ADD CONSTRAINT quartier_pkey PRIMARY KEY (quartier);
3511    
3512    
3513     --
3514     -- Name: rapport_instruction_pkey; Type: CONSTRAINT; Schema: openads; Owner: -; Tablespace:
3515     --
3516    
3517     ALTER TABLE ONLY rapport_instruction
3518     ADD CONSTRAINT rapport_instruction_pkey PRIMARY KEY (rapport_instruction);
3519    
3520    
3521     --
3522     -- Name: regle_pkey; Type: CONSTRAINT; Schema: openads; Owner: -; Tablespace:
3523     --
3524    
3525     ALTER TABLE ONLY regle
3526     ADD CONSTRAINT regle_pkey PRIMARY KEY (regle);
3527    
3528    
3529     --
3530     -- Name: rivoli_pkey; Type: CONSTRAINT; Schema: openads; Owner: -; Tablespace:
3531     --
3532    
3533     ALTER TABLE ONLY rivoli
3534     ADD CONSTRAINT rivoli_pkey PRIMARY KEY (rivoli);
3535    
3536    
3537     --
3538     -- Name: service_categorie_pkey; Type: CONSTRAINT; Schema: openads; Owner: -; Tablespace:
3539     --
3540    
3541     ALTER TABLE ONLY service_categorie
3542     ADD CONSTRAINT service_categorie_pkey PRIMARY KEY (service_categorie);
3543    
3544    
3545     --
3546     -- Name: service_pkey; Type: CONSTRAINT; Schema: openads; Owner: -; Tablespace:
3547     --
3548    
3549     ALTER TABLE ONLY service
3550     ADD CONSTRAINT service_pkey PRIMARY KEY (service);
3551    
3552    
3553     --
3554     -- Name: servitude_ligne_pkey; Type: CONSTRAINT; Schema: openads; Owner: -; Tablespace:
3555     --
3556    
3557     ALTER TABLE ONLY servitude_ligne
3558     ADD CONSTRAINT servitude_ligne_pkey PRIMARY KEY (servitude_ligne);
3559    
3560    
3561     --
3562     -- Name: servitude_point_pkey; Type: CONSTRAINT; Schema: openads; Owner: -; Tablespace:
3563     --
3564    
3565     ALTER TABLE ONLY servitude_point
3566     ADD CONSTRAINT servitude_point_pkey PRIMARY KEY (servitude_point);
3567    
3568    
3569     --
3570     -- Name: servitude_surfacique_pkey; Type: CONSTRAINT; Schema: openads; Owner: -; Tablespace:
3571     --
3572    
3573     ALTER TABLE ONLY servitude_surfacique
3574     ADD CONSTRAINT servitude_surfacique_pkey PRIMARY KEY (servitude_surfacique);
3575    
3576    
3577     --
3578     -- Name: signataire_arrete_pkey; Type: CONSTRAINT; Schema: openads; Owner: -; Tablespace:
3579     --
3580    
3581     ALTER TABLE ONLY signataire_arrete
3582     ADD CONSTRAINT signataire_arrete_pkey PRIMARY KEY (signataire_arrete);
3583    
3584    
3585     --
3586     -- Name: terrain_pkey; Type: CONSTRAINT; Schema: openads; Owner: -; Tablespace:
3587     --
3588    
3589     ALTER TABLE ONLY terrain
3590     ADD CONSTRAINT terrain_pkey PRIMARY KEY (terrain);
3591    
3592    
3593     --
3594     -- Name: transition_pkey; Type: CONSTRAINT; Schema: openads; Owner: -; Tablespace:
3595     --
3596    
3597     ALTER TABLE ONLY transition
3598     ADD CONSTRAINT transition_pkey PRIMARY KEY (transition);
3599    
3600    
3601     --
3602     -- Name: travaux_pkey; Type: CONSTRAINT; Schema: openads; Owner: -; Tablespace:
3603     --
3604    
3605     ALTER TABLE ONLY travaux
3606     ADD CONSTRAINT travaux_pkey PRIMARY KEY (travaux);
3607    
3608    
3609     --
3610 fmichon 1970 -- Name: lien_demande_type_etat_dossier_autorisation_uk; Type: INDEX; Schema: openads; Owner: -; Tablespace:
3611     --
3612    
3613     CREATE UNIQUE INDEX lien_demande_type_etat_dossier_autorisation_uk ON lien_demande_type_etat_dossier_autorisation USING btree (demande_type, etat_dossier_autorisation);
3614    
3615    
3616     --
3617 fmichon 1801 -- Name: affectation_automatique_arrondissement_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
3618     --
3619    
3620     ALTER TABLE ONLY affectation_automatique
3621     ADD CONSTRAINT affectation_automatique_arrondissement_fkey FOREIGN KEY (arrondissement) REFERENCES arrondissement(arrondissement);
3622    
3623    
3624     --
3625     -- Name: affectation_automatique_dossier_autorisation_type_detaille_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
3626     --
3627    
3628     ALTER TABLE ONLY affectation_automatique
3629     ADD CONSTRAINT affectation_automatique_dossier_autorisation_type_detaille_fkey FOREIGN KEY (dossier_autorisation_type_detaille) REFERENCES dossier_autorisation_type_detaille(dossier_autorisation_type_detaille);
3630    
3631    
3632     --
3633     -- Name: affectation_automatique_instructeur_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
3634     --
3635    
3636     ALTER TABLE ONLY affectation_automatique
3637     ADD CONSTRAINT affectation_automatique_instructeur_fkey FOREIGN KEY (instructeur) REFERENCES instructeur(instructeur);
3638    
3639    
3640     --
3641     -- Name: affectation_automatique_quartier_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
3642     --
3643    
3644     ALTER TABLE ONLY affectation_automatique
3645     ADD CONSTRAINT affectation_automatique_quartier_fkey FOREIGN KEY (quartier) REFERENCES quartier(quartier);
3646    
3647    
3648     --
3649     -- Name: bible_dossier_autorisation_type_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
3650     --
3651    
3652     ALTER TABLE ONLY bible
3653     ADD CONSTRAINT bible_dossier_autorisation_type_fkey FOREIGN KEY (dossier_autorisation_type) REFERENCES dossier_autorisation_type(dossier_autorisation_type);
3654    
3655    
3656     --
3657     -- Name: bible_evenement_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
3658     --
3659    
3660     ALTER TABLE ONLY bible
3661     ADD CONSTRAINT bible_evenement_fkey FOREIGN KEY (evenement) REFERENCES evenement(evenement);
3662    
3663    
3664     --
3665     -- Name: blocnote_dossier_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
3666     --
3667    
3668     ALTER TABLE ONLY blocnote
3669     ADD CONSTRAINT blocnote_dossier_fkey FOREIGN KEY (dossier) REFERENCES dossier(dossier);
3670    
3671    
3672     --
3673     -- Name: commission_commission_type_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
3674     --
3675    
3676     ALTER TABLE ONLY commission
3677     ADD CONSTRAINT commission_commission_type_fkey FOREIGN KEY (commission_type) REFERENCES commission_type(commission_type);
3678    
3679    
3680     --
3681     -- Name: consultation_avis_consultation_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
3682     --
3683    
3684     ALTER TABLE ONLY consultation
3685     ADD CONSTRAINT consultation_avis_consultation_fkey FOREIGN KEY (avis_consultation) REFERENCES avis_consultation(avis_consultation);
3686    
3687    
3688     --
3689     -- Name: consultation_dossier_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
3690     --
3691    
3692     ALTER TABLE ONLY consultation
3693     ADD CONSTRAINT consultation_dossier_fkey FOREIGN KEY (dossier) REFERENCES dossier(dossier);
3694    
3695    
3696     --
3697     -- Name: consultation_service_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
3698     --
3699    
3700     ALTER TABLE ONLY consultation
3701     ADD CONSTRAINT consultation_service_fkey FOREIGN KEY (service) REFERENCES service(service);
3702    
3703    
3704     --
3705     -- Name: demande_arrondissement_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
3706     --
3707    
3708     ALTER TABLE ONLY demande
3709     ADD CONSTRAINT demande_arrondissement_fkey FOREIGN KEY (arrondissement) REFERENCES arrondissement(arrondissement);
3710    
3711    
3712     --
3713     -- Name: demande_demande_type_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
3714     --
3715    
3716     ALTER TABLE ONLY demande
3717     ADD CONSTRAINT demande_demande_type_fkey FOREIGN KEY (demande_type) REFERENCES demande_type(demande_type);
3718    
3719    
3720     --
3721     -- Name: demande_dossier_autorisation_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
3722     --
3723    
3724     ALTER TABLE ONLY demande
3725     ADD CONSTRAINT demande_dossier_autorisation_fkey FOREIGN KEY (dossier_autorisation) REFERENCES dossier_autorisation(dossier_autorisation);
3726    
3727    
3728     --
3729     -- Name: demande_dossier_autorisation_type_detaille_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
3730     --
3731    
3732     ALTER TABLE ONLY demande
3733     ADD CONSTRAINT demande_dossier_autorisation_type_detaille_fkey FOREIGN KEY (dossier_autorisation_type_detaille) REFERENCES dossier_autorisation_type_detaille(dossier_autorisation_type_detaille);
3734    
3735    
3736     --
3737     -- Name: demande_dossier_instruction_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
3738     --
3739    
3740     ALTER TABLE ONLY demande
3741     ADD CONSTRAINT demande_dossier_instruction_fkey FOREIGN KEY (dossier_instruction) REFERENCES dossier(dossier);
3742    
3743    
3744     --
3745     -- Name: demande_instruction_recepisse_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
3746     --
3747    
3748     ALTER TABLE ONLY demande
3749     ADD CONSTRAINT demande_instruction_recepisse_fkey FOREIGN KEY (instruction_recepisse) REFERENCES instruction(instruction);
3750    
3751    
3752     --
3753     -- Name: demande_type_demande_nature_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
3754     --
3755    
3756     ALTER TABLE ONLY demande_type
3757     ADD CONSTRAINT demande_type_demande_nature_fkey FOREIGN KEY (demande_nature) REFERENCES demande_nature(demande_nature);
3758    
3759    
3760     --
3761     -- Name: demande_type_dossier_autorisation_type_detaille_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
3762     --
3763    
3764     ALTER TABLE ONLY demande_type
3765     ADD CONSTRAINT demande_type_dossier_autorisation_type_detaille_fkey FOREIGN KEY (dossier_autorisation_type_detaille) REFERENCES dossier_autorisation_type_detaille(dossier_autorisation_type_detaille);
3766    
3767    
3768     --
3769     -- Name: demande_type_dossier_instruction_type_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
3770     --
3771    
3772     ALTER TABLE ONLY demande_type
3773     ADD CONSTRAINT demande_type_dossier_instruction_type_fkey FOREIGN KEY (dossier_instruction_type) REFERENCES dossier_instruction_type(dossier_instruction_type);
3774    
3775    
3776     --
3777     -- Name: demande_type_evenement_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
3778     --
3779    
3780     ALTER TABLE ONLY demande_type
3781     ADD CONSTRAINT demande_type_evenement_fkey FOREIGN KEY (evenement) REFERENCES evenement(evenement);
3782    
3783    
3784     --
3785     -- Name: demande_type_groupe_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
3786     --
3787    
3788     ALTER TABLE ONLY demande_type
3789     ADD CONSTRAINT demande_type_groupe_fkey FOREIGN KEY (groupe) REFERENCES groupe(groupe);
3790    
3791    
3792     --
3793     -- Name: demandeur_particulier_civilite_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
3794     --
3795    
3796     ALTER TABLE ONLY demandeur
3797     ADD CONSTRAINT demandeur_particulier_civilite_fkey FOREIGN KEY (particulier_civilite) REFERENCES civilite(civilite);
3798    
3799    
3800     --
3801     -- Name: demandeur_personne_morale_civilite_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
3802     --
3803    
3804     ALTER TABLE ONLY demandeur
3805     ADD CONSTRAINT demandeur_personne_morale_civilite_fkey FOREIGN KEY (personne_morale_civilite) REFERENCES civilite(civilite);
3806    
3807    
3808     --
3809     -- Name: division_direction_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
3810     --
3811    
3812     ALTER TABLE ONLY division
3813     ADD CONSTRAINT division_direction_fkey FOREIGN KEY (direction) REFERENCES direction(direction);
3814    
3815    
3816     --
3817 fmichon 1970 -- Name: document_numerise_document_numerise_type_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
3818     --
3819    
3820     ALTER TABLE ONLY document_numerise
3821     ADD CONSTRAINT document_numerise_document_numerise_type_fkey FOREIGN KEY (document_numerise_type) REFERENCES document_numerise_type(document_numerise_type) MATCH FULL;
3822    
3823    
3824     --
3825 fmichon 1844 -- Name: document_numerise_dossier_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
3826     --
3827    
3828     ALTER TABLE ONLY document_numerise
3829     ADD CONSTRAINT document_numerise_dossier_fkey FOREIGN KEY (dossier) REFERENCES dossier(dossier) MATCH FULL ON UPDATE CASCADE ON DELETE SET NULL;
3830    
3831    
3832     --
3833 fmichon 1970 -- Name: document_numerise_type_document_numerise_type_categorie_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
3834     --
3835    
3836     ALTER TABLE ONLY document_numerise_type
3837     ADD CONSTRAINT document_numerise_type_document_numerise_type_categorie_fkey FOREIGN KEY (document_numerise_type_categorie) REFERENCES document_numerise_type_categorie(document_numerise_type_categorie) MATCH FULL;
3838    
3839    
3840     --
3841 fmichon 1801 -- Name: donnees_techniques_dossier_instruction_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
3842     --
3843    
3844     ALTER TABLE ONLY donnees_techniques
3845     ADD CONSTRAINT donnees_techniques_dossier_instruction_fkey FOREIGN KEY (dossier_instruction) REFERENCES dossier(dossier);
3846    
3847    
3848     --
3849     -- Name: donnees_techniques_lot_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
3850     --
3851    
3852     ALTER TABLE ONLY donnees_techniques
3853     ADD CONSTRAINT donnees_techniques_lot_fkey FOREIGN KEY (lot) REFERENCES lot(lot);
3854    
3855    
3856     --
3857     -- Name: dossier_autorisation_arrondissement_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
3858     --
3859    
3860     ALTER TABLE ONLY dossier_autorisation
3861     ADD CONSTRAINT dossier_autorisation_arrondissement_fkey FOREIGN KEY (arrondissement) REFERENCES arrondissement(arrondissement);
3862    
3863    
3864     --
3865     -- Name: dossier_autorisation_avis_decision_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
3866     --
3867    
3868     ALTER TABLE ONLY dossier_autorisation
3869     ADD CONSTRAINT dossier_autorisation_avis_decision_fkey FOREIGN KEY (avis_decision) REFERENCES avis_decision(avis_decision);
3870    
3871    
3872     --
3873     -- Name: dossier_autorisation_etat_dernier_dossier_instruction_accepte_f; Type: FK CONSTRAINT; Schema: openads; Owner: -
3874     --
3875    
3876     ALTER TABLE ONLY dossier_autorisation
3877     ADD CONSTRAINT dossier_autorisation_etat_dernier_dossier_instruction_accepte_f FOREIGN KEY (etat_dernier_dossier_instruction_accepte) REFERENCES etat_dossier_autorisation(etat_dossier_autorisation);
3878    
3879    
3880     --
3881     -- Name: dossier_autorisation_etat_dossier_autorisation_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
3882     --
3883    
3884     ALTER TABLE ONLY dossier_autorisation
3885     ADD CONSTRAINT dossier_autorisation_etat_dossier_autorisation_fkey FOREIGN KEY (etat_dossier_autorisation) REFERENCES etat_dossier_autorisation(etat_dossier_autorisation);
3886    
3887    
3888     --
3889     -- Name: dossier_autorisation_type_detaille_dossier_autorisation_type_fk; Type: FK CONSTRAINT; Schema: openads; Owner: -
3890     --
3891    
3892     ALTER TABLE ONLY dossier_autorisation_type_detaille
3893     ADD CONSTRAINT dossier_autorisation_type_detaille_dossier_autorisation_type_fk FOREIGN KEY (dossier_autorisation_type) REFERENCES dossier_autorisation_type(dossier_autorisation_type);
3894    
3895    
3896     --
3897     -- Name: dossier_autorisation_type_detaille_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
3898     --
3899    
3900     ALTER TABLE ONLY dossier_autorisation
3901     ADD CONSTRAINT dossier_autorisation_type_detaille_fkey FOREIGN KEY (dossier_autorisation_type_detaille) REFERENCES dossier_autorisation_type_detaille(dossier_autorisation_type_detaille);
3902    
3903    
3904     --
3905     -- Name: dossier_autorisation_type_groupe_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
3906     --
3907    
3908     ALTER TABLE ONLY dossier_autorisation_type
3909     ADD CONSTRAINT dossier_autorisation_type_groupe_fkey FOREIGN KEY (groupe) REFERENCES groupe(groupe);
3910    
3911    
3912     --
3913     -- Name: dossier_autorite_competente_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
3914     --
3915    
3916     ALTER TABLE ONLY dossier
3917     ADD CONSTRAINT dossier_autorite_competente_fkey FOREIGN KEY (autorite_competente) REFERENCES autorite_competente(autorite_competente);
3918    
3919    
3920     --
3921     -- Name: dossier_avis_decision_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
3922     --
3923    
3924     ALTER TABLE ONLY dossier
3925     ADD CONSTRAINT dossier_avis_decision_fkey FOREIGN KEY (avis_decision) REFERENCES avis_decision(avis_decision);
3926    
3927    
3928     --
3929     -- Name: dossier_commission_commission_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
3930     --
3931    
3932     ALTER TABLE ONLY dossier_commission
3933     ADD CONSTRAINT dossier_commission_commission_fkey FOREIGN KEY (commission) REFERENCES commission(commission);
3934    
3935    
3936     --
3937     -- Name: dossier_commission_commission_type_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
3938     --
3939    
3940     ALTER TABLE ONLY dossier_commission
3941     ADD CONSTRAINT dossier_commission_commission_type_fkey FOREIGN KEY (commission_type) REFERENCES commission_type(commission_type);
3942    
3943    
3944     --
3945     -- Name: dossier_commission_dossier_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
3946     --
3947    
3948     ALTER TABLE ONLY dossier_commission
3949     ADD CONSTRAINT dossier_commission_dossier_fkey FOREIGN KEY (dossier) REFERENCES dossier(dossier);
3950    
3951    
3952     --
3953     -- Name: dossier_division_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
3954     --
3955    
3956     ALTER TABLE ONLY dossier
3957     ADD CONSTRAINT dossier_division_fkey FOREIGN KEY (division) REFERENCES division(division);
3958    
3959    
3960     --
3961     -- Name: dossier_dossier_autorisation_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
3962     --
3963    
3964     ALTER TABLE ONLY dossier
3965     ADD CONSTRAINT dossier_dossier_autorisation_fkey FOREIGN KEY (dossier_autorisation) REFERENCES dossier_autorisation(dossier_autorisation);
3966    
3967    
3968     --
3969     -- Name: dossier_etat_archive_etat_pendant_incompletude_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
3970     --
3971    
3972     ALTER TABLE ONLY instruction
3973     ADD CONSTRAINT dossier_etat_archive_etat_pendant_incompletude_fkey FOREIGN KEY (archive_etat_pendant_incompletude) REFERENCES etat(etat);
3974    
3975    
3976     --
3977     -- Name: dossier_etat_etat_pendant_incompletude_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
3978     --
3979    
3980     ALTER TABLE ONLY dossier
3981     ADD CONSTRAINT dossier_etat_etat_pendant_incompletude_fkey FOREIGN KEY (etat_pendant_incompletude) REFERENCES etat(etat);
3982    
3983    
3984     --
3985     -- Name: dossier_etat_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
3986     --
3987    
3988     ALTER TABLE ONLY dossier
3989     ADD CONSTRAINT dossier_etat_fkey FOREIGN KEY (etat) REFERENCES etat(etat);
3990    
3991    
3992     --
3993     -- Name: dossier_evenement_archive_evenement_suivant_tacite_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
3994     --
3995    
3996     ALTER TABLE ONLY instruction
3997     ADD CONSTRAINT dossier_evenement_archive_evenement_suivant_tacite_fkey FOREIGN KEY (archive_evenement_suivant_tacite) REFERENCES evenement(evenement);
3998    
3999    
4000     --
4001     -- Name: dossier_evenement_archive_evenement_suivant_tacite_incompletude; Type: FK CONSTRAINT; Schema: openads; Owner: -
4002     --
4003    
4004     ALTER TABLE ONLY instruction
4005     ADD CONSTRAINT dossier_evenement_archive_evenement_suivant_tacite_incompletude FOREIGN KEY (archive_evenement_suivant_tacite_incompletude) REFERENCES evenement(evenement);
4006    
4007    
4008     --
4009     -- Name: dossier_evenement_evenement_suivant_tacite_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
4010     --
4011    
4012     ALTER TABLE ONLY dossier
4013     ADD CONSTRAINT dossier_evenement_evenement_suivant_tacite_fkey FOREIGN KEY (evenement_suivant_tacite) REFERENCES evenement(evenement);
4014    
4015    
4016     --
4017     -- Name: dossier_evenement_evenement_suivant_tacite_incompletude_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
4018     --
4019    
4020     ALTER TABLE ONLY dossier
4021     ADD CONSTRAINT dossier_evenement_evenement_suivant_tacite_incompletude_fkey FOREIGN KEY (evenement_suivant_tacite_incompletude) REFERENCES evenement(evenement);
4022    
4023    
4024     --
4025     -- Name: dossier_instructeur_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
4026     --
4027    
4028     ALTER TABLE ONLY dossier
4029     ADD CONSTRAINT dossier_instructeur_fkey FOREIGN KEY (instructeur) REFERENCES instructeur(instructeur);
4030    
4031    
4032     --
4033     -- Name: dossier_instruction_type_cerfa_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
4034     --
4035    
4036     ALTER TABLE ONLY dossier_instruction_type
4037     ADD CONSTRAINT dossier_instruction_type_cerfa_fkey FOREIGN KEY (cerfa) REFERENCES cerfa(cerfa);
4038    
4039    
4040     --
4041     -- Name: dossier_instruction_type_cerfa_lot_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
4042     --
4043    
4044     ALTER TABLE ONLY dossier_instruction_type
4045     ADD CONSTRAINT dossier_instruction_type_cerfa_lot_fkey FOREIGN KEY (cerfa_lot) REFERENCES cerfa(cerfa);
4046    
4047    
4048     --
4049     -- Name: dossier_instruction_type_dossier_autorisation_type_detaille_fke; Type: FK CONSTRAINT; Schema: openads; Owner: -
4050     --
4051    
4052     ALTER TABLE ONLY dossier_instruction_type
4053     ADD CONSTRAINT dossier_instruction_type_dossier_autorisation_type_detaille_fke FOREIGN KEY (dossier_autorisation_type_detaille) REFERENCES dossier_autorisation_type_detaille(dossier_autorisation_type_detaille);
4054    
4055    
4056     --
4057     -- Name: dossier_instruction_type_dossier_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
4058     --
4059    
4060     ALTER TABLE ONLY dossier
4061     ADD CONSTRAINT dossier_instruction_type_dossier_fkey FOREIGN KEY (dossier_instruction_type) REFERENCES dossier_instruction_type(dossier_instruction_type);
4062    
4063    
4064     --
4065     -- Name: dossier_message_dossier_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
4066     --
4067    
4068     ALTER TABLE ONLY dossier_message
4069     ADD CONSTRAINT dossier_message_dossier_fkey FOREIGN KEY (dossier) REFERENCES dossier(dossier);
4070    
4071    
4072     --
4073     -- Name: dossier_parcelle_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
4074     --
4075    
4076     ALTER TABLE ONLY dossier
4077     ADD CONSTRAINT dossier_parcelle_fkey FOREIGN KEY (parcelle) REFERENCES parcelle(parcelle);
4078    
4079    
4080     --
4081     -- Name: dossier_parcelle_lot_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
4082     --
4083    
4084     ALTER TABLE ONLY dossier
4085     ADD CONSTRAINT dossier_parcelle_lot_fkey FOREIGN KEY (parcelle_lot) REFERENCES parcelle_lot(parcelle_lot);
4086    
4087    
4088     --
4089     -- Name: dossier_pos_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
4090     --
4091    
4092     ALTER TABLE ONLY dossier
4093     ADD CONSTRAINT dossier_pos_fkey FOREIGN KEY (pos) REFERENCES pos(pos);
4094    
4095    
4096     --
4097     -- Name: evenement_action_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
4098     --
4099    
4100     ALTER TABLE ONLY evenement
4101     ADD CONSTRAINT evenement_action_fkey FOREIGN KEY (action) REFERENCES action(action);
4102    
4103    
4104     --
4105     -- Name: evenement_avis_decision_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
4106     --
4107    
4108     ALTER TABLE ONLY evenement
4109     ADD CONSTRAINT evenement_avis_decision_fkey FOREIGN KEY (avis_decision) REFERENCES avis_decision(avis_decision);
4110    
4111    
4112     --
4113     -- Name: evenement_etat_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
4114     --
4115    
4116     ALTER TABLE ONLY evenement
4117     ADD CONSTRAINT evenement_etat_fkey FOREIGN KEY (etat) REFERENCES etat(etat);
4118    
4119    
4120     --
4121     -- Name: evenement_evenement_retour_ar_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
4122     --
4123    
4124     ALTER TABLE ONLY evenement
4125     ADD CONSTRAINT evenement_evenement_retour_ar_fkey FOREIGN KEY (evenement_retour_ar) REFERENCES evenement(evenement);
4126    
4127    
4128     --
4129     -- Name: evenement_evenement_retour_signature_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
4130     --
4131    
4132     ALTER TABLE ONLY evenement
4133     ADD CONSTRAINT evenement_evenement_retour_signature_fkey FOREIGN KEY (evenement_retour_signature) REFERENCES evenement(evenement);
4134    
4135    
4136     --
4137     -- Name: evenement_evenement_suivant_tacite_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
4138     --
4139    
4140     ALTER TABLE ONLY evenement
4141     ADD CONSTRAINT evenement_evenement_suivant_tacite_fkey FOREIGN KEY (evenement_suivant_tacite) REFERENCES evenement(evenement);
4142    
4143    
4144     --
4145     -- Name: groupe_genre_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
4146     --
4147    
4148     ALTER TABLE ONLY groupe
4149     ADD CONSTRAINT groupe_genre_fkey FOREIGN KEY (genre) REFERENCES genre(genre);
4150    
4151    
4152     --
4153     -- Name: instructeur_division_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
4154     --
4155    
4156     ALTER TABLE ONLY instructeur
4157     ADD CONSTRAINT instructeur_division_fkey FOREIGN KEY (division) REFERENCES division(division);
4158    
4159    
4160     --
4161     -- Name: instructeur_om_utilisateur_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
4162     --
4163    
4164     ALTER TABLE ONLY instructeur
4165     ADD CONSTRAINT instructeur_om_utilisateur_fkey FOREIGN KEY (om_utilisateur) REFERENCES om_utilisateur(om_utilisateur);
4166    
4167    
4168     --
4169     -- Name: instruction_action_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
4170     --
4171    
4172     ALTER TABLE ONLY instruction
4173     ADD CONSTRAINT instruction_action_fkey FOREIGN KEY (action) REFERENCES action(action);
4174    
4175    
4176     --
4177     -- Name: instruction_avis_decision_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
4178     --
4179    
4180     ALTER TABLE ONLY instruction
4181     ADD CONSTRAINT instruction_avis_decision_fkey FOREIGN KEY (avis_decision) REFERENCES avis_decision(avis_decision);
4182    
4183    
4184     --
4185 vpihour 2052 -- Name: instruction_document_numerise_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
4186     --
4187    
4188     ALTER TABLE ONLY instruction
4189     ADD CONSTRAINT instruction_document_numerise_fkey FOREIGN KEY (document_numerise) REFERENCES document_numerise(document_numerise);
4190    
4191    
4192     --
4193 fmichon 1801 -- Name: instruction_dossier_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
4194     --
4195    
4196     ALTER TABLE ONLY instruction
4197     ADD CONSTRAINT instruction_dossier_fkey FOREIGN KEY (dossier) REFERENCES dossier(dossier);
4198    
4199    
4200     --
4201     -- Name: instruction_etat_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
4202     --
4203    
4204     ALTER TABLE ONLY instruction
4205     ADD CONSTRAINT instruction_etat_fkey FOREIGN KEY (etat) REFERENCES etat(etat);
4206    
4207    
4208     --
4209     -- Name: instruction_evenement_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
4210     --
4211    
4212     ALTER TABLE ONLY instruction
4213     ADD CONSTRAINT instruction_evenement_fkey FOREIGN KEY (evenement) REFERENCES evenement(evenement);
4214    
4215    
4216     --
4217     -- Name: instruction_signataire_arrete_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
4218     --
4219    
4220     ALTER TABLE ONLY instruction
4221     ADD CONSTRAINT instruction_signataire_arrete_fkey FOREIGN KEY (signataire_arrete) REFERENCES signataire_arrete(signataire_arrete);
4222    
4223    
4224     --
4225     -- Name: lien_demande_demandeur_demande_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
4226     --
4227    
4228     ALTER TABLE ONLY lien_demande_demandeur
4229     ADD CONSTRAINT lien_demande_demandeur_demande_fkey FOREIGN KEY (demande) REFERENCES demande(demande);
4230    
4231    
4232     --
4233     -- Name: lien_demande_demandeur_demandeur_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
4234     --
4235    
4236     ALTER TABLE ONLY lien_demande_demandeur
4237     ADD CONSTRAINT lien_demande_demandeur_demandeur_fkey FOREIGN KEY (demandeur) REFERENCES demandeur(demandeur);
4238    
4239    
4240     --
4241     -- Name: lien_demande_type_etat_dossier_autorisation_demande_type_fk; Type: FK CONSTRAINT; Schema: openads; Owner: -
4242     --
4243    
4244     ALTER TABLE ONLY lien_demande_type_etat_dossier_autorisation
4245     ADD CONSTRAINT lien_demande_type_etat_dossier_autorisation_demande_type_fk FOREIGN KEY (demande_type) REFERENCES demande_type(demande_type);
4246    
4247    
4248     --
4249     -- Name: lien_demande_type_etat_dossier_autorisation_etat_dossier_autori; Type: FK CONSTRAINT; Schema: openads; Owner: -
4250     --
4251    
4252     ALTER TABLE ONLY lien_demande_type_etat_dossier_autorisation
4253     ADD CONSTRAINT lien_demande_type_etat_dossier_autorisation_etat_dossier_autori FOREIGN KEY (etat_dossier_autorisation) REFERENCES etat_dossier_autorisation(etat_dossier_autorisation);
4254    
4255    
4256     --
4257     -- Name: lien_dossier_autorisation_demandeur_demande_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
4258     --
4259    
4260     ALTER TABLE ONLY lien_dossier_autorisation_demandeur
4261     ADD CONSTRAINT lien_dossier_autorisation_demandeur_demande_fkey FOREIGN KEY (dossier_autorisation) REFERENCES dossier_autorisation(dossier_autorisation);
4262    
4263    
4264     --
4265     -- Name: lien_dossier_autorisation_demandeur_demandeur_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
4266     --
4267    
4268     ALTER TABLE ONLY lien_dossier_autorisation_demandeur
4269     ADD CONSTRAINT lien_dossier_autorisation_demandeur_demandeur_fkey FOREIGN KEY (demandeur) REFERENCES demandeur(demandeur);
4270    
4271    
4272     --
4273     -- Name: lien_dossier_demandeur_demandeur_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
4274     --
4275    
4276     ALTER TABLE ONLY lien_dossier_demandeur
4277     ADD CONSTRAINT lien_dossier_demandeur_demandeur_fkey FOREIGN KEY (demandeur) REFERENCES demandeur(demandeur);
4278    
4279    
4280     --
4281     -- Name: lien_dossier_demandeur_dossier_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
4282     --
4283    
4284     ALTER TABLE ONLY lien_dossier_demandeur
4285     ADD CONSTRAINT lien_dossier_demandeur_dossier_fkey FOREIGN KEY (dossier) REFERENCES dossier(dossier);
4286    
4287    
4288     --
4289     -- Name: lien_dossier_instruction_type_evenement_dossier_instruction_typ; Type: FK CONSTRAINT; Schema: openads; Owner: -
4290     --
4291    
4292     ALTER TABLE ONLY lien_dossier_instruction_type_evenement
4293     ADD CONSTRAINT lien_dossier_instruction_type_evenement_dossier_instruction_typ FOREIGN KEY (dossier_instruction_type) REFERENCES dossier_instruction_type(dossier_instruction_type);
4294    
4295    
4296     --
4297     -- Name: lien_dossier_instruction_type_evenement_evenement_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
4298     --
4299    
4300     ALTER TABLE ONLY lien_dossier_instruction_type_evenement
4301     ADD CONSTRAINT lien_dossier_instruction_type_evenement_evenement_fkey FOREIGN KEY (evenement) REFERENCES evenement(evenement);
4302    
4303    
4304     --
4305     -- Name: lien_dossier_lot_dossier_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
4306     --
4307    
4308     ALTER TABLE ONLY lien_dossier_lot
4309     ADD CONSTRAINT lien_dossier_lot_dossier_fkey FOREIGN KEY (dossier) REFERENCES dossier(dossier);
4310    
4311    
4312     --
4313     -- Name: lien_dossier_lot_lot_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
4314     --
4315    
4316     ALTER TABLE ONLY lien_dossier_lot
4317     ADD CONSTRAINT lien_dossier_lot_lot_fkey FOREIGN KEY (lot) REFERENCES lot(lot);
4318    
4319    
4320     --
4321     -- Name: lien_evenement_dossier_autorisation_type_dossier_autorisation_t; Type: FK CONSTRAINT; Schema: openads; Owner: -
4322     --
4323    
4324     ALTER TABLE ONLY lien_evenement_dossier_autorisation_type
4325     ADD CONSTRAINT lien_evenement_dossier_autorisation_type_dossier_autorisation_t FOREIGN KEY (dossier_autorisation_type) REFERENCES dossier_autorisation_type(dossier_autorisation_type);
4326    
4327    
4328     --
4329     -- Name: lien_evenement_dossier_autorisation_type_evenement_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
4330     --
4331    
4332     ALTER TABLE ONLY lien_evenement_dossier_autorisation_type
4333     ADD CONSTRAINT lien_evenement_dossier_autorisation_type_evenement_fkey FOREIGN KEY (evenement) REFERENCES evenement(evenement);
4334    
4335    
4336     --
4337     -- Name: lien_lot_demandeur_demandeur_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
4338     --
4339    
4340     ALTER TABLE ONLY lien_lot_demandeur
4341     ADD CONSTRAINT lien_lot_demandeur_demandeur_fkey FOREIGN KEY (demandeur) REFERENCES demandeur(demandeur);
4342    
4343    
4344     --
4345     -- Name: lien_lot_demandeur_lot_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
4346     --
4347    
4348     ALTER TABLE ONLY lien_lot_demandeur
4349     ADD CONSTRAINT lien_lot_demandeur_lot_fkey FOREIGN KEY (lot) REFERENCES lot(lot);
4350    
4351    
4352     --
4353     -- Name: lien_service_om_utilisateur_om_utilisateur_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
4354     --
4355    
4356     ALTER TABLE ONLY lien_service_om_utilisateur
4357     ADD CONSTRAINT lien_service_om_utilisateur_om_utilisateur_fkey FOREIGN KEY (om_utilisateur) REFERENCES om_utilisateur(om_utilisateur);
4358    
4359    
4360     --
4361     -- Name: lien_service_om_utilisateur_service_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
4362     --
4363    
4364     ALTER TABLE ONLY lien_service_om_utilisateur
4365     ADD CONSTRAINT lien_service_om_utilisateur_service_fkey FOREIGN KEY (service) REFERENCES service(service);
4366    
4367    
4368     --
4369     -- Name: lien_service_service_categorie_service_categorie_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
4370     --
4371    
4372     ALTER TABLE ONLY lien_service_service_categorie
4373     ADD CONSTRAINT lien_service_service_categorie_service_categorie_fkey FOREIGN KEY (service_categorie) REFERENCES service_categorie(service_categorie);
4374    
4375    
4376     --
4377     -- Name: lien_service_service_categorie_service_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
4378     --
4379    
4380     ALTER TABLE ONLY lien_service_service_categorie
4381     ADD CONSTRAINT lien_service_service_categorie_service_fkey FOREIGN KEY (service) REFERENCES service(service);
4382    
4383    
4384     --
4385     -- Name: lot_dossier_autorisation_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
4386     --
4387    
4388     ALTER TABLE ONLY lot
4389     ADD CONSTRAINT lot_dossier_autorisation_fkey FOREIGN KEY (dossier_autorisation) REFERENCES dossier_autorisation(dossier_autorisation);
4390    
4391    
4392     --
4393     -- Name: parcelle_pos_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
4394     --
4395    
4396     ALTER TABLE ONLY parcelle
4397     ADD CONSTRAINT parcelle_pos_fkey FOREIGN KEY (pos) REFERENCES pos(pos);
4398    
4399    
4400     --
4401     -- Name: parcelle_proprietaire_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
4402     --
4403    
4404     ALTER TABLE ONLY parcelle
4405     ADD CONSTRAINT parcelle_proprietaire_fkey FOREIGN KEY (proprietaire) REFERENCES proprietaire(proprietaire);
4406    
4407    
4408     --
4409     -- Name: parcelle_rivoli_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
4410     --
4411    
4412     ALTER TABLE ONLY parcelle
4413     ADD CONSTRAINT parcelle_rivoli_fkey FOREIGN KEY (rivoli) REFERENCES rivoli(rivoli);
4414    
4415    
4416     --
4417     -- Name: proprietaire_civilite_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
4418     --
4419    
4420     ALTER TABLE ONLY proprietaire
4421     ADD CONSTRAINT proprietaire_civilite_fkey FOREIGN KEY (civilite) REFERENCES civilite(civilite);
4422    
4423    
4424     --
4425     -- Name: quartier_arrondissement_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
4426     --
4427    
4428     ALTER TABLE ONLY quartier
4429     ADD CONSTRAINT quartier_arrondissement_fkey FOREIGN KEY (arrondissement) REFERENCES arrondissement(arrondissement);
4430    
4431    
4432     --
4433     -- Name: rapport_instruction_dossier_instruction_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
4434     --
4435    
4436     ALTER TABLE ONLY rapport_instruction
4437     ADD CONSTRAINT rapport_instruction_dossier_instruction_fkey FOREIGN KEY (dossier_instruction) REFERENCES dossier(dossier);
4438    
4439    
4440     --
4441     -- Name: signataire_arrete_civilite_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
4442     --
4443    
4444     ALTER TABLE ONLY signataire_arrete
4445     ADD CONSTRAINT signataire_arrete_civilite_fkey FOREIGN KEY (civilite) REFERENCES civilite(civilite);
4446    
4447    
4448     --
4449     -- Name: terrain_dossier_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
4450     --
4451    
4452     ALTER TABLE ONLY terrain
4453     ADD CONSTRAINT terrain_dossier_fkey FOREIGN KEY (dossier) REFERENCES dossier(dossier);
4454    
4455    
4456     --
4457     -- Name: terrain_parcelle_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
4458     --
4459    
4460     ALTER TABLE ONLY terrain
4461     ADD CONSTRAINT terrain_parcelle_fkey FOREIGN KEY (parcelle) REFERENCES parcelle(parcelle);
4462    
4463    
4464     --
4465     -- Name: transition_etat_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
4466     --
4467    
4468     ALTER TABLE ONLY transition
4469     ADD CONSTRAINT transition_etat_fkey FOREIGN KEY (etat) REFERENCES etat(etat);
4470    
4471    
4472     --
4473     -- Name: transition_evenement_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
4474     --
4475    
4476     ALTER TABLE ONLY transition
4477     ADD CONSTRAINT transition_evenement_fkey FOREIGN KEY (evenement) REFERENCES evenement(evenement);
4478    
4479    
4480     --
4481     -- Name: travaux_dossier_autorisation_type_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
4482     --
4483    
4484     ALTER TABLE ONLY travaux
4485     ADD CONSTRAINT travaux_dossier_autorisation_type_fkey FOREIGN KEY (dossier_autorisation_type) REFERENCES dossier_autorisation_type(dossier_autorisation_type);
4486    
4487    
4488     --
4489     -- PostgreSQL database dump complete
4490     --
4491 fmichon 1844

Properties

Name Value
svn:keywords Id
[email protected]
 ViewVC Help
Powered by ViewVC 1.1.26