Music database:- music_ID : this is set to auto-increment so when a new song is added to the database a new ID is assigned to that track
- music_url : a URL to the music file will be input into the database so when played it can be directed to the correct address
- genre : so that the mixtape maker can recommend music dependant on the users type of mixtape a genre must be given to the song file to define it
- artist : title of the artist
- title : title of the song
Playlist Database:- playlist_ID : this is set to auto-increment so when a user makes a playlist it is assigned an individual ID
- user_ID : pulled from the user database so that the playlist is assigned to the correct user
- playlist : a list of arrays which store which songs were selected for the playlist
- design : a list of arrays which store the design elements used for the design of the tape
- tape_colour : a variable is stored in this field dependant on what colour cassette tape was chosen
- tape_name : the name the user added to the mixtape
User Database : For login/register- user_ID : this is set to auto-increment so when a user registers with the site an individual ID is assigned to them
- username : Records the users choice of username
- email : Records the users email
- password : Records the users password
No comments:
Post a Comment