Display Code

See below. The hiragana/katana in the first two panels are clickable.

Logic: Get all images for a chapterID. Foreach image - Get all overlays for the specified image ID

Scoping

Front End Pages

  • Reading Dashboard (User Stats)
  • Series List (ability to sort by media type, most recently updated, etc)
  • Series Overview (show series cover photos, series details -- age rating, chapter count, etc)
  • Read Chapter (display content of specified chapter)

Reading Practice - Database Tables

Reading_Series Table
  • seriesID
  • title
  • coverImageURL
Reading_Chapters Table
  • chapterID
  • seriesID
  • title
  • coverImageURL
  • publishDate
Reading_Series_Category_Options Table
  • seriesCategoryID
  • title
Reading_Series_Category_Assignment Table
  • seriesCategoryAssignmentID
  • seriesID
  • seriesCategoryID
Reading_Chapter_Category_Options Table
  • chapterCategoryID
  • title
Reading_Series_Category_Assignment Table
  • chapterCategoryAssignmentID
  • chapterID
  • chapterCategoryID
Reading_Chapters_Vocab Table
  • chapterVocabID
  • chapterID
  • VocabularyID
Reading_Chapters_Grammar Table
  • chapterGrammarID
  • chapterID
  • grammarID
Reading_Chapters_Unlocked Table
  • chapterUnlockedID
  • chapterID
  • userID
Images Table
  • chapterImageID
  • chapterID
  • orderNo
  • imageURL
Image Overlays Table
  • imageOverlayID
  • imageID
  • title
  • content
  • xPosition
  • yPosition
  • width
  • height