Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| tabel | varchar | 30 | null |
|
|
|||
| tabel_identificatie | varchar | 50 | null |
|
|
|||
| identificatie | varchar | 50 | null |
|
|
|||
| gemeente | int4 | 10 | √ | null |
|
|
||
| omschrijving | varchar | 255 | √ | null |
|
|
||
| datum | date | 13 | √ | null |
|
|
||
| ref_id | varchar | 50 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| brondocument_pkey | Primary key | Asc/Asc/Asc | tabel + tabel_identificatie + identificatie |
| brondocument_identificatie_idx | Performance | Asc | identificatie |
| brondocument_omschrijving_idx | Performance | Asc | omschrijving |
| brondocument_ref_id | Performance | Asc | ref_id |
| brondocument_tabel_identif_idx | Performance | Asc | tabel_identificatie |
| brondocument_tabel_idx | Performance | Asc | tabel |
Relationships
Close relationships within degrees of separation
