List of references

Name

Code

Parent Table

Child Table

Foreign Key Columns

Parent Role

Child Role

FKCDS001_CDS001_001

FKCDS001_CDS001_001

TBCDS001_PSA

TBCDS001_PSA

ID_PSA_PAI

 

 

FKCDS001_CDS002_002

FKCDS001_CDS002_002

TBCDS001_PSA

TBCDS002_PSA_JRDCA

ID_PSA_JRDCA

 

 

FKCDS001_CDS003_003

FKCDS001_CDS003_003

TBCDS001_PSA

TBCDS003_PSA_FSCA

ID_PSA_FSCA

 

 

FKCDS001_CDS005_004

FKCDS001_CDS005_004

TBCDS001_PSA

TBCDS005_RLCNO

ID_PSA

 

 

FKCDS001_CDS005_005

FKCDS001_CDS005_005

TBCDS001_PSA

TBCDS005_RLCNO

ID_PSA_RLCNA

 

 

FKCDS001_CDS018_006

FKCDS001_CDS018_006

TBCDS001_PSA

TBCDS018_TLFNE_PSA

ID_PSA

 

 

FKCDS001_CDS020_007

FKCDS001_CDS020_007

TBCDS001_PSA

TBCDS020_EML_PSA

ID_PSA

 

 

FKCDS001_CDS023_008

FKCDS001_CDS023_008

TBCDS001_PSA

TBCDS023_DADO_BNCRO

ID_PSA

 

 

FKCDS001_CDS030_009

FKCDS001_CDS030_009

TBCDS001_PSA

TBCDS030_ENDRO_PSA

ID_PSA

 

 

FKCDS001_CDS037_010

FKCDS001_CDS037_010

TBCDS001_PSA

TBCDS037_DCMNO

ID_PSA

 

 

FKCDS001_CDS039_011

FKCDS001_CDS039_011

TBCDS001_PSA

TBCDS039_STO_INTRT

ID_PSA

 

 

FKCDS002_CDS004_012

FKCDS002_CDS004_012

TBCDS002_PSA_JRDCA

TBCDS004_UNDDE_CASSI

ID_UNDDE_CASSI

 

 

FKCDS003_CDS007_013

FKCDS003_CDS007_013

TBCDS003_PSA_FSCA

TBCDS007_PSA_FSCA_INSTO_FRMCO

ID_PSA_FSCA

 

 

FKCDS003_CDS009_014

FKCDS003_CDS009_014

TBCDS003_PSA_FSCA

TBCDS009_PSA_FSCA_DFCNA

ID_PSA_FSCA

 

 

FKCDS003_CDS016_

FKCDS003_CDS016_

TBCDS003_PSA_FSCA

TBCDS016_PSA_FSCA_INVLZ

ID_PSA_FSCA

 

 

FKCDS003_CDS054_015

FKCDS003_CDS054_015

TBCDS054_ESTDO_CVL

TBCDS003_PSA_FSCA

ID_ESTDO_CVL

 

 

FKCDS003_CDS057_016

FKCDS003_CDS057_016

TBCDS003_PSA_FSCA

TBCDS057_PSA_FSCA_NTRZA

ID_PSA_FSCA

 

 

FKCDS006_CDS005_017

FKCDS006_CDS005_017

TBCDS006_TIPO_RLCNO

TBCDS005_RLCNO

ID_TIPO_RLCNO

 

 

FKCDS007_CDS008_018

FKCDS007_CDS008_018

TBCDS008_INSTO_FRMCO

TBCDS007_PSA_FSCA_INSTO_FRMCO

ID_INSTO_FRMCO

 

 

FKCDS007_CDS013_

FKCDS007_CDS013_

TBCDS007_PSA_FSCA_INSTO_FRMCO

TBCDS013_DCMNO_INSTO_FRMCO

ID_PSA_FSCA_INSTO_FRMCO

 

 

FKCDS010_CDS009_019

FKCDS010_CDS009_019

TBCDS010_DFCNA

TBCDS009_PSA_FSCA_DFCNA

ID_DFCNA

 

 

FKCDS010_CDS016_

FKCDS010_CDS016_

TBCDS010_DFCNA

TBCDS016_PSA_FSCA_INVLZ

ID_DFCNA

 

 

FKCDS011_CDS009_020

FKCDS011_CDS009_020

TBCDS011_GRAU_DFCNA

TBCDS009_PSA_FSCA_DFCNA

ID_GRAU_DFCNA

 

 

FKCDS014_CDS003_021

FKCDS014_CDS003_021

TBCDS014_TIPO_SNGNO

TBCDS003_PSA_FSCA

ID_TIPO_SNGNO

 

 

FKCDS015_CDS003_022

FKCDS015_CDS003_022

TBCDS015_COR

TBCDS003_PSA_FSCA

ID_COR

 

 

FKCDS017_CDS016_

FKCDS017_CDS016_

TBCDS017_TIPO_INVLZ

TBCDS016_PSA_FSCA_INVLZ

ID_TIPO_INVLZ

 

 

FKCDS018_CDS012_

FKCDS018_CDS012_

TBCDS018_TLFNE_PSA

TBCDS012_ENDRO_TLFNE_PSA

ID_TLFNE_PSA

 

 

FKCDS019_CDS018_023

FKCDS019_CDS018_023

TBCDS019_TIPO_OPRDA

TBCDS018_TLFNE_PSA

ID_TIPO_OPRDA

 

 

FKCDS021_CDS020_024

FKCDS021_CDS020_024

TBCDS021_CTGRA_EML

TBCDS020_EML_PSA

ID_CTGRA_EML

 

 

FKCDS022_CDS023_025

FKCDS022_CDS023_025

TBCDS022_TIPO_CNTA

TBCDS023_DADO_BNCRO

ID_TIPO_CNTA

 

 

FKCDS024_CDS025_

FKCDS024_CDS025_

TBCDS024_RGO

TBCDS025_RGO_ESTDO_PRVNA

Identificador Regiao

 

 

FKCDS026_CDS018_026

FKCDS026_CDS018_026

TBCDS026_CTGRA_TLFNE

TBCDS018_TLFNE_PSA

ID_CTGRA_TLFNE

 

 

FKCDS027_CDS018_027

FKCDS027_CDS018_027

TBCDS027_TIPO_TLFNE

TBCDS018_TLFNE_PSA

ID_TIPO_TLFNE

 

 

FKCDS028_CDS029_

FKCDS028_CDS029_

TBCDS028_PRTE

TBCDS029_PRTE_ESTDO_PRVNA

Identificador Porte

 

 

FKCDS030_CDS012_

FKCDS030_CDS012_

TBCDS030_ENDRO_PSA

TBCDS012_ENDRO_TLFNE_PSA

ID_ENDRO_PSA

 

 

FKCDS030_CDS067_028

FKCDS030_CDS067_028

TBCDS030_ENDRO_PSA

TBCDS067_ENDRO_INFRA

ID_ENDRO_PSA

 

 

FKCDS036_CDS035_029

FKCDS036_CDS035_029

TBCDS036_ORGO_EMSR

TBCDS035_TIPO_DCMNO_ORGO_EMSR

ID_ORGO_EMSR

 

 

FKCDS036_CDS037_030

FKCDS036_CDS037_030

TBCDS036_ORGO_EMSR

TBCDS037_DCMNO

ID_ORGO_EMSR

 

 

FKCDS037_CDS013_

FKCDS037_CDS013_

TBCDS037_DCMNO

TBCDS013_DCMNO_INSTO_FRMCO

ID_DCMNO

 

 

FKCDS037_CDS034_031

FKCDS037_CDS034_031

TBCDS037_DCMNO

TBCDS034_DCMNO_MDA_ARQVO

ID_DCMNO

 

 

FKCDS038_CDS035_032

FKCDS038_CDS035_032

TBCDS038_TIPO_DCMNO

TBCDS035_TIPO_DCMNO_ORGO_EMSR

ID_TIPO_DCMNO

 

 

FKCDS038_CDS037_033

FKCDS038_CDS037_033

TBCDS038_TIPO_DCMNO

TBCDS037_DCMNO

ID_TIPO_DCMNO

 

 

FKCDS040_CDS002_034

FKCDS040_CDS002_034

TBCDS040_ATVDE_ECNMA

TBCDS002_PSA_JRDCA

ID_ATVDE_ECNMA

 

 

FKCDS046_CDS003_035

FKCDS046_CDS003_035

TBCDS046_ETNA

TBCDS003_PSA_FSCA

ID_ETNA

 

 

FKCDS047_CDS030_036

FKCDS047_CDS030_036

TBCDS047_CTGRA_ENDRO

TBCDS030_ENDRO_PSA

ID_CTGRA_ENDRO

 

 

FKCDS053_CDS001_037

FKCDS053_CDS001_037

TBCDS053_TIPO_PSA

TBCDS001_PSA

ID_TIPO_PSA

 

 

FKCDS055_CDS003_038

FKCDS055_CDS003_038

TBCDS055_SEXO

TBCDS003_PSA_FSCA

ID_SEXO

 

 

FKCDS056_CDS002_039

FKCDS056_CDS002_039

TBCDS056_TIPO_PSA_JRDCA

TBCDS002_PSA_JRDCA

ID_TIPO_PSA_JRDCA

 

 

FKCDS058_CDS057_040

FKCDS058_CDS057_040

TBCDS058_TIPO_NTRZA

TBCDS057_PSA_FSCA_NTRZA

ID_TIPO_NTRZA

 

 

FKCDS063_CDS003_041

FKCDS063_CDS003_041

TBCDS063_GNRO

TBCDS003_PSA_FSCA

ID_GNRO

 

 


2