Jump to content


Photo

Thoughts on setting this up?


  • Please log in to reply
2 replies to this topic

#1 dodgyJim

dodgyJim
  • New Members
  • Pip
  • Newbie
  • 4 posts
  • LocationMelbourne, Australia

Posted 28 March 2006 - 10:18 PM

Hi all,

Having a few issues trying to work out the best way to set this db up.

I am still fairly new to it all so maybe I am trying to analyze this too hard...you know, can't see the forest for the trees etc.

General Product Data
Product Name - varchar
Height - varchar
Width - varchar
Small Image - varchar
Large Image - varchar

Colour Options
White - boolean (yes/no option only)
Custom - boolean
Anodised - boolean

Diffusers
Clear Reeded - boolean
Opal - boolean
Aluminium Louvre - boolean
Low Brightness Louvre - boolean

Bends
90 degree - boolean
45 degree - boolean
X Bend - boolean
T Bend - boolean
Custom Angled Bend - boolean




My initial plan was to stick it all into a massive table and enter in every product feature and hard code it to the page but then if the customer comes up with a new feature for a product I have to go back and add another field to the table and edit the page and queries etc. There's got to be a better way.

My first thought was to have a product table with the basic info and then another table with the feature in it, then I could reference each item according to it's ID in a third table.

tblproduct
id
name
height
width
etc

tblfeature
id
cat_id
name
image
etc

tbldata
id
prod_id
feat_id



If anyone has any ideas that could prod me along in the right direction it would be most appreciated.

cheers.

#2 wickning1

wickning1
  • Members
  • PipPipPip
  • Advanced Member
  • 405 posts

Posted 28 March 2006 - 11:05 PM

You're already heading in the right direction. It can become as complex as you allow it to become. Just be sure to stop somewhere so your software doesn't become vaporware. :)

#3 dodgyJim

dodgyJim
  • New Members
  • Pip
  • Newbie
  • 4 posts
  • LocationMelbourne, Australia

Posted 28 March 2006 - 11:11 PM

[!--quoteo(post=359467:date=Mar 29 2006, 09:05 AM:name=wickning1)--][div class=\'quotetop\']QUOTE(wickning1 @ Mar 29 2006, 09:05 AM) View Post[/div][div class=\'quotemain\'][!--quotec--]
You're already heading in the right direction. It can become as complex as you allow it to become. Just be sure to stop somewhere so your software doesn't become vaporware. :)
[/quote]

Yeah since my first post I have been playing with it a bit. Slowly sarting to get somewhere. Got a new requirement that is giving me a headache...time will tell! :)

Thanks for the reply.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users