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