Diagram_bluescreen
Tables (11)
Asset_Locations (asset_locations)
- Asset_Type (asset_type) — Primary key — NOT NULL
- Asset_Id (asset_id) — Primary key — NOT NULL
Chassis (chassis)
- Chassis_Id (chassis_id) — Primary key — NOT NULL
- Type (type)
Containers (containers)
- Container_Id (container_id) — Primary key — NOT NULL
- Type (type)
- Size (size)
Divisions (divisions)
- Division_Id (division_id) — Primary key — NOT NULL
Drivers (drivers)
- Driver_Id (driver_id) — Primary key — NOT NULL
- Division_Id (division_id) — Foreign key → Divisions.Division_Id — NOT NULL
Parking_Slots (parking_slots)
- Slot_Id (slot_id) — Primary key — NOT NULL
- Site_Id (site_id) — Foreign key → Sites.Site_Id — NOT NULL
Sites (sites)
- Site_Id (site_id) — Primary key — NOT NULL
- Yard_Id (yard_id) — Foreign key → Yards.Yard_Id — NOT NULL
Trailers (trailers)
- Trailer_Id (trailer_id) — Primary key — NOT NULL
- Size (size)
Transactions (transactions)
- Transaction_Id (transaction_id) — Primary key — NOT NULL
- Driver_Id (driver_id) — Foreign key → Drivers.Driver_Id — NOT NULL
- Yard_Id (yard_id) — Foreign key → Yards.Yard_Id — NOT NULL
Trucks (trucks)
- Truck_Id (truck_id) — Primary key — NOT NULL
- Type (type)
Yards (yards)
- Yard_Id (yard_id) — Primary key — NOT NULL
- Division_Id (division_id) — Foreign key → Divisions.Division_Id — NOT NULL