geulmatchum
Tables (6)
book (책정보)
- isbn (ISBN) — Primary key — NOT NULL
- title (제목)
- author (저자)
- pubdate (출간일)
- description (책소개)
- createAt (생성일)
- category (카테고리)
book content (책내용)
- pageId (페이지ID) — Primary key — NOT NULL
- isbn (ISBN) — Foreign key → book.isbn — NOT NULL
- bookContent (페이지 내용)
readBook (내가 읽던 책)
- userId (유저ID) — Foreign key → user.userId — NOT NULL
- isbn (ISBN) — Foreign key → book.isbn — NOT NULL
- page (읽던 페이지)
request (의뢰 내역)
- requestID (의뢰ID) — Primary key — NOT NULL
- userId (유저ID) — Foreign key → user.userId — NOT NULL
- isbn (ISBN) — Foreign key → book.isbn — NOT NULL
- progress (진행현황) — 담당자확인, 글맞춤, 검수,완료
text (읽기쉬운글)
- textId (글ID) — Primary key — NOT NULL
- userId (유저ID) — Foreign key → user.userId — NOT NULL
- reqText (요청 글)
- resText (응답 글)
- img (삽화)
user (유저)
- userId (유저ID) — Primary key — NOT NULL
- email (이메일)
- password (Field2)