Physical name  Orders   
Logical nameOrders
Attributes14
Description 

PKPhysical nameDatatypeFK Ref.
OrderIDINT 
 CustomerIDNCHAR (5)Customers.CustomerID [FK_Orders_Customers]
 EmployeeIDINTEmployees.EmployeeID [FK_Orders_Employees]
 OrderDateDATETIME 
 RequiredDateDATETIME 
 ShippedDateDATETIME 
 ShipViaINTShippers.ShipperID [FK_Orders_Shippers]
 FreightMONEY 
 ShipNameNVARCHAR (40) 
 ShipAddressNVARCHAR (60) 
 ShipCityNVARCHAR (15) 
 ShipRegionNVARCHAR (15) 
 ShipPostalCodeNVARCHAR (10) 
 ShipCountryNVARCHAR (15) 

Indexes
CustomerID CustomerIDASC
CustomersOrders CustomerIDASC
EmployeeID EmployeeIDASC
EmployeesOrders EmployeeIDASC
OrderDate OrderDateASC
ShippedDate ShippedDateASC
ShippersOrders ShipViaASC
ShipPostalCode ShipPostalCodeASC

ReferencesReferenced by
Customers [FK_Orders_Customers]
Employees [FK_Orders_Employees]
Shippers [FK_Orders_Shippers]  
Order Details [FK_OrdDet_Ord]