TABLES
17
VIEWS
0
COLUMNS
255
Constraints
45
Anomalies
1
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 |
|---|---|---|---|---|---|
| routes | 4 | 3 | 21 | Table | |
| vehicle_tracking_statuses | 0 | 3 | 16 | Table | |
| stops | 2 | 3 | 18 | Table | |
| user_tenants | 0 | 2 | 6 | Table | |
| packages | 2 | 8 | 21 | Table | |
| alembic_version | 0 | 0 | 1 | Table | |
| assignment_insights | 0 | 2 | 14 | Table | |
| tasks | 5 | 4 | 27 | Table | |
| vehicles | 6 | 2 | 16 | Table | |
| shipments | 3 | 4 | 30 | Table | |
| vehicle_position_logs | 1 | 2 | 15 | Table | |
| audit_logs | 0 | 1 | 12 | Table | |
| tenants | 14 | 0 | 8 | Table | |
| users | 1 | 0 | 8 | Table | |
| package_events | 0 | 7 | 16 | Table | |
| hubs | 7 | 1 | 15 | Table | |
| task_package_links | 0 | 3 | 11 | Table |