pggeodb-preprod.nancy.inra.fr/db_diams |
|
Table: pedo_diams_2
pggeodb-preprod.nancy.inra.fr/db_diams |
|
Table: pedo_diams_2
Schema
Owner
postgres
Tablespace
(default)
Descriptions
There is no description for table pedo_diams_2
Columns
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
id_echant |
integer |
|
|
|
|
|
|
|
projet |
varchar |
|
|
|
|
|
|
|
titre |
varchar |
|
|
|
|
|
|
|
responsable |
varchar |
|
|
|
|
|
|
|
commentaire |
varchar |
|
|
|
|
|
|
|
prefixe |
varchar |
|
|
|
|
|
|
|
suffixe |
varchar |
|
|
|
|
|
|
|
mpl_sauv |
varchar |
|
|
|
|
|
|
|
comm_echant |
text |
|
|
|
|
|
|
|
date_prelev |
varchar |
|
|
|
|
|
|
|
type_prelev |
varchar |
|
|
|
|
|
|
|
nature_prelev |
varchar |
|
|
|
|
|
|
|
texture |
varchar |
|
|
|
|
|
|
|
loa |
varchar |
|
|
|
|
|
|
|
comm_prelev |
text |
|
|
|
|
|
|
|
pays |
varchar |
|
|
|
|
|
|
|
region |
varchar |
|
|
|
|
|
|
|
site |
varchar |
|
|
|
|
|
|
|
geom |
public.geometry |
|
|
|
|
|
|
|
toponymie |
varchar |
|
|
|
|
|
|
|
type_sol |
varchar |
|
|
|
|
|
|
|
ref_pedo |
varchar |
|
|
|
|
|
|
|
occupation_sol |
varchar |
|
|
|
|
|
|
|
fertilisation_sol |
varchar |
|
|
|
|
|
|
|
travail_sol |
varchar |
|
|
|
|
|
|
|
comm_point_prelev |
text |
|
|
|
|
|
|
|
masse |
varchar |
|
|
|
|
|
|
|
num_ordre |
varchar |
|
|
|
|
|
|
|
prof_sup |
varchar |
|
|
|
|
|
|
|
prof_inf |
varchar |
|
|
|
|
|
|
|
latitude |
varchar |
|
|
|
|
|
|
|
longitude |
varchar |
|
|
|
|
|
|
|
mpl_0 |
varchar |
|
|
|
|
|
|
|
mpl |
varchar |
|
|
|
|
|
|
|
autre_pedo |
integer |
|
|
|
|
|
Foreign Keys
There are no foreign keys for table pedo_diams_2
Check Constraints
There are no check constraints for table pedo_diams_2
Indices
There are no indices for table pedo_diams_2
Triggers
There are no triggers for table pedo_diams_2
Rules
There are no rules for table pedo_diams_2
Policies
There are no policies for table pedo_diams_2
Referenced
There are no tables referenced by table pedo_diams_2
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
374 |
Pages |
9 |
System |
|
Temporary |
|
With OID |
|
Definition
id_echant INTEGER,
projet VARCHAR,
titre VARCHAR,
responsable VARCHAR,
commentaire VARCHAR,
prefixe VARCHAR,
suffixe VARCHAR,
mpl_sauv VARCHAR,
comm_echant TEXT,
date_prelev VARCHAR,
type_prelev VARCHAR,
nature_prelev VARCHAR,
texture VARCHAR,
loa VARCHAR,
comm_prelev TEXT,
pays VARCHAR,
region VARCHAR,
site VARCHAR,
geom public.geometry,
toponymie VARCHAR,
type_sol VARCHAR,
ref_pedo VARCHAR,
occupation_sol VARCHAR,
fertilisation_sol VARCHAR,
travail_sol VARCHAR,
comm_point_prelev TEXT,
masse VARCHAR,
num_ordre VARCHAR,
prof_sup VARCHAR,
prof_inf VARCHAR,
latitude VARCHAR,
longitude VARCHAR,
mpl_0 VARCHAR,
mpl VARCHAR,
autre_pedo INTEGER
) ;
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 07/12/2018 13:23 |
|