[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