Host_SmartFarm

Tables (4)

C_Communication_Cycle (configuration1)

  • User ID (usr_id) — BIGINT(20) — Foreign key → M_User.User ID — NOT NULL
  • Communication Cycle (comu_cycle) — INT(10)

C_Connection_Address (configuration2)

  • User ID (usr_id) — BIGINT(20) — Foreign key → M_User.User ID — NOT NULL
  • Connection IP (conect_ip) — VARCHAR(50)

D_PowerCheck (data1)

  • Device ID (device_id) — BIGINT(20) — Primary key — NOT NULL
  • User ID (usr_id) — BIGINT(20) — Foreign key → M_User.User ID — NOT NULL
  • Power Status (power_status) — BOOLEAN
  • Number of Attempts (attempts) — INT(10)

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)