SAJU-CHAT_v5

Tables (11)

astro_error_log

  • id — char(36) — Primary key — NOT NULL
  • error_message — text

chat_summaries

  • id — char(36) — Primary key — NOT NULL
  • session_id — char(36) — NOT NULL
  • summary_json — text

conversation_script

  • id — varchar(100) — Primary key — NOT NULL
  • title — varchar(200)

coupon_redemptions

  • id — char(36) — Primary key — NOT NULL
  • coupon_id — char(36) — Foreign key → coupons.id
  • owner_id — varchar(255)
  • redeemed_at — datetime

coupons

  • id — char(36) — Primary key — NOT NULL
  • code — varchar(50)
  • credit_amount — int

entitlements

  • id — char(36) — Primary key — NOT NULL
  • owner_id — varchar(255)
  • bound_chart_id — char(36) — Foreign key → saju_charts.id — 리포트ID(Anchor)
  • product_type — varchar(50)
  • status — varchar(50)
  • =이용권/권한 — (1:1바인딩

events

  • id — char(36) — Primary key — NOT NULL
  • title — varchar(200)

faq_items

  • id — char(36) — Primary key — NOT NULL
  • question — text
  • answer — text

interpretation_reports

  • id — char(36) — Primary key — NOT NULL
  • entitlement_id — char(36) — Foreign key → entitlements.id — NOT NULL

saju_charts

  • id — char(36) — Primary key — NOT NULL — 차트ID
  • owner_id — varchar(255) — 바인딩된 차트
  • name — varchar(100) — NOT NULL
  • birth_date — datetime — NOT NULL
  • input_json — text
  • result_json — text
  • =만세력/차트 — (기본정보

support_posts

  • id — char(36) — Primary key — NOT NULL
  • owner_id — varchar(255)
  • title — varchar(200)
  • status — varchar(50)