pggeodb-preprod.nancy.inra.fr/db_diams

Table: Parcelles_DIASCOPE_DIAMS

Schema

public

Owner

postgres

Tablespace

(default)

Descriptions

There is no description for table Parcelles_DIASCOPE_DIAMS

Columns

Foreign Keys

There are no foreign keys for table Parcelles_DIASCOPE_DIAMS

Check Constraints

There are no check constraints for table Parcelles_DIASCOPE_DIAMS

Indices

Triggers

There are no triggers for table Parcelles_DIASCOPE_DIAMS

Rules

There are no rules for table Parcelles_DIASCOPE_DIAMS

Policies

There are no policies for table Parcelles_DIASCOPE_DIAMS

Referenced

There are no tables referenced by table Parcelles_DIASCOPE_DIAMS

Properties

Definition

CREATE TABLE public."Parcelles_DIASCOPE_DIAMS" (
 id_diascope_diams SERIAL,
 geom public.geometry,
 siret VARCHAR(35),
 pacage VARCHAR(20),
 code_explo VARCHAR(20),
 rais_socia VARCHAR(50),
 campagne INTEGER,
 cod_parcel VARCHAR(40),
 id_externe VARCHAR(35),
 code_traca VARCHAR(13),
 guid_parc VARCHAR(36),
 code_p_ori VARCHAR(4),
 guid_p_ori VARCHAR(36),
 type_parc VARCHAR(30),
 nom_parcel VARCHAR(253),
 surface DOUBLE PRECISION,
 num_ilot INTEGER,
 code_insee VARCHAR(6),
 lib_commun VARCHAR(55),
 commentair VARCHAR(253),
 fd_comment VARCHAR(253),
 pd_comment VARCHAR(253),
 cp_cultu VARCHAR(25),
 cp_codcult VARCHAR(12),
 code_gnis VARCHAR(12),
 variete VARCHAR(25),
 destin_edi VARCHAR(3),
 destinatio VARCHAR(25),
 residu_edi VARCHAR(3),
 residus VARCHAR(35),
 date_semis DATE,
 date_recol DATE,
 rdt_object DOUBLE PRECISION,
 rdt_realis DOUBLE PRECISION,
 unite_edi VARCHAR(3),
 unite_rdt VARCHAR(4),
 labour VARCHAR(1),
 c_prec_edi VARCHAR(12),
 cult_prec VARCHAR(25),
 c_pre2_edi VARCHAR(12),
 cult_prec2 VARCHAR(25),
 cip_edi VARCHAR(12),
 cip_cultu VARCHAR(25),
 cip_datsem DATE,
 cip_datdes DATE,
 cip_moddes VARCHAR(35),
 cip_gnis VARCHAR(25),
 cis_edi VARCHAR(12),
 cis_cultu VARCHAR(25),
 cis_datsem DATE,
 cis_datdes DATE,
 cis_moddes VARCHAR(35),
 cis_gnis VARCHAR(25),
 type_sol VARCHAR(75),
 typsol_edi VARCHAR(3),
 outil_pilo VARCHAR(25),
 zone_vuln VARCHAR(1),
 spe_fumier DOUBLE PRECISION,
 spe_lisier DOUBLE PRECISION,
 spe_autre DOUBLE PRECISION,
 lib_analys VARCHAR(35),
 num_analys VARCHAR(35),
 nom_labo VARCHAR(35),
 dat_analys DATE,
 argile DOUBLE PRECISION,
 u_argile VARCHAR(4),
 limons_fin DOUBLE PRECISION,
 u_limon_f VARCHAR(4),
 limons_gr DOUBLE PRECISION,
 u_limon_gr VARCHAR(4),
 sable_fin DOUBLE PRECISION,
 u_sable_fi VARCHAR(4),
 sable_gr DOUBLE PRECISION,
 u_sable_gr VARCHAR(4),
 p2o5 DOUBLE PRECISION,
 u_p2o5 VARCHAR(4),
 m_p2o5 VARCHAR(35),
 k2o DOUBLE PRECISION,
 u_k2o VARCHAR(4),
 cao DOUBLE PRECISION,
 u_cao VARCHAR(4),
 mgo DOUBLE PRECISION,
 u_mgo VARCHAR(4),
 na2o DOUBLE PRECISION,
 u_na2o VARCHAR(4),
 soufre DOUBLE PRECISION,
 u_soufre VARCHAR(4),
 sels_solub DOUBLE PRECISION,
 k_mg DOUBLE PRECISION,
 ph_eau DOUBLE PRECISION,
 ph_kcl DOUBLE PRECISION,
 calcaire_t DOUBLE PRECISION,
 u_calcai_t VARCHAR(4),
 calcaire_a DOUBLE PRECISION,
 u_calcai_a VARCHAR(4),
 pvoir_chl DOUBLE PRECISION,
 cec DOUBLE PRECISION,
 u_cec VARCHAR(10),
 carb_org_t DOUBLE PRECISION,
 u_car_or_t VARCHAR(4),
 c_n DOUBLE PRECISION,
 taux_mo DOUBLE PRECISION,
 u_taux_mo VARCHAR(4),
 zinc DOUBLE PRECISION,
 u_zinc VARCHAR(4),
 m_zinc VARCHAR(35),
 manganese DOUBLE PRECISION,
 u_manganes VARCHAR(4),
 m_manganes VARCHAR(35),
 cuivre DOUBLE PRECISION,
 u_cuivre VARCHAR(4),
 m_cuivre VARCHAR(35),
 fer DOUBLE PRECISION,
 u_fer VARCHAR(4),
 m_fer VARCHAR(35),
 bore DOUBLE PRECISION,
 u_bore VARCHAR(4),
 m_bore VARCHAR(35),
 aluminiu DOUBLE PRECISION,
 u_aluminiu VARCHAR(4),
 molybdene DOUBLE PRECISION,
 u_molybden VARCHAR(4),
 m_molybden VARCHAR(35),
 arsenic DOUBLE PRECISION,
 u_arsenic VARCHAR(4),
 cadmum DOUBLE PRECISION,
 u_cadmum VARCHAR(4),
 chrome DOUBLE PRECISION,
 u_chrome VARCHAR(4),
 mercure DOUBLE PRECISION,
 u_mercure VARCHAR(4),
 nickel DOUBLE PRECISION,
 u_nickel VARCHAR(4),
 plomb DOUBLE PRECISION,
 u_plomb VARCHAR(4),
 selenium DOUBLE PRECISION,
 u_selenium VARCHAR(4),
 layer VARCHAR(254),
 path VARCHAR(254),
 CONSTRAINT "Parcelles_DIASCOPE_DIAMS_pkey" PRIMARY KEY(id_diascope_diams)
) ;

CREATE INDEX "sidx_Parcelles_DIASCOPE_DIAMS_geom" ON public."Parcelles_DIASCOPE_DIAMS"
 USING gist (geom public.gist_geometry_ops_2d);

This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 07/12/2018 13:23