Streets

StreetIDStreet_NameBlock_NumberBus_StopNumLanesMaxSpeed
1Main St1231230
2Elm St4560125
3Pine Ave7891230
4Maple Dr1010225
5Oak Blvd1231440

Accidents

AccidentIDDateLocationIDSeverity
(→ Streets.StreetID)
12022-01-01 10:00:001Minor
22022-02-01 14:30:002Moderate
32022-03-01 19:00:003Major
42022-04-01 23:30:004Catastrophic
52022-05-01 01:00:005Fatal

Vehicles

VehicleIDTypeLicensePlateOwnerID
(→ Users.UserID)
1CarABC1231
2TruckDEF4562
3SUVGHI7893
4MotorcycleJKL0124
5VanLMN3215

Users

UserIDFirstNameLastNameEmailPhoneNumber
1JohnDoejohn.doe@example.com+1234567890
2JaneSmithjane.smith@example.com+0987654321
3AliceBrownalice.brown@example.com+1123456789
4BobWhitebob.white@example.com+0987654321
5CharlieBlackcharlie.black@example.com+1123456789

RoadWorks

WorkIDStartDateEndDateStreetIDWorkType
(→ Streets.StreetID)
12022-06-01 08:00:002022-06-02 18:00:001Repair
22022-07-01 08:00:002022-07-02 18:00:002Resurfacing
32022-08-01 08:00:002022-08-02 18:00:003Construction
42022-09-01 08:00:002022-09-02 18:00:004Drainage
52022-10-01 08:00:002022-10-02 18:00:005Landscaping

SpeedingTickets

TicketIDIssueDateOffenderVehicleIDFineAmount
(→ Vehicles.VehicleID)
12022-01-15 12:34:56150
22022-02-15 12:34:562100
32022-03-15 12:34:56375
42022-04-15 12:34:564125
52022-05-15 12:34:565150