[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[ale] Database consulting in return for homebrew?



Mike Harrison wrote:
>> performance and your natural key is spread amongst a few different
>> tables.  But, if you have a natural key present, use it.
>>     
>
> Can you give an example of a "natural key"?
>
> I abuse a column called "uniq" because my framework
> makes it easy to manipulate any table single record
> if that column is present..
>
> But you have me wondering what you mean.. I assume you mean things like 
> "transaction number" or "account id"..
>
>   
That's it.  Any field that  is unique and can be used to identify a 
specific row.

Jim.