BookSystem

Tables (4)

Book

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

ReadLog

  • log_id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → User.user_id — NOT NULL
  • book_id — INT — Foreign key → Book.book_id — NOT NULL
  • status — ENUM('reading', 'read')
  • start_date — DATETIME
  • end_date — DATETIME — NOT NULL

Review

  • review_id — INT — Primary key — NOT NULL
  • book_id — INT — Foreign key → Book.book_id — NOT NULL
  • user_id — INT — Foreign key → User.user_id — NOT NULL
  • rating — INT
  • comment — TEXT
  • created_at — DATETIME

User

  • user_id — INT — Primary key — NOT NULL
  • email — VARCHAR(50)
  • password — VARCHAR(50)
  • username — VARCHAR(50)