CHECK Table Level|([ShipDate]>=[OrderDate] OR [ShipDate] IS NULL)
CHECK Table Level|([Status]>=(1) AND [Status]<=(4))
DEFAULT on column Freight|((0.0))
DEFAULT on column ModifiedDate|(getdate())
DEFAULT on column OrderDate|(getdate())
DEFAULT on column RevisionNumber|((0))
DEFAULT on column Status|((1))
DEFAULT on column SubTotal|((0.0))
DEFAULT on column TaxAmt|((0.0))
FOREIGN KEY|EmployeeID
|REFERENCES AdventureWorks.HumanResources.Employee (EmployeeID)
FOREIGN KEY|ShipMethodID
|REFERENCES AdventureWorks.Purchasing.ShipMethod (ShipMethodID)
FOREIGN KEY|VendorID
|REFERENCES AdventureWorks.Purchasing.Vendor (VendorID)
PRIMARY KEY (clustered)|PurchaseOrderID