CatalogAttributes Table
The CatalogAttributes table contains information about the attributes for a catalog property in the Catalog System. The following table describes the columns in the CatalogAttributes table. The CatalogAttributes table will have additional columns for the attributes that you define for a catalog property.
The following table describes the columns in the CatalogAttributes table.
Column name |
Type |
Allow null |
Description |
|---|---|---|---|
PropertyName |
nvarchar(100) |
no |
The name of the property. This is a primary key. |
DataType |
smallint |
no |
The data type of the property. |
u_DefaultValue |
ntext |
yes |
The default string value for non-multilingual properties. |
i_DefaultValue |
bigint |
yes |
The default value for properties of the Integer and BigInteger data types. |
dt_DefaultValue |
datetime |
yes |
The default value for properties of the DateTime data type. |
cy_DefaultValue |
money |
yes |
The default value for properties of the Currency data type. |
f_DefaultValue |
bit |
yes |
The default value for properties of the Boolean data type. |
fp_DefaultValue |
float |
yes |
The default value for properties of the Float data type. |
i_MinValue |
bigint |
yes |
The minimum value that can be defined for properties of the Integer and BigInteger data type. |
i_MaxValue |
bigint |
yes |
The maximum value that can be defined for properties of the Integer and BigInteger data type. |
dt_MinValue |
datetime |
yes |
The minimum value that can be defined for properties of the Datetime data type. |
dt_MaxValue |
datetime |
yes |
The maximum value that can be defined for properties of the Datetime data type. |
fp_MinValue |
float |
yes |
The minimum value that can be defined for properties of the Float data type. |
fp_MaxValue |
float |
yes |
The maximum value that can be defined for properties of the Float data type. |
IsFreeTextSearchable |
bit |
yes |
Specifies whether the property is free-text searchable. |
IncludeInSpecSearch |
bit |
yes |
Specifies whether the property is included in results that are returned from specification searches. |
MinLength |
int |
yes |
The minimum length of a String data type. |
MaxLength |
int |
yes |
The maximum length of a String data type. |
cy_MinValue |
money |
yes |
The minimum value that can be defined for properties of the Currency data type. |
cy_MaxValue |
money |
yes |
The maximum value that can be defined for properties of the Currency data type. |
TimeStamp |
timestamp |
no |
The timestamp on the property. |
DisplayOnSite |
bit |
yes |
Specifies whether this property should be displayed on the Web site. |
DisplayName |
ntext |
yes |
The display name of the property. |
AssignAll |
bit |
yes |
Specifies whether this property should automatically be applied to all product definitions. |
ExportToDW |
bit |
yes |
Specifies whether this property should be exported to the Data Warehouse. |
DisplayInProductsList |
bit |
yes |
Specifies whether this product is displayed in the products list. |
LanguageSensitive |
bit |
no |
Specifies if this property is language-sensitive. |
IsRequired |
bit |
no |
Specifies is this property is required. |
Currency |
nvarchar(10) |
yes |
The currency to use. |
BuiltIn |
bit |
no |
Specifies whether this is a built-in property. |
DisplayAsBase |
bit |
no |
Specifies whether this property should appear in the Base Properties tab in the Catalog Manager. |
DisplayName_de-DE |
nvarchar(128) |
yes |
The language-sensitive display name. |
u_DefaultValue_de-DE |
ntext |
yes |
The language-sensitive default value for properties of the String type. .gif "Note") Note:
This table will contain a similar column for each language that you add.
|
DisplayName_en-US |
nvarchar(128) |
yes |
The language-sensitive display name. Note:
This table will contain a similar column for each language that you add.
|
u_DefaultValue_ en-US |
ntext |
yes |
The language-sensitive default value for properties of the String type. |
DisplayName_fr-FR |
nvarchar(128) |
yes |
The language-sensitive display name. |
u_DefaultValue_ fr-FR |
ntext |
yes |
The language-sensitive default value for properties of the String type. |
DisplayName_ja-JP |
nvarchar(128) |
yes |
The language-sensitive display name. |
u_DefaultValue_ ja-JP |
ntext |
yes |
The language-sensitive default value for properties of the String type. |