Table testsql_comments.action_logs Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
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 mediumtext 16777215  √  null the module this action was taken against
action mediumtext 16777215  √  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 mediumtext 16777215  √  null information about the action (usually includes SQL statement)
interface varchar 30  √  null the context this action was taken in

Table contained 0 rows at Mon Jul 16 08:37 NZST 2018

Indexes:
Column(s) Type Sort Constraint Name
action_id Primary key Asc PRIMARY
action Performance Asc action_idx
info Performance Asc info_idx
interface Performance Asc interface
module Performance Asc module_idx
object Performance Asc object_idx
timestamp Performance Asc timestamp_idx
user Performance Asc user_idx