metrics_counter_submission_institution_monthly


Description

Monthly statistics matching the COUNTER R5 protocol for views and downloads from institutions.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
metrics_counter_submission_institution_monthly_id BIGINT UNSIGNED 20 √ null
context_id BIGINT 19 null
journals.journal_id msim_context_id_foreignC
submission_id BIGINT 19 null
submissions.submission_id msim_submission_id_foreignC
institution_id BIGINT 19 null
institutions.institution_id msim_institution_id_foreignC
month INT 10 null
metric_investigations INT 10 null
metric_investigations_unique INT 10 null
metric_requests INT 10 null
metric_requests_unique INT 10 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc metrics_counter_submission_institution_monthly_id
metrics_counter_submission_institution_monthly_context_id Performance Asc context_id
metrics_counter_submission_institution_monthly_institution_id Performance Asc institution_id
metrics_counter_submission_institution_monthly_submission_id Performance Asc submission_id
msim_context_id_submission_id Performance Asc/Asc context_id + submission_id
msim_uc_context_id_submission_id_institution_id_month Must be unique Asc/Asc/Asc/Asc context_id + submission_id + institution_id + month

Relationships

Close relationships within degrees of separation