Skip to content

Instantly share code, notes, and snippets.

@huckfinnaafb
Created January 11, 2012 15:43
Show Gist options
  • Save huckfinnaafb/1595247 to your computer and use it in GitHub Desktop.
Save huckfinnaafb/1595247 to your computer and use it in GitHub Desktop.
Item -> Attributes
----------------------
item_id | attribute_id
1 5
1 8
Item Attributes
-----------------------------
attribute_id | human_readable
5 Wood Floors
6 Carpet
7 AC
8 Heated Pool
OR
Item -> Item Types
------------------
item_id | item_type
1 1
Item Types -> Attributes
------------------------
item_type | attribute_id
1 5
1 6
1 8
Attributes
----------
attribute_id | human_readable
1 "Wood Floors"
2 "AC"
3 "Pool"
4 "Dicks"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment