erm_counter_logs

0 rows


Columns

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

primary key
borrowernumber INT 10 √ NULL
borrowers.borrowernumber erm_counter_log_ibfk_1 C

foreign key to borrowers
counter_files_id INT 10 √ NULL
erm_counter_files.erm_counter_files_id erm_counter_log_ibfk_2 C

foreign key to erm_counter_files
usage_data_provider_id INT 10 √ NULL
erm_usage_data_providers.erm_usage_data_provider_id erm_counter_log_ibfk_3 C

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

Indexes

Constraint Name Type Sort Column(s)
erm_counter_logs_s_pk Primary key Asc erm_counter_log_id
erm_counter_log_ibfk_1 Performance Asc borrowernumber
erm_counter_log_ibfk_2 Performance Asc counter_files_id
erm_counter_log_ibfk_3 Performance Asc usage_data_provider_id
PRIMARY Must be unique Asc erm_counter_log_id

Relationships

Close relationships within degrees of separation