Re: PostgreSQL Developer Best Practices

On 8/25/2015 1:42 PM, Gavin Flower wrote:
> Account numbers are externally generated, and may potentially change.
> Management might suddenly decide that they want to start using the
> year the account started as the first 4 digits, or that the branch
> code should be reflected in it, or something else.  The database
> should be protected from these arbitrary changes.  Hence the
> account_no is not a good candidate for a primary key.


such practices would raise total havoc on a traditional paper ledger
accounting system as well as things like pending AR/AP where external
companies will be referencing your account numbers.




--
john r pierce, recycling bits in santa cruz