Library

Tables (4)

Book (도서)

  • id (user_id) — INT — Primary key
  • category (book_category) — VARCHAR(20) — Primary key
  • title (book_title) — VARCHAR(20) — Primary key
  • like (book_liked) — BOOLEAN
  • description (book_description) — VARCHAR(30)
  • Field

User (사용자)

  • id (user_id) — INT — Primary key — NOT NULL
  • nickname (user_nickname) — VARCHAR(20)
  • password (user_password) — VARCHAR(20)
  • phoneNumber (user_phone_numer) — VARCHAR(11)
  • like (user_liked) — BOOLEAN
  • gender (user_gender) — VARCHAR(10)

book_info (도서 설명)

  • title (book_title) — VARCHAR(20) — Primary key
  • description (book_description) — VARCHAR(30) — Primary key

category (카테고리 정보)

  • category (book_category) — VARCHAR(20) — Primary key
  • count (book_count) — INT