need simple strategy for universal extension table

From: TJ Talluto <tj(at)getlostspammers(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: need simple strategy for universal extension table
Date: 2004-11-09 19:20:20
Message-ID: UL8kd.80193$Kl3.64029@twister.socal.rr.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Instead of putting the same 12 columns on every table (these 12 columns
contain info about who created the record and when, for example)... It may
be more efficient to make a new table to hold that data.

This new table would act as a universal extension table. Instead of having
FKs back to any particular table, it would contain regular keys that point
back to whatever table::record is its source.

I was thinking of using two keys only:

xmOwnerInfo
COL1 PK* oidParentTable
COL2 PK* oidParentTablesRecord
COL3-15 [attribs]

Thoughts?

--
TJ Talluto
torpedo51 at yahoo dot com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alexander Cohen 2004-11-09 19:20:23 new data types
Previous Message Patrick Hatcher 2004-11-09 19:09:33 Vacuum hangs