Forum Discussion
Rajendran_SPT
Sep 26, 2020Copper Contributor
How to Table design track each activity in Web Application
For Example :
Take the User Module. The user module has below fields
- UserName
- DOB
- Certification - Multiple
- Project - Multiple
- Status of user - Active or Inactive
We need log for
- when the User created ,
- Who is created ,
- While creating howmany certification
- If removed the certification
- When removed
- who is removed
- If Added certification
- When Added
- What added
- Whos is added
We need that kind of log . So how design table structure for this requirement in SQL Server
1 Reply
Sort By
- Rajendran_SPTCopper Contributor
Rajendran_SPT do you able to understand the question. If not I will need rephrase it the content