discount

20 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
category_discount.discount_id FK_569A30754C7C611FC
country_discount.discount_id FK_D22AE5B34C7C611FC
customer_discount.discount_id FK_CD25F7214C7C611FC
customergroup_discount.discount_id FK_23E5C85C4C7C611FC
discount_client.discount_id FK_A904286A4C7C611FC
discount_objectgroup.discount_id FK_EF81FCF54C7C611FC
discount_saleschannel.discount_id FK_517EF2A64C7C611FC
discountaccessory.discount_id FK_E57748E34C7C611FR
product_discount.discount_id FK_2A50DE994C7C611FC
foreign_id VARCHAR 36 √ null
title VARCHAR 255 null
active BIT 1 null
beginDate DATETIME 19 √ null
endDate DATETIME 19 √ null
minimumPurchaseValue DECIMAL 10,2 null
maximumPurchaseValue DECIMAL 10,2 null
minimumPurchaseAmount DECIMAL 10,2 null
maximumPurchaseAmount DECIMAL 10,2 null
description VARCHAR 255 √ null
discount DECIMAL 10,2 null
discountType VARCHAR 36 null
mainClient_id VARCHAR 36 √ null
client.id FK_E1E0B40E6CF8BF97R
lastDiscount BIT 1 null
sort INT 10 null
updated DATETIME 19 null
noSalesChannel BIT 1 null
itemAbsoluteDiscount BIT 1 null
validOnlyWithAssignedItems BIT 1 null
validOnlyWithAssignedProducts BIT 1 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
IDX_E1E0B40E6CF8BF97 Performance Asc mainClient_id

Relationships

Close relationships within degrees of separation