voucherserie

469 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
category_voucherserie.voucherserie_id FK_2CA540056EC643C7C
customer_voucherserie.voucherserie_id FK_F8AAA08E6EC643C7C
customergroup_voucherserie.voucherserie_id FK_C28062536EC643C7C
product_voucherserie.voucherserie_id FK_7BD641FC6EC643C7C
voucher.voucherserie_id FK_1392A5D86EC643C7R
voucherserie_client.voucherserie_id FK_BA672C446EC643C7C
voucherserie_objectgroup.voucherserie_id FK_356CCE2C6EC643C7C
voucherserieaccessory.voucherserie_id FK_E91D96B56EC643C7R
mainClient_id VARCHAR 36 null
client.id FK_F67263976CF8BF97R
created DATETIME 19 null
foreign_id VARCHAR 36 null
title VARCHAR 255 null
description VARCHAR 255 null
discount DECIMAL 10,2 null
discountType VARCHAR 36 null
beginDate DATETIME 19 null
endDate DATETIME 19 null
minimumValue DECIMAL 10,2 null
saleVoucher BIT 1 null
allowSameSeries BIT 1 null
allowOtherSeries BIT 1 null
allowUseAnother BIT 1 null
calculateOnce BIT 1 null
document_id VARCHAR 36 null
document.id FK_F6726397C33F7837R
refundDiscountVoucher BIT 1 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
foreign_idx Performance Asc foreign_id
IDX_F67263976CF8BF97 Performance Asc mainClient_id
IDX_F6726397C33F7837 Performance Asc document_id

Relationships