metrics_submission_geo_monthly

0 rows


Description

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

Columns

Column Type Size Nulls Auto Default Children Parents Comments
context_id int8 19 null
presses.press_id msgm_context_id_foreignC
submission_id int8 19 null
submissions.submission_id msgm_submission_id_foreignC
country varchar 2 ''::character varying
region varchar 3 ''::character varying
city varchar 255 ''::character varying
month int4 10 null
metric int4 10 null
metric_unique int4 10 null

Indexes

Constraint Name Type Sort Column(s)
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