Hierarchy of tables
Scoring is completed at the rule level and summed to each level above. This allows for the score at each level to be obtained directly from the database, rather than recalculated.
Hierarchy
→ conversation
→ category
→ top level
→ rule