metrics_issue


Description

Daily statistics for views and downloads of published issues.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
metrics_issue_id BIGINT UNSIGNED 20 √ null
load_id VARCHAR 255 null
job_batches.id Implied ConstraintR
context_id BIGINT 19 null
journals.journal_id metrics_issue_context_id_foreignC
issue_id BIGINT 19 null
issues.issue_id metrics_issue_issue_id_foreignC
issue_galley_id BIGINT 19 √ NULL
issue_galleys.galley_id metrics_issue_issue_galley_id_foreignC
date DATE 10 null
metric INT 10 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc metrics_issue_id
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