Re: [GENERAL] Database Best Practices ???

"amy cheng" wrote:
>>The refint trigger is to make sure that the address record exists before
>>the person record is updated; if the relation is new there will not be
>>anything in person_address yet.
>I still do not understand. IMHO, "person" should not contain address at all
>--because of "person-address".
>
>>The project is not yet complete, so there may be bugs in it!
>you defend yourself well, except the "person" one ;-)

I suspect you may be right on that; this was only an extract from a much
larger work, so I haven't got round to reviewing it recently.

--
Vote against SPAM: http://www.politik-digital.de/spam/
========================================
Oliver Elphick Oliver(dot)Elphick(at)lfix(dot)co(dot)uk
Isle of Wight http://www.lfix.co.uk/oliver
PGP key from public servers; key ID 32B8FAA1
========================================
" ...Take heed, and beware of covetousness; for a man's
life consisteth not in the abundance of the things
which he possesseth." Luke 12:15