Address | nvarchar | 60 | NULL | Employees, Suppliers, Customers
BirthDate | datetime | 8 | NULL | Employees
CategoryID | int | 4 | NULL | Products, Categories
CategoryName | nvarchar | 15 | NOT NULL | Categories
City | nvarchar | 15 | NULL | Employees, Suppliers
City | nvarchar | 20 | NULL | Customers
CompanyName | nvarchar | 40 | NOT NULL | Customers, Suppliers, Shippers
ContactName | nvarchar | 30 | NULL | Suppliers, Customers
ContactTitle | nvarchar | 30 | NULL | Customers, Suppliers
Country | nvarchar | 15 | NULL | Employees, Suppliers, Customers
CustomerDesc | ntext | 16 | NULL | CustomerDemographics
CustomerID | nchar | 5 | NOT NULL | CustomerCustomerDemo, Customers, Orders
CustomerTypeID | nchar | 10 | NOT NULL | CustomerDemographics, CustomerCustomerDemo
Description | ntext | 16 | NULL | Categories
Discontinued | bit | 1 | NOT NULL | Products
Discount | real | 4 | NOT NULL | Order Details
EmployeeID | int | 4 | NOT NULL | Employees, EmployeeTerritories, Orders
Extension | nvarchar | 4 | NULL | Employees
Fax | nvarchar | 24 | NULL | Suppliers, Customers
FirstName | nvarchar | 10 | NOT NULL | Employees
Freight | money | 8 | NULL | Orders
HireDate | datetime | 8 | NULL | Employees
HomePage | ntext | 16 | NULL | Suppliers
HomePhone | nvarchar | 24 | NULL | Employees
LastName | nvarchar | 20 | NOT NULL | Employees
Notes | ntext | 16 | NULL | Employees
OrderDate | datetime | 8 | NULL | Orders
OrderID | int | 4 | NOT NULL | Orders, Order Details
Phone | nvarchar | 24 | NULL | Shippers, Suppliers, Customers
Photo | image | 16 | NULL | Employees
PhotoPath | nvarchar | 255 | NULL | Employees
Picture | image | 16 | NULL | Categories
PostalCode | nvarchar | 10 | NULL | Employees, Suppliers, Customers
ProductID | int | 4 | NOT NULL | Products, Order Details
ProductName | nvarchar | 40 | NOT NULL | Products
Quantity | smallint | 2 | NOT NULL | Order Details
QuantityPerUnit | nvarchar | 20 | NULL | Products
Region | nvarchar | 15 | NULL | Suppliers, Customers, Employees
RegionDescription | nchar | 50 | NOT NULL | Region
RegionID | int | 4 | NOT NULL | Region, Territories
ReorderLevel | smallint | 2 | NULL | Products
ReportsTo | int | 4 | NULL | Employees
RequiredDate | datetime | 8 | NULL | Orders
ShipAddress | nvarchar | 60 | NULL | Orders
ShipCity | nvarchar | 15 | NULL | Orders
ShipCountry | nvarchar | 15 | NULL | Orders
ShipName | nvarchar | 40 | NULL | Orders
ShippedDate | datetime | 8 | NULL | Orders
ShipperID | int | 4 | NOT NULL | Shippers
ShipPostalCode | nvarchar | 10 | NULL | Orders
ShipRegion | nvarchar | 15 | NULL | Orders
ShipVia | int | 4 | NULL | Orders
SupplierID | int | 4 | NOT NULL | Suppliers, Products
TerritoryDescription | nchar | 50 | NOT NULL | Territories
TerritoryID | nvarchar | 20 | NOT NULL | EmployeeTerritories, Territories
Title | nvarchar | 30 | NULL | Employees
TitleOfCourtesy | nvarchar | 25 | NULL | Employees
UnitPrice | money | 8 | NOT NULL | Order Details, Products
UnitsInStock | smallint | 2 | NULL | Products
UnitsOnOrder | smallint | 2 | NULL | Products