Songs Data fields

Luis
Luis
Offline
0
For customization of songs, we need to get some help on data-table for songs.

(1) What is 'num' field used for which is tinyint(3) type. What numbers it adds when a new song is created ? What is this data meant for.

(2) It has composer ID - int(6) - field but there is no table for composers so when adding the song, where to pull composer ID from ?
Responses (6)
  • Accepted Answer

    Sunday, April 08 2012, 11:39 AM - #Permalink
    0
    1) it is for ordering the songs in the album

    2) this is a deprecated field. it is not used at all.
    The reply is currently minimized Show
  • Accepted Answer

    Luis
    Luis
    Offline
    Monday, April 09 2012, 12:36 PM - #Permalink
    0
    one more thing to know - what kind of data to be stored in 'chords' field
    The reply is currently minimized Show
  • Accepted Answer

    Monday, April 09 2012, 12:38 PM - #Permalink
    0
    guitar tab chords and lyrics
    The reply is currently minimized Show
  • Accepted Answer

    Luis
    Luis
    Offline
    Thursday, April 12 2012, 10:38 AM - #Permalink
    0
    For music lovers, Composers' details are very important part about any song. It is unfortunate that composers field is deprecated.
    The reply is currently minimized Show
  • Accepted Answer

    Thursday, April 12 2012, 10:39 AM - #Permalink
    0
    you can use the field SONGWRITERS for this purpose! :)
    The reply is currently minimized Show
  • Accepted Answer

    Luis
    Luis
    Offline
    Friday, April 13 2012, 07:07 PM - #Permalink
    0
    For songwriters field, I wish to use song-writers :) so thats occupied
    The reply is currently minimized Show
Your Reply