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