Song variations improvements #3

New issue

Open

opened 2021-07-22 12:47:22 +00:00 by dsonck · 2 comments

dsonck commented

2021-07-22 12:47:22 +00:00

(Migrated from git.touhou.fm)

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 fromsongs`.
Add the related_songs join table with a type_id indicating how they are related.
Add the related_song_types table to define the relation types.
- Should have a description, prefix, inverse_prefix

Migration

A new related_types should be created for soundtracks:
Soundtrack of
Any set main_song_id or sound_track_id values should create the appropriate related_songs

Related song types

description	prefix	inverse_prefix
Soundtrack	soundtrack of	arrangement
Instrumental	instrumental of	instrumental
Remix	remix of	remix

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_id` columns from `songs`. - Add the `related_songs` join table with a `type_id` indicating how they are related. - Add the `related_song_types` table to define the relation types. - Should have a `description`, `prefix`, `inverse_prefix` **Migration** - A new `related_types` should be created for soundtracks: `Soundtrack of` - Any set `main_song_id` or `sound_track_id` values should create the appropriate `related_songs` **Related song types** | description | prefix | inverse_prefix | | ----------- | ------ | -------------- | | Soundtrack | soundtrack of | arrangement | | Instrumental | instrumental of | instrumental | | Remix | remix of | remix |

dsonck commented

2021-07-22 12:56:48 +00:00

(Migrated from git.touhou.fm)

changed the description

dsonck commented

2021-07-22 13:16:27 +00:00

(Migrated from git.touhou.fm)

changed the description