NameDescriptionTypeAdditional information
CategoryID

Primary key. Auto-incremented. database reference = category.id

integer

None.

CategoryName

database reference = category.category_name

string

String length: inclusive between 0 and 150

Link

database reference = category.link

string

String length: inclusive between 0 and 255

CategoryDescription

database reference = category.category_description

string

String length: inclusive between 0 and 65535

CategoryIcon

database reference = category.iconimage

string

String length: inclusive between 0 and 100

CategoryMain

database reference = category.category_main

boolean

None.

CategoryParent

database reference = category.category_parent

integer

None.

Sorting

database reference = category.sorting

integer

None.

Hide

database reference = category.reference

boolean

None.

UserID

database reference = category.userid

string

String length: inclusive between 0 and 50

LastUpdate

database reference = category.last_update

date

None.

CategoryMenuGroup

database reference = category.menu_group

integer

None.

HomeSpecialCategory

database reference = category.homespecial

boolean

None.

FilterCategory

database reference = category.isFilter

boolean

None.

TemplateCategoryPage

database reference = category.category_displaytype

integer

None.

DefaultProductsSorting

database reference = category.category_defaultsorting

integer

None.

SubcategoryColumnsCategorySpecials

database reference = category.category_columnum

integer

None.

ProductColumnsCategorySpecials

database reference = category.special_columnum

integer

None.

ProductColumnsCategoryGeneralItems

database reference = category.columnum

integer

None.

ItemsPerPageCategorySpecialItems

database reference = category.special_numtolist

integer

None.

ItemsPerPageCategoryGeneralItems

database reference = category.numtolist

integer

None.

DisplayTypeCategorySpecialItems

database reference = category.special_displaytype

integer

None.

DisplayTypeCategoryGeneralProducts

database reference = category.displaytype

integer

None.

AllowAccess

database reference = category.accessgroup

string

String length: inclusive between 0 and 250

OnFailRedirectTo

database reference = category.redirectto

string

String length: inclusive between 0 and 150

HideLeftBar

database reference = category.hide_left

boolean

None.

HideRightBar

database reference = category.hide_right

boolean

None.

HideTopMenu

database reference = category.hide_framemenu

boolean

None.

SmartCategories

database reference = category.smartcategory

integer

None.

SmartCategoriesSearchKeyword

database reference = category.smartcategory_keyword

string

String length: inclusive between 0 and 255

SmartCategoriesLinkTarget

database reference = category.link_target

string

String length: inclusive between 0 and 50

TemplateProductPage

database reference = category.listing_displaytype

integer

None.

ProductColumnsRelatedProducts

database reference = category.related_columnum

integer

None.

ProductColumnsUpsellProducts

database reference = category.upsellitems_columnum

integer

None.

DisplayTypeRelatedItems

database reference = category.related_displaytype

integer

None.

DisplayTypeUpsellItems

database reference = category.upsellitems_displaytype

integer

None.

OptionSetList

Collection of OptionSet

None.

Title

database reference = category.category_title

string

String length: inclusive between 0 and 65535

CustomFileName

database reference = category.filename

string

String length: inclusive between 0 and 255

MetaTags

database reference = category.category_meta

string

String length: inclusive between 0 and 65535

CategoryHeader

database reference = category.category_header

string

String length: inclusive between 0 and 65535

CategoryFooter

database reference = category.category_footer

string

String length: inclusive between 0 and 65535

AdditionalKeywords

database reference = category.keywords

string

String length: inclusive between 0 and 65535

CategoryExternalIdsList

Collection of CategoryExternalId

None.