Re: [GENERAL] need simple strategy for universal extension table

2004-11-13 Thread TJ Talluto
Since nobody has mentioned any nuances about mapping these keys to system tables in this particular database, I'll assume this is a good idea for now. -- TJ Talluto torpedo51 at yahoo dot com ---(end of broadcast)--- TIP 4: Don't 'kill -9' the post

Re: [GENERAL] need simple strategy for universal extension table

2004-11-13 Thread Mike Rylander
On Tue, 09 Nov 2004 19:20:20 GMT, TJ Talluto <[EMAIL PROTECTED]> wrote: > 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 u

[GENERAL] need simple strategy for universal extension table

2004-11-13 Thread TJ Talluto
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 pa