data_base

Tables (4)

Book_Notes

  • note_id — INT — Primary key — NOT NULL
  • user_book_id — INT — Foreign key → User_Books.user_book_id — NOT NULL
  • page_number — INT
  • memo_text — TEXT — NOT NULL
  • updated_at — DATETIME — NOT NULL

Books

  • book_id — INT — Primary key — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • author — VARCHAR(50) — NOT NULL
  • total_pages — INT — NOT NULL
  • genre — VARCHAR(30)

User_Books

  • user_book_id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → Users.user_id — NOT NULL
  • book_id — INT — Foreign key → Books.book_id — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • current_page — INT — NOT NULL
  • start_date — DATE
  • end_date — DATE

Users

  • user_id — INT — Primary key — NOT NULL
  • email — VARCHAR(50) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL