테스트
테이블 (5)
books
- book_id — INT — 기본 키 — NOT NULL
- title — VARCHAR(200) — NOT NULL
- author — VARCHAR(100) — NOT NULL
- publisher — VARCHAR(100)
- genre — VARCHAR(50)
- cover_img — VARCHAR(500)
- pub_date — DATE
goals
- goal_id — INT — 기본 키 — NOT NULL
- user_id — INT — 외래 키 → users.user_id — NOT NULL
- month — VARCHAR(7) — NOT NULL
- target — INT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
reading_records
- record_id — INT — 기본 키 — NOT NULL
- status — VARCHAR(20) — NOT NULL
- start_date — DATE
- end_date — DATE
- memo — TEXT
- created_at — DATETIME — NOT NULL
- user_id — INT — 외래 키 → users.user_id — NOT NULL
- book_id — INT — 외래 키 → books.book_id — NOT NULL
reviews
- review_id — INT — 기본 키 — NOT NULL
- rating — TINYINT — NOT NULL
- content — VARCHAR(500) — NOT NULL
- is_deleted — TINYINT — NOT NULL
- created_at — DATETIME — NOT NULL
- user_id — INT — 외래 키 → users.user_id — NOT NULL
- book_id — INT — 외래 키 → books.book_id — NOT NULL
users
- user_id — INT — 기본 키 — NOT NULL
- username — VARCHAR(50) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- created_at — DATETIME — NOT NULL