Physical name	Datatype	Cross-Ref
Address	NVARCHAR (60)	Customers
Address	NVARCHAR (60)	Suppliers
Address	NVARCHAR (60)	Employees
BirthDate	DATETIME	Employees
CategoryID	INT	Categories, Product
CategoryName	NVARCHAR (15)	Categories
City	NVARCHAR (15)	Customers
City	NVARCHAR (15)	Employees
City	NVARCHAR (15)	Suppliers
CompanyName	NVARCHAR (40)	Suppliers
CompanyName	NVARCHAR (40)	Customers
CompanyName	NVARCHAR (40)	Shippers
ContactName	NVARCHAR (30)	Suppliers
ContactName	NVARCHAR (30)	Customers
ContactTitle	NVARCHAR (30)	Customers
ContactTitle	NVARCHAR (30)	Suppliers
Country	NVARCHAR (15)	Employees
Country	NVARCHAR (15)	Customers
Country	NVARCHAR (15)	Suppliers
CustomerDesc	NTEXT	CustomerDemographics
CustomerID	NCHAR (5)	CustomerCustomerDemo, Customers, Orders
CustomerTypeID	NCHAR (10)	CustomerCustomerDemo, CustomerDemographics
Description	NTEXT	Categories
Discontinued	BIT
Discount	REAL	Order Details
EmployeeID	INT	Employees, EmployeeTerritories, Orders
Extension	NVARCHAR (4)	Employees
Fax	NVARCHAR (24)	Suppliers
Fax	NVARCHAR (24)	Customers
FirstName	NVARCHAR (10)	Employees
Freight	MONEY	Orders
HireDate	DATETIME	Employees
HomePage	NTEXT	Suppliers
HomePhone	NVARCHAR (24)	Employees
LastName	NVARCHAR (20)	Employees
Notes	NTEXT	Employees
OrderDate	DATETIME	Orders
OrderID	INT	Order Details, Orders
Phone	NVARCHAR (24)	Shippers
Phone	NVARCHAR (24)	Customers
Phone	NVARCHAR (24)	Suppliers
Photo	IMAGE	Employees
PhotoPath	NVARCHAR (255)	Employees
Picture	IMAGE	Categories
PostalCode	NVARCHAR (10)	Employees
PostalCode	NVARCHAR (10)	Suppliers
PostalCode	NVARCHAR (10)	Customers
ProductID	INT	Order Details, Product
ProductName	NVARCHAR (40)	Product
Quantity	SMALLINT	Order Details
QuantityPerUnit	NVARCHAR (20)	Product
Region	NVARCHAR (15)	Customers
Region	NVARCHAR (15)	Suppliers
Region	NVARCHAR (15)	Employees
RegionDescription	NCHAR (50)	Region
RegionID	INT	Region, Territories
ReorderLevel	SMALLINT
ReportsTo	INT	Employees
RequiredDate	DATETIME	Orders
ShipAddress	NVARCHAR (60)	Orders
ShipCity	NVARCHAR (15)	Orders
ShipCountry	NVARCHAR (15)	Orders
ShipName	NVARCHAR (40)	Orders
ShippedDate	DATETIME	Orders
ShipperID	INT	Shippers
ShipPostalCode	NVARCHAR (10)	Orders
ShipRegion	NVARCHAR (15)	Orders
ShipVia	INT	Orders
SupplierID	INT	Product, Suppliers
TerritoryDescription	NCHAR (50)	Territories
TerritoryID	NVARCHAR (20)	EmployeeTerritories, Territories
Title	NVARCHAR (30)	Employees
TitleOfCourtesy	NVARCHAR (25)	Employees
UnitPrice	MONEY	Order Details
UnitPrice	MONEY	Product
UnitsInStock	SMALLINT	Product
UnitsOnOrder	SMALLINT	Product