Client_SmartFarm
Tables (7)
C_Alarm_Setting (Configuration2)
- User ID (usr_id) — BIGINT(20) — Foreign key → M_User.User ID — NOT NULL
- Power Anomaly (pw_anomaly) — BIGINT(20)
- Rainfall Detection (rain_detect) — Boolean
- High Temperature Detection (HT_detect) — Boolean
- Controller (controller) — Boolean
C_TH_Setting (Configuration1)
- User ID (usr_id) — BIGINT(20) — Foreign key → M_User.User ID — NOT NULL
- Max Temperature (max_tem) — FLOAT(5)
- Min Temperature (min_tem) — FLOAT(5)
- Max Humidity (max_hum) — FLOAT(5)
- Min Humidity (min_hum) — FLOAT(5)
- Update Time (update_time) — DATETIME
D_Current_Status (Data3)
- User ID (usr_id) — BIGINT(20) — Foreign key → M_User.User ID — NOT NULL
- Power (power) — Boolean
- Rainfall (rainfall) — Boolean
- High Temperature (h_tem) — Boolean
- Belve Controller (bel_controller) — Boolean
- Fan Controller (fan_contrller) — Boolean
D_Event (Data2)
- Event ID (event_id) — BIGINT(20) — Primary key — NOT NULL
- User ID (usr_id) — BIGINT(20) — Foreign key → M_User.User ID — NOT NULL
- Event Code (event_code) — INT(5)
- Event Content (event_content) — VARCHAR(100)
- Record Time (record_time) — DATETIME
D_TH (Data1)
- Log ID (log_id) — BIGINT(20) — Primary key — NOT NULL
- User ID (usr_id) — BIGINT(20) — Foreign key → M_User.User ID — NOT NULL
- Max Temperature (max_tem) — FLOAT(5)
- Min Temperature (min_tem) — FLOAT(5)
- Average Temperature (avg_tem) — FLOAT(5)
- Max Humidity (max_hum) — FLOAT(5)
- Min Humidity (min_hum) — FLOAT(5)
- Average Humidity (avg_hum) — FLOAT(5)
- Record Time (record_time) — DATETIME
M_Sensor (Master2)
- Sensor ID (sensor_id) — BIGINT(20) — Primary key — NOT NULL
- User ID (usr_id) — BIGINT(20) — Foreign key → M_User.User ID — NOT NULL
- Sensor Name (sensor_name) — VARCHAR(50)
- Sensor Port1 (sensor_p1) — INT(5)
- Sensor Port2 (sensor_p2) — INT(5)
- Sensor Port3 (sensor_p3) — INT(5)
- Sensor Power (sensor_power) — Boolean
- Sensor Setting Time (setting_time) — DATETIME
M_User (Master1)
- User ID (usr_id) — BIGINT(20) — Primary key — NOT NULL
- User Email (usr_email) — VARCHAR(50)
- User Passward (usr_passwd) — VARCHAR(50)
- User Name (usr_name) — VARCHAR(50)
- User Phone (usr_phone) — VARCHAR(50)