discount

11 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

Indexes

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

Relationships