db

Tables (9)

Chassis (Untitled5)

  • ChassisID (chassis_id) — String — Primary key — NOT NULL
  • CurrentTruckID (truck_id) — String — Foreign key → Truck.TruckID
  • CurrentYardID (yard_id) — String — Foreign key → Yard.YardID — NOT NULL
  • Type (chassis_type) — String — NOT NULL
  • Field

Container (Untitled6)

  • ContainerID (container_id) — String — Primary key — NOT NULL
  • CurrentChassisID (chassis_id) — String — Foreign key → Chassis.ChassisID
  • CurrentYardID (yard_id) — String — Foreign key → Yard.YardID — NOT NULL
  • Type (container_type) — String
  • Field

Division (Untitled)

  • DivisionID (division_id) — String — Primary key — NOT NULL
  • Name (division_name) — String

Drive (Untitled3)

  • DriverID (driver_id) — String — Primary key — NOT NULL
  • DriverName (driver_name) — String
  • CurrentYard (yard_id) — String
  • Field

Site (Untitled9)

  • SiteId (site_id) — String — Primary key — NOT NULL
  • YardID (yard_id) — String — Foreign key → Yard.YardID — NOT NULL
  • EquipmentType (equipment_type) — String
  • Capacity (site_cap) — Int
  • OccupiedSpaces (Field) — Int
  • Field2

Trailer (Untitled7)

  • TrailerID (trailer_id) — String — Primary key — NOT NULL
  • CurrentTruckID (truck_id) — String — Foreign key → Truck.TruckID — NOT NULL
  • CurrentYardID (yard_id) — String — Foreign key → Yard.YardID — NOT NULL
  • Size (trailer_type) — String
  • Field

Transaction (Untitled8)

  • TransactionID (transaction_id) — Int — Primary key — NOT NULL
  • Type(IN/OUT) (transaction_type) — String
  • EquipmentType (equipment_type) — String
  • EquipmentID (equipment_id) — String
  • Time (transaction_time) — DateTime
  • FromYardID (yard_id_out) — String — Foreign key → Yard.YardID
  • ToYardID (yard_id_in) — String — Foreign key → Yard.YardID

Truck (Untitled4)

  • TruckID (truck_id) — String — Primary key — NOT NULL
  • CurrentYardID (yard_id) — String — Foreign key → Yard.YardID — NOT NULL
  • DriverID (driver_id) — String — Foreign key → Drive.DriverID

Yard (Untitled2)

  • YardID (yard_id) — String — Primary key — NOT NULL
  • DivisionID (division_id) — String — Foreign key → Division.DivisionID — NOT NULL