0 rows


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


Column Type Size Nulls Auto Default Children Parents Comments
load_id varchar 255 null Implied ConstraintR
context_id int8 19 null
servers.server_id msid_context_id_foreignC
submission_id int8 19 null
submissions.submission_id msid_submission_id_foreignC
institution_id int8 19 null
institutions.institution_id msid_institution_id_foreignC
date date 13 null
metric_investigations int4 10 null
metric_investigations_unique int4 10 null
metric_requests int4 10 null
metric_requests_unique int4 10 null


Constraint Name Type Sort Column(s)
msid_context_id Performance Asc context_id
msid_context_id_submission_id Performance Asc/Asc context_id + submission_id
msid_institution_id Performance Asc institution_id
msid_load_id Performance Asc load_id
msid_submission_id Performance Asc submission_id
msid_uc_load_id_context_id_submission_id_institution_id_date Must be unique Asc/Asc/Asc/Asc/Asc load_id + context_id + submission_id + institution_id + date