madmaxoft / SkauTan

Music player for Skautské Tancování
https://skautske-tancovani.cz/
The Unlicense
1 stars 2 forks source link

Reorganize DB: file-related vs song-related #94

Closed madmaxoft closed 6 years ago

madmaxoft commented 6 years ago

The DB should get reorganized. The file-related data about a library song should be stored in one table, the son-related data in another table; both tables linked via a hash. Multiple files could link to the same song.

File-related:

Song-related:

This way duplicates in the library would be well-represented (their individual tags would stay complete), while still allowing a shared state that is common for all of them.

@kalich5 What do you think about TagManual (manual author, title, genre, mpm) being stored per-file, or per-logical-song?