browno Posted January 10, 2006 Author Share Posted January 10, 2006 Right, so if I have a ARTISTMAP for my 1 to many relationship then how do I join in my releases which was usually done by just artistid? Sorry!!! ARTISTMAP artistmap- bigint(20), unsigned, Key (Primary), auto_increment soloid bandid BANDS bandid - bigint(20), unsigned, Key (Primary), auto_increment bandname – varchar(255) placeformed – varchar(255) dateformed – date biography - longtext interview – longtext artistid - bigint(20), unsigned, Key (Primary), auto_increment SOLOS soloid - bigint(20), unsigned, Key (Primary), auto_increment soloname - varchar(255) dateborn - date biography - longtext interview – longtext website - varchar (255) artistimage - varchar(255) Link to comment https://forums.phpfreaks.com/topic/3157-music-database-design-help/page/2/#findComment-10794 Share on other sites More sharing options...
fenway Posted January 10, 2006 Share Posted January 10, 2006 I don't understand the question. Link to comment https://forums.phpfreaks.com/topic/3157-music-database-design-help/page/2/#findComment-10795 Share on other sites More sharing options...
browno Posted January 10, 2006 Author Share Posted January 10, 2006 [!--quoteo(post=335280:date=Jan 10 2006, 08:41 PM:name=fenway)--][div class=\'quotetop\']QUOTE(fenway @ Jan 10 2006, 08:41 PM) 335280[/snapback][/div][div class=\'quotemain\'][!--quotec--] I don't understand the question. If I have the above tables with the following, what do I replace artistid with? RELEASES ?releaseid - bigint(20), unsigned, Key (Primary), auto_increment ?reltitle - varchar(255) ?format - enum ?label - varchar (255) ?datereleased - date ?credits - text ?description - text ?artwork – varchar (255) ?artistid - bigint(20), unsigned, Key (MUL) Link to comment https://forums.phpfreaks.com/topic/3157-music-database-design-help/page/2/#findComment-10797 Share on other sites More sharing options...
fenway Posted January 10, 2006 Share Posted January 10, 2006 Why would you replace it with anything? You might have to make it a band_id instead, but otherwise, there's nothing wrong. Link to comment https://forums.phpfreaks.com/topic/3157-music-database-design-help/page/2/#findComment-10798 Share on other sites More sharing options...
browno Posted January 10, 2006 Author Share Posted January 10, 2006 [!--quoteo(post=335294:date=Jan 10 2006, 09:55 PM:name=fenway)--][div class=\'quotetop\']QUOTE(fenway @ Jan 10 2006, 09:55 PM) 335294[/snapback][/div][div class=\'quotemain\'][!--quotec--] Why would you replace it with anything? You might have to make it a band_id instead, but otherwise, there's nothing wrong. Can I make it accept both soloids and bandids? I thought it would have to be one or the other. Thanks! Link to comment https://forums.phpfreaks.com/topic/3157-music-database-design-help/page/2/#findComment-10800 Share on other sites More sharing options...
fenway Posted January 10, 2006 Share Posted January 10, 2006 Well, if all artists have a band_id, then you might as well link it to artist_id, and find the band from there. Alternatively, you can put in whatever uid you want, and have a type field. Personally, I prefer the former, because it's better DB design. Link to comment https://forums.phpfreaks.com/topic/3157-music-database-design-help/page/2/#findComment-10802 Share on other sites More sharing options...
browno Posted January 11, 2006 Author Share Posted January 11, 2006 [!--quoteo(post=335329:date=Jan 10 2006, 11:57 PM:name=fenway)--][div class=\'quotetop\']QUOTE(fenway @ Jan 10 2006, 11:57 PM) 335329[/snapback][/div][div class=\'quotemain\'][!--quotec--] Well, if all artists have a band_id, then you might as well link it to artist_id, and find the band from there. Alternatively, you can put in whatever uid you want, and have a type field. Personally, I prefer the former, because it's better DB design. My head hurts! If i have: ARTISTMAP artistmap- bigint(20), unsigned, Key (Primary), auto_increment soloid bandid BANDS bandid - bigint(20), unsigned, Key (Primary), auto_increment bandname – varchar(255) placeformed – varchar(255) dateformed – date biography - longtext interview – longtext website - varchar (255) artistimage - varchar(255) SOLOS soloid - bigint(20), unsigned, Key (Primary), auto_increment soloname - varchar(255) dateborn - date biography - longtext interview – longtext website - varchar (255) artistimage - varchar(255) then what do I do? Can you modify this one. I'm going crazy! THANK YOU! Link to comment https://forums.phpfreaks.com/topic/3157-music-database-design-help/page/2/#findComment-10803 Share on other sites More sharing options...
fenway Posted January 11, 2006 Share Posted January 11, 2006 What you should really do at this point is put in some dummy data and see how it all works together, or draw one of those annoying DB design diagrams, if that's your thing. It will be much easier to see it this way. However, to make a _final_ point, you simply have to decide logically whether or not bands -OR- artists have releases, and based on that, put the appropriate FK in the releases table. I think you can take it from here -- especially after 32 posts; good luck. Link to comment https://forums.phpfreaks.com/topic/3157-music-database-design-help/page/2/#findComment-10804 Share on other sites More sharing options...
browno Posted January 11, 2006 Author Share Posted January 11, 2006 OK! Thanks for all your help! Link to comment https://forums.phpfreaks.com/topic/3157-music-database-design-help/page/2/#findComment-10809 Share on other sites More sharing options...
franck Posted September 9, 2006 Share Posted September 9, 2006 Hello ... no one posted in this topic for at least 30 days, I'm also designing a DB for localbands but this DB will only englobe metal bands ... and there are lots of styles inside metal music category.Anyway an idea for your DB is that you could have the table BANDS and if there is just one member then it is still a band.Now ... I'm just going to start with this other idea of database i hope you guys are stilling around to give me a hand .. bye Link to comment https://forums.phpfreaks.com/topic/3157-music-database-design-help/page/2/#findComment-88974 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.