SchemaToDoc - Northwind
Note: The Type column includes the maximum size for character fields and the precision/scale (if they have been set) for Numeric and Decimal fields.
Table of Contents
All Tables (Tables)........................................................................................................................................ 3
Categories................................................................................................................................................. 3
CustomerCustomerDemo.......................................................................................................................... 3
CustomerDemographics............................................................................................................................ 4
Customers................................................................................................................................................. 4
Employees................................................................................................................................................ 5
EmployeeTerritories.................................................................................................................................. 6
Order Details............................................................................................................................................ 6
Orders...................................................................................................................................................... 7
Products................................................................................................................................................... 8
Region...................................................................................................................................................... 9
Shippers.................................................................................................................................................... 9
Suppliers................................................................................................................................................. 10
Territories............................................................................................................................................... 11
All Views (Views)....................................................................................................................................... 12
Alphabetical list of products..................................................................................................................... 12
Category Sales for 1997.......................................................................................................................... 12
Current Product List................................................................................................................................ 12
Customer and Suppliers by City............................................................................................................... 13
Invoices.................................................................................................................................................. 13
Order Details Extended........................................................................................................................... 14
Order Subtotals....................................................................................................................................... 15
Orders Qry............................................................................................................................................. 15
Product Sales for 1997............................................................................................................................ 16
Products Above Average Price................................................................................................................ 17
Products by Category.............................................................................................................................. 17
Quarterly Orders..................................................................................................................................... 17
Sales by Category................................................................................................................................... 18
Sales Totals by Amount........................................................................................................................... 18
Summary of Sales by Quarter.................................................................................................................. 19
Summary of Sales by Year...................................................................................................................... 19
All Stored Procedures (Stored Procedures)................................................................................................. 20
CustOrderHist......................................................................................................................................... 20
CustOrdersDetail.................................................................................................................................... 20
CustOrdersOrders.................................................................................................................................. 20
Employee Sales by Country..................................................................................................................... 21
Sales by Year.......................................................................................................................................... 21
SalesByCategory..................................................................................................................................... 21
Ten Most Expensive Products................................................................................................................. 22
Primary Key(s): CategoryID
|
Field |
Type |
Nulls? |
|
CategoryID |
int |
No |
|
CategoryName |
nvarchar (15) |
No |
|
Description |
ntext |
Yes |
|
Picture |
image |
Yes |
|
Index Name |
Unique |
Clustered |
Fields |
|
PK_Categories |
Yes |
Yes |
CategoryID |
|
CategoryName |
No |
No |
CategoryName |
No Check Constraints
No Internal Foreign Keys
|
Primary Key as Foreign Key Constraint |
Affected Table |
Affected Field |
|
FK_Products_Categories |
Products |
CategoryID |
No Enabled Triggers
Primary Key(s): CustomerID, CustomerTypeID
|
Field |
Type |
Nulls? |
|
CustomerID |
nchar (5) |
No |
|
CustomerTypeID |
nchar (10) |
No |
|
Index Name |
Unique |
Clustered |
Fields |
|
PK_CustomerCustomerDemo |
Yes |
No |
CustomerID, CustomerTypeID |
No Check Constraints
|
Internal Foreign Key Constraint |
Affected Field |
Source Table |
|
FK_CustomerCustomerDemo |
CustomerTypeID |
CustomerDemographics |
|
FK_CustomerCustomerDemo_Customers |
CustomerID |
Customers |
No External Foreign Keys
No Enabled Triggers
Primary Key(s): CustomerTypeID
|
Field |
Type |
Nulls? |
|
CustomerTypeID |
nchar (10) |
No |
|
CustomerDesc |
ntext |
Yes |
|
Index Name |
Unique |
Clustered |
Fields |
|
PK_CustomerDemographics |
Yes |
No |
CustomerTypeID |
No Check Constraints
No Internal Foreign Keys
|
Primary Key as Foreign Key Constraint |
Affected Table |
Affected Field |
|
FK_CustomerCustomerDemo |
CustomerCustomerDemo |
CustomerTypeID |
No Enabled Triggers
Primary Key(s): CustomerID
|
Field |
Type |
Nulls? |
|
CustomerID |
nchar (5) |
No |
|
CompanyName |
nvarchar (40) |
No |
|
ContactName |
nvarchar (30) |
Yes |
|
ContactTitle |
nvarchar (30) |
Yes |
|
Address |
nvarchar (60) |
Yes |
|
City |
nvarchar (15) |
Yes |
|
Region |
nvarchar (15) |
Yes |
|
PostalCode |
nvarchar (10) |
Yes |
|
Country |
nvarchar (15) |
Yes |
|
Phone |
nvarchar (24) |
Yes |
|
Fax |
nvarchar (24) |
Yes |
|
Index Name |
Unique |
Clustered |
Fields |
|
PK_Customers |
Yes |
Yes |
CustomerID |
|
City |
No |
No |
City |
|
CompanyName |
No |
No |
CompanyName |
|
PostalCode |
No |
No |
PostalCode |
|
Region |
No |
No |
Region |
No Check Constraints
No Internal Foreign Keys
|
Primary Key as Foreign Key Constraint |
Affected Table |
Affected Field |
|
FK_CustomerCustomerDemo_Customers |
CustomerCustomerDemo |
CustomerID |
|
FK_Orders_Customers |
Orders |
CustomerID |
No Enabled Triggers
Primary Key(s): EmployeeID
|
Field |
Type |
Nulls? |
|
EmployeeID |
int |
No |
|
LastName |
nvarchar (20) |
No |
|
FirstName |
nvarchar (10) |
No |
|
Title |
nvarchar (30) |
Yes |
|
TitleOfCourtesy |
nvarchar (25) |
Yes |
|
BirthDate |
datetime |
Yes |
|
HireDate |
datetime |
Yes |
|
Address |
nvarchar (60) |
Yes |
|
City |
nvarchar (15) |
Yes |
|
Region |
nvarchar (15) |
Yes |
|
PostalCode |
nvarchar (10) |
Yes |
|
Country |
nvarchar (15) |
Yes |
|
HomePhone |
nvarchar (24) |
Yes |
|
Extension |
nvarchar (4) |
Yes |
|
Photo |
image |
Yes |
|
Notes |
ntext |
Yes |
|
ReportsTo |
int |
Yes |
|
PhotoPath |
nvarchar (255) |
Yes |
|
Index Name |
Unique |
Clustered |
Fields |
|
PK_Employees |
Yes |
Yes |
EmployeeID |
|
LastName |
No |
No |
LastName |
|
PostalCode |
No |
No |
PostalCode |
|
Check Constraint Name |
Text |
|
CK_Birthdate |
([BirthDate] < getdate()) |
|
Internal Foreign Key Constraint |
Affected Field |
Source Table |
|
FK_Employees_Employees |
ReportsTo |
Employees |
|
Primary Key as Foreign Key Constraint |
Affected Table |
Affected Field |
|
FK_Employees_Employees |
Employees |
ReportsTo |
|
FK_EmployeeTerritories_Employees |
EmployeeTerritories |
EmployeeID |
|
FK_Orders_Employees |
Orders |
EmployeeID |
No Enabled Triggers
Primary Key(s): EmployeeID, TerritoryID
|
Field |
Type |
Nulls? |
|
EmployeeID |
int |
No |
|
TerritoryID |
nvarchar (20) |
No |
|
Index Name |
Unique |
Clustered |
Fields |
|
PK_EmployeeTerritories |
Yes |
No |
EmployeeID, TerritoryID |
No Check Constraints
|
Internal Foreign Key Constraint |
Affected Field |
Source Table |
|
FK_EmployeeTerritories_Employees |
EmployeeID |
Employees |
|
FK_EmployeeTerritories_Territories |
TerritoryID |
Territories |
No External Foreign Keys
No Enabled Triggers
Primary Key(s): OrderID, ProductID
|
Field |
Type |
Default |
Nulls? |
|
OrderID |
int |
|
No |
|
ProductID |
int |
|
No |
|
UnitPrice |
money |
(0) |
No |
|
Quantity |
smallint |
(1) |
No |
|
Discount |
real |
(0) |
No |
|
Index Name |
Unique |
Clustered |
Fields |
|
PK_Order_Details |
Yes |
Yes |
OrderID, ProductID |
|
OrderID |
No |
No |
OrderID |
|
OrdersOrder_Details |
No |
No |
OrderID |
|
ProductID |
No |
No |
ProductID |
|
ProductsOrder_Details |
No |
No |
ProductID |
|
Check Constraint Name |
Text |
|
CK_Discount |
([Discount] >= 0 and [Discount] <= 1) |
|
CK_Quantity |
([Quantity] > 0) |
|
CK_UnitPrice |
([UnitPrice] >= 0) |
|
Internal Foreign Key Constraint |
Affected Field |
Source Table |
|
FK_Order_Details_Orders |
OrderID |
Orders |
|
FK_Order_Details_Products |
ProductID |
Products |
No External Foreign Keys
No Enabled Triggers
Primary Key(s): OrderID
|
Field |
Type |
Default |
Nulls? |
|
OrderID |
int |
|
No |
|
CustomerID |
nchar (5) |
|
Yes |
|
EmployeeID |
int |
|
Yes |
|
OrderDate |
datetime |
|
Yes |
|
RequiredDate |
datetime |
|
Yes |
|
ShippedDate |
datetime |
|
Yes |
|
ShipVia |
int |
|
Yes |
|
Freight |
money |
(0) |
Yes |
|
ShipName |
nvarchar (40) |
|
Yes |
|
ShipAddress |
nvarchar (60) |
|
Yes |
|
ShipCity |
nvarchar (15) |
|
Yes |
|
ShipRegion |
nvarchar (15) |
|
Yes |
|
ShipPostalCode |
nvarchar (10) |
|
Yes |
|
ShipCountry |
nvarchar (15) |
|
Yes |
|
Index Name |
Unique |
Clustered |
Fields |
|
PK_Orders |
Yes |
Yes |
OrderID |
|
CustomerID |
No |
No |
CustomerID |
|
CustomersOrders |
No |
No |
CustomerID |
|
EmployeeID |
No |
No |
EmployeeID |
|
EmployeesOrders |
No |
No |
EmployeeID |
|
OrderDate |
No |
No |
OrderDate |
|
ShippedDate |
No |
No |
ShippedDate |
|
ShippersOrders |
No |
No |
ShipVia |
|
ShipPostalCode |
No |
No |
ShipPostalCode |
No Check Constraints
|
Internal Foreign Key Constraint |
Affected Field |
Source Table |
|
FK_Orders_Customers |
CustomerID |
Customers |
|
FK_Orders_Employees |
EmployeeID |
Employees |
|
FK_Orders_Shippers |
ShipVia |
Shippers |
|
Primary Key as Foreign Key Constraint |
Affected Table |
Affected Field |
|
FK_Order_Details_Orders |
Order Details |
OrderID |
No Enabled Triggers
Primary Key(s): ProductID
|
Field |
Type |
Default |
Nulls? |
|
ProductID |
int |
|
No |
|
ProductName |
nvarchar (40) |
|
No |
|
SupplierID |
int |
|
Yes |
|
CategoryID |
int |
|
Yes |
|
QuantityPerUnit |
nvarchar (20) |
|
Yes |
|
UnitPrice |
money |
(0) |
Yes |
|
UnitsInStock |
smallint |
(0) |
Yes |
|
UnitsOnOrder |
smallint |
(0) |
Yes |
|
ReorderLevel |
smallint |
(0) |
Yes |
|
Discontinued |
bit |