db_toff on pggeodb.nancy.inra.fr |
|
Table: tr_family_trait_fam
db_toff on pggeodb.nancy.inra.fr |
|
Table: tr_family_trait_fam
Schema
Owner
postgres
Tablespace
(default)
Descriptions
Table displaying the list of trait family / Table contenant la liste des familles de traits
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
fam_id |
serial |
|
|
|
nextval('tr_family_trait_fam_fam_id_seq'::regclass) |
Automatic ID of the trait family / Identifiant automatique de la famille de traits |
|
|
fam_parent_id |
integer |
|
|
|
|
Automatic ID of the parent trait family / Identifiant automatique de la famille de traits parent |
|
|
fam_name |
varchar(64) |
|
|
|
|
Name of the trait family / Nom de la famille de trait |
|
|
fam_definition |
varchar |
|
|
|
|
Definition of the trait family / Definition de la famille de traits |
|
|
fam_reference |
varchar |
|
|
|
|
Reference of the trait family (e.g. URL, DOI) / Reference de la famille de traits (URL, DOI ... libre) |
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
fam_parent_id |
fam_id |
No Action |
No Action |
|
Immediate |
A trait family is related to only one parent. The highest level families are not related to other families / Une famille de traits est associée à un et un seul parent. Les familles de tout premier ordre ne sont associées à aucune autre famille |
Check Constraints
There are no check constraints for table tr_family_trait_fam
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
btree |
|
fam_parent_id, fam_name |
|
|
Uniqueness of the name and the ID of the parent family / Unicité du couple nom - identifiant de la famille parent |
|
btree |
|
fam_id |
|
|
|
Triggers
There are no triggers for table tr_family_trait_fam
Rules
There are no rules for table tr_family_trait_fam
Policies
There are no policies for table tr_family_trait_fam
Referenced
Table | Schema | Foreign Key | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|---|---|
fam_parent_id |
fam_id |
No Action |
No Action |
|
Immediate |
A trait family is related to only one parent. The highest level families are not related to other families / Une famille de traits est associée à un et un seul parent. Les familles de tout premier ordre ne sont associées à aucune autre famille |
||||
tra_fam_id |
fam_id |
No Action |
No Action |
|
Immediate |
A characteristic family is related to only one parent. / Un trait est rattaché à une et une seule famille de traits |
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
fam_id SERIAL,
fam_parent_id INTEGER,
fam_name VARCHAR(64) NOT NULL,
fam_definition VARCHAR NOT NULL,
fam_reference VARCHAR,
CONSTRAINT tr_family_trait_fam_pkey PRIMARY KEY(fam_id),
CONSTRAINT c_fk_fam_fam FOREIGN KEY (fam_parent_id)
REFERENCES public.tr_family_trait_fam(fam_id)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE
)
WITH (oids = false);
COMMENT ON TABLE public.tr_family_trait_fam
IS 'Table displaying the list of trait family / Table contenant la liste des familles de traits';
COMMENT ON COLUMN public.tr_family_trait_fam.fam_id
IS 'Automatic ID of the trait family / Identifiant automatique de la famille de traits';
COMMENT ON COLUMN public.tr_family_trait_fam.fam_parent_id
IS 'Automatic ID of the parent trait family / Identifiant automatique de la famille de traits parent';
COMMENT ON COLUMN public.tr_family_trait_fam.fam_name
IS 'Name of the trait family / Nom de la famille de trait';
COMMENT ON COLUMN public.tr_family_trait_fam.fam_definition
IS 'Definition of the trait family / Definition de la famille de traits';
COMMENT ON COLUMN public.tr_family_trait_fam.fam_reference
IS 'Reference of the trait family (e.g. URL, DOI) / Reference de la famille de traits (URL, DOI ... libre)';
COMMENT ON CONSTRAINT c_fk_fam_fam ON public.tr_family_trait_fam
IS 'A trait family is related to only one parent. The highest level families are not related to other families / Une famille de traits est associée à un et un seul parent. Les familles de tout premier ordre ne sont associées à aucune autre famille';
CREATE UNIQUE INDEX c_uni_parent_id_name_fam ON public.tr_family_trait_fam
USING btree (fam_parent_id, fam_name COLLATE pg_catalog."default");
COMMENT ON INDEX public.c_uni_parent_id_name_fam
IS 'Uniqueness of the name and the ID of the parent family / Unicité du couple nom - identifiant de la famille parent';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 19/06/2019 10:17 |
|