-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On Tue, Aug 09, 2005 at 07:35:11PM +1000, Adam W wrote:
> Hi,
>
> Can anyone put a name to the following type of design...
>
> I need to be able to modify the amount/names of data "fields" stored
> for an entity so instead of representing the data stored for an entity
> in fields associated with that entity you would relate it to an
> another entity which would contain a datafield type field and its
> associated value, so different rows in the parent table could possibly
> have different datafields associated with it.
Postgresql supports a sort of "Object-Oriented" table system where
you can have a base table and then make an extended table that adds a few
fields to the base table while "inheriting" all of the existing
items in the base table. This sounds something similar to what you
are looking for.
You still have to spend time thinking out a suitable inheritance
tree and all that design stuff plus this is a postgresql-specific feature
so you sacrifice some portability.
- Tel
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.6 (GNU/Linux)
iQIVAwUBQv28ucfOVl0KFTApAQIqZA/+IHiSGC2aeHeP7DRPkwvE7vIm6UIBmlde
lrk0+yV8/SDUQu7g/ADskrjYHBYvJtnV24S8hoMsTQbGtnB9AjFjHmnXCEHHoFwi
+xwHvTZ04vXiU8Rc+ozk/Pg0niYgeXIF0FBpWrjiNgjI2FX5iU7q+z5uLITolls6
QW4AP/a4kxRSNBvS/H4e3+1vR1Oe0UO97iyeWTttub/O1+l054QmDp08cnPS25hb
NR9QC0QEi/s8b1SV9ePRgDvsiPZiGoi6DHKk7amcowkSK9EDs9XvB1AECnfWigy/
EEX+q6yu69AZoPsLT6ngo2BzyzDu+sM2aEbj7Ud/hnfd4mKpxhmVsQIgTWSQvpia
HuU/5dr9NKs5Z1g0WGNkOgKyt/9u4BthNSDfXelYDVjKmHi6noEOucVLFfPGvRbl
gSXBjLow0KyHws9pHVb+72mzMEbs19asHtptxUa431JaPiQpwmVp6haVizWYIKeS
TpBSq4ApQiQTtkMyF0i2MwQi7w4erl4tO6Xe3aOTPVbHi8Lv//K4xe82DU42DGRy
tK7o2H7SxmbhvGiy/NCwIO1jAF/Xj0mIGTrqRSDdCrcIt9EZ2TQUmBvVLoV0KgDo
nplKpNDWhvMrNr20VsLRKNwAJD99yJzRDF+a3wc4+BRDevQNvbNu5ruN4Pq7OllE
w0G9wgWb59A=
=VSvi
-----END PGP SIGNATURE-----
--
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html
