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