rule engine
Tables (3)
rule_change_history (Untitled2)
- id (Key) — Primary key — NOT NULL — NOT NULL
- old_threshold (Field1)
- new_threshold (Field2) — NOT NULL
- author (Field3) — NOT NULL
- changed_at (Field4) — NOT NULL
- rule_id (Key2) — Foreign key → threshold_rules.id — NOT NULL — NOT NULL
sensors (Untitled3)
- device_eui (Key) — VARCHAR(64) — Primary key — NOT NULL — NOT NULL
- model (Field) — VARCHAR(64) — NOT NULL
- location (Field2) — VARCHAR(64) — NOT NULL
- point (Field3) — VARCHAR(64)
- device_name (Field4) — VARCHAR(64)
- installed_at (Field5) — VARCHAR(64)
- Field6
threshold_rules (Untitled)
- id (Key) — Primary key — NOT NULL — NOT NULL
- node_id (Field1) — NOT NULL
- metric (Field2) — NOT NULL
- operator (Field3) — NOT NULL
- threshold (Field4) — NOT NULL
- updated_at (Field5) — NOT NULL