account_offsets

0 rows


Columns

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

unique identifier for each offset

credit_id INT 10 null
accountlines.accountlines_id account_offsets_ibfk_pC

The id of the accountline the increased the patron’s balance

debit_id INT 10 null
accountlines.accountlines_id account_offsets_ibfk_fC

The id of the accountline that decreased the patron’s balance

type enum('CREATE', 'APPLY', 'VOID', 'OVERDUE_INCREASE', 'OVERDUE_DECREASE') 16 null

The type of offset this is

amount DECIMAL 26,6 null

The amount of the change

created_on TIMESTAMP 19 CURRENT_TIMESTAMP

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
account_offsets_ibfk_f Performance Asc debit_id
account_offsets_ibfk_p Performance Asc credit_id

Relationships