search

atalantus / Wokabel-App

A vocabulary-trainer app for Android developed as a school project.
2 stars 0 forks source link

Reworking Databasestructure #28

Closed JonahKr closed 6 years ago

JonahKr commented 6 years ago

Task zur User Story: #5

← #15

Since Room doesn't support managing multiple tables with the same Java Object, we have to comprimize multiple tables into a Single one. Therefore we add a new atribute to the tables Subgroup and Supergroup.

Subgroup table structure:

Table name: Vocab

Subgroup ID String Vokabel ID String Key String Values String Helper String Level int
Buwhrös3 V&I(§R8gtf hello "Hallo,Hi" hello melwin, how are you? 235256623
B48z83J$9 Vasfw3 you "Du,ihr" YOU FOOL 4
B$(04jfps V34s4fs5 clock "Uhr" What time is it? - Look at the clock! 0

Supergroup table structure:

Tabel name: P3hhga

Supergroup ID String Subgroup ID String Name String
P3>>3a B7z44f Unit 2
Ps94uhnlyl B2zgf2 Unit2
P§(%&I$Gfsga B479hgf Unit 245