rsgb.public

77 Foreign Key Constraints

Constraint Name

Child Column

Parent Column

Delete Rule

fk_kad_onrrnd_zk_his_rel_sc_lh

kad_onrrnd_zk_his_rel.fk_sc_lh_koz_kad_identif

kad_onrrnd_zk.kad_identif

Cascade on delete

fk_inn_sc

ingeschr_niet_nat_prs.sc_identif

niet_nat_prs.sc_identif

Cascade on delete

fk_huw_ger_partn_sc_lh

huw_ger_partn.fk_sc_lh_inp_sc_identif

ingeschr_nat_prs.sc_identif

Cascade on delete

fk_huw_ger_partn_sc_rh

huw_ger_partn.fk_sc_rh_inp_sc_identif

ingeschr_nat_prs.sc_identif

Cascade on delete

fk_huw_ger_partn_ho_2

huw_ger_partn.fk_ho_lnd_code_iso

land.code_iso

Cascade on delete

fk_huw_ger_partn_hs_2

huw_ger_partn.fk_hs_lnd_code_iso

land.code_iso

Cascade on delete

fk_huishoudenrel_sc_lh

huishoudenrel.fk_sc_lh_inp_sc_identif

ingeschr_nat_prs.sc_identif

Cascade on delete

fk_huishoudenrel_sc_rh

huishoudenrel.fk_sc_rh_hhd_nummer

huishouden.nummer

Cascade on delete

fk_inp_nt_2

ingeschr_nat_prs.fk_nt_nat_code

nation.code

Cascade on delete

fk_inp_rl_3

ingeschr_nat_prs.fk_3nat_code

nation.code

Cascade on delete

fk_inp_1n_1

ingeschr_nat_prs.fk_1rsd_nummer

rsdoc.nummer

Cascade on delete

fk_inp_sc

ingeschr_nat_prs.sc_identif

nat_prs.sc_identif

Cascade on delete

fk_wav_1n_1

watervakonderdeel.fk_1wad_identif

waterdeel.identif

Cascade on delete

fk_wav_sc

watervakonderdeel.sc_identif

waterdeel.identif

Cascade on delete

fk_zra_as_6

zak_recht_aantek.fk_6pes_sc_identif

prs.sc_identif

Cascade on delete

fk_zra_as_5

zak_recht_aantek.fk_5zkr_kadaster_identif

zak_recht.kadaster_identif

Cascade on delete

fk_bce_sc

brugconstructie_element.sc_identif

kunstwerkdeel.identif

Cascade on delete

fk_woz_omvat_sc_rh

woz_omvat.fk_sc_rh_woz_nummer

woz_obj.nummer

Cascade on delete

fk_ves_as_18

vestg.fk_18ves_sc_identif

vestg.sc_identif

Cascade on delete

fk_ves_as_17

vestg.fk_17mac_kvk_nummer

maatschapp_activiteit.kvk_nummer

Cascade on delete

fk_ves_as_15

vestg.fk_15ond_kvk_nummer

ondrnmng.kvk_nummer

Cascade on delete

fk_ves_sa_2

vestg.fk_sa_sbi_activiteit_sbi_code

sbi_activiteit.sbi_code

Cascade on delete

fk_ves_as_19

vestg.fk_19mac_kvk_nummer

maatschapp_activiteit.kvk_nummer

Cascade on delete

fk_woz_belang_sc_lh

woz_belang.fk_sc_lh_sub_identif

subject.identif

Cascade on delete

fk_woz_belang_sc_rh

woz_belang.fk_sc_rh_woz_nummer

woz_obj.nummer

Cascade on delete

fk_apr_kdp_nn_lh

app_re_kad_perceel.fk_nn_lh_apr_sc_kad_identif

app_re.sc_kad_identif

Cascade on delete

fk_apr_kdp_nn_rh

app_re_kad_perceel.fk_nn_rh_kdp_sc_kad_identif

kad_perceel.sc_kad_identif

Cascade on delete

fk_apr_sc

app_re.sc_kad_identif

kad_onrrnd_zk.kad_identif

Cascade on delete

fk_apr_as_2

app_re.fk_2nnp_sc_identif

niet_nat_prs.sc_identif

Cascade on delete

fk_wrd_1n_1

woz_waarde.fk_1woz_nummer

woz_obj.nummer

Cascade on delete

fk_ves1

vestg_naam.fk_ves_sc_identif

vestg.sc_identif

Cascade on delete

fk_rsd_inp_nn_rh

rsdoc_ingeschr_nat_prs.fk_nn_rh_inp_sc_identif

ingeschr_nat_prs.sc_identif

Cascade on delete

fk_rsd_inp_nn_lh

rsdoc_ingeschr_nat_prs.fk_nn_lh_rsd_nummer

rsdoc.nummer

Cascade on delete

fk_koz_as_7

kad_onrrnd_zk.fk_7kdg_code

kad_gemeente.code

Cascade on delete

fk_koz_as_10

kad_onrrnd_zk.fk_10pes_sc_identif

prs.sc_identif

Cascade on delete

fk_tgo_koz_nn_rh

benoemd_obj_kad_onrrnd_zk.fk_nn_rh_koz_kad_identif

kad_onrrnd_zk.kad_identif

Cascade on delete

fk_wvd_sc

wegvakonderdeel.sc_identif

wegdeel.identif

Cascade on delete

fk_wvd_1n_1

wegvakonderdeel.fk_1wgd_identif

wegdeel.identif

Cascade on delete

fk_kza_as_5

kad_onrrnd_zk_aantek.fk_5pes_sc_identif

prs.sc_identif

Cascade on delete

fk_kza_as_4

kad_onrrnd_zk_aantek.fk_4koz_kad_identif

kad_onrrnd_zk.kad_identif

Cascade on delete

fk_otv_1n_1

onbegr_terreinvakonderd.fk_1obt_identif

onbegr_terr_dl.identif

Cascade on delete

fk_otv_sc

onbegr_terreinvakonderd.sc_identif

onbegr_terr_dl.identif

Cascade on delete

fk_functionaris_sc_lh

functionaris.fk_sc_lh_pes_sc_identif

prs.sc_identif

Cascade on delete

fk_functionaris_sc_rh

functionaris.fk_sc_rh_pes_sc_identif

prs.sc_identif

Cascade on delete

fk_nps_rl_2

nat_prs.fk_2acd_code

academische_titel.code

Cascade on delete

fk_nps_sc

nat_prs.sc_identif

prs.sc_identif

Cascade on delete

fk_koz_koz_nn_lh

kad_onrrnd_zk_kad_onrrnd_zk.fk_nn_lh_koz_kad_identif

kad_onrrnd_zk.kad_identif

Cascade on delete

fk_koz_koz_nn_rh

kad_onrrnd_zk_kad_onrrnd_zk.fk_nn_rh_koz_kad_identif

kad_onrrnd_zk.kad_identif

Cascade on delete

fk_pes_sc

prs.sc_identif

subject.identif

Cascade on delete

fk_ouder_kind_rel_sc_lh

ouder_kind_rel.fk_sc_lh_inp_sc_identif

ingeschr_nat_prs.sc_identif

Cascade on delete

fk_ouder_kind_rel_sc_rh

ouder_kind_rel.fk_sc_rh_inp_sc_identif

ingeschr_nat_prs.sc_identif

Cascade on delete

vestg_activiteit_fk_sbi_activiteit_code_fkey

vestg_activiteit.fk_sbi_activiteit_code

sbi_activiteit.sbi_code

Restrict delete

vestg_activiteit_fk_vestg_nummer_fkey

vestg_activiteit.fk_vestg_nummer

vestg.sc_identif

Restrict delete

fk_rsd_rl_7

rsdoc.fk_7rds_rsdoccode

rsdocsoort.rsdoccode

Cascade on delete

fk_ann_sc

ander_btnlnds_niet_nat_prs.sc_identif

niet_nat_prs.sc_identif

Cascade on delete

fk_mac_as_4

maatschapp_activiteit.fk_4pes_sc_identif

prs.sc_identif

Cascade on delete

fk_mac_as_3

maatschapp_activiteit.fk_3ond_kvk_nummer

ondrnmng.kvk_nummer

Cascade on delete

fk_ves_tgo_nn_lh

vestg_benoemd_obj.fk_nn_lh_ves_sc_identif

vestg.sc_identif

Cascade on delete

fk_nin_sc

niet_ingezetene.sc_identif

ingeschr_nat_prs.sc_identif

Cascade on delete

fk_locaand_openb_rmte_sc_rh

locaand_openb_rmte.fk_sc_rh_woz_nummer

woz_obj.nummer

Cascade on delete

fk_ond_as_4

ondrnmng.fk_4mac_kvk_nummer

maatschapp_activiteit.kvk_nummer

Cascade on delete

fk_ond_1n_1

ondrnmng.fk_1ond_kvk_nummer

ondrnmng.kvk_nummer

Cascade on delete

fk_nnp_sc

niet_nat_prs.sc_identif

prs.sc_identif

Cascade on delete

fk_ing_sc

ingezetene.sc_identif

ingeschr_nat_prs.sc_identif

Cascade on delete

fk_ing_as_8

ingezetene.fk_8vbt_aand

verblijfstitel.aand

Cascade on delete

fk_kdp_as_7

kad_perceel.fk_7kdp_sc_kad_identif

kad_perceel.sc_kad_identif

Cascade on delete

fk_kdp_sc

kad_perceel.sc_kad_identif

kad_onrrnd_zk.kad_identif

Cascade on delete

fk_locaand_adres_sc_rh

locaand_adres.fk_sc_rh_woz_nummer

woz_obj.nummer

Cascade on delete

fk_wdo_as_6

woz_deelobj.fk_6woz_nummer

woz_obj.nummer

Cascade on delete

fk_btv_sc

begr_terreinvakonderd.sc_identif

begr_terr_dl.identif

Cascade on delete

fk_btv_1n_1

begr_terreinvakonderd.fk_1btd_identif

begr_terr_dl.identif

Cascade on delete

fk_gem_gem_nn_lh

gemeente_gemeente.fk_nn_lh_gem_code

gemeente.code

Cascade on delete

fk_gem_gem_nn_rh

gemeente_gemeente.fk_nn_rh_gem_code

gemeente.code

Cascade on delete

fk_zkr_as_7

zak_recht.fk_7koz_kad_identif

kad_onrrnd_zk.kad_identif

Cascade on delete

fk_zkr_as_8

zak_recht.fk_8pes_sc_identif

prs.sc_identif

Cascade on delete

fk_zkr_rl_2

zak_recht.fk_2aard_recht_verkort_aand

aard_recht_verkort.aand

Cascade on delete

fk_anp_sc

ander_nat_prs.sc_identif

nat_prs.sc_identif

Cascade on delete

Check Constraints

Table	Constraint Name	Constraint
spatial_ref_sys	spatial_ref_sys_srid_check	((srid > 0) AND (srid <= 998999))