| id |
INT |
10 |
|
√ |
null |
|
|
unique identifier for each offset |
| credit_id |
INT |
10 |
√ |
|
null |
|
|
The id of the accountline the increased the patron’s balance |
| debit_id |
INT |
10 |
√ |
|
null |
|
|
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 |
|
|
|
