Re: integer id columns for all tables
From: -CELKO- <jcelko212_at_earthlink.net>
Date: 28 Aug 2006 13:56:50 -0700
Message-ID: <1156798610.100816.100020_at_b28g2000cwb.googlegroups.com>
Date: 28 Aug 2006 13:56:50 -0700
Message-ID: <1156798610.100816.100020_at_b28g2000cwb.googlegroups.com>
In addition to what Bob mentioned, you have no validation or verification on those numbers. Since they are generated by the hardware at insertion time, they are not part of a relational data model.
Most of the programmers doing this are mimicing a sequential file system or an OID rather usng a proper relational key. At best, with careful triggers and other code, you can make them into a stable redundancy. Received on Mon Aug 28 2006 - 22:56:50 CEST