metrics_counter_submission_daily

0 rows


Description

Daily statistics matching the COUNTER R5 protocol for views and downloads of published submissions and files.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
load_id varchar 255 null
job_batches.id Implied ConstraintR
context_id int8 19 null
presses.press_id msd_context_id_foreignC
submission_id int8 19 null
submissions.submission_id msd_submission_id_foreignC
date date 13 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

Indexes

Constraint Name Type Sort Column(s)
metrics_counter_submission_daily_context_id Performance Asc context_id
metrics_counter_submission_daily_submission_id Performance Asc submission_id
msd_context_id_submission_id Performance Asc/Asc context_id + submission_id
msd_load_id Performance Asc load_id
msd_uc_load_id_context_id_submission_id_date Must be unique Asc/Asc/Asc/Asc load_id + context_id + submission_id + date

Relationships