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