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)