pggeodb-preprod.nancy.inra.fr/db_diams |
|
Table: chn
pggeodb-preprod.nancy.inra.fr/db_diams |
|
Table: chn
Schema
Owner
postgres
Tablespace
(default)
Descriptions
There is no description for table chn
Columns
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
id_chn |
serial |
|
|
|
nextval('chn_id_chn_seq'::regclass) |
|
|
|
sk_echant |
integer |
|
|
|
|
|
|
|
poids |
varchar |
|
|
|
|
|
|
|
n_pourc |
varchar |
|
|
|
|
|
|
|
c_pourc |
varchar |
|
|
|
|
|
|
|
cn |
varchar |
|
|
|
|
|
Foreign Keys
Name | Columns | FK Table | FK Columns | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
sk_echant |
id_echant |
No Action |
No Action |
|
Immediate |
|
Check Constraints
There are no check constraints for table chn
Indices
Name | Type | Function | Columns | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
btree |
|
sk_echant |
|
|
|
|
btree |
|
id_chn |
|
|
|
Triggers
There are no triggers for table chn
Rules
There are no rules for table chn
Policies
There are no policies for table chn
Referenced
There are no tables referenced by table chn
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
819 |
Pages |
7 |
System |
|
Temporary |
|
With OID |
|
Definition
id_chn SERIAL,
sk_echant INTEGER,
poids VARCHAR,
n_pourc VARCHAR,
c_pourc VARCHAR,
cn VARCHAR,
CONSTRAINT pmk_chn PRIMARY KEY(id_chn),
CONSTRAINT stk_echant FOREIGN KEY (sk_echant)
REFERENCES public.pedotheque(id_echant)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
CREATE INDEX fki_stk_echant ON public.chn
USING btree (sk_echant);
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 07/12/2018 13:23 |
|