orderreturnitem

537 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
reason_id VARCHAR 36 √ null
orderreturnreason.id FK_3E24DCDF59BB1592R
quantity DECIMAL 10,3 null
action VARCHAR 2 null
orderReturn_id VARCHAR 36 √ null
orderreturn.id FK_3E24DCDF6FBD33A7R
offerItem_id VARCHAR 36 √ null
offeritem.id FK_3E24DCDFFDB4FBE0R
deliveryItem_id VARCHAR 36 √ null
vendororderitemdelivery.id FK_3E24DCDF3AF075CFR
swapDeliveryItem_id VARCHAR 36 √ null
vendororderitemdelivery.id FK_3E24DCDF6715173ER
shippingDate DATETIME 19 √ null
serialNumber_id VARCHAR 36 √ null
productserialnumber.id FK_3E24DCDFA907283BR
materialProduct_id VARCHAR 36 √ null
product.id FK_3E24DCDF7FDBDE77R
otherProduct_id VARCHAR 36 √ null
product.id FK_3E24DCDF99BA4D22R
otherSerialNumber_id VARCHAR 36 √ null
productserialnumber.id FK_3E24DCDF14EEE983R

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
IDX_3E24DCDF14EEE983 Performance Asc otherSerialNumber_id
IDX_3E24DCDF3AF075CF Performance Asc deliveryItem_id
IDX_3E24DCDF59BB1592 Performance Asc reason_id
IDX_3E24DCDF6715173E Performance Asc swapDeliveryItem_id
IDX_3E24DCDF6FBD33A7 Performance Asc orderReturn_id
IDX_3E24DCDF7FDBDE77 Performance Asc materialProduct_id
IDX_3E24DCDF99BA4D22 Performance Asc otherProduct_id
IDX_3E24DCDFA907283B Performance Asc serialNumber_id
IDX_3E24DCDFFDB4FBE0 Performance Asc offerItem_id

Relationships

Close relationships within degrees of separation