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)