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