Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | serial | 10 | √ | nextval('private_ci2027_001.edges_id_seq'::regclass) |
|
|
Primärschlüssel |
||||
| plot_id | int4 | 10 | null |
|
|
Fremdschlüssel auf Plot |
|||||
| created_at | timestamp | 29,6 | CURRENT_TIMESTAMP |
|
|
Erstellungszeitpunkt |
|||||
| modified_at | timestamp | 29,6 | √ | null |
|
|
|||||
| modified_by | regrole | 2147483647 | √ | (CURRENT_USER)::regrole |
|
|
|||||
| edge_state | "private_ci2027_001"."enum_edge_state" | 2147483647 | null |
|
|
Kennziffer des Wald-/Bestandesrandes |
|||||
| edge_type | "private_ci2027_001"."enum_edge_type" | 2147483647 | null |
|
|
Art des Wald- /Bestandesrandes |
|||||
| terrain | "private_ci2027_001"."enum_terrain" | 2147483647 | null |
|
|
Vorgelagertes Terrain |
|||||
| geometry | geometry | 2147483647 | √ | null |
|
|
Geometrie der Kante |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| edges_pkey | Primary key | Asc | id |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| ck_edges_geometry | (st_isvalid(geometry)) |