TABLES
18
VIEWS
2
COLUMNS
178
Constraints
17
Anomalies
0
Routines
0
Database Properties
Database Type: PostgreSQL - 15.8 (Debian 15.8-1.pgdg110+1)
Schema public
standard public schema
Tables
| Table / View | Children | Parents | Columns | Type | Comments |
|---|---|---|---|---|---|
| permission | 1 | 0 | 7 | Table | |
| route | 2 | 1 | 8 | Table | |
| trip | 1 | 3 | 12 | Table | |
| unit | 2 | 3 | 11 | Table | |
| location_log | 1 | 1 | 7 | Table | |
| spatial_ref_sys | 2 | 0 | 5 | Table | |
| stop | 3 | 0 | 10 | Table | |
| driver | 1 | 1 | 9 | Table | |
| route_stop_link | 0 | 2 | 7 | Table | |
| user | 2 | 0 | 9 | Table | |
| place | 0 | 0 | 12 | Table | |
| stop_time | 0 | 2 | 9 | Table | |
| user_role_link | 0 | 2 | 7 | Table | |
| role | 2 | 0 | 7 | Table | |
| agency | 1 | 0 | 8 | Table | |
| role_permission_link | 0 | 2 | 7 | Table | |
| calendar | 1 | 0 | 14 | Table | |
| sync_queue | 0 | 0 | 15 | Table | |
| geography_columns | 0 | 1 | 7 | View | |
| geometry_columns | 0 | 1 | 7 | View |