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
NameTypeConstraintsDescription
custom_field_KEYint (4)NOT NULLDatabase assigned primary key for this table.
owner_table_namenvarchar (256)NOT NULLName of the table that this custom field is associated with.
descriptionnvarchar (100)NOT NULLThe 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_KEYint (4)NOT NULLForiegn key to specify what data type this column is.
lengthint (4)NOT NULLLength of character columns, precision of number columns, storage length of other types.
sortint (4)NOT NULLSort order of this custom field when it is displayed. The fields should be sorted by position and description.
description_strippednvarchar (100)
staff_type_KEYint (4)The Staff_Type this Custom_Field applies to, or null if owner_table_name isn't Staff.
custom_field_guiduniqueidentifier (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
NameColumnsDescription
PK_Custom_Fieldcustom_field_KEY
Unique constraints
NameColumnsDescription
UK_Custom_Field$custom_field_guid$custom_field_type_KEYcustom_field_guid, custom_field_type_KEY
UK_Custom_Field$owner_table_name$description_stripped$staff_type_KEYowner_table_name, description_stripped, staff_type_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Custom_Field__Custom_Field_Type__custom_field_type_KEYcustom_field_type_KEYCustom_Field_Type (custom_field_type_KEY)
FK_Custom_Field__Staff_Type__staff_type_KEYstaff_type_KEYStaff_Type (staff_type_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Custom_Grouping__Custom_Field__custom_field_KEYcustom_field_KEYCustom_Grouping
FK_Custom_Value__Custom_Field__custom_field_KEYcustom_field_KEYCustom_Value
FK_Payroll_Tracking_Portlet_Column_Screen_Option__Custom_Field__custom_field_KEYcustom_field_KEYPayroll_Tracking_Portlet_Column_Screen_Option

Schema diagram