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. > > 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
