pggeodb-preprod.nancy.inra.fr/db_diams |
|
Table: pedotheque
pggeodb-preprod.nancy.inra.fr/db_diams |
|
Table: pedotheque
Schema
Owner
postgres
Tablespace
(default)
Descriptions
There is no description for table pedotheque
Columns
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
id_echant |
serial |
|
|
|
nextval('pedotheque_id_echant_seq'::regclass) |
|
|
|
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 |
|
|
|
|
|
|
|
responsable2 |
varchar |
|
|
|
|
|
Foreign Keys
There are no foreign keys for table pedotheque
Check Constraints
There are no check constraints for table pedotheque
Indices
Name | Type | Function | Columns | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
gist |
|
geom |
|
|
|
|
btree |
|
id_echant |
|
|
|
|
gist |
|
geom |
|
|
|
Triggers
There are no triggers for table pedotheque
Rules
There are no rules for table pedotheque
Policies
There are no policies for table pedotheque
Referenced
Table | Schema | Foreign Key | Columns | FK Table | FK Columns | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|---|---|
sk_echant |
id_echant |
No Action |
No Action |
|
Immediate |
|
||||
sk_echant_frac |
id_echant |
No Action |
No Action |
|
Immediate |
|
||||
sk_echant_micro |
id_echant |
No Action |
No Action |
|
Immediate |
|
||||
spect_echant |
id_echant |
No Action |
No Action |
|
Immediate |
|
||||
sk_pedo_vers |
id_echant |
No Action |
No Action |
|
Immediate |
|
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
4439 |
Pages |
171 |
System |
|
Temporary |
|
With OID |
|
Definition
id_echant SERIAL,
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,
responsable2 VARCHAR,
CONSTRAINT pmk_echant PRIMARY KEY(id_echant)
) ;
CREATE INDEX idx_geom ON public.pedotheque
USING gist (geom public.gist_geometry_ops_2d);
CREATE INDEX sidx_pedotheque_geom ON public.pedotheque
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 |
|