db_ecological_db
Previous topic Chapter index Next topic

Foreign Keys

 

Schema

Table

Foreign Key

Fields

FK Table

FK Fields

Delete Action

Update Action

Deferrable

Check Time

Description

application

tj_parent_role_rol_rol_prol

c_fk_child_role_prol

prol_child_role_id

application.t_role_rol

rol_id

Cascade

No Action

 

Immediate

Association of a child role.

application

tj_parent_role_rol_rol_prol

c_fk_parent_role_prol

prol_parent_role_id

application.t_role_rol

rol_id

Cascade

No Action

 

Immediate

Association of a parent role.

application

tj_rolepermission_rol_perm_rperm

c_fk_perm_rperm

rperm_perm_id

application.t_permission_perm

perm_id

Cascade

No Action

 

Immediate

Association of a permission to a role.

application

tj_rolepermission_rol_perm_rperm

c_fk_rol_rperm

rperm_rol_id

application.t_role_rol

rol_id

Cascade

No Action

 

Immediate

Association of a role with a permission.

application

tj_userrole_usr_rol_urol

c_fk_rol_urol

urol_rol_id

application.t_role_rol

rol_id

Cascade

No Action

 

Immediate

Associating a role with a user account.

application

tj_userrole_usr_rol_urol

c_fk_usr_urol

urol_usr_id

application.t_user_usr

usr_id

Cascade

No Action

 

Immediate

Associating a user account with a role.

public

t_grouping_grp

c_fk_fil_grp

grp_fil_id

public.tr_file_fil

fil_id

No Action

No Action

 

Immediate

a grouping can be attached to O or 1 file

public

t_grouping_grp

c_fk_prot_grp

grp_prot_id

public.tr_protocol_prot

prot_id

No Action

No Action

 

Immediate

a grouping can be attached to O or 1 protocol

public

t_grouping_grp

c_fk_std_grp

grp_std_id

public.tr_standard_std

std_id

No Action

No Action

 

Immediate

a grouping can be attached to O or 1 standard

public

t_grouping_grp

c_fk_tym_grp

grp_tym_id

public.tr_type_measure_tym

tym_id

No Action

No Action

 

Immediate

a grouping can be attached to O or 1 type of measure

public

t_grouping_grp

c_fk_uni_grp

grp_uni_id

public.tr_unit_uni

uni_id

No Action

No Action

 

Immediate

a grouping can be attached to O or 1 unit

public

t_measure_mzon

c_fk_fil_mzon

mzon_fil_id

public.tr_file_fil

fil_id

No Action

No Action

 

Immediate

a measurement can be attached to O or 1 file

public

t_measure_mzon

c_fk_prot_mzon

mzon_prot_id

public.tr_protocol_prot

prot_id

No Action

No Action

 

Immediate

a measurement can be attached to O or 1 protocol

public

t_measure_mzon

c_fk_std_mzon

mzon_std_id

public.tr_standard_std

std_id

No Action

No Action

 

Immediate

a measure can be attached to O or 1 standard

public

t_measure_mzon

c_fk_tym_mzon

mzon_tym_id

public.tr_type_measure_tym

tym_id

No Action

No Action

 

Immediate

a measure can be attached to O or 1 type of measure

public

t_measure_mzon

c_fk_uni_mzon

mzon_uni_id

public.tr_unit_uni

uni_id

No Action

No Action

 

Immediate

a measure can be attached to 0 or 1 unit

public

t_measure_mzon

c_fk_var_mzon

mzon_var_id

public.tr_variable_var

var_id

No Action

No Action

 

Immediate

a measure must be linked to one and only one variable

public

t_measure_mzon

c_fk_zon_mzon

mzon_zon_id

public.tr_study_zone_zon

zon_id

No Action

No Action

 

Immediate

a measure must be attached to one and only one object

public

tj_classifyvar_cvar

c_fk_rank_cvar

cvar_rank_id

public.tr_ranking_rank

rank_id

No Action

No Action

 

Immediate

The cvar_rank_id field necessarily corresponds to an existing ranking

public

tj_classifyvar_cvar

c_fk_var_cvar

cvar_var_id

public.tr_variable_var

var_id

No Action

No Action

 

Immediate

The cvar_var_id field must correspond to an existing variable

public

tj_grp_mzon_gmz

c_fk_grp_gmz

gmz_grp_id

public.t_grouping_grp

grp_id

No Action

No Action

 

Immediate

The gmz_grp_id field necessarily corresponds to an existing grouping

public

tj_grp_mzon_gmz

c_fk_mzon_gmz

gmz_mzon_id

public.t_measure_mzon

mzon_id

No Action

No Action

 

Immediate

The gmz_mzon_id field necessarily corresponds to an existing measurement

public

tj_mzon_mzon_tzon

c_fk_meta_mzon_tzon

tzon_meta_mzon_id

public.t_measure_mzon

mzon_id

No Action

No Action

 

Immediate

The tzon_meta_mzon_id field necessarily corresponds to an existing measurement

public

tj_mzon_mzon_tzon

c_fk_ref_mzon_tzon

tzon_ref_mzon_id

public.t_measure_mzon

mzon_id

No Action

No Action

 

Immediate

The tzon_ref_mzon_id field necessarily corresponds to an existing measurement

public

tj_role_ope_grp_rog

c_fk_grp_rog

rog_grp_id

public.t_grouping_grp

grp_id

No Action

No Action

 

Immediate

The rog_grp_id field necessarily corresponds to an existing grouping

public

tj_role_ope_grp_rog

c_fk_ope_rog

rog_ope_id

public.tr_operator_ope

ope_id

No Action

No Action

 

Immediate

The rog_ope_id field must correspond to an existing operator

public

tj_role_ope_grp_rog

c_fk_rol_rog

rog_rol_id

public.tr_role_rol

rol_id

No Action

No Action

 

Immediate

The rog_rol_id field must correspond to an existing role

public

tj_role_ope_mzon_roz

c_fk_mzon_roz

roz_mzon_id

public.t_measure_mzon

mzon_id

No Action

No Action

 

Immediate

The roz_mzon_id field necessarily corresponds to an existing measurement

public

tj_role_ope_mzon_roz

c_fk_ope_roz

roz_ope_id

public.tr_operator_ope

ope_id

No Action

No Action

 

Immediate

The roz_ope_id field necessarily corresponds to an existing operator

public

tj_role_ope_mzon_roz

c_fk_rol_roz

roz_rol_id

public.tr_role_rol

rol_id

No Action

No Action

 

Immediate

The roz_rol_id field must correspond to an existing role

public

tr_study_zone_zon

c_fk_typz_zon

zon_typz_id

public.tr_type_study_zone_typz

typz_id

No Action

No Action

 

Immediate

a study zone must be attached to 1 and 1 type of study zone

public

tr_taxon_tax

c_fk_ref_tax

tax_ref_id

public.tr_taxonomic_referential_ref

ref_id

No Action

No Action

 

Immediate

A taxon is linked to 1 and 1 single referential

topology

layer

layer_topology_id_fkey

topology_id

topology.topology

id

No Action

No Action

 

Immediate

 

This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com)
Previous topic Chapter index Next topic