cash_register_actions


Columns

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

unique identifier for each account register action

code VARCHAR 24 null

action code denoting the type of action recorded (enum),

register_id INT 10 null
cash_registers.id cash_register_actions_register C

id of cash_register this action belongs to,

manager_id INT 10 null
borrowers.borrowernumber cash_register_actions_manager C

staff member performing the action

amount DECIMAL 28,6 null

amount recorded in action (signed)

timestamp TIMESTAMP 19 current_timestamp()

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
cash_register_actions_manager Performance Asc manager_id
cash_register_actions_register Performance Asc register_id

Relationships