pggeodb.nancy.inra.fr/db_woodseer - db_woodseer on pggeodb.nancy.inra.fr
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

public

t_acquisition_acq

c_fk_adm_acq

acq_adm_id

public.tr_acquisition_detection_mean_adm

adm_id

No Action

No Action

 

Immediate

an acquisition can be associated to one mean of acquisition

public

t_acquisition_acq

c_fk_fil_acq

acq_fil_id

public.tr_file_fil

fil_id

No Action

No Action

 

Immediate

an acquisition must be associated to one source file

public

t_acquisition_acq

c_fk_obj_acq

acq_obj_id

public.t_object_obj

obj_id

No Action

No Action

 

Immediate

an acquisition must be associated to one and only one object

public

t_acquisition_acq

c_fk_prot_acq

acq_prot_id

public.tr_protocol_prot

prot_id

No Action

No Action

 

Immediate

an acquisition can be associated to one protocol

public

t_detection_singularity_det

c_fk_acq_det

det_acq_id

public.t_acquisition_acq

acq_id

No Action

No Action

 

Immediate

a singularity detection is associated to one and only one acquisition

public

t_detection_singularity_det

c_fk_adm_det

det_adm_id

public.tr_acquisition_detection_mean_adm

adm_id

No Action

No Action

 

Immediate

a singularity detection is associated to one and only one detection mean

public

t_detection_singularity_det

c_fk_fil_det

det_fil_id

public.tr_file_fil

fil_id

No Action

No Action

 

Immediate

a singularity detection is associated to one and only one source file

public

t_detection_singularity_det

c_fk_tsin_det

det_tsin_id

public.tr_type_singularity_tsin

tsin_id

No Action

No Action

 

Immediate

a singularity detection is associated to one and only one singularity type

public

t_measure_macq

c_fk_acq_macq

macq_acq_id

public.t_acquisition_acq

acq_id

No Action

No Action

 

Immediate

a measure must be attached to one and only one acquisition

public

t_measure_macq

c_fk_fil_macq

macq_fil_id

public.tr_file_fil

fil_id

No Action

No Action

 

Immediate

a measure can be attached to O or 1 file

public

t_measure_macq

c_fk_prot_macq

macq_prot_id

public.tr_protocol_prot

prot_id

No Action

No Action

 

Immediate

a measure can be attached to O or 1 protocol

public

t_measure_macq

c_fk_std_macq

macq_std_id

public.tr_standard_std

std_id

No Action

No Action

 

Immediate

a measure can be attached to O or 1 unit

public

t_measure_macq

c_fk_tym_macq

macq_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_macq

c_fk_uni_macq

macq_uni_id

public.tr_unit_uni

uni_id

No Action

No Action

 

Immediate

a measure can be attached to O or 1 unit

public

t_measure_macq

c_fk_var_macq

macq_var_id

public.tr_variable_var

var_id

No Action

No Action

 

Immediate

a measure must be attached to one and only one variable

public

t_measure_mdet

c_fk_det_mdet

mdet_det_id

public.t_detection_singularity_det

det_id

No Action

No Action

 

Immediate

a measure must be attached to one and only one singularity detection

public

t_measure_mdet

c_fk_fil_mdet

mdet_fil_id

public.tr_file_fil

fil_id

No Action

No Action

 

Immediate

a measure can be attached to O or 1 file

public

t_measure_mdet

c_fk_prot_mdet

mdet_prot_id

public.tr_protocol_prot

prot_id

No Action

No Action

 

Immediate

a measure can be attached to O or 1 protocol

public

t_measure_mdet

c_fk_std_mdet

mdet_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_mdet

c_fk_tym_mdet

mdet_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_mdet

c_fk_uni_mdet

mdet_uni_id

public.tr_unit_uni

uni_id

No Action

No Action

 

Immediate

a measure can be attached to O or 1 unit

public

t_measure_mdet

c_fk_var_mdet

mdet_var_id

public.tr_variable_var

var_id

No Action

No Action

 

Immediate

a measure must be attached to one and only one variable

public

t_measure_mobj

c_fk_fil_mobj

mobj_fil_id

public.tr_file_fil

fil_id

No Action

No Action

 

Immediate

a measure can be attached to O or 1 file

public

t_measure_mobj

c_fk_obj_mobj

mobj_obj_id

public.t_object_obj

obj_id

No Action

No Action

 

Immediate

a measure must be attached to one and only one object

public

t_measure_mobj

c_fk_prot_mobj

mobj_prot_id

public.tr_protocol_prot

prot_id

No Action

No Action

 

Immediate

a measure can be attached to O or 1 protocol

public

t_measure_mobj

c_fk_std_mobj

mobj_std_id

public.tr_standard_std

std_id

No Action

No Action

 

Immediate

a measure can be attached to O or 1 unit

public

t_measure_mobj

c_fk_tym_mobj

mobj_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_mobj

c_fk_uni_mobj

mobj_uni_id

public.tr_unit_uni

uni_id

No Action

No Action

 

Immediate

a measure can be attached to O or 1 unit

public

t_measure_mobj

c_fk_var_mobj

mobj_var_id

public.tr_variable_var

var_id

No Action

No Action

 

Immediate

a measure must be attached to one and only one variable

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

t_object_obj

c_fk_nobj_obj

obj_nobj_id

public.tr_nature_object_nobj

nobj_id

No Action

No Action

 

Immediate

An object is link to 1 and only 1 nature of object

public

t_object_obj

c_fk_proj_obj

obj_proj_id

public.t_project_proj

proj_id

No Action

No Action

 

Immediate

An object is link to 1 and only 1 project

public

t_object_obj

c_fk_tax_obj

obj_tax_id

public.tr_taxon_tax

tax_id

No Action

No Action

 

Immediate

An object is link to 0 or 1 taxon

public

t_object_obj

c_fk_zon_obj

obj_zon_id

public.tr_study_zone_zon

zon_id

No Action

No Action

 

Immediate

An object is link to 0 or 1 study zone

public

tj_classification_var_cvar

c_fk_cla_cvar

cvar_cla_id

public.tr_classification_cla

cla_id

No Action

No Action

 

Immediate

The cvar_cla_id field must correspond to an existing variable classification

public

tj_classification_var_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_detection_singularity_pairing_dsp

c_fk_det_source_dsp

dsp_det_id_source

public.t_detection_singularity_det

det_id

No Action

No Action

 

Immediate

identifier of the source singularity detection paired is required

public

tj_detection_singularity_pairing_dsp

c_fk_det_target_dsp

dsp_det_id_target

public.t_detection_singularity_det

det_id

No Action

No Action

 

Immediate

identifier of the target singularity detection paired is required

public

tj_rol_ope_macq_romacq

c_fk_macq_romacq

romacq_macq_id

public.t_measure_macq

macq_id

No Action

No Action

 

Immediate

The rom_macq_id field necessarily corresponds to an existing measure

public

tj_rol_ope_macq_romacq

c_fk_ope_romacq

romacq_ope_id

public.tr_operator_ope

ope_id

No Action

No Action

 

Immediate

The rom_ope_id field necessarily corresponds to an existing operator

public

tj_rol_ope_macq_romacq

c_fk_rol_romacq

romacq_rol_id

public.tr_role_rol

rol_id

No Action

No Action

 

Immediate

The rom_rol_id field necessarily corresponds to an existing role

public

tj_rol_ope_mdet_romdet

c_fk_mdet_romdet

romdet_mdet_id

public.t_measure_mdet

mdet_id

No Action

No Action

 

Immediate

The rom_mdet_id field necessarily corresponds to an existing measure

public

tj_rol_ope_mdet_romdet

c_fk_ope_romdet

romdet_ope_id

public.tr_operator_ope

ope_id

No Action

No Action

 

Immediate

The rom_ope_id field necessarily corresponds to an existing operator

public

tj_rol_ope_mdet_romdet

c_fk_rol_romdet

romdet_rol_id

public.tr_role_rol

rol_id

No Action

No Action

 

Immediate

The rom_rol_id field necessarily corresponds to an existing role

public

tj_rol_ope_mobj_romobj

c_fk_mobj_romobj

romobj_mobj_id

public.t_measure_mobj

mobj_id

No Action

No Action

 

Immediate

The rom_mobj_id field necessarily corresponds to an existing measure

public

tj_rol_ope_mobj_romobj

c_fk_ope_romobj

romobj_ope_id

public.tr_operator_ope

ope_id

No Action

No Action

 

Immediate

The rom_ope_id field necessarily corresponds to an existing operator

public

tj_rol_ope_mobj_romobj

c_fk_rol_romobj

romobj_rol_id

public.tr_role_rol

rol_id

No Action

No Action

 

Immediate

The rom_rol_id field necessarily corresponds to an existing role

public

tj_rol_ope_mzon_romzon

c_fk_mzon_romzon

romzon_mzon_id

public.t_measure_mzon

mzon_id

No Action

No Action

 

Immediate

The rom_mzon_id field necessarily corresponds to an existing measure

public

tj_rol_ope_mzon_romzon

c_fk_ope_romzon

romzon_ope_id

public.tr_operator_ope

ope_id

No Action

No Action

 

Immediate

The rom_ope_id field necessarily corresponds to an existing operator

public

tj_rol_ope_mzon_romzon

c_fk_rol_romzon

romzon_rol_id

public.tr_role_rol

rol_id

No Action

No Action

 

Immediate

The rom_rol_id field necessarily corresponds to an existing role

public

tj_transformation_matrix_tra

c_fk_acq_source_tra

tra_acq_id_source

public.t_acquisition_acq

acq_id

No Action

No Action

 

Immediate

Identifier of the source acquisition of the transformation is required

public

tj_transformation_matrix_tra

c_fk_acq_target_tra

tra_acq_id_target

public.t_acquisition_acq

acq_id

No Action

No Action

 

Immediate

identifier of the target acquisition of the transformation is required

public

tr_file_fil

c_fk_typf_fil

fil_typf_id

public.tr_type_file_typf

typf_id

No Action

No Action

 

Immediate

The file must correspond to a file type

public

tr_protocol_prot

c_fk_fil_prot

prot_fil_id

public.tr_file_fil

fil_id

No Action

No Action

 

Immediate

 

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) at 07/12/2018 13:23
Previous topic Chapter index Next topic