On 12 October 2016 at 10:54, Lahiru Cooray <[email protected]> wrote: > > > On Tue, Oct 11, 2016 at 1:44 PM, Sanjeewa Malalgoda <[email protected]> > wrote: > >> I think we can manage audit table while still having CREATED_BY, >> CREATED_TIME,UPDATED_BY, UPDATED_TIME in same tables. So with that >> approach we may never need to do table scan of audit table while fetching >> updates. So each updates will recorded in separate table while original >> table having all relevant information. WDYT? >> > > +1 > Also we may need the highlighted separate audit table to keep a track of > deleted rows. >
Hi Lahiru, Yes I highlighted the need for auditing entity deletions in my initial mail. > >> Thanks, >> sanjeewa. >> >> _______________________________________________ >> Architecture mailing list >> [email protected] >> https://mail.wso2.org/cgi-bin/mailman/listinfo/architecture >> >> > > > -- > *Lahiru Cooray* > Software Engineer > WSO2, Inc.;http://wso2.com/ > lean.enterprise.middleware > > Mobile: +94 715 654154 > > _______________________________________________ > Architecture mailing list > [email protected] > https://mail.wso2.org/cgi-bin/mailman/listinfo/architecture > > -- Regards, Uvindra Mobile: 777733962
_______________________________________________ Architecture mailing list [email protected] https://mail.wso2.org/cgi-bin/mailman/listinfo/architecture
