플래너

테이블 (19)

ADMIN

  • admin_id — TEXT — 기본 키 — NOT NULL
  • name — TEXT — NOT NULL
  • email — TEXT
  • role — TEXT
  • invited_by — TEXT — 외래 키 → ADMIN.admin_id
  • created_at — TEXT

COUPON

  • coupon_id — TEXT — 기본 키 — NOT NULL
  • user_id — TEXT — 외래 키 → USER.user_id — NOT NULL
  • title — TEXT — NOT NULL
  • discount_rate — TEXT
  • content — TEXT
  • source — TEXT
  • status — TEXT
  • issued_at — TEXT
  • used_at — TEXT

FAVORITE

  • favorite_id — TEXT — 기본 키 — NOT NULL
  • user_id — TEXT — 외래 키 → USER.user_id — NOT NULL
  • target_type — TEXT
  • target_id — TEXT
  • created_at — TEXT

IMPROVEMENT

  • improvement_id — TEXT — 기본 키 — NOT NULL
  • market_id — TEXT — 외래 키 → MARKET.market_id — NOT NULL
  • stall_id — TEXT — 외래 키 → MARKET_STALL.stall_id
  • source_review_id — TEXT — 외래 키 → REVIEW.review_id
  • content — TEXT
  • status — TEXT
  • handled_by — TEXT — 외래 키 → ADMIN.admin_id
  • merchant_comment — TEXT
  • created_at — TEXT

MARKET

  • market_id — TEXT — 기본 키 — NOT NULL
  • market_name — TEXT — NOT NULL
  • market_type — TEXT
  • open_cycle — TEXT
  • address_road — TEXT
  • address_jibun — TEXT
  • lat — REAL
  • lon — REAL
  • store_count — INTEGER
  • item_categories — TEXT
  • phone — TEXT
  • data_ref_date — TEXT
  • managed_by — TEXT — 외래 키 → ADMIN.admin_id

MARKET_DISCOUNT

  • discount_id — TEXT — 기본 키 — NOT NULL
  • merchant_id — TEXT — 외래 키 → MERCHANT.merchant_id — NOT NULL
  • title — TEXT — NOT NULL
  • discount_rate — TEXT
  • content — TEXT
  • start_date — TEXT
  • end_date — TEXT
  • created_at — TEXT

MARKET_EVENT

  • event_id — TEXT — 기본 키 — NOT NULL
  • merchant_id — TEXT — 외래 키 → MERCHANT.merchant_id — NOT NULL
  • title — TEXT — NOT NULL
  • content — TEXT
  • start_date — TEXT
  • end_date — TEXT
  • created_at — TEXT

MARKET_STALL

  • stall_id — TEXT — 기본 키 — NOT NULL
  • market_id — TEXT — 외래 키 → MARKET.market_id — NOT NULL
  • merchant_id — TEXT — 외래 키 → MERCHANT.merchant_id
  • stall_number — TEXT
  • pos_x — REAL
  • pos_y — REAL
  • stall_type — TEXT
  • biz_name — TEXT
  • category_large — TEXT
  • category_mid — TEXT
  • category_small — TEXT
  • road_address — TEXT
  • distance_m — REAL
  • source_biz_id — TEXT
  • data_source — TEXT
  • open_hours — TEXT
  • closed_days — TEXT
  • biz_desc — TEXT
  • photo_url — TEXT

MERCHANT

  • merchant_id — TEXT — 기본 키 — NOT NULL
  • name — TEXT — NOT NULL
  • business_number — TEXT
  • phone — TEXT
  • email — TEXT
  • auth_provider — TEXT
  • password_hash — TEXT
  • market_id — TEXT — 외래 키 → MARKET.market_id
  • approval_status — TEXT
  • approved_by — TEXT — 외래 키 → ADMIN.admin_id
  • created_at — TEXT
  • bank_name — TEXT
  • account_number — TEXT
  • account_holder — TEXT
  • contact_name — TEXT
  • contact_phone — TEXT
  • doc_note — TEXT
  • doc_status — TEXT
  • doc_reject_reason — TEXT

NOTICE

  • notice_id — TEXT — 기본 키 — NOT NULL
  • author_type — TEXT
  • author_id — TEXT
  • market_id — TEXT — 외래 키 → MARKET.market_id
  • title — TEXT
  • content — TEXT
  • created_at — TEXT

QR_CODE

  • qr_id — TEXT — 기본 키 — NOT NULL
  • stall_id — TEXT — 외래 키 → MARKET_STALL.stall_id — NOT NULL
  • qr_image_url — TEXT
  • issued_at — TEXT

QR_VISIT_LOG

  • visit_id — TEXT — 기본 키 — NOT NULL
  • user_id — TEXT — 외래 키 → USER.user_id — NOT NULL
  • qr_id — TEXT — 외래 키 → QR_CODE.qr_id — NOT NULL
  • visited_at — TEXT

RESERVATION

  • reservation_id — TEXT — 기본 키 — NOT NULL
  • user_id — TEXT — 외래 키 → USER.user_id — NOT NULL
  • merchant_id — TEXT — 외래 키 → MERCHANT.merchant_id — NOT NULL
  • stall_id — TEXT — 외래 키 → MARKET_STALL.stall_id
  • item_desc — TEXT
  • status — TEXT
  • reject_reason — TEXT
  • requested_at — TEXT
  • decided_at — TEXT
  • picked_up_at — TEXT

REVIEW

  • review_id — TEXT — 기본 키 — NOT NULL
  • user_id — TEXT — 외래 키 → USER.user_id — NOT NULL
  • target_type — TEXT
  • target_id — TEXT
  • rating — INTEGER
  • content — TEXT
  • qr_verified — INTEGER
  • source_visit_id — TEXT — 외래 키 → QR_VISIT_LOG.visit_id
  • is_reported — INTEGER
  • created_at — TEXT

SCHEDULE

  • schedule_id — TEXT — 기본 키 — NOT NULL
  • merchant_id — TEXT — 외래 키 → MERCHANT.merchant_id — NOT NULL
  • team_id — TEXT
  • title — TEXT — NOT NULL
  • event_date — TEXT — NOT NULL
  • memo — TEXT
  • share_scope — TEXT
  • created_at — TEXT

SETTLEMENT

  • settlement_id — TEXT — 기본 키 — NOT NULL
  • merchant_id — TEXT — 외래 키 → MERCHANT.merchant_id — NOT NULL
  • period_start — TEXT
  • period_end — TEXT
  • sales_amount — REAL
  • fee_amount — REAL
  • payout_amount — REAL
  • status — TEXT
  • created_at — TEXT

TEAM

  • team_id — TEXT — 기본 키 — NOT NULL
  • owner_merchant_id — TEXT — 외래 키 → MERCHANT.merchant_id — NOT NULL
  • team_name — TEXT — NOT NULL
  • invite_code — TEXT
  • created_at — TEXT

TEAM_MEMBER

  • member_id — TEXT — 기본 키 — NOT NULL
  • team_id — TEXT — 외래 키 → TEAM.team_id — NOT NULL
  • merchant_id — TEXT — 외래 키 → MERCHANT.merchant_id — NOT NULL
  • role — TEXT
  • joined_at — TEXT

USER

  • user_id — TEXT — 기본 키 — NOT NULL
  • name — TEXT — NOT NULL
  • email — TEXT
  • birthdate — TEXT
  • auth_provider — TEXT
  • auth_provider_id — TEXT
  • identity_verified — INTEGER
  • status — TEXT
  • created_at — TEXT
  • travel_style — TEXT