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)