Holiday Project

Tables (4)

Book (책)

  • id (아이디) — String — Primary key — NOT NULL
  • title (제목) — String
  • author (저자) — String
  • publisher (출판사) — String
  • pageCount (쪽수) — Long
  • thumbnail (표지) — URL
  • countForDifficulty (평가갯수) — int
  • difficultyScore (평가점수) — int

BookMark (북마크)

  • id (아이디) — Long — Primary key — NOT NULL
  • user_email (사용자이메일) — String — Foreign key → User.email — NOT NULL
  • book_id (책아이디) — Long — Foreign key → Book.id — NOT NULL
  • status (독서상태) — String
  • time (독서한 시간) — float

Memo (메모)

  • number (번호) — Long — Primary key — NOT NULL
  • email (이메일) — String — Foreign key → User.email — NOT NULL
  • id (아이디) — String — Foreign key → Book.id — NOT NULL
  • content (내용) — String
  • date (날짜) — String

User (사용자)

  • email (이메일) — String — Primary key — NOT NULL
  • nickName (닉네임) — String