map_version_reviews_summary

1034 rows


Description

Summary of all map version reviews. Entries are created and updated by triggers.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 null
map_version_id MEDIUMINT UNSIGNED 8 null
map_version.id map_version_reviews_summary_map_version R
positive FLOAT 12 null

The ‘positive’ share of the rating

negative FLOAT 12 null

The ‘negative’ share of the rating

score FLOAT 12 null

The sum of all scores

reviews INT 10 null

The sum of all ‘negative’ and ‘positive’ shares. Equals to the number of reviews.

lower_bound FLOAT 12 null

Lower bound of Wilson score confidence interval for a Bernoulli parameter

average_score FLOAT 12 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
map_version_id Must be unique Asc map_version_id
map_version_rev_sum_avg_score_ix Performance Asc average_score

Relationships