erm_usage_yus

0 rows


Columns

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

primary key
title_id INT 10 √ NULL
erm_usage_titles.title_id erm_usage_yus_ibfk_1 C

item title id number
platform_id INT 10 √ NULL
erm_usage_platforms.platform_id erm_usage_yus_ibfk_3 C

platform id number
database_id INT 10 √ NULL
erm_usage_databases.database_id erm_usage_yus_ibfk_4 C

database id number
item_id INT 10 √ NULL
erm_usage_items.item_id erm_usage_yus_ibfk_5 C

item id number
usage_data_provider_id INT 10 √ NULL
erm_usage_data_providers.erm_usage_data_provider_id erm_usage_yus_ibfk_2 C

item title id number
year INT 10 √ NULL

year of usage statistics
totalcount INT 10 √ NULL

usage count for the title
metric_type VARCHAR 50 √ NULL

metric type for the usage statistic
access_type VARCHAR 50 √ NULL

access type for the usage statistic
yop VARCHAR 255 √ NULL

year of publication for the usage statistic
report_type VARCHAR 50 √ NULL

report type for the usage statistic

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc yearly_usage_summary_id
erm_usage_yus_ibfk_1 Performance Asc title_id
erm_usage_yus_ibfk_2 Performance Asc usage_data_provider_id
erm_usage_yus_ibfk_3 Performance Asc platform_id
erm_usage_yus_ibfk_4 Performance Asc database_id
erm_usage_yus_ibfk_5 Performance Asc item_id

Relationships

Close relationships within degrees of separation