Unframe
Tables (7)
ConversationLog (conversation_log)
- Key — NOTNULL — Primary key — NOT NULL
- sessionId (session_id) — NOTNULL
- paintingId (painting_id) — NOTNULL
- role — NOTNULL
- message — NULL
- createdAt (created_at) — NOTNULL
painting
- painting_id — VARCHAR(255) — Primary key — NOT NULL
- title — VARCHAR(255) — NOT NULL
- artist — VARCHAR(255) — NOT NULL
- era — VARCHAR(255)
- persona_prompt — TEXT
- asset_key — VARCHAR(255)
player
- player_id — VARCHAR(255) — Primary key — NOT NULL
player_stats
- player_id — VARCHAR(255) — Primary key — NOT NULL
- total_attempts — INT — NOT NULL
seal_record
- id — BIGINT — NOT NULL
- painting_id — VARCHAR(255) — NOT NULL
- attempts — INT — NOT NULL
- quiz_accuracy — DOUBLE — NOT NULL
session
- session_id — VARCHAR(255) — Primary key — NOT NULL
- player_id — VARCHAR(255) — Foreign key → player.player_id — NOT NULL
- total_stamps — INT — NOT NULL
- started_at — DATETIME — NOT NULL
session_target
- painting_id — VARCHAR(255) — Foreign key → painting.painting_id — NOT NULL
- session_id — VARCHAR(255) — NOT NULL