usage_stats_total_temporary_records


Description

Temporary stats totals based on visitor log records. Data in this table is provisional. See the metrics_* tables for compiled stats.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
usage_stats_temp_total_id BIGINT UNSIGNED 20 √ null
date DATETIME 19 null
ip VARCHAR 255 null
user_agent VARCHAR 255 null
line_number BIGINT 19 null
canonical_url VARCHAR 255 null
issue_id BIGINT 19 √ NULL
issues.issue_id ust_issue_id_foreignC
issue_galley_id BIGINT 19 √ NULL
issue_galleys.galley_id ust_issue_galley_id_foreignC
context_id BIGINT 19 null
journals.journal_id ust_context_id_foreignC
submission_id BIGINT 19 √ NULL
submissions.submission_id ust_submission_id_foreignC
representation_id BIGINT 19 √ NULL
publication_galleys.galley_id ust_representation_id_foreignC
submission_file_id BIGINT UNSIGNED 20 √ NULL
submission_files.submission_file_id ust_submission_file_id_foreignC
assoc_type BIGINT 19 null
file_type SMALLINT 5 √ NULL
country VARCHAR 2 ''
region VARCHAR 3 ''
city VARCHAR 255 ''
load_id VARCHAR 255 null
job_batches.id Implied ConstraintR

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc usage_stats_temp_total_id
usage_stats_total_temporary_records_context_id Performance Asc context_id
usage_stats_total_temporary_records_issue_galley_id Performance Asc issue_galley_id
usage_stats_total_temporary_records_issue_id Performance Asc issue_id
usage_stats_total_temporary_records_representation_id Performance Asc representation_id
usage_stats_total_temporary_records_submission_file_id Performance Asc submission_file_id
usage_stats_total_temporary_records_submission_id Performance Asc submission_id

Relationships

Close relationships within degrees of separation