ㅁㄴㅇㅁ

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)