Table: dbo.Custom_Field
["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".
Columns
Name | Type | Constraints | Description
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.

Primary key
Name | Columns | Description
PK_Custom_Field | custom_field_KEY |
Unique constraints
Name | Columns | Description
UK_Custom_Field$custom_field_guid$custom_field_type_KEY | custom_field_guid, custom_field_type_KEY |
UK_Custom_Field$owner_table_name$description_stripped$staff_type_KEY | owner_table_name, description_stripped, staff_type_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Custom_Field__Custom_Field_Type__custom_field_type_KEY | custom_field_type_KEY | Custom_Field_Type (custom_field_type_KEY) |
FK_Custom_Field__Staff_Type__staff_type_KEY | staff_type_KEY | Staff_Type (staff_type_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Custom_Grouping__Custom_Field__custom_field_KEY | custom_field_KEY | Custom_Grouping |
FK_Custom_Value__Custom_Field__custom_field_KEY | custom_field_KEY | Custom_Value |
FK_Payroll_Tracking_Portlet_Column_Screen_Option__Custom_Field__custom_field_KEY | custom_field_KEY | Payroll_Tracking_Portlet_Column_Screen_Option |