AudixFE

Tables (3)

alarm (알람)

  • Key (alarmId) — string — Primary key — NOT NULL
  • Key (machineId) — string — Foreign key → machine.Key
  • Field (machineStatus) — string
  • Field2 (alarmTitle) — string
  • Field3 (regionName) — string
  • Field4 (regionLocation) — string
  • Field (model) — string
  • Field2 (timestamp) — string
  • Field3 (createdAt) — date
  • Field4 (message) — string
  • Field5 (type) — string

area (구역)

  • Key (id) — string — Primary key — NOT NULL
  • Field (title) — string
  • Field2 (subtitle) — string
  • Field3 (image) — Image
  • Field4 (state) — string

machine (장비)

  • Key (machineId) — string — Primary key
  • Key (id) — string — Foreign key → area.Key — NOT NULL
  • Field (machineImage) — Image
  • Field (machineName) — string
  • Field (model) — string
  • Field (percent) — int
  • Field (regionLocation) — string
  • Field (machineOwner) — string
  • Field (machineState) — string