ReadWith

Tables (11)

book

  • id — BIGINT
  • title — VARCHAR(200) — NOT NULL
  • author — VARCHAR(120)
  • language — CHAR(2) — NOT NULL
  • is_default — BOOLEAN
  • cover_img_url — VARCHAR(255)
  • epub_path — VARCHAR(255) — NOT NULL
  • uploaded_by_user_id — BIGINT
  • created_at — TIMESTAMP

chapter

  • id — BIGINT
  • book_id — BIGINT — NOT NULL
  • idx — INT — NOT NULL
  • title — VARCHAR(200)
  • page_start — INT
  • page_end — INT
  • start_pos — INT
  • end_pos — INT
  • raw_text — TEXT
  • summary_text — TEXT
  • pov_summaries_cached — BOOLEAN

chapter_character_stat

  • id — BIGINT
  • chapter_id — BIGINT — NOT NULL
  • character_id — BIGINT — NOT NULL
  • mention_count — INT — NOT NULL

chapter_relationship_edge

  • id — BIGINT
  • book_id — BIGINT — NOT NULL
  • chapter_idx — INT — NOT NULL
  • from_char_id — BIGINT — NOT NULL
  • to_char_id — BIGINT — NOT NULL
  • cumulative_interaction — INT — NOT NULL
  • sentiment_weighted_sum — FLOAT — NOT NULL
  • cumulative_sentiment — FLOAT
  • edge_color_hex — CHAR(7)
  • edge_width — FLOAT

character

  • id — BIGINT
  • book_id — BIGINT — NOT NULL
  • name — VARCHAR(120) — NOT NULL
  • is_main_character — BOOLEAN
  • first_chapter_idx — INT
  • personality_text — TEXT
  • embedding_vector — VECTOR(512)

character_pov_summary

  • id — BIGINT
  • chapter_id — BIGINT — NOT NULL
  • character_id — BIGINT — NOT NULL
  • summary_text — TEXT

event

  • id — BIGINT
  • chapter_id — BIGINT — NOT NULL
  • idx — INT — NOT NULL
  • page_start — INT
  • page_end — INT
  • start_pos — INT
  • end_pos — INT
  • raw_text — TEXT
  • summary_text — TEXT
  • embedding_vector — VECTOR(768)
  • created_at — TIMESTAMP

event_character_stat

  • id — BIGINT
  • event_id — BIGINT — NOT NULL
  • character_id — BIGINT — NOT NULL
  • mention_count — INT — NOT NULL

event_relationship_edge

  • id — BIGINT
  • event_id — BIGINT — NOT NULL
  • from_char_id — BIGINT — NOT NULL
  • to_char_id — BIGINT — NOT NULL
  • interaction_count — INT — NOT NULL
  • sentiment_label — sentiment_enum — NOT NULL
  • sentiment_score — FLOAT — NOT NULL
  • relation_tags — JSONB
  • explanation — TEXT
  • edge_color_hex — CHAR(7)
  • edge_width — FLOAT

user

  • id — BIGINT
  • email — VARCHAR(100) — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • provider — provider_enum — NOT NULL
  • provider_uid — VARCHAR(120) — NOT NULL
  • profile_img_url — VARCHAR(255)
  • jwt_refresh_token — CHAR(128)
  • created_at — TIMESTAMP

user_read_state

  • id — BIGINT
  • user_id — BIGINT — NOT NULL
  • book_id — BIGINT — NOT NULL
  • last_read_chapter_idx — INT — NOT NULL
  • last_read_event_idx — INT
  • bookmarks — JSONB
  • highlights — JSONB
  • updated_at — TIMESTAMP