ordertype


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 null
orderhistory.orderTypeId FKo4tyg1rn7ewuph9wyx1y2gmwt R
pickitem.orderTypeId FK6h0grdyvnagipkp69j35cbfe6 R
pickitem_aud.orderTypeId Implied Constraint R
post.orderTypeId FKio7k706qejm4363q3vb13volu R
receipt.orderTypeId FK7w54h7mqa2k5kr3v6yepe8701 R
receipt_aud.orderTypeId Implied Constraint R
receiptitem.orderTypeId FKoig8kulfvaw0scrgi86jdaw23 R
receiptitem_aud.orderTypeId Implied Constraint R
ship.orderTypeId FKdjmo1324e9rheybq7nu3od2e R
ship_aud.orderTypeId Implied Constraint R
shipcarton.orderTypeId FKm0uqqtsfdrr7o0m7hdtyosbak R
shipcarton_aud.orderTypeId Implied Constraint R
shipitem.orderTypeId FKs5og8s6hkfbdb9jvebmh0sspf R
shipitem_aud.orderTypeId Implied Constraint R
taxrate.orderTypeId FK4p83gy522cshq5r4wn9l2xcme R
taxrate_aud.orderTypeId Implied Constraint R
name VARCHAR 15 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
UKoi1m51eoyi32e1wickedmxcu7 Must be unique Asc name

Relationships