Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | int4 | 10 | √ | null |
|
|
Unique ID |
||||
| label | text | 2147483647 | null |
|
|
Editing session label. Keep it short |
|||||
| text | 2147483647 | null |
|
|
Author of the editing session |
||||||
| created_at | timestamp | 29,6 | √ | (now())::timestamp(0) without time zone |
|
|
Creation timestamp |
||||
| updated_at | timestamp | 29,6 | √ | (now())::timestamp(0) without time zone |
|
|
Update timestamp |
||||
| description | text | 2147483647 | √ | null |
|
|
Description of the session |
||||
| geom | geometry | 2147483647 | √ | null |
|
|
|||||
| status | text | 2147483647 | 'created'::text |
|
|
Current status : created, cloned, edited, merged |
|||||
| unique_code | text | 2147483647 | concat('editing_session_', to_char(now(), 'YYYY_MM_DD_HH_MI_SS'::text)) |
|
|
Automatically generated code with timestamp like editing_session_2025_09_26_08_37_24 |
|||||
| cloned_ids | jsonb | 2147483647 | √ | null |
|
|
Object containing the list of unique ids for each cloned data (roads, edges, nodes, etc.) |
||||
| logged_ids | jsonb | 2147483647 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| editing_sessions_pkey | Primary key | Asc | id |
| editing_sessions_geom_idx | Performance | Asc | geom |
Relationships
Close relationships within degrees of separation
