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_hhd_nummer | numeric | 12 | null |
|
|
FK N12, FK naar huishouden.nummer |
|||||
| huishoudenrelcode | numeric | 1 | √ | null |
|
|
N1 - Huishoudenrelatiecode |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| huishoudenrel_pk | Primary key | Asc/Asc | fk_sc_lh_inp_sc_identif + fk_sc_rh_hhd_nummer |
Relationships
Close relationships within degrees of separation
