길따라장따라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