readwith
Tables (6)
Bookmarks
- bookmark_id — UUID — Primary key
- user_id — UUID — NOT NULL
- book_id — UUID — NOT NULL
- cfi — TEXT — NOT NULL
- note — TEXT
- created_at — TIMESTAMP
Books
- book_id — UUID — Primary key
- title — VARCHAR(255) — NOT NULL
- author — VARCHAR(255) — NOT NULL
- epub_url — TEXT — NOT NULL
- created_by — UUID — NOT NULL
- created_at — TIMESTAMP
CharacterRelations
- relation_id — UUID — Primary key
- book_id — UUID — NOT NULL
- character1_id — UUID — NOT NULL
- character2_id — UUID — NOT NULL
- relation_type — VARCHAR(50) — NOT NULL
- strength — INTEGER — NOT NULL
- created_at — TIMESTAMP
Characters
- character_id — UUID — Primary key
- book_id — UUID — NOT NULL
- name — VARCHAR(100) — NOT NULL
- description — TEXT
- created_at — TIMESTAMP
ChatLogs
- log_id — UUID — Primary key
- user_id — UUID — NOT NULL
- book_id — UUID — NOT NULL
- character_id — UUID — NOT NULL
- user_message — TEXT — NOT NULL
- bot_response — TEXT — NOT NULL
- created_at — TIMESTAMP
Users
- user_id — UUID — Primary key
- email — VARCHAR(255) — NOT NULL
- password_hash — TEXT — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- created_at — TIMESTAMP