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)