metrics_issue

0 rows


Description

Daily statistics for views and downloads of published issues.

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
journals.journal_id metrics_issue_context_id_foreignC
issue_id int8 19 null
issues.issue_id metrics_issue_issue_id_foreignC
issue_galley_id int8 19 √ null
issue_galleys.galley_id metrics_issue_issue_galley_id_foreignC
date date 13 null
metric int4 10 null

Indexes

Constraint Name Type Sort Column(s)
metrics_issue_context_id Performance Asc context_id
metrics_issue_context_id_issue_id Performance Asc/Asc context_id + issue_id
metrics_issue_issue_galley_id Performance Asc issue_galley_id
metrics_issue_issue_id Performance Asc issue_id
metrics_issue_load_id Performance Asc load_id

Relationships

Close relationships within degrees of separation