| Name | Description | Type | Additional 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. |