Jump to content


ideas for schema

  • Please log in to reply
21 replies to this topic

#21 Zane

  • Administrators
  • Advanced Member
  • 4,134 posts

Posted 08 September 2006 - 11:26 PM

yeah this is backwards...as fenway said

catid        subcatid
item        couches
item        beds
item        desks
item        refrigerator
event      tickets
event      concerts
event      clubs
event      sports
event      parties
event      charity events
rental      sublets
rental      parking

go the other way
category      parentCategory
item            root
rental          root
event           root
couches 	item		  
beds		item
desks 		item
refrigerator	item
tickets 	event
concerts 	event
clubs 		event
sports 		event
parties 	event
charity events  event
sublets 	rental
parking 	rental

and suppose couches had two sub categories....making a 'sub-sub'
just had them as

category - parent
leather    - couches
fabric      - couches

there's no levels it's just referencing

basketball - sports
birthday - parties
21st birthdays - birthday
and so on

btn_donate_SM.gif Want to thank me? Contribute to my PayPal piggy-bank


#22 fenway

  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 09 September 2006 - 03:53 AM

You know, if you're just going to come up with your own solution anyway, why ask for the experience of others?  Don't get me wrong, if you think your innovative solution will work, then go with it, but trust me, it's completely upside-down and entirely inflexible.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users