daily pastebin goal


a guest Sep 14th, 2018 59 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  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)
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand