On Wed, 2 Feb 2005 07:56:44 +0000, Tony Bowden <tony-maypole at kasei.com> wrote:
> PK's should *always* be meaningless.
not *meaningless*, they mean a unique identifier for whatever they are
PK for. But you are right they should not have a meaning beyond that.
> Adding data in about things like part numbers, tray numbers etc leads to
> a world of pain when supposedly invariable data changes, as, invariably,
> happens.
Amen brother.
I have just been dealing with a company via a webservices and they
helpfully provided stock_codes for each item. Yes, that stock code was
user defined.... and guess what before we even did a weeks development
those values were changing and dissappearing.
never ever ever re-use something else as an identifier. Either you
don't need an identifier and can use a compound key of non-unique
fields that is unique to that record or you need an identifier that is
reliable, unchanging and unique.
I can't believe I had to ask these people for real unique id's,
explaining why it was important.
A.
_______________________________________________
maypole mailing list
maypole at lists.netthink.co.uk
http://lists.netthink.co.uk/listinfo/maypole
This archive was generated by hypermail 2.1.3 : Thu Feb 24 2005 - 22:25:58 GMT