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