Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| fk_sc_lh_inp_sc_identif | varchar | 255 | null |
|
|
FK AN32, FK naar ingeschr_nat_prs.sc_identif (is FK naar superclass SUBJECT) |
|||||
| fk_sc_rh_inp_sc_identif | varchar | 255 | null |
|
|
FK AN32, FK naar ingeschr_nat_prs.sc_identif (is FK naar superclass SUBJECT) |
|||||
| datum_einde_fam_recht_betr | varchar | 19 | √ | null |
|
|
OnvolledigeDatum - Datum einde familierechtelijke betrekking |
||||
| datum_ingang_fam_recht_betr | numeric | 8 | √ | null |
|
|
N8 - Datum ingang familierechtelijke betrekking |
||||
| ouder_aand | varchar | 6 | √ | null |
|
|
AN6 - Ouder-aanduiding |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| ouder_kind_rel_pk | Primary key | Asc/Asc | fk_sc_lh_inp_sc_identif + fk_sc_rh_inp_sc_identif |
Relationships
Close relationships within degrees of separation
