erm_usage_data_providers

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
erm_usage_data_provider_id INT 10 √ null
erm_counter_files.usage_data_provider_id erm_counter_files_ibfk_1 C
erm_counter_logs.usage_data_provider_id erm_counter_log_ibfk_3 C
erm_usage_databases.usage_data_provider_id erm_usage_databases_ibfk_1 C
erm_usage_items.usage_data_provider_id erm_usage_items_ibfk_1 C
erm_usage_mus.usage_data_provider_id erm_usage_mus_ibfk_2 C
erm_usage_platforms.usage_data_provider_id erm_usage_platforms_ibfk_1 C
erm_usage_titles.usage_data_provider_id erm_usage_titles_ibfk_1 C
erm_usage_yus.usage_data_provider_id erm_usage_yus_ibfk_2 C

primary key
name VARCHAR 80 null

name of the data provider
description LONGTEXT 2147483647 √ null

description of the data provider
active BIT 0 1

current status of the harvester - active/inactive
method VARCHAR 80 √ null

method of the harvester
aggregator VARCHAR 80 √ null

aggregator of the harvester
service_type VARCHAR 80 √ null

service_type of the harvester
service_url VARCHAR 80 √ null

service_url of the harvester
report_release VARCHAR 80 √ null

report_release of the harvester
customer_id VARCHAR 50 √ null

sushi customer id
requestor_id VARCHAR 50 √ null

sushi requestor id
api_key VARCHAR 80 √ null

sushi api key
requestor_name VARCHAR 80 √ null

requestor name
requestor_email VARCHAR 80 √ null

requestor email
report_types VARCHAR 255 √ null

report types provided by the harvester
service_platform VARCHAR 80 √ null

platform if provider requires it

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc erm_usage_data_provider_id

Relationships

Close relationships within degrees of separation