Rack Database Structure: Comments table

This table holds comments on the rest of the database. Comments can be associated with any object in the database, so tables don't need specific columns for comments.

A comment is associated with a row in some table by giving the table name, the field it's associated with and the value. For a comment on a specific rack, the table would be "racks", the field "idx" and the value "27" if the rack has idx=27. For a constraint comment, the table would be "constraints", the field "name" and the value "HRFs Together".

Fields
idx integer Unique identifier. This is the only field guaranteed to be unique.
tblname string The name of the table containing the row this is a comment for.
indexfield string the field used to look up the row this is a comment for.
value string the value the index field should have. Surrounding quotes aren't needed.
author string the author of this comment
comment string the text of the comment