GOQUAL NEW SERVICE

고퀄 신규 헤이홈 ERD

테이블 (28)

dashboard

  • id — int(11) — 기본 키 — NOT NULL
  • user_id — int(11) — 외래 키 → goqual_user_info.id — NOT NULL
  • dashboard_name — varchar(256) — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp

dashboard_device_widget_mapping_info

  • id — int(11) — 기본 키 — NOT NULL
  • device_id — int(11) — 외래 키 → user_devices.id — NOT NULL
  • dashboard_id — int(11) — NOT NULL
  • widget_state — longtext — NOT NULL — 사용되는 widget의 fields 정보
  • created_at — timestamp
  • updated_at — timestamp

goqual_services

  • id — int(11) — 기본 키 — NOT NULL
  • service_name — varchar(256) — NOT NULL
  • display_name — varchar(256) — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL

goqual_services_user_mapping

  • id — int(11) — 기본 키 — NOT NULL
  • user_id — int(11) — 외래 키 → goqual_user_info.id — NOT NULL
  • service_id — int(11) — NOT NULL
  • mapping_user_id — varchar(256) — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL

goqual_user_info

  • id — int(11) — 기본 키 — NOT NULL — 사용자 식별 ID
  • email — varchar(256) — Email
  • password — varchar(256)
  • user_name — varchar(256) — 사용자 이름
  • mobile — varchar(100) — 휴대폰 번호
  • user_status_code — varchar(2) — 공통코드-회원 상태(정상, 탈퇴)
  • created_at — timestamp — 생성일
  • updated_at — timestamp — 수정일

jm_device

  • id — int(11) — 기본 키 — NOT NULL
  • device_name — varchar(100)
  • device_type — varchar(100)
  • device_icon_type — varchar(100)

jm_user

  • id — int(11) — 기본 키 — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • user_name — varchar(100)
  • phone — varchar(100)

jm_user_device

  • id — int(11) — 외래 키 → jm_user.id — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • user_device_name — varchar(100) — NOT NULL
  • user_id — int(11)

jm_user_device_location

  • id — int(11) — 외래 키 → jm_user.id — NOT NULL
  • location_name — varchar(100)
  • user_id — int(11)

jm_user_recipe

  • id — int(11) — 외래 키 → jm_user.id — NOT NULL
  • recipe_name — varchar(100) — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • active — tinyint(1) — NOT NULL
  • user_id — int(11)

jm_user_recipe_demand

  • id — int(11) — 외래 키 → user_devices.id — NOT NULL
  • demand_start_at — timestamp
  • demand_end_at — timestamp
  • isScheduled — tinyint(1)
  • user_device_id — int(11)
  • device_demand_status — varchar(100)

jm_user_recipe_result_status

  • id — int(11) — 외래 키 → jm_user_recipe_demand.id — NOT NULL
  • device_status — varchar(100)
  • demand_id — int(11)
  • device_id — int(11)
  • recipe_id — int(11)

kmk_action

  • id — bigint(20) — 기본 키 — NOT NULL
  • device_info_id — bigint(20) — 외래 키 → kmk_device_info.id — NOT NULL
  • action — varchar(255)

kmk_device_action_recipe

  • id — bigint(20) — 기본 키 — NOT NULL
  • recipe_id — bigint(20) — NOT NULL
  • action_id — bigint(20) — 외래 키 → kmk_action.id — NOT NULL
  • user_device_id — int(11) — NOT NULL
  • action_value — varchar(255)

kmk_device_condition

  • id — bigint(20) — 기본 키 — NOT NULL
  • device_info_id — bigint(20) — 외래 키 → kmk_device_info.id — NOT NULL
  • condition — varchar(255) — NOT NULL

kmk_device_condition_recipe

  • id — bigint(20) — 기본 키 — NOT NULL
  • device_condition_id — bigint(20) — 외래 키 → kmk_device_condition.id — NOT NULL
  • recipe_id — bigint(20) — NOT NULL
  • action_recipe_id — bigint(20) — NOT NULL
  • user_device_id — int(11) — NOT NULL
  • condition_value — varchar(255)

kmk_device_info

  • id — bigint(20) — 기본 키 — NOT NULL
  • pid — varchar(255) — NOT NULL
  • deviceType — varchar(255) — NOT NULL

kmk_recipe

  • id — bigint(20) — 기본 키 — NOT NULL
  • user_id — int(11) — 외래 키 → goqual_user_info.id — NOT NULL
  • name — varchar(255)

migration_table

  • id — int(11) — 기본 키 — NOT NULL
  • timestamp — bigint(20) — NOT NULL
  • name — varchar(255) — NOT NULL

product_basic_info

  • id — int(11) — 기본 키 — NOT NULL — 제품 기본 정보 ID
  • sync_platform_id — bigint(20) — 외래 키 → sync_platform_info.id — NOT NULL — 연동 플랫폼 ID
  • pid — varchar(256) — NOT NULL — Tuya Product ID
  • firmware_key — varchar(256) — NOT NULL
  • deviceType — varchar(256)
  • product_name — varchar(256) — 제품 명
  • product_category_id — int(11) — NOT NULL
  • pair_easy — tinyint(1) — NOT NULL
  • pair_advance — tinyint(1) — NOT NULL
  • pair_ble — tinyint(1) — NOT NULL
  • pair_zigbee — tinyint(1) — NOT NULL
  • pairing_data — longtext
  • isReleased — tinyint(1) — NOT NULL — 출시여부
  • isDeleted — tinyint(1) — NOT NULL — 삭제(서비스) 여부
  • isRecipeAction — tinyint(1) — 레시피 지원 여부
  • isRecipeAlarm — tinyint(1) — 레시피 알람 여부
  • created_at — timestamp — 생성일
  • updated_at — timestamp — 수정일

product_category

  • id — int(11) — 기본 키 — NOT NULL
  • category_code — varchar(256) — NOT NULL
  • category_name — varchar(256) — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp

space

  • id — int(11) — 기본 키 — NOT NULL
  • user_id — int(11) — 외래 키 → goqual_user_info.id — NOT NULL
  • space_name — varchar(256) — NOT NULL
  • lan — int(11) — NOT NULL — 위도
  • lat — int(11) — NOT NULL — 경도
  • address — varchar(256) — NOT NULL
  • imageUrl — varchar(256) — NOT NULL — 장소 아이콘 이미지 url
  • created_at — timestamp
  • updated_at — timestamp

space_device_mapping_info

  • id — int(11) — 기본 키 — NOT NULL
  • device_id — int(11) — 외래 키 → user_devices.id — NOT NULL
  • space_id — int(11) — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp

sync_platform_info

  • id — bigint(20) — 기본 키 — NOT NULL — 연동 플랫폼 ID
  • platform_type_code — varchar(6) — NOT NULL — 공통코드-플랫폼 타입(tuya, toast, brunt)
  • app_schema — varchar(100) — APP 스키마
  • platform_name — varchar(50) — 플랫폼 명
  • package_name — varchar(100) — Andorid 패키지명
  • bundle_id — varchar(100) — iOS Bundle ID
  • created_at — timestamp — 생성일
  • updated_at — timestamp — 수정일

test_remote

  • id — int(11) — 기본 키 — NOT NULL
  • user_id — varchar(50) — NOT NULL
  • pid — varchar(50) — NOT NULL
  • infrared_id — varchar(50) — NOT NULL
  • remote_id — varchar(50) — NOT NULL
  • brand_id — int(50) — NOT NULL
  • remote_index — int(50) — NOT NULL
  • category_id — int(50) — NOT NULL
  • created_at — timestamp — NOT NULL — created date
  • updated_at — timestamp — NOT NULL — updated date

user_devices

  • id — int(11) — 기본 키 — NOT NULL
  • goqual_user_info_id — int(11) — 외래 키 → goqual_user_info.id — NOT NULL
  • device_id — varchar(45)
  • pid — varchar(45)
  • device_name — varchar(45)
  • isPared — tinyint(1)
  • created_at — timestamp
  • updated_at — timestamp

user_sync_platform_mapping_info

  • id — bigint(20) — 기본 키 — NOT NULL — 사용자 연동 플랫폼 맵핑 ID
  • user_info_id — int(11)
  • sync_platform_id — bigint(20) — 외래 키 → sync_platform_info.id — NOT NULL — 연동 플랫폼 ID
  • uid — varchar(256)
  • user_id — varchar(256)
  • user_password — varchar(256) — NOT NULL
  • created_at — timestamp — 생성일
  • updated_at — timestamp — 수정일

widget

  • id — int(11) — 기본 키 — NOT NULL
  • product_id — int(11) — 외래 키 → product_basic_info.id — NOT NULL
  • widget_name — varchar(256) — NOT NULL
  • widget_value — longtext — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp