DOGE
Tables (13)
Chapter (Untitled6)
- ChapterId (Key2) — Primary key — NOT NULL
- CourseId (Key) — Foreign key → Course.CourseId — NOT NULL
- ChapterNum (Field)
- ChapterContents (Field2)
Course (Untitled5)
- CourseId (Key) — Primary key — NOT NULL
- CourseName (Field)
ImgQuestion (Untitled10)
- QuestionId (Key3) — Primary key — NOT NULL
- ChapterId (Key2) — Foreign key → Chapter.ChapterId — NOT NULL
- CourseId (Key) — Foreign key → Chapter.CourseId — NOT NULL
- Question (Field)
- Example (Field4)
- Answer (Field2)
- ImgFile (Field3)
- CreateDate (Field5)
- LastUpdateDate (Field6)
MovieQuestion (Untitled9)
- QuestionId (Key3) — Primary key — NOT NULL
- ChapterId (Key2) — Foreign key → Chapter.ChapterId — NOT NULL
- CourseId (Key) — Foreign key → Chapter.CourseId — NOT NULL
- Question (Field)
- Example (Field4)
- Answer (Field2)
- MovieFile (Field3)
- CreateDate (Field5)
- LastUpdateDate (Field6)
QuestList (Untitled8)
- QuestId (Key) — Primary key — NOT NULL
- QuestName (Field)
- xp (Field2)
- DeadLine (Field3)
SentenceQuestion (CopyOfUntitled11)
- QuestionId (Key3) — Primary key — NOT NULL
- ChapterId (Key2) — Foreign key → Chapter.ChapterId — NOT NULL
- CourseId (Key) — Foreign key → Chapter.CourseId — NOT NULL
- Question (Field)
- Example (Field3)
- Answer (Field2)
- CreateDate (Field4)
- LastUpdateDate (Field5)
ShopItemList (Untitled3)
- ItemId (Key) — Primary key — NOT NULL
- ItemName (Field)
TTSQuestion (CopyOfUntitled9)
- QuestionId (Key3) — Primary key — NOT NULL
- ChapterId (Key2) — Foreign key → Chapter.ChapterId — NOT NULL
- CourseId (Key) — Foreign key → Chapter.CourseId — NOT NULL
- Question (Field)
- Example (Field4)
- Answer (Field2)
- TTSFile (Field3)
- CreateDate (Field5)
- LastUpdateDate (Field6)
USER (Untitled)
- Email (Key) — Primary key — NOT NULL
- pw (Field)
- Name (닉네임)
- Birth (Field3)
- Img (프로필 이미지)
- xp (Field12)
- Money (Field13)
- Alarm (알람 설정 유무) — Boolean
- Theme (Field5)
- Status (삭제된 계정인지 아닌지)
- Contact (어떤 경유로 서비스를 알게 되었는가)
- TotalGoal (어떤 목표로 웹서비스를 이용하는가)
- DayGoal (일일 학습 목표)
- CreateDate (Field6)
- LastUpdateDate (Field7)
UserItem (Untitled2)
- Email (Key) — Foreign key → USER.Email — NOT NULL
- ItemId (Key2) — Foreign key → ShopItemList.ItemId — NOT NULL
- Status (Field2)
- BuyDate (Field)
UserQuest (Untitled7)
- Email (Key) — Foreign key → USER.Email — NOT NULL
- QuestId (Key2) — Foreign key → QuestList.QuestId — NOT NULL
- Status (Field)
UserStudyResult (Untitled4)
- Email (Key) — Foreign key → USER.Email — NOT NULL
- ChapterId (Key2) — Foreign key → Chapter.ChapterId — NOT NULL
- CourseId (Key3) — Foreign key → Chapter.CourseId — NOT NULL
- Status (완료한 상태인지 아닌지)
- Progress (진척도)
- Accuracy (정확도)
- LastDate (Field4)
WordQuestion (Untitled11)
- QuestionId (Key3) — Primary key — NOT NULL
- ChapterId (Key2) — Foreign key → Chapter.ChapterId — NOT NULL
- CourseId (Key) — Foreign key → Chapter.CourseId — NOT NULL
- Question (Field)
- Example (Field3)
- Answer (Field2)
- CreateDate (Field4)
- LastUpdateDate (Field5)