db_biljou_carto on db.silva.inrae.fr |
|
Table: tj_combinaison_parametre_combp
db_biljou_carto on db.silva.inrae.fr |
|
Table: tj_combinaison_parametre_combp
Schema
Owner
biljoucarto
Tablespace
(default)
Descriptions
Table de jointure de tr_parametre_par et tr_combinaison_comb
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
combp_par_id |
integer |
|
|
|
|
Clé étrangère de la table tr_parametre_par |
|
|
combp_comb_id |
integer |
|
|
|
|
Clé étrangère de la table tr_combinaison_comb |
|
|
combp_valeur |
varchar(20) |
|
|
|
|
Valeur du paramètre |
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
combp_comb_id |
comb_id |
No Action |
No Action |
|
Immediate |
|
||
combp_par_id |
par_id |
No Action |
No Action |
|
Immediate |
|
Check Constraints
There are no check constraints for table tj_combinaison_parametre_combp
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
btree |
|
combp_par_id, combp_comb_id |
|
|
|
Triggers
There are no triggers for table tj_combinaison_parametre_combp
Rules
There are no rules for table tj_combinaison_parametre_combp
Policies
There are no policies for table tj_combinaison_parametre_combp
Referenced
There are no tables referenced by table tj_combinaison_parametre_combp
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
320 |
Pages |
2 |
System |
|
Temporary |
|
With OID |
|
Definition
combp_par_id INTEGER NOT NULL,
combp_comb_id INTEGER NOT NULL,
combp_valeur VARCHAR(20),
CONSTRAINT tj_combinaison_parametre_combp_pkey PRIMARY KEY(combp_par_id, combp_comb_id),
CONSTRAINT tj_combinaison_parametre_combp_combp_comb_id_fkey FOREIGN KEY (combp_comb_id)
REFERENCES public.tr_combinaison_comb(comb_id)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT tj_combinaison_parametre_combp_combp_par_id_fkey FOREIGN KEY (combp_par_id)
REFERENCES public.tr_parametre_par(par_id)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
COMMENT ON TABLE public.tj_combinaison_parametre_combp
IS 'Table de jointure de tr_parametre_par et tr_combinaison_comb';
COMMENT ON COLUMN public.tj_combinaison_parametre_combp.combp_par_id
IS 'Clé étrangère de la table tr_parametre_par';
COMMENT ON COLUMN public.tj_combinaison_parametre_combp.combp_comb_id
IS 'Clé étrangère de la table tr_combinaison_comb';
COMMENT ON COLUMN public.tj_combinaison_parametre_combp.combp_valeur
IS 'Valeur du paramètre';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 07/12/2018 13:23 |
|