action_logs

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
action_id INT 10 null

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

Indexes

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

Diagram producer might be missing

No diagrams were produced please see application output for any errors