erm_counter_files

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
erm_counter_files_id INT 10 √ null
erm_counter_logs.counter_files_id erm_counter_log_ibfk_2 C

primary key
usage_data_provider_id INT 10 √ NULL
erm_usage_data_providers.erm_usage_data_provider_id erm_counter_files_ibfk_1 C

foreign key to erm_usage_data_providers
type VARCHAR 80 √ NULL

type of counter file
filename VARCHAR 80 √ NULL

name of the counter file
file_content LONGBLOB 2147483647 √ NULL

content of the counter file
date_uploaded TIMESTAMP 19 √ current_timestamp()

counter file upload date

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc erm_counter_files_id
erm_counter_files_ibfk_1 Performance Asc usage_data_provider_id

Relationships

Close relationships within degrees of separation