TABLES
11
VIEWS
0
COLUMNS
67
Constraints
10
Anomalies
0
Routines
0
Database Properties
Database Type: PostgreSQL - 10.7 (Ubuntu 10.7-1.pgdg18.04+1)
Tables
| Table / View | Children | Parents | Columns | Rows | Type | Comments |
|---|---|---|---|---|---|---|
| movements | 0 | 1 | 11 | 330916 | Table | |
| aggregated_movements | 0 | 1 | 7 | 33839 | Table | |
| monitored_areas | 5 | 2 | 7 | 3 | Table | |
| statistics | 0 | 1 | 4 | 379 | Table | |
| device | 1 | 0 | 2 | 3 | Table | |
| screenshots | 0 | 1 | 3 | 2 | Table | |
| zone_sequences | 2 | 1 | 5 | 84 | Table | |
| detection_parameters | 1 | 0 | 3 | 3 | Table | |
| zones | 0 | 1 | 6 | 13 | Table | |
| transits | 1 | 1 | 5 | 59318 | Table | |
| aggregated_trajectories | 0 | 1 | 14 | 12046 | Table |