Task #624

Log Table Design

Added by Wong Bernard almost 14 years ago. Updated over 13 years ago.

Status:Closed - End of life cycleStart date:November 11, 2010
Priority:NormalDue date:November 11, 2010
Assignee:Wong Bernard% Done:

100%

Category:-Estimated time:16.00 hours
Target version:-Spent time:21.00 hours

Description

Design log tables to be used for user transaction activities

MPI_User_Transaction_Log_Tables.pdf (4.55 KB) Wong Bernard, November 11, 2010 00:20

draft3.pdf (4.28 KB) Wong Bernard, November 11, 2010 22:02

History

#1 Updated by Wong Bernard almost 14 years ago

  1. First draft of log table design
  2. Please review for go finalize design

#2 Updated by Wong Bernard almost 14 years ago

  • File draft3.pdf added
  • % Done changed from 50 to 80
  • Estimated time changed from 8.00 to 16.00
  1. Redesigned logging table database
  2. Dropped extraneous logging tables not required based on Function Spec documents
  3. Current design caters for M2U History module and user logout activity summary
  4. Please review to finalize design

#3 Updated by Wong Bernard almost 14 years ago

  • File MPI_Database.pdf added
  • File MPI_Logging_Tables.pdf added
  • Status changed from Pending Review to Development / Work In Progress
  • % Done changed from 80 to 100
  1. Redesigned database based on input during meetings
  2. Finalized design

Attached two diagrams for logging tables and MPI database.

#4 Updated by Wong Bernard almost 14 years ago

  • File deleted (MPI_Database.pdf)

#5 Updated by Wong Bernard almost 14 years ago

  • File deleted (MPI_Logging_Tables.pdf)

#6 Updated by Wong Bernard almost 14 years ago

  • Status changed from Development / Work In Progress to Work Completed-End life cycle

#7 Updated by Tan Lee Yong over 13 years ago

  • Status changed from Work Completed-End life cycle to Closed - End of life cycle

Also available in: Atom PDF