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