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