db_toff on pggeodb.nancy.inra.fr |
|
Table: tj_connection_tra_grp_ctg
db_toff on pggeodb.nancy.inra.fr |
|
Table: tj_connection_tra_grp_ctg
Schema
Owner
postgres
Tablespace
(default)
Descriptions
A trait can belong to from 0 to n trait groups / Un trait peut faire partie de 0 à n groupes de traits
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
ctg_grp_id |
integer |
|
|
|
|
Automatic ID of the trait group / Identifiant automatique du groupe de traits |
|
|
ctg_tra_id |
integer |
|
|
|
|
Unique automatic ID of the trait / Identifiant unique du trait |
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
ctg_grp_id |
grp_id |
No Action |
No Action |
|
Immediate |
Connection involves only one trait group / L'association concerne un et un seul groupe de traits |
||
ctg_tra_id |
tra_id |
No Action |
No Action |
|
Immediate |
Connection involves only one trait / L'association concerne un et un seul trait |
Check Constraints
There are no check constraints for table tj_connection_tra_grp_ctg
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
btree |
|
ctg_grp_id, ctg_tra_id |
|
|
|
|
btree |
|
ctg_grp_id |
|
|
Foreign key index linking a trait group to a trait / Index sur la clé étrangère rattachant un groupe de traits à un trait |
|
btree |
|
ctg_tra_id |
|
|
Foreign key index linking a trait to a trait group / Index sur la clé étrangère rattachant un trait à un groupe de traits |
Triggers
There are no triggers for table tj_connection_tra_grp_ctg
Rules
There are no rules for table tj_connection_tra_grp_ctg
Policies
There are no policies for table tj_connection_tra_grp_ctg
Referenced
There are no tables referenced by table tj_connection_tra_grp_ctg
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
ctg_grp_id INTEGER NOT NULL,
ctg_tra_id INTEGER NOT NULL,
CONSTRAINT tj_connection_tra_grp_ctg_pkey PRIMARY KEY(ctg_grp_id, ctg_tra_id),
CONSTRAINT c_fk_grp_ctg FOREIGN KEY (ctg_grp_id)
REFERENCES public.t_group_trait_grp(grp_id)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT c_fk_tra_ctg FOREIGN KEY (ctg_tra_id)
REFERENCES public.tr_trait_tra(tra_id)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE
)
WITH (oids = false);
COMMENT ON TABLE public.tj_connection_tra_grp_ctg
IS 'A trait can belong to from 0 to n trait groups / Un trait peut faire partie de 0 à n groupes de traits';
COMMENT ON COLUMN public.tj_connection_tra_grp_ctg.ctg_grp_id
IS 'Automatic ID of the trait group / Identifiant automatique du groupe de traits';
COMMENT ON COLUMN public.tj_connection_tra_grp_ctg.ctg_tra_id
IS 'Unique automatic ID of the trait / Identifiant unique du trait';
COMMENT ON CONSTRAINT c_fk_grp_ctg ON public.tj_connection_tra_grp_ctg
IS 'Connection involves only one trait group / L''association concerne un et un seul groupe de traits';
COMMENT ON CONSTRAINT c_fk_tra_ctg ON public.tj_connection_tra_grp_ctg
IS 'Connection involves only one trait / L''association concerne un et un seul trait';
CREATE INDEX x_btr_grp_ctg ON public.tj_connection_tra_grp_ctg
USING btree (ctg_grp_id);
COMMENT ON INDEX public.x_btr_grp_ctg
IS 'Foreign key index linking a trait group to a trait / Index sur la clé étrangère rattachant un groupe de traits à un trait';
CREATE INDEX x_btr_tra_ctg ON public.tj_connection_tra_grp_ctg
USING btree (ctg_tra_id);
COMMENT ON INDEX public.x_btr_tra_ctg
IS 'Foreign key index linking a trait to a trait group / Index sur la clé étrangère rattachant un trait à un groupe de traits';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 19/06/2019 10:17 |
|