LANGUAGE_RESOURCES

Holds culture-specific text values used throughout BBNC

Primary Key

Primary Key Field Type
ID uniqueidentifier

Fields

Field Field Type Null Notes Description
CULTURECODE nvarchar(10) Default = '' The culture code (e.g. 'en-US') for this resource.
RESOURCETYPE nvarchar(255) Default = '' The path of the control this field is on, or null if it does not map to a control.
RESOURCEKEY nvarchar(255) Default = '' A unique identifier per CULTURECODE-RESOURCETYPE pair to retrieve the text value, such as 'SubmitButton.Text', if it's for a specific control.
RESOURCEGUID uniqueidentifier yes A GUID to identify the resource. Only used for values not tied to a control.
RESOURCEVALUE nvarchar(1024) Default = '' The default text value for this resource in this culture, such as 'Submit' or 'The email address you specified is invalid.'
CATEGORY nvarchar(255) Default = '' The category the field belongs to, for Language Tab purposes

Indexes

Index Name Fields Unique Primary Clustered
PK_LANGUAGE_RESOURCES ID yes yes yes
UIX_LANGUAGE_RESOURCES_CULTURECODE_RESOURCETYPE_RESOURCEKEY CULTURECODE, RESOURCETYPE, RESOURCEKEY yes

Referenced by

Referenced by Field
LANGUAGE_RESOURCES_OVERRIDES LANGUAGERESOURCEGUID