| id | name | population |
|---|---|---|
| 1 | New York | 8419000 |
| 2 | Los Angeles | 3792600 |
| 3 | Chicago | 2693910 |
| 4 | Houston | 2209945 |
| 5 | Phoenix | 1660273 |
| 6 | Philadelphia | 1526000 |
| id | mode |
|---|---|
| 1 | Buses |
| 2 | Trains |
| 3 | Taxis |
| 4 | Cycling |
| 5 | Walking |
| id | road_id | city_id | length |
|---|---|---|---|
| (→ City.id) | |||
| 1 | 1 | 1 | 10.0 |
| 2 | 2 | 1 | 15.0 |
| 3 | 3 | 2 | 20.0 |
| 4 | 4 | 2 | 25.0 |
| 5 | 5 | 3 | 30.0 |
| 6 | 6 | 3 | 35.0 |
| 7 | 7 | 4 | 40.0 |
| 8 | 8 | 4 | 45.0 |
| 9 | 9 | 5 | 50.0 |
| 10 | 10 | 5 | 55.0 |
| id | volume | road_id | timestamp |
|---|---|---|---|
| (→ Roads.id) | |||
| 1 | 1000 | 1 | 2024-01-30 18:39:55 |
| 2 | 1500 | 2 | 2024-01-30 18:39:55 |
| 3 | 2000 | 3 | 2024-01-30 18:39:55 |
| 4 | 2500 | 4 | 2024-01-30 18:39:55 |
| 5 | 3000 | 5 | 2024-01-30 18:39:55 |
| 6 | 3500 | 6 | 2024-01-30 18:39:55 |
| 7 | 4000 | 7 | 2024-01-30 18:39:55 |
| 8 | 4500 | 8 | 2024-01-30 18:39:55 |
| 9 | 5000 | 9 | 2024-01-30 18:39:55 |
| 10 | 5500 | 10 | 2024-01-30 18:39:55 |
| id | accident_type | severity | road_id | timestamp |
|---|---|---|---|---|
| (→ Roads.id) | ||||
| 1 | Fender Bender | Minor | 1 | 2024-01-30 18:39:55 |
| 2 | Hit and Run | Moderate | 2 | 2024-01-30 18:39:55 |
| 3 | Head-on Collision | Major | 3 | 2024-01-30 18:39:55 |
| 4 | Multi Vehicle Pileup | Catastrophic | 4 | 2024-01-30 18:39:55 |
| 5 | DUI Accident | Serious | 5 | 2024-01-30 18:39:55 |
| 6 | Distracted Driver Accident | Moderate | 6 | 2024-01-30 18:39:55 |
| 7 | Speeding Ticket | Minor | 7 | 2024-01-30 18:39:55 |
| 8 | Reckless Driving | Major | 8 | 2024-01-30 18:39:55 |
| 9 | Texting While Driving | Minor | 9 | 2024-01-30 18:39:55 |
| 10 | Red Light Running | Serious | 10 | 2024-01-30 18:39:55 |
| city_id | transportation_mode_id |
|---|---|
| (→ City.id) | (→ Transportation_Mode.id) |
| 1 | 1 |
| 1 | 2 |
| 2 | 1 |
| 2 | 2 |
| 3 | 1 |
| 3 | 3 |
| 4 | 1 |
| 4 | 4 |
| 5 | 1 |
| 5 | 5 |
| 6 | 1 |