DataModel2

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

  • 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

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
  • 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