primary key - tag numbers
From: tretasdehr <tretasdehr_at_yahoo.co.uk>
Date: 23 Feb 2003 07:46:11 -0800
Message-ID: <cc15b354.0302230746.5a9abfe5_at_posting.google.com>
In a database of animals at a large shelter, the tag number of the animals can be large, but it will still need to be repeated after about 2 years. That is, the tag number will be used again.
Date: 23 Feb 2003 07:46:11 -0800
Message-ID: <cc15b354.0302230746.5a9abfe5_at_posting.google.com>
In a database of animals at a large shelter, the tag number of the animals can be large, but it will still need to be repeated after about 2 years. That is, the tag number will be used again.
If the tag number is to be used as the primary key in a (SQL) database that has to preserve its records for legal reasons, what is the best way to keep the primary key unique and prevent it from repeating with the re-use of the tag number?