erm_usage_titles

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
title_id INT 10 √ null
erm_usage_mus.title_id erm_usage_mus_ibfk_1 C
erm_usage_yus.title_id erm_usage_yus_ibfk_1 C

primary key
title MEDIUMTEXT 16777215 √ null

item title
usage_data_provider_id INT 10 null
erm_usage_data_providers.erm_usage_data_provider_id erm_usage_titles_ibfk_1 C

platform the title is harvested by
title_doi VARCHAR 255 √ null

DOI number for the title
proprietary_id VARCHAR 255 √ null

Proprietary_ID for the title
platform VARCHAR 255 √ null

platform for the title
print_issn VARCHAR 255 √ null

Print ISSN number for the title
online_issn VARCHAR 255 √ null

Online ISSN number for the title
title_uri VARCHAR 255 √ null

URI number for the title
publisher VARCHAR 255 √ null

Publisher for the title
publisher_id VARCHAR 255 √ null

Publisher ID for the title
isbn VARCHAR 255 √ null

ISBN of the title

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc title_id
erm_usage_titles_ibfk_1 Performance Asc usage_data_provider_id

Relationships

Close relationships within degrees of separation