Looking for simple Database design to simply check in checkout timestamps with comments, and istory recorded
Posted on 2014-09-16
I am looking for a simple database design simply used as a diary or work log. Two buttons - Check in and Checkout.
When checking out the user has to fill in one line of narrative. This is recorded in a table and then goes to the next row and the process can be repeated. Its almost acts as a diary and work log and all history is saved.
The table should contain the start and end times (dd/mm/yyy hh:mm:ss), username and the narrative. Calculated fields will also display the duration in minutes and seconds.
I would be grateful if some recommended code can be provided or example can be found on internet.