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) — 자치구명 (종로구, 마포구)