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)