Schema | Table | Foreign Key | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
---|---|---|---|---|---|---|---|---|---|---|
prol_child_role_id |
rol_id |
Cascade |
No Action |
|
Immediate |
Association of a child role. |
||||
prol_parent_role_id |
rol_id |
Cascade |
No Action |
|
Immediate |
Association of a parent role. |
||||
rperm_perm_id |
perm_id |
Cascade |
No Action |
|
Immediate |
Association of a permission to a role. |
||||
rperm_rol_id |
rol_id |
Cascade |
No Action |
|
Immediate |
Association of a role with a permission. |
||||
urol_rol_id |
rol_id |
Cascade |
No Action |
|
Immediate |
Associating a role with a user account. |
||||
urol_usr_id |
usr_id |
Cascade |
No Action |
|
Immediate |
Associating a user account with a role. |
||||
grp_fil_id |
fil_id |
No Action |
No Action |
|
Immediate |
a grouping can be attached to O or 1 file |
||||
grp_prot_id |
prot_id |
No Action |
No Action |
|
Immediate |
a grouping can be attached to O or 1 protocol |
||||
grp_std_id |
std_id |
No Action |
No Action |
|
Immediate |
a grouping can be attached to O or 1 standard |
||||
grp_tym_id |
tym_id |
No Action |
No Action |
|
Immediate |
a grouping can be attached to O or 1 type of measure |
||||
grp_uni_id |
uni_id |
No Action |
No Action |
|
Immediate |
a grouping can be attached to O or 1 unit |
||||
mzon_fil_id |
fil_id |
No Action |
No Action |
|
Immediate |
a measurement can be attached to O or 1 file |
||||
mzon_prot_id |
prot_id |
No Action |
No Action |
|
Immediate |
a measurement can be attached to O or 1 protocol |
||||
mzon_std_id |
std_id |
No Action |
No Action |
|
Immediate |
a measure can be attached to O or 1 standard |
||||
mzon_tym_id |
tym_id |
No Action |
No Action |
|
Immediate |
a measure can be attached to O or 1 type of measure |
||||
mzon_uni_id |
uni_id |
No Action |
No Action |
|
Immediate |
a measure can be attached to 0 or 1 unit |
||||
mzon_var_id |
var_id |
No Action |
No Action |
|
Immediate |
a measure must be linked to one and only one variable |
||||
mzon_zon_id |
zon_id |
No Action |
No Action |
|
Immediate |
a measure must be attached to one and only one object |
||||
cvar_rank_id |
rank_id |
No Action |
No Action |
|
Immediate |
The cvar_rank_id field necessarily corresponds to an existing ranking |
||||
cvar_var_id |
var_id |
No Action |
No Action |
|
Immediate |
The cvar_var_id field must correspond to an existing variable |
||||
gmz_grp_id |
grp_id |
No Action |
No Action |
|
Immediate |
The gmz_grp_id field necessarily corresponds to an existing grouping |
||||
gmz_mzon_id |
mzon_id |
No Action |
No Action |
|
Immediate |
The gmz_mzon_id field necessarily corresponds to an existing measurement |
||||
tzon_meta_mzon_id |
mzon_id |
No Action |
No Action |
|
Immediate |
The tzon_meta_mzon_id field necessarily corresponds to an existing measurement |
||||
tzon_ref_mzon_id |
mzon_id |
No Action |
No Action |
|
Immediate |
The tzon_ref_mzon_id field necessarily corresponds to an existing measurement |
||||
rog_grp_id |
grp_id |
No Action |
No Action |
|
Immediate |
The rog_grp_id field necessarily corresponds to an existing grouping |
||||
rog_ope_id |
ope_id |
No Action |
No Action |
|
Immediate |
The rog_ope_id field must correspond to an existing operator |
||||
rog_rol_id |
rol_id |
No Action |
No Action |
|
Immediate |
The rog_rol_id field must correspond to an existing role |
||||
roz_mzon_id |
mzon_id |
No Action |
No Action |
|
Immediate |
The roz_mzon_id field necessarily corresponds to an existing measurement |
||||
roz_ope_id |
ope_id |
No Action |
No Action |
|
Immediate |
The roz_ope_id field necessarily corresponds to an existing operator |
||||
roz_rol_id |
rol_id |
No Action |
No Action |
|
Immediate |
The roz_rol_id field must correspond to an existing role |
||||
zon_typz_id |
typz_id |
No Action |
No Action |
|
Immediate |
a study zone must be attached to 1 and 1 type of study zone |
||||
tax_ref_id |
ref_id |
No Action |
No Action |
|
Immediate |
A taxon is linked to 1 and 1 single referential |
||||
topology_id |
id |
No Action |
No Action |
|
Immediate |
|
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) |
![]() ![]() ![]() |