CHECK Table Level|([DueDate]>=[OrderDate])
CHECK Table Level|([ShipDate]>=[OrderDate] OR [ShipDate] IS NULL)
CHECK Table Level|([Status]>=(0) AND [Status]<=(8))
DEFAULT on column Freight|((0.0))
DEFAULT on column ModifiedDate|(getdate())
DEFAULT on column OnlineOrderFlag|((1))
DEFAULT on column OrderDate|(getdate())
DEFAULT on column RevisionNumber|((0))
DEFAULT on column rowguid|(newid())
DEFAULT on column Status|((1))
DEFAULT on column SubTotal|((0.0))
DEFAULT on column TaxAmt|((0.0))
FOREIGN KEY|BillToAddressID
|REFERENCES AdventureWorks.Person.Address (AddressID)
FOREIGN KEY|ShipToAddressID
|REFERENCES AdventureWorks.Person.Address (AddressID)
FOREIGN KEY|ContactID
|REFERENCES AdventureWorks.Person.Contact (ContactID)
FOREIGN KEY|CreditCardID
|REFERENCES AdventureWorks.Sales.CreditCard (CreditCardID)
FOREIGN KEY|CurrencyRateID
|REFERENCES AdventureWorks.Sales.CurrencyRate (CurrencyRateID)
FOREIGN KEY|CustomerID
|REFERENCES AdventureWorks.Sales.Customer (CustomerID)
FOREIGN KEY|SalesPersonID
|REFERENCES AdventureWorks.Sales.SalesPerson (SalesPersonID)
FOREIGN KEY|TerritoryID
|REFERENCES AdventureWorks.Sales.SalesTerritory (TerritoryID)
FOREIGN KEY|ShipMethodID
|REFERENCES AdventureWorks.Purchasing.ShipMethod (ShipMethodID)
PRIMARY KEY (clustered)|SalesOrderID