Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| uuid | uuid | 2147483647 | √ | null |
|
|
||
| geom | geometry | 2147483647 | √ | null |
|
|
||
| datum | text | 2147483647 | √ | null |
|
|
||
| actualiteit | numeric | 0 | √ | null |
|
|
||
| conditie | text | 2147483647 | √ | null |
|
|
||
| fase | text | 2147483647 | √ | null |
|
|
||
| gebied | text | 2147483647 | √ | null |
|
|
||
| symbool | text | 2147483647 | √ | null |
|
|
||
| symbool_id | int2 | 5 | √ | null |
|
|
||
| label | text | 2147483647 | √ | null |
|
|
||
| bijzonderheden | text | 2147483647 | √ | null |
|
|
||
| aanleg | date | 13 | √ | null |
|
|
||
| code | text | 2147483647 | √ | null |
|
|
||
| beheerder | text | 2147483647 | √ | null |
|
|
||
| particulier | text | 2147483647 | √ | null |
|
|
||
| adres | text | 2147483647 | √ | null |
|
|
||
| revisie_frequentie | int2 | 5 | √ | null |
|
|
||
| opstelplaats | bool | 1 | √ | null |
|
|
||
| opstelplaats_locatie | text | 2147483647 | √ | null |
|
|
||
| markering | text | 2147483647 | √ | null |
|
|
||
| toegang | text | 2147483647 | √ | null |
|
|
||
| putdeksel_locatie | text | 2147483647 | √ | null |
|
|
||
| putdeksel_waterdiepte | numeric | 0 | √ | null |
|
|
||
| verzonken | bool | 1 | √ | null |
|
|
||
| diameter_leiding | numeric | 0 | √ | null |
|
|
||
| inspecteur | text | 2147483647 | √ | null |
|
|
||
| inspectie_datum | date | 13 | √ | null |
|
|
||
| inspectie_opmerking | text | 2147483647 | √ | null |
|
|
||
| inspectie_conditie_id | int2 | 5 | √ | null |
|
|
||
| inspectie_opstelplaats | text | 2147483647 | √ | null |
|
|
||
| inspectie_reiniging | date | 13 | √ | null |
|
|
||
| inspectie_locatie | text | 2147483647 | √ | null |
|
|
||
| inspectie_markering | text | 2147483647 | √ | null |
|
|
||
| inspectie_beplanting | text | 2147483647 | √ | null |
|
|
||
| inspectie_obstakels | text | 2147483647 | √ | null |
|
|
||
| inspectie_bereikbaarheid | text | 2147483647 | √ | null |
|
|
||
| inspectie_waterdiepte | text | 2147483647 | √ | null |
|
|
||
| inspectie_bluswater | text | 2147483647 | √ | null |
|
|