[thelist] Architecture for arbitrary data management

Joe Flintham list at menticulture.com
Fri Feb 29 08:48:23 CST 2008


kasimir-k wrote:
> I'd approach it with something like this:
>
> table items
> - itemId
> - userId
> - timeAdded
>
> table properties
> - propertyId
> - propertyName
>
> table items_x_properties
> - itemId
> - propertyId
> - propertyValue
>
> .k
>   
Thanks kasimir - one question:

presumably you'd make items_x_properties.propertyValue a longtext field, 
even though the values could be anything from an integer to a float to a 
short string to a journal length article?

Joe



More information about the thelist mailing list