vendorconditions

5 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
vendor.conditions_id FK_F52233F6C5FBDC0FR
vendorconditiondiscount.condition_id FK_BD1B1845887793B6R
deliveryTime INT 10 null
paymentTerm INT 10 null
discountTime INT 10 null
discountPercent DECIMAL 10,2 null
minimumContractValue DECIMAL 10,2 null
minimumSurcharge DECIMAL 10,2 null
shippingFree BIT 1 null
shippingFreeValue DECIMAL 10,2 null
description LONGTEXT 2147483647 null
discountType VARCHAR 1 null
defaultCurrency_id VARCHAR 36 null
currency.id FK_739D793595D0AABAR
shippingCost DECIMAL 10,2 null
internalClient_id VARCHAR 36 null
client.id FK_739D79357A78233AR

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
IDX_739D79357A78233A Performance Asc internalClient_id
IDX_739D793595D0AABA Performance Asc defaultCurrency_id

Relationships