* Id

55

* Owning table (The table to which the field belongs)

Setting

* Name (A code-name for the field)

usereditable

* Display order (A rank determining where the field appears in lists)

* Display level (A category determining what granularity of report the field appears in)

primary   summary   record   detail   never

* Searchability (A category determining what level of searching this field supports)

primary   yes   no

Display order priority (If present, the level at which lists of records are sorted by the field)

Sort Descending (Whether when sorting by this column, the sort order should be reversed)

true false

* Indexed (Whether the field is indexed (ignored if the field is marked `unique'))

false

* Unique (Whether the field is unique (implies that it's `indexed'))

false

Integrity fix (How referential integrity is maintained, what to do when the object referred to is deleted)

delete   clear   prevent

* Display name (A user-friendly name for the field)

Description (A brief description of the field's function)

* Size (For character fields, the maximum number of characters that can be stored, (-1 for unlimited))

0

* Input-box width (A sensible width for text boxes used for entering the field, where appropriate)

* Input-box height (A sensible height for text boxes used for entering the field, where appropriate)

* Precision (Precision (total number of digits) for fixed-point numbers)

22

* Scale (Scale (number of digits after the decimal) for fixed-point numbers)

2

Rendering information (The name of the Melati templet (if not the default) to use for input controls for the field)

More ...