--
--


-- Started on 2024-10-30 11:27:04

SELECT pg_catalog.set_config('search_path', '', false);

--
-- TOC entry 4924 (class 1262 OID 646795)
-- Name: db_arboretum; Type: DATABASE; Schema: -; Owner: albenard
--

CREATE DATABASE db_arboretum WITH TEMPLATE = template0 ENCODING = 'UTF8' LOCALE_PROVIDER = libc LOCALE = 'fr_FR.UTF-8';


ALTER DATABASE db_arboretum OWNER TO albenard;

\connect db_arboretum

SELECT pg_catalog.set_config('search_path', '', false);

--
-- TOC entry 4925 (class 0 OID 0)
-- Name: db_arboretum; Type: DATABASE PROPERTIES; Schema: -; Owner: albenard
--

ALTER DATABASE db_arboretum SET search_path TO '$user', 'public', 'topology', 'sde';


\connect db_arboretum

SELECT pg_catalog.set_config('search_path', '', false);



--
-- TOC entry 251 (class 1259 OID 648300)
-- Name: t_arbre_arb; Type: TABLE; Schema: public; Owner: arboretum
--

CREATE TABLE public.t_arbre_arb (
    arb_id integer NOT NULL,
    arb_zon_id integer NOT NULL,
    arb_tax_id integer NOT NULL,
    arb_prov_id integer,
    arb_etiquette character varying(64) NOT NULL,
    arb_mort boolean,
    arb_mort_date character varying(40),
    arb_cle_externe character varying(16),
    arb_semis integer,
    arb_annee_plantation character varying(16),
    arb_plantation character varying(16),
    arb_saison_plant character varying(16),
    arb_x_plan_l93 double precision,
    arb_y_plan_l93 double precision,
    arb_x_gps_l93 double precision,
    arb_y_gps_l93 double precision,
    arb_x_theo_l93 double precision,
    arb_y_theo_l93 double precision,
    arb_geom_plan public.geometry(Point,2154),
    arb_geom_gps public.geometry(Point,2154),
    arb_geom_theo public.geometry(Point,2154)
);


ALTER TABLE public.t_arbre_arb OWNER TO arboretum;

--
-- TOC entry 4926 (class 0 OID 0)
-- Dependencies: 251
-- Name: TABLE t_arbre_arb; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON TABLE public.t_arbre_arb IS 'Table des arbres.';


--
-- TOC entry 4927 (class 0 OID 0)
-- Dependencies: 251
-- Name: COLUMN t_arbre_arb.arb_id; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.t_arbre_arb.arb_id IS 'Identifiant automatique numérique de l''arbre';


--
-- TOC entry 4928 (class 0 OID 0)
-- Dependencies: 251
-- Name: COLUMN t_arbre_arb.arb_zon_id; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.t_arbre_arb.arb_zon_id IS 'Identifiant automatique numérique de la zone';


--
-- TOC entry 4929 (class 0 OID 0)
-- Dependencies: 251
-- Name: COLUMN t_arbre_arb.arb_tax_id; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.t_arbre_arb.arb_tax_id IS 'Identifiant automatique numérique du taxon';


--
-- TOC entry 4930 (class 0 OID 0)
-- Dependencies: 251
-- Name: COLUMN t_arbre_arb.arb_prov_id; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.t_arbre_arb.arb_prov_id IS 'Identifiant automatique numérique de la provenance';


--
-- TOC entry 4931 (class 0 OID 0)
-- Dependencies: 251
-- Name: COLUMN t_arbre_arb.arb_etiquette; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.t_arbre_arb.arb_etiquette IS 'Identifiant humain de l''arbre au sein de sa zone';


--
-- TOC entry 4932 (class 0 OID 0)
-- Dependencies: 251
-- Name: COLUMN t_arbre_arb.arb_mort; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.t_arbre_arb.arb_mort IS 'Booléen précisant si l''arbre est mort ou vivant';


--
-- TOC entry 4933 (class 0 OID 0)
-- Dependencies: 251
-- Name: COLUMN t_arbre_arb.arb_mort_date; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.t_arbre_arb.arb_mort_date IS 'Date de mort estimée de l''arbre';


--
-- TOC entry 4934 (class 0 OID 0)
-- Dependencies: 251
-- Name: COLUMN t_arbre_arb.arb_cle_externe; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.t_arbre_arb.arb_cle_externe IS 'Identifiant dans un autre système d''information. Pour l''arboretum de Champenoux la colonne index du fichier Excel d''inventaire peuplera cette colonne';


--
-- TOC entry 4935 (class 0 OID 0)
-- Dependencies: 251
-- Name: COLUMN t_arbre_arb.arb_semis; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.t_arbre_arb.arb_semis IS 'année des semis issu du tableau excel d''origine';


--
-- TOC entry 4936 (class 0 OID 0)
-- Dependencies: 251
-- Name: COLUMN t_arbre_arb.arb_annee_plantation; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.t_arbre_arb.arb_annee_plantation IS 'année de platation issu du tableau excel d''origine';


--
-- TOC entry 4937 (class 0 OID 0)
-- Dependencies: 251
-- Name: COLUMN t_arbre_arb.arb_plantation; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.t_arbre_arb.arb_plantation IS 'type de plantation (récente ou ancienne) issu du tableau excel d''origine';


--
-- TOC entry 4938 (class 0 OID 0)
-- Dependencies: 251
-- Name: COLUMN t_arbre_arb.arb_saison_plant; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.t_arbre_arb.arb_saison_plant IS 'saison de plantation issu du tableau excel d''origine';


--
-- TOC entry 4939 (class 0 OID 0)
-- Dependencies: 251
-- Name: COLUMN t_arbre_arb.arb_x_plan_l93; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.t_arbre_arb.arb_x_plan_l93 IS 'Coordonnée X exprimée en Lambert 93 définie par pointage sur plan';


--
-- TOC entry 4940 (class 0 OID 0)
-- Dependencies: 251
-- Name: COLUMN t_arbre_arb.arb_y_plan_l93; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.t_arbre_arb.arb_y_plan_l93 IS 'Coordonnée Y exprimée en Lambert 93 définie par pointage sur plan';


--
-- TOC entry 4941 (class 0 OID 0)
-- Dependencies: 251
-- Name: COLUMN t_arbre_arb.arb_x_gps_l93; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.t_arbre_arb.arb_x_gps_l93 IS 'Coordonnée X exprimée en Lambert 93 définie par GPS';


--
-- TOC entry 4942 (class 0 OID 0)
-- Dependencies: 251
-- Name: COLUMN t_arbre_arb.arb_y_gps_l93; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.t_arbre_arb.arb_y_gps_l93 IS 'Coordonnée Y exprimée en Lambert 93 définie par GPS';


--
-- TOC entry 4943 (class 0 OID 0)
-- Dependencies: 251
-- Name: COLUMN t_arbre_arb.arb_x_theo_l93; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.t_arbre_arb.arb_x_theo_l93 IS 'Coordonnée X exprimée en Lambert 93 définie par théodolite';


--
-- TOC entry 4944 (class 0 OID 0)
-- Dependencies: 251
-- Name: COLUMN t_arbre_arb.arb_y_theo_l93; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.t_arbre_arb.arb_y_theo_l93 IS 'Coordonnée Y exprimée en Lambert 93 définie par théodolite';


--
-- TOC entry 4945 (class 0 OID 0)
-- Dependencies: 251
-- Name: COLUMN t_arbre_arb.arb_geom_plan; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.t_arbre_arb.arb_geom_plan IS 'Objet géométrique point construit à partir des coordonnées plan';


--
-- TOC entry 4946 (class 0 OID 0)
-- Dependencies: 251
-- Name: COLUMN t_arbre_arb.arb_geom_gps; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.t_arbre_arb.arb_geom_gps IS 'Objet géométrique point construit à partir des coordonnées GPS';


--
-- TOC entry 4947 (class 0 OID 0)
-- Dependencies: 251
-- Name: COLUMN t_arbre_arb.arb_geom_theo; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.t_arbre_arb.arb_geom_theo IS 'Objet géométrique point construit à partir des coordonnées théodolite';


--
-- TOC entry 252 (class 1259 OID 648305)
-- Name: t_mesure_marb; Type: TABLE; Schema: public; Owner: arboretum
--

CREATE TABLE public.t_mesure_marb (
    marb_id integer NOT NULL,
    marb_arb_id integer NOT NULL,
    marb_typm_id integer,
    marb_var_id integer NOT NULL,
    marb_fic_id integer,
    marb_prot_id integer,
    marb_norm_id integer,
    marb_uni_id integer,
    marb_valeur_num double precision,
    marb_valeur_text character varying,
    marb_valeur_date date,
    marb_date_mesure date,
    marb_precision_date_mesure double precision,
    marb_precision_mesure double precision,
    marb_remarque character varying
);


ALTER TABLE public.t_mesure_marb OWNER TO arboretum;

--
-- TOC entry 4949 (class 0 OID 0)
-- Dependencies: 252
-- Name: TABLE t_mesure_marb; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON TABLE public.t_mesure_marb IS 'Table des mesures de variables pour un type d''objet spécifique';


--
-- TOC entry 4950 (class 0 OID 0)
-- Dependencies: 252
-- Name: COLUMN t_mesure_marb.marb_id; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.t_mesure_marb.marb_id IS 'Identifiant automatique numérique de la mesure';


--
-- TOC entry 4951 (class 0 OID 0)
-- Dependencies: 252
-- Name: COLUMN t_mesure_marb.marb_arb_id; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.t_mesure_marb.marb_arb_id IS 'Identifiant automatique numérique de l''objet associé';


--
-- TOC entry 4952 (class 0 OID 0)
-- Dependencies: 252
-- Name: COLUMN t_mesure_marb.marb_typm_id; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.t_mesure_marb.marb_typm_id IS 'Identifiant automatique numérique du type de mesure associé';


--
-- TOC entry 4953 (class 0 OID 0)
-- Dependencies: 252
-- Name: COLUMN t_mesure_marb.marb_var_id; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.t_mesure_marb.marb_var_id IS 'Identifiant unique numérique de la variable associée';


--
-- TOC entry 4954 (class 0 OID 0)
-- Dependencies: 252
-- Name: COLUMN t_mesure_marb.marb_fic_id; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.t_mesure_marb.marb_fic_id IS 'Identifiant automatique numérique du fichier associé';


--
-- TOC entry 4955 (class 0 OID 0)
-- Dependencies: 252
-- Name: COLUMN t_mesure_marb.marb_prot_id; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.t_mesure_marb.marb_prot_id IS 'Identifiant unique numérique du protocole associé';


--
-- TOC entry 4956 (class 0 OID 0)
-- Dependencies: 252
-- Name: COLUMN t_mesure_marb.marb_norm_id; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.t_mesure_marb.marb_norm_id IS 'Identifiant numérique automatique de la norme associée';


--
-- TOC entry 4957 (class 0 OID 0)
-- Dependencies: 252
-- Name: COLUMN t_mesure_marb.marb_uni_id; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.t_mesure_marb.marb_uni_id IS 'Identifiant unique numérique de l''unité de mesure associée';


--
-- TOC entry 4958 (class 0 OID 0)
-- Dependencies: 252
-- Name: COLUMN t_mesure_marb.marb_valeur_num; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.t_mesure_marb.marb_valeur_num IS 'valeur de la mesure si celle-ci est de type numérique';


--
-- TOC entry 4959 (class 0 OID 0)
-- Dependencies: 252
-- Name: COLUMN t_mesure_marb.marb_valeur_text; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.t_mesure_marb.marb_valeur_text IS 'valeur de la mesure si celle-ci est de type texte';


--
-- TOC entry 4960 (class 0 OID 0)
-- Dependencies: 252
-- Name: COLUMN t_mesure_marb.marb_valeur_date; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.t_mesure_marb.marb_valeur_date IS 'valeur de la mesure si celle-ci est de type date';


--
-- TOC entry 4961 (class 0 OID 0)
-- Dependencies: 252
-- Name: COLUMN t_mesure_marb.marb_date_mesure; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.t_mesure_marb.marb_date_mesure IS 'date de la mesure';


--
-- TOC entry 4962 (class 0 OID 0)
-- Dependencies: 252
-- Name: COLUMN t_mesure_marb.marb_precision_date_mesure; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.t_mesure_marb.marb_precision_date_mesure IS 'Précision concernant la date de la mesure';


--
-- TOC entry 4963 (class 0 OID 0)
-- Dependencies: 252
-- Name: COLUMN t_mesure_marb.marb_precision_mesure; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.t_mesure_marb.marb_precision_mesure IS 'Précision de la valeur de la mesure';


--
-- TOC entry 4964 (class 0 OID 0)
-- Dependencies: 252
-- Name: COLUMN t_mesure_marb.marb_remarque; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.t_mesure_marb.marb_remarque IS 'Information complémentaire associée à la mesure';


--
-- TOC entry 253 (class 1259 OID 648310)
-- Name: tr_taxon_tax; Type: TABLE; Schema: public; Owner: arboretum
--

CREATE TABLE public.tr_taxon_tax (
    tax_id integer NOT NULL,
    tax_ref_id integer NOT NULL,
    tax_libelle character varying(255) NOT NULL,
    tax_identifiant_ext character varying(64),
    tax_sous_embranchement character varying(16),
    tax_nom_simple character varying(64),
    tax_synonyme character varying(128),
    tax_origine character varying(5)
);


ALTER TABLE public.tr_taxon_tax OWNER TO arboretum;

--
-- TOC entry 4966 (class 0 OID 0)
-- Dependencies: 253
-- Name: TABLE tr_taxon_tax; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON TABLE public.tr_taxon_tax IS 'table des taxons (espèces) végétales référencées dans la base';


--
-- TOC entry 4967 (class 0 OID 0)
-- Dependencies: 253
-- Name: COLUMN tr_taxon_tax.tax_id; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.tr_taxon_tax.tax_id IS 'identifiant automatique numérique du taxon';


--
-- TOC entry 4968 (class 0 OID 0)
-- Dependencies: 253
-- Name: COLUMN tr_taxon_tax.tax_ref_id; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.tr_taxon_tax.tax_ref_id IS 'identifiant automatique numérique du référentiel de rattachement';


--
-- TOC entry 4969 (class 0 OID 0)
-- Dependencies: 253
-- Name: COLUMN tr_taxon_tax.tax_libelle; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.tr_taxon_tax.tax_libelle IS 'nom courant unique du taxon dans son référentiel d''origine - issu colonne J = TAXON';


--
-- TOC entry 4970 (class 0 OID 0)
-- Dependencies: 253
-- Name: COLUMN tr_taxon_tax.tax_identifiant_ext; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.tr_taxon_tax.tax_identifiant_ext IS 'identifiant dans la source d''information (référentiel d''origine). par exemple le ''champ cd_nom d''une table taxref''. ce champ doit permettre un suivi de l''évolution des référentiels dans le temps.';


--
-- TOC entry 4971 (class 0 OID 0)
-- Dependencies: 253
-- Name: COLUMN tr_taxon_tax.tax_sous_embranchement; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.tr_taxon_tax.tax_sous_embranchement IS 'Sous-embranchement issu du tableau excel d''origine';


--
-- TOC entry 4972 (class 0 OID 0)
-- Dependencies: 253
-- Name: COLUMN tr_taxon_tax.tax_nom_simple; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.tr_taxon_tax.tax_nom_simple IS 'Nom simple issu du tableau excel d''origine';


--
-- TOC entry 4973 (class 0 OID 0)
-- Dependencies: 253
-- Name: COLUMN tr_taxon_tax.tax_synonyme; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.tr_taxon_tax.tax_synonyme IS 'Synonyme ou BD ancienne issu du tableau excel d''origine';


--
-- TOC entry 4974 (class 0 OID 0)
-- Dependencies: 253
-- Name: COLUMN tr_taxon_tax.tax_origine; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.tr_taxon_tax.tax_origine IS 'Origine issu du tableau excel d''origine';


--
-- TOC entry 254 (class 1259 OID 648315)
-- Name: tr_type_mesure_typm; Type: TABLE; Schema: public; Owner: arboretum
--

CREATE TABLE public.tr_type_mesure_typm (
    typm_id integer NOT NULL,
    typm_code character varying(16) NOT NULL,
    typm_description character varying(128) NOT NULL
);


ALTER TABLE public.tr_type_mesure_typm OWNER TO arboretum;

--
-- TOC entry 4976 (class 0 OID 0)
-- Dependencies: 254
-- Name: TABLE tr_type_mesure_typm; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON TABLE public.tr_type_mesure_typm IS 'Table des type de mesure (calculé, mesuré ...)';


--
-- TOC entry 4977 (class 0 OID 0)
-- Dependencies: 254
-- Name: COLUMN tr_type_mesure_typm.typm_id; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.tr_type_mesure_typm.typm_id IS 'Identifiant automatique numérique du type de mesure';


--
-- TOC entry 4978 (class 0 OID 0)
-- Dependencies: 254
-- Name: COLUMN tr_type_mesure_typm.typm_code; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.tr_type_mesure_typm.typm_code IS 'Code du type de mesure';


--
-- TOC entry 4979 (class 0 OID 0)
-- Dependencies: 254
-- Name: COLUMN tr_type_mesure_typm.typm_description; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.tr_type_mesure_typm.typm_description IS 'Description complète du type de mesure';


--
-- TOC entry 255 (class 1259 OID 648318)
-- Name: tr_unite_uni; Type: TABLE; Schema: public; Owner: arboretum
--

CREATE TABLE public.tr_unite_uni (
    uni_id integer NOT NULL,
    uni_symbole character varying(15) NOT NULL,
    uni_nom character varying(50) NOT NULL,
    uni_description character varying(255) NOT NULL,
    uni_type_donnee character varying(25)
);


ALTER TABLE public.tr_unite_uni OWNER TO arboretum;

--
-- TOC entry 4981 (class 0 OID 0)
-- Dependencies: 255
-- Name: TABLE tr_unite_uni; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON TABLE public.tr_unite_uni IS 'Table des unités de mesure.';


--
-- TOC entry 4982 (class 0 OID 0)
-- Dependencies: 255
-- Name: COLUMN tr_unite_uni.uni_id; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.tr_unite_uni.uni_id IS 'Identifiant unique numérique de l''unité de mesure';


--
-- TOC entry 4983 (class 0 OID 0)
-- Dependencies: 255
-- Name: COLUMN tr_unite_uni.uni_symbole; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.tr_unite_uni.uni_symbole IS 'Symbole utilisé pour représenter l''unité de mesure (par exemple m pour mètre)';


--
-- TOC entry 4984 (class 0 OID 0)
-- Dependencies: 255
-- Name: COLUMN tr_unite_uni.uni_nom; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.tr_unite_uni.uni_nom IS 'Nom usuel de l''unité de mesure';


--
-- TOC entry 4985 (class 0 OID 0)
-- Dependencies: 255
-- Name: COLUMN tr_unite_uni.uni_description; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.tr_unite_uni.uni_description IS 'Description de l''unité de mesure';


--
-- TOC entry 4986 (class 0 OID 0)
-- Dependencies: 255
-- Name: COLUMN tr_unite_uni.uni_type_donnee; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.tr_unite_uni.uni_type_donnee IS 'Type de données courant dans lequel les données exprimées dans l''unité de mesure seront fournies. Par exemple numeric pour des mesurées exprimées en mètres. Cette information optionnelle permet d''implémenter des contrôles de cohérence.';


--
-- TOC entry 256 (class 1259 OID 648321)
-- Name: tr_variable_var; Type: TABLE; Schema: public; Owner: arboretum
--

CREATE TABLE public.tr_variable_var (
    var_id integer NOT NULL,
    var_code character varying(25) NOT NULL,
    var_nom character varying(50) NOT NULL,
    var_description character varying(255) NOT NULL,
    var_type_donnees character varying(25),
    var_controle character varying(128)
);


ALTER TABLE public.tr_variable_var OWNER TO arboretum;

--
-- TOC entry 4988 (class 0 OID 0)
-- Dependencies: 256
-- Name: TABLE tr_variable_var; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON TABLE public.tr_variable_var IS 'Table des variable mesurées, observées ou calculées';


--
-- TOC entry 4989 (class 0 OID 0)
-- Dependencies: 256
-- Name: COLUMN tr_variable_var.var_id; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.tr_variable_var.var_id IS 'Identifiant unique numérique de la variable';


--
-- TOC entry 4990 (class 0 OID 0)
-- Dependencies: 256
-- Name: COLUMN tr_variable_var.var_code; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.tr_variable_var.var_code IS 'Code unique de la variable';


--
-- TOC entry 4991 (class 0 OID 0)
-- Dependencies: 256
-- Name: COLUMN tr_variable_var.var_nom; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.tr_variable_var.var_nom IS 'Nom usuel de la variable';


--
-- TOC entry 4992 (class 0 OID 0)
-- Dependencies: 256
-- Name: COLUMN tr_variable_var.var_description; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.tr_variable_var.var_description IS 'Description de la variable';


--
-- TOC entry 4993 (class 0 OID 0)
-- Dependencies: 256
-- Name: COLUMN tr_variable_var.var_type_donnees; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.tr_variable_var.var_type_donnees IS 'Type de données des mesures permettant des contrôles.';


--
-- TOC entry 4994 (class 0 OID 0)
-- Dependencies: 256
-- Name: COLUMN tr_variable_var.var_controle; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.tr_variable_var.var_controle IS 'Chaîne de caractère réglementée permettant d''effectuer des contrôles sur les valeurs de mesure en association avec l''information mes_type.';


--
-- TOC entry 257 (class 1259 OID 648324)
-- Name: tr_zone_etude_zon; Type: TABLE; Schema: public; Owner: arboretum
--

CREATE TABLE public.tr_zone_etude_zon (
    zon_id integer NOT NULL,
    zon_typz_id integer NOT NULL,
    zon_code character varying(64) NOT NULL,
    zon_libelle character varying(64) NOT NULL,
    zon_tree public.ltree NOT NULL
);


ALTER TABLE public.tr_zone_etude_zon OWNER TO arboretum;

--
-- TOC entry 4996 (class 0 OID 0)
-- Dependencies: 257
-- Name: TABLE tr_zone_etude_zon; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON TABLE public.tr_zone_etude_zon IS 'Table des zones d''étude représentant une entité géographique de niveau variable et pouvant être imbriquées.';


--
-- TOC entry 4997 (class 0 OID 0)
-- Dependencies: 257
-- Name: COLUMN tr_zone_etude_zon.zon_id; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.tr_zone_etude_zon.zon_id IS 'identifiant automatique numérique de la zone d''étude';


--
-- TOC entry 4998 (class 0 OID 0)
-- Dependencies: 257
-- Name: COLUMN tr_zone_etude_zon.zon_typz_id; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.tr_zone_etude_zon.zon_typz_id IS 'identifiant automatique numérique du type de zone d''étude';


--
-- TOC entry 4999 (class 0 OID 0)
-- Dependencies: 257
-- Name: COLUMN tr_zone_etude_zon.zon_code; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.tr_zone_etude_zon.zon_code IS 'Code de la zone d''étude';


--
-- TOC entry 5000 (class 0 OID 0)
-- Dependencies: 257
-- Name: COLUMN tr_zone_etude_zon.zon_libelle; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.tr_zone_etude_zon.zon_libelle IS 'Libellé de la zone d''étude';


--
-- TOC entry 5001 (class 0 OID 0)
-- Dependencies: 257
-- Name: COLUMN tr_zone_etude_zon.zon_tree; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.tr_zone_etude_zon.zon_tree IS 'Arborescence unique complète de la zone, chaque noeud étant séparé par le caractère ''.''';


--
-- TOC entry 259 (class 1259 OID 648334)
-- Name: tr_provenance_prov; Type: TABLE; Schema: public; Owner: arboretum
--

CREATE TABLE public.tr_provenance_prov (
    prov_id integer NOT NULL,
    prov_nom character varying(100) NOT NULL
);


ALTER TABLE public.tr_provenance_prov OWNER TO arboretum;

--
-- TOC entry 5003 (class 0 OID 0)
-- Dependencies: 259
-- Name: TABLE tr_provenance_prov; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON TABLE public.tr_provenance_prov IS 'Table des provenances des arbres.';


--
-- TOC entry 5004 (class 0 OID 0)
-- Dependencies: 259
-- Name: COLUMN tr_provenance_prov.prov_id; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.tr_provenance_prov.prov_id IS 'Identifiant automatique numérique de la provenance';


--
-- TOC entry 5005 (class 0 OID 0)
-- Dependencies: 259
-- Name: COLUMN tr_provenance_prov.prov_nom; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.tr_provenance_prov.prov_nom IS 'Identifiant humain / nom unique de la provenance';


--
-- TOC entry 284 (class 1259 OID 648425)
-- Name: t_arbre_arb_arb_id_seq; Type: SEQUENCE; Schema: public; Owner: arboretum
--

CREATE SEQUENCE public.t_arbre_arb_arb_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.t_arbre_arb_arb_id_seq OWNER TO arboretum;

--
-- TOC entry 5007 (class 0 OID 0)
-- Dependencies: 284
-- Name: t_arbre_arb_arb_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: arboretum
--

ALTER SEQUENCE public.t_arbre_arb_arb_id_seq OWNED BY public.t_arbre_arb.arb_id;


--
-- TOC entry 285 (class 1259 OID 648426)
-- Name: t_formulaire_access_configuration_faconf; Type: TABLE; Schema: public; Owner: arboretum
--

CREATE TABLE public.t_formulaire_access_configuration_faconf (
    faconf_id integer NOT NULL,
    faconf_sgbd character varying(100) NOT NULL,
    faconf_version character varying(4),
    faconf_odbc boolean NOT NULL,
    faconf_deconnecte boolean NOT NULL,
    faconf_num_instance integer,
    faconf_database character varying(100) NOT NULL,
    faconf_role_ecriture character varying(100),
    faconf_tag character varying(255)
);


ALTER TABLE public.t_formulaire_access_configuration_faconf OWNER TO arboretum;

--
-- TOC entry 5009 (class 0 OID 0)
-- Dependencies: 285
-- Name: TABLE t_formulaire_access_configuration_faconf; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON TABLE public.t_formulaire_access_configuration_faconf IS 'Table contenant une partie de la configuration de l''application access.';


--
-- TOC entry 5010 (class 0 OID 0)
-- Dependencies: 285
-- Name: COLUMN t_formulaire_access_configuration_faconf.faconf_id; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.t_formulaire_access_configuration_faconf.faconf_id IS 'Identifiant de la configuration.';


--
-- TOC entry 5011 (class 0 OID 0)
-- Dependencies: 285
-- Name: COLUMN t_formulaire_access_configuration_faconf.faconf_sgbd; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.t_formulaire_access_configuration_faconf.faconf_sgbd IS 'Nom du sgbd utilisé.';


--
-- TOC entry 5012 (class 0 OID 0)
-- Dependencies: 285
-- Name: COLUMN t_formulaire_access_configuration_faconf.faconf_version; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.t_formulaire_access_configuration_faconf.faconf_version IS 'Version du sgbd utilisé.';


--
-- TOC entry 5013 (class 0 OID 0)
-- Dependencies: 285
-- Name: COLUMN t_formulaire_access_configuration_faconf.faconf_odbc; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.t_formulaire_access_configuration_faconf.faconf_odbc IS 'Booléan indiquant si l''application est connectée à la base en mode connecté (tables liées).';


--
-- TOC entry 5014 (class 0 OID 0)
-- Dependencies: 285
-- Name: COLUMN t_formulaire_access_configuration_faconf.faconf_deconnecte; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.t_formulaire_access_configuration_faconf.faconf_deconnecte IS 'Booléan indiquant si l''application est connectée à la base en mode déconnecté.';


--
-- TOC entry 5015 (class 0 OID 0)
-- Dependencies: 285
-- Name: COLUMN t_formulaire_access_configuration_faconf.faconf_num_instance; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.t_formulaire_access_configuration_faconf.faconf_num_instance IS 'Chiffre indiquant le numéro de l''instance, information utilisée en mode déconnecté pour la saisie à plusieurs.';


--
-- TOC entry 5016 (class 0 OID 0)
-- Dependencies: 285
-- Name: COLUMN t_formulaire_access_configuration_faconf.faconf_database; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.t_formulaire_access_configuration_faconf.faconf_database IS 'Nom de la base de donnée utilsée.';


--
-- TOC entry 5017 (class 0 OID 0)
-- Dependencies: 285
-- Name: COLUMN t_formulaire_access_configuration_faconf.faconf_role_ecriture; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.t_formulaire_access_configuration_faconf.faconf_role_ecriture IS 'Nom du rôle ayant les droits en écriture.';


--
-- TOC entry 5018 (class 0 OID 0)
-- Dependencies: 285
-- Name: COLUMN t_formulaire_access_configuration_faconf.faconf_tag; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.t_formulaire_access_configuration_faconf.faconf_tag IS 'Tag permettant d''effectuer un traitement particulier selon la valeur de ce dernier.';


--
-- TOC entry 286 (class 1259 OID 648431)
-- Name: t_formulaire_access_configuration_faconf_faconf_id_seq; Type: SEQUENCE; Schema: public; Owner: arboretum
--

CREATE SEQUENCE public.t_formulaire_access_configuration_faconf_faconf_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.t_formulaire_access_configuration_faconf_faconf_id_seq OWNER TO arboretum;

--
-- TOC entry 5020 (class 0 OID 0)
-- Dependencies: 286
-- Name: t_formulaire_access_configuration_faconf_faconf_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: arboretum
--

ALTER SEQUENCE public.t_formulaire_access_configuration_faconf_faconf_id_seq OWNED BY public.t_formulaire_access_configuration_faconf.faconf_id;


--
-- TOC entry 287 (class 1259 OID 648432)
-- Name: t_mesure_marb_marb_id_seq; Type: SEQUENCE; Schema: public; Owner: arboretum
--

CREATE SEQUENCE public.t_mesure_marb_marb_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.t_mesure_marb_marb_id_seq OWNER TO arboretum;

--
-- TOC entry 5022 (class 0 OID 0)
-- Dependencies: 287
-- Name: t_mesure_marb_marb_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: arboretum
--

ALTER SEQUENCE public.t_mesure_marb_marb_id_seq OWNED BY public.t_mesure_marb.marb_id;


--
-- TOC entry 288 (class 1259 OID 648433)
-- Name: t_regroupement_rgp; Type: TABLE; Schema: public; Owner: arboretum
--

CREATE TABLE public.t_regroupement_rgp (
    rgp_id integer NOT NULL,
    rgp_typm_id integer,
    rgp_fic_id integer,
    rgp_prot_id integer,
    rgp_norm_id integer,
    rgp_uni_id integer,
    rgp_code character varying(32) NOT NULL,
    rgp_nom character varying(32) NOT NULL,
    rgp_description text NOT NULL
);


ALTER TABLE public.t_regroupement_rgp OWNER TO arboretum;

--
-- TOC entry 5024 (class 0 OID 0)
-- Dependencies: 288
-- Name: TABLE t_regroupement_rgp; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON TABLE public.t_regroupement_rgp IS 'Table des ensembles regroupant des mesures en vue de factoriser l''environnement de ces mesures (variable, unité, norme, protocole, fichier, opérateur(s)). Les informations satellites sont alors associées au regroupement de mesure et non plus à chaque mesure individuelle.';


--
-- TOC entry 5025 (class 0 OID 0)
-- Dependencies: 288
-- Name: COLUMN t_regroupement_rgp.rgp_id; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.t_regroupement_rgp.rgp_id IS 'Identifiant automatique numérique du regroupement';


--
-- TOC entry 5026 (class 0 OID 0)
-- Dependencies: 288
-- Name: COLUMN t_regroupement_rgp.rgp_typm_id; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.t_regroupement_rgp.rgp_typm_id IS 'Identifiant automatique numérique du type de mesure associé';


--
-- TOC entry 5027 (class 0 OID 0)
-- Dependencies: 288
-- Name: COLUMN t_regroupement_rgp.rgp_fic_id; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.t_regroupement_rgp.rgp_fic_id IS 'Identifiant automatique numérique du fichier associé';


--
-- TOC entry 5028 (class 0 OID 0)
-- Dependencies: 288
-- Name: COLUMN t_regroupement_rgp.rgp_prot_id; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.t_regroupement_rgp.rgp_prot_id IS 'Identifiant automatique numérique du protocole associé';


--
-- TOC entry 5029 (class 0 OID 0)
-- Dependencies: 288
-- Name: COLUMN t_regroupement_rgp.rgp_norm_id; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.t_regroupement_rgp.rgp_norm_id IS 'Identifiant numérique automatique de la norme associée';


--
-- TOC entry 5030 (class 0 OID 0)
-- Dependencies: 288
-- Name: COLUMN t_regroupement_rgp.rgp_uni_id; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.t_regroupement_rgp.rgp_uni_id IS 'Identifiant unique numérique de l''unité de mesure associée';


--
-- TOC entry 5031 (class 0 OID 0)
-- Dependencies: 288
-- Name: COLUMN t_regroupement_rgp.rgp_code; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.t_regroupement_rgp.rgp_code IS 'Code du regroupement permettant de l''identifier pour un opérateur humain';


--
-- TOC entry 5032 (class 0 OID 0)
-- Dependencies: 288
-- Name: COLUMN t_regroupement_rgp.rgp_nom; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.t_regroupement_rgp.rgp_nom IS 'Nom du regroupement';


--
-- TOC entry 5033 (class 0 OID 0)
-- Dependencies: 288
-- Name: COLUMN t_regroupement_rgp.rgp_description; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.t_regroupement_rgp.rgp_description IS 'Description du regroupement';


--
-- TOC entry 289 (class 1259 OID 648438)
-- Name: t_regroupement_rgp_rgp_id_seq; Type: SEQUENCE; Schema: public; Owner: arboretum
--

CREATE SEQUENCE public.t_regroupement_rgp_rgp_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.t_regroupement_rgp_rgp_id_seq OWNER TO arboretum;

--
-- TOC entry 5035 (class 0 OID 0)
-- Dependencies: 289
-- Name: t_regroupement_rgp_rgp_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: arboretum
--

ALTER SEQUENCE public.t_regroupement_rgp_rgp_id_seq OWNED BY public.t_regroupement_rgp.rgp_id;


--
-- TOC entry 290 (class 1259 OID 648439)
-- Name: tj_classervar_cvar; Type: TABLE; Schema: public; Owner: arboretum
--

CREATE TABLE public.tj_classervar_cvar (
    cvar_var_id integer NOT NULL,
    cvar_clas_id integer NOT NULL
);


ALTER TABLE public.tj_classervar_cvar OWNER TO arboretum;

--
-- TOC entry 5037 (class 0 OID 0)
-- Dependencies: 290
-- Name: TABLE tj_classervar_cvar; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON TABLE public.tj_classervar_cvar IS 'Table de jointure associant une variable à un classement, une variable pouvant être multiclassée';


--
-- TOC entry 5038 (class 0 OID 0)
-- Dependencies: 290
-- Name: COLUMN tj_classervar_cvar.cvar_var_id; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.tj_classervar_cvar.cvar_var_id IS 'Identifiant unique numérique de la variable';


--
-- TOC entry 5039 (class 0 OID 0)
-- Dependencies: 290
-- Name: COLUMN tj_classervar_cvar.cvar_clas_id; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.tj_classervar_cvar.cvar_clas_id IS 'Identifiant automatique numérique du classement';


--
-- TOC entry 291 (class 1259 OID 648442)
-- Name: tj_marb_marb_tarb; Type: TABLE; Schema: public; Owner: arboretum
--

CREATE TABLE public.tj_marb_marb_tarb (
    tarb_ref_marb_id integer NOT NULL,
    tarb_meta_marb_id integer NOT NULL,
    tarb_statut character varying(32)
);


ALTER TABLE public.tj_marb_marb_tarb OWNER TO arboretum;

--
-- TOC entry 5041 (class 0 OID 0)
-- Dependencies: 291
-- Name: TABLE tj_marb_marb_tarb; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON TABLE public.tj_marb_marb_tarb IS 'Table de jointure associant une mesure à une autre mesure, la seconde étant complémentaire (métadonnée) ou nécessaire à l''interprétation de la première.';


--
-- TOC entry 5042 (class 0 OID 0)
-- Dependencies: 291
-- Name: COLUMN tj_marb_marb_tarb.tarb_ref_marb_id; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.tj_marb_marb_tarb.tarb_ref_marb_id IS 'Identifiant automatique numérique de la mesure référence';


--
-- TOC entry 5043 (class 0 OID 0)
-- Dependencies: 291
-- Name: COLUMN tj_marb_marb_tarb.tarb_meta_marb_id; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.tj_marb_marb_tarb.tarb_meta_marb_id IS 'Identifiant automatique numérique de la mesure considérée comme métadonnée de la mesure référence';


--
-- TOC entry 5044 (class 0 OID 0)
-- Dependencies: 291
-- Name: COLUMN tj_marb_marb_tarb.tarb_statut; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.tj_marb_marb_tarb.tarb_statut IS 'Indicateur précisant le statut de la métadonnée par rapport à la mesure de référence. Par exemple le caractère obligatoire ou recommandé pour l''interprétation.';


--
-- TOC entry 292 (class 1259 OID 648445)
-- Name: tj_rgp_marb_gma; Type: TABLE; Schema: public; Owner: arboretum
--

CREATE TABLE public.tj_rgp_marb_gma (
    gma_marb_id integer NOT NULL,
    gma_rgp_id integer NOT NULL
);


ALTER TABLE public.tj_rgp_marb_gma OWNER TO arboretum;

--
-- TOC entry 5046 (class 0 OID 0)
-- Dependencies: 292
-- Name: TABLE tj_rgp_marb_gma; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON TABLE public.tj_rgp_marb_gma IS 'Table de jointure associant une mesure à un regroupement.';


--
-- TOC entry 5047 (class 0 OID 0)
-- Dependencies: 292
-- Name: COLUMN tj_rgp_marb_gma.gma_marb_id; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.tj_rgp_marb_gma.gma_marb_id IS 'Identifiant unique numérique de la mesure associée';


--
-- TOC entry 5048 (class 0 OID 0)
-- Dependencies: 292
-- Name: COLUMN tj_rgp_marb_gma.gma_rgp_id; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.tj_rgp_marb_gma.gma_rgp_id IS 'Identifiant automatique numérique du regroupement associé';


--
-- TOC entry 293 (class 1259 OID 648448)
-- Name: tj_role_ope_marb_roa; Type: TABLE; Schema: public; Owner: arboretum
--

CREATE TABLE public.tj_role_ope_marb_roa (
    roa_marb_id integer NOT NULL,
    roa_ope_id integer NOT NULL,
    roa_rol_id integer NOT NULL
);


ALTER TABLE public.tj_role_ope_marb_roa OWNER TO arboretum;

--
-- TOC entry 5050 (class 0 OID 0)
-- Dependencies: 293
-- Name: TABLE tj_role_ope_marb_roa; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON TABLE public.tj_role_ope_marb_roa IS 'Table de jointure associant une mesure à un opérateur et à un rôle pour cet opérateur';


--
-- TOC entry 5051 (class 0 OID 0)
-- Dependencies: 293
-- Name: COLUMN tj_role_ope_marb_roa.roa_marb_id; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.tj_role_ope_marb_roa.roa_marb_id IS 'Identifiant unique numérique de la mesure associée';


--
-- TOC entry 5052 (class 0 OID 0)
-- Dependencies: 293
-- Name: COLUMN tj_role_ope_marb_roa.roa_ope_id; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.tj_role_ope_marb_roa.roa_ope_id IS 'Identifiant automatique numérique de l''opérateur associé';


--
-- TOC entry 5053 (class 0 OID 0)
-- Dependencies: 293
-- Name: COLUMN tj_role_ope_marb_roa.roa_rol_id; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.tj_role_ope_marb_roa.roa_rol_id IS 'Identifiant automatique numérique du rôle associé';


--
-- TOC entry 294 (class 1259 OID 648451)
-- Name: tj_role_ope_rgp_ror; Type: TABLE; Schema: public; Owner: arboretum
--

CREATE TABLE public.tj_role_ope_rgp_ror (
    ror_rgp_id integer NOT NULL,
    ror_ope_id integer NOT NULL,
    ror_rol_id integer NOT NULL
);


ALTER TABLE public.tj_role_ope_rgp_ror OWNER TO arboretum;

--
-- TOC entry 5055 (class 0 OID 0)
-- Dependencies: 294
-- Name: TABLE tj_role_ope_rgp_ror; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON TABLE public.tj_role_ope_rgp_ror IS 'Table de jointure associant un regroupement à un opérateur et à un rôle pour cet opérateur';


--
-- TOC entry 5056 (class 0 OID 0)
-- Dependencies: 294
-- Name: COLUMN tj_role_ope_rgp_ror.ror_rgp_id; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.tj_role_ope_rgp_ror.ror_rgp_id IS 'Identifiant unique numérique du regroupement associé';


--
-- TOC entry 5057 (class 0 OID 0)
-- Dependencies: 294
-- Name: COLUMN tj_role_ope_rgp_ror.ror_ope_id; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.tj_role_ope_rgp_ror.ror_ope_id IS 'Identifiant automatique numérique de l''opérateur associé';


--
-- TOC entry 5058 (class 0 OID 0)
-- Dependencies: 294
-- Name: COLUMN tj_role_ope_rgp_ror.ror_rol_id; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.tj_role_ope_rgp_ror.ror_rol_id IS 'Identifiant automatique numérique du rôle associé';


--
-- TOC entry 295 (class 1259 OID 648454)
-- Name: tr_classement_clas; Type: TABLE; Schema: public; Owner: arboretum
--

CREATE TABLE public.tr_classement_clas (
    clas_id integer NOT NULL,
    clas_libelle character varying(32) NOT NULL,
    clas_definition character varying NOT NULL,
    clas_tree public.ltree NOT NULL
);


ALTER TABLE public.tr_classement_clas OWNER TO arboretum;

--
-- TOC entry 5060 (class 0 OID 0)
-- Dependencies: 295
-- Name: TABLE tr_classement_clas; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON TABLE public.tr_classement_clas IS 'Table des plans de classement. Informations relatives aux classement des variables permettant de les positionner dans un ou plusieurs référentiels. ';


--
-- TOC entry 5061 (class 0 OID 0)
-- Dependencies: 295
-- Name: COLUMN tr_classement_clas.clas_id; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.tr_classement_clas.clas_id IS 'Identifiant automatique numérique du classement';


--
-- TOC entry 5062 (class 0 OID 0)
-- Dependencies: 295
-- Name: COLUMN tr_classement_clas.clas_libelle; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.tr_classement_clas.clas_libelle IS 'Libellé usuel du classement';


--
-- TOC entry 5063 (class 0 OID 0)
-- Dependencies: 295
-- Name: COLUMN tr_classement_clas.clas_definition; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.tr_classement_clas.clas_definition IS 'Définition du classement';


--
-- TOC entry 5064 (class 0 OID 0)
-- Dependencies: 295
-- Name: COLUMN tr_classement_clas.clas_tree; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.tr_classement_clas.clas_tree IS 'Arborescence unique complète du classemùent, chaque noeud étant séparé par le caractère ''.''';


--
-- TOC entry 296 (class 1259 OID 648459)
-- Name: tr_classement_clas_clas_id_seq; Type: SEQUENCE; Schema: public; Owner: arboretum
--

CREATE SEQUENCE public.tr_classement_clas_clas_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.tr_classement_clas_clas_id_seq OWNER TO arboretum;

--
-- TOC entry 5066 (class 0 OID 0)
-- Dependencies: 296
-- Name: tr_classement_clas_clas_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: arboretum
--

ALTER SEQUENCE public.tr_classement_clas_clas_id_seq OWNED BY public.tr_classement_clas.clas_id;


--
-- TOC entry 297 (class 1259 OID 648460)
-- Name: tr_fichier_fic; Type: TABLE; Schema: public; Owner: arboretum
--

CREATE TABLE public.tr_fichier_fic (
    fic_id integer NOT NULL,
    fic_nom character varying(120) NOT NULL,
    fic_url character varying(255) NOT NULL
);


ALTER TABLE public.tr_fichier_fic OWNER TO arboretum;

--
-- TOC entry 5068 (class 0 OID 0)
-- Dependencies: 297
-- Name: TABLE tr_fichier_fic; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON TABLE public.tr_fichier_fic IS 'Table des fichiers de mesures';


--
-- TOC entry 5069 (class 0 OID 0)
-- Dependencies: 297
-- Name: COLUMN tr_fichier_fic.fic_id; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.tr_fichier_fic.fic_id IS 'Identifiant automatique numérique du fichier';


--
-- TOC entry 5070 (class 0 OID 0)
-- Dependencies: 297
-- Name: COLUMN tr_fichier_fic.fic_nom; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.tr_fichier_fic.fic_nom IS 'Nom du fichier';


--
-- TOC entry 5071 (class 0 OID 0)
-- Dependencies: 297
-- Name: COLUMN tr_fichier_fic.fic_url; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.tr_fichier_fic.fic_url IS 'url d''accès au fichier';


--
-- TOC entry 298 (class 1259 OID 648463)
-- Name: tr_fichier_fic_fic_id_seq; Type: SEQUENCE; Schema: public; Owner: arboretum
--

CREATE SEQUENCE public.tr_fichier_fic_fic_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.tr_fichier_fic_fic_id_seq OWNER TO arboretum;

--
-- TOC entry 5073 (class 0 OID 0)
-- Dependencies: 298
-- Name: tr_fichier_fic_fic_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: arboretum
--

ALTER SEQUENCE public.tr_fichier_fic_fic_id_seq OWNED BY public.tr_fichier_fic.fic_id;


--
-- TOC entry 299 (class 1259 OID 648464)
-- Name: tr_norme_norm; Type: TABLE; Schema: public; Owner: arboretum
--

CREATE TABLE public.tr_norme_norm (
    norm_id integer NOT NULL,
    norm_nom character varying(50),
    norm_date date NOT NULL,
    norm_url character varying(255),
    norm_version character varying(10) NOT NULL
);


ALTER TABLE public.tr_norme_norm OWNER TO arboretum;

--
-- TOC entry 5075 (class 0 OID 0)
-- Dependencies: 299
-- Name: TABLE tr_norme_norm; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON TABLE public.tr_norme_norm IS 'Table contenant les normes référencées dans la base';


--
-- TOC entry 5076 (class 0 OID 0)
-- Dependencies: 299
-- Name: COLUMN tr_norme_norm.norm_id; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.tr_norme_norm.norm_id IS 'Identifiant numérique automatique de la norme';


--
-- TOC entry 5077 (class 0 OID 0)
-- Dependencies: 299
-- Name: COLUMN tr_norme_norm.norm_nom; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.tr_norme_norm.norm_nom IS 'Nom usuel de la norme';


--
-- TOC entry 5078 (class 0 OID 0)
-- Dependencies: 299
-- Name: COLUMN tr_norme_norm.norm_date; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.tr_norme_norm.norm_date IS 'Date de parution de la norme';


--
-- TOC entry 5079 (class 0 OID 0)
-- Dependencies: 299
-- Name: COLUMN tr_norme_norm.norm_url; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.tr_norme_norm.norm_url IS 'Url d''accès au document de la norme';


--
-- TOC entry 5080 (class 0 OID 0)
-- Dependencies: 299
-- Name: COLUMN tr_norme_norm.norm_version; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.tr_norme_norm.norm_version IS 'Information de version de la norme';


--
-- TOC entry 300 (class 1259 OID 648467)
-- Name: tr_norme_norm_norm_id_seq; Type: SEQUENCE; Schema: public; Owner: arboretum
--

CREATE SEQUENCE public.tr_norme_norm_norm_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.tr_norme_norm_norm_id_seq OWNER TO arboretum;

--
-- TOC entry 5082 (class 0 OID 0)
-- Dependencies: 300
-- Name: tr_norme_norm_norm_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: arboretum
--

ALTER SEQUENCE public.tr_norme_norm_norm_id_seq OWNED BY public.tr_norme_norm.norm_id;


--
-- TOC entry 301 (class 1259 OID 648468)
-- Name: tr_operateur_ope; Type: TABLE; Schema: public; Owner: arboretum
--

CREATE TABLE public.tr_operateur_ope (
    ope_id integer NOT NULL,
    ope_nom character varying(50) NOT NULL,
    ope_prenom character varying(50) NOT NULL,
    ope_mail character varying(120)
);


ALTER TABLE public.tr_operateur_ope OWNER TO arboretum;

--
-- TOC entry 5084 (class 0 OID 0)
-- Dependencies: 301
-- Name: TABLE tr_operateur_ope; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON TABLE public.tr_operateur_ope IS 'Table des opérateurs';


--
-- TOC entry 5085 (class 0 OID 0)
-- Dependencies: 301
-- Name: COLUMN tr_operateur_ope.ope_id; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.tr_operateur_ope.ope_id IS 'Identifiant automatique numérique de l''opérateur';


--
-- TOC entry 5086 (class 0 OID 0)
-- Dependencies: 301
-- Name: COLUMN tr_operateur_ope.ope_nom; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.tr_operateur_ope.ope_nom IS 'Nom de l''opérateur';


--
-- TOC entry 5087 (class 0 OID 0)
-- Dependencies: 301
-- Name: COLUMN tr_operateur_ope.ope_prenom; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.tr_operateur_ope.ope_prenom IS 'Prénom de l''opérateur';


--
-- TOC entry 5088 (class 0 OID 0)
-- Dependencies: 301
-- Name: COLUMN tr_operateur_ope.ope_mail; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.tr_operateur_ope.ope_mail IS 'Adresse électronique de l''opérateur';


--
-- TOC entry 302 (class 1259 OID 648471)
-- Name: tr_operateur_ope_ope_id_seq; Type: SEQUENCE; Schema: public; Owner: arboretum
--

CREATE SEQUENCE public.tr_operateur_ope_ope_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.tr_operateur_ope_ope_id_seq OWNER TO arboretum;

--
-- TOC entry 5090 (class 0 OID 0)
-- Dependencies: 302
-- Name: tr_operateur_ope_ope_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: arboretum
--

ALTER SEQUENCE public.tr_operateur_ope_ope_id_seq OWNED BY public.tr_operateur_ope.ope_id;


--
-- TOC entry 303 (class 1259 OID 648472)
-- Name: tr_protocole_prot; Type: TABLE; Schema: public; Owner: arboretum
--

CREATE TABLE public.tr_protocole_prot (
    prot_id integer NOT NULL,
    prot_nom character varying(50) NOT NULL,
    prot_url character varying(255)
);


ALTER TABLE public.tr_protocole_prot OWNER TO arboretum;

--
-- TOC entry 5092 (class 0 OID 0)
-- Dependencies: 303
-- Name: TABLE tr_protocole_prot; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON TABLE public.tr_protocole_prot IS 'Table  des protocoles référencés dans la base';


--
-- TOC entry 5093 (class 0 OID 0)
-- Dependencies: 303
-- Name: COLUMN tr_protocole_prot.prot_id; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.tr_protocole_prot.prot_id IS 'Identifiant unique numérique du protocole';


--
-- TOC entry 5094 (class 0 OID 0)
-- Dependencies: 303
-- Name: COLUMN tr_protocole_prot.prot_nom; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.tr_protocole_prot.prot_nom IS 'Nom usuel du protocole';


--
-- TOC entry 5095 (class 0 OID 0)
-- Dependencies: 303
-- Name: COLUMN tr_protocole_prot.prot_url; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.tr_protocole_prot.prot_url IS 'url d''accès au document protocole';


--
-- TOC entry 304 (class 1259 OID 648475)
-- Name: tr_protocole_prot_prot_id_seq; Type: SEQUENCE; Schema: public; Owner: arboretum
--

CREATE SEQUENCE public.tr_protocole_prot_prot_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.tr_protocole_prot_prot_id_seq OWNER TO arboretum;

--
-- TOC entry 5097 (class 0 OID 0)
-- Dependencies: 304
-- Name: tr_protocole_prot_prot_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: arboretum
--

ALTER SEQUENCE public.tr_protocole_prot_prot_id_seq OWNED BY public.tr_protocole_prot.prot_id;


--
-- TOC entry 305 (class 1259 OID 648476)
-- Name: tr_provenance_prov_prov_id_seq; Type: SEQUENCE; Schema: public; Owner: arboretum
--

CREATE SEQUENCE public.tr_provenance_prov_prov_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.tr_provenance_prov_prov_id_seq OWNER TO arboretum;

--
-- TOC entry 5099 (class 0 OID 0)
-- Dependencies: 305
-- Name: tr_provenance_prov_prov_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: arboretum
--

ALTER SEQUENCE public.tr_provenance_prov_prov_id_seq OWNED BY public.tr_provenance_prov.prov_id;


--
-- TOC entry 306 (class 1259 OID 648477)
-- Name: tr_referentiel_taxonomique_ref; Type: TABLE; Schema: public; Owner: arboretum
--

CREATE TABLE public.tr_referentiel_taxonomique_ref (
    ref_id integer NOT NULL,
    ref_libelle character varying(128) NOT NULL,
    ref_version character varying(16) NOT NULL,
    ref_code character varying(16) NOT NULL,
    ref_commentaire character varying(255)
);


ALTER TABLE public.tr_referentiel_taxonomique_ref OWNER TO arboretum;

--
-- TOC entry 5101 (class 0 OID 0)
-- Dependencies: 306
-- Name: TABLE tr_referentiel_taxonomique_ref; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON TABLE public.tr_referentiel_taxonomique_ref IS 'table des référentiels taxonomiques';


--
-- TOC entry 5102 (class 0 OID 0)
-- Dependencies: 306
-- Name: COLUMN tr_referentiel_taxonomique_ref.ref_id; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.tr_referentiel_taxonomique_ref.ref_id IS 'identifiant automatique numérique du référentiel';


--
-- TOC entry 5103 (class 0 OID 0)
-- Dependencies: 306
-- Name: COLUMN tr_referentiel_taxonomique_ref.ref_libelle; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.tr_referentiel_taxonomique_ref.ref_libelle IS 'nom du référentiel';


--
-- TOC entry 5104 (class 0 OID 0)
-- Dependencies: 306
-- Name: COLUMN tr_referentiel_taxonomique_ref.ref_version; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.tr_referentiel_taxonomique_ref.ref_version IS 'version du référentiel';


--
-- TOC entry 5105 (class 0 OID 0)
-- Dependencies: 306
-- Name: COLUMN tr_referentiel_taxonomique_ref.ref_code; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.tr_referentiel_taxonomique_ref.ref_code IS 'code unique permettant d''identifier le référentiel (hors versions)';


--
-- TOC entry 5106 (class 0 OID 0)
-- Dependencies: 306
-- Name: COLUMN tr_referentiel_taxonomique_ref.ref_commentaire; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.tr_referentiel_taxonomique_ref.ref_commentaire IS 'Commentaire libre sur le référentiel.';


--
-- TOC entry 307 (class 1259 OID 648480)
-- Name: tr_referentiel_ref_ref_id_seq; Type: SEQUENCE; Schema: public; Owner: arboretum
--

CREATE SEQUENCE public.tr_referentiel_ref_ref_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.tr_referentiel_ref_ref_id_seq OWNER TO arboretum;

--
-- TOC entry 5108 (class 0 OID 0)
-- Dependencies: 307
-- Name: tr_referentiel_ref_ref_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: arboretum
--

ALTER SEQUENCE public.tr_referentiel_ref_ref_id_seq OWNED BY public.tr_referentiel_taxonomique_ref.ref_id;


--
-- TOC entry 308 (class 1259 OID 648481)
-- Name: tr_role_rol; Type: TABLE; Schema: public; Owner: arboretum
--

CREATE TABLE public.tr_role_rol (
    rol_id integer NOT NULL,
    rol_libelle character varying(32) NOT NULL,
    rol_description text NOT NULL
);


ALTER TABLE public.tr_role_rol OWNER TO arboretum;

--
-- TOC entry 5110 (class 0 OID 0)
-- Dependencies: 308
-- Name: TABLE tr_role_rol; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON TABLE public.tr_role_rol IS 'Table des rôles que peuvent tenir des personnes';


--
-- TOC entry 5111 (class 0 OID 0)
-- Dependencies: 308
-- Name: COLUMN tr_role_rol.rol_id; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.tr_role_rol.rol_id IS 'Identifiant unique automatique du rôle';


--
-- TOC entry 5112 (class 0 OID 0)
-- Dependencies: 308
-- Name: COLUMN tr_role_rol.rol_libelle; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.tr_role_rol.rol_libelle IS 'Libellé unique du rôle';


--
-- TOC entry 5113 (class 0 OID 0)
-- Dependencies: 308
-- Name: COLUMN tr_role_rol.rol_description; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.tr_role_rol.rol_description IS 'Descritpion complète du rôle';


--
-- TOC entry 309 (class 1259 OID 648486)
-- Name: tr_role_rol_rol_id_seq; Type: SEQUENCE; Schema: public; Owner: arboretum
--

CREATE SEQUENCE public.tr_role_rol_rol_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.tr_role_rol_rol_id_seq OWNER TO arboretum;

--
-- TOC entry 5115 (class 0 OID 0)
-- Dependencies: 309
-- Name: tr_role_rol_rol_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: arboretum
--

ALTER SEQUENCE public.tr_role_rol_rol_id_seq OWNED BY public.tr_role_rol.rol_id;


--
-- TOC entry 310 (class 1259 OID 648487)
-- Name: tr_taxon_tax_tax_id_seq; Type: SEQUENCE; Schema: public; Owner: arboretum
--

CREATE SEQUENCE public.tr_taxon_tax_tax_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.tr_taxon_tax_tax_id_seq OWNER TO arboretum;

--
-- TOC entry 5117 (class 0 OID 0)
-- Dependencies: 310
-- Name: tr_taxon_tax_tax_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: arboretum
--

ALTER SEQUENCE public.tr_taxon_tax_tax_id_seq OWNED BY public.tr_taxon_tax.tax_id;


--
-- TOC entry 311 (class 1259 OID 648488)
-- Name: tr_type_mesure_typm_typm_id_seq; Type: SEQUENCE; Schema: public; Owner: arboretum
--

CREATE SEQUENCE public.tr_type_mesure_typm_typm_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.tr_type_mesure_typm_typm_id_seq OWNER TO arboretum;

--
-- TOC entry 5119 (class 0 OID 0)
-- Dependencies: 311
-- Name: tr_type_mesure_typm_typm_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: arboretum
--

ALTER SEQUENCE public.tr_type_mesure_typm_typm_id_seq OWNED BY public.tr_type_mesure_typm.typm_id;


--
-- TOC entry 312 (class 1259 OID 648489)
-- Name: tr_type_zone_etude_typz; Type: TABLE; Schema: public; Owner: arboretum
--

CREATE TABLE public.tr_type_zone_etude_typz (
    typz_id integer NOT NULL,
    typz_code character varying(32) NOT NULL,
    typz_description character varying(128)
);


ALTER TABLE public.tr_type_zone_etude_typz OWNER TO arboretum;

--
-- TOC entry 5121 (class 0 OID 0)
-- Dependencies: 312
-- Name: TABLE tr_type_zone_etude_typz; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON TABLE public.tr_type_zone_etude_typz IS 'Table des types de zone d''étude permettant de caractériser la typologie des zones d''étude (zone, placeau, collection ...)';


--
-- TOC entry 5122 (class 0 OID 0)
-- Dependencies: 312
-- Name: COLUMN tr_type_zone_etude_typz.typz_id; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.tr_type_zone_etude_typz.typz_id IS 'identifiant automatique numérique du type de zone d''étude';


--
-- TOC entry 5123 (class 0 OID 0)
-- Dependencies: 312
-- Name: COLUMN tr_type_zone_etude_typz.typz_code; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.tr_type_zone_etude_typz.typz_code IS 'Nom unique du type de zone d''étude';


--
-- TOC entry 5124 (class 0 OID 0)
-- Dependencies: 312
-- Name: COLUMN tr_type_zone_etude_typz.typz_description; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON COLUMN public.tr_type_zone_etude_typz.typz_description IS 'Description du type de zone d''étude';


--
-- TOC entry 313 (class 1259 OID 648492)
-- Name: tr_type_zone_etude_typz_typz_id_seq; Type: SEQUENCE; Schema: public; Owner: arboretum
--

CREATE SEQUENCE public.tr_type_zone_etude_typz_typz_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.tr_type_zone_etude_typz_typz_id_seq OWNER TO arboretum;

--
-- TOC entry 5126 (class 0 OID 0)
-- Dependencies: 313
-- Name: tr_type_zone_etude_typz_typz_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: arboretum
--

ALTER SEQUENCE public.tr_type_zone_etude_typz_typz_id_seq OWNED BY public.tr_type_zone_etude_typz.typz_id;


--
-- TOC entry 314 (class 1259 OID 648493)
-- Name: tr_unite_uni_uni_id_seq; Type: SEQUENCE; Schema: public; Owner: arboretum
--

CREATE SEQUENCE public.tr_unite_uni_uni_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.tr_unite_uni_uni_id_seq OWNER TO arboretum;

--
-- TOC entry 5128 (class 0 OID 0)
-- Dependencies: 314
-- Name: tr_unite_uni_uni_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: arboretum
--

ALTER SEQUENCE public.tr_unite_uni_uni_id_seq OWNED BY public.tr_unite_uni.uni_id;


--
-- TOC entry 315 (class 1259 OID 648494)
-- Name: tr_variable_var_var_id_seq; Type: SEQUENCE; Schema: public; Owner: arboretum
--

CREATE SEQUENCE public.tr_variable_var_var_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.tr_variable_var_var_id_seq OWNER TO arboretum;

--
-- TOC entry 5130 (class 0 OID 0)
-- Dependencies: 315
-- Name: tr_variable_var_var_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: arboretum
--

ALTER SEQUENCE public.tr_variable_var_var_id_seq OWNED BY public.tr_variable_var.var_id;


--
-- TOC entry 316 (class 1259 OID 648495)
-- Name: tr_zone_etude_zon_zon_id_seq; Type: SEQUENCE; Schema: public; Owner: arboretum
--

CREATE SEQUENCE public.tr_zone_etude_zon_zon_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.tr_zone_etude_zon_zon_id_seq OWNER TO arboretum;

--
-- TOC entry 5132 (class 0 OID 0)
-- Dependencies: 316
-- Name: tr_zone_etude_zon_zon_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: arboretum
--

ALTER SEQUENCE public.tr_zone_etude_zon_zon_id_seq OWNED BY public.tr_zone_etude_zon.zon_id;


--
-- TOC entry 4589 (class 2604 OID 648569)
-- Name: t_arbre_arb arb_id; Type: DEFAULT; Schema: public; Owner: arboretum
--

ALTER TABLE ONLY public.t_arbre_arb ALTER COLUMN arb_id SET DEFAULT nextval('public.t_arbre_arb_arb_id_seq'::regclass);


--
-- TOC entry 4597 (class 2604 OID 648570)
-- Name: t_formulaire_access_configuration_faconf faconf_id; Type: DEFAULT; Schema: public; Owner: arboretum
--

ALTER TABLE ONLY public.t_formulaire_access_configuration_faconf ALTER COLUMN faconf_id SET DEFAULT nextval('public.t_formulaire_access_configuration_faconf_faconf_id_seq'::regclass);


--
-- TOC entry 4590 (class 2604 OID 648571)
-- Name: t_mesure_marb marb_id; Type: DEFAULT; Schema: public; Owner: arboretum
--

ALTER TABLE ONLY public.t_mesure_marb ALTER COLUMN marb_id SET DEFAULT nextval('public.t_mesure_marb_marb_id_seq'::regclass);


--
-- TOC entry 4598 (class 2604 OID 648572)
-- Name: t_regroupement_rgp rgp_id; Type: DEFAULT; Schema: public; Owner: arboretum
--

ALTER TABLE ONLY public.t_regroupement_rgp ALTER COLUMN rgp_id SET DEFAULT nextval('public.t_regroupement_rgp_rgp_id_seq'::regclass);


--
-- TOC entry 4599 (class 2604 OID 648573)
-- Name: tr_classement_clas clas_id; Type: DEFAULT; Schema: public; Owner: arboretum
--

ALTER TABLE ONLY public.tr_classement_clas ALTER COLUMN clas_id SET DEFAULT nextval('public.tr_classement_clas_clas_id_seq'::regclass);


--
-- TOC entry 4600 (class 2604 OID 648574)
-- Name: tr_fichier_fic fic_id; Type: DEFAULT; Schema: public; Owner: arboretum
--

ALTER TABLE ONLY public.tr_fichier_fic ALTER COLUMN fic_id SET DEFAULT nextval('public.tr_fichier_fic_fic_id_seq'::regclass);


--
-- TOC entry 4601 (class 2604 OID 648575)
-- Name: tr_norme_norm norm_id; Type: DEFAULT; Schema: public; Owner: arboretum
--

ALTER TABLE ONLY public.tr_norme_norm ALTER COLUMN norm_id SET DEFAULT nextval('public.tr_norme_norm_norm_id_seq'::regclass);


--
-- TOC entry 4602 (class 2604 OID 648576)
-- Name: tr_operateur_ope ope_id; Type: DEFAULT; Schema: public; Owner: arboretum
--

ALTER TABLE ONLY public.tr_operateur_ope ALTER COLUMN ope_id SET DEFAULT nextval('public.tr_operateur_ope_ope_id_seq'::regclass);


--
-- TOC entry 4603 (class 2604 OID 648577)
-- Name: tr_protocole_prot prot_id; Type: DEFAULT; Schema: public; Owner: arboretum
--

ALTER TABLE ONLY public.tr_protocole_prot ALTER COLUMN prot_id SET DEFAULT nextval('public.tr_protocole_prot_prot_id_seq'::regclass);


--
-- TOC entry 4596 (class 2604 OID 648578)
-- Name: tr_provenance_prov prov_id; Type: DEFAULT; Schema: public; Owner: arboretum
--

ALTER TABLE ONLY public.tr_provenance_prov ALTER COLUMN prov_id SET DEFAULT nextval('public.tr_provenance_prov_prov_id_seq'::regclass);


--
-- TOC entry 4604 (class 2604 OID 648579)
-- Name: tr_referentiel_taxonomique_ref ref_id; Type: DEFAULT; Schema: public; Owner: arboretum
--

ALTER TABLE ONLY public.tr_referentiel_taxonomique_ref ALTER COLUMN ref_id SET DEFAULT nextval('public.tr_referentiel_ref_ref_id_seq'::regclass);


--
-- TOC entry 4605 (class 2604 OID 648580)
-- Name: tr_role_rol rol_id; Type: DEFAULT; Schema: public; Owner: arboretum
--

ALTER TABLE ONLY public.tr_role_rol ALTER COLUMN rol_id SET DEFAULT nextval('public.tr_role_rol_rol_id_seq'::regclass);


--
-- TOC entry 4591 (class 2604 OID 648581)
-- Name: tr_taxon_tax tax_id; Type: DEFAULT; Schema: public; Owner: arboretum
--

ALTER TABLE ONLY public.tr_taxon_tax ALTER COLUMN tax_id SET DEFAULT nextval('public.tr_taxon_tax_tax_id_seq'::regclass);


--
-- TOC entry 4592 (class 2604 OID 648582)
-- Name: tr_type_mesure_typm typm_id; Type: DEFAULT; Schema: public; Owner: arboretum
--

ALTER TABLE ONLY public.tr_type_mesure_typm ALTER COLUMN typm_id SET DEFAULT nextval('public.tr_type_mesure_typm_typm_id_seq'::regclass);


--
-- TOC entry 4606 (class 2604 OID 648583)
-- Name: tr_type_zone_etude_typz typz_id; Type: DEFAULT; Schema: public; Owner: arboretum
--

ALTER TABLE ONLY public.tr_type_zone_etude_typz ALTER COLUMN typz_id SET DEFAULT nextval('public.tr_type_zone_etude_typz_typz_id_seq'::regclass);


--
-- TOC entry 4593 (class 2604 OID 648584)
-- Name: tr_unite_uni uni_id; Type: DEFAULT; Schema: public; Owner: arboretum
--

ALTER TABLE ONLY public.tr_unite_uni ALTER COLUMN uni_id SET DEFAULT nextval('public.tr_unite_uni_uni_id_seq'::regclass);


--
-- TOC entry 4594 (class 2604 OID 648585)
-- Name: tr_variable_var var_id; Type: DEFAULT; Schema: public; Owner: arboretum
--

ALTER TABLE ONLY public.tr_variable_var ALTER COLUMN var_id SET DEFAULT nextval('public.tr_variable_var_var_id_seq'::regclass);


--
-- TOC entry 4595 (class 2604 OID 648586)
-- Name: tr_zone_etude_zon zon_id; Type: DEFAULT; Schema: public; Owner: arboretum
--

ALTER TABLE ONLY public.tr_zone_etude_zon ALTER COLUMN zon_id SET DEFAULT nextval('public.tr_zone_etude_zon_zon_id_seq'::regclass);


--
-- TOC entry 4618 (class 2606 OID 648642)
-- Name: t_mesure_marb c_uni_arb_var_datemesure_marb; Type: CONSTRAINT; Schema: public; Owner: arboretum
--

ALTER TABLE ONLY public.t_mesure_marb
    ADD CONSTRAINT c_uni_arb_var_datemesure_marb UNIQUE (marb_arb_id, marb_var_id, marb_date_mesure);


--
-- TOC entry 5134 (class 0 OID 0)
-- Dependencies: 4618
-- Name: CONSTRAINT c_uni_arb_var_datemesure_marb ON t_mesure_marb; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON CONSTRAINT c_uni_arb_var_datemesure_marb ON public.t_mesure_marb IS 'L''ensemble identifiant de l''objet /identifiant de la variable / date de la mesure est unique';


--
-- TOC entry 4714 (class 2606 OID 648644)
-- Name: tr_referentiel_taxonomique_ref c_uni_code_ref; Type: CONSTRAINT; Schema: public; Owner: arboretum
--

ALTER TABLE ONLY public.tr_referentiel_taxonomique_ref
    ADD CONSTRAINT c_uni_code_ref UNIQUE (ref_code);


--
-- TOC entry 5135 (class 0 OID 0)
-- Dependencies: 4714
-- Name: CONSTRAINT c_uni_code_ref ON tr_referentiel_taxonomique_ref; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON CONSTRAINT c_uni_code_ref ON public.tr_referentiel_taxonomique_ref IS 'le code du référentiel est unique';


--
-- TOC entry 4663 (class 2606 OID 648646)
-- Name: t_regroupement_rgp c_uni_code_rgp; Type: CONSTRAINT; Schema: public; Owner: arboretum
--

ALTER TABLE ONLY public.t_regroupement_rgp
    ADD CONSTRAINT c_uni_code_rgp UNIQUE (rgp_code);


--
-- TOC entry 5136 (class 0 OID 0)
-- Dependencies: 4663
-- Name: CONSTRAINT c_uni_code_rgp ON t_regroupement_rgp; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON CONSTRAINT c_uni_code_rgp ON public.t_regroupement_rgp IS 'Le code d''un regroupement doit être unique';


--
-- TOC entry 4637 (class 2606 OID 648648)
-- Name: tr_type_mesure_typm c_uni_code_typm; Type: CONSTRAINT; Schema: public; Owner: arboretum
--

ALTER TABLE ONLY public.tr_type_mesure_typm
    ADD CONSTRAINT c_uni_code_typm UNIQUE (typm_code);


--
-- TOC entry 5137 (class 0 OID 0)
-- Dependencies: 4637
-- Name: CONSTRAINT c_uni_code_typm ON tr_type_mesure_typm; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON CONSTRAINT c_uni_code_typm ON public.tr_type_mesure_typm IS 'Le code du type de mesure doit être unique';


--
-- TOC entry 4724 (class 2606 OID 648650)
-- Name: tr_type_zone_etude_typz c_uni_code_typz; Type: CONSTRAINT; Schema: public; Owner: arboretum
--

ALTER TABLE ONLY public.tr_type_zone_etude_typz
    ADD CONSTRAINT c_uni_code_typz UNIQUE (typz_code);


--
-- TOC entry 5138 (class 0 OID 0)
-- Dependencies: 4724
-- Name: CONSTRAINT c_uni_code_typz ON tr_type_zone_etude_typz; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON CONSTRAINT c_uni_code_typz ON public.tr_type_zone_etude_typz IS 'Le code d''un type de zone d''étude doit être unique';


--
-- TOC entry 4647 (class 2606 OID 648652)
-- Name: tr_variable_var c_uni_code_var; Type: CONSTRAINT; Schema: public; Owner: arboretum
--

ALTER TABLE ONLY public.tr_variable_var
    ADD CONSTRAINT c_uni_code_var UNIQUE (var_code);


--
-- TOC entry 5139 (class 0 OID 0)
-- Dependencies: 4647
-- Name: CONSTRAINT c_uni_code_var ON tr_variable_var; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON CONSTRAINT c_uni_code_var ON public.tr_variable_var IS 'Le code d''une variable doit être unique';


--
-- TOC entry 4608 (class 2606 OID 648654)
-- Name: t_arbre_arb c_uni_etiquette_zone_arb; Type: CONSTRAINT; Schema: public; Owner: arboretum
--

ALTER TABLE ONLY public.t_arbre_arb
    ADD CONSTRAINT c_uni_etiquette_zone_arb UNIQUE (arb_etiquette, arb_zon_id);


--
-- TOC entry 5140 (class 0 OID 0)
-- Dependencies: 4608
-- Name: CONSTRAINT c_uni_etiquette_zone_arb ON t_arbre_arb; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON CONSTRAINT c_uni_etiquette_zone_arb ON public.t_arbre_arb IS 'L''ensemble Etiquette / Zone est unique';


--
-- TOC entry 4716 (class 2606 OID 648656)
-- Name: tr_referentiel_taxonomique_ref c_uni_lib_ver_ref; Type: CONSTRAINT; Schema: public; Owner: arboretum
--

ALTER TABLE ONLY public.tr_referentiel_taxonomique_ref
    ADD CONSTRAINT c_uni_lib_ver_ref UNIQUE (ref_libelle, ref_version);


--
-- TOC entry 5141 (class 0 OID 0)
-- Dependencies: 4716
-- Name: CONSTRAINT c_uni_lib_ver_ref ON tr_referentiel_taxonomique_ref; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON CONSTRAINT c_uni_lib_ver_ref ON public.tr_referentiel_taxonomique_ref IS 'le couple libellé / version du référentiel est unique';


--
-- TOC entry 4720 (class 2606 OID 648658)
-- Name: tr_role_rol c_uni_libelle_rol; Type: CONSTRAINT; Schema: public; Owner: arboretum
--

ALTER TABLE ONLY public.tr_role_rol
    ADD CONSTRAINT c_uni_libelle_rol UNIQUE (rol_libelle);


--
-- TOC entry 5142 (class 0 OID 0)
-- Dependencies: 4720
-- Name: CONSTRAINT c_uni_libelle_rol ON tr_role_rol; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON CONSTRAINT c_uni_libelle_rol ON public.tr_role_rol IS 'Le libellé d''un role doit être unique';


--
-- TOC entry 4706 (class 2606 OID 648660)
-- Name: tr_operateur_ope c_uni_nom_prenom_ope; Type: CONSTRAINT; Schema: public; Owner: arboretum
--

ALTER TABLE ONLY public.tr_operateur_ope
    ADD CONSTRAINT c_uni_nom_prenom_ope UNIQUE (ope_nom, ope_prenom);


--
-- TOC entry 5143 (class 0 OID 0)
-- Dependencies: 4706
-- Name: CONSTRAINT c_uni_nom_prenom_ope ON tr_operateur_ope; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON CONSTRAINT c_uni_nom_prenom_ope ON public.tr_operateur_ope IS 'Le couple nom / prénom d''un opérateur doit être unique';


--
-- TOC entry 4710 (class 2606 OID 648662)
-- Name: tr_protocole_prot c_uni_nom_prot; Type: CONSTRAINT; Schema: public; Owner: arboretum
--

ALTER TABLE ONLY public.tr_protocole_prot
    ADD CONSTRAINT c_uni_nom_prot UNIQUE (prot_nom);


--
-- TOC entry 5144 (class 0 OID 0)
-- Dependencies: 4710
-- Name: CONSTRAINT c_uni_nom_prot ON tr_protocole_prot; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON CONSTRAINT c_uni_nom_prot ON public.tr_protocole_prot IS 'Le nom du protocole doit être unique';


--
-- TOC entry 4657 (class 2606 OID 648664)
-- Name: tr_provenance_prov c_uni_nom_prov; Type: CONSTRAINT; Schema: public; Owner: arboretum
--

ALTER TABLE ONLY public.tr_provenance_prov
    ADD CONSTRAINT c_uni_nom_prov UNIQUE (prov_nom);


--
-- TOC entry 5145 (class 0 OID 0)
-- Dependencies: 4657
-- Name: CONSTRAINT c_uni_nom_prov ON tr_provenance_prov; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON CONSTRAINT c_uni_nom_prov ON public.tr_provenance_prov IS 'Le nom de la provenance est unique';


--
-- TOC entry 4641 (class 2606 OID 648666)
-- Name: tr_unite_uni c_uni_nom_uni; Type: CONSTRAINT; Schema: public; Owner: arboretum
--

ALTER TABLE ONLY public.tr_unite_uni
    ADD CONSTRAINT c_uni_nom_uni UNIQUE (uni_nom);


--
-- TOC entry 5146 (class 0 OID 0)
-- Dependencies: 4641
-- Name: CONSTRAINT c_uni_nom_uni ON tr_unite_uni; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON CONSTRAINT c_uni_nom_uni ON public.tr_unite_uni IS 'Le nom d''une unité doit être unique';


--
-- TOC entry 4698 (class 2606 OID 648668)
-- Name: tr_fichier_fic c_uni_nom_url_fic; Type: CONSTRAINT; Schema: public; Owner: arboretum
--

ALTER TABLE ONLY public.tr_fichier_fic
    ADD CONSTRAINT c_uni_nom_url_fic UNIQUE (fic_nom, fic_url);


--
-- TOC entry 5147 (class 0 OID 0)
-- Dependencies: 4698
-- Name: CONSTRAINT c_uni_nom_url_fic ON tr_fichier_fic; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON CONSTRAINT c_uni_nom_url_fic ON public.tr_fichier_fic IS 'Le couple nom / url d''un fichier doit être unique';


--
-- TOC entry 4702 (class 2606 OID 648670)
-- Name: tr_norme_norm c_uni_nom_version_norm; Type: CONSTRAINT; Schema: public; Owner: arboretum
--

ALTER TABLE ONLY public.tr_norme_norm
    ADD CONSTRAINT c_uni_nom_version_norm UNIQUE (norm_nom, norm_version);


--
-- TOC entry 5148 (class 0 OID 0)
-- Dependencies: 4702
-- Name: CONSTRAINT c_uni_nom_version_norm ON tr_norme_norm; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON CONSTRAINT c_uni_nom_version_norm ON public.tr_norme_norm IS 'Le couple nom / version d''une norme doit être unique';


--
-- TOC entry 4630 (class 2606 OID 648672)
-- Name: tr_taxon_tax c_uni_ref_identifiant_ext_tax; Type: CONSTRAINT; Schema: public; Owner: arboretum
--

ALTER TABLE ONLY public.tr_taxon_tax
    ADD CONSTRAINT c_uni_ref_identifiant_ext_tax UNIQUE (tax_ref_id, tax_identifiant_ext);


--
-- TOC entry 5149 (class 0 OID 0)
-- Dependencies: 4630
-- Name: CONSTRAINT c_uni_ref_identifiant_ext_tax ON tr_taxon_tax; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON CONSTRAINT c_uni_ref_identifiant_ext_tax ON public.tr_taxon_tax IS 'le couple référentiel / identifiant extérieur est unique';


--
-- TOC entry 4632 (class 2606 OID 648674)
-- Name: tr_taxon_tax c_uni_ref_libelle_tax; Type: CONSTRAINT; Schema: public; Owner: arboretum
--

ALTER TABLE ONLY public.tr_taxon_tax
    ADD CONSTRAINT c_uni_ref_libelle_tax UNIQUE (tax_ref_id, tax_libelle);


--
-- TOC entry 5150 (class 0 OID 0)
-- Dependencies: 4632
-- Name: CONSTRAINT c_uni_ref_libelle_tax ON tr_taxon_tax; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON CONSTRAINT c_uni_ref_libelle_tax ON public.tr_taxon_tax IS 'le couple référentiel / libellé est unique';


--
-- TOC entry 4643 (class 2606 OID 648676)
-- Name: tr_unite_uni c_uni_symbole_uni; Type: CONSTRAINT; Schema: public; Owner: arboretum
--

ALTER TABLE ONLY public.tr_unite_uni
    ADD CONSTRAINT c_uni_symbole_uni UNIQUE (uni_symbole);


--
-- TOC entry 5151 (class 0 OID 0)
-- Dependencies: 4643
-- Name: CONSTRAINT c_uni_symbole_uni ON tr_unite_uni; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON CONSTRAINT c_uni_symbole_uni ON public.tr_unite_uni IS 'Le symbole d''une unité doit être unique';


--
-- TOC entry 4694 (class 2606 OID 648678)
-- Name: tr_classement_clas c_uni_tree_clas; Type: CONSTRAINT; Schema: public; Owner: arboretum
--

ALTER TABLE ONLY public.tr_classement_clas
    ADD CONSTRAINT c_uni_tree_clas UNIQUE (clas_tree);


--
-- TOC entry 5152 (class 0 OID 0)
-- Dependencies: 4694
-- Name: CONSTRAINT c_uni_tree_clas ON tr_classement_clas; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON CONSTRAINT c_uni_tree_clas ON public.tr_classement_clas IS 'L''arborescence ltree du classement est unique';


--
-- TOC entry 4651 (class 2606 OID 648680)
-- Name: tr_zone_etude_zon c_uni_tree_zon; Type: CONSTRAINT; Schema: public; Owner: arboretum
--

ALTER TABLE ONLY public.tr_zone_etude_zon
    ADD CONSTRAINT c_uni_tree_zon UNIQUE (zon_tree);


--
-- TOC entry 5153 (class 0 OID 0)
-- Dependencies: 4651
-- Name: CONSTRAINT c_uni_tree_zon ON tr_zone_etude_zon; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON CONSTRAINT c_uni_tree_zon ON public.tr_zone_etude_zon IS 'L''arborescence complète d''une zone d''étude doit être unique';


--
-- TOC entry 4610 (class 2606 OID 648692)
-- Name: t_arbre_arb t_arbre_arb_pkey; Type: CONSTRAINT; Schema: public; Owner: arboretum
--

ALTER TABLE ONLY public.t_arbre_arb
    ADD CONSTRAINT t_arbre_arb_pkey PRIMARY KEY (arb_id);


--
-- TOC entry 4661 (class 2606 OID 648694)
-- Name: t_formulaire_access_configuration_faconf t_formulaire_access_configuration_faconf_pkey; Type: CONSTRAINT; Schema: public; Owner: arboretum
--

ALTER TABLE ONLY public.t_formulaire_access_configuration_faconf
    ADD CONSTRAINT t_formulaire_access_configuration_faconf_pkey PRIMARY KEY (faconf_id);


--
-- TOC entry 4621 (class 2606 OID 648696)
-- Name: t_mesure_marb t_mesure_marb_pkey; Type: CONSTRAINT; Schema: public; Owner: arboretum
--

ALTER TABLE ONLY public.t_mesure_marb
    ADD CONSTRAINT t_mesure_marb_pkey PRIMARY KEY (marb_id);


--
-- TOC entry 4665 (class 2606 OID 648698)
-- Name: t_regroupement_rgp t_regroupement_rgp_pkey; Type: CONSTRAINT; Schema: public; Owner: arboretum
--

ALTER TABLE ONLY public.t_regroupement_rgp
    ADD CONSTRAINT t_regroupement_rgp_pkey PRIMARY KEY (rgp_id);


--
-- TOC entry 4672 (class 2606 OID 648700)
-- Name: tj_classervar_cvar tj_classervar_cvar_pkey; Type: CONSTRAINT; Schema: public; Owner: arboretum
--

ALTER TABLE ONLY public.tj_classervar_cvar
    ADD CONSTRAINT tj_classervar_cvar_pkey PRIMARY KEY (cvar_var_id, cvar_clas_id);


--
-- TOC entry 4676 (class 2606 OID 648702)
-- Name: tj_marb_marb_tarb tj_marb_marb_tarb_pkey; Type: CONSTRAINT; Schema: public; Owner: arboretum
--

ALTER TABLE ONLY public.tj_marb_marb_tarb
    ADD CONSTRAINT tj_marb_marb_tarb_pkey PRIMARY KEY (tarb_ref_marb_id, tarb_meta_marb_id);


--
-- TOC entry 4680 (class 2606 OID 648704)
-- Name: tj_rgp_marb_gma tj_rgp_marb_gma_pkey; Type: CONSTRAINT; Schema: public; Owner: arboretum
--

ALTER TABLE ONLY public.tj_rgp_marb_gma
    ADD CONSTRAINT tj_rgp_marb_gma_pkey PRIMARY KEY (gma_marb_id, gma_rgp_id);


--
-- TOC entry 4684 (class 2606 OID 648706)
-- Name: tj_role_ope_marb_roa tj_role_ope_marb_roa_pkey; Type: CONSTRAINT; Schema: public; Owner: arboretum
--

ALTER TABLE ONLY public.tj_role_ope_marb_roa
    ADD CONSTRAINT tj_role_ope_marb_roa_pkey PRIMARY KEY (roa_marb_id, roa_ope_id, roa_rol_id);


--
-- TOC entry 4689 (class 2606 OID 648708)
-- Name: tj_role_ope_rgp_ror tj_role_ope_rgp_ror_pkey; Type: CONSTRAINT; Schema: public; Owner: arboretum
--

ALTER TABLE ONLY public.tj_role_ope_rgp_ror
    ADD CONSTRAINT tj_role_ope_rgp_ror_pkey PRIMARY KEY (ror_rgp_id, ror_ope_id, ror_rol_id);


--
-- TOC entry 4696 (class 2606 OID 648710)
-- Name: tr_classement_clas tr_classement_clas_pkey; Type: CONSTRAINT; Schema: public; Owner: arboretum
--

ALTER TABLE ONLY public.tr_classement_clas
    ADD CONSTRAINT tr_classement_clas_pkey PRIMARY KEY (clas_id);


--
-- TOC entry 4700 (class 2606 OID 648712)
-- Name: tr_fichier_fic tr_fichier_fic_pkey; Type: CONSTRAINT; Schema: public; Owner: arboretum
--

ALTER TABLE ONLY public.tr_fichier_fic
    ADD CONSTRAINT tr_fichier_fic_pkey PRIMARY KEY (fic_id);


--
-- TOC entry 4704 (class 2606 OID 648714)
-- Name: tr_norme_norm tr_norme_norm_pkey; Type: CONSTRAINT; Schema: public; Owner: arboretum
--

ALTER TABLE ONLY public.tr_norme_norm
    ADD CONSTRAINT tr_norme_norm_pkey PRIMARY KEY (norm_id);


--
-- TOC entry 4708 (class 2606 OID 648716)
-- Name: tr_operateur_ope tr_operateur_ope_pkey; Type: CONSTRAINT; Schema: public; Owner: arboretum
--

ALTER TABLE ONLY public.tr_operateur_ope
    ADD CONSTRAINT tr_operateur_ope_pkey PRIMARY KEY (ope_id);


--
-- TOC entry 4712 (class 2606 OID 648718)
-- Name: tr_protocole_prot tr_protocole_prot_pkey; Type: CONSTRAINT; Schema: public; Owner: arboretum
--

ALTER TABLE ONLY public.tr_protocole_prot
    ADD CONSTRAINT tr_protocole_prot_pkey PRIMARY KEY (prot_id);


--
-- TOC entry 4659 (class 2606 OID 648720)
-- Name: tr_provenance_prov tr_provenance_prov_pkey; Type: CONSTRAINT; Schema: public; Owner: arboretum
--

ALTER TABLE ONLY public.tr_provenance_prov
    ADD CONSTRAINT tr_provenance_prov_pkey PRIMARY KEY (prov_id);


--
-- TOC entry 4718 (class 2606 OID 648722)
-- Name: tr_referentiel_taxonomique_ref tr_referentiel_ref_pkey; Type: CONSTRAINT; Schema: public; Owner: arboretum
--

ALTER TABLE ONLY public.tr_referentiel_taxonomique_ref
    ADD CONSTRAINT tr_referentiel_ref_pkey PRIMARY KEY (ref_id);


--
-- TOC entry 4722 (class 2606 OID 648724)
-- Name: tr_role_rol tr_role_rol_pkey; Type: CONSTRAINT; Schema: public; Owner: arboretum
--

ALTER TABLE ONLY public.tr_role_rol
    ADD CONSTRAINT tr_role_rol_pkey PRIMARY KEY (rol_id);


--
-- TOC entry 4634 (class 2606 OID 648726)
-- Name: tr_taxon_tax tr_taxon_tax_pkey; Type: CONSTRAINT; Schema: public; Owner: arboretum
--

ALTER TABLE ONLY public.tr_taxon_tax
    ADD CONSTRAINT tr_taxon_tax_pkey PRIMARY KEY (tax_id);


--
-- TOC entry 4639 (class 2606 OID 648728)
-- Name: tr_type_mesure_typm tr_type_mesure_typm_pkey; Type: CONSTRAINT; Schema: public; Owner: arboretum
--

ALTER TABLE ONLY public.tr_type_mesure_typm
    ADD CONSTRAINT tr_type_mesure_typm_pkey PRIMARY KEY (typm_id);


--
-- TOC entry 4726 (class 2606 OID 648730)
-- Name: tr_type_zone_etude_typz tr_type_zone_etude_typz_pkey; Type: CONSTRAINT; Schema: public; Owner: arboretum
--

ALTER TABLE ONLY public.tr_type_zone_etude_typz
    ADD CONSTRAINT tr_type_zone_etude_typz_pkey PRIMARY KEY (typz_id);


--
-- TOC entry 4645 (class 2606 OID 648732)
-- Name: tr_unite_uni tr_unite_uni_pkey; Type: CONSTRAINT; Schema: public; Owner: arboretum
--

ALTER TABLE ONLY public.tr_unite_uni
    ADD CONSTRAINT tr_unite_uni_pkey PRIMARY KEY (uni_id);


--
-- TOC entry 4649 (class 2606 OID 648734)
-- Name: tr_variable_var tr_variable_var_pkey; Type: CONSTRAINT; Schema: public; Owner: arboretum
--

ALTER TABLE ONLY public.tr_variable_var
    ADD CONSTRAINT tr_variable_var_pkey PRIMARY KEY (var_id);


--
-- TOC entry 4653 (class 2606 OID 648736)
-- Name: tr_zone_etude_zon tr_zone_etude_zon_pkey; Type: CONSTRAINT; Schema: public; Owner: arboretum
--

ALTER TABLE ONLY public.tr_zone_etude_zon
    ADD CONSTRAINT tr_zone_etude_zon_pkey PRIMARY KEY (zon_id);


--
-- TOC entry 4619 (class 1259 OID 648755)
-- Name: c_uni_arb_var_marb; Type: INDEX; Schema: public; Owner: arboretum
--

CREATE UNIQUE INDEX c_uni_arb_var_marb ON public.t_mesure_marb USING btree (marb_arb_id, marb_var_id) WHERE (marb_date_mesure IS NULL);


--
-- TOC entry 5154 (class 0 OID 0)
-- Dependencies: 4619
-- Name: INDEX c_uni_arb_var_marb; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON INDEX public.c_uni_arb_var_marb IS 'Le couple variable / objet est unique si la date de mesure est non renseignée.';


--
-- TOC entry 4673 (class 1259 OID 648756)
-- Name: x_btr_clas_cvar; Type: INDEX; Schema: public; Owner: arboretum
--

CREATE INDEX x_btr_clas_cvar ON public.tj_classervar_cvar USING btree (cvar_clas_id);


--
-- TOC entry 5155 (class 0 OID 0)
-- Dependencies: 4673
-- Name: INDEX x_btr_clas_cvar; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON INDEX public.x_btr_clas_cvar IS 'Index de clé étrangère pour accélérer les mises à jour / suppression';


--
-- TOC entry 4622 (class 1259 OID 648757)
-- Name: x_btr_fkey_arb_marb; Type: INDEX; Schema: public; Owner: arboretum
--

CREATE INDEX x_btr_fkey_arb_marb ON public.t_mesure_marb USING btree (marb_arb_id);


--
-- TOC entry 5156 (class 0 OID 0)
-- Dependencies: 4622
-- Name: INDEX x_btr_fkey_arb_marb; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON INDEX public.x_btr_fkey_arb_marb IS 'Index de clé étrangère pour accélérer les mises à jour / suppression';


--
-- TOC entry 4623 (class 1259 OID 648758)
-- Name: x_btr_fkey_fic_marb; Type: INDEX; Schema: public; Owner: arboretum
--

CREATE INDEX x_btr_fkey_fic_marb ON public.t_mesure_marb USING btree (marb_fic_id);


--
-- TOC entry 5157 (class 0 OID 0)
-- Dependencies: 4623
-- Name: INDEX x_btr_fkey_fic_marb; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON INDEX public.x_btr_fkey_fic_marb IS 'Index de clé étrangère pour accélérer les mises à jour / suppression';


--
-- TOC entry 4666 (class 1259 OID 648759)
-- Name: x_btr_fkey_fic_rgp; Type: INDEX; Schema: public; Owner: arboretum
--

CREATE INDEX x_btr_fkey_fic_rgp ON public.t_regroupement_rgp USING btree (rgp_fic_id);


--
-- TOC entry 5158 (class 0 OID 0)
-- Dependencies: 4666
-- Name: INDEX x_btr_fkey_fic_rgp; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON INDEX public.x_btr_fkey_fic_rgp IS 'Index de clé étrangère pour accélérer les mises à jour / suppression';


--
-- TOC entry 4624 (class 1259 OID 648760)
-- Name: x_btr_fkey_norm_marb; Type: INDEX; Schema: public; Owner: arboretum
--

CREATE INDEX x_btr_fkey_norm_marb ON public.t_mesure_marb USING btree (marb_norm_id);


--
-- TOC entry 5159 (class 0 OID 0)
-- Dependencies: 4624
-- Name: INDEX x_btr_fkey_norm_marb; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON INDEX public.x_btr_fkey_norm_marb IS 'Index de clé étrangère pour accélérer les mises à jour / suppression';


--
-- TOC entry 4667 (class 1259 OID 648761)
-- Name: x_btr_fkey_norm_rgp; Type: INDEX; Schema: public; Owner: arboretum
--

CREATE INDEX x_btr_fkey_norm_rgp ON public.t_regroupement_rgp USING btree (rgp_norm_id);


--
-- TOC entry 5160 (class 0 OID 0)
-- Dependencies: 4667
-- Name: INDEX x_btr_fkey_norm_rgp; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON INDEX public.x_btr_fkey_norm_rgp IS 'Index de clé étrangère pour accélérer les mises à jour / suppression';


--
-- TOC entry 4625 (class 1259 OID 648762)
-- Name: x_btr_fkey_prot_marb; Type: INDEX; Schema: public; Owner: arboretum
--

CREATE INDEX x_btr_fkey_prot_marb ON public.t_mesure_marb USING btree (marb_prot_id);


--
-- TOC entry 5161 (class 0 OID 0)
-- Dependencies: 4625
-- Name: INDEX x_btr_fkey_prot_marb; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON INDEX public.x_btr_fkey_prot_marb IS 'Index de clé étrangère pour accélérer les mises à jour / suppression';


--
-- TOC entry 4668 (class 1259 OID 648763)
-- Name: x_btr_fkey_prot_rgp; Type: INDEX; Schema: public; Owner: arboretum
--

CREATE INDEX x_btr_fkey_prot_rgp ON public.t_regroupement_rgp USING btree (rgp_prot_id);


--
-- TOC entry 5162 (class 0 OID 0)
-- Dependencies: 4668
-- Name: INDEX x_btr_fkey_prot_rgp; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON INDEX public.x_btr_fkey_prot_rgp IS 'Index de clé étrangère pour accélérer les mises à jour / suppression';


--
-- TOC entry 4635 (class 1259 OID 648764)
-- Name: x_btr_fkey_ref_tax; Type: INDEX; Schema: public; Owner: arboretum
--

CREATE INDEX x_btr_fkey_ref_tax ON public.tr_taxon_tax USING btree (tax_ref_id);


--
-- TOC entry 5163 (class 0 OID 0)
-- Dependencies: 4635
-- Name: INDEX x_btr_fkey_ref_tax; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON INDEX public.x_btr_fkey_ref_tax IS 'index de clé étrangère pour accélérer les mises à jour / suppression';


--
-- TOC entry 4626 (class 1259 OID 648765)
-- Name: x_btr_fkey_typm_marb; Type: INDEX; Schema: public; Owner: arboretum
--

CREATE INDEX x_btr_fkey_typm_marb ON public.t_mesure_marb USING btree (marb_typm_id);


--
-- TOC entry 5164 (class 0 OID 0)
-- Dependencies: 4626
-- Name: INDEX x_btr_fkey_typm_marb; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON INDEX public.x_btr_fkey_typm_marb IS 'Index de clé étrangère pour accélérer les mises à jour / suppression';


--
-- TOC entry 4669 (class 1259 OID 648766)
-- Name: x_btr_fkey_typm_rgp; Type: INDEX; Schema: public; Owner: arboretum
--

CREATE INDEX x_btr_fkey_typm_rgp ON public.t_regroupement_rgp USING btree (rgp_typm_id);


--
-- TOC entry 5165 (class 0 OID 0)
-- Dependencies: 4669
-- Name: INDEX x_btr_fkey_typm_rgp; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON INDEX public.x_btr_fkey_typm_rgp IS 'Index de clé étrangère pour accélérer les mises à jour / suppression';


--
-- TOC entry 4654 (class 1259 OID 648767)
-- Name: x_btr_fkey_typz_zon; Type: INDEX; Schema: public; Owner: arboretum
--

CREATE INDEX x_btr_fkey_typz_zon ON public.tr_zone_etude_zon USING btree (zon_typz_id);


--
-- TOC entry 5166 (class 0 OID 0)
-- Dependencies: 4654
-- Name: INDEX x_btr_fkey_typz_zon; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON INDEX public.x_btr_fkey_typz_zon IS 'Index de clé étrangère pour accélérer les mises à jour / suppression';


--
-- TOC entry 4627 (class 1259 OID 648768)
-- Name: x_btr_fkey_uni_marb; Type: INDEX; Schema: public; Owner: arboretum
--

CREATE INDEX x_btr_fkey_uni_marb ON public.t_mesure_marb USING btree (marb_uni_id);


--
-- TOC entry 5167 (class 0 OID 0)
-- Dependencies: 4627
-- Name: INDEX x_btr_fkey_uni_marb; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON INDEX public.x_btr_fkey_uni_marb IS 'Index de clé étrangère pour accélérer les mises à jour / suppression';


--
-- TOC entry 4670 (class 1259 OID 648769)
-- Name: x_btr_fkey_uni_rgp; Type: INDEX; Schema: public; Owner: arboretum
--

CREATE INDEX x_btr_fkey_uni_rgp ON public.t_regroupement_rgp USING btree (rgp_uni_id);


--
-- TOC entry 5168 (class 0 OID 0)
-- Dependencies: 4670
-- Name: INDEX x_btr_fkey_uni_rgp; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON INDEX public.x_btr_fkey_uni_rgp IS 'Index de clé étrangère pour accélérer les mises à jour / suppression';


--
-- TOC entry 4628 (class 1259 OID 648770)
-- Name: x_btr_fkey_var_marb; Type: INDEX; Schema: public; Owner: arboretum
--

CREATE INDEX x_btr_fkey_var_marb ON public.t_mesure_marb USING btree (marb_var_id);


--
-- TOC entry 5169 (class 0 OID 0)
-- Dependencies: 4628
-- Name: INDEX x_btr_fkey_var_marb; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON INDEX public.x_btr_fkey_var_marb IS 'Index de clé étrangère pour accélérer les mises à jour / suppression';


--
-- TOC entry 4681 (class 1259 OID 648771)
-- Name: x_btr_marb_gma; Type: INDEX; Schema: public; Owner: arboretum
--

CREATE INDEX x_btr_marb_gma ON public.tj_rgp_marb_gma USING btree (gma_marb_id);


--
-- TOC entry 5170 (class 0 OID 0)
-- Dependencies: 4681
-- Name: INDEX x_btr_marb_gma; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON INDEX public.x_btr_marb_gma IS 'Index de clé étrangère pour accélérer les mises à jour / suppression';


--
-- TOC entry 4685 (class 1259 OID 648772)
-- Name: x_btr_marb_roa; Type: INDEX; Schema: public; Owner: arboretum
--

CREATE INDEX x_btr_marb_roa ON public.tj_role_ope_marb_roa USING btree (roa_marb_id);


--
-- TOC entry 5171 (class 0 OID 0)
-- Dependencies: 4685
-- Name: INDEX x_btr_marb_roa; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON INDEX public.x_btr_marb_roa IS 'Index de clé étrangère pour accélérer les mises à jour / suppression';


--
-- TOC entry 4677 (class 1259 OID 648773)
-- Name: x_btr_marb_tarb; Type: INDEX; Schema: public; Owner: arboretum
--

CREATE INDEX x_btr_marb_tarb ON public.tj_marb_marb_tarb USING btree (tarb_ref_marb_id);


--
-- TOC entry 5172 (class 0 OID 0)
-- Dependencies: 4677
-- Name: INDEX x_btr_marb_tarb; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON INDEX public.x_btr_marb_tarb IS 'Index de clé étrangère pour accélérer les mises à jour / suppression';


--
-- TOC entry 4686 (class 1259 OID 648774)
-- Name: x_btr_ope_roa; Type: INDEX; Schema: public; Owner: arboretum
--

CREATE INDEX x_btr_ope_roa ON public.tj_role_ope_marb_roa USING btree (roa_ope_id);


--
-- TOC entry 5173 (class 0 OID 0)
-- Dependencies: 4686
-- Name: INDEX x_btr_ope_roa; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON INDEX public.x_btr_ope_roa IS 'Index de clé étrangère pour accélérer les mises à jour / suppression';


--
-- TOC entry 4690 (class 1259 OID 648775)
-- Name: x_btr_ope_ror; Type: INDEX; Schema: public; Owner: arboretum
--

CREATE INDEX x_btr_ope_ror ON public.tj_role_ope_rgp_ror USING btree (ror_ope_id);


--
-- TOC entry 5174 (class 0 OID 0)
-- Dependencies: 4690
-- Name: INDEX x_btr_ope_ror; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON INDEX public.x_btr_ope_ror IS 'Index de clé étrangère pour accélérer les mises à jour / suppression';


--
-- TOC entry 4611 (class 1259 OID 648776)
-- Name: x_btr_prov_arb; Type: INDEX; Schema: public; Owner: arboretum
--

CREATE INDEX x_btr_prov_arb ON public.t_arbre_arb USING btree (arb_prov_id);


--
-- TOC entry 5175 (class 0 OID 0)
-- Dependencies: 4611
-- Name: INDEX x_btr_prov_arb; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON INDEX public.x_btr_prov_arb IS 'Index de clé étrangère pour accélérer les mises à jour / suppression';


--
-- TOC entry 4682 (class 1259 OID 648777)
-- Name: x_btr_rgp_gma; Type: INDEX; Schema: public; Owner: arboretum
--

CREATE INDEX x_btr_rgp_gma ON public.tj_rgp_marb_gma USING btree (gma_rgp_id);


--
-- TOC entry 5176 (class 0 OID 0)
-- Dependencies: 4682
-- Name: INDEX x_btr_rgp_gma; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON INDEX public.x_btr_rgp_gma IS 'Index de clé étrangère pour accélérer les mises à jour / suppression';


--
-- TOC entry 4691 (class 1259 OID 648778)
-- Name: x_btr_rgp_ror; Type: INDEX; Schema: public; Owner: arboretum
--

CREATE INDEX x_btr_rgp_ror ON public.tj_role_ope_rgp_ror USING btree (ror_rgp_id);


--
-- TOC entry 5177 (class 0 OID 0)
-- Dependencies: 4691
-- Name: INDEX x_btr_rgp_ror; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON INDEX public.x_btr_rgp_ror IS 'Index de clé étrangère pour accélérer les mises à jour / suppression';


--
-- TOC entry 4678 (class 1259 OID 648779)
-- Name: x_btr_rgp_tarb; Type: INDEX; Schema: public; Owner: arboretum
--

CREATE INDEX x_btr_rgp_tarb ON public.tj_marb_marb_tarb USING btree (tarb_meta_marb_id);


--
-- TOC entry 5178 (class 0 OID 0)
-- Dependencies: 4678
-- Name: INDEX x_btr_rgp_tarb; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON INDEX public.x_btr_rgp_tarb IS 'Index de clé étrangère pour accélérer les mises à jour / suppression';


--
-- TOC entry 4687 (class 1259 OID 648780)
-- Name: x_btr_rol_roa; Type: INDEX; Schema: public; Owner: arboretum
--

CREATE INDEX x_btr_rol_roa ON public.tj_role_ope_marb_roa USING btree (roa_rol_id);


--
-- TOC entry 5179 (class 0 OID 0)
-- Dependencies: 4687
-- Name: INDEX x_btr_rol_roa; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON INDEX public.x_btr_rol_roa IS 'Index de clé étrangère pour accélérer les mises à jour / suppression';


--
-- TOC entry 4692 (class 1259 OID 648781)
-- Name: x_btr_rol_ror; Type: INDEX; Schema: public; Owner: arboretum
--

CREATE INDEX x_btr_rol_ror ON public.tj_role_ope_rgp_ror USING btree (ror_rol_id);


--
-- TOC entry 5180 (class 0 OID 0)
-- Dependencies: 4692
-- Name: INDEX x_btr_rol_ror; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON INDEX public.x_btr_rol_ror IS 'Index de clé étrangère pour accélérer les mises à jour / suppression';


--
-- TOC entry 4612 (class 1259 OID 648782)
-- Name: x_btr_tax_arb; Type: INDEX; Schema: public; Owner: arboretum
--

CREATE INDEX x_btr_tax_arb ON public.t_arbre_arb USING btree (arb_tax_id);


--
-- TOC entry 5181 (class 0 OID 0)
-- Dependencies: 4612
-- Name: INDEX x_btr_tax_arb; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON INDEX public.x_btr_tax_arb IS 'Index de clé étrangère pour accélérer les mises à jour / suppression';


--
-- TOC entry 4674 (class 1259 OID 648783)
-- Name: x_btr_var_cvar; Type: INDEX; Schema: public; Owner: arboretum
--

CREATE INDEX x_btr_var_cvar ON public.tj_classervar_cvar USING btree (cvar_var_id);


--
-- TOC entry 5182 (class 0 OID 0)
-- Dependencies: 4674
-- Name: INDEX x_btr_var_cvar; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON INDEX public.x_btr_var_cvar IS 'Index de clé étrangère pour accélérer les mises à jour / suppression';


--
-- TOC entry 4613 (class 1259 OID 648784)
-- Name: x_btr_zon_arb; Type: INDEX; Schema: public; Owner: arboretum
--

CREATE INDEX x_btr_zon_arb ON public.t_arbre_arb USING btree (arb_zon_id);


--
-- TOC entry 5183 (class 0 OID 0)
-- Dependencies: 4613
-- Name: INDEX x_btr_zon_arb; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON INDEX public.x_btr_zon_arb IS 'Index de clé étrangère pour accélérer les mises à jour / suppression';


--
-- TOC entry 4614 (class 1259 OID 648785)
-- Name: x_gist_geom_gps_arb; Type: INDEX; Schema: public; Owner: arboretum
--

CREATE INDEX x_gist_geom_gps_arb ON public.t_arbre_arb USING gist (arb_geom_gps);


--
-- TOC entry 5184 (class 0 OID 0)
-- Dependencies: 4614
-- Name: INDEX x_gist_geom_gps_arb; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON INDEX public.x_gist_geom_gps_arb IS 'Index pour les opérations spatiales sur arb_geom_gps';


--
-- TOC entry 4615 (class 1259 OID 648786)
-- Name: x_gist_geom_plan_arb; Type: INDEX; Schema: public; Owner: arboretum
--

CREATE INDEX x_gist_geom_plan_arb ON public.t_arbre_arb USING gist (arb_geom_plan);


--
-- TOC entry 5185 (class 0 OID 0)
-- Dependencies: 4615
-- Name: INDEX x_gist_geom_plan_arb; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON INDEX public.x_gist_geom_plan_arb IS 'Index pour les opérations spatiales sur arb_geom_plan';


--
-- TOC entry 4616 (class 1259 OID 648787)
-- Name: x_gist_geom_theo_arb; Type: INDEX; Schema: public; Owner: arboretum
--

CREATE INDEX x_gist_geom_theo_arb ON public.t_arbre_arb USING gist (arb_geom_theo);


--
-- TOC entry 5186 (class 0 OID 0)
-- Dependencies: 4616
-- Name: INDEX x_gist_geom_theo_arb; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON INDEX public.x_gist_geom_theo_arb IS 'Index pour les opérations spatiales sur arb_geom_theo';


--
-- TOC entry 4655 (class 1259 OID 648788)
-- Name: x_gist_tree_zon; Type: INDEX; Schema: public; Owner: arboretum
--

CREATE INDEX x_gist_tree_zon ON public.tr_zone_etude_zon USING gist (zon_tree);


--
-- TOC entry 5187 (class 0 OID 0)
-- Dependencies: 4655
-- Name: INDEX x_gist_tree_zon; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON INDEX public.x_gist_tree_zon IS 'Index d''optimisation de parcours d''arbre sur l''objet tree de type ltree';


--
-- TOC entry 4730 (class 2606 OID 648876)
-- Name: t_mesure_marb c_fk_arb_marb; Type: FK CONSTRAINT; Schema: public; Owner: arboretum
--

ALTER TABLE ONLY public.t_mesure_marb
    ADD CONSTRAINT c_fk_arb_marb FOREIGN KEY (marb_arb_id) REFERENCES public.t_arbre_arb(arb_id);


--
-- TOC entry 5188 (class 0 OID 0)
-- Dependencies: 4730
-- Name: CONSTRAINT c_fk_arb_marb ON t_mesure_marb; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON CONSTRAINT c_fk_arb_marb ON public.t_mesure_marb IS 'une mesure doit être rattachée à un et un seul objet';


--
-- TOC entry 4744 (class 2606 OID 648881)
-- Name: tj_classervar_cvar c_fk_clas_cvar; Type: FK CONSTRAINT; Schema: public; Owner: arboretum
--

ALTER TABLE ONLY public.tj_classervar_cvar
    ADD CONSTRAINT c_fk_clas_cvar FOREIGN KEY (cvar_clas_id) REFERENCES public.tr_classement_clas(clas_id);


--
-- TOC entry 5189 (class 0 OID 0)
-- Dependencies: 4744
-- Name: CONSTRAINT c_fk_clas_cvar ON tj_classervar_cvar; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON CONSTRAINT c_fk_clas_cvar ON public.tj_classervar_cvar IS 'Le champ cvar_clas_id correspond obligatoirement à un classement existant';


--
-- TOC entry 4731 (class 2606 OID 648886)
-- Name: t_mesure_marb c_fk_fic_marb; Type: FK CONSTRAINT; Schema: public; Owner: arboretum
--

ALTER TABLE ONLY public.t_mesure_marb
    ADD CONSTRAINT c_fk_fic_marb FOREIGN KEY (marb_fic_id) REFERENCES public.tr_fichier_fic(fic_id);


--
-- TOC entry 5190 (class 0 OID 0)
-- Dependencies: 4731
-- Name: CONSTRAINT c_fk_fic_marb ON t_mesure_marb; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON CONSTRAINT c_fk_fic_marb ON public.t_mesure_marb IS 'une mesure peut être rattachée à O ou 1 fichier';


--
-- TOC entry 4739 (class 2606 OID 648891)
-- Name: t_regroupement_rgp c_fk_fic_rgp; Type: FK CONSTRAINT; Schema: public; Owner: arboretum
--

ALTER TABLE ONLY public.t_regroupement_rgp
    ADD CONSTRAINT c_fk_fic_rgp FOREIGN KEY (rgp_fic_id) REFERENCES public.tr_fichier_fic(fic_id);


--
-- TOC entry 5191 (class 0 OID 0)
-- Dependencies: 4739
-- Name: CONSTRAINT c_fk_fic_rgp ON t_regroupement_rgp; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON CONSTRAINT c_fk_fic_rgp ON public.t_regroupement_rgp IS 'un regroupement peut être rattaché à O ou 1 fichier';


--
-- TOC entry 4748 (class 2606 OID 648896)
-- Name: tj_rgp_marb_gma c_fk_marb_gma; Type: FK CONSTRAINT; Schema: public; Owner: arboretum
--

ALTER TABLE ONLY public.tj_rgp_marb_gma
    ADD CONSTRAINT c_fk_marb_gma FOREIGN KEY (gma_marb_id) REFERENCES public.t_mesure_marb(marb_id);


--
-- TOC entry 5192 (class 0 OID 0)
-- Dependencies: 4748
-- Name: CONSTRAINT c_fk_marb_gma ON tj_rgp_marb_gma; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON CONSTRAINT c_fk_marb_gma ON public.tj_rgp_marb_gma IS 'Le champ gma_marb_id correspond obligatoirement à une mesure existante';


--
-- TOC entry 4750 (class 2606 OID 648901)
-- Name: tj_role_ope_marb_roa c_fk_marb_roa; Type: FK CONSTRAINT; Schema: public; Owner: arboretum
--

ALTER TABLE ONLY public.tj_role_ope_marb_roa
    ADD CONSTRAINT c_fk_marb_roa FOREIGN KEY (roa_marb_id) REFERENCES public.t_mesure_marb(marb_id);


--
-- TOC entry 5193 (class 0 OID 0)
-- Dependencies: 4750
-- Name: CONSTRAINT c_fk_marb_roa ON tj_role_ope_marb_roa; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON CONSTRAINT c_fk_marb_roa ON public.tj_role_ope_marb_roa IS 'Le champ roa_marb_id correspond obligatoirement à une mesure existante';


--
-- TOC entry 4746 (class 2606 OID 648906)
-- Name: tj_marb_marb_tarb c_fk_meta_marb_tarb; Type: FK CONSTRAINT; Schema: public; Owner: arboretum
--

ALTER TABLE ONLY public.tj_marb_marb_tarb
    ADD CONSTRAINT c_fk_meta_marb_tarb FOREIGN KEY (tarb_meta_marb_id) REFERENCES public.t_mesure_marb(marb_id);


--
-- TOC entry 5194 (class 0 OID 0)
-- Dependencies: 4746
-- Name: CONSTRAINT c_fk_meta_marb_tarb ON tj_marb_marb_tarb; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON CONSTRAINT c_fk_meta_marb_tarb ON public.tj_marb_marb_tarb IS 'Le champ tarb_meta_marb_id correspond obligatoirement à une mesure existante';


--
-- TOC entry 4732 (class 2606 OID 648911)
-- Name: t_mesure_marb c_fk_norm_marb; Type: FK CONSTRAINT; Schema: public; Owner: arboretum
--

ALTER TABLE ONLY public.t_mesure_marb
    ADD CONSTRAINT c_fk_norm_marb FOREIGN KEY (marb_norm_id) REFERENCES public.tr_norme_norm(norm_id);


--
-- TOC entry 5195 (class 0 OID 0)
-- Dependencies: 4732
-- Name: CONSTRAINT c_fk_norm_marb ON t_mesure_marb; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON CONSTRAINT c_fk_norm_marb ON public.t_mesure_marb IS 'une mesure peut être rattachée à O ou 1 norme';


--
-- TOC entry 4740 (class 2606 OID 648916)
-- Name: t_regroupement_rgp c_fk_norm_rgp; Type: FK CONSTRAINT; Schema: public; Owner: arboretum
--

ALTER TABLE ONLY public.t_regroupement_rgp
    ADD CONSTRAINT c_fk_norm_rgp FOREIGN KEY (rgp_norm_id) REFERENCES public.tr_norme_norm(norm_id);


--
-- TOC entry 5196 (class 0 OID 0)
-- Dependencies: 4740
-- Name: CONSTRAINT c_fk_norm_rgp ON t_regroupement_rgp; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON CONSTRAINT c_fk_norm_rgp ON public.t_regroupement_rgp IS 'un regroupement peut être rattaché à O ou 1 norme';


--
-- TOC entry 4751 (class 2606 OID 648921)
-- Name: tj_role_ope_marb_roa c_fk_ope_roa; Type: FK CONSTRAINT; Schema: public; Owner: arboretum
--

ALTER TABLE ONLY public.tj_role_ope_marb_roa
    ADD CONSTRAINT c_fk_ope_roa FOREIGN KEY (roa_ope_id) REFERENCES public.tr_operateur_ope(ope_id);


--
-- TOC entry 5197 (class 0 OID 0)
-- Dependencies: 4751
-- Name: CONSTRAINT c_fk_ope_roa ON tj_role_ope_marb_roa; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON CONSTRAINT c_fk_ope_roa ON public.tj_role_ope_marb_roa IS 'Le champ roa_ope_id correspond obligatoirement à un opérateur existant';


--
-- TOC entry 4753 (class 2606 OID 648926)
-- Name: tj_role_ope_rgp_ror c_fk_ope_ror; Type: FK CONSTRAINT; Schema: public; Owner: arboretum
--

ALTER TABLE ONLY public.tj_role_ope_rgp_ror
    ADD CONSTRAINT c_fk_ope_ror FOREIGN KEY (ror_ope_id) REFERENCES public.tr_operateur_ope(ope_id);


--
-- TOC entry 5198 (class 0 OID 0)
-- Dependencies: 4753
-- Name: CONSTRAINT c_fk_ope_ror ON tj_role_ope_rgp_ror; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON CONSTRAINT c_fk_ope_ror ON public.tj_role_ope_rgp_ror IS 'Le champ ror_ope_id correspond obligatoirement à un opérateur existant';


--
-- TOC entry 4733 (class 2606 OID 648931)
-- Name: t_mesure_marb c_fk_prot_marb; Type: FK CONSTRAINT; Schema: public; Owner: arboretum
--

ALTER TABLE ONLY public.t_mesure_marb
    ADD CONSTRAINT c_fk_prot_marb FOREIGN KEY (marb_prot_id) REFERENCES public.tr_protocole_prot(prot_id);


--
-- TOC entry 5199 (class 0 OID 0)
-- Dependencies: 4733
-- Name: CONSTRAINT c_fk_prot_marb ON t_mesure_marb; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON CONSTRAINT c_fk_prot_marb ON public.t_mesure_marb IS 'une mesure peut être rattachée à O ou 1 protocole';


--
-- TOC entry 4741 (class 2606 OID 648936)
-- Name: t_regroupement_rgp c_fk_prot_rgp; Type: FK CONSTRAINT; Schema: public; Owner: arboretum
--

ALTER TABLE ONLY public.t_regroupement_rgp
    ADD CONSTRAINT c_fk_prot_rgp FOREIGN KEY (rgp_prot_id) REFERENCES public.tr_protocole_prot(prot_id);


--
-- TOC entry 5200 (class 0 OID 0)
-- Dependencies: 4741
-- Name: CONSTRAINT c_fk_prot_rgp ON t_regroupement_rgp; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON CONSTRAINT c_fk_prot_rgp ON public.t_regroupement_rgp IS 'un regroupement peut être rattaché à O ou 1 protocole';


--
-- TOC entry 4727 (class 2606 OID 648941)
-- Name: t_arbre_arb c_fk_prov_arb; Type: FK CONSTRAINT; Schema: public; Owner: arboretum
--

ALTER TABLE ONLY public.t_arbre_arb
    ADD CONSTRAINT c_fk_prov_arb FOREIGN KEY (arb_prov_id) REFERENCES public.tr_provenance_prov(prov_id);


--
-- TOC entry 5201 (class 0 OID 0)
-- Dependencies: 4727
-- Name: CONSTRAINT c_fk_prov_arb ON t_arbre_arb; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON CONSTRAINT c_fk_prov_arb ON public.t_arbre_arb IS 'un arbre peut être rattaché à une provenance';


--
-- TOC entry 4747 (class 2606 OID 648946)
-- Name: tj_marb_marb_tarb c_fk_ref_marb_tarb; Type: FK CONSTRAINT; Schema: public; Owner: arboretum
--

ALTER TABLE ONLY public.tj_marb_marb_tarb
    ADD CONSTRAINT c_fk_ref_marb_tarb FOREIGN KEY (tarb_ref_marb_id) REFERENCES public.t_mesure_marb(marb_id);


--
-- TOC entry 5202 (class 0 OID 0)
-- Dependencies: 4747
-- Name: CONSTRAINT c_fk_ref_marb_tarb ON tj_marb_marb_tarb; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON CONSTRAINT c_fk_ref_marb_tarb ON public.tj_marb_marb_tarb IS 'Le champ tarb_ref_marb_id correspond obligatoirement à une mesure existante';


--
-- TOC entry 4737 (class 2606 OID 648951)
-- Name: tr_taxon_tax c_fk_ref_tax; Type: FK CONSTRAINT; Schema: public; Owner: arboretum
--

ALTER TABLE ONLY public.tr_taxon_tax
    ADD CONSTRAINT c_fk_ref_tax FOREIGN KEY (tax_ref_id) REFERENCES public.tr_referentiel_taxonomique_ref(ref_id);


--
-- TOC entry 5203 (class 0 OID 0)
-- Dependencies: 4737
-- Name: CONSTRAINT c_fk_ref_tax ON tr_taxon_tax; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON CONSTRAINT c_fk_ref_tax ON public.tr_taxon_tax IS 'un taxon est rattaché à 1 et 1 seul référentiel';


--
-- TOC entry 4749 (class 2606 OID 648956)
-- Name: tj_rgp_marb_gma c_fk_rgp_gma; Type: FK CONSTRAINT; Schema: public; Owner: arboretum
--

ALTER TABLE ONLY public.tj_rgp_marb_gma
    ADD CONSTRAINT c_fk_rgp_gma FOREIGN KEY (gma_rgp_id) REFERENCES public.t_regroupement_rgp(rgp_id);


--
-- TOC entry 5204 (class 0 OID 0)
-- Dependencies: 4749
-- Name: CONSTRAINT c_fk_rgp_gma ON tj_rgp_marb_gma; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON CONSTRAINT c_fk_rgp_gma ON public.tj_rgp_marb_gma IS 'Le champ gma_rgp_id correspond obligatoirement à un regroupememnt existant';


--
-- TOC entry 4754 (class 2606 OID 648961)
-- Name: tj_role_ope_rgp_ror c_fk_rgp_ror; Type: FK CONSTRAINT; Schema: public; Owner: arboretum
--

ALTER TABLE ONLY public.tj_role_ope_rgp_ror
    ADD CONSTRAINT c_fk_rgp_ror FOREIGN KEY (ror_rgp_id) REFERENCES public.t_regroupement_rgp(rgp_id);


--
-- TOC entry 5205 (class 0 OID 0)
-- Dependencies: 4754
-- Name: CONSTRAINT c_fk_rgp_ror ON tj_role_ope_rgp_ror; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON CONSTRAINT c_fk_rgp_ror ON public.tj_role_ope_rgp_ror IS 'Le champ ror_rgp_id correspond obligatoirement à un regroupement existant';


--
-- TOC entry 4752 (class 2606 OID 648966)
-- Name: tj_role_ope_marb_roa c_fk_rol_roa; Type: FK CONSTRAINT; Schema: public; Owner: arboretum
--

ALTER TABLE ONLY public.tj_role_ope_marb_roa
    ADD CONSTRAINT c_fk_rol_roa FOREIGN KEY (roa_rol_id) REFERENCES public.tr_role_rol(rol_id);


--
-- TOC entry 5206 (class 0 OID 0)
-- Dependencies: 4752
-- Name: CONSTRAINT c_fk_rol_roa ON tj_role_ope_marb_roa; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON CONSTRAINT c_fk_rol_roa ON public.tj_role_ope_marb_roa IS 'Le champ roa_rol_id correspond obligatoirement à un rôle existant';


--
-- TOC entry 4755 (class 2606 OID 648971)
-- Name: tj_role_ope_rgp_ror c_fk_rol_ror; Type: FK CONSTRAINT; Schema: public; Owner: arboretum
--

ALTER TABLE ONLY public.tj_role_ope_rgp_ror
    ADD CONSTRAINT c_fk_rol_ror FOREIGN KEY (ror_rol_id) REFERENCES public.tr_role_rol(rol_id);


--
-- TOC entry 5207 (class 0 OID 0)
-- Dependencies: 4755
-- Name: CONSTRAINT c_fk_rol_ror ON tj_role_ope_rgp_ror; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON CONSTRAINT c_fk_rol_ror ON public.tj_role_ope_rgp_ror IS 'Le champ ror_rol_id correspond obligatoirement à un rôle existant';


--
-- TOC entry 4728 (class 2606 OID 648976)
-- Name: t_arbre_arb c_fk_tax_arb; Type: FK CONSTRAINT; Schema: public; Owner: arboretum
--

ALTER TABLE ONLY public.t_arbre_arb
    ADD CONSTRAINT c_fk_tax_arb FOREIGN KEY (arb_tax_id) REFERENCES public.tr_taxon_tax(tax_id);


--
-- TOC entry 5208 (class 0 OID 0)
-- Dependencies: 4728
-- Name: CONSTRAINT c_fk_tax_arb ON t_arbre_arb; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON CONSTRAINT c_fk_tax_arb ON public.t_arbre_arb IS 'un arbre doit être rattaché à un et un seul taxon';


--
-- TOC entry 4734 (class 2606 OID 648981)
-- Name: t_mesure_marb c_fk_typm_marb; Type: FK CONSTRAINT; Schema: public; Owner: arboretum
--

ALTER TABLE ONLY public.t_mesure_marb
    ADD CONSTRAINT c_fk_typm_marb FOREIGN KEY (marb_typm_id) REFERENCES public.tr_type_mesure_typm(typm_id);


--
-- TOC entry 5209 (class 0 OID 0)
-- Dependencies: 4734
-- Name: CONSTRAINT c_fk_typm_marb ON t_mesure_marb; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON CONSTRAINT c_fk_typm_marb ON public.t_mesure_marb IS 'une mesure peut être rattachée à O ou 1 type de mesure';


--
-- TOC entry 4742 (class 2606 OID 648986)
-- Name: t_regroupement_rgp c_fk_typm_rgp; Type: FK CONSTRAINT; Schema: public; Owner: arboretum
--

ALTER TABLE ONLY public.t_regroupement_rgp
    ADD CONSTRAINT c_fk_typm_rgp FOREIGN KEY (rgp_typm_id) REFERENCES public.tr_type_mesure_typm(typm_id);


--
-- TOC entry 5210 (class 0 OID 0)
-- Dependencies: 4742
-- Name: CONSTRAINT c_fk_typm_rgp ON t_regroupement_rgp; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON CONSTRAINT c_fk_typm_rgp ON public.t_regroupement_rgp IS 'un regroupement peut être rattaché à O ou 1 type de mesure';


--
-- TOC entry 4738 (class 2606 OID 648991)
-- Name: tr_zone_etude_zon c_fk_typz_zon; Type: FK CONSTRAINT; Schema: public; Owner: arboretum
--

ALTER TABLE ONLY public.tr_zone_etude_zon
    ADD CONSTRAINT c_fk_typz_zon FOREIGN KEY (zon_typz_id) REFERENCES public.tr_type_zone_etude_typz(typz_id);


--
-- TOC entry 5211 (class 0 OID 0)
-- Dependencies: 4738
-- Name: CONSTRAINT c_fk_typz_zon ON tr_zone_etude_zon; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON CONSTRAINT c_fk_typz_zon ON public.tr_zone_etude_zon IS 'une zone d''étude doit être rattachée à 1 et 1 seul type de zone d''étude';


--
-- TOC entry 4735 (class 2606 OID 648996)
-- Name: t_mesure_marb c_fk_uni_marb; Type: FK CONSTRAINT; Schema: public; Owner: arboretum
--

ALTER TABLE ONLY public.t_mesure_marb
    ADD CONSTRAINT c_fk_uni_marb FOREIGN KEY (marb_uni_id) REFERENCES public.tr_unite_uni(uni_id);


--
-- TOC entry 5212 (class 0 OID 0)
-- Dependencies: 4735
-- Name: CONSTRAINT c_fk_uni_marb ON t_mesure_marb; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON CONSTRAINT c_fk_uni_marb ON public.t_mesure_marb IS 'une mesure peut être rattachée à O ou 1 unité';


--
-- TOC entry 4743 (class 2606 OID 649001)
-- Name: t_regroupement_rgp c_fk_uni_rgp; Type: FK CONSTRAINT; Schema: public; Owner: arboretum
--

ALTER TABLE ONLY public.t_regroupement_rgp
    ADD CONSTRAINT c_fk_uni_rgp FOREIGN KEY (rgp_uni_id) REFERENCES public.tr_unite_uni(uni_id);


--
-- TOC entry 5213 (class 0 OID 0)
-- Dependencies: 4743
-- Name: CONSTRAINT c_fk_uni_rgp ON t_regroupement_rgp; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON CONSTRAINT c_fk_uni_rgp ON public.t_regroupement_rgp IS 'un regroupement peut être rattaché à O ou 1 unité';


--
-- TOC entry 4745 (class 2606 OID 649006)
-- Name: tj_classervar_cvar c_fk_var_cvar; Type: FK CONSTRAINT; Schema: public; Owner: arboretum
--

ALTER TABLE ONLY public.tj_classervar_cvar
    ADD CONSTRAINT c_fk_var_cvar FOREIGN KEY (cvar_var_id) REFERENCES public.tr_variable_var(var_id);


--
-- TOC entry 5214 (class 0 OID 0)
-- Dependencies: 4745
-- Name: CONSTRAINT c_fk_var_cvar ON tj_classervar_cvar; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON CONSTRAINT c_fk_var_cvar ON public.tj_classervar_cvar IS 'Le champ cvar_var_id correspond obligatoirement à variable existante';


--
-- TOC entry 4736 (class 2606 OID 649011)
-- Name: t_mesure_marb c_fk_var_marb; Type: FK CONSTRAINT; Schema: public; Owner: arboretum
--

ALTER TABLE ONLY public.t_mesure_marb
    ADD CONSTRAINT c_fk_var_marb FOREIGN KEY (marb_var_id) REFERENCES public.tr_variable_var(var_id);


--
-- TOC entry 5215 (class 0 OID 0)
-- Dependencies: 4736
-- Name: CONSTRAINT c_fk_var_marb ON t_mesure_marb; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON CONSTRAINT c_fk_var_marb ON public.t_mesure_marb IS 'une mesure doit être rattachée à une et une seule variable';


--
-- TOC entry 4729 (class 2606 OID 649016)
-- Name: t_arbre_arb c_fk_zon_arb; Type: FK CONSTRAINT; Schema: public; Owner: arboretum
--

ALTER TABLE ONLY public.t_arbre_arb
    ADD CONSTRAINT c_fk_zon_arb FOREIGN KEY (arb_zon_id) REFERENCES public.tr_zone_etude_zon(zon_id);


--
-- TOC entry 5216 (class 0 OID 0)
-- Dependencies: 4729
-- Name: CONSTRAINT c_fk_zon_arb ON t_arbre_arb; Type: COMMENT; Schema: public; Owner: arboretum
--

COMMENT ON CONSTRAINT c_fk_zon_arb ON public.t_arbre_arb IS 'un arbre doit être rattaché à une et une seule zone';


--
-- TOC entry 4948 (class 0 OID 0)
-- Dependencies: 251
-- Name: TABLE t_arbre_arb; Type: ACL; Schema: public; Owner: arboretum
--

GRANT ALL ON TABLE public.t_arbre_arb TO arboretum_ecriture;
GRANT SELECT ON TABLE public.t_arbre_arb TO arboretum_lecture;


--
-- TOC entry 4965 (class 0 OID 0)
-- Dependencies: 252
-- Name: TABLE t_mesure_marb; Type: ACL; Schema: public; Owner: arboretum
--

GRANT ALL ON TABLE public.t_mesure_marb TO arboretum_ecriture;
GRANT SELECT ON TABLE public.t_mesure_marb TO arboretum_lecture;


--
-- TOC entry 4975 (class 0 OID 0)
-- Dependencies: 253
-- Name: TABLE tr_taxon_tax; Type: ACL; Schema: public; Owner: arboretum
--

GRANT ALL ON TABLE public.tr_taxon_tax TO arboretum_ecriture;
GRANT SELECT ON TABLE public.tr_taxon_tax TO arboretum_lecture;


--
-- TOC entry 4980 (class 0 OID 0)
-- Dependencies: 254
-- Name: TABLE tr_type_mesure_typm; Type: ACL; Schema: public; Owner: arboretum
--

GRANT ALL ON TABLE public.tr_type_mesure_typm TO arboretum_ecriture;
GRANT SELECT ON TABLE public.tr_type_mesure_typm TO arboretum_lecture;


--
-- TOC entry 4987 (class 0 OID 0)
-- Dependencies: 255
-- Name: TABLE tr_unite_uni; Type: ACL; Schema: public; Owner: arboretum
--

GRANT ALL ON TABLE public.tr_unite_uni TO arboretum_ecriture;
GRANT SELECT ON TABLE public.tr_unite_uni TO arboretum_lecture;


--
-- TOC entry 4995 (class 0 OID 0)
-- Dependencies: 256
-- Name: TABLE tr_variable_var; Type: ACL; Schema: public; Owner: arboretum
--

GRANT ALL ON TABLE public.tr_variable_var TO arboretum_ecriture;
GRANT SELECT ON TABLE public.tr_variable_var TO arboretum_lecture;


--
-- TOC entry 5002 (class 0 OID 0)
-- Dependencies: 257
-- Name: TABLE tr_zone_etude_zon; Type: ACL; Schema: public; Owner: arboretum
--

GRANT ALL ON TABLE public.tr_zone_etude_zon TO arboretum_ecriture;
GRANT SELECT ON TABLE public.tr_zone_etude_zon TO arboretum_lecture;


--
-- TOC entry 5006 (class 0 OID 0)
-- Dependencies: 259
-- Name: TABLE tr_provenance_prov; Type: ACL; Schema: public; Owner: arboretum
--

GRANT ALL ON TABLE public.tr_provenance_prov TO arboretum_ecriture;
GRANT SELECT ON TABLE public.tr_provenance_prov TO arboretum_lecture;


--
-- TOC entry 5008 (class 0 OID 0)
-- Dependencies: 284
-- Name: SEQUENCE t_arbre_arb_arb_id_seq; Type: ACL; Schema: public; Owner: arboretum
--

GRANT ALL ON SEQUENCE public.t_arbre_arb_arb_id_seq TO arboretum_ecriture WITH GRANT OPTION;


--
-- TOC entry 5019 (class 0 OID 0)
-- Dependencies: 285
-- Name: TABLE t_formulaire_access_configuration_faconf; Type: ACL; Schema: public; Owner: arboretum
--

GRANT ALL ON TABLE public.t_formulaire_access_configuration_faconf TO arboretum_ecriture;
GRANT SELECT ON TABLE public.t_formulaire_access_configuration_faconf TO arboretum_lecture;


--
-- TOC entry 5021 (class 0 OID 0)
-- Dependencies: 286
-- Name: SEQUENCE t_formulaire_access_configuration_faconf_faconf_id_seq; Type: ACL; Schema: public; Owner: arboretum
--

GRANT ALL ON SEQUENCE public.t_formulaire_access_configuration_faconf_faconf_id_seq TO arboretum_ecriture WITH GRANT OPTION;


--
-- TOC entry 5023 (class 0 OID 0)
-- Dependencies: 287
-- Name: SEQUENCE t_mesure_marb_marb_id_seq; Type: ACL; Schema: public; Owner: arboretum
--

GRANT ALL ON SEQUENCE public.t_mesure_marb_marb_id_seq TO arboretum_ecriture WITH GRANT OPTION;


--
-- TOC entry 5034 (class 0 OID 0)
-- Dependencies: 288
-- Name: TABLE t_regroupement_rgp; Type: ACL; Schema: public; Owner: arboretum
--

GRANT ALL ON TABLE public.t_regroupement_rgp TO arboretum_ecriture;
GRANT SELECT ON TABLE public.t_regroupement_rgp TO arboretum_lecture;


--
-- TOC entry 5036 (class 0 OID 0)
-- Dependencies: 289
-- Name: SEQUENCE t_regroupement_rgp_rgp_id_seq; Type: ACL; Schema: public; Owner: arboretum
--

GRANT ALL ON SEQUENCE public.t_regroupement_rgp_rgp_id_seq TO arboretum_ecriture WITH GRANT OPTION;


--
-- TOC entry 5040 (class 0 OID 0)
-- Dependencies: 290
-- Name: TABLE tj_classervar_cvar; Type: ACL; Schema: public; Owner: arboretum
--

GRANT ALL ON TABLE public.tj_classervar_cvar TO arboretum_ecriture;
GRANT SELECT ON TABLE public.tj_classervar_cvar TO arboretum_lecture;


--
-- TOC entry 5045 (class 0 OID 0)
-- Dependencies: 291
-- Name: TABLE tj_marb_marb_tarb; Type: ACL; Schema: public; Owner: arboretum
--

GRANT ALL ON TABLE public.tj_marb_marb_tarb TO arboretum_ecriture;
GRANT SELECT ON TABLE public.tj_marb_marb_tarb TO arboretum_lecture;


--
-- TOC entry 5049 (class 0 OID 0)
-- Dependencies: 292
-- Name: TABLE tj_rgp_marb_gma; Type: ACL; Schema: public; Owner: arboretum
--

GRANT ALL ON TABLE public.tj_rgp_marb_gma TO arboretum_ecriture;
GRANT SELECT ON TABLE public.tj_rgp_marb_gma TO arboretum_lecture;


--
-- TOC entry 5054 (class 0 OID 0)
-- Dependencies: 293
-- Name: TABLE tj_role_ope_marb_roa; Type: ACL; Schema: public; Owner: arboretum
--

GRANT ALL ON TABLE public.tj_role_ope_marb_roa TO arboretum_ecriture;
GRANT SELECT ON TABLE public.tj_role_ope_marb_roa TO arboretum_lecture;


--
-- TOC entry 5059 (class 0 OID 0)
-- Dependencies: 294
-- Name: TABLE tj_role_ope_rgp_ror; Type: ACL; Schema: public; Owner: arboretum
--

GRANT ALL ON TABLE public.tj_role_ope_rgp_ror TO arboretum_ecriture;
GRANT SELECT ON TABLE public.tj_role_ope_rgp_ror TO arboretum_lecture;


--
-- TOC entry 5065 (class 0 OID 0)
-- Dependencies: 295
-- Name: TABLE tr_classement_clas; Type: ACL; Schema: public; Owner: arboretum
--

GRANT ALL ON TABLE public.tr_classement_clas TO arboretum_ecriture;
GRANT SELECT ON TABLE public.tr_classement_clas TO arboretum_lecture;


--
-- TOC entry 5067 (class 0 OID 0)
-- Dependencies: 296
-- Name: SEQUENCE tr_classement_clas_clas_id_seq; Type: ACL; Schema: public; Owner: arboretum
--

GRANT ALL ON SEQUENCE public.tr_classement_clas_clas_id_seq TO arboretum_ecriture WITH GRANT OPTION;


--
-- TOC entry 5072 (class 0 OID 0)
-- Dependencies: 297
-- Name: TABLE tr_fichier_fic; Type: ACL; Schema: public; Owner: arboretum
--

GRANT ALL ON TABLE public.tr_fichier_fic TO arboretum_ecriture;
GRANT SELECT ON TABLE public.tr_fichier_fic TO arboretum_lecture;


--
-- TOC entry 5074 (class 0 OID 0)
-- Dependencies: 298
-- Name: SEQUENCE tr_fichier_fic_fic_id_seq; Type: ACL; Schema: public; Owner: arboretum
--

GRANT ALL ON SEQUENCE public.tr_fichier_fic_fic_id_seq TO arboretum_ecriture WITH GRANT OPTION;


--
-- TOC entry 5081 (class 0 OID 0)
-- Dependencies: 299
-- Name: TABLE tr_norme_norm; Type: ACL; Schema: public; Owner: arboretum
--

GRANT ALL ON TABLE public.tr_norme_norm TO arboretum_ecriture;
GRANT SELECT ON TABLE public.tr_norme_norm TO arboretum_lecture;


--
-- TOC entry 5083 (class 0 OID 0)
-- Dependencies: 300
-- Name: SEQUENCE tr_norme_norm_norm_id_seq; Type: ACL; Schema: public; Owner: arboretum
--

GRANT ALL ON SEQUENCE public.tr_norme_norm_norm_id_seq TO arboretum_ecriture WITH GRANT OPTION;


--
-- TOC entry 5089 (class 0 OID 0)
-- Dependencies: 301
-- Name: TABLE tr_operateur_ope; Type: ACL; Schema: public; Owner: arboretum
--

GRANT ALL ON TABLE public.tr_operateur_ope TO arboretum_ecriture;
GRANT SELECT ON TABLE public.tr_operateur_ope TO arboretum_lecture;


--
-- TOC entry 5091 (class 0 OID 0)
-- Dependencies: 302
-- Name: SEQUENCE tr_operateur_ope_ope_id_seq; Type: ACL; Schema: public; Owner: arboretum
--

GRANT ALL ON SEQUENCE public.tr_operateur_ope_ope_id_seq TO arboretum_ecriture WITH GRANT OPTION;


--
-- TOC entry 5096 (class 0 OID 0)
-- Dependencies: 303
-- Name: TABLE tr_protocole_prot; Type: ACL; Schema: public; Owner: arboretum
--

GRANT ALL ON TABLE public.tr_protocole_prot TO arboretum_ecriture;
GRANT SELECT ON TABLE public.tr_protocole_prot TO arboretum_lecture;


--
-- TOC entry 5098 (class 0 OID 0)
-- Dependencies: 304
-- Name: SEQUENCE tr_protocole_prot_prot_id_seq; Type: ACL; Schema: public; Owner: arboretum
--

GRANT ALL ON SEQUENCE public.tr_protocole_prot_prot_id_seq TO arboretum_ecriture WITH GRANT OPTION;


--
-- TOC entry 5100 (class 0 OID 0)
-- Dependencies: 305
-- Name: SEQUENCE tr_provenance_prov_prov_id_seq; Type: ACL; Schema: public; Owner: arboretum
--

GRANT ALL ON SEQUENCE public.tr_provenance_prov_prov_id_seq TO arboretum_ecriture WITH GRANT OPTION;


--
-- TOC entry 5107 (class 0 OID 0)
-- Dependencies: 306
-- Name: TABLE tr_referentiel_taxonomique_ref; Type: ACL; Schema: public; Owner: arboretum
--

GRANT ALL ON TABLE public.tr_referentiel_taxonomique_ref TO arboretum_ecriture;
GRANT SELECT ON TABLE public.tr_referentiel_taxonomique_ref TO arboretum_lecture;


--
-- TOC entry 5109 (class 0 OID 0)
-- Dependencies: 307
-- Name: SEQUENCE tr_referentiel_ref_ref_id_seq; Type: ACL; Schema: public; Owner: arboretum
--

GRANT ALL ON SEQUENCE public.tr_referentiel_ref_ref_id_seq TO arboretum_ecriture WITH GRANT OPTION;


--
-- TOC entry 5114 (class 0 OID 0)
-- Dependencies: 308
-- Name: TABLE tr_role_rol; Type: ACL; Schema: public; Owner: arboretum
--

GRANT ALL ON TABLE public.tr_role_rol TO arboretum_ecriture;
GRANT SELECT ON TABLE public.tr_role_rol TO arboretum_lecture;


--
-- TOC entry 5116 (class 0 OID 0)
-- Dependencies: 309
-- Name: SEQUENCE tr_role_rol_rol_id_seq; Type: ACL; Schema: public; Owner: arboretum
--

GRANT ALL ON SEQUENCE public.tr_role_rol_rol_id_seq TO arboretum_ecriture WITH GRANT OPTION;


--
-- TOC entry 5118 (class 0 OID 0)
-- Dependencies: 310
-- Name: SEQUENCE tr_taxon_tax_tax_id_seq; Type: ACL; Schema: public; Owner: arboretum
--

GRANT ALL ON SEQUENCE public.tr_taxon_tax_tax_id_seq TO arboretum_ecriture WITH GRANT OPTION;


--
-- TOC entry 5120 (class 0 OID 0)
-- Dependencies: 311
-- Name: SEQUENCE tr_type_mesure_typm_typm_id_seq; Type: ACL; Schema: public; Owner: arboretum
--

GRANT ALL ON SEQUENCE public.tr_type_mesure_typm_typm_id_seq TO arboretum_ecriture WITH GRANT OPTION;


--
-- TOC entry 5125 (class 0 OID 0)
-- Dependencies: 312
-- Name: TABLE tr_type_zone_etude_typz; Type: ACL; Schema: public; Owner: arboretum
--

GRANT ALL ON TABLE public.tr_type_zone_etude_typz TO arboretum_ecriture;
GRANT SELECT ON TABLE public.tr_type_zone_etude_typz TO arboretum_lecture;


--
-- TOC entry 5127 (class 0 OID 0)
-- Dependencies: 313
-- Name: SEQUENCE tr_type_zone_etude_typz_typz_id_seq; Type: ACL; Schema: public; Owner: arboretum
--

GRANT ALL ON SEQUENCE public.tr_type_zone_etude_typz_typz_id_seq TO arboretum_ecriture WITH GRANT OPTION;


--
-- TOC entry 5129 (class 0 OID 0)
-- Dependencies: 314
-- Name: SEQUENCE tr_unite_uni_uni_id_seq; Type: ACL; Schema: public; Owner: arboretum
--

GRANT ALL ON SEQUENCE public.tr_unite_uni_uni_id_seq TO arboretum_ecriture WITH GRANT OPTION;


--
-- TOC entry 5131 (class 0 OID 0)
-- Dependencies: 315
-- Name: SEQUENCE tr_variable_var_var_id_seq; Type: ACL; Schema: public; Owner: arboretum
--

GRANT ALL ON SEQUENCE public.tr_variable_var_var_id_seq TO arboretum_ecriture WITH GRANT OPTION;


--
-- TOC entry 5133 (class 0 OID 0)
-- Dependencies: 316
-- Name: SEQUENCE tr_zone_etude_zon_zon_id_seq; Type: ACL; Schema: public; Owner: arboretum
--

GRANT ALL ON SEQUENCE public.tr_zone_etude_zon_zon_id_seq TO arboretum_ecriture WITH GRANT OPTION;


-- Completed on 2024-10-30 11:27:11

--
--

