WISP

Tables (6)

app_user

  • app_user_id — CHAR(36) — Primary key — NOT NULL
  • email — text
  • display_name — varchar(80) — NOT NULL
  • avatar_url — text
  • status — VARCHAR(20) — NOT NULL
  • settings — JSON
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

chat_message

  • id — CHAR(36) — Primary key — NOT NULL
  • session_id — CHAR(36) — Foreign key — NOT NULL
  • seq — bigint — NOT NULL
  • role — VARCHAR(12) — NOT NULL
  • persona_version_id — CHAR(36)
  • content_text — TEXT
  • content_json — JSON
  • metadata — JSON
  • created_at — timestamptz — NOT NULL

chat_message_embedding

  • message_embedding_id — CHAR(36) — Primary key — NOT NULL
  • message_id — CHAR(36) — Foreign key
  • model — VARCHAR(60) — NOT NULL
  • embedding — BLOB — NOT NULL
  • created_at — timestamptz — NOT NULL

chat_session

  • session_id — CHAR(36) — Primary key — NOT NULL
  • user_id — CHAR(36) — Foreign key — NOT NULL
  • mode — VARCHAR(10) — NOT NULL
  • title — TEXT — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • world_version_id — CHAR(36)
  • scene_version_id — CHAR(36)
  • metadata — JSON
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL
  • last_message_at — timestamptz

chat_session_summary

  • id (session_summary_id) — CHAR(36) — Primary key — NOT NULL
  • session_id — CHAR(36) — Foreign key — NOT NULL
  • up_to_seq — bigint — NOT NULL
  • summary_text — TEXT
  • metadata — JSON
  • created_at — timestamptz — NOT NULL

user_identity

  • id — CHAR(36) — Primary key — NOT NULL
  • user_id — CHAR(36) — Foreign key — NOT NULL
  • provider — varchar(80) — NOT NULL
  • provider_uid — CHAR(36) — NOT NULL
  • email — text — NOT NULL
  • created_at — timestamptz — NOT NULL