On Mon, Aug 7, 2017 at 11:51 AM, < <[email protected]> [email protected]> wrote:
> > [snip] > > On the other hand, you do model the data after business relations, but the > keys that tie that relation data need/should never be seen in a well > designed system. If a user readable key is needed by business, then there > should be another data piece that the user can read (like an MRN, medical > record number, or an abbreviation that is unique and human readable) But > these should never be used to link together data in a structure in primary > key foreign key relation. > [snip] > > > +1 My point exactly, only stated much better. ---------------------------- Steve Simpson ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
