openAI

Tables (12)

character_aliases

  • id — CHAR(36)
  • character_id — CHAR(36) — Foreign key → characters.id — NOT NULL
  • alias_text — VARCHAR(120) — NOT NULL
  • alias_type — VARCHAR(30) — NOT NULL
  • confidence — FLOAT
  • created_at — TIMESTAMP — NOT NULL

character_mentions

  • id — CHAR(36)
  • subtitle_line_id — CHAR(36) — Foreign key → subtitle_lines.id — NOT NULL
  • character_id — CHAR(36) — Foreign key → characters.id — NOT NULL
  • mention_text — VARCHAR(120) — NOT NULL
  • confidence — FLOAT
  • created_at — TIMESTAMP — NOT NULL

characters

  • id — CHAR(36)
  • title_id — CHAR(36) — Foreign key → titles.id — NOT NULL
  • canonical_name — VARCHAR(120) — NOT NULL
  • description — TEXT
  • first_episode_id — CHAR(36) — Foreign key → episodes.id
  • first_time_ms — INT
  • created_at — TIMESTAMP — NOT NULL

chat_messages

  • id — CHAR(36)
  • session_id — CHAR(36) — Foreign key → chat_sessions.id — NOT NULL
  • role — VARCHAR(16) — NOT NULL
  • content — TEXT — NOT NULL
  • current_time_ms — INT — NOT NULL
  • model — VARCHAR(60)
  • prompt_tokens — INT
  • completion_tokens — INT
  • related_relation_id — CHAR(36) — Foreign key → relations.id
  • created_at — TIMESTAMP — NOT NULL

chat_sessions

  • id — CHAR(36)
  • title_id — CHAR(36) — Foreign key → titles.id — NOT NULL
  • episode_id — CHAR(36) — Foreign key → episodes.id — NOT NULL
  • user_id — CHAR(36) — Foreign key → users.id
  • current_time_ms — INT — NOT NULL
  • meta — JSON
  • created_at — TIMESTAMP — NOT NULL

episodes

  • id — CHAR(36)
  • title_id — CHAR(36) — Foreign key → titles.id — NOT NULL
  • season — INT — NOT NULL
  • episode_number — INT — NOT NULL
  • name — VARCHAR(200)
  • duration_ms — INT
  • created_at — TIMESTAMP — NOT NULL

evidence_lines

  • evidence_id — CHAR(36) — Foreign key → evidences.id — NOT NULL
  • subtitle_line_id — CHAR(36) — Foreign key → subtitle_lines.id — NOT NULL
  • order_index — INT — NOT NULL

evidences

  • id — CHAR(36)
  • title_id — CHAR(36) — Foreign key → titles.id — NOT NULL
  • episode_id — CHAR(36) — Foreign key → episodes.id — NOT NULL
  • relation_id — CHAR(36) — Foreign key → relations.id
  • message_id — CHAR(36) — Foreign key → chat_messages.id
  • summary — VARCHAR(255)
  • representative_time_ms — INT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

relations

  • id — CHAR(36)
  • title_id — CHAR(36) — Foreign key → titles.id — NOT NULL
  • from_character_id — CHAR(36) — Foreign key → characters.id — NOT NULL
  • to_character_id — CHAR(36) — Foreign key → characters.id — NOT NULL
  • relation_type — VARCHAR(50) — NOT NULL
  • is_hypothesis — BOOLEAN — NOT NULL
  • confidence — FLOAT
  • valid_from_episode_id — CHAR(36) — Foreign key → episodes.id
  • valid_from_time_ms — INT — NOT NULL
  • valid_to_episode_id — CHAR(36) — Foreign key → episodes.id
  • valid_to_time_ms — INT
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP

subtitle_lines

  • id — CHAR(36)
  • episode_id — CHAR(36) — Foreign key → episodes.id — NOT NULL
  • start_ms — INT — NOT NULL
  • end_ms — INT — NOT NULL
  • text — TEXT — NOT NULL
  • speaker_text — VARCHAR(120)
  • speaker_character_id — CHAR(36) — Foreign key → characters.id
  • embedding — BLOB
  • created_at — TIMESTAMP — NOT NULL

titles

  • id — CHAR(36)
  • name — VARCHAR(200) — NOT NULL
  • description — TEXT
  • created_at — TIMESTAMP — NOT NULL

users

  • id — CHAR(36)
  • display_name — VARCHAR(100)
  • created_at — TIMESTAMP — NOT NULL