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