database table layout help
| From: | Barry Rumsey | Date: | Mon, 15 Apr 2002 22:02:10 +0000 |
| Subject: | database table layout help | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-18521@lists.php.net to get a copy of this message | ||
I am setting up a music info site and have decided on the follow tables
( not to sure weather to add the mp3 part). The one main question I have
before starting to make the tables is weather mysql_insert_id() would be
able to handle this with the way I have it ?
:Artist
id
artist_name
:Album
id - auto-inc
artist_id
album_name
rec_id
image_id
:Songs
id - auto-inc
album_id
genre_id
mp3_id
lyrics
:Genre
id - auto-inc
genre
:Recording
id - auto-inc
recording_studio
date
:Album Image
id - auto-inc
image
:Artist Info
id - auto-inc
info
:Mp3
id - auto-inc
mp3_location
Any other suggestions are welcome.
B.J.Rumsey