Table audit_log

Table audit_log keeps a historical trail of the actions performed in PhreeBooks. All major events are tracked from logging in, order posting, inentory item editing, etc.

Table Type: InnoDB

Field Type Default Description
id auto_increment N/A PRIMARY KEY - unique id assigned to each log entry
action_datetimestampTimestamp of the audit log entry
user_idint (11)0Specifies the user id of the action. Links to the table 'users'.
reference_idvarchar (32)NULLINDEX
actionvarchar (64)NULLspecifies the action added to the log. Content varies depending on what functions was performed.
amountfloat0Specifies 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.