Physical nameDatatypeCross-Ref
AddressNVARCHAR (60)Customers
AddressNVARCHAR (60)Suppliers
AddressNVARCHAR (60)Employees
BirthDateDATETIMEEmployees
CategoryIDINTCategories, Product
CategoryNameNVARCHAR (15)Categories
CityNVARCHAR (15)Customers
CityNVARCHAR (15)Employees
CityNVARCHAR (15)Suppliers
CompanyNameNVARCHAR (40)Suppliers
CompanyNameNVARCHAR (40)Customers
CompanyNameNVARCHAR (40)Shippers
ContactNameNVARCHAR (30)Suppliers
ContactNameNVARCHAR (30)Customers
ContactTitleNVARCHAR (30)Customers
ContactTitleNVARCHAR (30)Suppliers
CountryNVARCHAR (15)Employees
CountryNVARCHAR (15)Customers
CountryNVARCHAR (15)Suppliers
CustomerDescNTEXTCustomerDemographics
CustomerIDNCHAR (5)CustomerCustomerDemo, Customers, Orders
CustomerTypeIDNCHAR (10)CustomerCustomerDemo, CustomerDemographics
DescriptionNTEXTCategories
DiscontinuedBIT 
DiscountREALOrder Details
EmployeeIDINTEmployees, EmployeeTerritories, Orders
ExtensionNVARCHAR (4)Employees
FaxNVARCHAR (24)Suppliers
FaxNVARCHAR (24)Customers
FirstNameNVARCHAR (10)Employees
FreightMONEYOrders
HireDateDATETIMEEmployees
HomePageNTEXTSuppliers
HomePhoneNVARCHAR (24)Employees
LastNameNVARCHAR (20)Employees
NotesNTEXTEmployees
OrderDateDATETIMEOrders
OrderIDINTOrder Details, Orders
PhoneNVARCHAR (24)Shippers
PhoneNVARCHAR (24)Customers
PhoneNVARCHAR (24)Suppliers
PhotoIMAGEEmployees
PhotoPathNVARCHAR (255)Employees
PictureIMAGECategories
PostalCodeNVARCHAR (10)Employees
PostalCodeNVARCHAR (10)Suppliers
PostalCodeNVARCHAR (10)Customers
ProductIDINTOrder Details, Product
ProductNameNVARCHAR (40)Product
QuantitySMALLINTOrder Details
QuantityPerUnitNVARCHAR (20)Product
RegionNVARCHAR (15)Customers
RegionNVARCHAR (15)Suppliers
RegionNVARCHAR (15)Employees
RegionDescriptionNCHAR (50)Region
RegionIDINTRegion, Territories
ReorderLevelSMALLINT 
ReportsToINTEmployees
RequiredDateDATETIMEOrders
ShipAddressNVARCHAR (60)Orders
ShipCityNVARCHAR (15)Orders
ShipCountryNVARCHAR (15)Orders
ShipNameNVARCHAR (40)Orders
ShippedDateDATETIMEOrders
ShipperIDINTShippers
ShipPostalCodeNVARCHAR (10)Orders
ShipRegionNVARCHAR (15)Orders
ShipViaINTOrders
SupplierIDINTProduct, Suppliers
TerritoryDescriptionNCHAR (50)Territories
TerritoryIDNVARCHAR (20)EmployeeTerritories, Territories
TitleNVARCHAR (30)Employees
TitleOfCourtesyNVARCHAR (25)Employees
UnitPriceMONEYOrder Details
UnitPriceMONEYProduct
UnitsInStockSMALLINTProduct
UnitsOnOrderSMALLINTProduct