lucky raccoon

Tables (9)

BaseEntity (기본엔티티)

  • createdAt (생성시간) — 모든 엔티티에 상속
  • updatedAt (수정시간) — 모든 엔티티에 상속

Chapter (챕터)

  • id — long — Primary key — NOT NULL
  • chapterName (챕터이름) — string — NOT NULL
  • chapterComment (챕터소개) — string

ChapterIndex (목차)

  • id — long — Primary key — NOT NULL
  • indexName (목차이름) — NOT NULL
  • indexComment (목차설명)
  • chapterId (챕터아이디) — long — Foreign key → Chapter.id — NOT NULL

Comment (댓글)

  • id — long — Primary key — NOT NULL
  • content (댓글 내용) — NOT NULL
  • userChapterId (유제챕터아이디) — Foreign key → UserChapter.id — NOT NULL

FamilyGroup (가족 그룹)

  • id — long — Primary key — NOT NULL
  • groupJoinId (그룹조인아이디) — string — NOT NULL
  • groupPassword (그룹 비밀번호) — string
  • groupName (그룹 이름) — string — NOT NULL
  • groupComment (그룹 설명) — string — NOT NULL
  • groupImage (그룹 사진) — string
  • groupCount (최대인원수) — int — NOT NULL
  • currentCount (현재 인원수) — int

Question (질문)

  • id — Primary key — NOT NULL
  • questionName (질문이름) — NOT NULL
  • questionComment (질문설명)
  • indexId (목차아이디) — long — Foreign key → ChapterIndex.id — NOT NULL

User (유저)

  • id — long — Primary key — NOT NULL
  • userId (유저아이디) — string — NOT NULL
  • userPassword (유저비밀번호) — string — NOT NULL
  • userName (유저이름) — string — NOT NULL
  • nickName (닉네임) — string — NOT NULL
  • email (이메일) — string — NOT NULL
  • gender (성별) — enum — NOT NULL
  • birth (생년월일) — date — NOT NULL
  • userImage (유저이미지) — string
  • fontSize (글자크기)
  • voiceSpeed (음성속도)
  • groupId (그룹아이디) — long — Foreign key → FamilyGroup.id — NOT NULL

UserChapter (유저챕터)

  • id — long — Primary key — NOT NULL
  • state (상태) — enum — NONE, PROGRESS, SUCCESS
  • progressPercent (진행도)
  • lastQuestionId (최근 질문 id) — long
  • finishedAt (완성 날짜)
  • chapterId (챕터아이디) — long — Foreign key → Chapter.id — NOT NULL
  • userId (유저아이디) — long — Foreign key → User.id — NOT NULL

UserQuestion (유저 질문)

  • id — Primary key — NOT NULL
  • answer (답변) — string
  • anserVoice (답변음성)
  • questionId (질문id) — long — Foreign key → Question.id — NOT NULL
  • userId (유저id) — long — Foreign key → User.id — NOT NULL