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

Close relationships within degrees of separation