DataModel(260702)
Tables (14)
Driver
- DriverID — String — Primary key — NOT NULL
- DriverType — String
- Status — String
- CurrentResourceInstanceID — String — Foreign key → ResourceInstance.ResourceInstanceID
DriverAssignment
- AssignmentID — String — Primary key — NOT NULL
- DriverID — String — Foreign key → Driver.DriverID — NOT NULL
- ResourceInstanceID — String — Foreign key → ResourceInstance.ResourceInstanceID — NOT NULL
- StartTime — DateTime
- EndTime — DateTime
- Status — String
DroneInstanceDetail
- ResourceInstanceID — String — Primary key — Foreign key → ResourceInstance.ResourceInstanceID — NOT NULL
- BatteryLevel — Float
- DockedTruckResourceInstanceID — String — Foreign key → ResourceInstance.ResourceInstanceID — Optional truck resource that carries or launches this drone.
Job
- JobID — String — Primary key — NOT NULL
- OriginLocationID — String — Foreign key → Location.LocationID — NOT NULL — Replaces DepartureStationID so jobs can start at any physical node.
- DestinationLocationID — String — Foreign key → Location.LocationID — NOT NULL
- RequestedQuantity — Int
- Status — String
- RequestedAt — DateTime
- DueTime — DateTime
JobTransport
- JobTransportID — String — Primary key — NOT NULL
- JobID — String — Foreign key → Job.JobID — NOT NULL
- LegNo — Int — NOT NULL — Sequence number of a transport leg within a job.
- FromLocationID — String — Foreign key → Location.LocationID — NOT NULL
- ToLocationID — String — Foreign key → Location.LocationID — NOT NULL
- RequiredResourceTypeID — String — Foreign key → ResourceType.ResourceTypeID — NOT NULL
- AssignedResourceInstanceID — String — Foreign key → ResourceInstance.ResourceInstanceID
- Status — String
- LoadQuantity — Int
- PlannedStartTime — DateTime
- PlannedEndTime — DateTime
- ActualStartTime — DateTime
- ActualEndTime — DateTime
Location
- LocationID — String — Primary key — NOT NULL
- LocationType — String — NOT NULL — Station, Depot, Customer, or TransferHub.
- Name — String — NOT NULL
- Address — String
- XCoord — Float
- YCoord — Float
MetroInstanceDetail
- ResourceInstanceID — String — Primary key — Foreign key → ResourceInstance.ResourceInstanceID — NOT NULL
- TrainNumber — String
- LineID — String
MetroSchedule
- ScheduleID — String — Primary key — NOT NULL
- TripID — String — Foreign key → MetroTrip.TripID — NOT NULL
- StationID — String — Foreign key → Station.StationID — NOT NULL
- StopSequence — Int
- ArrivalTime — DateTime
- DepartureTime — DateTime
MetroTrip
- TripID — String — Primary key — NOT NULL
- MetroResourceInstanceID — String — Foreign key → ResourceInstance.ResourceInstanceID — NOT NULL — The metro train resource assigned to this trip.
- LineID — String
- Direction — String
- StartTime — DateTime
- EndTime — DateTime
ResourceInstance
- ResourceInstanceID — String — Primary key — NOT NULL
- ResourceTypeID — String — Foreign key → ResourceType.ResourceTypeID — NOT NULL
- Status — String
- CurrentLocationID — String — Foreign key → Location.LocationID — NOT NULL
- NextLocationID — String — Foreign key → Location.LocationID
- CurrentPayload — Int
- EnergyLevel — Float — Current fuel or battery level as a numeric value.
- RemainingOperationTime — Int — Remaining work duration in minutes; not a DateTime.
ResourceType
- ResourceTypeID — String — Primary key — NOT NULL
- Mode — String — NOT NULL — Truck, Drone, or Metro.
- Capacity — Int
- FuelCapacity — Float
- BatteryCapacity — Float
Station
- StationID — String — Primary key — NOT NULL
- LocationID — String — Foreign key → Location.LocationID — NOT NULL — Connects a metro station to the common physical node model.
- StationType — String
- PlatformCapacity — Int
- StorageCapacity — Int
- CurrentPayload — Int
- Status — String
TravelTime
- TravelTimeID — String — Primary key — NOT NULL
- FromLocationID — String — Foreign key → Location.LocationID — NOT NULL
- ToLocationID — String — Foreign key → Location.LocationID — NOT NULL
- ResourceTypeID — String — Foreign key → ResourceType.ResourceTypeID — NOT NULL
- TravelTimeMinutes — Float — Duration value; the original DateTime type was incorrect.
- DistanceKm — Float — Optional distance used by routing or simulation.
TruckInstanceDetail
- ResourceInstanceID — String — Primary key — Foreign key → ResourceInstance.ResourceInstanceID — NOT NULL
- PlateNumber — String
- FuelLevel — Float