Table: band
Each record in band represents a band
Columns
- bid i pk
- The unique id representing the band
- members p
- A list of songs structures - the songs on the band's profile
- members.member.name p
- The name of the band member.
- members.member.pic_big p
- An absolute url to the large sized version of the band member's profile photo
- members.member.pic_square p
- An absolute url to the thumbnail version of the band member's profile photo
- members.member.uid p
- The uid (user id) of a band member.
- music_albums p
- A list of music_album structures - the music_albums on the band's profile
- music_albums.music_album.maid p
- The maid (music album id) of the music album.
- music_albums.music_album.name p
- The name of the music_album.
- music_albums.music_album.pic p
- The pic associated with the music_album.
- music_albums.music_album.tracks p
- The list of tracks in the music_album.
- music_albums.music_album.tracks.track.song p
- The bid (band id) of a song.
- music_albums.music_album.tracks.track.song.artist_name p
- The name of the artist of a song.
- music_albums.music_album.tracks.track.song.duration p
- The duration, in seconds, of a song.
- music_albums.music_album.tracks.track.song.name p
- The name of the song.
- music_albums.music_album.tracks.track.song.sid p
- The sid (song id) of a song.
- music_albums.music_album.tracks.track.song.url p
- The url of the song.
- music_albums.music_album.tracks.track.track_number p
- The track number of a track in a music_album.
- name i
- The band's display name
- pic
- An absolute url to the medium sized version of the band's profile photo
- pic_big
- An absolute url to the large sized version of the band's profile photo
- pic_small
- An absolute url to the thumbnail version of the band's profile photo
- pic_square
- An absolute url to the thumbnail version of the band's profile photo
- shows p
- A list of show structures - the shows on the band's profile
- shows.show.date p
- The date of the show.
- shows.show.detail p
- The details of the show.
- shows.show.location p
- The location of the show.
- songs p
- A list of songs structures - the songs on the band's profile
- songs.song.artist_name p
- The name of the artist of a song.
- songs.song.duration p
- The duration, in seconds, of a song.
- songs.song.name p
- The name of the song.
- songs.song.sid p
- The sid (song id) of a song.
- songs.song.url p
- The url of the song.