BookRatingDB
Tables (4)
BOOK
- book_id (책ID) — INT — Primary key — NOT NULL
- title (제목) — VARCHAR(100) — NOT NULL
- author (저자) — VARCHAR(50)
- publisher (출판사) — VARCHAR(50)
- price (가격) — INT
- category_id (카테고리ID) — INT — Foreign key → CATEGORY.category_id — NOT NULL
CATEGORY
- category_id (카테고리ID) — INT — Primary key — NOT NULL
- name (이름) — VARCHAR(50) — NOT NULL
- description (설명) — VARCHAR(200)
REVIEW
- review_id (리뷰ID) — INT — Primary key — NOT NULL
- rating (별점) — INT
- content (내용) — TEXT
- created_at (생성날짜) — TIMESTAMP
- user_id (유저ID) — VARCHAR(20) — Foreign key → USER.user_id — NOT NULL
- book_id (책ID) — INT — Foreign key → BOOK.book_id — NOT NULL
USER
- user_id (유저ID) — VARCHAR(20) — Primary key — NOT NULL
- password (비밀번호) — VARCHAR(20) — NOT NULL
- nickname (닉네임) — VARCHAR(20)
- email (이메일) — VARCHAR(50)