category

137 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
category.parent_id FK_64C19C1727ACA70R
category_client.category_id FK_C8ACCE2E12469DE2C
category_discount.category_id FK_569A307512469DE2C
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_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

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc 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

Relationships