Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| identificatie | varchar | 255 | null |
|
|
|||
| begingeldigheid | date | 13 | null |
|
|
|||
| begrenzing_perceel | geometry | 2147483647 | null |
|
|
|||
| kadastralegrootte | numeric | 9,1 | √ | null |
|
|
||
| soortgrootte | varchar | 100 | √ | null |
|
|
||
| perceelnummerrotatie | numeric | 3,1 | √ | null |
|
|
||
| perceelnummer_deltax | numeric | 20,10 | √ | null |
|
|
||
| perceelnummer_deltay | numeric | 20,10 | √ | null |
|
|
||
| plaatscoordinaten | geometry | 2147483647 | null |
|
|
|||
| meettariefverschuldigd | bool | 1 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| perceel_archief_pkey | Primary key | Asc/Asc | identificatie + begingeldigheid |
| perceel_archief_begrenzing_perceel | Performance | Asc | begrenzing_perceel |
| perceel_archief_plaatscoordinaten | Performance | Asc | plaatscoordinaten |
Relationships
Close relationships within degrees of separation
