vendororderdelivery

6510 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
vendororderitemdelivery.delivery_id FK_61BB180612136921R
warehousebooking.reference_id FK_FC6BD52C1645DEA9R
order_id VARCHAR 36 null
vendororder.id FK_44EAB7578D9F6D38R
warehouse_id VARCHAR 36 null
warehouse.id FK_44EAB7575080ECDER
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
orders.id FK_44EAB7571C7C4AADR
orderReturn_id VARCHAR 36 null
orderreturn.id FK_44EAB7576FBD33A7R
note LONGTEXT 2147483647 null
relocatedWarehouse_id VARCHAR 36 null
warehouse.id FK_44EAB757DD5477C4R
user_id INT 10 null
users.id FK_44EAB757A76ED395R
deliveryNoteNumber VARCHAR 30 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_44EAB757DD5477C4 Performance Asc relocatedWarehouse_id

Relationships