book_story
Tables (3)
Books
- book_id — INT — Primary key — auto_increment
- title — VARCHAR(255) — NOT NULL
- author — VARCHAR(100) — NOT NULL
- published_date — DATE
- cover_image — VARCHAR(255)
- genre — VARCHAR(50)
- created_at — TIMESTAMP
Reviews
- review_id — INT — Primary key — auto_increment
- user_id — INT — NOT NULL
- book_id — INT — NOT NULL
- rating — INT
- review_text — TEXT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
user
- id — INT — Primary key — NOT NULL — auto_increment
- user_id — VARCHAR(50) — NOT NULL
- password — VARCHAR(50) — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP