BA

Tables (7)

Alarm (alarm)

  • Alarm Index (idx) — INT — Primary key — NOT NULL
  • Alarm Type (alarmType) — VARCHAR(255)
  • Threshold Max (maxValue) — FLOAT
  • Threshold Min (minValue) — FLOAT

Error Log (error_log)

  • Error Index (idx) — INT — Primary key — NOT NULL
  • Error Type (errorType) — VARCHAR(255)
  • Error Detail (errorDetail) — TEXT
  • Regist Time (regTime) — DATETIME

Graph (graph)

  • Graph Index (idx) — INT — Primary key — NOT NULL
  • Graph Type (gType) — VARCHAR(255)

GraphData (graph_data)

  • Graph Index (idx) — INT — Foreign key → Graph.Graph Index — NOT NULL
  • GWID (gwid) — VARCHAR(100)
  • device — VARCHAR(100)
  • interval — VARCHAR(100)
  • nodeid — VARCHAR(100)
  • nodeType — VARCHAR(100)
  • Input Data 1 (sd1) — FLOAT
  • Input Data 2 (sd2) — FLOAT
  • Regist Time (regTime) — DATETIME

Sensor (sensor)

  • gwid — VARCHAR(255) — Primary key — NOT NULL
  • Rack Position (rack) — VARCHAR(255)
  • Category (category) — VARCHAR(255)

SensorData (sensor_data)

  • gwid — VARCHAR(255) — Foreign key → Sensor.gwid — NOT NULL
  • Data Index (idx) — INT
  • Sensor Type (senser_type) — VARCHAR(255)
  • device — VARCHAR(100)
  • batt — VARCHAR(100)
  • child — VARCHAR(100) — NOT NULL
  • interval — VARCHAR(100)
  • ipaddr — VARCHAR(100)
  • lqi — VARCHAR(100)
  • model — VARCHAR(100)
  • nodeid — VARCHAR(100)
  • nodeType — VARCHAR(100)
  • Input Data 1 (sd1) — FLOAT
  • Input Data 2 (sd2) — FLOAT
  • Regist Time (regTime) — DATETIME

User (user_account)

  • User id (user_id) — INT — Primary key — NOT NULL
  • Password (password) — String