Three table database - period (?)
From: Jens <jens_at_axon.is>
Date: Tue, 30 Jan 2001 12:11:25 +0000
Message-ID: <3A76AF6D.70C2F781_at_axon.is>
Date: Tue, 30 Jan 2001 12:11:25 +0000
Message-ID: <3A76AF6D.70C2F781_at_axon.is>
Hi
I have been wondering about the merits / pitfalls of the
following table structure:
Entity(ID)
EntityAttribute(EntityID, AttributeID)
Attribute(ID, Type, EntityID, Number, String, Date, Blob,
...)
This describes an entity that has some attributes linked to
it through the EntityAttribute table. The attribute table's
Type field describes which of the attribute fields is
actually used.
I don't seem to need any more tables as I can describe
anything with these three (or can I?). I'm also concerned
about speed and space consumption but the flexibility this
seems to give me is tempting.
You may even have a name for this 'little monster' :)
Any thoughts?
Thanks,
Jens
Received on Tue Jan 30 2001 - 13:11:25 CET