ms access - Audit table design suggestions -


is correct approach? suggestions make better?

  1. below screenshot of employee table , shadow table tl_name , dept fields may change , using shadow table track changes.

  2. records inserted/updated in main table , gets copied shadow table of data macro.

  3. all records in shadow table have approved/rejected superuser

  4. main table have updated alignment , shadow table have entire history of changes employee.

  5. when record added/updated in main table via userform, copy of record created in shadow table has approved admin.

  6. when record added/updated in main table via userform, is_active field set false , once approved admin updated true.

enter image description here

as understand requirements:

  • changed/inserted data should visible everyone, visible flag un-approved data.
  • this reasonable, if work under assumption majority of changes correct , approved (hopefully true ;) ).

i think missing:

  • if change rejected, data in main table should automatically reverted recent approved state.
  • otherwise main table stays in (sort of) undefined state forever, is_active = false , (apparently) wrong data.

this can done audit table design. find latest approved entry emp pk, , use data.

but if number of columns audited may change in future, might consider approach 2 tables, in project: https://autoaudit.codeplex.com/documentation

auditheader table

this table inserted 1 row everytime 1 record inserted, updated or deleted in table has been setup use autoaudit system.

auditdetail table

this table related auditheader , inserted 1 row each column changed during insert or update operation , each column during delete operation.

if save old + new values every change, can revert "old" state current audit entry.

and structure change of main table (or if decide e.g. users can edit emp_name too) doesn't need structure change of audit table, because every audited column in main mapped row in auditdetails instead of column.

edit: additional advantage:

in sample data have marked changed values in red. access table doesn't work that. if want keep information ("which column(s) edited?"), need additional column in audit table.

this covered auditdetail, since contains each change old + new value.


Comments

Post a Comment

Popular posts from this blog

inversion of control - Autofac named registration constructor injection -

does autofac support specifying registration name in components' constructors? example: ninject's namedattribute . you need use autofac.extras.attributed package on top achieve this so let's have 1 interface , 2 classes: public interface ihello { string sayhello(); } public class englishhello : ihello { public string sayhello() { return "hello"; } } public class frenchhello : ihello { public string sayhello() { return "bonjour"; } } then have consumer class, in want select instance injected: public class helloconsumer { private readonly ihello helloservice; public helloconsumer([withkey("en")] ihello helloservice) { if (helloservice == null) { throw new argumentnullexception("helloservice"); } this.helloservice = helloservice; } public string sayhello() { return this.helloservice.sayhello()...
Read more

verilog - Systemverilog dynamic casting issues -

i've code snippet following in testbench function void write_to_port( my_data_type_base data ); my_data_type_extended data_ext; if(!$cast(data_ext, data)); `uvm_error(get_type_name(), "failed cast"); `uvm_info(get_name(), $psprintf("data_ext :\n%s", data_ext.sprint()), uvm_medium) // write data_ext out port.... endfunction when run it, i'm getting uvm_error "failed cast." i'm not quire sure why $cast not returning 1. can see, i'm printing out extended class data item after casting uvm_info. can see it's being cast properly. if don't use $cast if condition, don't runtime error. isn't coding practice use if dynamic cast check if $cast returning 1 ? what might reason behind cast not returning 1 in above case? i think semicolon on line 'if' not belong? i think consumes if statement, , uvm_error executes regardless of how if evaluates: if(!$cast(data_ext, data)); <- no semico...
Read more

ios - Change Storyboard View using Seague -

i have following code checks connection server, , depending on want change views if no connection found. nsstring *connect = [nsstring stringwithcontentsofurl:[nsurl urlwithstring:@"http://myserver.com"] encoding:nsutf8stringencoding error:nil]; if (connect == null) { [self performseguewithidentifier:@"network_failure" sender:self]; } else { // other code here } my problem not change views. have added storyboard segue between 2 views identifier of network_failure . not have navigation controller or that, problem? thanks help! no not problem. first of all, in objectivec exists nil object oriented null . must use that. so: if(connect == nil) or better: if(!connect) so due fact nil not same of null , probably code does't enter in if scope . you have been able discover breakpoint. anyway: be sure set trigger segue (line) 2 view controller , , name network_failure (that not best name. should instead view1toview2 ) as, m...
Read more