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