SAJU-CHAT_v3
Tables (8)
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
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바인딩
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
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)
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)
- =만세력/분석결과 — (엔진상세