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

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

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 2664 by nhaye, Thu Dec 5 18:14:26 2013 UTC revision 2665 by nhaye, Tue Dec 31 16:19:15 2013 UTC
# Line 283  CREATE TABLE architecte ( Line 283  CREATE TABLE architecte (
283      email character varying(40) DEFAULT ''::character varying NOT NULL,      email character varying(40) DEFAULT ''::character varying NOT NULL,
284      note text,      note text,
285      frequent boolean,      frequent boolean,
286      nom_cabinet character varying(100)      nom_cabinet character varying(100),
287        conseil_regional character varying(100)
288  );  );
289    
290    
# Line 400  COMMENT ON COLUMN architecte.nom_cabinet Line 401  COMMENT ON COLUMN architecte.nom_cabinet
401    
402    
403  --  --
404    -- Name: COLUMN architecte.conseil_regional; Type: COMMENT; Schema: openads; Owner: -
405    --
406    
407    COMMENT ON COLUMN architecte.conseil_regional IS 'Conseil régional de l''architecte';
408    
409    
410    --
411  -- Name: architecte_seq; Type: SEQUENCE; Schema: openads; Owner: -  -- Name: architecte_seq; Type: SEQUENCE; Schema: openads; Owner: -
412  --  --
413    
# Line 1094  CREATE TABLE cerfa ( Line 1102  CREATE TABLE cerfa (
1102      avap_aut_inst_mob boolean DEFAULT false,      avap_aut_inst_mob boolean DEFAULT false,
1103      avap_aut_plant boolean DEFAULT false,      avap_aut_plant boolean DEFAULT false,
1104      avap_aut_auv_elec boolean DEFAULT false,      avap_aut_auv_elec boolean DEFAULT false,
1105      tax_dest_loc_tr boolean DEFAULT false      tax_dest_loc_tr boolean DEFAULT false,
1106        ope_proj_desc boolean DEFAULT false,
1107        tax_surf_tot_cstr boolean DEFAULT false
1108  );  );
1109    
1110    
# Line 2702  COMMENT ON COLUMN cerfa.tax_dest_loc_tr Line 2712  COMMENT ON COLUMN cerfa.tax_dest_loc_tr
2712    
2713    
2714  --  --
2715    -- Name: COLUMN cerfa.ope_proj_desc; Type: COMMENT; Schema: openads; Owner: -
2716    --
2717    
2718    COMMENT ON COLUMN cerfa.ope_proj_desc IS 'Va afficher le champ ope_proj_desc';
2719    
2720    
2721    --
2722    -- Name: COLUMN cerfa.tax_surf_tot_cstr; Type: COMMENT; Schema: openads; Owner: -
2723    --
2724    
2725    COMMENT ON COLUMN cerfa.tax_surf_tot_cstr IS 'Va afficher le champ tax_surf_tot_cstr
2726    ';
2727    
2728    
2729    --
2730  -- Name: cerfa_seq; Type: SEQUENCE; Schema: openads; Owner: -  -- Name: cerfa_seq; Type: SEQUENCE; Schema: openads; Owner: -
2731  --  --
2732    
# Line 4586  CREATE TABLE donnees_techniques ( Line 4611  CREATE TABLE donnees_techniques (
4611      co_trx_amgt character varying(250),      co_trx_amgt character varying(250),
4612      co_modif_aspect character varying(250),      co_modif_aspect character varying(250),
4613      co_modif_struct character varying(250),      co_modif_struct character varying(250),
4614      co_ouvr_elec character varying(250),      co_ouvr_elec boolean,
4615      co_ouvr_infra character varying(250),      co_ouvr_infra boolean,
4616      co_trx_imm character varying(250),      co_trx_imm character varying(250),
4617      co_cstr_shob character varying(250),      co_cstr_shob character varying(250),
4618      am_voyage_deb character varying(250),      am_voyage_deb character varying(250),
# Line 4598  CREATE TABLE donnees_techniques ( Line 4623  CREATE TABLE donnees_techniques (
4623      tr_total character varying(250),      tr_total character varying(250),
4624      tr_partiel character varying(250),      tr_partiel character varying(250),
4625      tr_desc character varying(250),      tr_desc character varying(250),
4626      avap_co_elt_pro character varying(250),      avap_co_elt_pro boolean,
4627      avap_nouv_haut_surf character varying(250),      avap_nouv_haut_surf boolean,
4628      avap_co_clot character varying(250),      avap_co_clot character varying(250),
4629      avap_aut_coup_aba_arb character varying(250),      avap_aut_coup_aba_arb character varying(250),
4630      avap_ouv_infra character varying(250),      avap_ouv_infra character varying(250),
4631      avap_aut_inst_mob character varying(250),      avap_aut_inst_mob character varying(250),
4632      avap_aut_plant character varying(250),      avap_aut_plant character varying(250),
4633      avap_aut_auv_elec character varying(250),      avap_aut_auv_elec character varying(250),
4634      tax_dest_loc_tr character varying(250)      tax_dest_loc_tr character varying(250),
4635        ope_proj_desc text,
4636        tax_surf_tot_cstr integer
4637  );  );
4638    
4639    
# Line 6049  COMMENT ON COLUMN donnees_techniques.dm_ Line 6076  COMMENT ON COLUMN donnees_techniques.dm_
6076  -- Name: COLUMN donnees_techniques.tax_surf_tot; Type: COMMENT; Schema: openads; Owner: -  -- Name: COLUMN donnees_techniques.tax_surf_tot; Type: COMMENT; Schema: openads; Owner: -
6077  --  --
6078    
6079  COMMENT ON COLUMN donnees_techniques.tax_surf_tot IS 'Superficie totale du (ou des) terrain(s) (en m²)';  COMMENT ON COLUMN donnees_techniques.tax_surf_tot IS 'Superficie taxable créée de la construction avant modification';
6080    
6081    
6082  --  --
6083  -- Name: COLUMN donnees_techniques.tax_surf; Type: COMMENT; Schema: openads; Owner: -  -- Name: COLUMN donnees_techniques.tax_surf; Type: COMMENT; Schema: openads; Owner: -
6084  --  --
6085    
6086  COMMENT ON COLUMN donnees_techniques.tax_surf IS 'Superficie du (ou des) terrain(s) à aménager (en m²)';  COMMENT ON COLUMN donnees_techniques.tax_surf IS 'Superficie taxable créée par la modification';
6087    
6088    
6089  --  --
# Line 6914  COMMENT ON COLUMN donnees_techniques.co_ Line 6941  COMMENT ON COLUMN donnees_techniques.co_
6941    
6942    
6943  --  --
6944    -- Name: COLUMN donnees_techniques.co_ouvr_elec; Type: COMMENT; Schema: openads; Owner: -
6945    --
6946    
6947    COMMENT ON COLUMN donnees_techniques.co_ouvr_elec IS 'Ouvrage et accessoires de lignes de distribution électrique';
6948    
6949    
6950    --
6951    -- Name: COLUMN donnees_techniques.co_ouvr_infra; Type: COMMENT; Schema: openads; Owner: -
6952    --
6953    
6954    COMMENT ON COLUMN donnees_techniques.co_ouvr_infra IS 'Ouvrage d''infrastructure';
6955    
6956    
6957    --
6958  -- Name: COLUMN donnees_techniques.am_lot_max_shob; Type: COMMENT; Schema: openads; Owner: -  -- Name: COLUMN donnees_techniques.am_lot_max_shob; Type: COMMENT; Schema: openads; Owner: -
6959  --  --
6960    
# Line 7005  COMMENT ON COLUMN donnees_techniques.ava Line 7046  COMMENT ON COLUMN donnees_techniques.ava
7046    
7047    
7048  --  --
7049    -- Name: COLUMN donnees_techniques.ope_proj_desc; Type: COMMENT; Schema: openads; Owner: -
7050    --
7051    
7052    COMMENT ON COLUMN donnees_techniques.ope_proj_desc IS 'Description de la demande / du projet';
7053    
7054    
7055    --
7056    -- Name: COLUMN donnees_techniques.tax_surf_tot_cstr; Type: COMMENT; Schema: openads; Owner: -
7057    --
7058    
7059    COMMENT ON COLUMN donnees_techniques.tax_surf_tot_cstr IS 'Surface taxable totale créée de la ou des construction(s) (en m²)';
7060    
7061    
7062    --
7063  -- Name: donnees_techniques_seq; Type: SEQUENCE; Schema: openads; Owner: -  -- Name: donnees_techniques_seq; Type: SEQUENCE; Schema: openads; Owner: -
7064  --  --
7065    
# Line 8544  CREATE TABLE evenement ( Line 8599  CREATE TABLE evenement (
8599      evenement_suivant_tacite integer,      evenement_suivant_tacite integer,
8600      evenement_retour_signature integer,      evenement_retour_signature integer,
8601      autorite_competente integer,      autorite_competente integer,
8602      retour boolean DEFAULT false      retour boolean DEFAULT false,
8603        non_verrouillable boolean DEFAULT false
8604  );  );
8605    
8606    
# Line 8675  COMMENT ON COLUMN evenement.retour IS 'P Line 8731  COMMENT ON COLUMN evenement.retour IS 'P
8731    
8732    
8733  --  --
8734    -- Name: COLUMN evenement.non_verrouillable; Type: COMMENT; Schema: openads; Owner: -
8735    --
8736    
8737    COMMENT ON COLUMN evenement.non_verrouillable IS 'Permet d''identifier un événement non verrouillable, c''est-à-dire que l''événement d''instruction sera toujours modifiable même si le dossier d''autorisation est clôturé';
8738    
8739    
8740    --
8741  -- Name: evenement_seq; Type: SEQUENCE; Schema: openads; Owner: -  -- Name: evenement_seq; Type: SEQUENCE; Schema: openads; Owner: -
8742  --  --
8743    
# Line 8933  CREATE TABLE instruction ( Line 8996  CREATE TABLE instruction (
8996      date_evenement date NOT NULL,      date_evenement date NOT NULL,
8997      evenement integer NOT NULL,      evenement integer NOT NULL,
8998      lettretype character varying(40) DEFAULT ''::character varying NOT NULL,      lettretype character varying(40) DEFAULT ''::character varying NOT NULL,
8999      complement text,      complement_om_html text,
9000      complement2 text,      complement2_om_html text,
9001      dossier character varying(30),      dossier character varying(30),
9002      action character varying(20),      action character varying(20),
9003      delai integer,      delai integer,
# Line 8954  CREATE TABLE instruction ( Line 9017  CREATE TABLE instruction (
9017      archive_date_achevement date,      archive_date_achevement date,
9018      archive_date_chantier date,      archive_date_chantier date,
9019      archive_date_conformite date,      archive_date_conformite date,
9020      complement3 text,      complement3_om_html text,
9021      complement4 text,      complement4_om_html text,
9022      complement5 text,      complement5_om_html text,
9023      complement6 text,      complement6_om_html text,
9024      complement7 text,      complement7_om_html text,
9025      complement8 text,      complement8_om_html text,
9026      complement9 text,      complement9_om_html text,
9027      complement10 text,      complement10_om_html text,
9028      complement11 text,      complement11_om_html text,
9029      complement12 text,      complement12_om_html text,
9030      complement13 text,      complement13_om_html text,
9031      complement14 text,      complement14_om_html text,
9032      complement15 text,      complement15_om_html text,
9033      avis_decision integer,      avis_decision integer,
9034      date_finalisation_courrier date,      date_finalisation_courrier date,
9035      date_envoi_signature date,      date_envoi_signature date,
# Line 9038  COMMENT ON COLUMN instruction.lettretype Line 9101  COMMENT ON COLUMN instruction.lettretype
9101    
9102    
9103  --  --
9104  -- Name: COLUMN instruction.complement; Type: COMMENT; Schema: openads; Owner: -  -- Name: COLUMN instruction.complement_om_html; Type: COMMENT; Schema: openads; Owner: -
9105  --  --
9106    
9107  COMMENT ON COLUMN instruction.complement IS 'Complément d''information';  COMMENT ON COLUMN instruction.complement_om_html IS 'Complément d''information';
9108    
9109    
9110  --  --
9111  -- Name: COLUMN instruction.complement2; Type: COMMENT; Schema: openads; Owner: -  -- Name: COLUMN instruction.complement2_om_html; Type: COMMENT; Schema: openads; Owner: -
9112  --  --
9113    
9114  COMMENT ON COLUMN instruction.complement2 IS 'Second complément d''information';  COMMENT ON COLUMN instruction.complement2_om_html IS 'Second complément d''information';
9115    
9116    
9117  --  --
# Line 9185  COMMENT ON COLUMN instruction.archive_da Line 9248  COMMENT ON COLUMN instruction.archive_da
9248    
9249    
9250  --  --
9251  -- Name: COLUMN instruction.complement3; Type: COMMENT; Schema: openads; Owner: -  -- Name: COLUMN instruction.complement3_om_html; Type: COMMENT; Schema: openads; Owner: -
9252  --  --
9253    
9254  COMMENT ON COLUMN instruction.complement3 IS 'Complément d''information';  COMMENT ON COLUMN instruction.complement3_om_html IS 'Complément d''information';
9255    
9256    
9257  --  --
9258  -- Name: COLUMN instruction.complement4; Type: COMMENT; Schema: openads; Owner: -  -- Name: COLUMN instruction.complement4_om_html; Type: COMMENT; Schema: openads; Owner: -
9259  --  --
9260    
9261  COMMENT ON COLUMN instruction.complement4 IS 'Complément d''information';  COMMENT ON COLUMN instruction.complement4_om_html IS 'Complément d''information';
9262    
9263    
9264  --  --
9265  -- Name: COLUMN instruction.complement5; Type: COMMENT; Schema: openads; Owner: -  -- Name: COLUMN instruction.complement5_om_html; Type: COMMENT; Schema: openads; Owner: -
9266  --  --
9267    
9268  COMMENT ON COLUMN instruction.complement5 IS 'Complément d''information';  COMMENT ON COLUMN instruction.complement5_om_html IS 'Complément d''information';
9269    
9270    
9271  --  --
9272  -- Name: COLUMN instruction.complement6; Type: COMMENT; Schema: openads; Owner: -  -- Name: COLUMN instruction.complement6_om_html; Type: COMMENT; Schema: openads; Owner: -
9273  --  --
9274    
9275  COMMENT ON COLUMN instruction.complement6 IS 'Complément d''information';  COMMENT ON COLUMN instruction.complement6_om_html IS 'Complément d''information';
9276    
9277    
9278  --  --
9279  -- Name: COLUMN instruction.complement7; Type: COMMENT; Schema: openads; Owner: -  -- Name: COLUMN instruction.complement7_om_html; Type: COMMENT; Schema: openads; Owner: -
9280  --  --
9281    
9282  COMMENT ON COLUMN instruction.complement7 IS 'Complément d''information';  COMMENT ON COLUMN instruction.complement7_om_html IS 'Complément d''information';
9283    
9284    
9285  --  --
9286  -- Name: COLUMN instruction.complement8; Type: COMMENT; Schema: openads; Owner: -  -- Name: COLUMN instruction.complement8_om_html; Type: COMMENT; Schema: openads; Owner: -
9287  --  --
9288    
9289  COMMENT ON COLUMN instruction.complement8 IS 'Complément d''information';  COMMENT ON COLUMN instruction.complement8_om_html IS 'Complément d''information';
9290    
9291    
9292  --  --
9293  -- Name: COLUMN instruction.complement9; Type: COMMENT; Schema: openads; Owner: -  -- Name: COLUMN instruction.complement9_om_html; Type: COMMENT; Schema: openads; Owner: -
9294  --  --
9295    
9296  COMMENT ON COLUMN instruction.complement9 IS 'Complément d''information';  COMMENT ON COLUMN instruction.complement9_om_html IS 'Complément d''information';
9297    
9298    
9299  --  --
9300  -- Name: COLUMN instruction.complement10; Type: COMMENT; Schema: openads; Owner: -  -- Name: COLUMN instruction.complement10_om_html; Type: COMMENT; Schema: openads; Owner: -
9301  --  --
9302    
9303  COMMENT ON COLUMN instruction.complement10 IS 'Complément d''information';  COMMENT ON COLUMN instruction.complement10_om_html IS 'Complément d''information';
9304    
9305    
9306  --  --
9307  -- Name: COLUMN instruction.complement11; Type: COMMENT; Schema: openads; Owner: -  -- Name: COLUMN instruction.complement11_om_html; Type: COMMENT; Schema: openads; Owner: -
9308  --  --
9309    
9310  COMMENT ON COLUMN instruction.complement11 IS 'Complément d''information';  COMMENT ON COLUMN instruction.complement11_om_html IS 'Complément d''information';
9311    
9312    
9313  --  --
9314  -- Name: COLUMN instruction.complement12; Type: COMMENT; Schema: openads; Owner: -  -- Name: COLUMN instruction.complement12_om_html; Type: COMMENT; Schema: openads; Owner: -
9315  --  --
9316    
9317  COMMENT ON COLUMN instruction.complement12 IS 'Complément d''information';  COMMENT ON COLUMN instruction.complement12_om_html IS 'Complément d''information';
9318    
9319    
9320  --  --
9321  -- Name: COLUMN instruction.complement13; Type: COMMENT; Schema: openads; Owner: -  -- Name: COLUMN instruction.complement13_om_html; Type: COMMENT; Schema: openads; Owner: -
9322  --  --
9323    
9324  COMMENT ON COLUMN instruction.complement13 IS 'Complément d''information';  COMMENT ON COLUMN instruction.complement13_om_html IS 'Complément d''information';
9325    
9326    
9327  --  --
9328  -- Name: COLUMN instruction.complement14; Type: COMMENT; Schema: openads; Owner: -  -- Name: COLUMN instruction.complement14_om_html; Type: COMMENT; Schema: openads; Owner: -
9329  --  --
9330    
9331  COMMENT ON COLUMN instruction.complement14 IS 'Complément d''information';  COMMENT ON COLUMN instruction.complement14_om_html IS 'Complément d''information';
9332    
9333    
9334  --  --
9335  -- Name: COLUMN instruction.complement15; Type: COMMENT; Schema: openads; Owner: -  -- Name: COLUMN instruction.complement15_om_html; Type: COMMENT; Schema: openads; Owner: -
9336  --  --
9337    
9338  COMMENT ON COLUMN instruction.complement15 IS 'Complément d''information';  COMMENT ON COLUMN instruction.complement15_om_html IS 'Complément d''information';
9339    
9340    
9341  --  --
# Line 10623  CREATE TABLE service ( Line 10686  CREATE TABLE service (
10686      notification_email boolean,      notification_email boolean,
10687      om_validite_debut date,      om_validite_debut date,
10688      om_validite_fin date,      om_validite_fin date,
10689      type_consultation character varying(70) DEFAULT 'avec_avis_attendu'::character varying NOT NULL      type_consultation character varying(70) DEFAULT 'avec_avis_attendu'::character varying NOT NULL,
10690        edition integer NOT NULL
10691  );  );
10692    
10693    
# Line 10733  COMMENT ON COLUMN service.type_consultat Line 10797  COMMENT ON COLUMN service.type_consultat
10797    
10798    
10799  --  --
10800    -- Name: COLUMN service.edition; Type: COMMENT; Schema: openads; Owner: -
10801    --
10802    
10803    COMMENT ON COLUMN service.edition IS 'Type d''édition pour la consultation';
10804    
10805    
10806    --
10807  -- Name: service_categorie; Type: TABLE; Schema: openads; Owner: -; Tablespace:  -- Name: service_categorie; Type: TABLE; Schema: openads; Owner: -; Tablespace:
10808  --  --
10809    
# Line 12693  ALTER TABLE ONLY rapport_instruction Line 12764  ALTER TABLE ONLY rapport_instruction
12764    
12765    
12766  --  --
12767    -- Name: service_edition_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
12768    --
12769    
12770    ALTER TABLE ONLY service
12771        ADD CONSTRAINT service_edition_fkey FOREIGN KEY (edition) REFERENCES om_etat(om_etat);
12772    
12773    
12774    --
12775  -- Name: sig_elyx_dossier_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -  -- Name: sig_elyx_dossier_fkey; Type: FK CONSTRAINT; Schema: openads; Owner: -
12776  --  --
12777    
Legend:
Removed from v.2664  
changed lines
  Added in v.2665
[email protected]
 ViewVC Help
Powered by ViewVC 1.1.26