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)