길따라장따라1
테이블 (20)
ADMIN (관리자)
- admin_id — VARCHAR(50) — 기본 키 — NOT NULL
- name — VARCHAR(100) — NOT NULL
- email — VARCHAR(255)
- role — VARCHAR(50)
- invited_by — VARCHAR(50) — 외래 키 → ADMIN.admin_id
- created_at — TIMESTAMP
COUPON (쿠폰)
- coupon_id — VARCHAR(50) — 기본 키 — NOT NULL
- user_id — VARCHAR(50) — 외래 키 → USER.user_id — NOT NULL
- title — VARCHAR(200) — NOT NULL
- discount_rate — VARCHAR(20)
- content — VARCHAR(500)
- source — VARCHAR(100)
- status — VARCHAR(20)
- issued_at — TIMESTAMP
- used_at — TIMESTAMP
FAVORITE (찜한 목록)
- favorite_id — VARCHAR(50) — 기본 키 — NOT NULL
- user_id — VARCHAR(50) — 외래 키 → USER.user_id — NOT NULL
- target_type — VARCHAR(20)
- target_id — VARCHAR(50)
- created_at — TIMESTAMP
IMPROVEMENT (개선사항)
- improvement_id — VARCHAR(50) — 기본 키 — NOT NULL
- market_id — VARCHAR(50) — 외래 키 → MARKET.market_id — NOT NULL
- stall_id — VARCHAR(50) — 외래 키 → MARKET_STALL.stall_id
- source_review_id — VARCHAR(50) — 외래 키 → REVIEW.review_id
- content — VARCHAR(1000)
- status — VARCHAR(20)
- handled_by — VARCHAR(50) — 외래 키 → ADMIN.admin_id
- merchant_comment — VARCHAR(500)
- created_at — TIMESTAMP
MARKET (시장)
- market_id — VARCHAR(50) — 기본 키 — NOT NULL
- market_name — VARCHAR(200) — NOT NULL
- market_type — VARCHAR(50)
- open_cycle — VARCHAR(50)
- address_road — VARCHAR(255)
- address_jibun — VARCHAR(255)
- lat — REAL
- lon — REAL
- store_count — INTEGER
- item_categories — VARCHAR(255)
- phone — VARCHAR(30)
- data_ref_date — VARCHAR(20)
- managed_by — VARCHAR(50) — 외래 키 → ADMIN.admin_id
MARKET_DISCOUNT (할인)
- discount_id — VARCHAR(50) — 기본 키 — NOT NULL
- merchant_id — VARCHAR(50) — 외래 키 → MERCHANT.merchant_id — NOT NULL
- title — VARCHAR(200) — NOT NULL
- discount_rate — VARCHAR(20)
- content — VARCHAR(1000)
- start_date — VARCHAR(20)
- end_date — VARCHAR(20)
- created_at — TIMESTAMP
MARKET_EVENT (이벤트)
- event_id — VARCHAR(50) — 기본 키 — NOT NULL
- merchant_id — VARCHAR(50) — 외래 키 → MERCHANT.merchant_id — NOT NULL
- title — VARCHAR(200) — NOT NULL
- content — VARCHAR(1000)
- start_date — VARCHAR(20)
- end_date — VARCHAR(20)
- created_at — TIMESTAMP
MARKET_STALL (상점)
- stall_id — VARCHAR(50) — 기본 키 — NOT NULL
- market_id — VARCHAR(50) — 외래 키 → MARKET.market_id — NOT NULL
- merchant_id — VARCHAR(50) — 외래 키 → MERCHANT.merchant_id
- stall_number — VARCHAR(20)
- pos_x — REAL
- pos_y — REAL
- stall_type — VARCHAR(50)
- biz_name — VARCHAR(200)
- category_large — VARCHAR(50)
- category_mid — VARCHAR(50)
- category_small — VARCHAR(50)
- road_address — VARCHAR(255)
- distance_m — REAL
- source_biz_id — VARCHAR(50)
- data_source — VARCHAR(100)
- open_hours — VARCHAR(255)
- closed_days — VARCHAR(100)
- biz_desc — VARCHAR(255)
- photo_url — VARCHAR(255)
MERCHANT (상인)
- merchant_id — VARCHAR(50) — 기본 키 — NOT NULL
- name — VARCHAR(100) — NOT NULL
- business_number — VARCHAR(50)
- phone — VARCHAR(30)
- email — VARCHAR(255)
- auth_provider — VARCHAR(20)
- password_hash — VARCHAR(255)
- market_id — VARCHAR(50) — 외래 키 → MARKET.market_id
- approval_status — VARCHAR(20)
- approved_by — VARCHAR(50) — 외래 키 → ADMIN.admin_id
- created_at — TIMESTAMP
- bank_name — VARCHAR(50)
- account_number — VARCHAR(50)
- account_holder — VARCHAR(100)
- contact_name — VARCHAR(100)
- contact_phone — VARCHAR(30)
- doc_note — VARCHAR(255)
- doc_status — VARCHAR(20)
- doc_reject_reason — VARCHAR(255)
NOTICE (공지사항)
- notice_id — VARCHAR(50) — 기본 키 — NOT NULL
- author_type — VARCHAR(20)
- author_id — VARCHAR(50)
- market_id — VARCHAR(50) — 외래 키 → MARKET.market_id
- title — VARCHAR(200)
- content — VARCHAR(2000)
- created_at — TIMESTAMP
QR_CODE
- qr_id — VARCHAR(50) — 기본 키 — NOT NULL
- stall_id — VARCHAR(50) — 외래 키 → MARKET_STALL.stall_id — NOT NULL
- qr_image_url — VARCHAR(255)
- issued_at — TIMESTAMP
QR_VISIT_LOG (QR 방문 기록)
- visit_id — VARCHAR(50) — 기본 키 — NOT NULL
- user_id — VARCHAR(50) — 외래 키 → USER.user_id — NOT NULL
- qr_id — VARCHAR(50) — 외래 키 → QR_CODE.qr_id — NOT NULL
- visited_at — TIMESTAMP
RESERVATION (물품예약)
- reservation_id — VARCHAR(50) — 기본 키 — NOT NULL
- user_id — VARCHAR(50) — 외래 키 → USER.user_id — NOT NULL
- merchant_id — VARCHAR(50) — 외래 키 → MERCHANT.merchant_id — NOT NULL
- stall_id — VARCHAR(50) — 외래 키 → MARKET_STALL.stall_id
- item_desc — VARCHAR(500)
- status — VARCHAR(20)
- reject_reason — VARCHAR(255)
- requested_at — TIMESTAMP
- decided_at — TIMESTAMP
- picked_up_at — TIMESTAMP
REVIEW (리뷰)
- review_id — VARCHAR(50) — 기본 키 — NOT NULL
- user_id — VARCHAR(50) — 외래 키 → USER.user_id — NOT NULL
- target_type — VARCHAR(20)
- target_id — VARCHAR(50)
- rating — INTEGER
- content — VARCHAR(1000)
- qr_verified — INTEGER
- source_visit_id — VARCHAR(50) — 외래 키 → QR_VISIT_LOG.visit_id
- is_reported — INTEGER
- created_at — TIMESTAMP
SCHEDULE (상인 스케줄)
- schedule_id — VARCHAR(50) — 기본 키 — NOT NULL
- merchant_id — VARCHAR(50) — 외래 키 → MERCHANT.merchant_id — NOT NULL
- team_id — VARCHAR(50)
- title — VARCHAR(200) — NOT NULL
- event_date — VARCHAR(20) — NOT NULL
- memo — VARCHAR(500)
- share_scope — VARCHAR(20)
- created_at — TIMESTAMP
SETTLEMENT (해결)
- settlement_id — VARCHAR(50) — 기본 키 — NOT NULL
- merchant_id — VARCHAR(50) — 외래 키 → MERCHANT.merchant_id — NOT NULL
- period_start — VARCHAR(20)
- period_end — VARCHAR(20)
- sales_amount — REAL
- fee_amount — REAL
- payout_amount — REAL
- status — VARCHAR(20)
- created_at — TIMESTAMP
TEAM (상인 팀)
- team_id — VARCHAR(50) — 기본 키 — NOT NULL
- owner_merchant_id — VARCHAR(50) — 외래 키 → MERCHANT.merchant_id — NOT NULL
- team_name — VARCHAR(100) — NOT NULL
- invite_code — VARCHAR(50)
- created_at — TIMESTAMP
TEAM_MEMBER (상인 팀 팀원)
- member_id — VARCHAR(50) — 기본 키 — NOT NULL
- team_id — VARCHAR(50) — 외래 키 → TEAM.team_id — NOT NULL
- merchant_id — VARCHAR(50) — 외래 키 → MERCHANT.merchant_id — NOT NULL
- role — VARCHAR(20)
- joined_at — TIMESTAMP
TRIP_PLAN (여행 계획)
- plan_id — VARCHAR(50) — 기본 키 — NOT NULL
- user_id — VARCHAR(50) — 외래 키 → USER.user_id — NOT NULL
- title — VARCHAR(200)
- styles — VARCHAR(255)
- companion — VARCHAR(100)
- duration — VARCHAR(50)
- region — VARCHAR(100)
- market_cycle — VARCHAR(50)
- result_text — VARCHAR(4000)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
USER (사용자)
- user_id — VARCHAR(50) — 기본 키 — NOT NULL
- name — VARCHAR(100) — NOT NULL
- email — VARCHAR(255)
- birthdate — VARCHAR(20)
- auth_provider — VARCHAR(20)
- auth_provider_id — VARCHAR(100)
- identity_verified — INTEGER
- status — VARCHAR(20)
- created_at — TIMESTAMP
- travel_style — VARCHAR(100)
- travel_style_updated_at — TIMESTAMP