0 rows


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


Column Type Size Nulls Auto Default Children Parents Comments
context_id int8 19 null
presses.press_id msim_context_id_foreignC
submission_id int8 19 null
submissions.submission_id msim_submission_id_foreignC
institution_id int8 19 null
institutions.institution_id msim_institution_id_foreignC
month int4 10 null
metric_book_investigations int4 10 null
metric_book_investigations_unique int4 10 null
metric_book_requests int4 10 null
metric_book_requests_unique int4 10 null
metric_chapter_investigations int4 10 null
metric_chapter_investigations_unique int4 10 null
metric_chapter_requests int4 10 null
metric_chapter_requests_unique int4 10 null
metric_title_investigations_unique int4 10 null
metric_title_requests_unique int4 10 null


Constraint Name Type Sort Column(s)
msim_context_id Performance Asc context_id
msim_context_id_submission_id Performance Asc/Asc context_id + submission_id
msim_institution_id Performance Asc institution_id
msim_submission_id Performance Asc 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