플래너
테이블 (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