Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| id | VARCHAR | 36 | null |
|
|
|||||||
| 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 |
|
|
||||||
| shippingCost | DECIMAL | 10,2 | √ | null |
|
|
||||||
| internalClient_id | VARCHAR | 36 | √ | null |
|
|
||||||
| payment_id | VARCHAR | 36 | √ | null |
|
|
||||||
| shipping_id | VARCHAR | 36 | √ | null |
|
|
||||||
| mainVendor | BIT | 1 | null |
|
|
|||||||
| productionOrderClerk_id | INT | 10 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| IDX_739D79354887F3F8 | Performance | Asc | shipping_id |
| IDX_739D79354C3A3BB | Performance | Asc | payment_id |
| IDX_739D79357A78233A | Performance | Asc | internalClient_id |
| IDX_739D79358334E7B | Performance | Asc | productionOrderClerk_id |
| IDX_739D793595D0AABA | Performance | Asc | defaultCurrency_id |