Database

Tables (7)

ChassisID (Untitled5)

  • ChassisID (Key) — Primary key — NOT NULL
  • YardID (Key2) — Primary key — NOT NULL
  • YardID (Key3) — Foreign key → YardID.YardID — NOT NULL
  • DivisionID (Key22) — Foreign key → YardID.DivisionID — NOT NULL
  • DivisionID (Key32) — Foreign key → YardID.DivisionID — NOT NULL
  • Type (Field)

ContainerID (Untitled6)

  • ContainerID (Key) — Primary key — NOT NULL
  • YardID (Key2) — Primary key — NOT NULL
  • YardID (Key3) — Foreign key → YardID.YardID — NOT NULL
  • DivisionID (Key22) — Foreign key → YardID.DivisionID — NOT NULL
  • DivisionID (Key32) — Foreign key → YardID.DivisionID — NOT NULL
  • Size (Field)
  • Type (Field2)

DivisionID (Untitled)

  • DivisionID (Key) — Primary key — NOT NULL
  • Name (Field)

DriverID (Untitled3)

  • DriverID (Key) — Primary key — NOT NULL
  • Name (Field)
  • LicenseNumber (Field2)

TrailerID (Untitled7)

  • TrailerID (Key) — Primary key — NOT NULL
  • YardID (Key2) — Primary key — NOT NULL
  • YardID (Key3) — Foreign key → YardID.YardID — NOT NULL
  • DivisionID (Key22) — Foreign key → YardID.DivisionID — NOT NULL
  • DivisionID (Key32) — Foreign key → YardID.DivisionID — NOT NULL
  • TruckID (Key4) — Foreign key → TruckID.TruckID — NOT NULL
  • YardID (Key23) — Foreign key → TruckID.YardID — NOT NULL
  • YardID (Key33) — Foreign key → TruckID.YardID — NOT NULL
  • DivisionID (Key222) — Foreign key → TruckID.DivisionID — NOT NULL
  • DivisionID (Key322) — Foreign key → TruckID.DivisionID — NOT NULL
  • DriverID (Key42) — Foreign key → TruckID.DriverID — NOT NULL
  • Size (Field)

TruckID (Untitled4)

  • TruckID (Key) — Primary key — NOT NULL
  • YardID (Key2) — Primary key — NOT NULL
  • YardID (Key3) — Foreign key → YardID.YardID — NOT NULL
  • DivisionID (Key22) — Foreign key → YardID.DivisionID — NOT NULL
  • DivisionID (Key32) — Foreign key → YardID.DivisionID — NOT NULL
  • DriverID (Key4) — Foreign key → DriverID.DriverID — NOT NULL
  • Status (Field)

YardID (Untitled2)

  • YardID (Key) — Primary key — NOT NULL
  • DivisionID (Key2) — Primary key — NOT NULL
  • DivisionID (Key3) — Foreign key → DivisionID.DivisionID — NOT NULL
  • Location (Field)