[Rockhounds] I D Numbers when cataloging
Kreigh Tomaszewski
Kreigh at Tomaszewski.net
Tue Dec 2 19:09:27 PST 2008
Amen!
Use a simple sequential number, but prefix it with something that ties
the sequence to you.
Kreigh
On Tuesday, Dec 2, 2008, at 21:48 America/Detroit, J. R. Hodel wrote:
<snip>
> Ideally, data keys should be information free, except for the fact of
> the key and its uniqueness. This is practically so because in
> relational databases it is difficult ( sort of impossible) to change a
> key field when it contains a data item which is discovered to be in
> error later on, as key fields are usually propagated to other DB
> tables containing the real data fields about the item in question.
> <snip>
More information about the Rockhounds
mailing list