Unframed
Tables (7)
conversation_log
- id — BIGINT — Primary key — NOT NULL
- sessionId (session_id) — VARCHAR(255) — Foreign key → session.sessionId — NOT NULL
- playerId (player_id) — VARCHAR(255) — Foreign key → player.playerId — NOT NULL
- paintingId (painting_id) — VARCHAR(255) — Foreign key → painting.paintingId — NOT NULL
- role — VARCHAR(20) — NOT NULL
- message — VARCHAR(2000) — NOT NULL
- turnNo (turn_no) — INT — NOT NULL
- createdAt (created_at) — DATETIME — NOT NULL
painting
- paintingId (painting_id) — VARCHAR(255) — Primary key — NOT NULL
- title — VARCHAR(255) — NOT NULL
- artist — VARCHAR(255) — NOT NULL
- era — VARCHAR(255)
- personaPrompt (persona_prompt) — TEXT
- assetKey (asset_key) — VARCHAR(255)
player
- playerId (player_id) — VARCHAR(255) — Primary key — NOT NULL
player_stats
- playerId (player_id) — VARCHAR(255) — Foreign key → player.playerId — NOT NULL
- totalAttempts (total_attempts) — INT — NOT NULL
- correctCount (correct_count) — INT — NOT NULL
seal_record
- id — BIGINT — Primary key — NOT NULL
- playerId (player_id) — VARCHAR(255) — Foreign key → player.playerId — NOT NULL
- paintingId (painting_id) — VARCHAR(255) — Foreign key → painting.paintingId — NOT NULL
- sealedAt (sealed_at) — DATETIME — NOT NULL
- attempts — INT — NOT NULL
- quizAccuracy (quiz_accuracy) — DOUBLE — NOT NULL
session
- sessionId (session_id) — VARCHAR(255) — Primary key — NOT NULL
- playerId (player_id) — VARCHAR(255) — Foreign key → player.playerId — NOT NULL
- totalStamps (total_stamps) — INT — NOT NULL
- startedAt (started_at) — DATETIME — NOT NULL
session_target
- sessionId (session_id) — VARCHAR(255) — Foreign key → session.sessionId — NOT NULL
- paintingId (painting_id) — VARCHAR(255) — Foreign key → painting.paintingId — NOT NULL