category

6507 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
category.additionalParent_id FK_64C19C1649AB165R
category.parent_id FK_64C19C1727ACA70R
category_client.category_id FK_C8ACCE2E12469DE2C
category_customergroup.category_id FK_7AAFB5E212469DE2R
category_discount.category_id FK_569A307512469DE2C
category_excludedsaleschannel.category_id FK_67A8141312469DE2C
category_objectgroup.category_id FK_1A6B4AA612469DE2C
category_report.category_id FK_CBC7BDFF12469DE2C
category_voucherserie.category_id FK_2CA5400512469DE2C
categoryaccessory.category_id FK_380BE40712469DE2R
categorycountrytax.category_id FK_9B13321B12469DE2R
categorymetafield.category_id FK_CCC871B12469DE2R
inventory.category_id FK_B12D4A3612469DE2R
payment_category.category_id FK_468A5BA912469DE2C
payment_excludedcategory.category_id FK_4490746C12469DE2C
payment_onlycategory.category_id FK_B1F468EA12469DE2C
product.mainCategory_id FK_D34A04ADCF69962ER
product_cachedrootcategory.category_id FK_D25954CA12469DE2C
product_category.category_id FK_CDFC735612469DE2R
shipping_category.category_id FK_9AA3576E12469DE2C
shipping_excludedcategory.category_id FK_9FF5969012469DE2C
shippingcost_category.category_id FK_A564A10812469DE2C
shippingcost_excludedcategory.category_id FK_A143311412469DE2C
shippingpackage_category.category_id FK_46B5ACCA12469DE2C
shippingpackage_excludedcategory.category_id FK_4E01621B12469DE2C
storebanner.category_id FK_999B026212469DE2R
storebanner.showInCategory_id FK_999B026229A16EF5R
storemenu.category_id FK_31BAF9A012469DE2R
warehousestoragelocation.placedProductGroup_id FK_CBC9E6B7B3467BC9R
tax_id VARCHAR 36 √ null
tax.id FK_64C19C1B2A824D8R
parent_id VARCHAR 36 √ null
category.id FK_64C19C1727ACA70R
foreign_id VARCHAR 36 √ null
foreign_parent_id VARCHAR 36 √ null
title VARCHAR 255 √ null
active BIT 1 null
hidden BIT 1 null
sort INT 10 null
depth INT 10 null
description VARCHAR 255 √ null
longdescription LONGTEXT 2147483647 √ null
picture VARCHAR 255 √ null
externalLink VARCHAR 255 √ null
icon VARCHAR 255 √ null
lastupdated INT 10 null
mainClient_id VARCHAR 36 √ null
client.id FK_64C19C16CF8BF97R
updated DATETIME 19 null
categoryFullTitle VARCHAR 255 √ null
customsTariffNumber VARCHAR 32 √ null
showInCommission BIT 1 null
skipDiscounts BIT 1 null
productGroup BIT 1 null
ident VARCHAR 255 √ null
additionalParent_id VARCHAR 36 √ null
category.id FK_64C19C1649AB165R
numberOfActiveProducts INT 10 null
customNumberOfProducts1 INT 10 null
customNumberOfProducts2 INT 10 null
customNumberOfProducts3 INT 10 null
multiLangCategoryFullTitle LONGTEXT 2147483647 √ null
additionalTitle VARCHAR 255 √ null
additionalTitle2 VARCHAR 255 √ null
customNumberOfProducts4 INT 10 null
customNumberOfProducts5 INT 10 null
additionalTitleFull LONGTEXT 2147483647 √ null
additionalTitle2Full LONGTEXT 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
IDX_64C19C1649AB165 Performance Asc additionalParent_id
IDX_64C19C16CF8BF97 Performance Asc mainClient_id
IDX_64C19C1727ACA70 Performance Asc parent_id
IDX_64C19C1B2A824D8 Performance Asc tax_id
search_idx Performance Asc/Asc foreign_id + foreign_parent_id
title_idx Performance Asc/Asc/Asc title + additionalTitle + additionalTitle2

Relationships

Close relationships within degrees of separation