Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
---|---|---|---|---|---|---|---|---|---|---|---|
erm_counter_log_id | INT | 10 | √ | null |
|
|
primary key |
||||
borrowernumber | INT | 10 | √ | null |
|
|
foreign key to borrowers |
||||
counter_files_id | INT | 10 | √ | null |
|
|
foreign key to erm_counter_files |
||||
usage_data_provider_id | INT | 10 | √ | null |
|
|
foreign key to erm_usage_data_providers |
||||
importdate | TIMESTAMP | 19 | √ | current_timestamp() |
|
|
counter file import date |
||||
filename | VARCHAR | 80 | √ | null |
|
|
name of the counter file |
||||
logdetails | LONGTEXT | 2147483647 | √ | null |
|
|
details from the counter log |