Re: variable column table

From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: Tue, 27 May 2003 14:24:05 +0000
Message-ID: <bavlg0$rjt$1@ctb-nnrp2.saix.net>

sybrandb_at_yahoo.com wrote:

> Design a meta-system where you have one central table holding entities
> and attributes. Currently don't have such a design at hand, but I have
> seen it several times.

You mean having one table with loads of columns?

Then have a kind of dictionary table that says for entity type 1, col 1 is name, col 2 is colour and so on, while for entity type 2, col 1 is weight and col 2 is a description?

Or do I have my mouth around the wrong end of the bottle?

--
Billy

Received on Tue May 27 2003 - 09:24:05 CDT