Song variations improvements
Currently, songs can refer to 2 "variations". The sound_track_id
indicates which original ZUN work it is a derivative of. The main_song_id
indicates how this song is related to it (e.g. "off vocal", "extended edition", etc.).
This, however, is probably going to be limiting in the long run. Instead, it would be better to convert this kind of foreign linking with a related_songs
join table.
Upon completion
- Remove the
main_song_id
,main_song_type_id and
sound_track_idcolumns from
songs`. - Add the
related_songs
join table with atype_id
indicating how they are related. - Add the
related_song_types
table to define the relation types.- Should have a
description
,prefix
,inverse_prefix
- Should have a
Migration
- A new
related_types
should be created for soundtracks:Soundtrack of
- Any set
main_song_id
orsound_track_id
values should create the appropriaterelated_songs
Related song types
description | prefix | inverse_prefix |
---|---|---|
Soundtrack | soundtrack of | arrangement |
Instrumental | instrumental of | instrumental |
Remix | remix of | remix |