BRL
Tables (12)
DroneInstance (CopyOfCopyOfCopyOfUntitled2)
- DroneInstanceID (Key) — String — Primary key — NOT NULL
- BatteryStatus (Field2) — String
- Status (Field4) — String
- Payload (Field6) — Int
- CurrentLocationID (Key2) — String — Foreign key → Location.LocationID — NOT NULL
- NextLocationID (Key3) — String — Foreign key → Location.LocationID — NOT NULL
- ResourceTypeID (Key5) — String — Foreign key → ResourceType.ResourceTypeID — NOT NULL
- TruckInstanceID (Key4) — String — Foreign key → TruckInstance.TruckInstanceID — NOT NULL
- RemainingOperationTime (Field3)
Job (Untitled8)
- JobID (Key) — String — Primary key — NOT NULL
- DepartureStationID (Field) — String
- DestinationLocationID (Field2) — String
- IsCompleted (Field8) — Boolean
JobTransport (CopyOfUntitled8)
- JobTransportID (Key) — String — Primary key — NOT NULL
- JobID (Key2) — String — Foreign key → Job.JobID — NOT NULL
- ResourceTypeID (Key3) — String — Foreign key → ResourceType.ResourceTypeID — NOT NULL
- IsLoaded (Field) — Boolean
- IsCompleted (Field2) — Boolean
Location (CopyOfCopyOfCopyOfCopyOfUntitled2)
- LocationID (Key) — String — Primary key — NOT NULL
- LocationType (Field9) — String
MetroDriverID
- DriverID (Key) — String — Primary key — NOT NULL
- Status (Field9) — String
- RemainingOperationTime (Field) — DateTime
- MetroInstanceID (Key2) — String — Foreign key → MetroInstance.MetroInstanceID — NOT NULL
MetroInstance (CopyOfCopyOfUntitled22)
- MetroInstanceID (Key) — String — Primary key — NOT NULL
- DriverID (Field2) — String
- Status (Field3) — String
- Payload (Field6) — Int
- CurrentStationID (Key2) — String — Foreign key → Station.StationID — NOT NULL
- RemainingOperationTime (Field) — DateTime
- ResourceTypeID (Key3) — String — Foreign key → ResourceType.ResourceTypeID — NOT NULL
- NextStationID (Key4) — String — Foreign key → Station.StationID — NOT NULL
MetroSchedule
- DateTime (Field) — DateTime
- StationID (Key2) — String — Foreign key → Station.StationID — NOT NULL
ResourceType (CopyOfUntitled2)
- ResourceTypeID (Key) — String — Primary key — NOT NULL
- Capacity (Field) — Int
- FuelCapacity (Field2)
- BatteryCapacity (Field3)
Station
- StationID (Key) — String — Primary key — NOT NULL
- StationType (Field9) — String
- Capacity (Field) — DateTime
- Payload (Field2) — DateTime
- Status (Field4) — String
TravelTime (CopyOfCopyOfCopyOfCopyOfCopyOfUntitled2)
- FromLocationID (Key2) — String — Foreign key → Location.LocationID — NOT NULL
- ToLocationID (Key) — String — Foreign key → Location.LocationID — NOT NULL
- ResourceTypeID (Key3) — String — Foreign key → ResourceType.ResourceTypeID — NOT NULL
- TravelTime (Field) — DateTime
TruckDriverID (CopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfUntitled2)
- DriverID (Key) — String — Primary key — NOT NULL
- Status (Field9) — String
- RemainingOperationTime (Field) — DateTime
- CurrentTruckID (Key2) — String — Foreign key → TruckInstance.TruckInstanceID — NOT NULL
TruckInstance (CopyOfCopyOfUntitled2)
- TruckInstanceID (Key) — String — Primary key — NOT NULL
- FuelStatus (Field2) — String
- Status (Field4) — String
- Payload (Field6) — Int
- CurrentLocationID (Key2) — String — Foreign key → Location.LocationID — NOT NULL
- NextLocationID (Key3) — String — Foreign key → Location.LocationID — NOT NULL
- RemainingOperationTime (Field)
- ResourceTypeID (Key4) — String — Foreign key → ResourceType.ResourceTypeID — NOT NULL