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