Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| waardepeildatum | numeric | 8 | null |
|
|
PK N8 - Waardepeildatum |
||
| status_beschikking | numeric | 2 | √ | null |
|
|
N2 - Status beschikking |
|
| toestandspeildatum | numeric | 8 | √ | null |
|
|
N8 - Toestandspeildatum |
|
| vastgestelde_waarde | numeric | 11 | √ | null |
|
|
N11 - Vastgestelde waarde |
|
| fk_1woz_nummer | numeric | 12 | null |
|
|
FK N12, FK naar woz_obj.nummer |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| woz_waarde_archief_pk | Primary key | Asc/Asc | waardepeildatum + fk_1woz_nummer |
Relationships
Close relationships within degrees of separation
