Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| id | VARCHAR | 36 | null |
|
|
|||||
| client_id | VARCHAR | 36 | √ | null |
|
|
||||
| foreign_id | VARCHAR | 36 | √ | null |
|
|
||||
| productId | VARCHAR | 32 | √ | null |
|
|
||||
| parentId | VARCHAR | 32 | √ | null |
|
|
||||
| variant | INT | 10 | √ | null |
|
|
||||
| price | DOUBLE | 22 | null |
|
|
|||||
| size | INT | 10 | null |
|
|
|||||
| user | INT | 10 | null |
|
|
|||||
| provision | INT | 10 | null |
|
|
|||||
| variantName | VARCHAR | 255 | √ | null |
|
|
||||
| sizeName | VARCHAR | 255 | √ | null |
|
|
||||
| useCorrectionView | BIT | 1 | null |
|
|
|||||
| correctionViewPrice | DECIMAL | 10,2 | null |
|
|
|||||
| useTypeSample | BIT | 1 | null |
|
|
|||||
| typeSamplePrice | DECIMAL | 10,2 | null |
|
|
|||||
| vpe | DOUBLE | 22 | null |
|
|
|||||
| file | VARCHAR | 255 | √ | null |
|
|
||||
| offerItem_id | VARCHAR | 36 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| foreign_idx | Performance | Asc | foreign_id |
| IDX_AE6EEF4519EB6921 | Performance | Asc | client_id |
| IDX_AE6EEF45FDB4FBE0 | Performance | Asc | offerItem_id |