data

Tables (9)

SWOT

  • id — bigint — NOT NULL
  • store_id — bigint — NOT NULL
  • badge — VARCHAR(255)
  • s_title — VARCHAR(255)
  • s_detail — VARCHAR(255)
  • w_title — VARCHAR(255)
  • w_detail — VARCHAR(255)
  • o_title — VARCHAR(255)
  • o_detail — VARCHAR(255)
  • t_title — VARCHAR(255)
  • t_detail — VARCHAR(255)

action_detail

  • id — bigint — NOT NULL
  • action_plan_id — bigint — NOT NULL
  • content — TEXT
  • is_completed — BOOLEAN

action_plan

  • id — bigint — NOT NULL
  • swot_id — bigint — NOT NULL
  • title — VARCHAR(255)
  • category — VARCHAR(50) — 마케팅, 메뉴, 운영
  • tags — JSON
  • reason — TEXT

store

  • id — BIGINT — NOT NULL
  • member_id — BIGINT — NOT NULL
  • region_id — bigint — NOT NULL — FK: tb_region_master
  • name — VARCHAR(100)
  • address — VARCHAR(255) — NOT NULL
  • lat — DECIMAL(10, 7)
  • lon — DECIMAL(10, 7)
  • category — ENUM('CAFE_BAKERY', 'RESTAURANT', 'BAR') — NOT NULL
  • category_detail — VARCHAR(50)
  • signature — VARCHAR(255) — NOT NULL
  • price — ENUM('UNDER_10000', 'FROM_10000_TO_20000', 'FROM_20000_TO_40000', 'OVER_40000') — NOT NULL
  • target — ENUM('TWENTIES', 'THIRTIES_FORTIES', 'FAMILY', 'LOCAL_RESIDENT', 'TOURIST') — NOT NULL
  • pain_point — ENUM('CUSTOMER_ACQUISITION', 'LOYALTY_MANAGEMENT', 'COMPETITIVE_EDGE', 'PROFIT_IMPROVEMENT', 'PRODUCT_PLANNING') — NOT NULL

store_tag

  • id — bigint — NOT NULL
  • store_id — bigint — NOT NULL
  • tag_id — bigint — Foreign key → tag.id — NOT NULL

tag

  • id — bigint — NOT NULL
  • type — ENUM('MOOD', 'FEATURE', 'OPERATION') — NOT NULL
  • name — VARCHAR(50) — NOT NULL

tb_competitor_store

  • competitor_id — BIGINT — Primary key — NOT NULL
  • region_id — BIGINT — Foreign key → tb_region_master.region_id — NOT NULL — 지역 마스터 FK
  • store_name — VARCHAR(255) — 상호명 (콩마을)
  • category_lg — VARCHAR(50) — 상권업종대분류명 (음식)
  • category_md — VARCHAR(50) — 상권업종중분류명 (한식)
  • category_sm — VARCHAR(50) — 상권업종소분류명 (백반/한정식)
  • lat — DECIMAL(10, 7) — 위도
  • lon — DECIMAL(10, 7) — 경도
  • address_road — VARCHAR(255) — 도로명주소

tb_floating_population

  • log_id — BIGINT — Primary key — NOT NULL
  • region_id — BIGINT — Foreign key → tb_region_master.region_id — NOT NULL — 지역 마스터 FK
  • sdot_model_nm — VARCHAR(50) — 모델명/센서ID (SDOT001)
  • measure_date — DATETIME — NOT NULL — 측정일시 (2026-01-18 23:58:06)
  • location_type — VARCHAR(50) — 방문지 특성 (main_street)
  • pop_count — INT — 유동인구 수 (12)
  • INDEX — `idx_measure_date`

tb_region_master

  • region_id — BIGINT — Primary key — NOT NULL — 내부 관리용 ID
  • trdar_cd — VARCHAR(20) — 서울시 상권코드 (골목상권 등)
  • trdar_cd_nm — VARCHAR(100) — 상권명
  • adstrd_cd — VARCHAR(20) — 행정동코드 (소상공인 데이터 매핑용)
  • adstrd_nm — VARCHAR(50) — 행정동명 (S-DoT 매핑용)
  • gu_nm — VARCHAR(50) — 자치구명 (종로구, 마포구)