Table report_fields

Table report_fields holds the field details for the reports/forms displayed in PhreeBooks. The fields are coded by entrytype to inidicate the type of entry it is. A single report will contain one field in table reports and several in report_fields.

Table Type: InnoDB

Field Type Default Description
id int (11) NOT NULL PRIMARY KEY - Auto increment field to hold unique ID
reportid int(5) 0 Link to the report ID this field is a part of.
entrytype varchar(15) NOT NULL

Defines the tpye of field. Types include:

datafield: Hold the data field information used in reports and forms. One or moer entries are required per report/form.
critfield: Holds the critereia used to filter reports and forms. Zero or more entries are permitted.
datefield: Holds the possible date portion of the criteria. Only one entry is permitted per report/form.
sortfield: Associated with the sort portion of criteria. Zero or more are permitted.

seqnum seqnum(3) 0 The sequence number of the field. Used for ordering the fields. This value determines the display order in preparation of the output for reports but is only used to display the order of the fields in Reportbuilder for forms since fields are placed individually on a form.
fieldname fieldname(255) NOT NULL The name of the field as related to the databases used to generate the report/form. An equation can be entered here to generate more complicated report outputs.
displaydesc varchar(25) NOT NULL This field hold the textual desxcription of the field. The value entered here will be displayed in the header of reports but is only used for field setup in Reportbuilder for forms.
visible 0, 1 1 Indicates whether the field will be displayed on the report or form.
columnbreak 0, 1 1 Indicates whether the field will cause a column break after being displayed. If not set, the next field to display will be shown below this field. Column widths will default to the largest column displayed of all fields in a given column
params text NULL This is an encoded (serialized) string of parameters used to further identify the field. Form fields contain significant information related to the font, color, position, etc. The field is freeform in that there are no criteria regarding the contents.