GongcheckMVP

Tables (4)

Book (Untitled)

  • Key (bookID) — Primary key — NOT NULL

User

  • Key (userID) — Primary key — NOT NULL
  • Field (nickname) — varchar(20) — NOT NULL — 이용자 닉네임
  • Field (gender) — varchar(1) — NOT NULL — 성별
  • Field (birth) — date — NOT NULL — 출생년도
  • Field (readingType) — varchar(20) — 책장 타입 결과
  • Field (isAgree) — varchar(1) — 공감여부
  • Field (feedback) — text — 피드백

bookShelf

  • Key (bookShelfImage) — Primary key — NOT NULL — 이미지 경로
  • Key (userID) — Foreign key → User.Key — NOT NULL

userBook

  • Key (bookID) — Foreign key → Book.Key — NOT NULL
  • Key (userID) — Foreign key → User.Key — NOT NULL