ㅁㄴㅇㅁ
Tables (9)
Alert
- alert_id — bigint(20) — Primary key — NOT NULL
- user_id — bigint(20) — Foreign key → Users.user_id — NOT NULL
- hub_id — bigint(20) — NOT NULL
- alert_category — varchar(20) — NOT NULL
- alert_title — varchar(30)
- alert_detail — varchar(100)
- alert_date — datetime
Brand
- brand_id — bigint(20) — Primary key — NOT NULL
- brand_name — varchar(100) — NOT NULL
Controller
- button_id — bigint(20) — Primary key — NOT NULL
- controller_id — bigint(20) — Foreign key → Remote.controller_id — NOT NULL
- button_name — varchar(20) — NOT NULL
- ir_signal — varchar(8) — NOT NULL
Hubs
- hub_id — bigint(20) — Primary key — NOT NULL
- hub_uuid — varchar(36) — NOT NULL
- weather_key — varchar(40) — NOT NULL
- location — varchar(100)
Product
- product_id — bigint(20) — Primary key — NOT NULL
- brand_id — bigint(20) — NOT NULL
- product_category — varchar(100) — NOT NULL
Remote
- controller_id — bigint — Primary key — NOT NULL
- user_id — bigint(20)
- product_id — bigint(20) — NOT NULL
- hub_id — bigint(20)
- controller_name — varchar(20) — NOT NULL
- create_date — datetime — NOT NULL
- modify_date — datetime — NOT NULL
- is_opened — char(10) — NOT NULL
Routine
- routine_id — bigint(20) — Primary key — NOT NULL
- hub_id — bigint(20) — Foreign key → Hubs.hub_id — NOT NULL
- is_activated — char(10) — NOT NULL
- condition_category — set('weather', 'time', 'command') — NOT NULL
- attributes — json — NOT NULL
- create_date — datetime
- modify_date — datetime
Users
- user_id — bigint(20) — Primary key — NOT NULL
- login_id — varchar(20) — NOT NULL
- email — varchar(50) — NOT NULL
- password — varchar(30) — NOT NULL
- user_name — varchar(30) — NOT NULL
- user_img — varchar(100) — NOT NULL
- user_phone — varchar(20) — NOT NULL
- user_svc_agmt — char(10) — NOT NULL
- user_svc_agmt_date — datetime
- user_info_agmt — char(10) — NOT NULL
- user_info_agmt_date — datetime
- user_alert_agmt — char(10)
- user_alert_agmt_date — datetime
- is_push_alert_on — char(10)
- is_dark_alert_on — char(10)
Users-Hubs
- user_id — bigint(20) — Foreign key → Users.user_id — NOT NULL
- hub_id — bigint(20) — Foreign key → Hubs.hub_id — NOT NULL
- user_hub_auth — set('master', 'manager', 'user') — NOT NULL
- user_hub_name — varchar(20)