DataMode_260713_2

Tables (13)

DroneInstance

  • DroneInstanceID — String — Primary key — Foreign key → TransportInstance.TransportInstanceID — NOT NULL
  • BatteryStatus — String
  • Status — String
  • Payload — Int
  • CurrentLocationID — String — Foreign key → Location.LocationID — NOT NULL
  • NextLocationID — String — Foreign key → Location.LocationID — NOT NULL
  • TruckInstanceID — String — Foreign key → TruckInstance.TruckInstanceID
  • RemainingOperationTime — DateTime

Location

  • LocationID — String — Primary key — NOT NULL
  • LocationType — String

MetroDriverID

  • DriverID — String — Primary key — NOT NULL
  • Status — String
  • RemainingOperationTime — DateTime
  • MetroInstanceID — String — Foreign key → MetroInstance.MetroInstanceID — NOT NULL

MetroInstance

  • MetroInstanceID — String — Primary key — Foreign key → TransportInstance.TransportInstanceID — NOT NULL
  • DriverID — String
  • Status — String
  • Payload — Int
  • CurrentStationID — String — Foreign key → Station.StationID — NOT NULL
  • RemainingOperationTime — DateTime
  • NextStationID — String — Foreign key → Station.StationID — NOT NULL

MetroSchedule

  • MetroScheduleID — String — Primary key — NOT NULL
  • StationID — String — Foreign key → Station.StationID — NOT NULL
  • MetroInstanceID — String — Foreign key → MetroInstance.MetroInstanceID — NOT NULL
  • DateTime — DateTime

OrderInfo

  • OrderID — String — Primary key — NOT NULL
  • DepartureLocationID — String — Foreign key → Location.LocationID — NOT NULL
  • DestinationLocationID — String — Foreign key → Location.LocationID — NOT NULL
  • OrderStatus — Int

OrderTransport

  • OrderTransportID — String — Primary key — NOT NULL
  • OrderID — String — Foreign key → OrderInfo.OrderID — NOT NULL
  • TransportInstanceID — String — Foreign key → TransportInstance.TransportInstanceID — NOT NULL

ResourceType

  • ResourceTypeID — String — Primary key — NOT NULL
  • Capacity — Float
  • FuelCapacity — Float
  • BatteryCapacity — Float

Station

  • StationID — String — Primary key — NOT NULL
  • StationType — String
  • Capacity — Int
  • Payload — DateTime
  • Status — String

TransportInstance

  • TransportInstanceID — String — Primary key — NOT NULL
  • ResourceTypeID — String — Foreign key → ResourceType.ResourceTypeID — NOT NULL

TravelInfo

  • TravelInfoID — 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
  • DepartureTimePeriod — DateTime
  • TravelTime — Time

TruckDriverID

  • DriverID — String — Primary key — NOT NULL
  • Status — String
  • RemainingOperationTime — DateTime
  • CurrentTruckID — String — Foreign key → TruckInstance.TruckInstanceID — NOT NULL

TruckInstance

  • TruckInstanceID — String — Primary key — Foreign key → TransportInstance.TransportInstanceID — NOT NULL
  • FuelStatus — String
  • Status — String
  • Payload — Int
  • CurrentLocationID — String — Foreign key → Location.LocationID — NOT NULL
  • NextLocationID — String — Foreign key → Location.LocationID — NOT NULL
  • RemainingOperationTime — Time