IntegrateDataModel

Tables (10)

Driver

  • DriverID — String — Primary key — NOT NULL
  • DriverType — String
  • Status — String
  • CurrentResourceInstanceID — String — Foreign key → ResourceInstance.ResourceInstanceID

Job

  • JobID — String — Primary key — NOT NULL
  • OriginLocationID — String — Foreign key → Location.LocationID — NOT NULL — 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

MetroSchedule

  • TripID — String — Primary key — NOT NULL
  • StopSequence — Int — Primary key — NOT NULL
  • MetroResourceInstanceID — String — Foreign key → ResourceInstance.ResourceInstanceID — NOT NULL — MetroTrip merged into MetroSchedule.
  • LineID — String
  • Direction — String
  • StationID — String — Foreign key → Station.StationID — NOT NULL
  • StartTime — DateTime — Trip-level field repeated per stop after denormalization.
  • EndTime — DateTime — Trip-level field repeated per stop after denormalization.
  • ArrivalTime — DateTime
  • DepartureTime — 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.
  • PlateNumber — String — Truck-only attribute merged from TruckInstanceDetail.
  • FuelLevel — Float — Truck-only attribute merged from TruckInstanceDetail.
  • BatteryLevel — Float — Drone-only attribute merged from DroneInstanceDetail.
  • DockedTruckResourceInstanceID — String — Foreign key → ResourceInstance.ResourceInstanceID — Drone-only optional truck resource that carries or launches this drone.
  • TrainNumber — String — Metro-only attribute merged from MetroInstanceDetail.
  • LineID — String — Metro-only line identifier merged from MetroInstanceDetail.
  • DriverID — String — Foreign key → Driver.DriverID — Current or planned assigned driver. Merged from DriverAssignment.
  • DriverAssignmentStartTime — DateTime
  • DriverAssignmentEndTime — DateTime
  • DriverAssignmentStatus — String

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.