Database design help
Posted: Mon Aug 28, 2006 2:19 pm
I'm working on a photo album and I need help designing my database. It's pretty standard: the pictures are collected in albums, and more albums can be in albums as well. Addition to that users can leave comments for individual pictures.
Obviously pictures could have comments from zero to any number.
What is the easiest way to design my database?
I'm thinking I might assign to each picture a unique number no matter what album they're in and have a separate table for comments. For each comment I'll assign that unique number and list them in order underneath my picture.
Does it sound like a good way to go? Or can you guys recommend a better way?
Obviously pictures could have comments from zero to any number.
What is the easiest way to design my database?
I'm thinking I might assign to each picture a unique number no matter what album they're in and have a separate table for comments. For each comment I'll assign that unique number and list them in order underneath my picture.
Does it sound like a good way to go? Or can you guys recommend a better way?