metrics_submission_geo_monthly


Description

Monthly statistics by country, region and city for views and downloads of published submissions and galleys.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
metrics_submission_geo_monthly_id BIGINT UNSIGNED 20 √ null
context_id BIGINT 19 null
journals.journal_id msgm_context_id_foreignC
submission_id BIGINT 19 null
submissions.submission_id msgm_submission_id_foreignC
country VARCHAR 2 ''
region VARCHAR 3 ''
city VARCHAR 255 ''
month INT 10 null
metric INT 10 null
metric_unique INT 10 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc metrics_submission_geo_monthly_id
metrics_submission_geo_monthly_context_id Performance Asc context_id
metrics_submission_geo_monthly_submission_id Performance Asc submission_id
msgm_context_id_submission_id Performance Asc/Asc context_id + submission_id
msgm_uc_context_submission_c_r_c_month Must be unique Asc/Asc/Asc/Asc/Asc/Asc context_id + submission_id + country + region + city + month

Relationships

Close relationships within degrees of separation