metrics_submission


Description

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

Columns

Column Type Size Nulls Auto Default Children Parents Comments
metrics_submission_id BIGINT UNSIGNED 20 √ null
load_id VARCHAR 255 null
job_batches.id Implied ConstraintR
context_id BIGINT 19 null
presses.press_id metrics_submission_context_id_foreignC
submission_id BIGINT 19 null
submissions.submission_id metrics_submission_submission_id_foreignC
chapter_id BIGINT 19 √ NULL
submission_chapters.chapter_id metrics_submission_chapter_id_foreignC
representation_id BIGINT 19 √ NULL
publication_formats.publication_format_id metrics_submission_representation_id_foreignC
submission_file_id BIGINT UNSIGNED 20 √ NULL
submission_files.submission_file_id metrics_submission_submission_file_id_foreignC
file_type BIGINT 19 √ NULL
assoc_type BIGINT 19 null
date DATE 10 null
metric INT 10 null

Indexes

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