How to Table design track each activity in Web Application

%3CLINGO-SUB%20id%3D%22lingo-sub-1715575%22%20slang%3D%22en-US%22%3EHow%20to%20Table%20design%20track%20each%20activity%20in%20Web%20Application%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1715575%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSTRONG%3EFor%20Example%20%3A%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CSTRONG%3ETake%20the%26nbsp%3B%20User%20Module.%20The%20user%20module%20has%20below%20fields%3C%2FSTRONG%3E%3C%2FP%3E%3COL%3E%3CLI%3EUserName%3C%2FLI%3E%3CLI%3EDOB%3C%2FLI%3E%3CLI%3ECertification%20-%20Multiple%3C%2FLI%3E%3CLI%3EProject%20-%20Multiple%26nbsp%3B%3C%2FLI%3E%3CLI%3EStatus%20of%20user%20-%20Active%20or%20Inactive%26nbsp%3B%3C%2FLI%3E%3C%2FOL%3E%3CP%3EWe%20need%26nbsp%3B%20log%26nbsp%3B%20for%3C%2FP%3E%3CUL%3E%3CLI%3Ewhen%20the%20User%20created%20%2C%3C%2FLI%3E%3CLI%3EWho%20is%20created%20%2C%3C%2FLI%3E%3CLI%3EWhile%20creating%20howmany%20certification%26nbsp%3B%3C%2FLI%3E%3CLI%3EIf%20removed%20the%20certification%26nbsp%3B%3CUL%3E%3CLI%3EWhen%20removed%26nbsp%3B%3C%2FLI%3E%3CLI%3Ewho%20is%20removed%26nbsp%3B%3C%2FLI%3E%3C%2FUL%3E%3C%2FLI%3E%3CLI%3EIf%20Added%20certification%26nbsp%3B%3CUL%3E%3CLI%3EWhen%20Added%26nbsp%3B%3C%2FLI%3E%3CLI%3EWhat%20added%26nbsp%3B%3C%2FLI%3E%3CLI%3EWhos%20is%20added%26nbsp%3B%3C%2FLI%3E%3C%2FUL%3E%3C%2FLI%3E%3C%2FUL%3E%3CP%3EWe%20need%20that%20kind%20of%20log%20.%20So%20how%20design%20table%20structure%20for%20this%20requirement%20in%20SQL%20Server%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

For Example :

Take the  User Module. The user module has below fields

  1. UserName
  2. DOB
  3. Certification - Multiple
  4. Project - Multiple 
  5. 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
Highlighted

@Rajendran_SPT  do you able to understand the question. If not I will need rephrase it the content