metrics_submission

0 rows


Description

Daily statistics for views and downloads of published submissions and galleys.

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
servers.server_id metrics_submission_context_id_foreignC
submission_id int8 19 null
submissions.submission_id metrics_submission_submission_id_foreignC
representation_id int8 19 √ null
publication_galleys.galley_id metrics_submission_representation_id_foreignC
submission_file_id int8 19 √ null
submission_files.submission_file_id metrics_submission_submission_file_id_foreignC
file_type int8 19 √ null
assoc_type int8 19 null
date date 13 null
metric int4 10 null

Indexes

Constraint Name Type Sort Column(s)
metrics_submission_context_id Performance Asc context_id
metrics_submission_representation_id Performance Asc representation_id
metrics_submission_submission_file_id Performance Asc submission_file_id
metrics_submission_submission_id Performance Asc submission_id
ms_context_id_submission_id_assoc_type_file_type Performance Asc/Asc/Asc/Asc context_id + submission_id + assoc_type + file_type
ms_load_id Performance Asc load_id

Relationships

Close relationships within degrees of separation