[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