bookr_review
Tables (3)
books
- book_id — BIGINT
- title — VARCHAR(200) — NOT NULL
- author — VARCHAR(100)
- publisher — VARCHAR(100)
- category — VARCHAR(50)
- description — TEXT
- cover_url — VARCHAR(300)
- created_by — BIGINT — Foreign key → users.user_id
reviews
- review_id — BIGINT
- user_id — BIGINT — Foreign key → users.user_id
- book_id — BIGINT — Foreign key → books.book_id
- rating — INT
- title — VARCHAR(255)
- content — TEXT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
users
- user_id — BIGINT
- email — VARCHAR(100) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- created_at — TIMESTAMP