Re: identity columns
From: --CELKO-- <71062.1056_at_compuserve.com>
Date: 9 Jan 2002 10:09:23 -0800
Message-ID: <c0d87ec0.0201091009.784dc71b_at_posting.google.com>
Date: 9 Jan 2002 10:09:23 -0800
Message-ID: <c0d87ec0.0201091009.784dc71b_at_posting.google.com>
>> As an example you might think of records of invoices, which may
have a
natural candidate key combined of foreign keys to Customer and Order.
Nevertheless, a running integer is often used as a primary key, eg. to
document (for the auditor) that no sale is forgotten. <<
The reason for sequential numbers was that they were printed on the paper order forms, so they existed before the actual order. The auditor wanted to be able to go to the PHYSICAL document for each order in the PHYSICAL filing cabinet. Received on Wed Jan 09 2002 - 19:09:23 CET