Table 4: scoring conversation_rule_score

The purpose of this table is to hold the calculated score of each rule

Field	Type	Description

Field	Type	Description
id	integer	id that can be used to join with the other tables in the scoring schema
filename	string	name of the call recording file
dimension_rule_id	integer	foreign key to the table ‘dimension_rule’
score	double	the score of the rule
hit_type_enum	char	Two options Found: Where the points are assumed as ‘found’ and then removed if evidence is detected Absent: Where the points are assumed as ‘absent’ and only given if evidence is detected
hits	double	the number of times the rule was found to be true
hit_requirements	double	the number of times the rule must be hit for it to be considered true
red_flag	boolean	if finding this rule as true should be considered a ‘red flag’ i.e. of extreme importance
weight	double	the weight of this rule
is_hit	boolean	whether the rule was calculated as ‘hit’
conversation_toplevel_score_id	integer	foreign key to the table ‘conversation_toplevel_score'
created_datetime	datetime	when the record was inserted
updated_datetime	datetime	when the record was updated