I think I'm in need of a little bit of database design guidance.
I have a website that will be selling photos. I want to store all the
information about the photo and any comments about it, and give a list of
sizes it's available in, plus a price depending on which price scale the
photo falls into, low, medium, or high. So far, I have 3 tables I'm
confident in:
|images|
id MEDIUMINT NOT NULL PRIMARY KEY
filename VARCHAR(50)
|image_comments|
image_id MEDIUMINT NOT NULL PRIMARY KEY
comment TEXT
|image_attrib|
image_id MEDIUMINT NOT NULL PRIMARY KEY
title VARCHAR(50)
...
(bunch of film type stuff)
...
price ENUM("L","M","H") NOT NULL
Now, my problem is I don't know how to link a photo to a specific set of
sizes it's available in (4x6, 5x7, 8x10, etc) AND link those sizes to a
particular price scale.
Sorry if this is more of a gen DB question instead of MySQL, but I'd
appreciate any help.
Jason Soza
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
