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)