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)