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
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