Orders Info

Customer name, order date, and freight charge for each order.

Name	Type	Attributes	Default	Description
OrderID	int	Auto Increment		Unique order number.
CustomerID	nchar(5)	Nullable		Same entry as in Customers table.
EmployeeID	int	Nullable		Same entry as in Employees table.
OrderDate	datetime	Nullable	getdate()
RequiredDate	datetime	Nullable
ShippedDate	datetime	Nullable
ShipVia	int	Nullable		Same as Shipper ID in Shippers table.
Freight	money	Nullable	0
ShipName	nvarchar(40)	Nullable		Name of person or company to receive the shipment.
ShipAddress	nvarchar(60)	Nullable		Street address only -- no post-office box allowed.
ShipCity	nvarchar(15)	Nullable
ShipRegion	nvarchar(15)	Nullable		State or province.
ShipPostalCode	nvarchar(10)	Nullable
ShipCountry	nvarchar(15)	Nullable

Orders Table