Field |
Type |
Default |
Description |
id |
auto_increment |
N/A |
PRIMARY KEY - unique id assigned to each log entry |
action_date | timestamp | | Timestamp of the audit log entry |
user_id | int (11) | 0 | Specifies the user id of the action. Links to the table 'users'. |
reference_id | varchar (32) | NULL | INDEX |
action | varchar (64) | NULL | specifies the action added to the log. Content varies depending on what functions was performed. |
amount | float | 0 | Specifies
the amount of the transaction. Will be 0 if the action did not involve
an amount, i.e. logging in, updating an inventory item, etc. |