Guest User

Untitled

a guest
Sep 14th, 2018
88
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.57 KB | None | 0 0
  1. Transaction log
  2. Name: alert_transactio_log
  3. id auto increment pk
  4. user_id int Who is making the changes
  5. field_name varchar Column name
  6. table_name varchar Table ie., getting affected
  7. module_id int Which module? Ex: User/ alert
  8. operation_id int Functionality Ex: Add, edit delete
  9. table_id int Pk of the table getting affected (worst case to put the data back)
  10. old_data varchar
  11. new_data varchar
  12. created_by int
  13. created_date UNIX timestamp
  14. notification_flag int Does modified notification has to be sent ? (0,1)
Add Comment
Please, Sign In to add comment