Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 PARTID uniqueidentifier   The BBNC part id instance
 HELPID int   Default = 0 The id that is passed to the help file
 HELPIDDESCRIPTION nvarchar(255)   Default = '' Label to describe the specific HELPID's functionality
 HELPSTATUSCODE tinyint   Default = 0 Marks the help item as off, default or custom
 HELPSTATUS nvarchar(7) (Computed) CASE [HELPSTATUSCODE] WHEN 0 THEN N'Off' WHEN 1 THEN N'Default' WHEN 2 THEN N'Custom' END Provides a translation for the 'HELPSTATUSCODE' field.
 CUSTOMHELPURL nvarchar(255)   Default = '' URL to a custom help file
 CUSTOMTOOLTIP nvarchar(255)   Default = '' Tool tip for the help button
 DATEADDED datetime   Default = getdate() Indicates the date this record was added.
 DATECHANGED datetime   Default = getdate() Indicates the date this record was last changed.
 TS timestamp   Timestamp.
 TSLONG bigint (Computed) CONVERT(bigint, TS) Numeric representation of the timestamp.

Foreign Key Field Type Null Notes Description
 CONTENTTYPESID int   ContentTypes.ID BBNC ContentTypes table id; used as the part type id
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.

Index Name Field(s) Unique Primary Clustered
 IX_FAFHELPCONFIG_DATEADDED DATEADDED    
 IX_FAFHELPCONFIG_DATECHANGED DATECHANGED      
 PK_FAFHELPCONFIG ID  
 UIX_FAFHELPCONFIG_PARTID_CONTENTTYPESID_HELPID PARTID, CONTENTTYPESID, HELPID    

Trigger Name Description
 TR_FAFHELPCONFIG_AUDIT_UPDATE
 TR_FAFHELPCONFIG_AUDIT_DELETE