Re: Table Design In General

From: Ed Prochak <ed.prochak_at_magicinterface.com>
Date: 18 May 2005 10:47:47 -0700
Message-ID: <1116438467.931762.154050@g49g2000cwa.googlegroups.com>

By "dumb" primary key, do you mean a pseudo-key?

Re: the fence Mark hinted at, I fall on the side of not liking pseudo-keys. I'm not fanatical about it. Use them when they make sense, when they truely serve a purpose beyond saving a few bytes per row.

Re: using views, If you are going to "edit it accordingly", then you need an updateable view. This is something that must be designed carefully.

One question for you: what happened to your DB designers? How about asking them for guidance? ( but still ask here to get differing perspectives too)

Ed Received on Wed May 18 2005 - 12:47:47 CDT