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