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