AI기반

테이블 (23)

ADMIN

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

CONVERSATION

  • conversation_id — TEXT — 기본 키 — NOT NULL
  • user_id — TEXT — 외래 키 → USER.user_id — NOT NULL
  • title — TEXT
  • is_deleted — INTEGER
  • created_at — TEXT
  • updated_at — TEXT

COUPON

  • coupon_id — TEXT — 기본 키 — NOT NULL
  • issuer_type — TEXT
  • issuer_id — TEXT
  • stall_id — TEXT — 외래 키 → MARKET_STALL.stall_id
  • market_id — TEXT — 외래 키 → MARKET.market_id
  • discount_info — TEXT
  • valid_from — TEXT
  • valid_to — TEXT

FAVORITE

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

FEEDBACK

  • feedback_id — TEXT — 기본 키 — NOT NULL
  • user_id — TEXT — 외래 키 → USER.user_id — NOT NULL
  • target — TEXT
  • content — 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
  • created_at — TEXT

INQUIRY

  • inquiry_id — TEXT — 기본 키 — NOT NULL
  • user_id — TEXT — 외래 키 → USER.user_id
  • category — TEXT
  • question — TEXT
  • answer — TEXT
  • answered_by — TEXT — 외래 키 → ADMIN.admin_id
  • status — TEXT
  • created_at — TEXT

ITINERARY

  • itinerary_id — TEXT — 기본 키 — NOT NULL
  • user_id — TEXT — 외래 키 → USER.user_id — NOT NULL
  • conversation_id — TEXT — 외래 키 → CONVERSATION.conversation_id
  • title — TEXT
  • travel_type — TEXT
  • start_date — TEXT
  • end_date — TEXT
  • version — INTEGER
  • created_at — TEXT

ITINERARY_HISTORY

  • history_id — TEXT — 기본 키 — NOT NULL
  • itinerary_id — TEXT — 외래 키 → ITINERARY.itinerary_id — NOT NULL
  • change_type — TEXT
  • snapshot — TEXT
  • changed_at — TEXT

ITINERARY_PLACE

  • itinerary_place_id — TEXT — 기본 키 — NOT NULL
  • itinerary_id — TEXT — 외래 키 → ITINERARY.itinerary_id — NOT NULL
  • place_id — TEXT — 외래 키 → PLACE.place_id
  • market_id — TEXT — 외래 키 → MARKET.market_id
  • day_number — INTEGER
  • visit_order — INTEGER
  • visit_time — 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_FLOOR_MAP

  • floor_map_id — TEXT — 기본 키 — NOT NULL
  • market_id — TEXT — 외래 키 → MARKET.market_id — NOT NULL
  • map_image_url — TEXT
  • map_type — TEXT
  • updated_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

MERCHANT

  • merchant_id — TEXT — 기본 키 — NOT NULL
  • name — TEXT — NOT NULL
  • business_number — TEXT
  • phone — TEXT
  • email — TEXT
  • auth_provider — TEXT
  • market_id — TEXT — 외래 키 → MARKET.market_id
  • approval_status — TEXT
  • approved_by — TEXT — 외래 키 → ADMIN.admin_id
  • created_at — TEXT

MESSAGE

  • message_id — TEXT — 기본 키 — NOT NULL
  • conversation_id — TEXT — 외래 키 → CONVERSATION.conversation_id — NOT NULL
  • sender — TEXT
  • content — TEXT
  • extracted_slots — TEXT
  • created_at — 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

PLACE

  • place_id — TEXT — 기본 키 — NOT NULL
  • name — TEXT — NOT NULL
  • category — TEXT
  • address — TEXT
  • lat — REAL
  • lon — REAL
  • description — TEXT
  • source — 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
  • stall_id — TEXT — 외래 키 → MARKET_STALL.stall_id — NOT NULL
  • item_info — TEXT
  • status — TEXT
  • created_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

STAMP_TOUR

  • stamp_id — TEXT — 기본 키 — NOT NULL
  • user_id — TEXT — 외래 키 → USER.user_id — NOT NULL
  • market_id — TEXT — 외래 키 → MARKET.market_id — NOT NULL
  • stamps_collected — TEXT
  • completed_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