metrics_series


Description

Daily statistics for views of published submissions in each series.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
metrics_series_id BIGINT UNSIGNED 20 √ null
load_id VARCHAR 255 null
job_batches.id Implied ConstraintR
context_id BIGINT 19 null
presses.press_id metrics_series_context_id_foreignC
series_id BIGINT 19 null
series.series_id metrics_series_series_id_foreignC
date DATE 10 null
metric INT 10 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc metrics_series_id
metrics_series_context_id Performance Asc context_id
metrics_series_context_id_series_id Performance Asc/Asc context_id + series_id
metrics_series_load_id Performance Asc load_id
metrics_series_series_id Performance Asc series_id

Relationships

Close relationships within degrees of separation