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

Properties

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