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