Rack Database Structure: Sums table

This table records all the data for user-added resources, or straight-sum fields. These fields reference resources in the racks table, total up the usage for each combination, and compare it to a limit value in the runs table.

Some fields in this table are reserved for future use, and not currently used.

Fields
name string A unique name given to this resource
inputfield string The name of the field in the racks table that is to be totaled
inputtable string Reserved for future use.
limitfield string The name of the field in the runs table to compare the total to.
limittable string Reserved for future use.
outputfield string The name of the fields in the output table to create, ex. "foo" creates "foo_ttl" and "foo_xcd" to record total value and whether exceeded.
increment boolean Whether this field appears on the increment graph.
simultaneous boolean Whether this field appears on the simultaneous graph.
red number The value, between 0 and 1, of red in the line color on the graph.
green number The value, between 0 and 1, of green in the line color on the graph.
blue number The value, between 0 and 1, of blue in the line color on the graph.
symbol string The name of the glyph for this resource on the graph, must be a value in the glyphnames table.