plantcare
Tables (6)
Device
- device_id — VARCHAR(36) — NOT NULL
- device_pw — VARCHAR(36) — NOT NULL
Sensor_Data
- data_id — INT — NOT NULL
- device_id — VARCHAR(36) — Foreign key → Device.device_id — NOT NULL
- led_v — DOUBLE
- temp_v — DOUBLE
- humidity_v — DOUBLE
- shumidity_v — DOUBLE
- timestamp — TIMESTAMP — NOT NULL
User
- user_id — VARCHAR(255) — NOT NULL
- user_pw — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(255) — NOT NULL
- birth — INT — NOT NULL
- phone — VARCHAR(20) — NOT NULL
- address — VARCHAR(255) — NOT NULL
User_Device
- user_device_id — INT — NOT NULL
- user_id — VARCHAR(255) — Foreign key → User.user_id — NOT NULL
- device_id — VARCHAR(36) — Foreign key → Device.device_id — NOT NULL
- device_name — VARCHAR(255)
User_Permission
- user_id — VARCHAR(255) — Primary key — NOT NULL
- permission_id — INT — Primary key — NOT NULL
set_data
- no — INT — NOT NULL
- device_id — VARCHAR(36) — Foreign key → Device.device_id — NOT NULL
- led_v — INT
- temp_v — INT
- humidity_v — INT
- shumidity_v — INT