11

Tables (12)

AlarmRecord

  • id — INT
  • event_id — INT — Foreign key → Event.id
  • facility_id — INT — Foreign key → Facility.id
  • ml_anomaly_result_id — INT — Foreign key → MLAnomalyResult.id

AlertPolicy

  • id — INT

Event

  • id — INT
  • status — VARCHAR(50)
  • facility_id — INT — Foreign key → Facility.id
  • source_sensor_id — INT — Foreign key → GasSensor.id
  • source_power_device_id — INT — Foreign key → PowerDevice.id
  • source_geofence_id — INT — Foreign key → GeoFence.id
  • worker_id — INT — Foreign key → Worker.id
  • policy_id — INT — Foreign key → AlertPolicy.id
  • acknowledged_by_id — INT — Foreign key → User.id
  • resolved_by_id — INT — Foreign key → User.id

EventAcknowledgement

  • id — INT
  • event_id — INT — Foreign key → Event.id
  • user_id — INT — Foreign key → User.id

EventLog

  • id — INT
  • event_id — INT — Foreign key → Event.id

Facility

  • id — INT

GasSensor

  • id — INT

GeoFence

  • id — INT

MLAnomalyResult

  • id — INT

PowerDevice

  • id — INT

User

  • id — INT

Worker

  • id — INT