| 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 |
VARCHAR |
16 |
|
|
null |
|
|
The type of offset this is |
| amount |
DECIMAL |
26,6 |
|
|
null |
|
|
The amount of the change |
| created_on |
TIMESTAMP |
19 |
|
|
current_timestamp() |
|
|
|
