Skip to content

Database Schemas

Static Tables schemes

CREATE TABLE `_LetterData` (
  `Id` varchar(255),
  `Number` int(11) DEFAULT NULL,
  `Added` varchar(255),
  `Active` tinyint(4) DEFAULT NULL,
  `Complexity` varchar(255),
  `Title` varchar(255),
  `Kind` varchar(255),
  `BaseLetter` varchar(255),
  `Symbol` varchar(255),
  `SoundZone` varchar(255),
  `Type` varchar(255),
  `Tag` varchar(255),
  `Notes` varchar(255),
  `SunMoon` varchar(255),
  `Sound` varchar(255),
  `Isolated` varchar(255),
  `Final` varchar(255),
  `Medial` varchar(255),
  `Initial` varchar(255),
  `Isolated_Unicode` varchar(255),
  `Final_Unicode` varchar(255),
  `Medial_Unicode` varchar(255),
  `Initial_Unicode` varchar(255),
  `Symbol_Unicode` varchar(255),
  `FinalFix` varchar(255),
  `MedialFix` varchar(255),
  `InitialFix` varchar(255),
  `Old_Isolated` varchar(255),
  `Old_Final` varchar(255),
  `Old_Medial` varchar(255),
  `Old_Initial` varchar(255),
)

CREATE TABLE `_MiniGameData` (
  `Id` varchar(255),
  `Type` varchar(255),
  `Status` varchar(255),
  `Main` varchar(255),
  `Variation` varchar(255),
  `Badge` varchar(255),
  `Description` varchar(255),
  `Team` varchar(255),
  `Title_En` varchar(255),
  `Title_Ar` varchar(255),
  `Intro_En` varchar(255),
  `Intro_Ar` varchar(255),
  `Tutorial_En` varchar(255),
  `Tutorial_Ar` varchar(255),
  `Scene` varchar(255),
  `Notes` varchar(255),
  `SkillTiming` varchar(255),
  `SkillPrecision` varchar(255),
  `SkillObservation` varchar(255),
  `SkillListening` varchar(255),
  `SkillLogic` varchar(255),
  `SkillMemory` varchar(255),
  `TOTAL` varchar(255),
  `Comprehension` varchar(255),
)


CREATE TABLE `_PhraseData` (
  `Id` varchar(255),
  `Active` tinyint(4) DEFAULT NULL,
  `English` varchar(255),
  `Arabic` varchar(255),
  `Linked` varchar(255),
  `Category` varchar(255),
  `Words` varchar(255),
  `Answers` varchar(255),
  `Complexity` varchar(255),
  `Notes` varchar(255),
)

CREATE TABLE `_PlaySessionData` (
  `Stage` int(11) DEFAULT NULL,
  `LearningBlock` int(11) DEFAULT NULL,
  `PlaySession` int(11) DEFAULT NULL,
  `Title_En` varchar(255),
  `Title_Ar` varchar(255),
  `Description_En` varchar(255),
  `Description_Ar` varchar(255),
  `Notes` varchar(255),
  `Focus` varchar(255),
  `Letters` varchar(255),
  `Type` varchar(255),
  `Words` varchar(255),
  `Words_previous` varchar(255),
  `Phrases` varchar(255),
  `Phrases_previous` varchar(255),
  `Order` varchar(255),
  `NumberOfMinigames` varchar(255),
  `NumberOfRounds` varchar(255),
  `AssessmentType` varchar(255),
  `Maze` varchar(255),
  `FastCrowd_letter` varchar(255),
  `ThrowBalls_letters` varchar(255),
  `Tobogan_letters` varchar(255),
  `Balloons_letter` varchar(255),
  `TakeMeHome` varchar(255),
  `Egg_letters` varchar(255),
  `Egg_sequence` varchar(255),
  `ColorTickle` varchar(255),
  `HideSeek` varchar(255),
  `AlphabetSong_alphabet` varchar(255),
  `AlphabetSong_letters` varchar(255),
  `MixedLetters_alphabet` varchar(255),
  `FastCrowd_alphabet` varchar(255),
  `MakeFriends` varchar(255),
  `DancingDots` varchar(255),
  `SickLetters` varchar(255),
  `ThrowBalls_letterinword` varchar(255),
  `MissingLetter` varchar(255),
  `Balloons_spelling` varchar(255),
  `FastCrowd_spelling` varchar(255),
  `MixedLetters_spelling` varchar(255),
  `Balloons_words` varchar(255),
  `FastCrowd_words` varchar(255),
  `ThrowBalls_words` varchar(255),
  `Tobogan_words` varchar(255),
  `Scanner` varchar(255),
  `Balloons_counting` varchar(255),
  `FastCrowd_counting` varchar(255),
  `MissingLetter_phrases` varchar(255),
  `MissingLetter_forms` varchar(255),
  `Scanner_phrase` varchar(255),
  `ReadingGame` varchar(255),
)

CREATE TABLE `_StageData` (
  `Id` varchar(255),
  `Title_En` varchar(255),
  `Title_Ar` varchar(255),
  `Description` varchar(255),
)

CREATE TABLE `_WordData` (
  `Id` varchar(255),
  `added` varchar(255),
  `Active` varchar(255),
  `Kind` varchar(255),
  `Category` varchar(255),
  `Complexity` varchar(255),
  `Gender` varchar(255),
  `Form` varchar(255),
  `Article` varchar(255),
  `LinkedWord` varchar(255),
  `Value` varchar(255),
  `Arabic` varchar(255),
  `Symbols` varchar(255),
  `Drawing` varchar(255),
  `Letters` varchar(255),
  `Transliteration` varchar(255),
  `SunMoon` varchar(255),
  `Notes` varchar(255),
)

Dynamic Tables schemes

CREATE TABLE `DatabaseInfoData` (
  `Uuid` longtext,
  `Timestamp` int(11) DEFAULT NULL,
  `DynamicDbVersion` longtext,
  `StaticDbVersion` longtext COLLATE utf8_bin
)

CREATE TABLE `JourneyScoreData` (
  `Uuid` longtext,
  `JourneyDataType` int(11) DEFAULT NULL,
  `ElementId` longtext,
  `Stage` int(11) DEFAULT NULL,
  `LearningBlock` int(11) DEFAULT NULL,
  `PlaySession` int(11) DEFAULT NULL,
  `Stars` int(11) DEFAULT NULL,
  `UpdateTimestamp` int(11) DEFAULT NULL
)

CREATE TABLE `LogInfoData` (
  `Id` int(11) NOT NULL,
  `Uuid` longtext,
  `AppSession` int(11) DEFAULT NULL,
  `Timestamp` int(11) DEFAULT NULL,
  `Event` int(11) DEFAULT NULL,
  `Scene` int(11) DEFAULT NULL,
  `AdditionalData` longtext,
  )

CREATE TABLE `LogMiniGameScoreData` (
  `Id` int(11) NOT NULL,
  `Uuid` longtext,
  `AppSession` int(11) DEFAULT NULL,
  `Timestamp` int(11) DEFAULT NULL,
  `Stage` int(11) DEFAULT NULL,
  `LearningBlock` int(11) DEFAULT NULL,
  `PlaySession` int(11) DEFAULT NULL,
  `MiniGameCode` int(11) DEFAULT NULL,
  `Stars` int(11) DEFAULT NULL,
  `PlayTime` double DEFAULT NULL,
  )

CREATE TABLE `LogMoodData` (
  `Id` int(11) NOT NULL,
  `Uuid` longtext,
  `AppSession` int(11) DEFAULT NULL,
  `Timestamp` int(11) DEFAULT NULL,
  `MoodValue` double DEFAULT NULL,
  )

CREATE TABLE `LogPlayData` (
  `Id` int(11) NOT NULL,
  `Uuid` longtext,
  `AppSession` int(11) DEFAULT NULL,
  `Timestamp` int(11) DEFAULT NULL,
  `Stage` int(11) DEFAULT NULL,
  `LearningBlock` int(11) DEFAULT NULL,
  `PlaySession` int(11) DEFAULT NULL,
  `MiniGameCode` int(11) DEFAULT NULL,
  `PlayEvent` int(11) DEFAULT NULL,
  `PlaySkill` int(11) DEFAULT NULL,
  `Score` double DEFAULT NULL,
  `AdditionalData` longtext,
  )

CREATE TABLE `LogPlaySessionScoreData` (
  `Id` int(11) NOT NULL,
  `Uuid` longtext,
  `AppSession` int(11) DEFAULT NULL,
  `Timestamp` int(11) DEFAULT NULL,
  `Stage` int(11) DEFAULT NULL,
  `LearningBlock` int(11) DEFAULT NULL,
  `PlaySession` int(11) DEFAULT NULL,
  `Stars` int(11) DEFAULT NULL,
  `PlayTime` double DEFAULT NULL,
  )

CREATE TABLE `LogVocabularyScoreData` (
  `Id` int(11) NOT NULL,
  `Uuid` longtext,
  `AppSession` int(11) DEFAULT NULL,
  `Timestamp` int(11) DEFAULT NULL,
  `Stage` int(11) DEFAULT NULL,
  `LearningBlock` int(11) DEFAULT NULL,
  `PlaySession` int(11) DEFAULT NULL,
  `MiniGameCode` int(11) DEFAULT NULL,
  `VocabularyDataType` int(11) DEFAULT NULL,
  `ElementId` longtext,
  `Score` double DEFAULT NULL,
  )

CREATE TABLE `PlayerProfileData` (
  `Timestamp` int(11) DEFAULT NULL,
  `Uuid` longtext,
  `AvatarId` int(11) DEFAULT NULL,
  `Gender` int(11) DEFAULT NULL,
  `Tint` int(11) DEFAULT NULL,
  `IsDemoUser` int(11) DEFAULT NULL,
  `JourneyCompleted` int(11) DEFAULT NULL,
  `TotalScore` double DEFAULT NULL,
  `Age` int(11) DEFAULT NULL,
  `ProfileCompletion` int(11) DEFAULT NULL,
  `MaxStage` int(11) DEFAULT NULL,
  `MaxLearningBlock` int(11) DEFAULT NULL,
  `MaxPlaySession` int(11) DEFAULT NULL,
  `CurrentStage` int(11) DEFAULT NULL,
  `CurrentLearningBlock` int(11) DEFAULT NULL,
  `CurrentPlaySession` int(11) DEFAULT NULL,
  `TotalBones` int(11) DEFAULT NULL,
  `CurrentAnturaCustomization` longtext,
  `AdditionalData` longtext COLLATE utf8_bin
)

CREATE TABLE `VocabularyScoreData` (
  `Uuid` longtext,
  `VocabularyDataType` int(11) DEFAULT NULL,
  `ElementId` longtext,
  `Score` double DEFAULT NULL,
  `Unlocked` int(11) DEFAULT NULL,
  `UpdateTimestamp` int(11) DEFAULT NULL
)