Database Properties
Database Type: PostgreSQL - 17.11 (Debian 17.11-1.pgdg12+2)
Tables
| Table / View | Children | Parents | Columns | Rows | Type | Comments |
|---|---|---|---|---|---|---|
| editing_sessions | 0 | 1 | 11 | -1 | Table | |
| glossary_road_class | 1 | 1 | 3 | -1 | Table | Glossary for the column road_scale of the table roads |
| nodes | 2 | 0 | 5 | -1 | Table | Road graph nodes |
| glossary_graph_check | 5 | 0 | 8 | -1 | Table | Checks of the road graph run by the function check_graph. The rows are added by the plugin migrations: only the columns default_options and is_active should be modified. |
| markers | 0 | 1 | 10 | -1 | Table | Road distance markers |
| edges | 0 | 3 | 18 | -1 | Table | Road graph edges |
| roads | 2 | 3 | 11 | -1 | Table | Roads. This is a non-spatial table listing all unique roads codes. It is a parent of the table edges. |
| metadata | 0 | 0 | 4 | -1 | Table | Metadata of the structure : version and date. Usefull for database structure and glossary data migrations between versions |
| managed_objects | 0 | 0 | 8 | -1 | Table | Table listing all managed objects in the road graph system |
| v_managed_objects | 0 | 0 | 8 | 0 | View | View allowing to see the merged geometries of each managed table for the last editing session merge. Useful to have a quick look at the edited objects. |
| v_road_without_zero_marker | 0 | 1 | 1 | 0 | View | |
| vm_managed_objects | 0 | 0 | 8 | 0 | View | Materialized view based on the view v_managed_objects, showing the merged geometries of each managed table for the last editing session merge. It is refreshed at the end of the function merge_editing_session_data. |