--
--


-- SET statement_timeout = 0;
-- SET lock_timeout = 0;
-- SET idle_in_transaction_session_timeout = 0;
-- SET client_encoding = 'UTF8';
-- SET standard_conforming_strings = on;
-- SELECT pg_catalog.set_config('search_path', '', false);
-- SET check_function_bodies = false;
-- SET xmloption = content;
-- SET client_min_messages = warning;
-- SET row_security = off;

--
-- Name: openads; Type: SCHEMA; Schema: -; Owner: -
--

-- CREATE SCHEMA openads;


--
-- Name: lien_dossier_dossier_type_lien; Type: TYPE; Schema: openads; Owner: -
--

CREATE TYPE lien_dossier_dossier_type_lien AS ENUM (
    'manuel',
    'auto_recours'
);


--
-- Name: check_validite_unique(); Type: FUNCTION; Schema: openads; Owner: -
--

CREATE FUNCTION check_validite_unique() RETURNS trigger
    LANGUAGE plpgsql
    AS $$
DECLARE
mypieces RECORD;
BEGIN
IF (NEW.om_validite_fin > CURRENT_DATE
    OR NEW.om_validite_fin IS NULL
) THEN
    FOR mypieces IN
        SELECT
            *
        FROM
            document_numerise_type
        WHERE
            document_numerise_type.code LIKE NEW.code
            AND document_numerise_type.document_numerise_type != NEW.document_numerise_type
        LOOP
        IF (mypieces.om_validite_fin > CURRENT_DATE
            OR mypieces.om_validite_fin IS NULL
        ) THEN
            RAISE EXCEPTION 'Il ne peut pas y avoir deux codes valide pour un type de pièce';
        END IF;
    END LOOP;
END IF;
RETURN NEW;
END;
$$;


--
-- Name: fn_traitement_existant_filtre_da(); Type: FUNCTION; Schema: openads; Owner: -
--

CREATE FUNCTION fn_traitement_existant_filtre_da() RETURNS integer
    LANGUAGE plpgsql
    AS $$
DECLARE
om_parametre_var VARCHAR;
code_var varchar;
BEGIN

    -- Récupère le contenu du paramètre contenant la liste des codes filtrés
    om_parametre_var := (SELECT valeur FROM om_parametre WHERE libelle = 'da_listing_pieces_filtre')::VARCHAR;

    -- Si le paramètre de filtre des pièces dans le contexte des DA existe
    IF om_parametre_var != ''
    THEN
        -- Pour chaque code
        FOR code_var IN SELECT regexp_split_to_table(om_parametre_var, E';') AS code
        LOOP
            -- Met à jour les types de pièce
            UPDATE document_numerise_type
            SET aff_da = 't'
            WHERE code = code_var;
        END LOOP;
    END IF;

    --
    RETURN 0;
END;
$$;


-- SET default_tablespace = '';

-- SET default_with_oids = false;

--
-- Name: action; Type: TABLE; Schema: openads; Owner: -
--

CREATE TABLE action (
    action character varying(150) NOT NULL,
    libelle character varying(60) NOT NULL,
    regle_etat character varying(60),
    regle_delai character varying(60),
    regle_accord_tacite character varying(60),
    regle_avis character varying(60),
    regle_date_limite character varying(60),
    regle_date_notification_delai character varying(60),
    regle_date_complet character varying(60),
    regle_date_validite character varying(60),
    regle_date_decision character varying(60),
    regle_date_chantier character varying(60),
    regle_date_achevement character varying(60),
    regle_date_conformite character varying(60),
    regle_date_rejet character varying(60),
    regle_date_dernier_depot character varying(60),
    regle_date_limite_incompletude character varying(60),
    regle_delai_incompletude character varying(60),
    regle_autorite_competente character varying(60),
    regle_date_cloture_instruction character varying(60),
    regle_date_premiere_visite character varying(60),
    regle_date_derniere_visite character varying(60),
    regle_date_contradictoire character varying(60),
    regle_date_retour_contradictoire character varying(60),
    regle_date_ait character varying(60),
    regle_date_transmission_parquet character varying(60),
    regle_donnees_techniques1 character varying(60),
    regle_donnees_techniques2 character varying(60),
    regle_donnees_techniques3 character varying(60),
    regle_donnees_techniques4 character varying(60),
    regle_donnees_techniques5 character varying(60),
    cible_regle_donnees_techniques1 character varying(250),
    cible_regle_donnees_techniques2 character varying(250),
    cible_regle_donnees_techniques3 character varying(250),
    cible_regle_donnees_techniques4 character varying(250),
    cible_regle_donnees_techniques5 character varying(250),
    regle_dossier_instruction_type character varying(60) DEFAULT NULL::character varying,
    regle_date_affichage character varying(30),
    regle_pec_metier character varying(60),
    regle_a_qualifier character varying(60),
    regle_incompletude character varying(60),
    regle_incomplet_notifie character varying(60),
    regle_etat_pendant_incompletude character varying(60),
    regle_evenement_suivant_tacite_incompletude character varying(60)
);


--
-- Name: TABLE action; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON TABLE action IS 'Action effectuée lors de l''ajout d''un événement d''instruction';


--
-- Name: COLUMN action.action; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN action.action IS 'Identifiant unique';


--
-- Name: COLUMN action.libelle; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN action.libelle IS 'Libellé de l''action';


--
-- Name: COLUMN action.regle_etat; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN action.regle_etat IS 'Règle de calcul de l''état des dossiers d''instruction';


--
-- Name: COLUMN action.regle_delai; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN action.regle_delai IS 'Règle de calcul du délai des dossiers d''instruction';


--
-- Name: COLUMN action.regle_accord_tacite; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN action.regle_accord_tacite IS 'Règle de calcul de l''accord tacite des dossiers d''instruction';


--
-- Name: COLUMN action.regle_avis; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN action.regle_avis IS 'Règle de calcul de l''avis des dossiers d''instruction';


--
-- Name: COLUMN action.regle_date_limite; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN action.regle_date_limite IS 'Règle de calcul de la date limite des dossiers d''instruction';


--
-- Name: COLUMN action.regle_date_notification_delai; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN action.regle_date_notification_delai IS 'Règle de calcul de la date de notification de délai des dossiers d''instruction';


--
-- Name: COLUMN action.regle_date_complet; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN action.regle_date_complet IS 'Règle de calcul de la date de complétude des dossiers d''instruction';


--
-- Name: COLUMN action.regle_date_validite; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN action.regle_date_validite IS 'Règle de calcul de date de validité des dossiers d''instruction';


--
-- Name: COLUMN action.regle_date_decision; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN action.regle_date_decision IS 'Règle de calcul de date de décision des dossiers d''instruction';


--
-- Name: COLUMN action.regle_date_chantier; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN action.regle_date_chantier IS 'Règle de calcul de date d''ouverture de chantier chantier';


--
-- Name: COLUMN action.regle_date_achevement; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN action.regle_date_achevement IS 'Règle de calcul de date d''achèvement de travaux';


--
-- Name: COLUMN action.regle_date_conformite; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN action.regle_date_conformite IS 'Règle de calcul de date de conformité des dossiers d''instruction';


--
-- Name: COLUMN action.regle_date_rejet; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN action.regle_date_rejet IS 'Règle de calcul de la date de rejet des dossiers d''instruction';


--
-- Name: COLUMN action.regle_date_dernier_depot; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN action.regle_date_dernier_depot IS 'Règle de calcul de la date de dernier dépôt des dossiers d''instruction';


--
-- Name: COLUMN action.regle_date_limite_incompletude; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN action.regle_date_limite_incompletude IS 'Règle de calcul de la date limite d''incomplétude des dossiers d''instruction';


--
-- Name: COLUMN action.regle_delai_incompletude; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN action.regle_delai_incompletude IS 'Règle de calcul du délai d''incomplétude des dossiers d''instruction';


--
-- Name: COLUMN action.regle_autorite_competente; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN action.regle_autorite_competente IS 'Règle de calcul de l''autorité compétente des dossiers d''instruction';


--
-- Name: COLUMN action.regle_date_cloture_instruction; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN action.regle_date_cloture_instruction IS 'Règle de calcul de la date de cloture de l''instruction des dossiers d''instruction';


--
-- Name: COLUMN action.regle_date_premiere_visite; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN action.regle_date_premiere_visite IS 'Règle de calcul de la date de première visite des dossiers d''instruction';


--
-- Name: COLUMN action.regle_date_derniere_visite; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN action.regle_date_derniere_visite IS 'Règle de calcul de la date de dernière visite des dossiers d''instruction';


--
-- Name: COLUMN action.regle_date_contradictoire; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN action.regle_date_contradictoire IS 'Règle de calcul de la date de contradictoire des dossiers d''instruction';


--
-- Name: COLUMN action.regle_date_retour_contradictoire; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN action.regle_date_retour_contradictoire IS 'Règle de calcul de la date de retour de contradictoire des dossiers d''instruction';


--
-- Name: COLUMN action.regle_date_ait; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN action.regle_date_ait IS 'Règle de calcul de la date d''AIT des dossiers d''instruction';


--
-- Name: COLUMN action.regle_date_transmission_parquet; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN action.regle_date_transmission_parquet IS 'Règle de calcul de la date de transmission au parquet des dossiers d''instruction';


--
-- Name: COLUMN action.regle_donnees_techniques1; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN action.regle_donnees_techniques1 IS 'Règle de calcul d''un champ des données techniques';


--
-- Name: COLUMN action.regle_donnees_techniques2; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN action.regle_donnees_techniques2 IS 'Règle de calcul d''un champ des données techniques';


--
-- Name: COLUMN action.regle_donnees_techniques3; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN action.regle_donnees_techniques3 IS 'Règle de calcul d''un champ des données techniques';


--
-- Name: COLUMN action.regle_donnees_techniques4; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN action.regle_donnees_techniques4 IS 'Règle de calcul d''un champ des données techniques';


--
-- Name: COLUMN action.regle_donnees_techniques5; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN action.regle_donnees_techniques5 IS 'Règle de calcul d''un champ des données techniques';


--
-- Name: COLUMN action.cible_regle_donnees_techniques1; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN action.cible_regle_donnees_techniques1 IS 'Champ des données techniques ciblé par la règle 1';


--
-- Name: COLUMN action.cible_regle_donnees_techniques2; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN action.cible_regle_donnees_techniques2 IS 'Champ des données techniques ciblé par la règle 2';


--
-- Name: COLUMN action.cible_regle_donnees_techniques3; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN action.cible_regle_donnees_techniques3 IS 'Champ des données techniques ciblé par la règle 3';


--
-- Name: COLUMN action.cible_regle_donnees_techniques4; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN action.cible_regle_donnees_techniques4 IS 'Champ des données techniques ciblé par la règle 4';


--
-- Name: COLUMN action.cible_regle_donnees_techniques5; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN action.cible_regle_donnees_techniques5 IS 'Champ des données techniques ciblé par la règle 5';


--
-- Name: COLUMN action.regle_dossier_instruction_type; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN action.regle_dossier_instruction_type IS 'Règle de modification du type de dossier d''instruction';


--
-- Name: COLUMN action.regle_date_affichage; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN action.regle_date_affichage IS 'Règle de calcul de la date d''affichage de l''avis de dépôt du dossier d''instruction';


--
-- Name: COLUMN action.regle_pec_metier; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN action.regle_pec_metier IS 'Règle de calcul de la prise en compte métier d''un dossier d''instruction';


--
-- Name: COLUMN action.regle_a_qualifier; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN action.regle_a_qualifier IS 'Règle de calcul de la qualification d''un dossier d''instruction';


--
-- Name: COLUMN action.regle_incompletude; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN action.regle_incompletude IS 'Règle de calcul de l''incomplétude d''un dossier d''instruction';


--
-- Name: COLUMN action.regle_incomplet_notifie; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN action.regle_incomplet_notifie IS 'Règle de calcul de l''incomplétude notifiée d''un dossier d''instruction';


--
-- Name: COLUMN action.regle_etat_pendant_incompletude; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN action.regle_etat_pendant_incompletude IS 'Règle de calcul de l''état d''un dossier d''instruction pendant son incomplétude';


--
-- Name: COLUMN action.regle_evenement_suivant_tacite_incompletude; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN action.regle_evenement_suivant_tacite_incompletude IS 'Règle de calcul pour définir si l''événement suivant tacite paramétré sur l''événement concerne l''incomplétude du dossier d''instruction';


--
-- Name: affectation_automatique; Type: TABLE; Schema: openads; Owner: -
--

CREATE TABLE affectation_automatique (
    affectation_automatique integer NOT NULL,
    arrondissement integer,
    quartier integer,
    section character varying(2),
    instructeur integer,
    dossier_autorisation_type_detaille integer,
    om_collectivite integer NOT NULL,
    instructeur_2 integer,
    communes character varying(2000),
    affectation_manuelle character varying(100),
    dossier_instruction_type integer
);


--
-- Name: TABLE affectation_automatique; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON TABLE affectation_automatique IS 'Les dossiers d''instruction sont affectés aux instructeurs en fonction du type détaillé de dossier d''autorisation, arrondissement, quartier et section (dans cette priorité)';


--
-- Name: COLUMN affectation_automatique.affectation_automatique; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN affectation_automatique.affectation_automatique IS 'Identifiant unique';


--
-- Name: COLUMN affectation_automatique.arrondissement; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN affectation_automatique.arrondissement IS 'Arrondissement affecté à l''instructeur';


--
-- Name: COLUMN affectation_automatique.quartier; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN affectation_automatique.quartier IS 'Quartier affecté à l''instructeur';


--
-- Name: COLUMN affectation_automatique.section; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN affectation_automatique.section IS 'Section affectée à l''instructeur';


--
-- Name: COLUMN affectation_automatique.instructeur; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN affectation_automatique.instructeur IS 'Identifiant du premier instructeur ';


--
-- Name: COLUMN affectation_automatique.dossier_autorisation_type_detaille; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN affectation_automatique.dossier_autorisation_type_detaille IS 'Type détaillé de dossier d''autorisation affectés à l''instructeur';


--
-- Name: COLUMN affectation_automatique.om_collectivite; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN affectation_automatique.om_collectivite IS 'lien vers la collectivité concernée';


--
-- Name: COLUMN affectation_automatique.instructeur_2; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN affectation_automatique.instructeur_2 IS 'Identifiant du second instructeur';


--
-- Name: COLUMN affectation_automatique.communes; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN affectation_automatique.communes IS 'Communes associées';


--
-- Name: COLUMN affectation_automatique.affectation_manuelle; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN affectation_automatique.affectation_manuelle IS 'Affectation manuelle';


--
-- Name: COLUMN affectation_automatique.dossier_instruction_type; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN affectation_automatique.dossier_instruction_type IS 'Type de dossier d''instruction affecté à l''instructeur';


--
-- Name: affectation_automatique_seq; Type: SEQUENCE; Schema: openads; Owner: -
--

CREATE SEQUENCE affectation_automatique_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- Name: affectation_automatique_seq; Type: SEQUENCE OWNED BY; Schema: openads; Owner: -
--

ALTER SEQUENCE affectation_automatique_seq OWNED BY affectation_automatique.affectation_automatique;


--
-- Name: architecte; Type: TABLE; Schema: openads; Owner: -
--

CREATE TABLE architecte (
    architecte integer NOT NULL,
    nom character varying(50) NOT NULL,
    prenom character varying(50) DEFAULT ''::character varying NOT NULL,
    adresse1 character varying(50) DEFAULT ''::character varying NOT NULL,
    adresse2 character varying(50) DEFAULT ''::character varying NOT NULL,
    cp character varying(5) DEFAULT ''::character varying NOT NULL,
    ville character varying(50) DEFAULT ''::character varying NOT NULL,
    pays character varying(40) DEFAULT ''::character varying NOT NULL,
    inscription character varying(20) DEFAULT ''::character varying NOT NULL,
    telephone character varying(20) DEFAULT ''::character varying NOT NULL,
    fax character varying(14) DEFAULT ''::character varying NOT NULL,
    email character varying(60) DEFAULT ''::character varying NOT NULL,
    note text,
    frequent boolean,
    nom_cabinet character varying(100),
    conseil_regional character varying(100),
    lieu_dit character varying(39),
    boite_postale character varying(5),
    cedex character varying(5)
);


--
-- Name: TABLE architecte; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON TABLE architecte IS 'Coordonnées d''un architecte';


--
-- Name: COLUMN architecte.architecte; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN architecte.architecte IS 'Identifiant unique';


--
-- Name: COLUMN architecte.nom; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN architecte.nom IS 'Nom de famille de l''architecte';


--
-- Name: COLUMN architecte.prenom; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN architecte.prenom IS 'Prénom de l''architecte';


--
-- Name: COLUMN architecte.adresse1; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN architecte.adresse1 IS 'Adresse de l''architecte';


--
-- Name: COLUMN architecte.adresse2; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN architecte.adresse2 IS 'Complément d''adresse de l''architecte';


--
-- Name: COLUMN architecte.cp; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN architecte.cp IS 'Code postal de l''adresse de l''architecte';


--
-- Name: COLUMN architecte.ville; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN architecte.ville IS 'Ville de l''adresse de l''architecte';


--
-- Name: COLUMN architecte.pays; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN architecte.pays IS 'Pays de résidence de l''architecte';


--
-- Name: COLUMN architecte.inscription; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN architecte.inscription IS 'Numéro d''inscription au conseil national de l''ordre des architectes de l''architecte';


--
-- Name: COLUMN architecte.telephone; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN architecte.telephone IS 'Téléphone de l''architecte';


--
-- Name: COLUMN architecte.fax; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN architecte.fax IS 'Fax de l''architecte';


--
-- Name: COLUMN architecte.email; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN architecte.email IS 'Email de l''architecte';


--
-- Name: COLUMN architecte.note; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN architecte.note IS 'Note à propos de l''architecte';


--
-- Name: COLUMN architecte.frequent; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN architecte.frequent IS 'Permet de faire apparaître l''architecte dans la recherche sur les architectes dans les données techniques';


--
-- Name: COLUMN architecte.nom_cabinet; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN architecte.nom_cabinet IS 'Nom du cabinet dans lequel travail l''architecte';


--
-- Name: COLUMN architecte.conseil_regional; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN architecte.conseil_regional IS 'Conseil régional de l''architecte';


--
-- Name: COLUMN architecte.lieu_dit; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN architecte.lieu_dit IS 'Lieu-dit de l''adresse';


--
-- Name: COLUMN architecte.boite_postale; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN architecte.boite_postale IS 'Boîte postale de l''adresse';


--
-- Name: COLUMN architecte.cedex; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN architecte.cedex IS 'Cedex de l''adresse';


--
-- Name: architecte_seq; Type: SEQUENCE; Schema: openads; Owner: -
--

CREATE SEQUENCE architecte_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- Name: architecte_seq; Type: SEQUENCE OWNED BY; Schema: openads; Owner: -
--

ALTER SEQUENCE architecte_seq OWNED BY architecte.architecte;


--
-- Name: arrondissement; Type: TABLE; Schema: openads; Owner: -
--

CREATE TABLE arrondissement (
    arrondissement integer NOT NULL,
    libelle character varying(3) NOT NULL,
    code_postal character varying(5) NOT NULL,
    code_impots character varying(3) NOT NULL
);


--
-- Name: TABLE arrondissement; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON TABLE arrondissement IS 'Division territoriale, administrative de la ville';


--
-- Name: COLUMN arrondissement.arrondissement; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN arrondissement.arrondissement IS 'Identifiant unique';


--
-- Name: COLUMN arrondissement.libelle; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN arrondissement.libelle IS 'Libellé de l''arrondissement';


--
-- Name: COLUMN arrondissement.code_postal; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN arrondissement.code_postal IS 'Code postal de l''arrondissement';


--
-- Name: COLUMN arrondissement.code_impots; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN arrondissement.code_impots IS 'Code impôt de l''arrondissement, notamment utilisé pour les références cadastrales afin de récupérer l''adresse depuis un SIG';


--
-- Name: arrondissement_seq; Type: SEQUENCE; Schema: openads; Owner: -
--

CREATE SEQUENCE arrondissement_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- Name: arrondissement_seq; Type: SEQUENCE OWNED BY; Schema: openads; Owner: -
--

ALTER SEQUENCE arrondissement_seq OWNED BY arrondissement.arrondissement;


--
-- Name: autorite_competente; Type: TABLE; Schema: openads; Owner: -
--

CREATE TABLE autorite_competente (
    autorite_competente integer NOT NULL,
    code character varying(20),
    libelle character varying(100),
    description text,
    autorite_competente_sitadel integer NOT NULL
);


--
-- Name: TABLE autorite_competente; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON TABLE autorite_competente IS 'Autorité compétente pour rendre une décision sur une instruction';


--
-- Name: COLUMN autorite_competente.autorite_competente; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN autorite_competente.autorite_competente IS 'Identifiant unique';


--
-- Name: COLUMN autorite_competente.code; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN autorite_competente.code IS 'Code de l''autorité compétente';


--
-- Name: COLUMN autorite_competente.libelle; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN autorite_competente.libelle IS 'Libellé de l''autorité compétente';


--
-- Name: COLUMN autorite_competente.description; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN autorite_competente.description IS 'Description de l''autorité compétente';


--
-- Name: COLUMN autorite_competente.autorite_competente_sitadel; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN autorite_competente.autorite_competente_sitadel IS 'Code sitadel de l''autorité compétente';


--
-- Name: autorite_competente_seq; Type: SEQUENCE; Schema: openads; Owner: -
--

CREATE SEQUENCE autorite_competente_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- Name: autorite_competente_seq; Type: SEQUENCE OWNED BY; Schema: openads; Owner: -
--

ALTER SEQUENCE autorite_competente_seq OWNED BY autorite_competente.autorite_competente;


--
-- Name: avis_consultation; Type: TABLE; Schema: openads; Owner: -
--

CREATE TABLE avis_consultation (
    libelle character varying(50) NOT NULL,
    abrege character varying(10),
    om_validite_debut date,
    om_validite_fin date,
    avis_consultation integer NOT NULL,
    code character varying(10)
);


--
-- Name: TABLE avis_consultation; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON TABLE avis_consultation IS 'Avis décidé après une consultation';


--
-- Name: COLUMN avis_consultation.libelle; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN avis_consultation.libelle IS 'Libellé de l''avis';


--
-- Name: COLUMN avis_consultation.abrege; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN avis_consultation.abrege IS 'Abréviation de l''avis';


--
-- Name: COLUMN avis_consultation.om_validite_debut; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN avis_consultation.om_validite_debut IS 'Date de début de validité de l''avis';


--
-- Name: COLUMN avis_consultation.om_validite_fin; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN avis_consultation.om_validite_fin IS 'Date de fin de validité de l''avis';


--
-- Name: COLUMN avis_consultation.avis_consultation; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN avis_consultation.avis_consultation IS 'Identifiant unique';


--
-- Name: COLUMN avis_consultation.code; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN avis_consultation.code IS 'Code unique de l''avis de consultation';


--
-- Name: avis_consultation_seq; Type: SEQUENCE; Schema: openads; Owner: -
--

CREATE SEQUENCE avis_consultation_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- Name: avis_consultation_seq; Type: SEQUENCE OWNED BY; Schema: openads; Owner: -
--

ALTER SEQUENCE avis_consultation_seq OWNED BY avis_consultation.avis_consultation;


--
-- Name: avis_decision; Type: TABLE; Schema: openads; Owner: -
--

CREATE TABLE avis_decision (
    libelle character varying(50) NOT NULL,
    typeavis character(1) DEFAULT ''::bpchar NOT NULL,
    sitadel character(1) DEFAULT ''::bpchar NOT NULL,
    sitadel_motif character(1) DEFAULT ''::bpchar NOT NULL,
    avis_decision integer NOT NULL,
    tacite boolean DEFAULT false,
    avis_decision_type integer,
    avis_decision_nature integer,
    prescription boolean DEFAULT false
);


--
-- Name: TABLE avis_decision; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON TABLE avis_decision IS 'Avis décidé après l''instruction d''un dossier d''instruction';


--
-- Name: COLUMN avis_decision.libelle; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN avis_decision.libelle IS 'Libellé de l''avis';


--
-- Name: COLUMN avis_decision.typeavis; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN avis_decision.typeavis IS 'Type d''avis à rendre';


--
-- Name: COLUMN avis_decision.sitadel; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN avis_decision.sitadel IS 'Type de mouvement sitadel';


--
-- Name: COLUMN avis_decision.sitadel_motif; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN avis_decision.sitadel_motif IS 'Motif de refus sitadel';


--
-- Name: COLUMN avis_decision.avis_decision; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN avis_decision.avis_decision IS 'Identifiant unique';


--
-- Name: COLUMN avis_decision.tacite; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN avis_decision.tacite IS 'Indique si l''avis de décision est appliqué par tacicité';


--
-- Name: COLUMN avis_decision.avis_decision_type; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN avis_decision.avis_decision_type IS 'Type de l''avis de décision';


--
-- Name: COLUMN avis_decision.avis_decision_nature; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN avis_decision.avis_decision_nature IS 'Nature de l''avis de décision';


--
-- Name: COLUMN avis_decision.prescription; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN avis_decision.prescription IS 'Identifie si l''avis de décision concerne une prescription archéologique';


--
-- Name: avis_decision_nature; Type: TABLE; Schema: openads; Owner: -
--

CREATE TABLE avis_decision_nature (
    avis_decision_nature integer NOT NULL,
    code character varying(10),
    libelle character varying(255) NOT NULL,
    description text,
    om_validite_debut date,
    om_validite_fin date
);


--
-- Name: TABLE avis_decision_nature; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON TABLE avis_decision_nature IS 'Nature d''avis décision';


--
-- Name: COLUMN avis_decision_nature.avis_decision_nature; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN avis_decision_nature.avis_decision_nature IS 'Identifiant technique de la nature d''avis décision';


--
-- Name: COLUMN avis_decision_nature.code; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN avis_decision_nature.code IS 'Code de la nature d''avis décision';


--
-- Name: COLUMN avis_decision_nature.libelle; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN avis_decision_nature.libelle IS 'Libellé de la nature d''avis décision';


--
-- Name: COLUMN avis_decision_nature.description; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN avis_decision_nature.description IS 'Description de la nature d''avis décision';


--
-- Name: COLUMN avis_decision_nature.om_validite_debut; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN avis_decision_nature.om_validite_debut IS 'Date de validité (début) de la nature d''avis décision';


--
-- Name: COLUMN avis_decision_nature.om_validite_fin; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN avis_decision_nature.om_validite_fin IS 'Date de validité (fin) de la nature d''avis décision';


--
-- Name: avis_decision_nature_seq; Type: SEQUENCE; Schema: openads; Owner: -
--

CREATE SEQUENCE avis_decision_nature_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- Name: avis_decision_nature_seq; Type: SEQUENCE OWNED BY; Schema: openads; Owner: -
--

ALTER SEQUENCE avis_decision_nature_seq OWNED BY avis_decision_nature.avis_decision_nature;


--
-- Name: avis_decision_seq; Type: SEQUENCE; Schema: openads; Owner: -
--

CREATE SEQUENCE avis_decision_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- Name: avis_decision_seq; Type: SEQUENCE OWNED BY; Schema: openads; Owner: -
--

ALTER SEQUENCE avis_decision_seq OWNED BY avis_decision.avis_decision;


--
-- Name: avis_decision_type; Type: TABLE; Schema: openads; Owner: -
--

CREATE TABLE avis_decision_type (
    avis_decision_type integer NOT NULL,
    code character varying(10),
    libelle character varying(255) NOT NULL,
    description text,
    om_validite_debut date,
    om_validite_fin date
);


--
-- Name: TABLE avis_decision_type; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON TABLE avis_decision_type IS 'Type d''avis décision';


--
-- Name: COLUMN avis_decision_type.avis_decision_type; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN avis_decision_type.avis_decision_type IS 'Identifiant technique du type d''avis décision';


--
-- Name: COLUMN avis_decision_type.code; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN avis_decision_type.code IS 'Code du type d''avis décision';


--
-- Name: COLUMN avis_decision_type.libelle; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN avis_decision_type.libelle IS 'Libellé du type d''avis décision';


--
-- Name: COLUMN avis_decision_type.description; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN avis_decision_type.description IS 'Description du type d''avis décision';


--
-- Name: COLUMN avis_decision_type.om_validite_debut; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN avis_decision_type.om_validite_debut IS 'Date de validité (début) du type d''avis décision';


--
-- Name: COLUMN avis_decision_type.om_validite_fin; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN avis_decision_type.om_validite_fin IS 'Date de validité (fin) du type d''avis décision';


--
-- Name: avis_decision_type_seq; Type: SEQUENCE; Schema: openads; Owner: -
--

CREATE SEQUENCE avis_decision_type_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- Name: avis_decision_type_seq; Type: SEQUENCE OWNED BY; Schema: openads; Owner: -
--

ALTER SEQUENCE avis_decision_type_seq OWNED BY avis_decision_type.avis_decision_type;


--
-- Name: bible; Type: TABLE; Schema: openads; Owner: -
--

CREATE TABLE bible (
    bible integer NOT NULL,
    libelle character varying(60) NOT NULL,
    evenement integer,
    contenu text NOT NULL,
    complement integer,
    automatique character(3) DEFAULT ''::bpchar NOT NULL,
    dossier_autorisation_type integer,
    om_collectivite integer NOT NULL
);


--
-- Name: TABLE bible; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON TABLE bible IS 'Bible qui regroupe des textes applicables sur les événements d''instruction';


--
-- Name: COLUMN bible.bible; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN bible.bible IS 'Identifiant unique';


--
-- Name: COLUMN bible.libelle; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN bible.libelle IS 'Libellé du texte de la bible';


--
-- Name: COLUMN bible.evenement; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN bible.evenement IS 'Événement sur lequel le texte de la bible est applicable';


--
-- Name: COLUMN bible.contenu; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN bible.contenu IS 'Texte de la bible';


--
-- Name: COLUMN bible.complement; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN bible.complement IS 'Complément de l''événement d''instruction sur lequel s''applique le texte de la bible';


--
-- Name: COLUMN bible.automatique; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN bible.automatique IS 'Applique automatiquement le texte de la bible sur la lettre type';


--
-- Name: COLUMN bible.dossier_autorisation_type; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN bible.dossier_autorisation_type IS 'Type du dossier d''autorisation sur lequel le texte de la bible est applicable';


--
-- Name: COLUMN bible.om_collectivite; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN bible.om_collectivite IS 'Lien vers la collectivité concernée.';


--
-- Name: bible_seq; Type: SEQUENCE; Schema: openads; Owner: -
--

CREATE SEQUENCE bible_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- Name: bible_seq; Type: SEQUENCE OWNED BY; Schema: openads; Owner: -
--

ALTER SEQUENCE bible_seq OWNED BY bible.bible;


--
-- Name: blocnote; Type: TABLE; Schema: openads; Owner: -
--

CREATE TABLE blocnote (
    blocnote integer NOT NULL,
    categorie character varying(20) NOT NULL,
    note text NOT NULL,
    dossier character varying(30)
);


--
-- Name: TABLE blocnote; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON TABLE blocnote IS 'Annotation concernant le dossier d''instruction lié';


--
-- Name: COLUMN blocnote.blocnote; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN blocnote.blocnote IS 'Identifiant unique';


--
-- Name: COLUMN blocnote.categorie; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN blocnote.categorie IS 'Catégorie de la note';


--
-- Name: COLUMN blocnote.note; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN blocnote.note IS 'Contenu de la note';


--
-- Name: COLUMN blocnote.dossier; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN blocnote.dossier IS 'Dossier d''instruction lié';


--
-- Name: blocnote_seq; Type: SEQUENCE; Schema: openads; Owner: -
--

CREATE SEQUENCE blocnote_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- Name: blocnote_seq; Type: SEQUENCE OWNED BY; Schema: openads; Owner: -
--

ALTER SEQUENCE blocnote_seq OWNED BY blocnote.blocnote;


--
-- Name: cerfa; Type: TABLE; Schema: openads; Owner: -
--

CREATE TABLE cerfa (
    cerfa integer NOT NULL,
    libelle character varying(200),
    code character varying(20),
    om_validite_debut date,
    om_validite_fin date,
    am_lotiss boolean,
    am_autre_div boolean,
    am_camping boolean,
    am_caravane boolean,
    am_carav_duree boolean,
    am_statio boolean,
    am_statio_cont boolean,
    am_affou_exhau boolean,
    am_affou_exhau_sup boolean,
    am_affou_prof boolean,
    am_exhau_haut boolean,
    am_coupe_abat boolean,
    am_prot_plu boolean,
    am_prot_muni boolean,
    am_mobil_voyage boolean,
    am_aire_voyage boolean,
    am_rememb_afu boolean,
    am_parc_resid_loi boolean,
    am_sport_moto boolean,
    am_sport_attrac boolean,
    am_sport_golf boolean,
    am_mob_art boolean,
    am_modif_voie_esp boolean,
    am_plant_voie_esp boolean,
    am_chem_ouv_esp boolean,
    am_agri_peche boolean,
    am_crea_voie boolean,
    am_modif_voie_exist boolean,
    am_crea_esp_sauv boolean,
    am_crea_esp_class boolean,
    am_projet_desc boolean,
    am_terr_surf boolean,
    am_tranche_desc boolean,
    am_lot_max_nb boolean,
    am_lot_max_shon boolean,
    am_lot_cstr_cos boolean,
    am_lot_cstr_plan boolean,
    am_lot_cstr_vente boolean,
    am_lot_fin_diff boolean,
    am_lot_consign boolean,
    am_lot_gar_achev boolean,
    am_lot_vente_ant boolean,
    am_empl_nb boolean,
    am_tente_nb boolean,
    am_carav_nb boolean,
    am_mobil_nb boolean,
    am_pers_nb boolean,
    am_empl_hll_nb boolean,
    am_hll_shon boolean,
    am_periode_exploit boolean,
    am_exist_agrand boolean,
    am_exist_date boolean,
    am_exist_num boolean,
    am_exist_nb_avant boolean,
    am_exist_nb_apres boolean,
    am_coupe_bois boolean,
    am_coupe_parc boolean,
    am_coupe_align boolean,
    am_coupe_ess boolean,
    am_coupe_age boolean,
    am_coupe_dens boolean,
    am_coupe_qual boolean,
    am_coupe_trait boolean,
    am_coupe_autr boolean,
    co_archi_recours boolean,
    co_cstr_nouv boolean,
    co_cstr_exist boolean,
    co_cloture boolean,
    co_elec_tension boolean,
    co_div_terr boolean,
    co_projet_desc boolean,
    co_anx_pisc boolean,
    co_anx_gara boolean,
    co_anx_veran boolean,
    co_anx_abri boolean,
    co_anx_autr boolean,
    co_anx_autr_desc boolean,
    co_tot_log_nb boolean,
    co_tot_ind_nb boolean,
    co_tot_coll_nb boolean,
    co_mais_piece_nb boolean,
    co_mais_niv_nb boolean,
    co_fin_lls_nb boolean,
    co_fin_aa_nb boolean,
    co_fin_ptz_nb boolean,
    co_fin_autr_nb boolean,
    co_fin_autr_desc boolean,
    co_mais_contrat_ind boolean,
    co_uti_pers boolean,
    co_uti_vente boolean,
    co_uti_loc boolean,
    co_uti_princ boolean,
    co_uti_secon boolean,
    co_resid_agees boolean,
    co_resid_etud boolean,
    co_resid_tourism boolean,
    co_resid_hot_soc boolean,
    co_resid_soc boolean,
    co_resid_hand boolean,
    co_resid_autr boolean,
    co_resid_autr_desc boolean,
    co_foyer_chamb_nb boolean,
    co_log_1p_nb boolean,
    co_log_2p_nb boolean,
    co_log_3p_nb boolean,
    co_log_4p_nb boolean,
    co_log_5p_nb boolean,
    co_log_6p_nb boolean,
    co_bat_niv_nb boolean,
    co_trx_exten boolean,
    co_trx_surelev boolean,
    co_trx_nivsup boolean,
    co_demont_periode boolean,
    co_sp_transport boolean,
    co_sp_enseign boolean,
    co_sp_act_soc boolean,
    co_sp_ouvr_spe boolean,
    co_sp_sante boolean,
    co_sp_culture boolean,
    co_statio_avt_nb boolean,
    co_statio_apr_nb boolean,
    co_statio_adr boolean,
    co_statio_place_nb boolean,
    co_statio_tot_surf boolean,
    co_statio_tot_shob boolean,
    co_statio_comm_cin_surf boolean,
    tab_surface integer,
    dm_constr_dates boolean,
    dm_total boolean,
    dm_partiel boolean,
    dm_projet_desc boolean,
    dm_tot_log_nb boolean,
    tax_surf_tot boolean,
    tax_surf boolean,
    tax_surf_suppr_mod boolean,
    tab_tax_su_princ integer,
    tab_tax_su_heber integer,
    tab_tax_su_secon integer,
    tab_tax_su_tot integer,
    tax_ext_pret boolean,
    tax_ext_desc boolean,
    tax_surf_tax_exist_cons boolean,
    tax_log_exist_nb boolean,
    tax_trx_presc_ppr boolean,
    tax_monu_hist boolean,
    tax_comm_nb boolean,
    tab_tax_su_non_habit_surf integer,
    tab_tax_am integer,
    vsd_surf_planch_smd boolean,
    vsd_unit_fonc_sup boolean,
    vsd_unit_fonc_constr_sup boolean,
    vsd_val_terr boolean,
    vsd_const_sxist_non_dem_surf boolean,
    vsd_rescr_fisc boolean,
    pld_val_terr boolean,
    pld_const_exist_dem boolean,
    pld_const_exist_dem_surf boolean,
    code_cnil boolean,
    terr_juri_titul boolean,
    terr_juri_lot boolean,
    terr_juri_zac boolean,
    terr_juri_afu boolean,
    terr_juri_pup boolean,
    terr_juri_oin boolean,
    terr_juri_desc boolean,
    terr_div_surf_etab boolean,
    terr_div_surf_av_div boolean,
    doc_date boolean,
    doc_tot_trav boolean,
    doc_tranche_trav boolean,
    doc_tranche_trav_desc boolean,
    doc_surf boolean,
    doc_nb_log boolean,
    doc_nb_log_indiv boolean,
    doc_nb_log_coll boolean,
    doc_nb_log_lls boolean,
    doc_nb_log_aa boolean,
    doc_nb_log_ptz boolean,
    doc_nb_log_autre boolean,
    daact_date boolean,
    daact_date_chgmt_dest boolean,
    daact_tot_trav boolean,
    daact_tranche_trav boolean,
    daact_tranche_trav_desc boolean,
    daact_surf boolean,
    daact_nb_log boolean,
    daact_nb_log_indiv boolean,
    daact_nb_log_coll boolean,
    daact_nb_log_lls boolean,
    daact_nb_log_aa boolean,
    daact_nb_log_ptz boolean,
    daact_nb_log_autre boolean,
    am_div_mun boolean,
    co_perf_energ boolean,
    architecte boolean,
    co_statio_avt_shob boolean DEFAULT false,
    co_statio_apr_shob boolean DEFAULT false,
    co_statio_avt_surf boolean DEFAULT false,
    co_statio_apr_surf boolean DEFAULT false,
    co_trx_amgt boolean DEFAULT false,
    co_modif_aspect boolean DEFAULT false,
    co_modif_struct boolean DEFAULT false,
    co_ouvr_elec boolean DEFAULT false,
    co_ouvr_infra boolean DEFAULT false,
    co_trx_imm boolean DEFAULT false,
    co_cstr_shob boolean DEFAULT false,
    am_voyage_deb boolean DEFAULT false,
    am_voyage_fin boolean DEFAULT false,
    am_modif_amgt boolean DEFAULT false,
    am_lot_max_shob boolean DEFAULT false,
    mod_desc boolean DEFAULT false,
    tr_total boolean DEFAULT false,
    tr_partiel boolean DEFAULT false,
    tr_desc boolean DEFAULT false,
    avap_co_elt_pro boolean DEFAULT false,
    avap_nouv_haut_surf boolean DEFAULT false,
    avap_co_clot boolean DEFAULT false,
    avap_aut_coup_aba_arb boolean DEFAULT false,
    avap_ouv_infra boolean DEFAULT false,
    avap_aut_inst_mob boolean DEFAULT false,
    avap_aut_plant boolean DEFAULT false,
    avap_aut_auv_elec boolean DEFAULT false,
    tax_dest_loc_tr boolean DEFAULT false,
    ope_proj_desc boolean DEFAULT false,
    tax_surf_tot_cstr boolean DEFAULT false,
    tax_surf_loc_stat boolean DEFAULT false,
    tax_log_ap_trvx_nb boolean DEFAULT false,
    tax_am_statio_ext_cr boolean DEFAULT false,
    tax_sup_bass_pisc_cr boolean DEFAULT false,
    tax_empl_ten_carav_mobil_nb_cr boolean DEFAULT false,
    tax_empl_hll_nb_cr boolean DEFAULT false,
    tax_eol_haut_nb_cr boolean DEFAULT false,
    tax_pann_volt_sup_cr boolean DEFAULT false,
    tax_surf_loc_arch boolean DEFAULT false,
    tax_surf_pisc_arch boolean DEFAULT false,
    tax_am_statio_ext_arch boolean DEFAULT false,
    tab_tax_su_parc_statio_expl_comm integer,
    tax_empl_ten_carav_mobil_nb_arch boolean DEFAULT false,
    tax_empl_hll_nb_arch boolean DEFAULT false,
    tax_eol_haut_nb_arch boolean DEFAULT false,
    ope_proj_div_co boolean DEFAULT false,
    ope_proj_div_contr boolean DEFAULT false,
    tax_desc boolean DEFAULT false,
    erp_cstr_neuve boolean DEFAULT false,
    erp_trvx_acc boolean DEFAULT false,
    erp_extension boolean DEFAULT false,
    erp_rehab boolean DEFAULT false,
    erp_trvx_am boolean DEFAULT false,
    erp_vol_nouv_exist boolean DEFAULT false,
    tab_erp_eff integer,
    erp_class_cat boolean DEFAULT false,
    erp_class_type boolean DEFAULT false,
    tax_surf_abr_jard_pig_colom boolean DEFAULT false,
    tax_su_non_habit_abr_jard_pig_colom boolean DEFAULT false,
    dia_imm_non_bati boolean DEFAULT false,
    dia_imm_bati_terr_propr boolean DEFAULT false,
    dia_imm_bati_terr_autr boolean DEFAULT false,
    dia_imm_bati_terr_autr_desc boolean DEFAULT false,
    dia_bat_copro boolean DEFAULT false,
    dia_bat_copro_desc boolean DEFAULT false,
    dia_lot_numero boolean DEFAULT false,
    dia_lot_bat boolean DEFAULT false,
    dia_lot_etage boolean DEFAULT false,
    dia_lot_quote_part boolean DEFAULT false,
    dia_us_hab boolean DEFAULT false,
    dia_us_pro boolean DEFAULT false,
    dia_us_mixte boolean DEFAULT false,
    dia_us_comm boolean DEFAULT false,
    dia_us_agr boolean DEFAULT false,
    dia_us_autre boolean DEFAULT false,
    dia_us_autre_prec boolean DEFAULT false,
    dia_occ_prop boolean DEFAULT false,
    dia_occ_loc boolean DEFAULT false,
    dia_occ_sans_occ boolean DEFAULT false,
    dia_occ_autre boolean DEFAULT false,
    dia_occ_autre_prec boolean DEFAULT false,
    dia_mod_cess_prix_vente boolean DEFAULT false,
    dia_mod_cess_prix_vente_mob boolean DEFAULT false,
    dia_mod_cess_prix_vente_cheptel boolean DEFAULT false,
    dia_mod_cess_prix_vente_recol boolean DEFAULT false,
    dia_mod_cess_prix_vente_autre boolean DEFAULT false,
    dia_mod_cess_commi boolean DEFAULT false,
    dia_mod_cess_commi_ttc boolean DEFAULT false,
    dia_mod_cess_commi_ht boolean DEFAULT false,
    dia_acquereur_nom_prenom boolean DEFAULT false,
    dia_acquereur_adr_num_voie boolean DEFAULT false,
    dia_acquereur_adr_ext boolean DEFAULT false,
    dia_acquereur_adr_type_voie boolean DEFAULT false,
    dia_acquereur_adr_nom_voie boolean DEFAULT false,
    dia_acquereur_adr_lieu_dit_bp boolean DEFAULT false,
    dia_acquereur_adr_cp boolean DEFAULT false,
    dia_acquereur_adr_localite boolean DEFAULT false,
    dia_observation boolean DEFAULT false,
    tab_surface2 integer,
    dia_occ_sol_su_terre boolean DEFAULT false,
    dia_occ_sol_su_pres boolean DEFAULT false,
    dia_occ_sol_su_verger boolean DEFAULT false,
    dia_occ_sol_su_vigne boolean DEFAULT false,
    dia_occ_sol_su_bois boolean DEFAULT false,
    dia_occ_sol_su_lande boolean DEFAULT false,
    dia_occ_sol_su_carriere boolean DEFAULT false,
    dia_occ_sol_su_eau_cadastree boolean DEFAULT false,
    dia_occ_sol_su_jardin boolean DEFAULT false,
    dia_occ_sol_su_terr_batir boolean DEFAULT false,
    dia_occ_sol_su_terr_agr boolean DEFAULT false,
    dia_occ_sol_su_sol boolean DEFAULT false,
    dia_bati_vend_tot boolean DEFAULT false,
    dia_bati_vend_tot_txt boolean DEFAULT false,
    dia_su_co_sol boolean DEFAULT false,
    dia_su_util_hab boolean DEFAULT false,
    dia_nb_niv boolean DEFAULT false,
    dia_nb_appart boolean DEFAULT false,
    dia_nb_autre_loc boolean DEFAULT false,
    dia_vente_lot_volume boolean DEFAULT false,
    dia_vente_lot_volume_txt boolean DEFAULT false,
    dia_lot_nat_su boolean DEFAULT false,
    dia_lot_bat_achv_plus_10 boolean DEFAULT false,
    dia_lot_bat_achv_moins_10 boolean DEFAULT false,
    dia_lot_regl_copro_publ_hypo_plus_10 boolean DEFAULT false,
    dia_lot_regl_copro_publ_hypo_moins_10 boolean DEFAULT false,
    dia_indivi_quote_part boolean DEFAULT false,
    dia_design_societe boolean DEFAULT false,
    dia_design_droit boolean DEFAULT false,
    dia_droit_soc_nat boolean DEFAULT false,
    dia_droit_soc_nb boolean DEFAULT false,
    dia_droit_soc_num_part boolean DEFAULT false,
    dia_droit_reel_perso_grevant_bien_oui boolean DEFAULT false,
    dia_droit_reel_perso_grevant_bien_non boolean DEFAULT false,
    dia_droit_reel_perso_nat boolean DEFAULT false,
    dia_droit_reel_perso_viag boolean DEFAULT false,
    dia_mod_cess_adr boolean DEFAULT false,
    dia_mod_cess_sign_act_auth boolean DEFAULT false,
    dia_mod_cess_terme boolean DEFAULT false,
    dia_mod_cess_terme_prec boolean DEFAULT false,
    dia_mod_cess_bene_acquereur boolean DEFAULT false,
    dia_mod_cess_bene_vendeur boolean DEFAULT false,
    dia_mod_cess_paie_nat boolean DEFAULT false,
    dia_mod_cess_design_contr_alien boolean DEFAULT false,
    dia_mod_cess_eval_contr boolean DEFAULT false,
    dia_mod_cess_rente_viag boolean DEFAULT false,
    dia_mod_cess_mnt_an boolean DEFAULT false,
    dia_mod_cess_mnt_compt boolean DEFAULT false,
    dia_mod_cess_bene_rente boolean DEFAULT false,
    dia_mod_cess_droit_usa_hab boolean DEFAULT false,
    dia_mod_cess_droit_usa_hab_prec boolean DEFAULT false,
    dia_mod_cess_eval_usa_usufruit boolean DEFAULT false,
    dia_mod_cess_vente_nue_prop boolean DEFAULT false,
    dia_mod_cess_vente_nue_prop_prec boolean DEFAULT false,
    dia_mod_cess_echange boolean DEFAULT false,
    dia_mod_cess_design_bien_recus_ech boolean DEFAULT false,
    dia_mod_cess_mnt_soulte boolean DEFAULT false,
    dia_mod_cess_prop_contre_echan boolean DEFAULT false,
    dia_mod_cess_apport_societe boolean DEFAULT false,
    dia_mod_cess_bene boolean DEFAULT false,
    dia_mod_cess_esti_bien boolean DEFAULT false,
    dia_mod_cess_cess_terr_loc_co boolean DEFAULT false,
    dia_mod_cess_esti_terr boolean DEFAULT false,
    dia_mod_cess_esti_loc boolean DEFAULT false,
    dia_mod_cess_esti_imm_loca boolean DEFAULT false,
    dia_mod_cess_adju_vol boolean DEFAULT false,
    dia_mod_cess_adju_obl boolean DEFAULT false,
    dia_mod_cess_adju_fin_indivi boolean DEFAULT false,
    dia_mod_cess_adju_date_lieu boolean DEFAULT false,
    dia_mod_cess_mnt_mise_prix boolean DEFAULT false,
    dia_prop_titu_prix_indique boolean DEFAULT false,
    dia_prop_recherche_acqu_prix_indique boolean DEFAULT false,
    dia_acquereur_prof boolean DEFAULT false,
    dia_indic_compl_ope boolean DEFAULT false,
    dia_vente_adju boolean DEFAULT false,
    am_terr_res_demon boolean DEFAULT false,
    am_air_terr_res_mob boolean DEFAULT false,
    ctx_objet_recours boolean DEFAULT false,
    ctx_moyen_souleve boolean DEFAULT false,
    ctx_moyen_retenu_juge boolean DEFAULT false,
    ctx_reference_sagace boolean DEFAULT false,
    ctx_nature_travaux_infra_om_html boolean DEFAULT false,
    ctx_synthese_nti boolean DEFAULT false,
    ctx_article_non_resp_om_html boolean DEFAULT false,
    ctx_synthese_anr boolean DEFAULT false,
    ctx_reference_parquet boolean DEFAULT false,
    ctx_element_taxation boolean DEFAULT false,
    ctx_infraction boolean DEFAULT false,
    ctx_regularisable boolean DEFAULT false,
    ctx_reference_courrier boolean DEFAULT false,
    ctx_date_audience boolean DEFAULT false,
    ctx_date_ajournement boolean DEFAULT false,
    exo_facul_1 boolean DEFAULT false,
    exo_facul_2 boolean DEFAULT false,
    exo_facul_3 boolean DEFAULT false,
    exo_facul_4 boolean DEFAULT false,
    exo_facul_5 boolean DEFAULT false,
    exo_facul_6 boolean DEFAULT false,
    exo_facul_7 boolean DEFAULT false,
    exo_facul_8 boolean DEFAULT false,
    exo_facul_9 boolean DEFAULT false,
    exo_ta_1 boolean DEFAULT false,
    exo_ta_2 boolean DEFAULT false,
    exo_ta_3 boolean DEFAULT false,
    exo_ta_4 boolean DEFAULT false,
    exo_ta_5 boolean DEFAULT false,
    exo_ta_6 boolean DEFAULT false,
    exo_ta_7 boolean DEFAULT false,
    exo_ta_8 boolean DEFAULT false,
    exo_ta_9 boolean DEFAULT false,
    exo_rap_1 boolean DEFAULT false,
    exo_rap_2 boolean DEFAULT false,
    exo_rap_3 boolean DEFAULT false,
    exo_rap_4 boolean DEFAULT false,
    exo_rap_5 boolean DEFAULT false,
    exo_rap_6 boolean DEFAULT false,
    exo_rap_7 boolean DEFAULT false,
    exo_rap_8 boolean DEFAULT false,
    mtn_exo_ta_part_commu boolean DEFAULT false,
    mtn_exo_ta_part_depart boolean DEFAULT false,
    mtn_exo_ta_part_reg boolean DEFAULT false,
    mtn_exo_rap boolean DEFAULT false,
    dpc_type boolean DEFAULT false,
    dpc_desc_actv_ex boolean DEFAULT false,
    dpc_desc_ca boolean DEFAULT false,
    dpc_desc_aut_prec boolean DEFAULT false,
    dpc_desig_comm_arti boolean DEFAULT false,
    dpc_desig_loc_hab boolean DEFAULT false,
    dpc_desig_loc_ann boolean DEFAULT false,
    dpc_desig_loc_ann_prec boolean DEFAULT false,
    dpc_bail_comm_date boolean DEFAULT false,
    dpc_bail_comm_loyer boolean DEFAULT false,
    dpc_actv_acqu boolean DEFAULT false,
    dpc_nb_sala_di boolean DEFAULT false,
    dpc_nb_sala_dd boolean DEFAULT false,
    dpc_nb_sala_tc boolean DEFAULT false,
    dpc_nb_sala_tp boolean DEFAULT false,
    dpc_moda_cess_vente_am boolean DEFAULT false,
    dpc_moda_cess_adj boolean DEFAULT false,
    dpc_moda_cess_prix boolean DEFAULT false,
    dpc_moda_cess_adj_date boolean DEFAULT false,
    dpc_moda_cess_adj_prec boolean DEFAULT false,
    dpc_moda_cess_paie_comp boolean DEFAULT false,
    dpc_moda_cess_paie_terme boolean DEFAULT false,
    dpc_moda_cess_paie_terme_prec boolean DEFAULT false,
    dpc_moda_cess_paie_nat boolean DEFAULT false,
    dpc_moda_cess_paie_nat_desig_alien boolean DEFAULT false,
    dpc_moda_cess_paie_nat_desig_alien_prec boolean DEFAULT false,
    dpc_moda_cess_paie_nat_eval boolean DEFAULT false,
    dpc_moda_cess_paie_nat_eval_prec boolean DEFAULT false,
    dpc_moda_cess_paie_aut boolean DEFAULT false,
    dpc_moda_cess_paie_aut_prec boolean DEFAULT false,
    dpc_ss_signe_demande_acqu boolean DEFAULT false,
    dpc_ss_signe_recher_trouv_acqu boolean DEFAULT false,
    dpc_notif_adr_prop boolean DEFAULT false,
    dpc_notif_adr_manda boolean DEFAULT false,
    dpc_obs boolean DEFAULT false,
    co_peri_site_patri_remar boolean DEFAULT false,
    co_abo_monu_hist boolean DEFAULT false,
    co_inst_ouvr_trav_act_code_envir boolean DEFAULT false,
    co_trav_auto_env boolean DEFAULT false,
    co_derog_esp_prot boolean DEFAULT false,
    ctx_reference_dsj boolean DEFAULT false NOT NULL,
    co_piscine boolean DEFAULT false,
    co_fin_lls boolean DEFAULT false,
    co_fin_aa boolean DEFAULT false,
    co_fin_ptz boolean DEFAULT false,
    co_fin_autr boolean DEFAULT false,
    dia_ss_date boolean DEFAULT false,
    dia_ss_lieu boolean DEFAULT false,
    enga_decla_lieu boolean DEFAULT false,
    enga_decla_date boolean DEFAULT false,
    co_archi_attest_honneur boolean DEFAULT false,
    co_bat_niv_dessous_nb boolean DEFAULT false,
    co_install_classe boolean DEFAULT false,
    co_derog_innov boolean DEFAULT false,
    co_avis_abf boolean DEFAULT false,
    tax_surf_tot_demo boolean DEFAULT false,
    tax_surf_tax_demo boolean DEFAULT false,
    tax_terrassement_arch boolean DEFAULT false,
    tax_adresse_future_numero boolean DEFAULT false,
    tax_adresse_future_voie boolean DEFAULT false,
    tax_adresse_future_lieudit boolean DEFAULT false,
    tax_adresse_future_localite boolean DEFAULT false,
    tax_adresse_future_cp boolean DEFAULT false,
    tax_adresse_future_bp boolean DEFAULT false,
    tax_adresse_future_cedex boolean DEFAULT false,
    tax_adresse_future_pays boolean DEFAULT false,
    tax_adresse_future_division boolean DEFAULT false,
    co_bat_projete boolean DEFAULT false,
    co_bat_existant boolean DEFAULT false,
    co_bat_nature boolean DEFAULT false,
    terr_juri_titul_date boolean DEFAULT false,
    co_autre_desc boolean DEFAULT false,
    co_trx_autre boolean DEFAULT false,
    co_autre boolean DEFAULT false,
    erp_modif_facades boolean DEFAULT false,
    erp_trvx_adap boolean DEFAULT false,
    erp_trvx_adap_numero boolean DEFAULT false,
    erp_trvx_adap_valid boolean DEFAULT false,
    erp_prod_dangereux boolean DEFAULT false,
    co_trav_supp_dessus boolean DEFAULT false,
    co_trav_supp_dessous boolean DEFAULT false,
    tax_su_habit_abr_jard_pig_colom boolean DEFAULT false,
    enga_decla_donnees_nomi_comm boolean DEFAULT false
);


--
-- Name: TABLE cerfa; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON TABLE cerfa IS 'Configuration de l''affichage des formulaires CERFA';


--
-- Name: COLUMN cerfa.cerfa; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.cerfa IS 'Identifiant unique';


--
-- Name: COLUMN cerfa.libelle; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.libelle IS 'Libellé du formulaire CERFA';


--
-- Name: COLUMN cerfa.code; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.code IS 'Code du formulaire CERFA';


--
-- Name: COLUMN cerfa.om_validite_debut; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.om_validite_debut IS 'Début de validité du formulaire CERFA';


--
-- Name: COLUMN cerfa.om_validite_fin; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.om_validite_fin IS 'Fin de validité du formulaire CERFA';


--
-- Name: COLUMN cerfa.am_lotiss; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.am_lotiss IS 'Va afficher le champ am_lotiss';


--
-- Name: COLUMN cerfa.am_autre_div; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.am_autre_div IS 'Va afficher le champ am_autre_div';


--
-- Name: COLUMN cerfa.am_camping; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.am_camping IS 'Va afficher le champ am_camping';


--
-- Name: COLUMN cerfa.am_caravane; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.am_caravane IS 'Va afficher le champ am_caravane';


--
-- Name: COLUMN cerfa.am_carav_duree; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.am_carav_duree IS 'Va afficher le champ am_carav_duree';


--
-- Name: COLUMN cerfa.am_statio; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.am_statio IS 'Va afficher le champ am_statio';


--
-- Name: COLUMN cerfa.am_statio_cont; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.am_statio_cont IS 'Va afficher le champ am_statio_cont';


--
-- Name: COLUMN cerfa.am_affou_exhau; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.am_affou_exhau IS 'Va afficher le champ am_affou_exhau';


--
-- Name: COLUMN cerfa.am_affou_exhau_sup; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.am_affou_exhau_sup IS 'Va afficher le champ am_affou_exhau_sup';


--
-- Name: COLUMN cerfa.am_affou_prof; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.am_affou_prof IS 'Va afficher le champ am_affou_prof';


--
-- Name: COLUMN cerfa.am_exhau_haut; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.am_exhau_haut IS 'Va afficher le champ am_exhau_haut';


--
-- Name: COLUMN cerfa.am_coupe_abat; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.am_coupe_abat IS 'Va afficher le champ am_coupe_abat';


--
-- Name: COLUMN cerfa.am_prot_plu; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.am_prot_plu IS 'Va afficher le champ am_prot_plu';


--
-- Name: COLUMN cerfa.am_prot_muni; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.am_prot_muni IS 'Va afficher le champ am_prot_muni';


--
-- Name: COLUMN cerfa.am_mobil_voyage; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.am_mobil_voyage IS 'Va afficher le champ am_mobil_voyage';


--
-- Name: COLUMN cerfa.am_aire_voyage; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.am_aire_voyage IS 'Va afficher le champ am_aire_voyage';


--
-- Name: COLUMN cerfa.am_rememb_afu; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.am_rememb_afu IS 'Travaux ayant pour effet de modifier l''aménagement des espaces non bâtis autour d''un bâtiment existant situé dans le périmètre d''un site patrimonial remarquable ou abords d''un monument historique';


--
-- Name: COLUMN cerfa.am_parc_resid_loi; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.am_parc_resid_loi IS 'Va afficher le champ am_parc_resid_loi';


--
-- Name: COLUMN cerfa.am_sport_moto; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.am_sport_moto IS 'Va afficher le champ am_sport_moto';


--
-- Name: COLUMN cerfa.am_sport_attrac; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.am_sport_attrac IS 'Va afficher le champ am_sport_attrac';


--
-- Name: COLUMN cerfa.am_sport_golf; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.am_sport_golf IS 'Va afficher le champ am_sport_golf';


--
-- Name: COLUMN cerfa.am_mob_art; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.am_mob_art IS 'Va afficher le champ am_mob_art';


--
-- Name: COLUMN cerfa.am_modif_voie_esp; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.am_modif_voie_esp IS 'Va afficher le champ am_modif_voie_esp';


--
-- Name: COLUMN cerfa.am_plant_voie_esp; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.am_plant_voie_esp IS 'Va afficher le champ am_plant_voie_esp';


--
-- Name: COLUMN cerfa.am_chem_ouv_esp; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.am_chem_ouv_esp IS 'Va afficher le champ am_chem_ouv_esp';


--
-- Name: COLUMN cerfa.am_agri_peche; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.am_agri_peche IS 'Va afficher le champ am_agri_peche';


--
-- Name: COLUMN cerfa.am_crea_voie; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.am_crea_voie IS 'Va afficher le champ am_crea_voie';


--
-- Name: COLUMN cerfa.am_modif_voie_exist; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.am_modif_voie_exist IS 'Va afficher le champ am_modif_voie_exist';


--
-- Name: COLUMN cerfa.am_crea_esp_sauv; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.am_crea_esp_sauv IS 'Va afficher le champ am_crea_esp_sauv';


--
-- Name: COLUMN cerfa.am_crea_esp_class; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.am_crea_esp_class IS 'Va afficher le champ am_crea_esp_class';


--
-- Name: COLUMN cerfa.am_projet_desc; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.am_projet_desc IS 'Va afficher le champ am_projet_desc';


--
-- Name: COLUMN cerfa.am_terr_surf; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.am_terr_surf IS 'Va afficher le champ am_terr_surf';


--
-- Name: COLUMN cerfa.am_tranche_desc; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.am_tranche_desc IS 'Va afficher le champ am_tranche_desc';


--
-- Name: COLUMN cerfa.am_lot_max_nb; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.am_lot_max_nb IS 'Va afficher le champ am_lot_max_nb';


--
-- Name: COLUMN cerfa.am_lot_max_shon; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.am_lot_max_shon IS 'Va afficher le champ am_lot_max_shon';


--
-- Name: COLUMN cerfa.am_lot_cstr_cos; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.am_lot_cstr_cos IS 'Va afficher le champ am_lot_cstr_cos';


--
-- Name: COLUMN cerfa.am_lot_cstr_plan; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.am_lot_cstr_plan IS 'Va afficher le champ am_lot_cstr_plan';


--
-- Name: COLUMN cerfa.am_lot_cstr_vente; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.am_lot_cstr_vente IS 'Va afficher le champ am_lot_cstr_vente';


--
-- Name: COLUMN cerfa.am_lot_fin_diff; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.am_lot_fin_diff IS 'Va afficher le champ am_lot_fin_diff';


--
-- Name: COLUMN cerfa.am_lot_consign; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.am_lot_consign IS 'Va afficher le champ am_lot_consign';


--
-- Name: COLUMN cerfa.am_lot_gar_achev; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.am_lot_gar_achev IS 'Va afficher le champ am_lot_gar_achev';


--
-- Name: COLUMN cerfa.am_lot_vente_ant; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.am_lot_vente_ant IS 'Va afficher le champ am_lot_vente_ant';


--
-- Name: COLUMN cerfa.am_empl_nb; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.am_empl_nb IS 'Va afficher le champ am_empl_nb';


--
-- Name: COLUMN cerfa.am_tente_nb; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.am_tente_nb IS 'Va afficher le champ am_tente_nb';


--
-- Name: COLUMN cerfa.am_carav_nb; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.am_carav_nb IS 'Va afficher le champ am_carav_nb';


--
-- Name: COLUMN cerfa.am_mobil_nb; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.am_mobil_nb IS 'Va afficher le champ am_mobil_nb';


--
-- Name: COLUMN cerfa.am_pers_nb; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.am_pers_nb IS 'Va afficher le champ am_pers_nb';


--
-- Name: COLUMN cerfa.am_empl_hll_nb; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.am_empl_hll_nb IS 'Va afficher le champ am_empl_hll_nb';


--
-- Name: COLUMN cerfa.am_hll_shon; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.am_hll_shon IS 'Va afficher le champ am_hll_shon';


--
-- Name: COLUMN cerfa.am_periode_exploit; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.am_periode_exploit IS 'Va afficher le champ am_periode_exploit';


--
-- Name: COLUMN cerfa.am_exist_agrand; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.am_exist_agrand IS 'Va afficher le champ am_exist_agrand';


--
-- Name: COLUMN cerfa.am_exist_date; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.am_exist_date IS 'Va afficher le champ am_exist_date';


--
-- Name: COLUMN cerfa.am_exist_num; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.am_exist_num IS 'Va afficher le champ am_exist_num';


--
-- Name: COLUMN cerfa.am_exist_nb_avant; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.am_exist_nb_avant IS 'Va afficher le champ am_exist_nb_avant';


--
-- Name: COLUMN cerfa.am_exist_nb_apres; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.am_exist_nb_apres IS 'Va afficher le champ am_exist_nb_apres';


--
-- Name: COLUMN cerfa.am_coupe_bois; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.am_coupe_bois IS 'Va afficher le champ am_coupe_bois';


--
-- Name: COLUMN cerfa.am_coupe_parc; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.am_coupe_parc IS 'Va afficher le champ am_coupe_parc';


--
-- Name: COLUMN cerfa.am_coupe_align; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.am_coupe_align IS 'Va afficher le champ am_coupe_align';


--
-- Name: COLUMN cerfa.am_coupe_ess; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.am_coupe_ess IS 'Va afficher le champ am_coupe_ess';


--
-- Name: COLUMN cerfa.am_coupe_age; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.am_coupe_age IS 'Va afficher le champ am_coupe_age';


--
-- Name: COLUMN cerfa.am_coupe_dens; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.am_coupe_dens IS 'Va afficher le champ am_coupe_dens';


--
-- Name: COLUMN cerfa.am_coupe_qual; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.am_coupe_qual IS 'Va afficher le champ am_coupe_qual';


--
-- Name: COLUMN cerfa.am_coupe_trait; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.am_coupe_trait IS 'Va afficher le champ am_coupe_trait';


--
-- Name: COLUMN cerfa.am_coupe_autr; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.am_coupe_autr IS 'Va afficher le champ am_coupe_autr';


--
-- Name: COLUMN cerfa.co_archi_recours; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_archi_recours IS 'Va afficher le champ co_archi_recours';


--
-- Name: COLUMN cerfa.co_cstr_nouv; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_cstr_nouv IS 'Va afficher le champ co_cstr_nouv';


--
-- Name: COLUMN cerfa.co_cstr_exist; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_cstr_exist IS 'Va afficher le champ co_cstr_exist';


--
-- Name: COLUMN cerfa.co_cloture; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_cloture IS 'Va afficher le champ co_cloture';


--
-- Name: COLUMN cerfa.co_elec_tension; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_elec_tension IS 'Va afficher le champ co_elec_tension';


--
-- Name: COLUMN cerfa.co_div_terr; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_div_terr IS 'Va afficher le champ co_div_terr';


--
-- Name: COLUMN cerfa.co_projet_desc; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_projet_desc IS 'Va afficher le champ co_projet_desc';


--
-- Name: COLUMN cerfa.co_anx_pisc; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_anx_pisc IS 'Va afficher le champ co_anx_pisc';


--
-- Name: COLUMN cerfa.co_anx_gara; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_anx_gara IS 'Va afficher le champ co_anx_gara';


--
-- Name: COLUMN cerfa.co_anx_veran; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_anx_veran IS 'Va afficher le champ co_anx_veran';


--
-- Name: COLUMN cerfa.co_anx_abri; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_anx_abri IS 'Va afficher le champ co_anx_abri';


--
-- Name: COLUMN cerfa.co_anx_autr; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_anx_autr IS 'Va afficher le champ co_anx_autr';


--
-- Name: COLUMN cerfa.co_anx_autr_desc; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_anx_autr_desc IS 'Va afficher le champ co_anx_autr_desc';


--
-- Name: COLUMN cerfa.co_tot_log_nb; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_tot_log_nb IS 'Va afficher le champ co_tot_log_nb';


--
-- Name: COLUMN cerfa.co_tot_ind_nb; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_tot_ind_nb IS 'Va afficher le champ co_tot_ind_nb';


--
-- Name: COLUMN cerfa.co_tot_coll_nb; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_tot_coll_nb IS 'Va afficher le champ co_tot_coll_nb';


--
-- Name: COLUMN cerfa.co_mais_piece_nb; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_mais_piece_nb IS 'Va afficher le champ co_mais_piece_nb';


--
-- Name: COLUMN cerfa.co_mais_niv_nb; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_mais_niv_nb IS 'Va afficher le champ co_mais_niv_nb';


--
-- Name: COLUMN cerfa.co_fin_lls_nb; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_fin_lls_nb IS 'Va afficher le champ co_fin_lls_nb';


--
-- Name: COLUMN cerfa.co_fin_aa_nb; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_fin_aa_nb IS 'Va afficher le champ co_fin_aa_nb';


--
-- Name: COLUMN cerfa.co_fin_ptz_nb; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_fin_ptz_nb IS 'Va afficher le champ co_fin_ptz_nb';


--
-- Name: COLUMN cerfa.co_fin_autr_nb; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_fin_autr_nb IS 'Va afficher le champ co_fin_autr_nb';


--
-- Name: COLUMN cerfa.co_fin_autr_desc; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_fin_autr_desc IS 'Va afficher le champ co_fin_autr_desc';


--
-- Name: COLUMN cerfa.co_mais_contrat_ind; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_mais_contrat_ind IS 'Va afficher le champ co_mais_contrat_ind';


--
-- Name: COLUMN cerfa.co_uti_pers; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_uti_pers IS 'Va afficher le champ co_uti_pers';


--
-- Name: COLUMN cerfa.co_uti_vente; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_uti_vente IS 'Va afficher le champ co_uti_vente';


--
-- Name: COLUMN cerfa.co_uti_loc; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_uti_loc IS 'Va afficher le champ co_uti_loc';


--
-- Name: COLUMN cerfa.co_uti_princ; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_uti_princ IS 'Va afficher le champ co_uti_princ';


--
-- Name: COLUMN cerfa.co_uti_secon; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_uti_secon IS 'Va afficher le champ co_uti_secon';


--
-- Name: COLUMN cerfa.co_resid_agees; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_resid_agees IS 'Va afficher le champ co_resid_agees';


--
-- Name: COLUMN cerfa.co_resid_etud; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_resid_etud IS 'Va afficher le champ co_resid_etud';


--
-- Name: COLUMN cerfa.co_resid_tourism; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_resid_tourism IS 'Va afficher le champ co_resid_tourism';


--
-- Name: COLUMN cerfa.co_resid_hot_soc; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_resid_hot_soc IS 'Va afficher le champ co_resid_hot_soc';


--
-- Name: COLUMN cerfa.co_resid_soc; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_resid_soc IS 'Va afficher le champ co_resid_soc';


--
-- Name: COLUMN cerfa.co_resid_hand; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_resid_hand IS 'Va afficher le champ co_resid_hand';


--
-- Name: COLUMN cerfa.co_resid_autr; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_resid_autr IS 'Va afficher le champ co_resid_autr';


--
-- Name: COLUMN cerfa.co_resid_autr_desc; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_resid_autr_desc IS 'Va afficher le champ co_resid_autr_desc';


--
-- Name: COLUMN cerfa.co_foyer_chamb_nb; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_foyer_chamb_nb IS 'Va afficher le champ co_foyer_chamb_nb';


--
-- Name: COLUMN cerfa.co_log_1p_nb; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_log_1p_nb IS 'Va afficher le champ co_log_1p_nb';


--
-- Name: COLUMN cerfa.co_log_2p_nb; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_log_2p_nb IS 'Va afficher le champ co_log_2p_nb';


--
-- Name: COLUMN cerfa.co_log_3p_nb; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_log_3p_nb IS 'Va afficher le champ co_log_3p_nb';


--
-- Name: COLUMN cerfa.co_log_4p_nb; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_log_4p_nb IS 'Va afficher le champ co_log_4p_nb';


--
-- Name: COLUMN cerfa.co_log_5p_nb; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_log_5p_nb IS 'Va afficher le champ co_log_5p_nb';


--
-- Name: COLUMN cerfa.co_log_6p_nb; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_log_6p_nb IS 'Va afficher le champ co_log_6p_nb';


--
-- Name: COLUMN cerfa.co_bat_niv_nb; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_bat_niv_nb IS 'Le nombre de niveaux du bâtiment le plus élevé : au-dessus du sol';


--
-- Name: COLUMN cerfa.co_trx_exten; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_trx_exten IS 'Va afficher le champ co_trx_exten';


--
-- Name: COLUMN cerfa.co_trx_surelev; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_trx_surelev IS 'Va afficher le champ co_trx_surelev';


--
-- Name: COLUMN cerfa.co_trx_nivsup; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_trx_nivsup IS 'Va afficher le champ co_trx_nivsup';


--
-- Name: COLUMN cerfa.co_demont_periode; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_demont_periode IS 'Va afficher le champ co_demont_periode';


--
-- Name: COLUMN cerfa.co_sp_transport; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_sp_transport IS 'Va afficher le champ co_sp_transport';


--
-- Name: COLUMN cerfa.co_sp_enseign; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_sp_enseign IS 'Va afficher le champ co_sp_enseign';


--
-- Name: COLUMN cerfa.co_sp_act_soc; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_sp_act_soc IS 'Va afficher le champ co_sp_act_soc';


--
-- Name: COLUMN cerfa.co_sp_ouvr_spe; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_sp_ouvr_spe IS 'Va afficher le champ co_sp_ouvr_spe';


--
-- Name: COLUMN cerfa.co_sp_sante; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_sp_sante IS 'Va afficher le champ co_sp_sante';


--
-- Name: COLUMN cerfa.co_sp_culture; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_sp_culture IS 'Va afficher le champ co_sp_culture';


--
-- Name: COLUMN cerfa.co_statio_avt_nb; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_statio_avt_nb IS 'Va afficher le champ co_statio_avt_nb';


--
-- Name: COLUMN cerfa.co_statio_apr_nb; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_statio_apr_nb IS 'Va afficher le champ co_statio_apr_nb';


--
-- Name: COLUMN cerfa.co_statio_adr; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_statio_adr IS 'Va afficher le champ co_statio_adr';


--
-- Name: COLUMN cerfa.co_statio_place_nb; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_statio_place_nb IS 'Va afficher le champ co_statio_place_nb';


--
-- Name: COLUMN cerfa.co_statio_tot_surf; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_statio_tot_surf IS 'Va afficher le champ co_statio_tot_surf';


--
-- Name: COLUMN cerfa.co_statio_tot_shob; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_statio_tot_shob IS 'Va afficher le champ co_statio_tot_shob';


--
-- Name: COLUMN cerfa.co_statio_comm_cin_surf; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_statio_comm_cin_surf IS 'Va afficher le champ co_statio_comm_cin_surf';


--
-- Name: COLUMN cerfa.tab_surface; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.tab_surface IS 'Va afficher le champ tab_surface';


--
-- Name: COLUMN cerfa.dm_constr_dates; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dm_constr_dates IS 'Va afficher le champ dm_constr_dates';


--
-- Name: COLUMN cerfa.dm_total; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dm_total IS 'Va afficher le champ dm_total';


--
-- Name: COLUMN cerfa.dm_partiel; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dm_partiel IS 'Va afficher le champ dm_partiel';


--
-- Name: COLUMN cerfa.dm_projet_desc; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dm_projet_desc IS 'Va afficher le champ dm_projet_desc';


--
-- Name: COLUMN cerfa.dm_tot_log_nb; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dm_tot_log_nb IS 'Va afficher le champ dm_tot_log_nb';


--
-- Name: COLUMN cerfa.tax_surf_tot; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.tax_surf_tot IS 'Va afficher le champ tax_surf_tot';


--
-- Name: COLUMN cerfa.tax_surf; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.tax_surf IS 'Va afficher le champ tax_surf';


--
-- Name: COLUMN cerfa.tax_surf_suppr_mod; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.tax_surf_suppr_mod IS 'Va afficher le champ tax_surf_suppr_mod';


--
-- Name: COLUMN cerfa.tab_tax_su_princ; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.tab_tax_su_princ IS 'Tableau : Locaux à usage d’habitation principale et leurs annexes';


--
-- Name: COLUMN cerfa.tab_tax_su_heber; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.tab_tax_su_heber IS 'Va afficher le champ tab_tax_su_heber';


--
-- Name: COLUMN cerfa.tab_tax_su_secon; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.tab_tax_su_secon IS 'Va afficher le champ tab_tax_su_secon';


--
-- Name: COLUMN cerfa.tab_tax_su_tot; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.tab_tax_su_tot IS 'Va afficher le champ tab_tax_su_tot';


--
-- Name: COLUMN cerfa.tax_ext_pret; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.tax_ext_pret IS 'Va afficher le champ tax_ext_pret';


--
-- Name: COLUMN cerfa.tax_ext_desc; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.tax_ext_desc IS 'Va afficher le champ tax_ext_desc';


--
-- Name: COLUMN cerfa.tax_surf_tax_exist_cons; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.tax_surf_tax_exist_cons IS 'Va afficher le champ tax_surf_tax_exist_cons';


--
-- Name: COLUMN cerfa.tax_log_exist_nb; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.tax_log_exist_nb IS 'Va afficher le champ tax_log_exist_nb';


--
-- Name: COLUMN cerfa.tax_trx_presc_ppr; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.tax_trx_presc_ppr IS 'Va afficher le champ tax_trx_presc_ppr';


--
-- Name: COLUMN cerfa.tax_monu_hist; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.tax_monu_hist IS 'Va afficher le champ tax_monu_hist';


--
-- Name: COLUMN cerfa.tax_comm_nb; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.tax_comm_nb IS 'Nombre de commerces de détail dont la surface de vente est inférieure à 400 m²';


--
-- Name: COLUMN cerfa.tab_tax_su_non_habit_surf; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.tab_tax_su_non_habit_surf IS 'Va afficher le champ tab_tax_su_non_habit_surf';


--
-- Name: COLUMN cerfa.tab_tax_am; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.tab_tax_am IS 'Va afficher le champ tab_tax_am';


--
-- Name: COLUMN cerfa.vsd_surf_planch_smd; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.vsd_surf_planch_smd IS 'Va afficher le champ vsd_surf_planch_smd';


--
-- Name: COLUMN cerfa.vsd_unit_fonc_sup; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.vsd_unit_fonc_sup IS 'Va afficher le champ vsd_unit_fonc_sup';


--
-- Name: COLUMN cerfa.vsd_unit_fonc_constr_sup; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.vsd_unit_fonc_constr_sup IS 'Va afficher le champ vsd_unit_fonc_constr_sup';


--
-- Name: COLUMN cerfa.vsd_val_terr; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.vsd_val_terr IS 'Va afficher le champ vsd_val_terr';


--
-- Name: COLUMN cerfa.vsd_const_sxist_non_dem_surf; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.vsd_const_sxist_non_dem_surf IS 'Va afficher le champ vsd_const_sxist_non_dem_surf';


--
-- Name: COLUMN cerfa.vsd_rescr_fisc; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.vsd_rescr_fisc IS 'Va afficher le champ vsd_rescr_fisc';


--
-- Name: COLUMN cerfa.pld_val_terr; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.pld_val_terr IS 'Va afficher le champ pld_val_terr';


--
-- Name: COLUMN cerfa.pld_const_exist_dem; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.pld_const_exist_dem IS 'Va afficher le champ pld_const_exist_dem';


--
-- Name: COLUMN cerfa.pld_const_exist_dem_surf; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.pld_const_exist_dem_surf IS 'Va afficher le champ pld_const_exist_dem_surf';


--
-- Name: COLUMN cerfa.code_cnil; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.code_cnil IS 'Va afficher le champ code_cnil';


--
-- Name: COLUMN cerfa.terr_juri_titul; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.terr_juri_titul IS 'Va afficher le champ terr_juri_titul';


--
-- Name: COLUMN cerfa.terr_juri_lot; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.terr_juri_lot IS 'Va afficher le champ terr_juri_lot';


--
-- Name: COLUMN cerfa.terr_juri_zac; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.terr_juri_zac IS 'Va afficher le champ terr_juri_zac';


--
-- Name: COLUMN cerfa.terr_juri_afu; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.terr_juri_afu IS 'Va afficher le champ terr_juri_afu';


--
-- Name: COLUMN cerfa.terr_juri_pup; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.terr_juri_pup IS 'Va afficher le champ terr_juri_pup';


--
-- Name: COLUMN cerfa.terr_juri_oin; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.terr_juri_oin IS 'Va afficher le champ terr_juri_oin';


--
-- Name: COLUMN cerfa.terr_juri_desc; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.terr_juri_desc IS 'Va afficher le champ terr_juri_desc';


--
-- Name: COLUMN cerfa.terr_div_surf_etab; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.terr_div_surf_etab IS 'Va afficher le champ terr_div_surf_etab';


--
-- Name: COLUMN cerfa.terr_div_surf_av_div; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.terr_div_surf_av_div IS 'Va afficher le champ terr_div_surf_av_div';


--
-- Name: COLUMN cerfa.doc_date; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.doc_date IS 'Va afficher le champ doc_date';


--
-- Name: COLUMN cerfa.doc_tot_trav; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.doc_tot_trav IS 'Va afficher le champ doc_tot_trav';


--
-- Name: COLUMN cerfa.doc_tranche_trav; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.doc_tranche_trav IS 'Va afficher le champ doc_tranche_trav';


--
-- Name: COLUMN cerfa.doc_tranche_trav_desc; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.doc_tranche_trav_desc IS 'Va afficher le champ doc_tranche_trav_desc';


--
-- Name: COLUMN cerfa.doc_surf; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.doc_surf IS 'Va afficher le champ doc_surf';


--
-- Name: COLUMN cerfa.doc_nb_log; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.doc_nb_log IS 'Va afficher le champ doc_nb_log';


--
-- Name: COLUMN cerfa.doc_nb_log_indiv; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.doc_nb_log_indiv IS 'Va afficher le champ doc_nb_log_indiv';


--
-- Name: COLUMN cerfa.doc_nb_log_coll; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.doc_nb_log_coll IS 'Va afficher le champ doc_nb_log_coll';


--
-- Name: COLUMN cerfa.doc_nb_log_lls; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.doc_nb_log_lls IS 'Va afficher le champ doc_nb_log_lls';


--
-- Name: COLUMN cerfa.doc_nb_log_aa; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.doc_nb_log_aa IS 'Accession Aidée (hors prêt à taux zéro)';


--
-- Name: COLUMN cerfa.doc_nb_log_ptz; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.doc_nb_log_ptz IS 'Va afficher le champ doc_nb_log_ptz';


--
-- Name: COLUMN cerfa.doc_nb_log_autre; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.doc_nb_log_autre IS 'Va afficher le champ doc_nb_log_autre';


--
-- Name: COLUMN cerfa.daact_date; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.daact_date IS 'Va afficher le champ daact_date';


--
-- Name: COLUMN cerfa.daact_date_chgmt_dest; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.daact_date_chgmt_dest IS 'Va afficher le champ daact_date_chgmt_dest';


--
-- Name: COLUMN cerfa.daact_tot_trav; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.daact_tot_trav IS 'Va afficher le champ daact_tot_trav';


--
-- Name: COLUMN cerfa.daact_tranche_trav; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.daact_tranche_trav IS 'Va afficher le champ daact_tranche_trav';


--
-- Name: COLUMN cerfa.daact_tranche_trav_desc; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.daact_tranche_trav_desc IS 'Va afficher le champ daact_tranche_trav_desc';


--
-- Name: COLUMN cerfa.daact_surf; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.daact_surf IS 'Va afficher le champ daact_surf';


--
-- Name: COLUMN cerfa.daact_nb_log; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.daact_nb_log IS 'Va afficher le champ daact_nb_log';


--
-- Name: COLUMN cerfa.daact_nb_log_indiv; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.daact_nb_log_indiv IS 'Va afficher le champ daact_nb_log_indiv';


--
-- Name: COLUMN cerfa.daact_nb_log_coll; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.daact_nb_log_coll IS 'Va afficher le champ daact_nb_log_coll';


--
-- Name: COLUMN cerfa.daact_nb_log_lls; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.daact_nb_log_lls IS 'Va afficher le champ daact_nb_log_lls';


--
-- Name: COLUMN cerfa.daact_nb_log_aa; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.daact_nb_log_aa IS 'Va afficher le champ daact_nb_log_aa';


--
-- Name: COLUMN cerfa.daact_nb_log_ptz; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.daact_nb_log_ptz IS 'Va afficher le champ daact_nb_log_ptz';


--
-- Name: COLUMN cerfa.daact_nb_log_autre; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.daact_nb_log_autre IS 'Va afficher le champ daact_nb_log_autre';


--
-- Name: COLUMN cerfa.am_div_mun; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.am_div_mun IS 'Va afficher le champ am_div_mun';


--
-- Name: COLUMN cerfa.co_perf_energ; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_perf_energ IS 'Va afficher le champ co_perf_energ';


--
-- Name: COLUMN cerfa.architecte; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.architecte IS 'Va afficher le champ architecte';


--
-- Name: COLUMN cerfa.co_statio_avt_shob; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_statio_avt_shob IS 'Va afficher le champ co_statio_avt_shob';


--
-- Name: COLUMN cerfa.co_statio_apr_shob; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_statio_apr_shob IS 'Va afficher le champ co_statio_apr_shob';


--
-- Name: COLUMN cerfa.co_statio_avt_surf; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_statio_avt_surf IS 'Va afficher le champ co_statio_avt_surf';


--
-- Name: COLUMN cerfa.co_statio_apr_surf; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_statio_apr_surf IS 'Va afficher le champ co_statio_apr_surf';


--
-- Name: COLUMN cerfa.co_trx_amgt; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_trx_amgt IS 'Va afficher le champ co_trx_amgt';


--
-- Name: COLUMN cerfa.co_modif_aspect; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_modif_aspect IS 'Va afficher le champ co_modif_aspect';


--
-- Name: COLUMN cerfa.co_modif_struct; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_modif_struct IS 'Va afficher le champ co_modif_struct';


--
-- Name: COLUMN cerfa.co_ouvr_elec; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_ouvr_elec IS 'Va afficher le champ co_ouvr_elec';


--
-- Name: COLUMN cerfa.co_ouvr_infra; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_ouvr_infra IS 'Va afficher le champ co_ouvr_infra';


--
-- Name: COLUMN cerfa.co_trx_imm; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_trx_imm IS 'Va afficher le champ co_trx_imm';


--
-- Name: COLUMN cerfa.co_cstr_shob; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_cstr_shob IS 'Va afficher le champ co_cstr_shob';


--
-- Name: COLUMN cerfa.am_voyage_deb; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.am_voyage_deb IS 'Va afficher le champ am_voyage_deb';


--
-- Name: COLUMN cerfa.am_voyage_fin; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.am_voyage_fin IS 'Va afficher le champ am_voyage_fin';


--
-- Name: COLUMN cerfa.am_modif_amgt; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.am_modif_amgt IS 'Va afficher le champ am_modif_amgt';


--
-- Name: COLUMN cerfa.am_lot_max_shob; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.am_lot_max_shob IS 'Va afficher le champ am_lot_max_shob';


--
-- Name: COLUMN cerfa.mod_desc; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.mod_desc IS 'Va afficher le champ mod_desc';


--
-- Name: COLUMN cerfa.tr_total; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.tr_total IS 'Va afficher le champ tr_total';


--
-- Name: COLUMN cerfa.tr_partiel; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.tr_partiel IS 'Va afficher le champ tr_partiel';


--
-- Name: COLUMN cerfa.tr_desc; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.tr_desc IS 'Va afficher le champ tr_desc';


--
-- Name: COLUMN cerfa.avap_co_elt_pro; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.avap_co_elt_pro IS 'Va afficher le champ avap_co_elt_pro';


--
-- Name: COLUMN cerfa.avap_nouv_haut_surf; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.avap_nouv_haut_surf IS 'Va afficher le champ avap_nouv_haut_surf';


--
-- Name: COLUMN cerfa.avap_co_clot; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.avap_co_clot IS 'Va afficher le champ avap_co_clot';


--
-- Name: COLUMN cerfa.avap_aut_coup_aba_arb; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.avap_aut_coup_aba_arb IS 'Va afficher le champ avap_aut_coup_aba_arb';


--
-- Name: COLUMN cerfa.avap_ouv_infra; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.avap_ouv_infra IS 'Va afficher le champ avap_ouv_infra';


--
-- Name: COLUMN cerfa.avap_aut_inst_mob; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.avap_aut_inst_mob IS 'Va afficher le champ avap_aut_inst_mob';


--
-- Name: COLUMN cerfa.avap_aut_plant; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.avap_aut_plant IS 'Va afficher le champ avap_aut_plant';


--
-- Name: COLUMN cerfa.avap_aut_auv_elec; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.avap_aut_auv_elec IS 'Va afficher le champ avap_aut_auv_elec';


--
-- Name: COLUMN cerfa.tax_dest_loc_tr; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.tax_dest_loc_tr IS 'Va afficher le champ tax_dest_loc_tr';


--
-- Name: COLUMN cerfa.ope_proj_desc; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.ope_proj_desc IS 'Va afficher le champ ope_proj_desc';


--
-- Name: COLUMN cerfa.tax_surf_tot_cstr; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.tax_surf_tot_cstr IS 'Surface taxable totale créée de la ou des construction(s), hormis les surfaces de stationnement closes et couvertes (en m²)';


--
-- Name: COLUMN cerfa.tax_surf_loc_stat; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.tax_surf_loc_stat IS 'Surface taxable des locaux clos et couverts à usage de stationnement';


--
-- Name: COLUMN cerfa.tax_log_ap_trvx_nb; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.tax_log_ap_trvx_nb IS 'Quel est le nombre de logements après travaux ?';


--
-- Name: COLUMN cerfa.tax_am_statio_ext_cr; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.tax_am_statio_ext_cr IS 'Nombre de places de stationnement non couvertes ou non closes';


--
-- Name: COLUMN cerfa.tax_sup_bass_pisc_cr; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.tax_sup_bass_pisc_cr IS 'Superficie du bassin intérieur ou extérieur de la piscine';


--
-- Name: COLUMN cerfa.tax_empl_ten_carav_mobil_nb_cr; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.tax_empl_ten_carav_mobil_nb_cr IS 'Nombre d’emplacements de tentes, de caravanes et de résidences mobiles de loisirs';


--
-- Name: COLUMN cerfa.tax_empl_hll_nb_cr; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.tax_empl_hll_nb_cr IS 'Nombre d’emplacements pour les habitations légères de loisirs';


--
-- Name: COLUMN cerfa.tax_eol_haut_nb_cr; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.tax_eol_haut_nb_cr IS 'Nombre d’éoliennes dont la hauteur est supérieure à 12 m';


--
-- Name: COLUMN cerfa.tax_pann_volt_sup_cr; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.tax_pann_volt_sup_cr IS 'Superficie des panneaux photo-voltaïques posés au sol';


--
-- Name: COLUMN cerfa.tax_surf_loc_arch; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.tax_surf_loc_arch IS 'Veuillez préciser la profondeur du(des) terrasement(s) nécessaire(s) à la réalisation de votre projet - au titre des locaux';


--
-- Name: COLUMN cerfa.tax_surf_pisc_arch; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.tax_surf_pisc_arch IS 'Veuillez préciser la profondeur du(des) terrasement(s) nécessaire(s) à la réalisation de votre projet - au titre de la piscine';


--
-- Name: COLUMN cerfa.tax_am_statio_ext_arch; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.tax_am_statio_ext_arch IS 'Veuillez préciser la profondeur du(des) terrasement(s) nécessaire(s) à la réalisation de votre projet - au titre des emplacements de stationnement';


--
-- Name: COLUMN cerfa.tab_tax_su_parc_statio_expl_comm; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.tab_tax_su_parc_statio_expl_comm IS 'Tableau : Parcs de stationnement couverts faisant l’objet d’une exploitation commerciale';


--
-- Name: COLUMN cerfa.tax_empl_ten_carav_mobil_nb_arch; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.tax_empl_ten_carav_mobil_nb_arch IS 'Veuillez préciser la profondeur du(des) terrasement(s) nécessaire(s) à la réalisation de votre projet - au titre des emplacements de tentes, de caravanes et de résidences mobiles de loisirs';


--
-- Name: COLUMN cerfa.tax_empl_hll_nb_arch; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.tax_empl_hll_nb_arch IS 'Veuillez préciser la profondeur du(des) terrasement(s) nécessaire(s) à la réalisation de votre projet - au titre des emplacements pour les habitations légères de loisirs';


--
-- Name: COLUMN cerfa.tax_eol_haut_nb_arch; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.tax_eol_haut_nb_arch IS 'Nombre d’éoliennes dont la hauteur est supérieure à 12 m concernées';


--
-- Name: COLUMN cerfa.ope_proj_div_co; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.ope_proj_div_co IS 'Division en vue de construire';


--
-- Name: COLUMN cerfa.ope_proj_div_contr; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.ope_proj_div_contr IS 'Division dans une commune qui a institué le contrôle des divisions dans le cadre de l’article L.115-3 du code de l’urbanisme.';


--
-- Name: COLUMN cerfa.tax_desc; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.tax_desc IS 'Informations/Explications complémentaires pouvant vous permettre de bénéficier d’impositions plus favorables.';


--
-- Name: COLUMN cerfa.erp_cstr_neuve; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.erp_cstr_neuve IS 'Nature des travaux : Construction neuve';


--
-- Name: COLUMN cerfa.erp_trvx_acc; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.erp_trvx_acc IS 'Nature des travaux : Travaux de mise en conformité totale aux règles d’accessibilité';


--
-- Name: COLUMN cerfa.erp_extension; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.erp_extension IS 'Nature des travaux : Extension';


--
-- Name: COLUMN cerfa.erp_rehab; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.erp_rehab IS 'Nature des travaux : Réhabilitation';


--
-- Name: COLUMN cerfa.erp_trvx_am; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.erp_trvx_am IS 'Nature des travaux : Travaux d’aménagement (remplacement de revêtements, rénovation électrique, création d’une rampe, par exemple)';


--
-- Name: COLUMN cerfa.erp_vol_nouv_exist; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.erp_vol_nouv_exist IS 'Nature des travaux : Création de volumes nouveaux dans des volumes existants (modification du cloisonnement, par exemple)';


--
-- Name: COLUMN cerfa.tab_erp_eff; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.tab_erp_eff IS 'Tableau : Effectif';


--
-- Name: COLUMN cerfa.erp_class_cat; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.erp_class_cat IS 'Classement sécurité incendie de l’ERP : Catégorie';


--
-- Name: COLUMN cerfa.erp_class_type; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.erp_class_type IS 'Classement sécurité incendie de l’ERP : Type';


--
-- Name: COLUMN cerfa.tax_surf_abr_jard_pig_colom; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.tax_surf_abr_jard_pig_colom IS '1.2.3 Création d’abris de jardin, de pigeonniers et colombiers - Quelle est la surface taxable créée (en m²) ?';


--
-- Name: COLUMN cerfa.tax_su_non_habit_abr_jard_pig_colom; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.tax_su_non_habit_abr_jard_pig_colom IS 'Parmi les surfaces déclarées ci-dessus, quelle est la surface affectée à la catégorie des abris de jardin, pigeonniers et colombiers (en m²) ?';


--
-- Name: COLUMN cerfa.dia_imm_non_bati; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_imm_non_bati IS 'Immeuble : Non bâti';


--
-- Name: COLUMN cerfa.dia_imm_bati_terr_propr; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_imm_bati_terr_propr IS 'Immeuble : Bâti sur terrain propre';


--
-- Name: COLUMN cerfa.dia_imm_bati_terr_autr; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_imm_bati_terr_autr IS 'Immeuble : Bâti sur terrain d’autrui, dans ce cas indiquer nom et adresse du propriétaire';


--
-- Name: COLUMN cerfa.dia_imm_bati_terr_autr_desc; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_imm_bati_terr_autr_desc IS 'Nom et adresse du propriétaire dans le cas ''Bâti sur terrain d’autrui''';


--
-- Name: COLUMN cerfa.dia_bat_copro; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_bat_copro IS 'Locaux dans un bâtiment en copropriété';


--
-- Name: COLUMN cerfa.dia_bat_copro_desc; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_bat_copro_desc IS 'Description du champ ''Locaux dans un bâtiment en copropriété''';


--
-- Name: COLUMN cerfa.dia_lot_numero; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_lot_numero IS 'N° du lot';


--
-- Name: COLUMN cerfa.dia_lot_bat; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_lot_bat IS 'Bâtiment';


--
-- Name: COLUMN cerfa.dia_lot_etage; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_lot_etage IS 'Étage';


--
-- Name: COLUMN cerfa.dia_lot_quote_part; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_lot_quote_part IS 'Quote-part des parties communes';


--
-- Name: COLUMN cerfa.dia_us_hab; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_us_hab IS 'Usage : habitation';


--
-- Name: COLUMN cerfa.dia_us_pro; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_us_pro IS 'Usage : professionnel';


--
-- Name: COLUMN cerfa.dia_us_mixte; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_us_mixte IS 'Usage : mixte';


--
-- Name: COLUMN cerfa.dia_us_comm; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_us_comm IS 'Usage : commercial';


--
-- Name: COLUMN cerfa.dia_us_agr; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_us_agr IS 'Usage : agricole';


--
-- Name: COLUMN cerfa.dia_us_autre; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_us_autre IS 'Usage : autre (préciser)';


--
-- Name: COLUMN cerfa.dia_us_autre_prec; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_us_autre_prec IS 'Précision de l''usage ''autre''';


--
-- Name: COLUMN cerfa.dia_occ_prop; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_occ_prop IS 'Occupation : par le(s) propriétaire(s)';


--
-- Name: COLUMN cerfa.dia_occ_loc; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_occ_loc IS 'Occupation : par un (des) locataire(s)';


--
-- Name: COLUMN cerfa.dia_occ_sans_occ; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_occ_sans_occ IS 'Occupation : sans occupant';


--
-- Name: COLUMN cerfa.dia_occ_autre; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_occ_autre IS 'Occupation : autre (préciser)';


--
-- Name: COLUMN cerfa.dia_occ_autre_prec; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_occ_autre_prec IS 'Précision de l''occupation ''autre''';


--
-- Name: COLUMN cerfa.dia_mod_cess_prix_vente; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_mod_cess_prix_vente IS 'Prix de vente ou évaluation (en lettres et en chiffres)';


--
-- Name: COLUMN cerfa.dia_mod_cess_prix_vente_mob; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_mod_cess_prix_vente_mob IS 'Dont éventuellement inclus : Mobilier';


--
-- Name: COLUMN cerfa.dia_mod_cess_prix_vente_cheptel; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_mod_cess_prix_vente_cheptel IS 'Dont éventuellement inclus : Cheptel';


--
-- Name: COLUMN cerfa.dia_mod_cess_prix_vente_recol; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_mod_cess_prix_vente_recol IS 'Dont éventuellement inclus : Récoltes';


--
-- Name: COLUMN cerfa.dia_mod_cess_prix_vente_autre; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_mod_cess_prix_vente_autre IS 'Dont éventuellement inclus : Autres';


--
-- Name: COLUMN cerfa.dia_mod_cess_commi; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_mod_cess_commi IS 'Si commission, montant';


--
-- Name: COLUMN cerfa.dia_mod_cess_commi_ttc; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_mod_cess_commi_ttc IS 'Le montant de la commission est TTC';


--
-- Name: COLUMN cerfa.dia_mod_cess_commi_ht; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_mod_cess_commi_ht IS 'Le montant de la commission est HT';


--
-- Name: COLUMN cerfa.dia_acquereur_nom_prenom; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_acquereur_nom_prenom IS 'Nom, prénom de l’acquéreur';


--
-- Name: COLUMN cerfa.dia_acquereur_adr_num_voie; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_acquereur_adr_num_voie IS 'N° voie';


--
-- Name: COLUMN cerfa.dia_acquereur_adr_ext; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_acquereur_adr_ext IS 'Extension';


--
-- Name: COLUMN cerfa.dia_acquereur_adr_type_voie; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_acquereur_adr_type_voie IS 'Type de voie';


--
-- Name: COLUMN cerfa.dia_acquereur_adr_nom_voie; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_acquereur_adr_nom_voie IS 'Nom de voie';


--
-- Name: COLUMN cerfa.dia_acquereur_adr_lieu_dit_bp; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_acquereur_adr_lieu_dit_bp IS 'Lieu-dit ou boite postale';


--
-- Name: COLUMN cerfa.dia_acquereur_adr_cp; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_acquereur_adr_cp IS 'Code postal';


--
-- Name: COLUMN cerfa.dia_acquereur_adr_localite; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_acquereur_adr_localite IS 'Localité';


--
-- Name: COLUMN cerfa.dia_observation; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_observation IS 'Observation';


--
-- Name: COLUMN cerfa.tab_surface2; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.tab_surface2 IS 'Tableau : Destination, sous-destination des constructions et tableau des surfaces';


--
-- Name: COLUMN cerfa.dia_occ_sol_su_terre; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_occ_sol_su_terre IS 'Occupation du sol en superficie (m²) : Terres';


--
-- Name: COLUMN cerfa.dia_occ_sol_su_pres; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_occ_sol_su_pres IS 'Occupation du sol en superficie (m²) : Près';


--
-- Name: COLUMN cerfa.dia_occ_sol_su_verger; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_occ_sol_su_verger IS 'Occupation du sol en superficie (m²) : Vergers';


--
-- Name: COLUMN cerfa.dia_occ_sol_su_vigne; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_occ_sol_su_vigne IS 'Occupation du sol en superficie (m²) : Vignes';


--
-- Name: COLUMN cerfa.dia_occ_sol_su_bois; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_occ_sol_su_bois IS 'Occupation du sol en superficie (m²) : Bois';


--
-- Name: COLUMN cerfa.dia_occ_sol_su_lande; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_occ_sol_su_lande IS 'Occupation du sol en superficie (m²) : Landes';


--
-- Name: COLUMN cerfa.dia_occ_sol_su_carriere; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_occ_sol_su_carriere IS 'Occupation du sol en superficie (m²) : Carrières';


--
-- Name: COLUMN cerfa.dia_occ_sol_su_eau_cadastree; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_occ_sol_su_eau_cadastree IS 'Occupation du sol en superficie (m²) : Eaux cadastrées';


--
-- Name: COLUMN cerfa.dia_occ_sol_su_jardin; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_occ_sol_su_jardin IS 'Occupation du sol en superficie (m²) : Jardins';


--
-- Name: COLUMN cerfa.dia_occ_sol_su_terr_batir; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_occ_sol_su_terr_batir IS 'Occupation du sol en superficie (m²) : Terrains à bâtir';


--
-- Name: COLUMN cerfa.dia_occ_sol_su_terr_agr; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_occ_sol_su_terr_agr IS 'Occupation du sol en superficie (m²) : Terrains d''agrément';


--
-- Name: COLUMN cerfa.dia_occ_sol_su_sol; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_occ_sol_su_sol IS 'Occupation du sol en superficie (m²) : Sol';


--
-- Name: COLUMN cerfa.dia_bati_vend_tot; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_bati_vend_tot IS 'Bâtiments vendus en totalité';


--
-- Name: COLUMN cerfa.dia_bati_vend_tot_txt; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_bati_vend_tot_txt IS 'Bâtiments vendus en totalité (texte)';


--
-- Name: COLUMN cerfa.dia_su_co_sol; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_su_co_sol IS 'Surface construite au sol (m2)';


--
-- Name: COLUMN cerfa.dia_su_util_hab; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_su_util_hab IS 'Surface utile ou habitable (m2)';


--
-- Name: COLUMN cerfa.dia_nb_niv; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_nb_niv IS 'Nombre de : Niveaux';


--
-- Name: COLUMN cerfa.dia_nb_appart; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_nb_appart IS 'Nombre de : Appartements';


--
-- Name: COLUMN cerfa.dia_nb_autre_loc; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_nb_autre_loc IS 'Nombre de : Autres locaux';


--
-- Name: COLUMN cerfa.dia_vente_lot_volume; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_vente_lot_volume IS 'Vente en lot de volumes';


--
-- Name: COLUMN cerfa.dia_vente_lot_volume_txt; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_vente_lot_volume_txt IS 'Vente en lot de volumes (texte)';


--
-- Name: COLUMN cerfa.dia_lot_nat_su; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_lot_nat_su IS 'Nature et surface utile ou habitable';


--
-- Name: COLUMN cerfa.dia_lot_bat_achv_plus_10; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_lot_bat_achv_plus_10 IS 'Le bâtiment est achevé depuis : Plus de 10 ans';


--
-- Name: COLUMN cerfa.dia_lot_bat_achv_moins_10; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_lot_bat_achv_moins_10 IS 'Le bâtiment est achevé depuis : Moins de 10 ans';


--
-- Name: COLUMN cerfa.dia_lot_regl_copro_publ_hypo_plus_10; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_lot_regl_copro_publ_hypo_plus_10 IS 'Le règlement de copropriété a été publié aux hypothèques depuis : Plus de 10 ans';


--
-- Name: COLUMN cerfa.dia_lot_regl_copro_publ_hypo_moins_10; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_lot_regl_copro_publ_hypo_moins_10 IS 'Le règlement de copropriété a été publié aux hypothèques depuis : Moins de 10 ans';


--
-- Name: COLUMN cerfa.dia_indivi_quote_part; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_indivi_quote_part IS 'En cas d’indivision, quote-part du bien vendu';


--
-- Name: COLUMN cerfa.dia_design_societe; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_design_societe IS 'Désignation de la société';


--
-- Name: COLUMN cerfa.dia_design_droit; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_design_droit IS 'Désignation des droits';


--
-- Name: COLUMN cerfa.dia_droit_soc_nat; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_droit_soc_nat IS 'Nature';


--
-- Name: COLUMN cerfa.dia_droit_soc_nb; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_droit_soc_nb IS 'Nombre';


--
-- Name: COLUMN cerfa.dia_droit_soc_num_part; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_droit_soc_num_part IS 'Numéro des parts';


--
-- Name: COLUMN cerfa.dia_droit_reel_perso_grevant_bien_oui; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_droit_reel_perso_grevant_bien_oui IS 'Grevant les biens : OUI';


--
-- Name: COLUMN cerfa.dia_droit_reel_perso_grevant_bien_non; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_droit_reel_perso_grevant_bien_non IS 'Grevant les biens : NON';


--
-- Name: COLUMN cerfa.dia_droit_reel_perso_nat; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_droit_reel_perso_nat IS 'Préciser la nature';


--
-- Name: COLUMN cerfa.dia_droit_reel_perso_viag; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_droit_reel_perso_viag IS 'Indiquer si rente viagère antérieure';


--
-- Name: COLUMN cerfa.dia_mod_cess_adr; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_mod_cess_adr IS 'Si vente indissociable d’autres biens : Adresse précise du bien';


--
-- Name: COLUMN cerfa.dia_mod_cess_sign_act_auth; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_mod_cess_sign_act_auth IS 'Modalités de paiement : comptant à la signature de l’acte authentique';


--
-- Name: COLUMN cerfa.dia_mod_cess_terme; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_mod_cess_terme IS 'Modalités de paiement : à terme';


--
-- Name: COLUMN cerfa.dia_mod_cess_terme_prec; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_mod_cess_terme_prec IS 'Modalités de paiement : à terme (préciser)';


--
-- Name: COLUMN cerfa.dia_mod_cess_bene_acquereur; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_mod_cess_bene_acquereur IS 'Bénéficiaire : acquéreur';


--
-- Name: COLUMN cerfa.dia_mod_cess_bene_vendeur; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_mod_cess_bene_vendeur IS 'Bénéficiaire : vendeur';


--
-- Name: COLUMN cerfa.dia_mod_cess_paie_nat; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_mod_cess_paie_nat IS 'Paiement en nature';


--
-- Name: COLUMN cerfa.dia_mod_cess_design_contr_alien; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_mod_cess_design_contr_alien IS 'Désignation de la contrepartie de l’aliénation';


--
-- Name: COLUMN cerfa.dia_mod_cess_eval_contr; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_mod_cess_eval_contr IS 'Evaluation de la contrepartie';


--
-- Name: COLUMN cerfa.dia_mod_cess_rente_viag; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_mod_cess_rente_viag IS 'Rente viagère';


--
-- Name: COLUMN cerfa.dia_mod_cess_mnt_an; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_mod_cess_mnt_an IS 'Montant annuel';


--
-- Name: COLUMN cerfa.dia_mod_cess_mnt_compt; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_mod_cess_mnt_compt IS 'Montant comptant';


--
-- Name: COLUMN cerfa.dia_mod_cess_bene_rente; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_mod_cess_bene_rente IS 'Bénéficiaire(s) de la rente';


--
-- Name: COLUMN cerfa.dia_mod_cess_droit_usa_hab; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_mod_cess_droit_usa_hab IS 'Droit d’usage et d’habitation';


--
-- Name: COLUMN cerfa.dia_mod_cess_droit_usa_hab_prec; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_mod_cess_droit_usa_hab_prec IS 'Droit d’usage et d’habitation (à préciser)';


--
-- Name: COLUMN cerfa.dia_mod_cess_eval_usa_usufruit; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_mod_cess_eval_usa_usufruit IS 'Evaluation de l’usage ou de l’usufruit';


--
-- Name: COLUMN cerfa.dia_mod_cess_vente_nue_prop; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_mod_cess_vente_nue_prop IS 'Vente de la nue-propriété';


--
-- Name: COLUMN cerfa.dia_mod_cess_vente_nue_prop_prec; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_mod_cess_vente_nue_prop_prec IS 'Vente de la nue-propriété (à préciser)';


--
-- Name: COLUMN cerfa.dia_mod_cess_echange; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_mod_cess_echange IS 'Echange';


--
-- Name: COLUMN cerfa.dia_mod_cess_design_bien_recus_ech; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_mod_cess_design_bien_recus_ech IS 'Désignation des biens reçus en échange';


--
-- Name: COLUMN cerfa.dia_mod_cess_mnt_soulte; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_mod_cess_mnt_soulte IS 'Montant de la soulte le cas échéant';


--
-- Name: COLUMN cerfa.dia_mod_cess_prop_contre_echan; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_mod_cess_prop_contre_echan IS 'Propriétaires contre-échangistes';


--
-- Name: COLUMN cerfa.dia_mod_cess_apport_societe; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_mod_cess_apport_societe IS 'Apport en société';


--
-- Name: COLUMN cerfa.dia_mod_cess_bene; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_mod_cess_bene IS 'Bénéficiaire';


--
-- Name: COLUMN cerfa.dia_mod_cess_esti_bien; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_mod_cess_esti_bien IS 'Estimation du bien apporté';


--
-- Name: COLUMN cerfa.dia_mod_cess_cess_terr_loc_co; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_mod_cess_cess_terr_loc_co IS 'Cession de tantième de terrains contre remise de locaux à construire';


--
-- Name: COLUMN cerfa.dia_mod_cess_esti_terr; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_mod_cess_esti_terr IS 'Estimation du terrain';


--
-- Name: COLUMN cerfa.dia_mod_cess_esti_loc; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_mod_cess_esti_loc IS 'Estimation des locaux à remettre';


--
-- Name: COLUMN cerfa.dia_mod_cess_esti_imm_loca; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_mod_cess_esti_imm_loca IS 'Location-accession – Estimation de l’immeuble objet de la location-accession';


--
-- Name: COLUMN cerfa.dia_mod_cess_adju_vol; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_mod_cess_adju_vol IS 'Volontaire';


--
-- Name: COLUMN cerfa.dia_mod_cess_adju_obl; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_mod_cess_adju_obl IS 'Rendue obligatoire par une disposition législative ou réglementaire';


--
-- Name: COLUMN cerfa.dia_mod_cess_adju_fin_indivi; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_mod_cess_adju_fin_indivi IS 'Mettant fin à une indivision ne résultant pas d’une donation-partage';


--
-- Name: COLUMN cerfa.dia_mod_cess_adju_date_lieu; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_mod_cess_adju_date_lieu IS 'Date et lieu de l’adjudication';


--
-- Name: COLUMN cerfa.dia_mod_cess_mnt_mise_prix; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_mod_cess_mnt_mise_prix IS 'Montant de la mise à prix';


--
-- Name: COLUMN cerfa.dia_prop_titu_prix_indique; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_prop_titu_prix_indique IS 'Que le(s) propriétaire(s) nommé(s) à la rubrique 1 : Demande(nt) au titulaire du droit de préemption d’acquérir les biens désignés à la rubrique 3 aux prix et conditions indiqués';


--
-- Name: COLUMN cerfa.dia_prop_recherche_acqu_prix_indique; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_prop_recherche_acqu_prix_indique IS 'Que le(s) propriétaire(s) nommé(s) à la rubrique 1 : A (ont) recherché un acquéreur disposé à acquérir les biens désignés à la rubrique 3 aux prix et conditions indiqués';


--
-- Name: COLUMN cerfa.dia_acquereur_prof; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_acquereur_prof IS 'Profession (facultatif)';


--
-- Name: COLUMN cerfa.dia_indic_compl_ope; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_indic_compl_ope IS 'Indications complémentaires concernant l’opération envisagée par l’acquéreur (facultatif)';


--
-- Name: COLUMN cerfa.dia_vente_adju; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_vente_adju IS 'Qu’il est chargé de procéder à la vente par voie d’adjudication comme indiqué à la rubrique F-2 des biens désignés à la rubrique C appartenant a(ux) propriétaire(s) nommé(s) en A';


--
-- Name: COLUMN cerfa.am_terr_res_demon; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.am_terr_res_demon IS 'Aménagement d’un terrain pour au moins 2 résidences démontables, créant une surface de plancher totale supérieure à 40M², constituant l’habitat permanent de leurs utilisateurs';


--
-- Name: COLUMN cerfa.am_air_terr_res_mob; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.am_air_terr_res_mob IS 'Aménagement d’une aire d’accueil ou d’un terrain familial des gens du voyage recevant plus de deux résidences mobiles';


--
-- Name: COLUMN cerfa.ctx_objet_recours; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.ctx_objet_recours IS 'Objet du recours';


--
-- Name: COLUMN cerfa.ctx_moyen_souleve; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.ctx_moyen_souleve IS 'Moyens soulevés';


--
-- Name: COLUMN cerfa.ctx_moyen_retenu_juge; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.ctx_moyen_retenu_juge IS 'Moyens retenus par le juge';


--
-- Name: COLUMN cerfa.ctx_reference_sagace; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.ctx_reference_sagace IS 'Références sagaces';


--
-- Name: COLUMN cerfa.ctx_nature_travaux_infra_om_html; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.ctx_nature_travaux_infra_om_html IS 'Nature des travaux en infraction (NTI)';


--
-- Name: COLUMN cerfa.ctx_synthese_nti; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.ctx_synthese_nti IS 'Synthèse des NTI';


--
-- Name: COLUMN cerfa.ctx_article_non_resp_om_html; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.ctx_article_non_resp_om_html IS 'Article(s) non respecté(s) (ANR)';


--
-- Name: COLUMN cerfa.ctx_synthese_anr; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.ctx_synthese_anr IS 'Synthèse (ANR)';


--
-- Name: COLUMN cerfa.ctx_reference_parquet; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.ctx_reference_parquet IS 'Références Parquet';


--
-- Name: COLUMN cerfa.ctx_element_taxation; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.ctx_element_taxation IS 'Éléments de taxation';


--
-- Name: COLUMN cerfa.ctx_infraction; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.ctx_infraction IS 'Infraction';


--
-- Name: COLUMN cerfa.ctx_regularisable; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.ctx_regularisable IS 'Régularisable';


--
-- Name: COLUMN cerfa.ctx_reference_courrier; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.ctx_reference_courrier IS 'Référence(s) courrier';


--
-- Name: COLUMN cerfa.ctx_date_audience; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.ctx_date_audience IS 'Date d''audience';


--
-- Name: COLUMN cerfa.ctx_date_ajournement; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.ctx_date_ajournement IS 'Date d''ajournement';


--
-- Name: COLUMN cerfa.exo_facul_1; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.exo_facul_1 IS 'Les locaux d''habitation et d''hébergement mentionnés au 1° de l''article L. 331-12 qui ne bénéficient pas de l''exonération prévue au 2° de l''article L. 331-7.';


--
-- Name: COLUMN cerfa.exo_facul_2; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.exo_facul_2 IS 'Dans la limite de 50 % de leur surface, les surfaces des locaux à usage d''habitation principale qui ne bénéficient pas de l''abattement mentionné au 2° de l''article L. 331-12 et qui sont financés à l''aide du prêt ne portant pas intérêt prévu à l''article L. 31-10-1 du code de la construction et de l''habitation.';


--
-- Name: COLUMN cerfa.exo_facul_3; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.exo_facul_3 IS 'Les locaux à usage industriel et artisanal mentionnés au 3° de l''article L. 331-12 du présent code.';


--
-- Name: COLUMN cerfa.exo_facul_4; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.exo_facul_4 IS 'Les commerces de détail d''une surface de vente inférieure à 400 mètres carrés.';


--
-- Name: COLUMN cerfa.exo_facul_5; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.exo_facul_5 IS 'Les immeubles classés parmi les monuments historiques ou inscrits à l''inventaire supplémentaire des monuments historiques.';


--
-- Name: COLUMN cerfa.exo_facul_6; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.exo_facul_6 IS 'Les surfaces annexes à usage de stationnement des locaux mentionnés au 1° et ne bénéficiant pas de l''exonération totale.';


--
-- Name: COLUMN cerfa.exo_facul_7; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.exo_facul_7 IS 'Les surfaces des locaux annexes à usage de stationnement des immeubles autres que d''habitations individuelles.';


--
-- Name: COLUMN cerfa.exo_facul_8; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.exo_facul_8 IS 'Les abris de jardin, les pigeonniers et colombiers soumis à déclaration préalable.';


--
-- Name: COLUMN cerfa.exo_facul_9; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.exo_facul_9 IS 'Les maisons de santé mentionnées à l''article L. 6323-3 du code de la santé publique, pour les communes maîtres d''ouvrage.';


--
-- Name: COLUMN cerfa.exo_ta_1; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.exo_ta_1 IS 'Les constructions et aménagements destinés à être affectés à un service public ou d''utilité publique, dont la liste est fixée par un décret en Conseil d''Etat.';


--
-- Name: COLUMN cerfa.exo_ta_2; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.exo_ta_2 IS 'Les constructions de locaux d''habitation et d''hébergement mentionnés aux articles 278 sexies et 296 ter du code général des impôts et, en Guyane et à Mayotte, les constructions de mêmes locaux, dès lors qu''ils sont financés dans les conditions du II de l''article R. 331-1 du code de la construction et de l''habitation ou du b du 2 de l''article R. 372-9 du même code.';


--
-- Name: COLUMN cerfa.exo_ta_3; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.exo_ta_3 IS 'Dans les exploitations et coopératives agricoles, les surfaces de plancher des serres de production, celles des locaux destinés à abriter les récoltes, à héberger les animaux, à ranger et à entretenir le matériel agricole, celles des locaux de production et de stockage des produits à usage agricole, celles des locaux de transformation et de conditionnement des produits provenant de l''exploitation et, dans les centres équestres de loisir, les surfaces des bâtiments affectées aux activités équestres.';


--
-- Name: COLUMN cerfa.exo_ta_4; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.exo_ta_4 IS 'Les constructions et aménagements réalisés dans les périmètres des opérations d''intérêt national prévues à l''article L. 102-12 lorsque le coût des équipements, dont la liste est fixée par décret en Conseil d''Etat, a été mis à la charge des constructeurs ou des aménageurs.';


--
-- Name: COLUMN cerfa.exo_ta_5; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.exo_ta_5 IS 'Les constructions et aménagements réalisés dans les zones d''aménagement concerté mentionnées à l''article L. 311-1 lorsque le coût des équipements publics, dont la liste est fixée par un décret en Conseil d''Etat, a été mis à la charge des constructeurs ou des aménageurs. Cette liste peut être complétée par une délibération du conseil municipal ou de l''organe délibérant de l''établissement public de coopération intercommunale valable pour une durée minimale de trois ans.';


--
-- Name: COLUMN cerfa.exo_ta_6; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.exo_ta_6 IS 'Les constructions et aménagements réalisés dans les périmètres délimités par une convention de projet urbain partenarial prévue par l''article L. 332-11-3, dans les limites de durée prévues par cette convention, en application de l''article L. 332-11-4.';


--
-- Name: COLUMN cerfa.exo_ta_7; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.exo_ta_7 IS 'Les aménagements prescrits par un plan de prévention des risques naturels prévisibles, un plan de prévention des risques technologiques ou un plan de prévention des risques miniers sur des biens construits ou aménagés conformément aux dispositions du présent code avant l''approbation de ce plan et mis à la charge des propriétaires ou exploitants de ces biens.';


--
-- Name: COLUMN cerfa.exo_ta_8; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.exo_ta_8 IS 'La reconstruction à l''identique d''un bâtiment détruit ou démoli depuis moins de dix ans dans les conditions prévues au premier alinéa de l''article L. 111-15, sous réserve des dispositions du 4° de l''article L. 331-30, ainsi que la reconstruction sur d''autres terrains de la même commune ou des communes limitrophes des bâtiments de même nature que les locaux sinistrés dont le terrain d''implantation a été reconnu comme extrêmement dangereux et classé inconstructible, pourvu que le contribuable justifie que les indemnités versées en réparation des dommages occasionnés à l''immeuble ne comprennent pas le montant de la taxe d''aménagement normalement exigible sur les reconstructions.';


--
-- Name: COLUMN cerfa.exo_ta_9; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.exo_ta_9 IS 'Les constructions dont la surface est inférieure ou égale à 5 mètres carrés.';


--
-- Name: COLUMN cerfa.exo_rap_1; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.exo_rap_1 IS 'Travaux et aménagements dont la surface au sol est inférieure à 3 000 m².';


--
-- Name: COLUMN cerfa.exo_rap_2; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.exo_rap_2 IS 'Les constructions de locaux d''habitation et d''hébergement mentionnés aux articles 278 sexies et 296 ter du code général des impôts et, en Guyane et à Mayotte, les constructions de mêmes locaux, dès lors qu''ils sont financés dans les conditions du II de l''article R. 331-1 du code de la construction et de l''habitation ou du b du 2 de l''article R. 372-9 du même code.';


--
-- Name: COLUMN cerfa.exo_rap_3; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.exo_rap_3 IS 'Travaux n''affectant pas le sous-sol : surélévation d''un bâtiment existant, emplacement sans fondation (emplacement de tente, caravane et résidence mobile de loisirs sur un terrain de camping, panneau photovoltaïque fixé au sol, aire de stationnement extérieure...).';


--
-- Name: COLUMN cerfa.exo_rap_4; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.exo_rap_4 IS 'Dans les exploitations et coopératives agricoles, les surfaces de plancher des serres de production, celles des locaux destinés à abriter les récoltes, à héberger les animaux, à ranger et à entretenir le matériel agricole, celles des locaux de production et de stockage des produits à usage agricole, celles des locaux de transformation et de conditionnement des produits provenant de l''exploitation et, dans les centres équestres de loisir, les surfaces des bâtiments affectées aux activités équestres.';


--
-- Name: COLUMN cerfa.exo_rap_5; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.exo_rap_5 IS 'Les constructions et aménagements destinés à être affectés à un service public ou d''utilité publique, dont la liste est fixée par un décret en Conseil d''Etat.';


--
-- Name: COLUMN cerfa.exo_rap_6; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.exo_rap_6 IS 'La reconstruction à l''identique d''un bâtiment détruit ou démoli depuis moins de dix ans dans les conditions prévues au premier alinéa de l''article L. 111-15, sous réserve des dispositions du 4° de l''article L. 331-30, ainsi que la reconstruction sur d''autres terrains de la même commune ou des communes limitrophes des bâtiments de même nature que les locaux sinistrés dont le terrain d''implantation a été reconnu comme extrêmement dangereux et classé inconstructible, pourvu que le contribuable justifie que les indemnités versées en réparation des dommages occasionnés à l''immeuble ne comprennent pas le montant de la taxe d''aménagement normalement exigible sur les reconstructions.';


--
-- Name: COLUMN cerfa.exo_rap_7; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.exo_rap_7 IS 'Les aménagements prescrits par un plan de prévention des risques naturels prévisibles, un plan de prévention des risques technologiques ou un plan de prévention des risques miniers sur des biens construits ou aménagés conformément aux dispositions du présent code avant l''approbation de ce plan et mis à la charge des propriétaires ou exploitants de ces biens.';


--
-- Name: COLUMN cerfa.exo_rap_8; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.exo_rap_8 IS 'Les constructions dont la surface est inférieure ou égale à 5 mètres carrés.';


--
-- Name: COLUMN cerfa.mtn_exo_ta_part_commu; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.mtn_exo_ta_part_commu IS 'Montant de l''exonération de la taxe d’aménagement sur la part communale.';


--
-- Name: COLUMN cerfa.mtn_exo_ta_part_depart; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.mtn_exo_ta_part_depart IS 'Montant de l''exonération de la taxe d’aménagement sur la part départementale.';


--
-- Name: COLUMN cerfa.mtn_exo_ta_part_reg; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.mtn_exo_ta_part_reg IS 'Montant de l''exonération de la taxe d’aménagement sur la part régionale.';


--
-- Name: COLUMN cerfa.mtn_exo_rap; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.mtn_exo_rap IS 'Montant de l''exonération de la redevance d''archéologie préventive.';


--
-- Name: COLUMN cerfa.dpc_type; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dpc_type IS 'Type de droit de préemption commercial';


--
-- Name: COLUMN cerfa.dpc_desc_actv_ex; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dpc_desc_actv_ex IS 'Activité exercée';


--
-- Name: COLUMN cerfa.dpc_desc_ca; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dpc_desc_ca IS 'Chiffre d’affaires';


--
-- Name: COLUMN cerfa.dpc_desc_aut_prec; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dpc_desc_aut_prec IS 'Autres précisions';


--
-- Name: COLUMN cerfa.dpc_desig_comm_arti; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dpc_desig_comm_arti IS 'Bien à usage uniquement commercial ou artisanal';


--
-- Name: COLUMN cerfa.dpc_desig_loc_hab; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dpc_desig_loc_hab IS 'Bien comportant un local accessoire d’habitation';


--
-- Name: COLUMN cerfa.dpc_desig_loc_ann; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dpc_desig_loc_ann IS 'Bien comportant d’autres locaux annexes (entrepôts, ateliers, etc.)';


--
-- Name: COLUMN cerfa.dpc_desig_loc_ann_prec; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dpc_desig_loc_ann_prec IS 'Préciser la composition de ces autres locaux';


--
-- Name: COLUMN cerfa.dpc_bail_comm_date; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dpc_bail_comm_date IS 'Date de signature du bail';


--
-- Name: COLUMN cerfa.dpc_bail_comm_loyer; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dpc_bail_comm_loyer IS 'Montant du loyer';


--
-- Name: COLUMN cerfa.dpc_actv_acqu; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dpc_actv_acqu IS 'Activité de l’acquéreur pressenti';


--
-- Name: COLUMN cerfa.dpc_nb_sala_di; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dpc_nb_sala_di IS 'À durée indéterminée';


--
-- Name: COLUMN cerfa.dpc_nb_sala_dd; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dpc_nb_sala_dd IS 'À durée déterminée';


--
-- Name: COLUMN cerfa.dpc_nb_sala_tc; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dpc_nb_sala_tc IS 'À temps complet';


--
-- Name: COLUMN cerfa.dpc_nb_sala_tp; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dpc_nb_sala_tp IS 'À temps partiel';


--
-- Name: COLUMN cerfa.dpc_moda_cess_vente_am; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dpc_moda_cess_vente_am IS 'Vente amiable';


--
-- Name: COLUMN cerfa.dpc_moda_cess_adj; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dpc_moda_cess_adj IS 'Adjudication';


--
-- Name: COLUMN cerfa.dpc_moda_cess_prix; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dpc_moda_cess_prix IS 'Prix de vente ou évaluation (en lettres et chiffres)';


--
-- Name: COLUMN cerfa.dpc_moda_cess_adj_date; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dpc_moda_cess_adj_date IS 'En cas d’adjudication, précisez la date';


--
-- Name: COLUMN cerfa.dpc_moda_cess_adj_prec; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dpc_moda_cess_adj_prec IS 'En cas d’adjudication, précisez les modalités de la vente';


--
-- Name: COLUMN cerfa.dpc_moda_cess_paie_comp; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dpc_moda_cess_paie_comp IS 'Comptant à la signature de l’acte authentique';


--
-- Name: COLUMN cerfa.dpc_moda_cess_paie_terme; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dpc_moda_cess_paie_terme IS 'À terme';


--
-- Name: COLUMN cerfa.dpc_moda_cess_paie_terme_prec; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dpc_moda_cess_paie_terme_prec IS 'À terme, précisez';


--
-- Name: COLUMN cerfa.dpc_moda_cess_paie_nat; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dpc_moda_cess_paie_nat IS 'Paiement en nature';


--
-- Name: COLUMN cerfa.dpc_moda_cess_paie_nat_desig_alien; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dpc_moda_cess_paie_nat_desig_alien IS 'Désignation de la contrepartie de l’aliénation';


--
-- Name: COLUMN cerfa.dpc_moda_cess_paie_nat_desig_alien_prec; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dpc_moda_cess_paie_nat_desig_alien_prec IS 'Désignation de la contrepartie de l’aliénation, précisez';


--
-- Name: COLUMN cerfa.dpc_moda_cess_paie_nat_eval; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dpc_moda_cess_paie_nat_eval IS 'Évaluation de la contrepartie';


--
-- Name: COLUMN cerfa.dpc_moda_cess_paie_nat_eval_prec; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dpc_moda_cess_paie_nat_eval_prec IS 'Évaluation de la contrepartie, précisez';


--
-- Name: COLUMN cerfa.dpc_moda_cess_paie_aut; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dpc_moda_cess_paie_aut IS 'Autre : échange, apport en société...';


--
-- Name: COLUMN cerfa.dpc_moda_cess_paie_aut_prec; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dpc_moda_cess_paie_aut_prec IS 'Autre : échange, apport en société... Précisez';


--
-- Name: COLUMN cerfa.dpc_ss_signe_demande_acqu; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dpc_ss_signe_demande_acqu IS 'Demande au titulaire du droit de préemption d’acquérir le bien désigné à la rubrique 3';


--
-- Name: COLUMN cerfa.dpc_ss_signe_recher_trouv_acqu; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dpc_ss_signe_recher_trouv_acqu IS 'A recherché et trouvé un acquéreur disposé à acheter le bien désigné à la rubrique 3 aux prix et conditions indiqués';


--
-- Name: COLUMN cerfa.dpc_notif_adr_prop; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dpc_notif_adr_prop IS 'À l’adresse du propriétaire ou du titulaire du bail désigné à la rubrique 1';


--
-- Name: COLUMN cerfa.dpc_notif_adr_manda; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dpc_notif_adr_manda IS 'À l’adresse du mandataire désigné à la rubrique 6';


--
-- Name: COLUMN cerfa.dpc_obs; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dpc_obs IS 'Observations éventuelles';


--
-- Name: COLUMN cerfa.co_peri_site_patri_remar; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_peri_site_patri_remar IS 'Indiquez si votre projet se situe dans les périmètres de protection suivants : se situe dans le périmètre d''un site patrimonial remarquable';


--
-- Name: COLUMN cerfa.co_abo_monu_hist; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_abo_monu_hist IS 'Indiquez si votre projet se situe dans les périmètres de protection suivants : se situe dans les abords d''un monument historique';


--
-- Name: COLUMN cerfa.co_inst_ouvr_trav_act_code_envir; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_inst_ouvr_trav_act_code_envir IS 'Indiquez si votre projet : porte sur une installation, un ouvrage, des travaux ou une activité soumis à déclaration en application du code de l''environnement (IOTA)';


--
-- Name: COLUMN cerfa.co_trav_auto_env; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_trav_auto_env IS 'Indiquez si votre projet : porte sur des travaux soumis à autorisation environnementale en application du L.181-1 du code de l''environnement';


--
-- Name: COLUMN cerfa.co_derog_esp_prot; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_derog_esp_prot IS 'Indiquez si votre projet : fait l''objet d’une dérogation au titre du L.411-2 4° du code de l''environnement (dérogation espèces protégées)';


--
-- Name: COLUMN cerfa.ctx_reference_dsj; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.ctx_reference_dsj IS 'Référence DSJ';


--
-- Name: COLUMN cerfa.co_piscine; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_piscine IS 'Piscine';


--
-- Name: COLUMN cerfa.co_fin_lls; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_fin_lls IS 'Mode de financement du projet : Logement Locatif Social';


--
-- Name: COLUMN cerfa.co_fin_aa; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_fin_aa IS 'Mode de financement du projet : Accession Sociale (hors prêt à taux zéro)';


--
-- Name: COLUMN cerfa.co_fin_ptz; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_fin_ptz IS 'Mode de financement du projet : Prêt à taux zéro';


--
-- Name: COLUMN cerfa.co_fin_autr; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_fin_autr IS 'Mode de financement du projet : Autres financements';


--
-- Name: COLUMN cerfa.dia_ss_date; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_ss_date IS 'Document signé le';


--
-- Name: COLUMN cerfa.dia_ss_lieu; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.dia_ss_lieu IS 'Document signé à';


--
-- Name: COLUMN cerfa.enga_decla_lieu; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.enga_decla_lieu IS 'Engagement du déclarant : lieu de signature';


--
-- Name: COLUMN cerfa.enga_decla_date; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.enga_decla_date IS 'Engagement du déclarant : date de signature';


--
-- Name: COLUMN cerfa.co_archi_attest_honneur; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_archi_attest_honneur IS 'Je déclare sur l''honneur que mon projet entre dans l''une des situations pour lesquelles le recours à l''architecte n''est pas obligatoire';


--
-- Name: COLUMN cerfa.co_bat_niv_dessous_nb; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_bat_niv_dessous_nb IS 'Le nombre de niveaux du bâtiment le plus élevé : au-dessous du sol';


--
-- Name: COLUMN cerfa.co_install_classe; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_install_classe IS 'porte sur une installation classée soumise à enregistrement en application de l''article L. 512-7 du code de l''environnement';


--
-- Name: COLUMN cerfa.co_derog_innov; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_derog_innov IS 'déroge à certaines règles de construction et met en œuvre une solution d''effet équivalent au titre de l''ordonnance n° 2018-937 du 30 octobre 2018 visant à faciliter la réalisation de projets de construction et à favoriser l''innovation';


--
-- Name: COLUMN cerfa.co_avis_abf; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_avis_abf IS 'relève de l''article L.632-2-1 du code du patrimoine (avis simple de l''architecte des Bâtiments de France pour les antennes-relais et les opérations liées au traitement de l''habitat indigne)';


--
-- Name: COLUMN cerfa.tax_surf_tot_demo; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.tax_surf_tot_demo IS 'Surface taxable démolie de la (ou des) construction(s)';


--
-- Name: COLUMN cerfa.tax_surf_tax_demo; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.tax_surf_tax_demo IS 'Quelle est la surface taxable démolie ?';


--
-- Name: COLUMN cerfa.tax_terrassement_arch; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.tax_terrassement_arch IS 'Votre projet fait-il l''objet d''un (ou de) terrassement(s) ?';


--
-- Name: COLUMN cerfa.tax_adresse_future_numero; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.tax_adresse_future_numero IS 'Adresse à échéance des taxes : Numéro';


--
-- Name: COLUMN cerfa.tax_adresse_future_voie; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.tax_adresse_future_voie IS 'Adresse à échéance des taxes : Voie';


--
-- Name: COLUMN cerfa.tax_adresse_future_lieudit; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.tax_adresse_future_lieudit IS 'Adresse à échéance des taxes : Lieu-dit';


--
-- Name: COLUMN cerfa.tax_adresse_future_localite; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.tax_adresse_future_localite IS 'Adresse à échéance des taxes : Localité';


--
-- Name: COLUMN cerfa.tax_adresse_future_cp; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.tax_adresse_future_cp IS 'Adresse à échéance des taxes : Code postal';


--
-- Name: COLUMN cerfa.tax_adresse_future_bp; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.tax_adresse_future_bp IS 'Adresse à échéance des taxes : BP';


--
-- Name: COLUMN cerfa.tax_adresse_future_cedex; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.tax_adresse_future_cedex IS 'Adresse à échéance des taxes : Cedex';


--
-- Name: COLUMN cerfa.tax_adresse_future_pays; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.tax_adresse_future_pays IS 'Adresse à échéance des taxes : Pays';


--
-- Name: COLUMN cerfa.tax_adresse_future_division; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.tax_adresse_future_division IS 'Adresse à échéance des taxes : Division territoriale';


--
-- Name: COLUMN cerfa.co_bat_projete; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_bat_projete IS 'Indiquez la destination, la sous-destination et la localisation approximative des bâtiments projetés dans l''unité foncière';


--
-- Name: COLUMN cerfa.co_bat_existant; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_bat_existant IS 'Indiquez la destination et la sous-destination des bâtiments à conserver ou à démolir';


--
-- Name: COLUMN cerfa.co_bat_nature; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_bat_nature IS 'Vous pouvez compléter cette note par des feuilles supplémentaires, des plans, des croquis, des photos. Dans ce cas, précisez ci-dessous la nature et le nombre des pièces fournies';


--
-- Name: COLUMN cerfa.terr_juri_titul_date; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.terr_juri_titul_date IS 'Si oui, à quelle date a t-il été délivré ?';


--
-- Name: COLUMN cerfa.co_autre_desc; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_autre_desc IS 'Autres travaux envisagés (précisez)';


--
-- Name: COLUMN cerfa.co_trx_autre; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_trx_autre IS 'Travaux comprennent notamment : Autre (précisez)';


--
-- Name: COLUMN cerfa.co_autre; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_autre IS 'Autres travaux envisagés';


--
-- Name: COLUMN cerfa.erp_modif_facades; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.erp_modif_facades IS 'Modification des accès en façades';


--
-- Name: COLUMN cerfa.erp_trvx_adap; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.erp_trvx_adap IS 'travaux mettent en œuvre des engagements d''un Ad''AP déposé antérieurement';


--
-- Name: COLUMN cerfa.erp_trvx_adap_numero; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.erp_trvx_adap_numero IS 'travaux mettent en œuvre des engagements d''un Ad''AP déposé antérieurement : Ad''AP n°';


--
-- Name: COLUMN cerfa.erp_trvx_adap_valid; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.erp_trvx_adap_valid IS 'travaux mettent en œuvre des engagements d''un Ad''AP déposé antérieurement : validé le';


--
-- Name: COLUMN cerfa.erp_prod_dangereux; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.erp_prod_dangereux IS 'Cette demande fait l''objet d''une déclaration ou autorisation au titre du code de l''environnement (produits dangereux stockés ou utilisés)';


--
-- Name: COLUMN cerfa.co_trav_supp_dessus; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_trav_supp_dessus IS 'Création de niveaux supplémentaires : au-dessus du sol';


--
-- Name: COLUMN cerfa.co_trav_supp_dessous; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.co_trav_supp_dessous IS 'Création de niveaux supplémentaires : au-dessous du sol';


--
-- Name: COLUMN cerfa.tax_su_habit_abr_jard_pig_colom; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.tax_su_habit_abr_jard_pig_colom IS 'Création de locaux destinés à l''habitation : Parmi les surfaces déclarées ci-dessus, quelle est la surface affectée à la catégorie des abris de jardin, pigeonniers et colombiers (en m²) ?';


--
-- Name: COLUMN cerfa.enga_decla_donnees_nomi_comm; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN cerfa.enga_decla_donnees_nomi_comm IS 'Pour permettre l''utilisation des informations nominatives comprises dans ce formulaire à des fins commerciales, cochez la case ci-contre';


--
-- Name: cerfa_seq; Type: SEQUENCE; Schema: openads; Owner: -
--

CREATE SEQUENCE cerfa_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- Name: cerfa_seq; Type: SEQUENCE OWNED BY; Schema: openads; Owner: -
--

ALTER SEQUENCE cerfa_seq OWNED BY cerfa.cerfa;


--
-- Name: civilite; Type: TABLE; Schema: openads; Owner: -
--

CREATE TABLE civilite (
    code character varying(20) NOT NULL,
    civilite integer NOT NULL,
    libelle character varying(100),
    om_validite_debut date,
    om_validite_fin date
);


--
-- Name: TABLE civilite; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON TABLE civilite IS 'Titre de civilité';


--
-- Name: COLUMN civilite.code; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN civilite.code IS 'Code de la civilité';


--
-- Name: COLUMN civilite.civilite; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN civilite.civilite IS 'Identifiant unique';


--
-- Name: COLUMN civilite.libelle; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN civilite.libelle IS 'Libellé de la civilité';


--
-- Name: COLUMN civilite.om_validite_debut; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN civilite.om_validite_debut IS 'Date de début de validité de la civilité';


--
-- Name: COLUMN civilite.om_validite_fin; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN civilite.om_validite_fin IS 'Date de fin de validité de la civilité';


--
-- Name: civilite_seq; Type: SEQUENCE; Schema: openads; Owner: -
--

CREATE SEQUENCE civilite_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- Name: civilite_seq; Type: SEQUENCE OWNED BY; Schema: openads; Owner: -
--

ALTER SEQUENCE civilite_seq OWNED BY civilite.civilite;


--
-- Name: commission; Type: TABLE; Schema: openads; Owner: -
--

CREATE TABLE commission (
    commission integer NOT NULL,
    code character varying(20),
    commission_type integer NOT NULL,
    libelle character varying(100),
    date_commission date NOT NULL,
    heure_commission character varying(5),
    lieu_adresse_ligne1 character varying(100),
    lieu_adresse_ligne2 character varying(100),
    lieu_salle character varying(100),
    listes_de_diffusion text,
    participants text,
    om_fichier_commission_ordre_jour character varying(255),
    om_final_commission_ordre_jour boolean,
    om_fichier_commission_compte_rendu character varying(255),
    om_final_commission_compte_rendu boolean,
    om_collectivite integer NOT NULL
);


--
-- Name: TABLE commission; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON TABLE commission IS 'Demande de passage en commission';


--
-- Name: COLUMN commission.commission; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN commission.commission IS 'Identifiant unique';


--
-- Name: COLUMN commission.code; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN commission.code IS 'Code de la commission';


--
-- Name: COLUMN commission.commission_type; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN commission.commission_type IS 'Type de la commission';


--
-- Name: COLUMN commission.libelle; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN commission.libelle IS 'Libellé de la commission';


--
-- Name: COLUMN commission.date_commission; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN commission.date_commission IS 'Date de passage de la commission';


--
-- Name: COLUMN commission.heure_commission; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN commission.heure_commission IS 'Heure de passage de la commission';


--
-- Name: COLUMN commission.lieu_adresse_ligne1; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN commission.lieu_adresse_ligne1 IS 'Adresse de passage de la commission';


--
-- Name: COLUMN commission.lieu_adresse_ligne2; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN commission.lieu_adresse_ligne2 IS 'Complément d''adresse de passage de la commission';


--
-- Name: COLUMN commission.lieu_salle; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN commission.lieu_salle IS 'Salle de passage de la commission';


--
-- Name: COLUMN commission.listes_de_diffusion; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN commission.listes_de_diffusion IS 'Liste des emails à notifier pour le compte rendu de la commission';


--
-- Name: COLUMN commission.participants; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN commission.participants IS 'Participants à la commission';


--
-- Name: COLUMN commission.om_fichier_commission_ordre_jour; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN commission.om_fichier_commission_ordre_jour IS 'Identifiant du fichier de l''ordre du jour de la commission finalisé dans le système de stockage';


--
-- Name: COLUMN commission.om_final_commission_ordre_jour; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN commission.om_final_commission_ordre_jour IS 'Permet de savoir si le fichier de l''ordre du jour de la commission est finalisé';


--
-- Name: COLUMN commission.om_fichier_commission_compte_rendu; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN commission.om_fichier_commission_compte_rendu IS 'Identifiant du fichier du compte rendu de la commission finalisé dans le système de stockage';


--
-- Name: COLUMN commission.om_final_commission_compte_rendu; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN commission.om_final_commission_compte_rendu IS 'Permet de savoir si le fichier du compte rendu de la commission est finalisé';


--
-- Name: COLUMN commission.om_collectivite; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN commission.om_collectivite IS 'Lien vers la collectivité concernée';


--
-- Name: commission_seq; Type: SEQUENCE; Schema: openads; Owner: -
--

CREATE SEQUENCE commission_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- Name: commission_seq; Type: SEQUENCE OWNED BY; Schema: openads; Owner: -
--

ALTER SEQUENCE commission_seq OWNED BY commission.commission;


--
-- Name: commission_type; Type: TABLE; Schema: openads; Owner: -
--

CREATE TABLE commission_type (
    commission_type integer NOT NULL,
    code character varying(10),
    libelle character varying(100),
    lieu_adresse_ligne1 character varying(150),
    lieu_adresse_ligne2 character varying(100),
    lieu_salle character varying(100),
    listes_de_diffusion text,
    participants text,
    corps_du_courriel text,
    om_validite_debut date,
    om_validite_fin date,
    om_collectivite integer NOT NULL
);


--
-- Name: TABLE commission_type; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON TABLE commission_type IS 'Les types de commission';


--
-- Name: COLUMN commission_type.commission_type; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN commission_type.commission_type IS 'Identifiant unique';


--
-- Name: COLUMN commission_type.code; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN commission_type.code IS 'Code du type de commission';


--
-- Name: COLUMN commission_type.libelle; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN commission_type.libelle IS 'Libellé du type de commission';


--
-- Name: COLUMN commission_type.lieu_adresse_ligne1; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN commission_type.lieu_adresse_ligne1 IS 'Adresse des commissions de ce type';


--
-- Name: COLUMN commission_type.lieu_adresse_ligne2; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN commission_type.lieu_adresse_ligne2 IS 'Complément d''adresse des commissions de ce type';


--
-- Name: COLUMN commission_type.lieu_salle; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN commission_type.lieu_salle IS 'Salle où ont lieu les commissions de ce type';


--
-- Name: COLUMN commission_type.listes_de_diffusion; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN commission_type.listes_de_diffusion IS 'Liste de diffusion des commissions de ce type';


--
-- Name: COLUMN commission_type.participants; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN commission_type.participants IS 'Participants aux commissions de ce type';


--
-- Name: COLUMN commission_type.corps_du_courriel; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN commission_type.corps_du_courriel IS 'Corps du courriel diffusé à la liste de diffusion des commissions de ce type';


--
-- Name: COLUMN commission_type.om_validite_debut; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN commission_type.om_validite_debut IS 'Date de début de validité de ce type de commission';


--
-- Name: COLUMN commission_type.om_validite_fin; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN commission_type.om_validite_fin IS 'Date de fin de validité de ce type de commission';


--
-- Name: COLUMN commission_type.om_collectivite; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN commission_type.om_collectivite IS 'Lien vers la collectivité concernée';


--
-- Name: commission_type_seq; Type: SEQUENCE; Schema: openads; Owner: -
--

CREATE SEQUENCE commission_type_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- Name: commission_type_seq; Type: SEQUENCE OWNED BY; Schema: openads; Owner: -
--

ALTER SEQUENCE commission_type_seq OWNED BY commission_type.commission_type;


--
-- Name: commune; Type: TABLE; Schema: openads; Owner: -
--

CREATE TABLE commune (
    commune integer NOT NULL,
    typecom character varying(4),
    com character varying(5) NOT NULL,
    reg character varying(2) NOT NULL,
    dep character varying(3) NOT NULL,
    arr character varying(4),
    tncc character varying(1),
    ncc character varying(200),
    nccenr character varying(200),
    libelle character varying(45),
    can character varying(5),
    comparent character varying(5),
    om_validite_debut date,
    om_validite_fin date
);


--
-- Name: COLUMN commune.commune; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN commune.commune IS 'Identifiant technique de la commune';


--
-- Name: COLUMN commune.typecom; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN commune.typecom IS 'Type de commune';


--
-- Name: COLUMN commune.com; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN commune.com IS 'Code INSEE de la commune';


--
-- Name: COLUMN commune.reg; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN commune.reg IS 'Code INSEE de la région';


--
-- Name: COLUMN commune.dep; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN commune.dep IS 'Code INSEE du département';


--
-- Name: COLUMN commune.arr; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN commune.arr IS 'Code d’arrondissement sur 3 caractères (métropole) ou 4';


--
-- Name: COLUMN commune.tncc; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN commune.tncc IS 'Type de nom en clair';


--
-- Name: COLUMN commune.ncc; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN commune.ncc IS 'Nom en clair (majuscules)';


--
-- Name: COLUMN commune.nccenr; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN commune.nccenr IS 'Nom en typographie riche';


--
-- Name: COLUMN commune.libelle; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN commune.libelle IS 'Nom en typographie riche avec article';


--
-- Name: COLUMN commune.can; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN commune.can IS 'Code canton. Pour les communes « multi-cantonales » code décliné de 99 à 90 (pseudo-canton) ou de 89 à 80 (communes nouvelles)';


--
-- Name: COLUMN commune.comparent; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN commune.comparent IS 'Code de la commune parente pour les arrondissements municipaux et les communes associées ou déléguées.';


--
-- Name: COLUMN commune.om_validite_debut; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN commune.om_validite_debut IS 'Date de validité (début)';


--
-- Name: COLUMN commune.om_validite_fin; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN commune.om_validite_fin IS 'Date de validité (fin)';


--
-- Name: commune_seq; Type: SEQUENCE; Schema: openads; Owner: -
--

CREATE SEQUENCE commune_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- Name: commune_seq; Type: SEQUENCE OWNED BY; Schema: openads; Owner: -
--

ALTER SEQUENCE commune_seq OWNED BY commune.commune;


--
-- Name: consultation; Type: TABLE; Schema: openads; Owner: -
--

CREATE TABLE consultation (
    consultation integer NOT NULL,
    dossier character varying(30) NOT NULL,
    date_envoi date NOT NULL,
    date_retour date,
    date_limite date,
    service integer NOT NULL,
    avis_consultation integer,
    date_reception date,
    motivation text DEFAULT ''::text,
    fichier character varying(255),
    lu boolean,
    code_barres character varying(12),
    om_fichier_consultation character varying(255),
    om_final_consultation boolean,
    marque boolean DEFAULT false,
    visible boolean DEFAULT true NOT NULL,
    om_fichier_consultation_dossier_final boolean DEFAULT false,
    fichier_dossier_final boolean DEFAULT false,
    texte_fondement_avis text,
    texte_avis text,
    texte_hypotheses text,
    nom_auteur character varying(255),
    prenom_auteur character varying(255),
    qualite_auteur character varying(255)
);


--
-- Name: TABLE consultation; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON TABLE consultation IS 'Demande de consultation d''un dossier d''instruction à un service';


--
-- Name: COLUMN consultation.consultation; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN consultation.consultation IS 'Identifiant unique';


--
-- Name: COLUMN consultation.dossier; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN consultation.dossier IS 'Dossier d''instruction sur lequel il y a la demande de consultation';


--
-- Name: COLUMN consultation.date_envoi; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN consultation.date_envoi IS 'Date d''envoi de la consultation';


--
-- Name: COLUMN consultation.date_retour; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN consultation.date_retour IS 'Date de retour de la consultation';


--
-- Name: COLUMN consultation.date_limite; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN consultation.date_limite IS 'Date limite pour la consultation';


--
-- Name: COLUMN consultation.service; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN consultation.service IS 'Service demandé pour la consultation';


--
-- Name: COLUMN consultation.avis_consultation; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN consultation.avis_consultation IS 'Avis de la consultation';


--
-- Name: COLUMN consultation.date_reception; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN consultation.date_reception IS 'Date de réception de la consultation';


--
-- Name: COLUMN consultation.motivation; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN consultation.motivation IS 'Motivation du service pour l''avis rendu sur la consultation';


--
-- Name: COLUMN consultation.fichier; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN consultation.fichier IS 'Document joint à la réponse de consultation';


--
-- Name: COLUMN consultation.lu; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN consultation.lu IS 'Indique que la demande de consultation a été lue';


--
-- Name: COLUMN consultation.code_barres; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN consultation.code_barres IS 'Code barres de la consultation';


--
-- Name: COLUMN consultation.om_fichier_consultation; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN consultation.om_fichier_consultation IS 'Document résumé de la consultation';


--
-- Name: COLUMN consultation.om_final_consultation; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN consultation.om_final_consultation IS 'Document résumé de la consultation finalisée';


--
-- Name: COLUMN consultation.visible; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN consultation.visible IS 'Si vrai, la consultation apparaît dans les éditions faisant appel au sous-état Liste des consultations par dossier.';


--
-- Name: COLUMN consultation.om_fichier_consultation_dossier_final; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN consultation.om_fichier_consultation_dossier_final IS 'Identifie que le document généré constitue dossier final';


--
-- Name: COLUMN consultation.fichier_dossier_final; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN consultation.fichier_dossier_final IS 'Identifie que le document en pièce jointe constitue dossier final';


--
-- Name: COLUMN consultation.texte_fondement_avis; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN consultation.texte_fondement_avis IS 'Texte indiquant le(s) article(s) réglementaire(s) sur le(s)quel(s) se fonde l''avis';


--
-- Name: COLUMN consultation.texte_avis; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN consultation.texte_avis IS 'Texte qui permet de préciser l''avis, à la manière du texte figurant aujourd''hui sur les avis papier. C''est un moyen de ne pas avoir à annexer de document indiquant ces éléments lorsqu''il n''y a pas besoin de les mettre en forme';


--
-- Name: COLUMN consultation.texte_hypotheses; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN consultation.texte_hypotheses IS 'Texte descriptif des hypothèses sur lesquelles l''avis est rendu lorsque le dossier ne contient pas d''éléments suffisants';


--
-- Name: COLUMN consultation.nom_auteur; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN consultation.nom_auteur IS 'Nom de l''auteur de l''avis';


--
-- Name: COLUMN consultation.prenom_auteur; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN consultation.prenom_auteur IS 'Prénom de l''auteur de l''avis';


--
-- Name: COLUMN consultation.qualite_auteur; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN consultation.qualite_auteur IS 'Qualité de l''auteur de l''avis';


--
-- Name: consultation_entrante; Type: TABLE; Schema: openads; Owner: -
--

CREATE TABLE consultation_entrante (
    consultation_entrante integer NOT NULL,
    delai_reponse character varying(255),
    date_consultation date,
    date_emission date,
    service_consultant_id character varying(255),
    service_consultant_libelle character varying(255),
    service_consultant_insee character varying(255),
    service_consultant_mail character varying(255),
    service_consultant_type character varying(255),
    service_consultant__siren character varying(255),
    etat_consultation character varying(255),
    type_consultation character varying(255),
    texte_fondement_reglementaire text,
    texte_objet_consultation text,
    dossier character varying(255),
    type_delai character varying(255),
    objet_consultation character varying(255),
    date_production_notification date,
    date_premiere_consultation date
);


--
-- Name: TABLE consultation_entrante; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON TABLE consultation_entrante IS 'Consultation entrante';


--
-- Name: COLUMN consultation_entrante.consultation_entrante; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN consultation_entrante.consultation_entrante IS 'Identifiant technique de la consultation entrante';


--
-- Name: COLUMN consultation_entrante.delai_reponse; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN consultation_entrante.delai_reponse IS 'Délais de la réponse autorisée';


--
-- Name: COLUMN consultation_entrante.date_consultation; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN consultation_entrante.date_consultation IS 'Date à laquelle la consultation entrante a été décidée';


--
-- Name: COLUMN consultation_entrante.date_emission; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN consultation_entrante.date_emission IS 'Date à laquelle la consultation entrante a été transmise au service consultable';


--
-- Name: COLUMN consultation_entrante.service_consultant_id; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN consultation_entrante.service_consultant_id IS 'Identifiant du service consultant';


--
-- Name: COLUMN consultation_entrante.service_consultant_libelle; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN consultation_entrante.service_consultant_libelle IS 'Libellé du service consultant';


--
-- Name: COLUMN consultation_entrante.service_consultant_insee; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN consultation_entrante.service_consultant_insee IS 'Code INSEE du service consultant';


--
-- Name: COLUMN consultation_entrante.service_consultant_mail; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN consultation_entrante.service_consultant_mail IS 'Adresse mail du service consultant';


--
-- Name: COLUMN consultation_entrante.service_consultant_type; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN consultation_entrante.service_consultant_type IS 'Type du service consultant';


--
-- Name: COLUMN consultation_entrante.service_consultant__siren; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN consultation_entrante.service_consultant__siren IS 'Code SIREN du service consultant';


--
-- Name: COLUMN consultation_entrante.etat_consultation; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN consultation_entrante.etat_consultation IS 'État de la consultation entrante';


--
-- Name: COLUMN consultation_entrante.type_consultation; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN consultation_entrante.type_consultation IS 'Type de la consultation entrante';


--
-- Name: COLUMN consultation_entrante.texte_fondement_reglementaire; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN consultation_entrante.texte_fondement_reglementaire IS 'Texte indiquant le(s) article(s) réglémen-taire(s) sur le(s)quel(s) se fonde la consultation entrante';


--
-- Name: COLUMN consultation_entrante.texte_objet_consultation; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN consultation_entrante.texte_objet_consultation IS 'Texte descriptif de la consultation entrante';


--
-- Name: COLUMN consultation_entrante.dossier; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN consultation_entrante.dossier IS 'Numéro du dossier d''instruction portant la consultation entrante';


--
-- Name: COLUMN consultation_entrante.type_delai; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN consultation_entrante.type_delai IS 'Type de délai pour la réponse (jour/mois)';


--
-- Name: COLUMN consultation_entrante.objet_consultation; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN consultation_entrante.objet_consultation IS 'Identifiant Plat''AU de l''objet de la consultation entrante';


--
-- Name: COLUMN consultation_entrante.date_production_notification; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN consultation_entrante.date_production_notification IS 'Date à laquelle la notification de la consultation entrante a été produite';


--
-- Name: COLUMN consultation_entrante.date_premiere_consultation; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN consultation_entrante.date_premiere_consultation IS 'Date à laquelle la consultation entrainte a été consultée pour la première fois';


--
-- Name: consultation_entrante_seq; Type: SEQUENCE; Schema: openads; Owner: -
--

CREATE SEQUENCE consultation_entrante_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- Name: consultation_entrante_seq; Type: SEQUENCE OWNED BY; Schema: openads; Owner: -
--

ALTER SEQUENCE consultation_entrante_seq OWNED BY consultation_entrante.consultation_entrante;


--
-- Name: consultation_seq; Type: SEQUENCE; Schema: openads; Owner: -
--

CREATE SEQUENCE consultation_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- Name: consultation_seq; Type: SEQUENCE OWNED BY; Schema: openads; Owner: -
--

ALTER SEQUENCE consultation_seq OWNED BY consultation.consultation;


--
-- Name: contrainte; Type: TABLE; Schema: openads; Owner: -
--

CREATE TABLE contrainte (
    contrainte integer NOT NULL,
    numero character varying(250),
    nature character varying(10) NOT NULL,
    groupe character varying(250),
    sousgroupe character varying(250),
    libelle character varying(250) NOT NULL,
    texte text,
    no_ordre integer,
    reference boolean DEFAULT false,
    service_consulte boolean DEFAULT false,
    om_validite_debut date,
    om_validite_fin date,
    om_collectivite integer NOT NULL
);


--
-- Name: TABLE contrainte; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON TABLE contrainte IS 'Table de référence des contraintes';


--
-- Name: COLUMN contrainte.contrainte; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN contrainte.contrainte IS 'Identifiant unique';


--
-- Name: COLUMN contrainte.numero; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN contrainte.numero IS 'Numéro unique de contrainte, issu du SIG';


--
-- Name: COLUMN contrainte.nature; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN contrainte.nature IS 'Nature de la contrainte POS ou PLU';


--
-- Name: COLUMN contrainte.groupe; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN contrainte.groupe IS 'Groupe de la contrainte';


--
-- Name: COLUMN contrainte.sousgroupe; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN contrainte.sousgroupe IS 'Sous-groupe de la contrainte';


--
-- Name: COLUMN contrainte.libelle; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN contrainte.libelle IS 'Libellé de la contrainte';


--
-- Name: COLUMN contrainte.texte; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN contrainte.texte IS 'Texte de la contrainte';


--
-- Name: COLUMN contrainte.no_ordre; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN contrainte.no_ordre IS 'Numéro d''ordre d''affichage ou d''impression';


--
-- Name: COLUMN contrainte.reference; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN contrainte.reference IS 'Contrainte récupérée depuis le SIG';


--
-- Name: COLUMN contrainte.service_consulte; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN contrainte.service_consulte IS 'Contrainte affichée aux services consultés';


--
-- Name: COLUMN contrainte.om_validite_debut; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN contrainte.om_validite_debut IS 'Date de début de validité';


--
-- Name: COLUMN contrainte.om_validite_fin; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN contrainte.om_validite_fin IS 'Date de fin de validité';


--
-- Name: COLUMN contrainte.om_collectivite; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN contrainte.om_collectivite IS 'lien vers la collectivité concernée';


--
-- Name: contrainte_seq; Type: SEQUENCE; Schema: openads; Owner: -
--

CREATE SEQUENCE contrainte_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- Name: contrainte_seq; Type: SEQUENCE OWNED BY; Schema: openads; Owner: -
--

ALTER SEQUENCE contrainte_seq OWNED BY contrainte.contrainte;


--
-- Name: demande; Type: TABLE; Schema: openads; Owner: -
--

CREATE TABLE demande (
    demande integer NOT NULL,
    dossier_autorisation_type_detaille integer NOT NULL,
    demande_type integer NOT NULL,
    dossier_instruction character varying(255),
    dossier_autorisation character varying(255),
    date_demande date NOT NULL,
    terrain_references_cadastrales text,
    terrain_adresse_voie_numero character varying(20),
    terrain_adresse_voie character varying(30),
    terrain_adresse_lieu_dit character varying(30),
    terrain_adresse_localite character varying(30),
    terrain_adresse_code_postal character varying(5),
    terrain_adresse_bp character varying(15),
    terrain_adresse_cedex character varying(15),
    terrain_superficie double precision,
    instruction_recepisse integer,
    arrondissement integer,
    om_collectivite integer NOT NULL,
    autorisation_contestee character varying(30),
    depot_electronique boolean DEFAULT false NOT NULL,
    parcelle_temporaire boolean DEFAULT false NOT NULL,
    commune integer,
    source_depot character varying(255)
);


--
-- Name: TABLE demande; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON TABLE demande IS 'Demande saisie par le guichet unique';


--
-- Name: COLUMN demande.demande; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN demande.demande IS 'Identifiant unique';


--
-- Name: COLUMN demande.dossier_autorisation_type_detaille; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN demande.dossier_autorisation_type_detaille IS 'Type détaillé du dossier d''autorisation (PCI, AZ, AT, ...) à sa création';


--
-- Name: COLUMN demande.demande_type; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN demande.demande_type IS 'Type de la demande, influe sur le type du dossier d''instruction (initial, modificatif, transfert, ...) à sa création';


--
-- Name: COLUMN demande.dossier_instruction; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN demande.dossier_instruction IS 'Dossier d''instruction de la demande';


--
-- Name: COLUMN demande.dossier_autorisation; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN demande.dossier_autorisation IS 'Dossier d''autorisation de la demande';


--
-- Name: COLUMN demande.date_demande; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN demande.date_demande IS 'Date de la demande';


--
-- Name: COLUMN demande.terrain_references_cadastrales; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN demande.terrain_references_cadastrales IS 'Références cadastrales de l''adresse du terrain';


--
-- Name: COLUMN demande.terrain_adresse_voie_numero; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN demande.terrain_adresse_voie_numero IS 'Numéro de la voie de l''adresse du terrain';


--
-- Name: COLUMN demande.terrain_adresse_voie; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN demande.terrain_adresse_voie IS 'Nom de la voie de l''adresse du terrain';


--
-- Name: COLUMN demande.terrain_adresse_lieu_dit; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN demande.terrain_adresse_lieu_dit IS 'Lieu dit de l''adresse du terrain';


--
-- Name: COLUMN demande.terrain_adresse_localite; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN demande.terrain_adresse_localite IS 'Ville de l''adresse du terrain';


--
-- Name: COLUMN demande.terrain_adresse_code_postal; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN demande.terrain_adresse_code_postal IS 'Code postal de l''adresse du terrain';


--
-- Name: COLUMN demande.terrain_adresse_bp; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN demande.terrain_adresse_bp IS 'Boîte postale de l''adresse du terrain';


--
-- Name: COLUMN demande.terrain_adresse_cedex; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN demande.terrain_adresse_cedex IS 'Cedex de l''adresse du terrain';


--
-- Name: COLUMN demande.terrain_superficie; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN demande.terrain_superficie IS 'Superficie du terrain';


--
-- Name: COLUMN demande.instruction_recepisse; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN demande.instruction_recepisse IS 'Récipissé de l''instruction lors de la création de la demande';


--
-- Name: COLUMN demande.arrondissement; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN demande.arrondissement IS 'Arrondissement du terrain de la demande';


--
-- Name: COLUMN demande.om_collectivite; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN demande.om_collectivite IS 'lien vers la collectivité concernée';


--
-- Name: COLUMN demande.autorisation_contestee; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN demande.autorisation_contestee IS 'Le numéro de l''autorisation contestée (DI)';


--
-- Name: COLUMN demande.depot_electronique; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN demande.depot_electronique IS 'Identifie le dépôt électronique de la demande';


--
-- Name: COLUMN demande.parcelle_temporaire; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN demande.parcelle_temporaire IS 'Existence d''au moins une parcelle temporaire sur la demande';


--
-- Name: COLUMN demande.commune; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN demande.commune IS 'Commune associée à la demande';


--
-- Name: COLUMN demande.source_depot; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN demande.source_depot IS 'Permet d''indiquer la source de dépot, ce champ peut prendre en valeur : platau, app et portal';


--
-- Name: demande_nature; Type: TABLE; Schema: openads; Owner: -
--

CREATE TABLE demande_nature (
    demande_nature integer NOT NULL,
    code character varying(20),
    libelle character varying(100),
    description text
);


--
-- Name: TABLE demande_nature; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON TABLE demande_nature IS 'Nature de la demande';


--
-- Name: COLUMN demande_nature.demande_nature; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN demande_nature.demande_nature IS 'Identifiant unique';


--
-- Name: COLUMN demande_nature.code; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN demande_nature.code IS 'Code de la nature de la demande';


--
-- Name: COLUMN demande_nature.libelle; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN demande_nature.libelle IS 'Libellé de la nature de la demande';


--
-- Name: COLUMN demande_nature.description; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN demande_nature.description IS 'Description de la nature de la demande';


--
-- Name: demande_nature_seq; Type: SEQUENCE; Schema: openads; Owner: -
--

CREATE SEQUENCE demande_nature_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- Name: demande_nature_seq; Type: SEQUENCE OWNED BY; Schema: openads; Owner: -
--

ALTER SEQUENCE demande_nature_seq OWNED BY demande_nature.demande_nature;


--
-- Name: demande_seq; Type: SEQUENCE; Schema: openads; Owner: -
--

CREATE SEQUENCE demande_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- Name: demande_seq; Type: SEQUENCE OWNED BY; Schema: openads; Owner: -
--

ALTER SEQUENCE demande_seq OWNED BY demande.demande;


--
-- Name: demande_type; Type: TABLE; Schema: openads; Owner: -
--

CREATE TABLE demande_type (
    demande_type integer NOT NULL,
    code character varying(20) NOT NULL,
    libelle character varying(100) NOT NULL,
    description text,
    demande_nature integer NOT NULL,
    groupe integer NOT NULL,
    dossier_instruction_type integer,
    dossier_autorisation_type_detaille integer,
    contraintes character varying(20),
    qualification boolean,
    evenement integer NOT NULL,
    document_obligatoire text,
    regeneration_cle_citoyen boolean DEFAULT false
);


--
-- Name: TABLE demande_type; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON TABLE demande_type IS 'Type de la demande';


--
-- Name: COLUMN demande_type.demande_type; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN demande_type.demande_type IS 'Identifiant unique';


--
-- Name: COLUMN demande_type.code; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN demande_type.code IS 'Code du type de la demande';


--
-- Name: COLUMN demande_type.libelle; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN demande_type.libelle IS 'Libellé du type de la demande';


--
-- Name: COLUMN demande_type.description; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN demande_type.description IS 'Description du type de la demande';


--
-- Name: COLUMN demande_type.demande_nature; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN demande_type.demande_nature IS 'Nature de la demande';


--
-- Name: COLUMN demande_type.groupe; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN demande_type.groupe IS 'Groupe du type de la demande. Permet de filtrer les choix du champ dossier_autorisation_type_detaille';


--
-- Name: COLUMN demande_type.dossier_instruction_type; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN demande_type.dossier_instruction_type IS 'Type du dossier d''instruction créé par la demande';


--
-- Name: COLUMN demande_type.dossier_autorisation_type_detaille; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN demande_type.dossier_autorisation_type_detaille IS 'Type détaillé du dossier d''autorisation crée par la demande. Permet de filtrer les choix du champ dossier_instruction_type';


--
-- Name: COLUMN demande_type.contraintes; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN demande_type.contraintes IS 'Permet de définir si les informations des demandeurs du dossier d''instruction précédent doivent être récupérées';


--
-- Name: COLUMN demande_type.qualification; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN demande_type.qualification IS 'Le dossier d''instruction crée doit être à qualifier';


--
-- Name: COLUMN demande_type.evenement; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN demande_type.evenement IS 'Événement à instancier lors de la création de la demande';


--
-- Name: COLUMN demande_type.regeneration_cle_citoyen; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN demande_type.regeneration_cle_citoyen IS 'La clé d''accès au portail citoyen du dossier d''autorisation doit être regénérée lors de la création du dossier d''instruction';


--
-- Name: demande_type_seq; Type: SEQUENCE; Schema: openads; Owner: -
--

CREATE SEQUENCE demande_type_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- Name: demande_type_seq; Type: SEQUENCE OWNED BY; Schema: openads; Owner: -
--

ALTER SEQUENCE demande_type_seq OWNED BY demande_type.demande_type;


--
-- Name: demandeur; Type: TABLE; Schema: openads; Owner: -
--

CREATE TABLE demandeur (
    demandeur integer NOT NULL,
    type_demandeur character varying(40),
    qualite character varying(40),
    particulier_nom character varying(100),
    particulier_prenom character varying(50),
    particulier_date_naissance date,
    particulier_commune_naissance character varying(30),
    particulier_departement_naissance character varying(80),
    personne_morale_denomination character varying(40),
    personne_morale_raison_sociale character varying(50),
    personne_morale_siret character varying(15),
    personne_morale_categorie_juridique character varying(15),
    personne_morale_nom character varying(50),
    personne_morale_prenom character varying(50),
    numero character varying(10),
    voie character varying(55),
    complement character varying(50),
    lieu_dit character varying(39),
    localite character varying(250),
    code_postal character varying(5),
    bp character varying(5),
    cedex character varying(5),
    pays character varying(40),
    division_territoriale character varying(40),
    telephone_fixe character varying(20),
    telephone_mobile character varying(20),
    indicatif character varying(5),
    courriel character varying(60),
    notification boolean,
    frequent boolean,
    particulier_civilite integer,
    personne_morale_civilite integer,
    fax character varying(20),
    om_collectivite integer NOT NULL,
    particulier_pays_naissance character varying(250),
    num_inscription character varying(20),
    nom_cabinet character varying(100),
    conseil_regional character varying(100)
);


--
-- Name: TABLE demandeur; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON TABLE demandeur IS 'Pétitionnaire et délégataire de chaque dossier d''instruction';


--
-- Name: COLUMN demandeur.demandeur; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN demandeur.demandeur IS 'Identifiant unique';


--
-- Name: COLUMN demandeur.type_demandeur; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN demandeur.type_demandeur IS 'Type de demandeur : avocat / contrevenant / delegataire / petitionnaire / plaignant / requerant / bailleur';


--
-- Name: COLUMN demandeur.qualite; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN demandeur.qualite IS 'Qualité du demandeur : particulier ou personne morale';


--
-- Name: COLUMN demandeur.particulier_nom; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN demandeur.particulier_nom IS 'Nom du demandeur de qualité particulier';


--
-- Name: COLUMN demandeur.particulier_prenom; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN demandeur.particulier_prenom IS 'Prénom du demandeur de qualité particulier';


--
-- Name: COLUMN demandeur.particulier_date_naissance; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN demandeur.particulier_date_naissance IS 'Date de naissance du demandeur de qualité particulier';


--
-- Name: COLUMN demandeur.particulier_commune_naissance; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN demandeur.particulier_commune_naissance IS 'Commune de naissance du demandeur de qualité particulier';


--
-- Name: COLUMN demandeur.particulier_departement_naissance; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN demandeur.particulier_departement_naissance IS 'Département de naissance du demandeur de qualité particulier';


--
-- Name: COLUMN demandeur.personne_morale_denomination; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN demandeur.personne_morale_denomination IS 'Dénomination du demandeur de qualité personne marole';


--
-- Name: COLUMN demandeur.personne_morale_raison_sociale; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN demandeur.personne_morale_raison_sociale IS 'Raison sociale du demandeur de qualité personne morale';


--
-- Name: COLUMN demandeur.personne_morale_siret; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN demandeur.personne_morale_siret IS 'SIRET du demandeur de qualité personne morale';


--
-- Name: COLUMN demandeur.personne_morale_categorie_juridique; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN demandeur.personne_morale_categorie_juridique IS 'Catégorie juridique du demandeur de qualité personne morale';


--
-- Name: COLUMN demandeur.personne_morale_nom; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN demandeur.personne_morale_nom IS 'Nom du demandeur de qualité personne morale';


--
-- Name: COLUMN demandeur.personne_morale_prenom; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN demandeur.personne_morale_prenom IS 'Prénom du demandeur de qualité personne morale';


--
-- Name: COLUMN demandeur.numero; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN demandeur.numero IS 'Numéro de voie de l''adresse du demandeur';


--
-- Name: COLUMN demandeur.voie; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN demandeur.voie IS 'Voie de l''adresse du demandeur';


--
-- Name: COLUMN demandeur.complement; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN demandeur.complement IS 'Complément d''adresse du demandeur';


--
-- Name: COLUMN demandeur.lieu_dit; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN demandeur.lieu_dit IS 'Lieu-dit de l''adresse du demandeur';


--
-- Name: COLUMN demandeur.localite; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN demandeur.localite IS 'Localité de l''adresse du demandeur';


--
-- Name: COLUMN demandeur.code_postal; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN demandeur.code_postal IS 'Code postal de l''adresse du demandeur';


--
-- Name: COLUMN demandeur.bp; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN demandeur.bp IS 'Boîte postale de l''adresse du demandeur';


--
-- Name: COLUMN demandeur.cedex; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN demandeur.cedex IS 'Cedex de l''adresse du demandeur';


--
-- Name: COLUMN demandeur.pays; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN demandeur.pays IS 'Pays de résidence du demandeur';


--
-- Name: COLUMN demandeur.division_territoriale; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN demandeur.division_territoriale IS 'Division territoriale de résidence du demandeur';


--
-- Name: COLUMN demandeur.telephone_fixe; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN demandeur.telephone_fixe IS 'Numéro de téléphone fixe du demandeur';


--
-- Name: COLUMN demandeur.telephone_mobile; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN demandeur.telephone_mobile IS 'Numéro de téléphone mobile du demandeur';


--
-- Name: COLUMN demandeur.indicatif; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN demandeur.indicatif IS 'Indicatif du pays de résidence du demandeur';


--
-- Name: COLUMN demandeur.courriel; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN demandeur.courriel IS 'Adresse mail du demandeur';


--
-- Name: COLUMN demandeur.notification; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN demandeur.notification IS 'Notification par mail du demandeur';


--
-- Name: COLUMN demandeur.frequent; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN demandeur.frequent IS 'Demandeur fréquent';


--
-- Name: COLUMN demandeur.particulier_civilite; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN demandeur.particulier_civilite IS 'Civilité du demandeur de qualité particulier';


--
-- Name: COLUMN demandeur.personne_morale_civilite; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN demandeur.personne_morale_civilite IS 'Civilité du demandeur de qualité personne morale';


--
-- Name: COLUMN demandeur.fax; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN demandeur.fax IS 'Numéro de fax du demandeur';


--
-- Name: COLUMN demandeur.om_collectivite; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN demandeur.om_collectivite IS 'Lien vers la collectivité concernée.';


--
-- Name: COLUMN demandeur.particulier_pays_naissance; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN demandeur.particulier_pays_naissance IS 'Pays de naissance du demandeur de qualité ''particulier''';


--
-- Name: COLUMN demandeur.num_inscription; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN demandeur.num_inscription IS 'Numéro d''inscription au conseil national de l''ordre des architectes';


--
-- Name: COLUMN demandeur.nom_cabinet; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN demandeur.nom_cabinet IS 'Nom du cabinet dans lequel travail l''architecte';


--
-- Name: COLUMN demandeur.conseil_regional; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN demandeur.conseil_regional IS 'Conseil régional de l''architecte';


--
-- Name: demandeur_seq; Type: SEQUENCE; Schema: openads; Owner: -
--

CREATE SEQUENCE demandeur_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- Name: demandeur_seq; Type: SEQUENCE OWNED BY; Schema: openads; Owner: -
--

ALTER SEQUENCE demandeur_seq OWNED BY demandeur.demandeur;


--
-- Name: departement; Type: TABLE; Schema: openads; Owner: -
--

CREATE TABLE departement (
    departement integer NOT NULL,
    dep character varying(3) NOT NULL,
    reg character varying(2) NOT NULL,
    cheflieu character varying(5) NOT NULL,
    tncc character varying(1),
    ncc character varying(200),
    nccenr character varying(200),
    libelle character varying(45),
    om_validite_debut date NOT NULL,
    om_validite_fin date
);


--
-- Name: COLUMN departement.departement; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN departement.departement IS 'Identifiant technique de la departement';


--
-- Name: COLUMN departement.dep; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN departement.dep IS 'Code INSEE du département';


--
-- Name: COLUMN departement.reg; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN departement.reg IS 'Code INSEE de la région';


--
-- Name: COLUMN departement.cheflieu; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN departement.cheflieu IS 'Code INSEE du chef lieu';


--
-- Name: COLUMN departement.tncc; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN departement.tncc IS 'Type de nom en clair';


--
-- Name: COLUMN departement.ncc; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN departement.ncc IS 'Nom en clair (majuscules)';


--
-- Name: COLUMN departement.nccenr; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN departement.nccenr IS 'Nom en typographie riche';


--
-- Name: COLUMN departement.libelle; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN departement.libelle IS 'Nom en typographie riche avec article';


--
-- Name: COLUMN departement.om_validite_debut; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN departement.om_validite_debut IS 'Date de validité (début)';


--
-- Name: COLUMN departement.om_validite_fin; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN departement.om_validite_fin IS 'Date de validité (fin)';


--
-- Name: departement_seq; Type: SEQUENCE; Schema: openads; Owner: -
--

CREATE SEQUENCE departement_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- Name: departement_seq; Type: SEQUENCE OWNED BY; Schema: openads; Owner: -
--

ALTER SEQUENCE departement_seq OWNED BY departement.departement;


--
-- Name: direction; Type: TABLE; Schema: openads; Owner: -
--

CREATE TABLE direction (
    direction integer NOT NULL,
    code character varying(20) NOT NULL,
    libelle character varying(100) NOT NULL,
    description text,
    chef character varying(100) NOT NULL,
    om_validite_debut date,
    om_validite_fin date,
    om_collectivite integer NOT NULL
);


--
-- Name: TABLE direction; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON TABLE direction IS 'Direction des divisions, nécessaire aussi pour obtenir le nom du responsable de service dans certains documents';


--
-- Name: COLUMN direction.direction; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN direction.direction IS 'Identifiant unique';


--
-- Name: COLUMN direction.code; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN direction.code IS 'Code de la direction';


--
-- Name: COLUMN direction.libelle; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN direction.libelle IS 'Libellé de la direction';


--
-- Name: COLUMN direction.description; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN direction.description IS 'Description de la direction';


--
-- Name: COLUMN direction.chef; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN direction.chef IS 'Nom et prénom du chef de la direction';


--
-- Name: COLUMN direction.om_validite_debut; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN direction.om_validite_debut IS 'Date de début de validité de la direction';


--
-- Name: COLUMN direction.om_validite_fin; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN direction.om_validite_fin IS 'Date de fin de validité de la direction';


--
-- Name: COLUMN direction.om_collectivite; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN direction.om_collectivite IS 'Lien vers la collectivité concernée.';


--
-- Name: direction_seq; Type: SEQUENCE; Schema: openads; Owner: -
--

CREATE SEQUENCE direction_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- Name: direction_seq; Type: SEQUENCE OWNED BY; Schema: openads; Owner: -
--

ALTER SEQUENCE direction_seq OWNED BY direction.direction;


--
-- Name: division; Type: TABLE; Schema: openads; Owner: -
--

CREATE TABLE division (
    division integer NOT NULL,
    code character varying(20) NOT NULL,
    libelle character varying(100) NOT NULL,
    description text,
    chef character varying(100) NOT NULL,
    direction integer NOT NULL,
    om_validite_debut date,
    om_validite_fin date
);


--
-- Name: TABLE division; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON TABLE division IS 'Division regroupant les instructeurs';


--
-- Name: COLUMN division.division; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN division.division IS 'Identifiant unique';


--
-- Name: COLUMN division.code; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN division.code IS 'Code de la division';


--
-- Name: COLUMN division.libelle; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN division.libelle IS 'Libellé de la division';


--
-- Name: COLUMN division.description; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN division.description IS 'Description de la division';


--
-- Name: COLUMN division.chef; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN division.chef IS 'Nom et prénom du chef de la division';


--
-- Name: COLUMN division.direction; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN division.direction IS 'Direction à laquelle est rattachée la division';


--
-- Name: COLUMN division.om_validite_debut; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN division.om_validite_debut IS 'Date de début de validité de la division';


--
-- Name: COLUMN division.om_validite_fin; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN division.om_validite_fin IS 'Date de fin de validité de la division';


--
-- Name: division_seq; Type: SEQUENCE; Schema: openads; Owner: -
--

CREATE SEQUENCE division_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- Name: division_seq; Type: SEQUENCE OWNED BY; Schema: openads; Owner: -
--

ALTER SEQUENCE division_seq OWNED BY division.division;


--
-- Name: document_numerise; Type: TABLE; Schema: openads; Owner: -
--

CREATE TABLE document_numerise (
    document_numerise integer NOT NULL,
    uid character varying(255) NOT NULL,
    dossier character varying(255) NOT NULL,
    nom_fichier character varying(255) NOT NULL,
    date_creation date NOT NULL,
    document_numerise_type integer NOT NULL,
    uid_dossier_final boolean DEFAULT false,
    document_numerise_nature integer,
    uid_thumbnail character varying(255),
    description_type character varying(2000),
    document_travail boolean DEFAULT false NOT NULL
);


--
-- Name: TABLE document_numerise; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON TABLE document_numerise IS 'Document numérisé rattaché à un dossier d''instruction';


--
-- Name: COLUMN document_numerise.document_numerise; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN document_numerise.document_numerise IS 'Identifiant unique';


--
-- Name: COLUMN document_numerise.uid; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN document_numerise.uid IS 'Identifiant unique du fichier, compose aussi son chemin';


--
-- Name: COLUMN document_numerise.dossier; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN document_numerise.dossier IS 'Dossier d''instruction auquel est rattaché le document';


--
-- Name: COLUMN document_numerise.nom_fichier; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN document_numerise.nom_fichier IS 'Nom du document';


--
-- Name: COLUMN document_numerise.date_creation; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN document_numerise.date_creation IS 'Date de création du document';


--
-- Name: COLUMN document_numerise.document_numerise_type; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN document_numerise.document_numerise_type IS 'Type du document';


--
-- Name: COLUMN document_numerise.uid_dossier_final; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN document_numerise.uid_dossier_final IS 'Identifie que le document constitue dossier final';


--
-- Name: COLUMN document_numerise.document_numerise_nature; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN document_numerise.document_numerise_nature IS 'Nature du document';


--
-- Name: COLUMN document_numerise.uid_thumbnail; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN document_numerise.uid_thumbnail IS 'Identifiant unique de la miniature du fichier';


--
-- Name: COLUMN document_numerise.description_type; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN document_numerise.description_type IS 'Description du type de pièce destiné aux pièces "Autre à préciser"';


--
-- Name: COLUMN document_numerise.document_travail; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN document_numerise.document_travail IS 'Indique si le document est un document de travail';


--
-- Name: document_numerise_nature; Type: TABLE; Schema: openads; Owner: -
--

CREATE TABLE document_numerise_nature (
    document_numerise_nature integer NOT NULL,
    code character varying(10) NOT NULL,
    libelle character varying(255) NOT NULL,
    description text,
    om_validite_debut date,
    om_validite_fin date
);


--
-- Name: TABLE document_numerise_nature; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON TABLE document_numerise_nature IS 'Nature de document numérisé';


--
-- Name: COLUMN document_numerise_nature.document_numerise_nature; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN document_numerise_nature.document_numerise_nature IS 'Identifiant numérique unique de la nature de document numérisé';


--
-- Name: COLUMN document_numerise_nature.code; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN document_numerise_nature.code IS 'Code aplhanumérique unique de la nature de document numérisé';


--
-- Name: COLUMN document_numerise_nature.libelle; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN document_numerise_nature.libelle IS 'Libellé de la nature de document numérisé';


--
-- Name: COLUMN document_numerise_nature.description; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN document_numerise_nature.description IS 'Description de la nature de document numérisé';


--
-- Name: COLUMN document_numerise_nature.om_validite_debut; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN document_numerise_nature.om_validite_debut IS 'Date de début de validité de la nature de document numérisé';


--
-- Name: COLUMN document_numerise_nature.om_validite_fin; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN document_numerise_nature.om_validite_fin IS 'Date de fin de validité de la nature de document numérisé';


--
-- Name: document_numerise_nature_seq; Type: SEQUENCE; Schema: openads; Owner: -
--

CREATE SEQUENCE document_numerise_nature_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- Name: document_numerise_nature_seq; Type: SEQUENCE OWNED BY; Schema: openads; Owner: -
--

ALTER SEQUENCE document_numerise_nature_seq OWNED BY document_numerise_nature.document_numerise_nature;


--
-- Name: document_numerise_seq; Type: SEQUENCE; Schema: openads; Owner: -
--

CREATE SEQUENCE document_numerise_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- Name: document_numerise_seq; Type: SEQUENCE OWNED BY; Schema: openads; Owner: -
--

ALTER SEQUENCE document_numerise_seq OWNED BY document_numerise.document_numerise;


--
-- Name: document_numerise_type; Type: TABLE; Schema: openads; Owner: -
--

CREATE TABLE document_numerise_type (
    document_numerise_type integer NOT NULL,
    code character varying(50) NOT NULL,
    libelle character varying(2000) NOT NULL,
    document_numerise_type_categorie integer NOT NULL,
    aff_service_consulte boolean DEFAULT true NOT NULL,
    aff_da boolean DEFAULT true NOT NULL,
    synchro_metadonnee boolean DEFAULT false NOT NULL,
    description text,
    om_validite_debut date,
    om_validite_fin date
);


--
-- Name: TABLE document_numerise_type; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON TABLE document_numerise_type IS 'Type de document numérisé';


--
-- Name: COLUMN document_numerise_type.document_numerise_type; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN document_numerise_type.document_numerise_type IS 'Identifiant unique';


--
-- Name: COLUMN document_numerise_type.code; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN document_numerise_type.code IS 'Code du type de document numérisé';


--
-- Name: COLUMN document_numerise_type.libelle; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN document_numerise_type.libelle IS 'Libellé du type de document numérisé';


--
-- Name: COLUMN document_numerise_type.document_numerise_type_categorie; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN document_numerise_type.document_numerise_type_categorie IS 'Catégorie du type de document numérisé';


--
-- Name: COLUMN document_numerise_type.aff_service_consulte; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN document_numerise_type.aff_service_consulte IS 'Définit si les pièces de ce type sont affichées sur les demandes d''avis.';


--
-- Name: COLUMN document_numerise_type.aff_da; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN document_numerise_type.aff_da IS 'Définit si les pièces de ce type sont affichées sur les dossiers d''autorisation.';


--
-- Name: COLUMN document_numerise_type.synchro_metadonnee; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN document_numerise_type.synchro_metadonnee IS 'Définit si les champs ''aff_da'' et/ou ''aff_service_consulte'' de ce type ont été modifiés (t) ou non (f). Utilisé lors du traitement des métadonnées.';


--
-- Name: COLUMN document_numerise_type.description; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN document_numerise_type.description IS 'Description';


--
-- Name: COLUMN document_numerise_type.om_validite_debut; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN document_numerise_type.om_validite_debut IS 'Date de début de validité';


--
-- Name: COLUMN document_numerise_type.om_validite_fin; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN document_numerise_type.om_validite_fin IS 'Date de fin de validité';


--
-- Name: document_numerise_type_categorie; Type: TABLE; Schema: openads; Owner: -
--

CREATE TABLE document_numerise_type_categorie (
    document_numerise_type_categorie integer NOT NULL,
    libelle character varying(255) NOT NULL,
    code character varying(50)
);


--
-- Name: TABLE document_numerise_type_categorie; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON TABLE document_numerise_type_categorie IS 'Catégorie du type de document numérisé';


--
-- Name: COLUMN document_numerise_type_categorie.document_numerise_type_categorie; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN document_numerise_type_categorie.document_numerise_type_categorie IS 'Identifiant unique';


--
-- Name: COLUMN document_numerise_type_categorie.libelle; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN document_numerise_type_categorie.libelle IS 'Libellé de la catégorie du type de document numérisé';


--
-- Name: COLUMN document_numerise_type_categorie.code; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN document_numerise_type_categorie.code IS 'Code de la catégorie de document numérisé';


--
-- Name: document_numerise_type_categorie_seq; Type: SEQUENCE; Schema: openads; Owner: -
--

CREATE SEQUENCE document_numerise_type_categorie_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- Name: document_numerise_type_categorie_seq; Type: SEQUENCE OWNED BY; Schema: openads; Owner: -
--

ALTER SEQUENCE document_numerise_type_categorie_seq OWNED BY document_numerise_type_categorie.document_numerise_type_categorie;


--
-- Name: document_numerise_type_seq; Type: SEQUENCE; Schema: openads; Owner: -
--

CREATE SEQUENCE document_numerise_type_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- Name: document_numerise_type_seq; Type: SEQUENCE OWNED BY; Schema: openads; Owner: -
--

ALTER SEQUENCE document_numerise_type_seq OWNED BY document_numerise_type.document_numerise_type;


--
-- Name: donnees_techniques; Type: TABLE; Schema: openads; Owner: -
--

CREATE TABLE donnees_techniques (
    donnees_techniques integer NOT NULL,
    dossier_instruction character varying(255),
    lot integer,
    am_lotiss boolean,
    am_autre_div boolean,
    am_camping boolean,
    am_caravane boolean,
    am_carav_duree integer,
    am_statio boolean,
    am_statio_cont integer,
    am_affou_exhau boolean,
    am_affou_exhau_sup numeric,
    am_affou_prof numeric,
    am_exhau_haut numeric,
    am_coupe_abat boolean,
    am_prot_plu boolean,
    am_prot_muni boolean,
    am_mobil_voyage boolean,
    am_aire_voyage boolean,
    am_rememb_afu boolean,
    am_parc_resid_loi boolean,
    am_sport_moto boolean,
    am_sport_attrac boolean,
    am_sport_golf boolean,
    am_mob_art boolean,
    am_modif_voie_esp boolean,
    am_plant_voie_esp boolean,
    am_chem_ouv_esp boolean,
    am_agri_peche boolean,
    am_crea_voie boolean,
    am_modif_voie_exist boolean,
    am_crea_esp_sauv boolean,
    am_crea_esp_class boolean,
    am_projet_desc text,
    am_terr_surf numeric,
    am_tranche_desc text,
    am_lot_max_nb integer,
    am_lot_max_shon numeric,
    am_lot_cstr_cos boolean,
    am_lot_cstr_plan boolean,
    am_lot_cstr_vente boolean,
    am_lot_fin_diff boolean,
    am_lot_consign boolean,
    am_lot_gar_achev boolean,
    am_lot_vente_ant boolean,
    am_empl_nb integer,
    am_tente_nb integer,
    am_carav_nb integer,
    am_mobil_nb integer,
    am_pers_nb integer,
    am_empl_hll_nb integer,
    am_hll_shon numeric,
    am_periode_exploit text,
    am_exist_agrand boolean,
    am_exist_date character varying(100),
    am_exist_num character varying(100),
    am_exist_nb_avant integer,
    am_exist_nb_apres integer,
    am_coupe_bois boolean,
    am_coupe_parc boolean,
    am_coupe_align boolean,
    am_coupe_ess character varying(100),
    am_coupe_age character varying(15),
    am_coupe_dens character varying(100),
    am_coupe_qual character varying(100),
    am_coupe_trait character varying(100),
    am_coupe_autr character varying(100),
    co_archi_recours boolean,
    co_cstr_nouv boolean,
    co_cstr_exist boolean,
    co_cloture boolean,
    co_elec_tension numeric,
    co_div_terr boolean,
    co_projet_desc text,
    co_anx_pisc boolean,
    co_anx_gara boolean,
    co_anx_veran boolean,
    co_anx_abri boolean,
    co_anx_autr boolean,
    co_anx_autr_desc text,
    co_tot_log_nb integer,
    co_tot_ind_nb integer,
    co_tot_coll_nb integer,
    co_mais_piece_nb integer,
    co_mais_niv_nb integer,
    co_fin_lls_nb integer,
    co_fin_aa_nb integer,
    co_fin_ptz_nb integer,
    co_fin_autr_nb integer,
    co_fin_autr_desc text,
    co_mais_contrat_ind boolean,
    co_uti_pers boolean,
    co_uti_vente boolean,
    co_uti_loc boolean,
    co_uti_princ boolean,
    co_uti_secon boolean,
    co_resid_agees boolean,
    co_resid_etud boolean,
    co_resid_tourism boolean,
    co_resid_hot_soc boolean,
    co_resid_soc boolean,
    co_resid_hand boolean,
    co_resid_autr boolean,
    co_resid_autr_desc text,
    co_foyer_chamb_nb integer,
    co_log_1p_nb integer,
    co_log_2p_nb integer,
    co_log_3p_nb integer,
    co_log_4p_nb integer,
    co_log_5p_nb integer,
    co_log_6p_nb integer,
    co_bat_niv_nb integer,
    co_trx_exten boolean,
    co_trx_surelev boolean,
    co_trx_nivsup boolean,
    co_demont_periode text,
    co_sp_transport boolean,
    co_sp_enseign boolean,
    co_sp_act_soc boolean,
    co_sp_ouvr_spe boolean,
    co_sp_sante boolean,
    co_sp_culture boolean,
    co_statio_avt_nb integer,
    co_statio_apr_nb integer,
    co_statio_adr text,
    co_statio_place_nb integer,
    co_statio_tot_surf numeric,
    co_statio_tot_shob numeric,
    co_statio_comm_cin_surf numeric,
    su_avt_shon1 numeric,
    su_avt_shon2 numeric,
    su_avt_shon3 numeric,
    su_avt_shon4 numeric,
    su_avt_shon5 numeric,
    su_avt_shon6 numeric,
    su_avt_shon7 numeric,
    su_avt_shon8 numeric,
    su_avt_shon9 numeric,
    su_cstr_shon1 numeric,
    su_cstr_shon2 numeric,
    su_cstr_shon3 numeric,
    su_cstr_shon4 numeric,
    su_cstr_shon5 numeric,
    su_cstr_shon6 numeric,
    su_cstr_shon7 numeric,
    su_cstr_shon8 numeric,
    su_cstr_shon9 numeric,
    su_trsf_shon1 numeric,
    su_trsf_shon2 numeric,
    su_trsf_shon3 numeric,
    su_trsf_shon4 numeric,
    su_trsf_shon5 numeric,
    su_trsf_shon6 numeric,
    su_trsf_shon7 numeric,
    su_trsf_shon8 numeric,
    su_trsf_shon9 numeric,
    su_chge_shon1 numeric,
    su_chge_shon2 numeric,
    su_chge_shon3 numeric,
    su_chge_shon4 numeric,
    su_chge_shon5 numeric,
    su_chge_shon6 numeric,
    su_chge_shon7 numeric,
    su_chge_shon8 numeric,
    su_chge_shon9 numeric,
    su_demo_shon1 numeric,
    su_demo_shon2 numeric,
    su_demo_shon3 numeric,
    su_demo_shon4 numeric,
    su_demo_shon5 numeric,
    su_demo_shon6 numeric,
    su_demo_shon7 numeric,
    su_demo_shon8 numeric,
    su_demo_shon9 numeric,
    su_sup_shon1 numeric,
    su_sup_shon2 numeric,
    su_sup_shon3 numeric,
    su_sup_shon4 numeric,
    su_sup_shon5 numeric,
    su_sup_shon6 numeric,
    su_sup_shon7 numeric,
    su_sup_shon8 numeric,
    su_sup_shon9 numeric,
    su_tot_shon1 numeric,
    su_tot_shon2 numeric,
    su_tot_shon3 numeric,
    su_tot_shon4 numeric,
    su_tot_shon5 numeric,
    su_tot_shon6 numeric,
    su_tot_shon7 numeric,
    su_tot_shon8 numeric,
    su_tot_shon9 numeric,
    su_avt_shon_tot numeric,
    su_cstr_shon_tot numeric,
    su_trsf_shon_tot numeric,
    su_chge_shon_tot numeric,
    su_demo_shon_tot numeric,
    su_sup_shon_tot numeric,
    su_tot_shon_tot numeric,
    dm_constr_dates text,
    dm_total boolean,
    dm_partiel boolean,
    dm_projet_desc text,
    dm_tot_log_nb integer,
    tax_surf_tot numeric,
    tax_surf numeric,
    tax_surf_suppr_mod numeric,
    tax_su_princ_log_nb1 numeric,
    tax_su_princ_log_nb2 numeric,
    tax_su_princ_log_nb3 numeric,
    tax_su_princ_log_nb4 numeric,
    tax_su_princ_log_nb_tot1 numeric,
    tax_su_princ_log_nb_tot2 numeric,
    tax_su_princ_log_nb_tot3 numeric,
    tax_su_princ_log_nb_tot4 numeric,
    tax_su_princ_surf1 numeric,
    tax_su_princ_surf2 numeric,
    tax_su_princ_surf3 numeric,
    tax_su_princ_surf4 numeric,
    tax_su_princ_surf_sup1 numeric,
    tax_su_princ_surf_sup2 numeric,
    tax_su_princ_surf_sup3 numeric,
    tax_su_princ_surf_sup4 numeric,
    tax_su_heber_log_nb1 integer,
    tax_su_heber_log_nb2 integer,
    tax_su_heber_log_nb3 integer,
    tax_su_heber_log_nb_tot1 integer,
    tax_su_heber_log_nb_tot2 integer,
    tax_su_heber_log_nb_tot3 integer,
    tax_su_heber_surf1 numeric,
    tax_su_heber_surf2 numeric,
    tax_su_heber_surf3 numeric,
    tax_su_heber_surf_sup1 numeric,
    tax_su_heber_surf_sup2 numeric,
    tax_su_heber_surf_sup3 numeric,
    tax_su_secon_log_nb integer,
    tax_su_tot_log_nb integer,
    tax_su_secon_log_nb_tot integer,
    tax_su_tot_log_nb_tot integer,
    tax_su_secon_surf numeric,
    tax_su_tot_surf numeric,
    tax_su_secon_surf_sup numeric,
    tax_su_tot_surf_sup numeric,
    tax_ext_pret boolean,
    tax_ext_desc text,
    tax_surf_tax_exist_cons numeric,
    tax_log_exist_nb integer,
    tax_am_statio_ext integer,
    tax_sup_bass_pisc numeric,
    tax_empl_ten_carav_mobil_nb integer,
    tax_empl_hll_nb integer,
    tax_eol_haut_nb integer,
    tax_pann_volt_sup numeric,
    tax_am_statio_ext_sup integer,
    tax_sup_bass_pisc_sup numeric,
    tax_empl_ten_carav_mobil_nb_sup integer,
    tax_empl_hll_nb_sup integer,
    tax_eol_haut_nb_sup integer,
    tax_pann_volt_sup_sup numeric,
    tax_trx_presc_ppr boolean,
    tax_monu_hist boolean,
    tax_comm_nb integer,
    tax_su_non_habit_surf1 numeric,
    tax_su_non_habit_surf2 numeric,
    tax_su_non_habit_surf3 numeric,
    tax_su_non_habit_surf4 numeric,
    tax_su_non_habit_surf5 numeric,
    tax_su_non_habit_surf6 numeric,
    tax_su_non_habit_surf7 numeric,
    tax_su_non_habit_surf_sup1 numeric,
    tax_su_non_habit_surf_sup2 numeric,
    tax_su_non_habit_surf_sup3 numeric,
    tax_su_non_habit_surf_sup4 numeric,
    tax_su_non_habit_surf_sup5 numeric,
    tax_su_non_habit_surf_sup6 numeric,
    tax_su_non_habit_surf_sup7 numeric,
    vsd_surf_planch_smd boolean,
    vsd_unit_fonc_sup numeric,
    vsd_unit_fonc_constr_sup numeric,
    vsd_val_terr numeric,
    vsd_const_sxist_non_dem_surf numeric,
    vsd_rescr_fisc date,
    pld_val_terr numeric,
    pld_const_exist_dem boolean,
    pld_const_exist_dem_surf numeric,
    code_cnil boolean,
    terr_juri_titul character varying(20),
    terr_juri_lot character varying(20),
    terr_juri_zac character varying(20),
    terr_juri_afu character varying(20),
    terr_juri_pup character varying(20),
    terr_juri_oin character varying(20),
    terr_juri_desc text,
    terr_div_surf_etab numeric,
    terr_div_surf_av_div numeric,
    doc_date date,
    doc_tot_trav boolean,
    doc_tranche_trav boolean,
    doc_tranche_trav_desc text,
    doc_surf numeric,
    doc_nb_log integer,
    doc_nb_log_indiv integer,
    doc_nb_log_coll integer,
    doc_nb_log_lls integer,
    doc_nb_log_aa integer,
    doc_nb_log_ptz integer,
    doc_nb_log_autre integer,
    daact_date date,
    daact_date_chgmt_dest date,
    daact_tot_trav boolean,
    daact_tranche_trav boolean,
    daact_tranche_trav_desc text,
    daact_surf numeric,
    daact_nb_log integer,
    daact_nb_log_indiv integer,
    daact_nb_log_coll integer,
    daact_nb_log_lls integer,
    daact_nb_log_aa integer,
    daact_nb_log_ptz integer,
    daact_nb_log_autre integer,
    dossier_autorisation character varying(255),
    am_div_mun boolean,
    co_perf_energ character varying(40),
    architecte integer,
    co_statio_avt_shob character varying(250),
    co_statio_apr_shob character varying(250),
    co_statio_avt_surf character varying(250),
    co_statio_apr_surf character varying(250),
    co_trx_amgt character varying(250),
    co_modif_aspect character varying(250),
    co_modif_struct character varying(250),
    co_ouvr_elec boolean,
    co_ouvr_infra boolean,
    co_trx_imm character varying(250),
    co_cstr_shob character varying(250),
    am_voyage_deb character varying(250),
    am_voyage_fin character varying(250),
    am_modif_amgt character varying(250),
    am_lot_max_shob character varying(250),
    mod_desc character varying(250),
    tr_total character varying(250),
    tr_partiel character varying(250),
    tr_desc character varying(250),
    avap_co_elt_pro boolean,
    avap_nouv_haut_surf boolean,
    avap_co_clot character varying(250),
    avap_aut_coup_aba_arb character varying(250),
    avap_ouv_infra character varying(250),
    avap_aut_inst_mob character varying(250),
    avap_aut_plant character varying(250),
    avap_aut_auv_elec character varying(250),
    tax_dest_loc_tr character varying(250),
    ope_proj_desc text,
    tax_surf_tot_cstr integer,
    cerfa integer NOT NULL,
    tax_surf_loc_stat integer,
    tax_su_princ_surf_stat1 numeric,
    tax_su_princ_surf_stat2 numeric,
    tax_su_princ_surf_stat3 numeric,
    tax_su_princ_surf_stat4 numeric,
    tax_su_secon_surf_stat numeric,
    tax_su_heber_surf_stat1 numeric,
    tax_su_heber_surf_stat2 numeric,
    tax_su_heber_surf_stat3 numeric,
    tax_su_tot_surf_stat numeric,
    tax_su_non_habit_surf_stat1 numeric,
    tax_su_non_habit_surf_stat2 numeric,
    tax_su_non_habit_surf_stat3 numeric,
    tax_su_non_habit_surf_stat4 numeric,
    tax_su_non_habit_surf_stat5 numeric,
    tax_su_non_habit_surf_stat6 numeric,
    tax_su_non_habit_surf_stat7 numeric,
    tax_su_parc_statio_expl_comm_surf numeric,
    tax_log_ap_trvx_nb integer,
    tax_am_statio_ext_cr integer,
    tax_sup_bass_pisc_cr numeric,
    tax_empl_ten_carav_mobil_nb_cr integer,
    tax_empl_hll_nb_cr integer,
    tax_eol_haut_nb_cr integer,
    tax_pann_volt_sup_cr numeric,
    tax_surf_loc_arch numeric,
    tax_surf_pisc_arch numeric,
    tax_am_statio_ext_arch numeric,
    tax_empl_ten_carav_mobil_nb_arch numeric,
    tax_empl_hll_nb_arch numeric,
    tax_eol_haut_nb_arch integer,
    ope_proj_div_co boolean DEFAULT false,
    ope_proj_div_contr boolean DEFAULT false,
    tax_desc text,
    erp_cstr_neuve boolean DEFAULT false,
    erp_trvx_acc boolean DEFAULT false,
    erp_extension boolean DEFAULT false,
    erp_rehab boolean DEFAULT false,
    erp_trvx_am boolean DEFAULT false,
    erp_vol_nouv_exist boolean DEFAULT false,
    erp_loc_eff1 numeric,
    erp_loc_eff2 numeric,
    erp_loc_eff3 numeric,
    erp_loc_eff4 numeric,
    erp_loc_eff5 numeric,
    erp_loc_eff_tot numeric,
    erp_public_eff1 numeric,
    erp_public_eff2 numeric,
    erp_public_eff3 numeric,
    erp_public_eff4 numeric,
    erp_public_eff5 numeric,
    erp_public_eff_tot numeric,
    erp_perso_eff1 numeric,
    erp_perso_eff2 numeric,
    erp_perso_eff3 numeric,
    erp_perso_eff4 numeric,
    erp_perso_eff5 numeric,
    erp_perso_eff_tot numeric,
    erp_tot_eff1 numeric,
    erp_tot_eff2 numeric,
    erp_tot_eff3 numeric,
    erp_tot_eff4 numeric,
    erp_tot_eff5 numeric,
    erp_tot_eff_tot numeric,
    erp_class_cat integer,
    erp_class_type integer,
    tax_surf_abr_jard_pig_colom numeric,
    tax_su_non_habit_abr_jard_pig_colom numeric,
    dia_imm_non_bati boolean DEFAULT false,
    dia_imm_bati_terr_propr boolean DEFAULT false,
    dia_imm_bati_terr_autr boolean DEFAULT false,
    dia_imm_bati_terr_autr_desc text,
    dia_bat_copro boolean DEFAULT false,
    dia_bat_copro_desc text,
    dia_lot_numero text,
    dia_lot_bat text,
    dia_lot_etage text,
    dia_lot_quote_part text,
    dia_us_hab boolean DEFAULT false,
    dia_us_pro boolean DEFAULT false,
    dia_us_mixte boolean DEFAULT false,
    dia_us_comm boolean DEFAULT false,
    dia_us_agr boolean DEFAULT false,
    dia_us_autre boolean DEFAULT false,
    dia_us_autre_prec text,
    dia_occ_prop boolean DEFAULT false,
    dia_occ_loc boolean DEFAULT false,
    dia_occ_sans_occ boolean DEFAULT false,
    dia_occ_autre boolean DEFAULT false,
    dia_occ_autre_prec text,
    dia_mod_cess_prix_vente character varying(250),
    dia_mod_cess_prix_vente_mob character varying(250),
    dia_mod_cess_prix_vente_cheptel character varying(250),
    dia_mod_cess_prix_vente_recol character varying(250),
    dia_mod_cess_prix_vente_autre character varying(250),
    dia_mod_cess_commi boolean DEFAULT false,
    dia_mod_cess_commi_ttc character varying(250),
    dia_mod_cess_commi_ht character varying(250),
    dia_acquereur_nom_prenom character varying(150),
    dia_acquereur_adr_num_voie character varying(10),
    dia_acquereur_adr_ext character varying(55),
    dia_acquereur_adr_type_voie character varying(20),
    dia_acquereur_adr_nom_voie character varying(55),
    dia_acquereur_adr_lieu_dit_bp character varying(39),
    dia_acquereur_adr_cp character varying(5),
    dia_acquereur_adr_localite character varying(250),
    dia_observation text,
    su2_avt_shon1 numeric,
    su2_avt_shon2 numeric,
    su2_avt_shon3 numeric,
    su2_avt_shon4 numeric,
    su2_avt_shon5 numeric,
    su2_avt_shon6 numeric,
    su2_avt_shon7 numeric,
    su2_avt_shon8 numeric,
    su2_avt_shon9 numeric,
    su2_avt_shon10 numeric,
    su2_avt_shon11 numeric,
    su2_avt_shon12 numeric,
    su2_avt_shon13 numeric,
    su2_avt_shon14 numeric,
    su2_avt_shon15 numeric,
    su2_avt_shon16 numeric,
    su2_avt_shon17 numeric,
    su2_avt_shon18 numeric,
    su2_avt_shon19 numeric,
    su2_avt_shon20 numeric,
    su2_avt_shon_tot numeric,
    su2_cstr_shon1 numeric,
    su2_cstr_shon2 numeric,
    su2_cstr_shon3 numeric,
    su2_cstr_shon4 numeric,
    su2_cstr_shon5 numeric,
    su2_cstr_shon6 numeric,
    su2_cstr_shon7 numeric,
    su2_cstr_shon8 numeric,
    su2_cstr_shon9 numeric,
    su2_cstr_shon10 numeric,
    su2_cstr_shon11 numeric,
    su2_cstr_shon12 numeric,
    su2_cstr_shon13 numeric,
    su2_cstr_shon14 numeric,
    su2_cstr_shon15 numeric,
    su2_cstr_shon16 numeric,
    su2_cstr_shon17 numeric,
    su2_cstr_shon18 numeric,
    su2_cstr_shon19 numeric,
    su2_cstr_shon20 numeric,
    su2_cstr_shon_tot numeric,
    su2_chge_shon1 numeric,
    su2_chge_shon2 numeric,
    su2_chge_shon3 numeric,
    su2_chge_shon4 numeric,
    su2_chge_shon5 numeric,
    su2_chge_shon6 numeric,
    su2_chge_shon7 numeric,
    su2_chge_shon8 numeric,
    su2_chge_shon9 numeric,
    su2_chge_shon10 numeric,
    su2_chge_shon11 numeric,
    su2_chge_shon12 numeric,
    su2_chge_shon13 numeric,
    su2_chge_shon14 numeric,
    su2_chge_shon15 numeric,
    su2_chge_shon16 numeric,
    su2_chge_shon17 numeric,
    su2_chge_shon18 numeric,
    su2_chge_shon19 numeric,
    su2_chge_shon20 numeric,
    su2_chge_shon_tot numeric,
    su2_demo_shon1 numeric,
    su2_demo_shon2 numeric,
    su2_demo_shon3 numeric,
    su2_demo_shon4 numeric,
    su2_demo_shon5 numeric,
    su2_demo_shon6 numeric,
    su2_demo_shon7 numeric,
    su2_demo_shon8 numeric,
    su2_demo_shon9 numeric,
    su2_demo_shon10 numeric,
    su2_demo_shon11 numeric,
    su2_demo_shon12 numeric,
    su2_demo_shon13 numeric,
    su2_demo_shon14 numeric,
    su2_demo_shon15 numeric,
    su2_demo_shon16 numeric,
    su2_demo_shon17 numeric,
    su2_demo_shon18 numeric,
    su2_demo_shon19 numeric,
    su2_demo_shon20 numeric,
    su2_demo_shon_tot numeric,
    su2_sup_shon1 numeric,
    su2_sup_shon2 numeric,
    su2_sup_shon3 numeric,
    su2_sup_shon4 numeric,
    su2_sup_shon5 numeric,
    su2_sup_shon6 numeric,
    su2_sup_shon7 numeric,
    su2_sup_shon8 numeric,
    su2_sup_shon9 numeric,
    su2_sup_shon10 numeric,
    su2_sup_shon11 numeric,
    su2_sup_shon12 numeric,
    su2_sup_shon13 numeric,
    su2_sup_shon14 numeric,
    su2_sup_shon15 numeric,
    su2_sup_shon16 numeric,
    su2_sup_shon17 numeric,
    su2_sup_shon18 numeric,
    su2_sup_shon19 numeric,
    su2_sup_shon20 numeric,
    su2_sup_shon_tot numeric,
    su2_tot_shon1 numeric,
    su2_tot_shon2 numeric,
    su2_tot_shon3 numeric,
    su2_tot_shon4 numeric,
    su2_tot_shon5 numeric,
    su2_tot_shon6 numeric,
    su2_tot_shon7 numeric,
    su2_tot_shon8 numeric,
    su2_tot_shon9 numeric,
    su2_tot_shon10 numeric,
    su2_tot_shon11 numeric,
    su2_tot_shon12 numeric,
    su2_tot_shon13 numeric,
    su2_tot_shon14 numeric,
    su2_tot_shon15 numeric,
    su2_tot_shon16 numeric,
    su2_tot_shon17 numeric,
    su2_tot_shon18 numeric,
    su2_tot_shon19 numeric,
    su2_tot_shon20 numeric,
    su2_tot_shon_tot numeric,
    dia_occ_sol_su_terre text,
    dia_occ_sol_su_pres text,
    dia_occ_sol_su_verger text,
    dia_occ_sol_su_vigne text,
    dia_occ_sol_su_bois text,
    dia_occ_sol_su_lande text,
    dia_occ_sol_su_carriere text,
    dia_occ_sol_su_eau_cadastree text,
    dia_occ_sol_su_jardin text,
    dia_occ_sol_su_terr_batir text,
    dia_occ_sol_su_terr_agr text,
    dia_occ_sol_su_sol text,
    dia_bati_vend_tot boolean DEFAULT false,
    dia_bati_vend_tot_txt text,
    dia_su_co_sol text,
    dia_su_util_hab text,
    dia_nb_niv text,
    dia_nb_appart text,
    dia_nb_autre_loc text,
    dia_vente_lot_volume boolean DEFAULT false,
    dia_vente_lot_volume_txt text,
    dia_lot_nat_su text,
    dia_lot_bat_achv_plus_10 boolean DEFAULT false,
    dia_lot_bat_achv_moins_10 boolean DEFAULT false,
    dia_lot_regl_copro_publ_hypo_plus_10 boolean DEFAULT false,
    dia_lot_regl_copro_publ_hypo_moins_10 boolean DEFAULT false,
    dia_indivi_quote_part text,
    dia_design_societe text,
    dia_design_droit text,
    dia_droit_soc_nat text,
    dia_droit_soc_nb text,
    dia_droit_soc_num_part text,
    dia_droit_reel_perso_grevant_bien_oui boolean DEFAULT false,
    dia_droit_reel_perso_grevant_bien_non boolean DEFAULT false,
    dia_droit_reel_perso_nat text,
    dia_droit_reel_perso_viag text,
    dia_mod_cess_adr text,
    dia_mod_cess_sign_act_auth boolean DEFAULT false,
    dia_mod_cess_terme boolean DEFAULT false,
    dia_mod_cess_terme_prec text,
    dia_mod_cess_bene_acquereur boolean DEFAULT false,
    dia_mod_cess_bene_vendeur boolean DEFAULT false,
    dia_mod_cess_paie_nat boolean DEFAULT false,
    dia_mod_cess_design_contr_alien text,
    dia_mod_cess_eval_contr text,
    dia_mod_cess_rente_viag boolean DEFAULT false,
    dia_mod_cess_mnt_an text,
    dia_mod_cess_mnt_compt text,
    dia_mod_cess_bene_rente text,
    dia_mod_cess_droit_usa_hab boolean DEFAULT false,
    dia_mod_cess_droit_usa_hab_prec text,
    dia_mod_cess_eval_usa_usufruit text,
    dia_mod_cess_vente_nue_prop boolean DEFAULT false,
    dia_mod_cess_vente_nue_prop_prec text,
    dia_mod_cess_echange boolean DEFAULT false,
    dia_mod_cess_design_bien_recus_ech text,
    dia_mod_cess_mnt_soulte text,
    dia_mod_cess_prop_contre_echan text,
    dia_mod_cess_apport_societe text,
    dia_mod_cess_bene text,
    dia_mod_cess_esti_bien text,
    dia_mod_cess_cess_terr_loc_co boolean DEFAULT false,
    dia_mod_cess_esti_terr text,
    dia_mod_cess_esti_loc text,
    dia_mod_cess_esti_imm_loca boolean DEFAULT false,
    dia_mod_cess_adju_vol boolean DEFAULT false,
    dia_mod_cess_adju_obl boolean DEFAULT false,
    dia_mod_cess_adju_fin_indivi boolean DEFAULT false,
    dia_mod_cess_adju_date_lieu text,
    dia_mod_cess_mnt_mise_prix text,
    dia_prop_titu_prix_indique boolean DEFAULT false,
    dia_prop_recherche_acqu_prix_indique boolean DEFAULT false,
    dia_acquereur_prof text,
    dia_indic_compl_ope text,
    dia_vente_adju boolean DEFAULT false,
    am_terr_res_demon boolean DEFAULT false,
    am_air_terr_res_mob boolean DEFAULT false,
    ctx_objet_recours integer,
    ctx_reference_sagace character varying(255),
    ctx_nature_travaux_infra_om_html text,
    ctx_synthese_nti text,
    ctx_article_non_resp_om_html text,
    ctx_synthese_anr text,
    ctx_reference_parquet character varying(255),
    ctx_element_taxation character varying(255),
    ctx_infraction boolean,
    ctx_regularisable boolean,
    ctx_reference_courrier character varying(255),
    ctx_date_audience date,
    ctx_date_ajournement date,
    exo_facul_1 boolean DEFAULT false,
    exo_facul_2 boolean DEFAULT false,
    exo_facul_3 boolean DEFAULT false,
    exo_facul_4 boolean DEFAULT false,
    exo_facul_5 boolean DEFAULT false,
    exo_facul_6 boolean DEFAULT false,
    exo_facul_7 boolean DEFAULT false,
    exo_facul_8 boolean DEFAULT false,
    exo_facul_9 boolean DEFAULT false,
    exo_ta_1 boolean DEFAULT false,
    exo_ta_2 boolean DEFAULT false,
    exo_ta_3 boolean DEFAULT false,
    exo_ta_4 boolean DEFAULT false,
    exo_ta_5 boolean DEFAULT false,
    exo_ta_6 boolean DEFAULT false,
    exo_ta_7 boolean DEFAULT false,
    exo_ta_8 boolean DEFAULT false,
    exo_ta_9 boolean DEFAULT false,
    exo_rap_1 boolean DEFAULT false,
    exo_rap_2 boolean DEFAULT false,
    exo_rap_3 boolean DEFAULT false,
    exo_rap_4 boolean DEFAULT false,
    exo_rap_5 boolean DEFAULT false,
    exo_rap_6 boolean DEFAULT false,
    exo_rap_7 boolean DEFAULT false,
    exo_rap_8 boolean DEFAULT false,
    mtn_exo_ta_part_commu numeric,
    mtn_exo_ta_part_depart numeric,
    mtn_exo_ta_part_reg numeric,
    mtn_exo_rap numeric,
    dpc_type character varying(100),
    dpc_desc_actv_ex text,
    dpc_desc_ca text,
    dpc_desc_aut_prec text,
    dpc_desig_comm_arti boolean DEFAULT false,
    dpc_desig_loc_hab boolean DEFAULT false,
    dpc_desig_loc_ann boolean DEFAULT false,
    dpc_desig_loc_ann_prec text,
    dpc_bail_comm_date date,
    dpc_bail_comm_loyer text,
    dpc_actv_acqu text,
    dpc_nb_sala_di text,
    dpc_nb_sala_dd text,
    dpc_nb_sala_tc text,
    dpc_nb_sala_tp text,
    dpc_moda_cess_vente_am boolean DEFAULT false,
    dpc_moda_cess_adj boolean DEFAULT false,
    dpc_moda_cess_prix text,
    dpc_moda_cess_adj_date date,
    dpc_moda_cess_adj_prec text,
    dpc_moda_cess_paie_comp boolean DEFAULT false,
    dpc_moda_cess_paie_terme boolean DEFAULT false,
    dpc_moda_cess_paie_terme_prec text,
    dpc_moda_cess_paie_nat boolean DEFAULT false,
    dpc_moda_cess_paie_nat_desig_alien boolean DEFAULT false,
    dpc_moda_cess_paie_nat_desig_alien_prec text,
    dpc_moda_cess_paie_nat_eval boolean DEFAULT false,
    dpc_moda_cess_paie_nat_eval_prec text,
    dpc_moda_cess_paie_aut boolean DEFAULT false,
    dpc_moda_cess_paie_aut_prec text,
    dpc_ss_signe_demande_acqu boolean DEFAULT false,
    dpc_ss_signe_recher_trouv_acqu boolean DEFAULT false,
    dpc_notif_adr_prop boolean DEFAULT false,
    dpc_notif_adr_manda boolean DEFAULT false,
    dpc_obs text,
    co_peri_site_patri_remar boolean DEFAULT false,
    co_abo_monu_hist boolean DEFAULT false,
    co_inst_ouvr_trav_act_code_envir boolean DEFAULT false,
    co_trav_auto_env boolean DEFAULT false,
    co_derog_esp_prot boolean DEFAULT false,
    ctx_reference_dsj character varying(30),
    co_piscine boolean DEFAULT false,
    co_fin_lls boolean DEFAULT false,
    co_fin_aa boolean DEFAULT false,
    co_fin_ptz boolean DEFAULT false,
    co_fin_autr text,
    dia_ss_date date,
    dia_ss_lieu character varying(255),
    enga_decla_lieu character varying(255),
    enga_decla_date date,
    co_archi_attest_honneur boolean DEFAULT false,
    co_bat_niv_dessous_nb integer,
    co_install_classe boolean DEFAULT false,
    co_derog_innov boolean DEFAULT false,
    co_avis_abf boolean DEFAULT false,
    tax_surf_tot_demo numeric,
    tax_surf_tax_demo numeric,
    tax_su_non_habit_surf8 numeric,
    tax_su_non_habit_surf_stat8 numeric,
    tax_su_non_habit_surf9 numeric,
    tax_su_non_habit_surf_stat9 numeric,
    tax_terrassement_arch boolean DEFAULT false,
    tax_adresse_future_numero character varying(255),
    tax_adresse_future_voie character varying(255),
    tax_adresse_future_lieudit character varying(255),
    tax_adresse_future_localite character varying(255),
    tax_adresse_future_cp character varying(255),
    tax_adresse_future_bp character varying(255),
    tax_adresse_future_cedex character varying(255),
    tax_adresse_future_pays character varying(255),
    tax_adresse_future_division character varying(255),
    co_bat_projete text,
    co_bat_existant text,
    co_bat_nature text,
    terr_juri_titul_date date,
    co_autre_desc text,
    co_trx_autre text,
    co_autre boolean DEFAULT false,
    erp_modif_facades boolean DEFAULT false,
    erp_trvx_adap boolean DEFAULT false,
    erp_trvx_adap_numero character varying(255),
    erp_trvx_adap_valid date,
    erp_prod_dangereux boolean DEFAULT false,
    co_trav_supp_dessus numeric,
    co_trav_supp_dessous numeric,
    tax_su_habit_abr_jard_pig_colom numeric,
    enga_decla_donnees_nomi_comm boolean DEFAULT false
);


--
-- Name: TABLE donnees_techniques; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON TABLE donnees_techniques IS 'Données techniques';


--
-- Name: COLUMN donnees_techniques.donnees_techniques; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN donnees_techniques.donnees_techniques IS 'Identifiant unique';


--
-- Name: COLUMN donnees_techniques.dossier_instruction; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN donnees_techniques.dossier_instruction IS 'Dossier d''instruction auquel sont rattachés les données techniques';


--
-- Name: COLUMN donnees_techniques.lot; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN donnees_techniques.lot IS 'Lot sur lequel sont rattachés les données techniques';


--
-- Name: COLUMN donnees_techniques.am_lotiss; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN donnees_techniques.am_lotiss IS 'Lotissement';


--
-- Name: COLUMN donnees_techniques.am_autre_div; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN donnees_techniques.am_autre_div IS 'Remembrement réalisé par une association foncière urbaine libre';


--
-- Name: COLUMN donnees_techniques.am_camping; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN donnees_techniques.am_camping IS 'Terrain de camping';


--
-- Name: COLUMN donnees_techniques.am_caravane; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN donnees_techniques.am_caravane IS 'Installation d’une caravane en dehors d’un terrain de camping ou d’un parc résidentiel de loisirs';


--
-- Name: COLUMN donnees_techniques.am_carav_duree; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN donnees_techniques.am_carav_duree IS 'Durée annuelle d’installation (en mois)';


--
-- Name: COLUMN donnees_techniques.am_statio; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN donnees_techniques.am_statio IS 'Aires de stationnement ouvertes au public, dépôts de véhicules et garages collectifs de caravanes ou de résidences mobiles de loisirs';


--
-- Name: COLUMN donnees_techniques.am_statio_cont; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN donnees_techniques.am_statio_cont IS 'Contenance de l''aire de stationnement (nombre d’unités)';


--
-- Name: COLUMN donnees_techniques.am_affou_exhau; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN donnees_techniques.am_affou_exhau IS 'Travaux d’affouillements ou d’exhaussements du sol';


--
-- Name: COLUMN donnees_techniques.am_affou_exhau_sup; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN donnees_techniques.am_affou_exhau_sup IS 'Superficie (en m2) des travaux d’affouillements ou d’exhaussements du sol';


--
-- Name: COLUMN donnees_techniques.am_affou_prof; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN donnees_techniques.am_affou_prof IS 'Profondeur pour les travaux affouillements du sol';


--
-- Name: COLUMN donnees_techniques.am_exhau_haut; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN donnees_techniques.am_exhau_haut IS 'Hauteur pour les travaux exhaussements du sol';


--
-- Name: COLUMN donnees_techniques.am_coupe_abat; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN donnees_techniques.am_coupe_abat IS 'Coupe et abattage d’arbres';


--
-- Name: COLUMN donnees_techniques.am_prot_plu; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN donnees_techniques.am_prot_plu IS 'Modification ou suppression d’un élément protégé par un plan local d’urbanisme ou document d’urbanisme en tenant lieu (plan d’occupation des sols, plan de sauvegarde et de mise en valeur, plan d’aménagement de zone)';


--
-- Name: COLUMN donnees_techniques.am_prot_muni; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN donnees_techniques.am_prot_muni IS 'Modification ou suppression d’un élément protégé par une délibération du conseil municipal';


--
-- Name: COLUMN donnees_techniques.am_mobil_voyage; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN donnees_techniques.am_mobil_voyage IS 'Installation d’une résidence mobile constituant l’habitat permanent des gens du voyage pendant plus de trois mois consécutifs';


--
-- Name: COLUMN donnees_techniques.am_aire_voyage; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN donnees_techniques.am_aire_voyage IS 'Aire d’accueil des gens du voyage';


--
-- Name: COLUMN donnees_techniques.am_rememb_afu; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN donnees_techniques.am_rememb_afu IS 'Travaux ayant pour effet de modifier l''aménagement des espaces non bâtis autour d''un bâtiment existant situé dans le périmètre d''un site patrimonial remarquable ou abords d''un monument historique';


--
-- Name: COLUMN donnees_techniques.am_parc_resid_loi; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN donnees_techniques.am_parc_resid_loi IS 'Parc résidentiel de loisirs ou village de vacances';


--
-- Name: COLUMN donnees_techniques.am_sport_moto; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN donnees_techniques.am_sport_moto IS 'Aménagement d’un terrain pour la pratique de sports ou de loisirs motorisés';


--
-- Name: COLUMN donnees_techniques.am_sport_attrac; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN donnees_techniques.am_sport_attrac IS 'Aménagement d’un parc d’attraction ou d’une aire de jeux et de sports';


--
-- Name: COLUMN donnees_techniques.am_sport_golf; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN donnees_techniques.am_sport_golf IS 'Aménagement d’un golf';


--
-- Name: COLUMN donnees_techniques.am_mob_art; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN donnees_techniques.am_mob_art IS 'Installation de mobilier urbain, d’œuvre d’art';


--
-- Name: COLUMN donnees_techniques.am_modif_voie_esp; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN donnees_techniques.am_modif_voie_esp IS 'Modification de voie ou espace publics';


--
-- Name: COLUMN donnees_techniques.am_plant_voie_esp; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN donnees_techniques.am_plant_voie_esp IS 'Plantations effectuées sur les voies ou espaces publics';


--
-- Name: COLUMN donnees_techniques.am_chem_ouv_esp; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN donnees_techniques.am_chem_ouv_esp IS 'Chemin piétonnier ou objet mobilier destiné à l’accueil ou à l’information du public, lorsqu’ils sont nécessaires à la gestion ou à l’ouverture au public de ces espaces ou milieux';


--
-- Name: COLUMN donnees_techniques.am_agri_peche; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN donnees_techniques.am_agri_peche IS 'Aménagement nécessaire à l’exercice des activités agricoles, de pêche et de culture marine ou lacustres, conchylicoles, pastorales et forestières';


--
-- Name: COLUMN donnees_techniques.am_crea_voie; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN donnees_techniques.am_crea_voie IS 'Création d’une voie';


--
-- Name: COLUMN donnees_techniques.am_modif_voie_exist; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN donnees_techniques.am_modif_voie_exist IS 'Travaux ayant pour effet de modifier les caractéristiques d’une voie existante';


--
-- Name: COLUMN donnees_techniques.am_crea_esp_sauv; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN donnees_techniques.am_crea_esp_sauv IS 'Création d’un espace public (secteur sauvegardé)';


--
-- Name: COLUMN donnees_techniques.am_crea_esp_class; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN donnees_techniques.am_crea_esp_class IS 'Création d’un espace public (site classé)';


--
-- Name: COLUMN donnees_techniques.am_projet_desc; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN donnees_techniques.am_projet_desc IS 'Description de votre projet de construction';


--
-- Name: COLUMN donnees_techniques.am_terr_surf; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN donnees_techniques.am_terr_surf IS 'Superficie du (ou des) terrain(s) à aménager (en m²)';


--
-- Name: COLUMN donnees_techniques.am_tranche_desc; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN donnees_techniques.am_tranche_desc IS 'Si les travaux sont réalisés par tranches, en préciser le nombre et leur contenu';


--
-- Name: COLUMN donnees_techniques.am_lot_max_nb; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN donnees_techniques.am_lot_max_nb IS 'Nombre maximum de lots projetés';


--
-- Name: COLUMN donnees_techniques.am_lot_max_shon; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN donnees_techniques.am_lot_max_shon IS 'Surface de plancher maximale envisagée (en m²) des lots';


--
-- Name: COLUMN donnees_techniques.am_lot_cstr_cos; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN donnees_techniques.am_lot_cstr_cos IS 'Par application du coefficient d’occupation du sol (COS) à chaque lot';


--
-- Name: COLUMN donnees_techniques.am_lot_cstr_plan; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN donnees_techniques.am_lot_cstr_plan IS 'Conformément aux plans ou tableaux joints à la présente demande';


--
-- Name: COLUMN donnees_techniques.am_lot_cstr_vente; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN donnees_techniques.am_lot_cstr_vente IS 'La constructibilité sera déterminée à la vente de chaque lot. Dans ce cas, le lotisseur devra fournir un certificat aux constructeurs.';


--
-- Name: COLUMN donnees_techniques.am_lot_fin_diff; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN donnees_techniques.am_lot_fin_diff IS 'Le projet fait l’objet d’une demande de travaux de finition différés';


--
-- Name: COLUMN donnees_techniques.am_lot_consign; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN donnees_techniques.am_lot_consign IS 'Consignation en compte bloqué';


--
-- Name: COLUMN donnees_techniques.am_lot_gar_achev; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN donnees_techniques.am_lot_gar_achev IS 'Garantie financière d’achèvement des travaux';


--
-- Name: COLUMN donnees_techniques.am_lot_vente_ant; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN donnees_techniques.am_lot_vente_ant IS 'Le projet fait l’objet d’une demande de vente ou location de lots par anticipation';


--
-- Name: COLUMN donnees_techniques.am_empl_nb; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN donnees_techniques.am_empl_nb IS 'Nombre maximum d’emplacements réservés aux tentes, caravanes ou résidences mobiles de loisirs';


--
-- Name: COLUMN donnees_techniques.am_tente_nb; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN donnees_techniques.am_tente_nb IS 'Nombre maximum d’emplacements réservés aux tentes';


--
-- Name: COLUMN donnees_techniques.am_carav_nb; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN donnees_techniques.am_carav_nb IS 'Nombre maximum d’emplacements réservés aux caravanes ';


--
-- Name: COLUMN donnees_techniques.am_mobil_nb; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN donnees_techniques.am_mobil_nb IS 'Nombre maximum d’emplacements réservés aux mobiles de loisirs';


--
-- Name: COLUMN donnees_techniques.am_pers_nb; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN donnees_techniques.am_pers_nb IS 'Nombre maximal de personnes accueillies';


--
-- Name: COLUMN donnees_techniques.am_empl_hll_nb; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN donnees_techniques.am_empl_hll_nb IS 'Nombre d’emplacements réservés aux HLL';


--
-- Name: COLUMN donnees_techniques.am_hll_shon; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN donnees_techniques.am_hll_shon IS 'Surface de plancher prévue, réservée aux HLL';


--
-- Name: COLUMN donnees_techniques.am_periode_exploit; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN donnees_techniques.am_periode_exploit IS 'Lorsque le terrain est destiné à une exploitation saisonnière, veuillez préciser la (ou les) période(s) d’exploitation';


--
-- Name: COLUMN donnees_techniques.am_exist_agrand; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN donnees_techniques.am_exist_agrand IS 'Agrandissement ou ré-aménagement d’une structure existante';


--
-- Name: COLUMN donnees_techniques.am_exist_date; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN donnees_techniques.am_exist_date IS 'Date et/ou numéro de l’autorisation';


--
-- Name: COLUMN donnees_techniques.am_exist_num; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN donnees_techniques.am_exist_num IS 'Nombre d’emplacements';


--
-- Name: COLUMN donnees_techniques.am_exist_nb_avant; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN donnees_techniques.am_exist_nb_avant IS 'Nombre d’emplacements avant agrandissement ou ré-aménagement';


--
-- Name: COLUMN donnees_techniques.am_exist_nb_apres; Type: COMMENT; Schema: openads; Owner: -
--

COMMENT ON COLUMN donnees_techniques.am_exist_nb_apres IS 'Nombre d’emplacements après agrandissement ou ré-aménagement';


--
