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