Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| dat_beg_geldh_deelobj | varchar | 19 | √ | null |
|
|
|||||
| nummer | numeric | 12 | null |
|
|
PK N12 - Nummer WOZ-deelobject |
|||||
| code | varchar | 4 | √ | null |
|
|
AN4 - Code WOZ-deelobject |
||||
| datum_einde_geldh_deelobj | varchar | 19 | √ | null |
|
|
OnvolledigeDatum - Datum einde geldigheid deelobject |
||||
| status | numeric | 2 | √ | null |
|
|
N2 - Status WOZ-deelobject |
||||
| fk_4pnd_identif | varchar | 16 | √ | null |
|
|
FK AN16, FK naar pand.identif: “bestaat uit” |
||||
| fk_5tgo_identif | varchar | 16 | √ | null |
|
|
FK AN16, FK naar benoemd_obj.identif: “bestaat uit” |
||||
| fk_6woz_nummer | numeric | 12 | √ | null |
|
|
FK N12, FK naar woz_obj.nummer: “is onderdeel van” |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| woz_deelobj_pk | Primary key | Asc | nummer |
Relationships
Close relationships within degrees of separation
