Schema
Owner
postgres
Tablespace
(default)
Descriptions
There is no description for table phytotheque
Columns
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
---|---|---|---|---|---|---|---|---|
|
|
projet |
varchar |
|
|
|
|
|
|
|
titre |
varchar |
|
|
|
|
|
|
|
responsable |
varchar |
|
|
|
|
|
|
|
commentaire |
varchar |
|
|
|
|
|
|
|
prefixe |
varchar |
|
|
|
|
|
|
|
suffixe |
varchar |
|
|
|
|
|
|
|
mpl |
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 |
|
|
|
|
|
|
|
id_echant |
serial |
|
|
nextval('phytotheque_id_echant_seq'::regclass) |
|
|
|
id_phyto |
serial |
|
nextval('phytotheque_id_phyto_seq'::regclass) |
|
Foreign Keys
There are no foreign keys for table phytotheque
Check Constraints
There are no check constraints for table phytotheque
Indices
Name | Type | Function | Columns | Primary Key | Unique | Description |
---|---|---|---|---|---|---|
btree |
|
id_phyto |
|
Triggers
There are no triggers for table phytotheque
Rules
There are no rules for table phytotheque
Policies
There are no policies for table phytotheque
Referenced
Table | Schema | Foreign Key | Columns | FK Table | FK Columns | Delete Action | Update Action | Deferrable | Check Time | Description |
---|---|---|---|---|---|---|---|---|---|---|
spect_echant_phyto |
id_phyto |
No Action |
No Action |
|
Immediate |
|
Properties
Property | Value |
---|---|
Inherited From |
|
Rows |
460 |
Pages |
21 |
System |
|
Temporary |
|
With OID |
Definition
CREATE TABLE public.phytotheque (
projet VARCHAR,
titre VARCHAR,
responsable VARCHAR,
commentaire VARCHAR,
prefixe VARCHAR,
suffixe VARCHAR,
mpl 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,
id_echant SERIAL,
id_phyto SERIAL,
CONSTRAINT pmk_phyto PRIMARY KEY(id_phyto)
) ;
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 07/12/2018 13:23 |