     id_nomenclature_sexe integer DEFAULT 189,
     id_nomenclature_bio_condition integer DEFAULT 177,
     id_nomenclature_naturalness integer DEFAULT 181,
+
+    id_nomenclature_exist_proof integer DEFAULT 91,
+    id_nomenclature_valid_status integer DEFAULT 347,
+    id_nomenclature_diffusion_level integer DEFAULT 163,
+
+    id_nomenclature_life_stage integer NOT NULL,
+    id_nomenclature_sex integer NOT NULL,
+    id_nomenclature_obj_count integer NOT NULL DEFAULT 166,
+    id_nomenclature_type_count integer DEFAULT 107,
+    count_min integer,
+    count_max integer,
+
     cd_nom integer,
-    insee character(5),
+    nom_cite character varying(255),
+    meta_v_taxref character varying(50) DEFAULT 'SELECT get_default_parameter(''taxref_version'',NULL)',
+    id_municipality character(25),
     altitude_min integer,
     altitude_max integer,
-    the_geom_3857 public.geometry(Geometry,3857),
-    the_geom_point public.geometry(Point,3857),
+    the_geom_4326 public.geometry(Geometry,4326),
+    the_geom_point public.geometry(Point,4326),
     the_geom_local public.geometry(Geometry,MYLOCALSRID),
     date_min date NOT NULL,
     date_max date NOT NULL,
+    id_validator integer,
     observers character varying(255),
     determiner character varying(255),
+    determination_method character varying(255),
     total_number integer,
     comment text,
     sensitivity INTEGER NOT NULL,

---------
CREATE INDEX fki_synthese_bib_proprietaires ON synthese USING btree (id_organisme);

CREATE INDEX fki_synthese_insee_fkey ON synthese USING btree (insee);

CREATE INDEX fki_synthese_t_modules ON synthese USING btree (id_module);


    meta_create_date timestamp without time zone DEFAULT now(),
    meta_update_date timestamp without time zone DEFAULT now(),
    last_action character(1),
    CONSTRAINT enforce_dims_the_geom_4326 CHECK ((public.st_ndims(the_geom_4326) = 2)),
    CONSTRAINT enforce_dims_the_geom_local CHECK ((public.st_ndims(the_geom_local) = 2)),
    CONSTRAINT enforce_dims_the_geom_point CHECK ((public.st_ndims(the_geom_point) = 2)),
    CONSTRAINT enforce_geotype_the_geom_point CHECK (((public.geometrytype(the_geom_point) = 'POINT'::text) OR (the_geom_point IS NULL))),
    CONSTRAINT enforce_srid_the_geom_4326 CHECK ((public.st_srid(the_geom_4326) = 4326)),
    CONSTRAINT enforce_srid_the_geom_local CHECK ((public.st_srid(the_geom_local) = MYLOCALSRID)),
    CONSTRAINT enforce_srid_the_geom_point CHECK ((public.st_srid(the_geom_point) = 4326))
);
COMMENT ON TABLE synthese IS 'Table de synthèse destinée à recevoir les données de tous les protocoles. Pour consultation uniquement';
COMMENT ON COLUMN synthese.id_nomenclature_obs_technique IS 'Correspondance nomenclature INPN = technique_obs';
COMMENT ON COLUMN synthese.id_nomenclature_obs_meth IS 'Correspondance nomenclature INPN = methode_obs';
COMMENT ON COLUMN synthese.id_nomenclature_bio_condition IS 'Correspondance nomenclature INPN = etat_bio';
COMMENT ON COLUMN synthese.id_nomenclature_bio_status IS 'Correspondance nomenclature INPN = statut_bio';
COMMENT ON COLUMN synthese.id_nomenclature_naturalness IS 'Correspondance nomenclature INPN = naturalite';
COMMENT ON COLUMN synthese.id_nomenclature_exist_proof IS 'Correspondance nomenclature INPN = preuve_exist';
COMMENT ON COLUMN synthese.id_nomenclature_valid_status IS 'Correspondance nomenclature INPN = statut_valide';
COMMENT ON COLUMN synthese.id_nomenclature_diffusion_level IS 'Correspondance nomenclature INPN = niv_precis';

CREATE SEQUENCE synthese_id_synthese_seq
    START WITH 1
