DataModel2-1
Tables (15)
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
- JobID — String — Primary key — Foreign key → Job.JobID — NOT NULL
- LegNo — Int — Primary key — 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
- TripID — String — Primary key — Foreign key → MetroTrip.TripID — NOT NULL
- StopSequence — Int — Primary key — NOT NULL
- StationID — String — Foreign key → Station.StationID — NOT NULL
- 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
TimeBand
- TimeBandID — String — Primary key — NOT NULL
- TimeBandName — String — NOT NULL
- DayType — String — Weekday, Weekend, or Holiday.
- StartMinute — Int — NOT NULL — Start time as minutes from 00:00. Example: 420 means 07:00.
- EndMinute — Int — NOT NULL — End time as minutes from 00:00. Example: 600 means 10:00.
TravelTime
- FromLocationID — String — Primary key — Foreign key → Location.LocationID — NOT NULL
- ToLocationID — String — Primary key — Foreign key → Location.LocationID — NOT NULL
- ResourceTypeID — String — Primary key — Foreign key → ResourceType.ResourceTypeID — NOT NULL
- TimeBandID — String — Primary key — Foreign key → TimeBand.TimeBandID — NOT NULL
- TravelTimeMinutes — Float — Time-band-specific travel duration in minutes. For truck travel, store one row per time band.
- DistanceKm — Float — Optional distance used by routing or simulation.
TruckInstanceDetail
- ResourceInstanceID — String — Primary key — Foreign key → ResourceInstance.ResourceInstanceID — NOT NULL
- PlateNumber — String
- FuelLevel — Float