pggeodb-preprod.nancy.inra.fr/db_diams
Previous topic Chapter index Next topic

Foreign Keys

 

Schema

Table

Foreign Key

Columns

FK Table

FK Columns

Delete Action

Update Action

Deferrable

Check Time

Description

public

chn

stk_echant

sk_echant

public.pedotheque

id_echant

No Action

No Action

 

Immediate

 

public

chn_frac

stk_echant_frac

sk_echant_frac

public.pedotheque

id_echant

No Action

No Action

 

Immediate

 

public

itk

stk_parcel

parcelle

public.parcelle_diams

id_parcelle

No Action

No Action

 

Immediate

 

public

itk_autre

st_itk_autre

stk_itk_autre

public.itk

id_itk

No Action

No Action

 

Immediate

 

public

itk_fertilisation

st_itk_ferti

stk_itk_ferti

public.itk

id_itk

No Action

No Action

 

Immediate

 

public

itk_protection

sk_itk_protect

stk_itk_protect

public.itk

id_itk

No Action

No Action

 

Immediate

 

public

itk_recolte

st_itk_recolte

stk_itk_recolte

public.itk

id_itk

No Action

No Action

 

Immediate

 

public

itk_semis

stk_itk_sem

stk_itk_sem

public.itk

id_itk

No Action

No Action

 

Immediate

 

public

itk_trav_sol

st_itk_trav

stk_itk_trav

public.itk

id_itk

No Action

No Action

 

Immediate

 

public

microresp_diams

stk_ech_micro

sk_echant_micro

public.pedotheque

id_echant

No Action

No Action

 

Immediate

 

public

modalite_diams

stk_placette_mod

id_placette_mod

public.placette_diams

id_placette

No Action

No Action

 

Immediate

 

public

placette_diams

stk_bloc_placette

id_bloc_placette

public.bloc_diams

id_bloc

No Action

No Action

 

Immediate

 

public

placette_diams

stk_parcelle_placette

id_parcelle_placette

public.parcelle_diams

id_parcelle

No Action

No Action

 

Immediate

 

public

spectre

st_spe_ech

spect_echant

public.pedotheque

id_echant

No Action

No Action

 

Immediate

 

public

spectre

st_t_spectro

t_spectro

public.type_spectro

id_spectro

No Action

No Action

 

Immediate

 

public

spectre_phyto

st_spe_ech_phyt

spect_echant_phyto

public.phytotheque

id_phyto

No Action

No Action

 

Immediate

 

public

spectre_phyto

st_t_spectro_phy

t_spectro_phyto

public.type_spectro_phyto

id_spectro_phyto

No Action

No Action

 

Immediate

 

public

utilisateur_projet

stk_user_proj

stk_user

public.utilisateur

id_user

No Action

No Action

 

Immediate

 

public

vers_de_terre

stk_pedo_vers

sk_pedo_vers

public.pedotheque

id_echant

No Action

No Action

 

Immediate

 

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