metrics_counter_submission_monthly

0 rows


Description

Monthly statistics matching the COUNTER R5 protocol for views and downloads of published submissions and galleys.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
context_id int8 19 null
servers.server_id msm_context_id_foreignC
submission_id int8 19 null
submissions.submission_id msm_submission_id_foreignC
month int4 10 null
metric_investigations int4 10 null
metric_investigations_unique int4 10 null
metric_requests int4 10 null
metric_requests_unique int4 10 null

Indexes

Constraint Name Type Sort Column(s)
metrics_counter_submission_monthly_context_id Performance Asc context_id
metrics_counter_submission_monthly_submission_id Performance Asc submission_id
msm_context_id_submission_id Performance Asc/Asc context_id + submission_id
msm_uc_context_id_submission_id_month Must be unique Asc/Asc/Asc context_id + submission_id + month

Relationships