usage_stats_institution_temporary_records


Description

Temporary stats for views and downloads from institutions 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_institution_id BIGINT UNSIGNED 20 √ null
load_id VARCHAR 255 null
job_batches.id Implied ConstraintR
line_number BIGINT 19 null
institution_id BIGINT 19 null
institutions.institution_id usi_institution_id_foreignC

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc usage_stats_temp_institution_id
usi_institution_id Performance Asc institution_id
usitr_load_id_line_number_institution_id Must be unique Asc/Asc/Asc load_id + line_number + institution_id

Relationships

Close relationships within degrees of separation