comment table needs unique key

[lsloan]

Problem

The number of rows in the comment table grows with each execution because the auto-incrementing id column is the primary key. The other columns that could possibly function as a primary key, assessment_id and criterion_id are not required to be unique.

Solution

Change the primary key from being the id column to a compound key of assessment_id and criterion_id.