browno Posted January 6, 2006 Share Posted January 6, 2006 Hello! I'm really needing some help. I'm currently trying to create a website dedicated to the local music scene in my area. I want to have a database containing as much info as possible about the artist (name, where they're from, a biography, interviews) as well as info about their releases (titles, credits, single or album). I'd also like to have tracklistings from these releases that the user can click on for individual song info and lyrics. So... I've setup a preliminary database with three tables: artists, releases and songs. ARTISTS artistid - smallint, length (6), Key (Primary), Default (NULL) artistname - varchar (70), Key (Mul?) origin - varchar (40) yearformed - year, length (4) biography - longtext website - varchar (40) interview - longtext artistimage - varchar (40) artisttype - char (1) RELEASES releaseid - smallint, length (6), Key (Primary), Default (NULL) reltitle - varchar, length (50) format - varchar, length (20) label - varchar, length (30) year - year, length (4) credits - mediumtext description - mediumtext artwork - varchar, length (30) artistname - varchar, length (70) SONGS songid - int, length (11), Key (Primary), Default (NULL) songtitle - varchar, length (50) trackno - tinyint, length (4) composer - varchar (80) performer - varchar (50) lyrics - mediumtext reltitle - varchar (50) I hope you can see what I'm trying to do. On the website you click on an artist, you get their bio and a discography. You can click on an album in the discography which will show you the tracklisting for that album. You can then click on that song to get lyrics or whatever. So, by not really knowing what I'm doing, is my design ok? artist and release are joined by artistname and releases and songs are joined by reltitle. Also, do I have to declare my intended lengths for varchars. Does it improve the efficiency of the DB in anyway? Thanks so much for your help!! Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.