SAJU-CHAT_v4

Tables (17)

chat_messages

  • id — char(36) — Primary key — NOT NULL
  • session_id — char(36) — Foreign key → chat_sessions.id

chat_sessions

  • id — char(36) — Primary key — NOT NULL
  • owner_id — varchar(255)
  • entitlement_id — char(36)
  • report_id — char(36) — Foreign key → interpretation_reports.id

conversation_script

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

coupon_redemptions

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

credit_logs

  • id — char(36) — Primary key — NOT NULL
  • owner_id — varchar(255)
  • amount — int
  • reason — varchar(100)

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)
  • slug — varchar(100)

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 — user/assistant
  • chart_id — char(36) — Foreign key → saju_charts.id — NOT NULL
  • is_current — boolean

master_logic_definitions

  • id — char(36) — Primary key — NOT NULL
  • logic_key — varchar(100)
  • name_ko — varchar(100)

notices

  • id — char(36) — Primary key — NOT NULL
  • title — varchar(200)
  • body_md — text
  • is_active — boolean

orders

  • id — char(36) — Primary key — NOT NULL
  • owner_id — varchar(255) — NOT NULL
  • order_id — varchar(255) — 차트ID(FK)
  • amount — int
  • status — varchar(50)
  • product_type — varchar(50)

persona_vibe_hook

  • id — varchar(100) — Primary key — NOT NULL
  • persona_id — varchar(50)
  • text — text

saju_charts

  • id — char(36) — Primary key — NOT NULL — 소유자(회원)FK
  • owner_id — varchar(255) — 입력값(JSON)
  • name — varchar(100) — NOT NULL
  • gender — varchar(10) — NOT NULL
  • birth_date — datetime — NOT NULL
  • input_json — text — 만세력결과(JSON)
  • result_json — text — 차트ID(FK)
  • is_locked — boolean
  • =만세력/차트 — (기본정보

saju_results

  • id — char(36) — Primary key — NOT NULL
  • chart_id — char(36) — Foreign key → saju_charts.id — NOT NULL — 분석결과(JSON)
  • raw_json — text — 주문번호
  • analysis_json — text — 바인딩된 차트(1:1)
  • engine_version — varchar(50)
  • =만세력/분석결과 — (엔진상세

solution_action

  • id — varchar(100) — Primary key — NOT NULL
  • type — varchar(50)
  • title — varchar(200)
  • content_detail — text

support_posts

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