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