Table testsql_comments.action_logs Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
action_id int 10  √  unique identifier for each action
timestamp timestamp 19 CURRENT_TIMESTAMP the date and time the action took place
user int 10 0 the staff member who performed the action (borrowers.borrowernumber)
module text 65535  √  null the module this action was taken against
action text 65535  √  null the action (includes things like DELETED, ADDED, MODIFY, etc)
object int 10  √  null the object that the action was taken against (could be a borrowernumber, itemnumber, etc)
info text 65535  √  null information about the action (usually includes SQL statement)

Table contained 0 rows at Tue Dec 27 18:01 NZDT 2016

Indexes:
Column(s) Type Sort
action_id Primary key Asc
action Performance Asc
info Performance Asc
module Performance Asc
object Performance Asc
timestamp Performance Asc
user Performance Asc