usage_stats_total_temporary_records

0 rows


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
date timestamp 22 null
ip varchar 255 null
user_agent varchar 255 null
line_number int8 19 null
canonical_url varchar 255 null
series_id int8 19 √ null
series.series_id ust_series_id_foreignC
context_id int8 19 null
presses.press_id ust_context_id_foreignC
submission_id int8 19 √ null
submissions.submission_id ust_submission_id_foreignC
chapter_id int8 19 √ null
submission_chapters.chapter_id ust_chapter_id_foreignC
representation_id int8 19 √ null
publication_formats.publication_format_id ust_representation_id_foreignC
submission_file_id int8 19 √ null
submission_files.submission_file_id ust_submission_file_id_foreignC
assoc_type int8 19 null
file_type int2 5 √ null
country varchar 2 ''::character varying
region varchar 3 ''::character varying
city varchar 255 ''::character varying
load_id varchar 255 null
job_batches.id Implied ConstraintR

Indexes

Constraint Name Type Sort Column(s)
ust_chapter_id Performance Asc chapter_id
ust_context_id Performance Asc context_id
ust_representation_id Performance Asc representation_id
ust_series_id Performance Asc series_id
ust_submission_file_id Performance Asc submission_file_id
ust_submission_id Performance Asc submission_id

Relationships

Close relationships within degrees of separation