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".
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 |