# 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