customergroup

32 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
category_customergroup.customergroup_id FK_7AAFB5E296C19C84R
customer_customergroup.customergroup_id FK_11E0AA96C19C84R
customergroup_discount.customergroup_id FK_23E5C85C96C19C84C
customergroup_voucherserie.customergroup_id FK_C280625396C19C84C
customergroupmetafield.customerGroup_id FK_79B37F326FB7FED2R
customform_customergroup.customergroup_id FK_F94805FB96C19C84C
customformaction_customergroup.customergroup_id FK_346C866396C19C84C
customformfield_customergroup.customergroup_id FK_7970C6A096C19C84C
customformgrid_customergroup.customergroup_id FK_4CA5C48096C19C84C
customformgridaction_customergroup.customergroup_id FK_667C1F1496C19C84C
payment_customergroup.customergroup_id FK_9970996496C19C84C
payment_excludedcustomergroup.customergroup_id FK_6353058396C19C84C
product_customergroup.customergroup_id FK_BE998C5B96C19C84R
productprice.customerGroup_id FK_1A0570636FB7FED2R
productsalecondition.customerGroup_id FK_5A9D614B6FB7FED2R
scaleprice.customerGroup_id FK_9F9E26156FB7FED2R
shipping_customergroup.customergroup_id FK_9282E56B96C19C84C
shipping_excludedcustomergroup.customergroup_id FK_BE31247396C19C84C
shippingcost_customergroup.customergroup_id FK_EBC3840496C19C84C
shippingcost_excludedcustomergroup.customergroup_id FK_AAFD8A4296C19C84C
storemenu_customergroup.customergroup_id FK_6F05319F96C19C84C
foreign_id VARCHAR 36 √ null
title VARCHAR 255 null
active BIT 1 null
sort INT 10 null
ident VARCHAR 36 √ null
nettoMode BIT 1 null
displayProductsForOther BIT 1 null
paymentTerm INT 10 √ null
cashDiscountPercent DECIMAL 10,2 √ null
cashDiscountDays INT 10 √ null

Indexes

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

Relationships

Close relationships within degrees of separation