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