pggeodb.nancy.inra.fr/db_woodseer - db_woodseer on pggeodb.nancy.inra.fr |
|
Table: tr_classification_cla
pggeodb.nancy.inra.fr/db_woodseer - db_woodseer on pggeodb.nancy.inra.fr |
|
Table: tr_classification_cla
Schema
Owner
woodseer
Tablespace
(default)
Descriptions
Table of variables classifications where a variable can belong to several classifications.
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
cla_id |
serial |
|
|
|
nextval('tr_classification_cla_cla_id_seq'::regclass) |
Unique numeric identifier of the variable classification |
|
|
cla_tree |
public.ltree |
|
|
|
|
Complete classification hierarchy, based on the postgreSQL Ltree data type, each node being separated by the character ''.'' (e.g. physical_characteristics. dendrometry) |
|
|
cla_label |
varchar(32) |
|
|
|
|
Usual name of the classification |
|
|
cla_definition |
varchar(255) |
|
|
|
|
Definition of the classification |
Foreign Keys
There are no foreign keys for table tr_classification_cla
Check Constraints
There are no check constraints for table tr_classification_cla
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
btree |
|
cla_tree |
|
|
The ltree hierarchy of a classification is unique |
|
btree |
|
cla_id |
|
|
|
Triggers
There are no triggers for table tr_classification_cla
Rules
There are no rules for table tr_classification_cla
Policies
There are no policies for table tr_classification_cla
Referenced
Table | Schema | Foreign Key | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|---|---|
cvar_cla_id |
cla_id |
No Action |
No Action |
|
Immediate |
The cvar_cla_id field must correspond to an existing variable classification |
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
cla_id SERIAL,
cla_tree public.ltree NOT NULL,
cla_label VARCHAR(32),
cla_definition VARCHAR(255),
CONSTRAINT c_uni_tree_cla UNIQUE(cla_tree),
CONSTRAINT tr_classification_cla_pkey PRIMARY KEY(cla_id)
) ;
COMMENT ON TABLE public.tr_classification_cla
IS 'Table of variables classifications where a variable can belong to several classifications.';
COMMENT ON COLUMN public.tr_classification_cla.cla_id
IS 'Unique numeric identifier of the variable classification';
COMMENT ON COLUMN public.tr_classification_cla.cla_tree
IS 'Complete classification hierarchy, based on the postgreSQL Ltree data type, each node being separated by the character ''''.'''' (e.g. physical_characteristics. dendrometry)';
COMMENT ON COLUMN public.tr_classification_cla.cla_label
IS 'Usual name of the classification';
COMMENT ON COLUMN public.tr_classification_cla.cla_definition
IS 'Definition of the classification';
COMMENT ON CONSTRAINT c_uni_tree_cla ON public.tr_classification_cla
IS 'The ltree hierarchy of a classification is unique';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 07/12/2018 13:23 |
|