["BR"]Defines custom fields, allowing users to attach custom data to various business objects["BR"]without altering schema. The kind of business object being extended is identified by["BR"]the "owner_table_name". |
custom_field_KEY | int (4) | NOT NULL | Database assigned primary key for this table. |
owner_table_name | nvarchar (256) | NOT NULL | Name of the table that this custom field is associated with. |
description | nvarchar (100) | NOT NULL | The description of this custom field as it would appear in the user interface. The same description can only be used once per source_table. |
custom_field_type_KEY | int (4) | NOT NULL | Foriegn key to specify what data type this column is. |
length | int (4) | NOT NULL | Length of character columns, precision of number columns, storage length of other types. |
sort | int (4) | NOT NULL | Sort order of this custom field when it is displayed. The fields should be sorted by position and description. |
description_stripped | nvarchar (100) | | |
staff_type_KEY | int (4) | | The Staff_Type this Custom_Field applies to, or null if owner_table_name isn't Staff. |
custom_field_guid | uniqueidentifier (16) | NOT NULL | ["BR"]Together with the custom_field_type_KEY value, this uniquely identifies a definition. ["BR"]Allowing duplicate GUIDs discriminated by type is unusual, but facilitates correct behavior["BR"]when restoring client backups in cases where a custom field's type has been changed. |