Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| id | VARCHAR | 36 | null |
|
|
|||||||||
| order_id | VARCHAR | 36 | √ | null |
|
|
||||||||
| warehouse_id | VARCHAR | 36 | √ | null |
|
|
||||||||
| created | DATETIME | 19 | null |
|
|
|||||||||
| type | INT | 10 | null |
|
|
|||||||||
| deliveryNumber | INT | 10 | null |
|
|
|||||||||
| slipNumber | VARCHAR | 255 | √ | null |
|
|
||||||||
| reason | VARCHAR | 2 | null |
|
|
|||||||||
| customerOrder_id | VARCHAR | 36 | √ | null |
|
|
||||||||
| orderReturn_id | VARCHAR | 36 | √ | null |
|
|
||||||||
| note | LONGTEXT | 2147483647 | √ | null |
|
|
||||||||
| relocatedWarehouse_id | VARCHAR | 36 | √ | null |
|
|
||||||||
| user_id | INT | 10 | √ | null |
|
|
||||||||
| deliveryNoteNumber | VARCHAR | 30 | √ | null |
|
|
||||||||
| differentShippingDate | DATETIME | 19 | √ | null |
|
|
||||||||
| submission | BIT | 1 | √ | null |
|
|
||||||||
| secret | VARCHAR | 36 | √ | null |
|
|
||||||||
| relocatedLocation_id | VARCHAR | 36 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| IDX_44EAB7571C7C4AAD | Performance | Asc | customerOrder_id |
| IDX_44EAB7575080ECDE | Performance | Asc | warehouse_id |
| IDX_44EAB7576FBD33A7 | Performance | Asc | orderReturn_id |
| IDX_44EAB7578D9F6D38 | Performance | Asc | order_id |
| IDX_44EAB757A76ED395 | Performance | Asc | user_id |
| IDX_44EAB757DADBCE91 | Performance | Asc | relocatedLocation_id |
| IDX_44EAB757DD5477C4 | Performance | Asc | relocatedWarehouse_id |