Re: 1.4 TABLE audittrail field person_id references person(entity_id)

[Chris Travers <..hidden..>]

My thinking is it would be better to just reference entity_id.  Here are my thoughts:

1.  Right now the assumption is that every item is added or modified by a person.  What if we want to add automated process accounts?  If we link to entity that makes that easier.

2.  If we link against entity(id), we don't have to change the data.

Best Wishes,

Chris Travers

On Sat, Nov 16, 2013 at 9:20 AM, herman vierendeels <..hidden..> wrote:

Hello,

Should field person_id in  audittrail not reference
person(id)
instead of
person(entity_id)

If different persons of same entity change things, you only see
entity.id , not person.id.
You cannot tell which person changed things.

Thanks
Herman

------------------------------------------------------------------------------
DreamFactory - Open Source REST & JSON Services for HTML5 & Native Apps
OAuth, Users, Roles, SQL, NoSQL, BLOB Storage and External API Access
Free app hosting. Or install the open source package on any LAMP server.
Sign up and see examples for AngularJS, jQuery, Sencha Touch and Native!
http://pubads.g.doubleclick.net/gampad/clk?id=63469471&iu=/4140/ostg.clktrk
_______________________________________________
Ledger-smb-devel mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel

--

Best Wishes,

Chris Travers

Efficito:  Hosted Accounting and ERP.  Robust and Flexible.  No vendor lock-in.

http://www.efficito.com/learn_more

------------------------------------------------------------------------------
Dive into the World of Parallel Programming! The Go Parallel Website,
sponsored by Intel and developed in partnership with Slashdot Media, is your
hub for all things parallel software development, from weekly thought
leadership blogs to news, videos, case studies, tutorials and more. Take a
look and join the conversation now. http://goparallel.sourceforge.net

_______________________________________________
Ledger-smb-devel mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel