Bug ID domain?

[Jason Pyeron]

On Fri, 25 Apr 2003, Bradley Baetz wrote:

>On Fri, Apr 25, 2003 at 03:23:27AM -0400, Jason Pyeron wrote:
>
>Well, you don't need a PK. Have the field id be non-null, and add unique
>constraint on (bug, field).
>
>Think about the 'multiple' bit - there is no PK there since (bug, field)
>isn't unique.

I just assumed that he had PK(bug,field,row) for that.

I don't like not having a identity column. It just makes every thing 
easier. 

So the results are in? UNIQUE (bug,field,etc) PK(ID) -- or don't have ID

Jason Pyeron


-- 
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
-                                                               -
- Jason Pyeron                   http://www.pyerotechnics.com   -
- Owner & Lead                  Pyerotechnics Development, Inc. -
- +1 410 808 6646 (c)           500 West University Parkway #1S -
- +1 410 467 2266 (f)           Baltimore, Maryland  21210-3253 -
-                                                               -
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

This message is for the designated recipient only and may contain 
privileged, proprietary, or otherwise private information. If you
have received it in error, purge the message from your system and 
notify the sender immediately.  Any other use of the email by you 
is prohibited.