songs.composer utilization?

0
How does the composer ID field in songs get used? Seems like the songwriter could be a pair of INT fields linked to a single table of composers. In the songs table, one field for music, one for lyricist (if any)

In the composers table a tiny text field to allow multiple names.

The songs table probably should have some suggestions on proper copyright attribution, especially since the table offers a place for lyrics.
Responses (3)
  • Accepted Answer

    Wednesday, November 11 2009, 04:57 PM - #Permalink
    0
    the composers fields is just a free text field, not like "artist" field, that links to another table

    is just extra info for the song, but not searchable

    on a future version we may change this to be like artists. not sure.

    about "copyright attribution".. what you mean? what would you like to have exactly?

    Germi
    The reply is currently minimized Show
  • Accepted Answer

    Wednesday, September 04 2013, 04:16 AM - #Permalink
    0
    This is old but I want to avoid repeating the same question in a new thread. I assume we're talking about the composer_id column on muscol_songs. If that's the case I want to confirm there's no use for it at the moment as it will come handy to add more info to songs.
    • Germinal Camps
      more than a month ago
      that's correcty, there's no use for it at the moment. it's just a field on the DB that you can ignore.
    The reply is currently minimized Show
  • Accepted Answer

    Tuesday, September 24 2013, 06:53 AM - #Permalink
    0
    Thanks!! :)
    The reply is currently minimized Show
Your Reply