Database Properties
Database Type: PostgreSQL - 13.14 (Debian 13.14-1.pgdg110+2)
Tables
| Table / View | Children | Parents | Columns | Rows | Type | Comments |
|---|---|---|---|---|---|---|
| project | 1 | 0 | 6 | 0 | Table | List of projects, which represents a group of indicators |
| series | 2 | 4 | 5 | 0 | Table | Series of data |
| actor_category | 1 | 0 | 3 | 0 | Table | Actors categories |
| actor | 2 | 1 | 6 | 0 | Table | Actors |
| deleted_data_log | 0 | 0 | 3 | 0 | Table | Log of deleted objects from observation table. Use for synchronization purpose |
| indicator | 4 | 0 | 9 | 0 | Table | Groups of observation data for decisional purpose. |
| protocol | 1 | 0 | 5 | 0 | Table | List of protocols |
| project_view | 0 | 1 | 6 | 0 | Table | Allow to filter the access on projects and relative data (indicators, observations, etc.) with a spatial object for a given list of user groups. There must be at least one project view for the project, of type global. The other views must be of type filter. |
| glossary | 0 | 0 | 6 | 0 | Table | List of labels and words used as labels for stored data |
| spatial_layer | 2 | 1 | 7 | 0 | Table | List the spatial layers, used to regroup the spatial data. Ex : cities, rivers, stations |
| import | 1 | 1 | 4 | 0 | Table | Journal des imports |
| observation | 0 | 3 | 11 | 0 | Table | Les données brutes au format pivot ( indicateur, date, valeurs et entité spatiale, auteur, etc.) |
| r_indicator_node | 0 | 2 | 2 | 0 | Table | Pivot table between indicators and nodes |
| spatial_object | 1 | 1 | 10 | 0 | Table | Contains all the spatial objects, caracterized by a geometry type and an entity |
| dimension | 0 | 1 | 6 | 0 | Table | Stores the different dimensions characteristics of an indicator |
| graph_node | 1 | 0 | 2 | 0 | Table | Graph nodes, to store key words used to find an indicator. |
| document | 0 | 1 | 9 | 0 | Table | List of documents for describing indicators. |
| metadata | 0 | 0 | 4 | 0 | Table | Metadata of the structure : version and date. Usefull for database structure and glossary data migrations between versions |
| r_graph_edge | 0 | 0 | 2 | 0 | Table | Graph edges: relations between nodes |