StreetID | Street_Name | Block_Number | Bus_Stop | NumLanes | MaxSpeed |
---|---|---|---|---|---|
1 | Main St | 123 | 1 | 2 | 30 |
2 | Elm St | 456 | 0 | 1 | 25 |
3 | Pine Ave | 789 | 1 | 2 | 30 |
4 | Maple Dr | 101 | 0 | 2 | 25 |
5 | Oak Blvd | 123 | 1 | 4 | 40 |
AccidentID | Date | LocationID | Severity |
---|---|---|---|
(→ Streets.StreetID) | |||
1 | 2022-01-01 10:00:00 | 1 | Minor |
2 | 2022-02-01 14:30:00 | 2 | Moderate |
3 | 2022-03-01 19:00:00 | 3 | Major |
4 | 2022-04-01 23:30:00 | 4 | Catastrophic |
5 | 2022-05-01 01:00:00 | 5 | Fatal |
VehicleID | Type | LicensePlate | OwnerID |
---|---|---|---|
(→ Users.UserID) | |||
1 | Car | ABC123 | 1 |
2 | Truck | DEF456 | 2 |
3 | SUV | GHI789 | 3 |
4 | Motorcycle | JKL012 | 4 |
5 | Van | LMN321 | 5 |
UserID | FirstName | LastName | PhoneNumber | |
---|---|---|---|---|
1 | John | Doe | john.doe@example.com | +1234567890 |
2 | Jane | Smith | jane.smith@example.com | +0987654321 |
3 | Alice | Brown | alice.brown@example.com | +1123456789 |
4 | Bob | White | bob.white@example.com | +0987654321 |
5 | Charlie | Black | charlie.black@example.com | +1123456789 |
WorkID | StartDate | EndDate | StreetID | WorkType |
---|---|---|---|---|
(→ Streets.StreetID) | ||||
1 | 2022-06-01 08:00:00 | 2022-06-02 18:00:00 | 1 | Repair |
2 | 2022-07-01 08:00:00 | 2022-07-02 18:00:00 | 2 | Resurfacing |
3 | 2022-08-01 08:00:00 | 2022-08-02 18:00:00 | 3 | Construction |
4 | 2022-09-01 08:00:00 | 2022-09-02 18:00:00 | 4 | Drainage |
5 | 2022-10-01 08:00:00 | 2022-10-02 18:00:00 | 5 | Landscaping |
TicketID | IssueDate | OffenderVehicleID | FineAmount |
---|---|---|---|
(→ Vehicles.VehicleID) | |||
1 | 2022-01-15 12:34:56 | 1 | 50 |
2 | 2022-02-15 12:34:56 | 2 | 100 |
3 | 2022-03-15 12:34:56 | 3 | 75 |
4 | 2022-04-15 12:34:56 | 4 | 125 |
5 | 2022-05-15 12:34:56 | 5 | 150 |