db_toff on pggeodb.nancy.inra.fr |
|
Table: tr_family_characteristic_fca
db_toff on pggeodb.nancy.inra.fr |
|
Table: tr_family_characteristic_fca
Schema
Owner
postgres
Tablespace
(default)
Descriptions
Table displaying the list of characteristic families / Table contenant la liste des familles de caractéristiques
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
fca_id |
serial |
|
|
|
nextval('tr_family_characteristic_fca_fca_id_seq'::regclass) |
Automatic ID of the characteristic family /Identifiant automatique de la famille de caractéristiques |
|
|
fca_parent_id |
integer |
|
|
|
|
Automatic ID of the parent characteristic family / Identifiant automatique de la famille de caractéristiques parent |
|
|
fca_wording |
varchar(128) |
|
|
|
|
Wording (designation) of the characteristic family /Libellé de la famille de caractéristiques |
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
fca_parent_id |
fca_id |
No Action |
No Action |
|
Immediate |
A characteristic family is related to only one parent. The highest level families are not related to other families / Une famille de caractéristiques 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_characteristic_fca
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
btree |
|
fca_parent_id, fca_wording |
|
|
Uniqueness of the name and the ID of the parent family / Unicité du couple nom - identifiant de la famille parent |
|
btree |
|
fca_id |
|
|
|
Triggers
There are no triggers for table tr_family_characteristic_fca
Rules
There are no rules for table tr_family_characteristic_fca
Policies
There are no policies for table tr_family_characteristic_fca
Referenced
Table | Schema | Foreign Key | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|---|---|
char_fca_id |
fca_id |
No Action |
No Action |
|
Immediate |
A characteristic is related to only one characteristic family. / Une caractéristique est rattachée à une et une seule famille de caractéristiques |
||||
fca_parent_id |
fca_id |
No Action |
No Action |
|
Immediate |
A characteristic family is related to only one parent. The highest level families are not related to other families / Une famille de caractéristiques est associée à un et un seul parent. Les familles de tout premier ordre ne sont associées à aucune autre famille. |
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
fca_id SERIAL,
fca_parent_id INTEGER,
fca_wording VARCHAR(128) NOT NULL,
CONSTRAINT tr_family_characteristic_fca_pkey PRIMARY KEY(fca_id),
CONSTRAINT c_fk_fca_fca FOREIGN KEY (fca_parent_id)
REFERENCES public.tr_family_characteristic_fca(fca_id)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE
)
WITH (oids = false);
COMMENT ON TABLE public.tr_family_characteristic_fca
IS 'Table displaying the list of characteristic families / Table contenant la liste des familles de caractéristiques';
COMMENT ON COLUMN public.tr_family_characteristic_fca.fca_id
IS 'Automatic ID of the characteristic family /Identifiant automatique de la famille de caractéristiques';
COMMENT ON COLUMN public.tr_family_characteristic_fca.fca_parent_id
IS 'Automatic ID of the parent characteristic family / Identifiant automatique de la famille de caractéristiques parent';
COMMENT ON COLUMN public.tr_family_characteristic_fca.fca_wording
IS 'Wording (designation) of the characteristic family /Libellé de la famille de caractéristiques';
COMMENT ON CONSTRAINT c_fk_fca_fca ON public.tr_family_characteristic_fca
IS 'A characteristic family is related to only one parent. The highest level families are not related to other families / Une famille de caractéristiques 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_fca ON public.tr_family_characteristic_fca
USING btree (fca_parent_id, fca_wording COLLATE pg_catalog."default");
COMMENT ON INDEX public.c_uni_parent_id_name_fca
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 |
|