TABLES
16
VIEWS
2
COLUMNS
174
Constraints
41
Anomalies
0
Routines
0
Database Properties
Database Type: PostgreSQL - 12.15 (Ubuntu 12.15-1.pgdg18.04+1)
Schema public
standard public schema
Tables
| Table / View | Children | Parents | Columns | Rows | Type | Comments |
|---|---|---|---|---|---|---|
| trip | 2 | 4 | 16 | 21 | Table | Holds all trips |
| trip_user | 0 | 6 | 18 | 31 | Table | Holds all trip users (driver, assistants and passengers) |
| carmodel | 1 | 1 | 9 | 0 | Table | Holds all car models |
| absencetype | 1 | 2 | 10 | 0 | Table | Holds all absence types |
| mileage | 0 | 5 | 13 | 49 | Table | Holds all mileages |
| mileagetype | 1 | 0 | 3 | 0 | Table | Holds all mileage types |
| car_registration | 0 | 4 | 11 | 21 | Table | Holds all registrations of a car |
| manufacturer | 1 | 0 | 2 | 0 | Table | Holds all manufacturers |
| staff_contract | 0 | 5 | 12 | 23 | Table | Holds all staff contracts (e.g. work/employment contract) |
| locale | 0 | 0 | 5 | 0 | Table | Holds all locales |
| car | 3 | 4 | 11 | 0 | Table | Holds all cars |
| approvaltype | 1 | 0 | 4 | 0 | Table | Holds all approval types |
| tripusertype | 1 | 1 | 4 | 0 | Table | Holds all trip user types |
| staff | 1 | 4 | 9 | 0 | Table | Holds all staff records |
| absence | 0 | 5 | 13 | 0 | Table | Holds all absence records |
| jobtitle | 1 | 0 | 3 | 0 | Table | Holds all job titles |
| _trip | 0 | 0 | 17 | 0 | View | |
| _car | 0 | 0 | 14 | 0 | View |