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

Properties

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