SAJU-CHAT_2
Tables (18)
chat_messages
- id — uuid — Primary key — NOT NULL
- session_id — uuid
- role — text — NOT NULL
- content — text — NOT NULL
- meta — jsonb
- idempotency_key — text
- created_at — timestamp
- owner_id — text
chat_sessions
- id — uuid — Primary key — NOT NULL
- owner_id — text
- entitlement_id — uuid
- session_summary — text
- created_at — timestamp
- updated_at — timestamp
chat_summaries
- id — uuid — Primary key — NOT NULL
- session_id — uuid — NOT NULL
- summary_json — jsonb — NOT NULL
- created_at — timestamp
conversation_script
- id — text — NOT NULL
- title — text
coupons
- id — uuid — NOT NULL
- code — text
credit_logs
- id — uuid — Primary key — NOT NULL
- owner_id — text
- amount — integer — NOT NULL
- reason — text — NOT NULL
- related_ref_id — text
- created_at — timestamp
- entitlement_id — uuid
entitlements
- id — uuid — Primary key — NOT NULL
- owner_id — text
- product_type — text — NOT NULL
- status — text
- bound_chart_id — uuid
- created_at — timestamp
- updated_at — timestamp
- linked_payment_id — uuid
- parent_entitlement_id — uuid
events
- id — uuid — NOT NULL
- title — text
faq_items
- id — uuid — NOT NULL
- question — text
interpretation_reports
- id — uuid — Primary key — NOT NULL
- entitlement_id — uuid — NOT NULL
- chart_id — uuid — NOT NULL
- payload_json — jsonb — NOT NULL
- ruleset_version — text
- created_at — timestamp
- tier — text
- report_revision — integer
- engine_version — text
- is_current — boolean
- updated_at — timestamp
notices
- id — uuid — NOT NULL
- title — text
orders
- id — uuid — Primary key — NOT NULL
- owner_id — text — NOT NULL
- order_id — text — NOT NULL
- payment_key — text
- product_type — text — NOT NULL
- amount — integer — NOT NULL
- status — text — NOT NULL
- metadata — jsonb
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
persona_vibe_hook
- id — text — NOT NULL
- text — text
profiles
- id — text — Primary key — NOT NULL
- email — text
- display_name — text
- role — text
- created_at — timestamp
- updated_at — timestamp
- is_admin — boolean — NOT NULL
saju_charts
- id — uuid — Primary key — NOT NULL
- owner_id — text
- name — text — NOT NULL
- gender — text — NOT NULL
- birth_date — timestamp — NOT NULL
- birth_hour — text
- input_json — jsonb — NOT NULL
- result_json — jsonb — NOT NULL
- is_locked — boolean
- created_at — timestamp
- updated_at — timestamp
- is_hidden — boolean
saju_results
- id — uuid — Primary key — NOT NULL
- chart_id — uuid — NOT NULL
- raw_json — jsonb — NOT NULL
- analysis_json — jsonb
- engine_version — text — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
solution_action
- id — text — NOT NULL
- title — text
support_posts
- id — uuid — NOT NULL
- title — text