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)