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
- 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
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