pggeodb-preprod.nancy.inra.fr/db_diams |
|
Table: vers_de_terre
pggeodb-preprod.nancy.inra.fr/db_diams |
|
Table: vers_de_terre
Schema
Owner
postgres
Tablespace
(default)
Descriptions
There is no description for table vers_de_terre
Columns
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
id_vers |
serial |
|
|
|
nextval('vers_de_terre_id_vers_seq'::regclass) |
|
|
|
label |
varchar |
|
|
|
|
|
|
|
num_vers |
integer |
|
|
|
|
|
|
|
nbre_vers |
integer |
|
|
|
|
|
|
|
biom_vers |
varchar |
|
|
|
|
|
|
|
chloro_ad |
varchar |
|
|
|
|
|
|
|
chloro_sub |
varchar |
|
|
|
|
|
|
|
spx_ad |
varchar |
|
|
|
|
|
|
|
spx_sub |
varchar |
|
|
|
|
|
|
|
spr_ad |
varchar |
|
|
|
|
|
|
|
spr_sub |
varchar |
|
|
|
|
|
|
|
eji |
varchar |
|
|
|
|
|
|
|
anecique |
varchar |
|
|
|
|
|
|
|
castaneus |
varchar |
|
|
|
|
|
|
|
culture_vers |
varchar |
|
|
|
|
|
|
|
bloc_vers |
integer |
|
|
|
|
|
|
|
irrig |
varchar |
|
|
|
|
|
|
|
date_vers |
varchar |
|
|
|
|
|
|
|
prefixe_vers_pedo |
varchar |
|
|
|
|
|
|
|
sk_pedo_vers |
integer |
|
|
|
|
|
Foreign Keys
Name | Columns | FK Table | FK Columns | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
sk_pedo_vers |
id_echant |
No Action |
No Action |
|
Immediate |
|
Check Constraints
There are no check constraints for table vers_de_terre
Indices
Name | Type | Function | Columns | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
btree |
|
sk_pedo_vers |
|
|
|
|
btree |
|
id_vers |
|
|
|
Triggers
There are no triggers for table vers_de_terre
Rules
There are no rules for table vers_de_terre
Policies
There are no policies for table vers_de_terre
Referenced
There are no tables referenced by table vers_de_terre
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
362 |
Pages |
5 |
System |
|
Temporary |
|
With OID |
|
Definition
id_vers SERIAL,
label VARCHAR,
num_vers INTEGER,
nbre_vers INTEGER,
biom_vers VARCHAR,
chloro_ad VARCHAR,
chloro_sub VARCHAR,
spx_ad VARCHAR,
spx_sub VARCHAR,
spr_ad VARCHAR,
spr_sub VARCHAR,
eji VARCHAR,
anecique VARCHAR,
castaneus VARCHAR,
culture_vers VARCHAR,
bloc_vers INTEGER,
irrig VARCHAR,
date_vers VARCHAR,
prefixe_vers_pedo VARCHAR,
sk_pedo_vers INTEGER,
CONSTRAINT pmk_vers PRIMARY KEY(id_vers),
CONSTRAINT stk_pedo_vers FOREIGN KEY (sk_pedo_vers)
REFERENCES public.pedotheque(id_echant)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
CREATE INDEX fki_stk_pedo_vers ON public.vers_de_terre
USING btree (sk_pedo_vers);
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 07/12/2018 13:23 |
|