Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | int4 | 10 | null |
|
|
Unique ID des Traktes |
|||||
| created_at | timestamp | 29,6 | CURRENT_TIMESTAMP |
|
|
Erstellungsdatum |
|||||
| modified_at | timestamp | 29,6 | √ | null |
|
|
|||||
| modified_by | regrole | 2147483647 | √ | (CURRENT_USER)::regrole |
|
|
|||||
| select_access_by | _text | 2147483647 | ARRAY[]::text[] |
|
|
||||||
| update_access_by | _text | 2147483647 | ARRAY[]::text[] |
|
|
||||||
| supervisor_id | int4 | 10 | √ | null |
|
|
|||||
| topo_map_sheet | "private_ci2027_001"."ck_topographicmapsheet" | 10 | √ | null |
|
|
Nummer der topgraphischen Karte 1:25.000 |
||||
| state_responsible | "private_ci2027_001"."enum_state" | 2147483647 | null |
|
|
Aufnahme-Bundesland für Feldaufnahmen und ggf. Vorklärungsmerkmale |
|||||
| state | "private_ci2027_001"."enum_state" | 2147483647 | √ | null |
|
|
Standard-Land für Ecken und Wege, meist wie Aufnahmeland “StandardBl” |
||||
| states_affected | "private_ci2027_001"."_enum_state" | 2147483647 | √ | null |
|
|
zugehörige Ländernummer(n), auch mehrere |
||||
| grid_density | "private_ci2027_001"."enum_grid_density" | 2147483647 | null |
|
|
Zugehörigkeit zum Stichprobennetz, Netzdichte |
|||||
| cluster_status | "private_ci2027_001"."enum_cluster_status" | 2147483647 | √ | null |
|
|
Traktkennung / Traktkennzeichen lt. Vorklärung durch vTI |
||||
| cluster_situation | "private_ci2027_001"."enum_cluster_situation" | 2147483647 | √ | null |
|
|
Lage des Traktes im Vergleich zu Bundesland- und Landesgrenzen |
||||
| is_locked | bool | 1 | √ | false |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| cluster_pkey | Primary key | Asc | id |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| check_update_access_by_emails_constraint | (private_ci2027_001.check_select_access_by_emails(update_access_by)) |
| check_select_access_by_emails_constraint | (private_ci2027_001.check_select_access_by_emails(select_access_by)) |