Database : Northwind
Report created by EasyStruct 4.5 on 8/16/2004
  Tables   Views   Stored Procedures   Indexes
  Tables


Orders Top
Column Name Ordinal Position Default Value Null Allowed Data Type Precision Check Clause Description
 OrderID 1 No int 10
CustomerID 2 YES nchar 5
EmployeeID 3 YES int 10
OrderDate 4 YES datetime 23
RequiredDate 5 YES datetime 23
ShippedDate 6 YES datetime 23
ShipVia 7 YES int 10
Freight 8 (0) YES money 19
ShipName 9 YES nvarchar 40
ShipAddress 10 YES nvarchar 60
ShipCity 11 YES nvarchar 15
ShipRegion 12 YES nvarchar 15
ShipPostalCode 13 YES nvarchar 10
ShipCountry 14 YES nvarchar 15



Orders Top
Name Primary Key Table Foreign Key Table Foreign Key Column Update Rule Delete Rule Primary Key Column
FK_Orders_Customers Customers Orders CustomerID NO ACTION NO ACTION CustomerID
FK_Orders_Employees Employees Orders EmployeeID NO ACTION NO ACTION EmployeeID
FK_Orders_Shippers Shippers Orders ShipVia NO ACTION NO ACTION ShipperID



PK_Orders Top
Name PK_Orders
Table Name Orders
Index Type Clustered
Unique False
Index FillFactor 0
Primary Key True
Ignore Duplicate Row False



PK_Orders - Columns Top
Column Name Sort Order
OrderID Ascending
Tables Views Stored Procedures Indexes


CustomerID Top
Name CustomerID
Table Name Orders
Index Type Non-Clustered
Unique True
Index FillFactor 0
Primary Key False
Ignore Duplicate Row False



CustomerID - Columns Top
Column Name Sort Order
CustomerID Ascending
Tables Views Stored Procedures Indexes


CustomersOrders Top
Name CustomersOrders
Table Name Orders
Index Type Non-Clustered
Unique True
Index FillFactor 0
Primary Key False
Ignore Duplicate Row False



CustomersOrders - Columns Top
Column Name Sort Order
CustomerID Ascending
Tables Views Stored Procedures Indexes


EmployeeID Top
Name EmployeeID
Table Name Orders
Index Type Non-Clustered
Unique True
Index FillFactor 0
Primary Key False
Ignore Duplicate Row False



EmployeeID - Columns Top
Column Name Sort Order
EmployeeID Ascending
Tables Views Stored Procedures Indexes


EmployeesOrders Top
Name EmployeesOrders
Table Name Orders
Index Type Non-Clustered
Unique True
Index FillFactor 0
Primary Key False
Ignore Duplicate Row False



EmployeesOrders - Columns Top
Column Name Sort Order
EmployeeID Ascending
Tables Views Stored Procedures Indexes


OrderDate Top
Name OrderDate
Table Name Orders
Index Type Non-Clustered
Unique True
Index FillFactor 0
Primary Key False
Ignore Duplicate Row False



OrderDate - Columns Top
Column Name Sort Order
OrderDate Ascending
Tables Views Stored Procedures Indexes


ShippedDate Top
Name ShippedDate
Table Name Orders
Index Type Non-Clustered
Unique True
Index FillFactor 0
Primary Key False
Ignore Duplicate Row False



ShippedDate - Columns Top
Column Name Sort Order
ShippedDate Ascending
Tables Views Stored Procedures Indexes


ShippersOrders Top
Name ShippersOrders
Table Name Orders
Index Type Non-Clustered
Unique True
Index FillFactor 0
Primary Key False
Ignore Duplicate Row False



ShippersOrders - Columns Top
Column Name Sort Order
ShipVia Ascending
Tables Views Stored Procedures Indexes


ShipPostalCode Top
Name ShipPostalCode
Table Name Orders
Index Type Non-Clustered
Unique True
Index FillFactor 0
Primary Key False
Ignore Duplicate Row False



ShipPostalCode - Columns Top
Column Name Sort Order
ShipPostalCode Ascending
Tables Views Stored Procedures Indexes


Products Top
Column Name Ordinal Position Default Value Null Allowed Data Type Precision Check Clause Description
 ProductID 1 No int 10
ProductName 2 No nvarchar 40
SupplierID 3 YES int 10
CategoryID 4 YES int 10
QuantityPerUnit 5 YES nvarchar 20
UnitPrice 6 (0) YES money 19
UnitsInStock 7 (0) YES smallint 5
UnitsOnOrder 8 (0) YES smallint 5
ReorderLevel 9 (0) YES smallint 5
Discontinued 10 (0) No bit 1



Products Top
Name Primary Key Table Foreign Key Table Foreign Key Column Update Rule Delete Rule Primary Key Column
FK_Products_Categories Categories Products CategoryID NO ACTION NO ACTION CategoryID
FK_Products_Suppliers Suppliers Products SupplierID NO ACTION NO ACTION SupplierID



PK_Products Top
Name PK_Products
Table Name Products
Index Type Clustered
Unique False
Index FillFactor 0
Primary Key True
Ignore Duplicate Row False



PK_Products - Columns Top
Column Name Sort Order
ProductID Ascending
Tables Views Stored Procedures Indexes


CategoriesProducts Top
Name CategoriesProducts
Table Name Products
Index Type Non-Clustered
Unique True
Index FillFactor 0
Primary Key False
Ignore Duplicate Row False



CategoriesProducts - Columns Top
Column Name Sort Order
CategoryID Ascending
Tables Views Stored Procedures Indexes


CategoryID Top
Name CategoryID
Table Name Products
Index Type Non-Clustered
Unique True
Index FillFactor 0
Primary Key False
Ignore Duplicate Row False



CategoryID - Columns Top
Column Name Sort Order
CategoryID Ascending
Tables Views Stored Procedures Indexes


ProductName Top
Name ProductName
Table Name Products
Index Type Non-Clustered
Unique True
Index FillFactor 0
Primary Key False
Ignore Duplicate Row False



ProductName - Columns Top
Column Name Sort Order
ProductName Ascending
Tables Views Stored Procedures Indexes


SupplierID Top
Name SupplierID
Table Name Products
Index Type Non-Clustered
Unique True
Index FillFactor 0
Primary Key False
Ignore Duplicate Row False



SupplierID - Columns Top
Column Name Sort Order
SupplierID Ascending
Tables Views Stored Procedures Indexes


SuppliersProducts Top
Name SuppliersProducts
Table Name Products
Index Type Non-Clustered
Unique True
Index FillFactor 0
Primary Key False
Ignore Duplicate Row False



SuppliersProducts - Columns Top
Column Name Sort Order
SupplierID Ascending
Tables Views Stored Procedures Indexes


Order Details Top
Column Name Ordinal Position Default Value Null Allowed Data Type Precision Check Clause Description
 OrderID 1 No int 10
 ProductID 2 No int 10
UnitPrice 3 (0) No money 19
Quantity 4 (1) No smallint 5
Discount 5 (0) No real 24



Order Details Top
Name Primary Key Table Foreign Key Table Foreign Key Column Update Rule Delete Rule Primary Key Column
FK_Order_Details_Orders Orders Order Details OrderID NO ACTION NO ACTION OrderID
FK_Order_Details_Products Products Order Details ProductID NO ACTION NO ACTION ProductID



PK_Order_Details Top
Name PK_Order_Details
Table Name Order Details
Index Type Clustered
Unique False
Index FillFactor 0
Primary Key True
Ignore Duplicate Row False



PK_Order_Details - Columns Top
Column Name Sort Order
OrderID Ascending
ProductID Ascending
Tables Views Stored Procedures Indexes


OrderID Top
Name OrderID
Table Name Order Details
Index Type Non-Clustered
Unique True
Index FillFactor 0
Primary Key False
Ignore Duplicate Row False



OrderID - Columns Top
Column Name Sort Order
OrderID Ascending
Tables Views Stored Procedures Indexes


OrdersOrder_Details Top
Name OrdersOrder_Details
Table Name Order Details
Index Type Non-Clustered
Unique True
Index FillFactor 0
Primary Key False
Ignore Duplicate Row False



OrdersOrder_Details - Columns Top
Column Name Sort Order
OrderID Ascending
Tables Views Stored Procedures Indexes


ProductID Top
Name ProductID
Table Name Order Details
Index Type Non-Clustered
Unique True
Index FillFactor 0
Primary Key False
Ignore Duplicate Row False



ProductID - Columns Top
Column Name Sort Order
ProductID Ascending
Tables Views Stored Procedures Indexes


ProductsOrder_Details Top
Name ProductsOrder_Details
Table Name Order Details
Index Type Non-Clustered
Unique True
Index FillFactor 0
Primary Key False
Ignore Duplicate Row False



ProductsOrder_Details - Columns Top
Column Name Sort Order
ProductID Ascending
Tables Views Stored Procedures Indexes


CustomerCustomerDemo Top
Column Name Ordinal Position Default Value Null Allowed Data Type Precision Check Clause Description
 CustomerID 1 No nchar 5
 CustomerTypeID 2 No nchar 10



CustomerCustomerDemo Top
Name Primary Key Table Foreign Key Table Foreign Key Column Update Rule Delete Rule Primary Key Column
FK_CustomerCustomerDemo CustomerDemographics CustomerCustomerDemo CustomerTypeID NO ACTION NO ACTION CustomerTypeID
FK_CustomerCustomerDemo_Customers Customers CustomerCustomerDemo CustomerID NO ACTION NO ACTION CustomerID



PK_CustomerCustomerDemo Top
Name PK_CustomerCustomerDemo
Table Name CustomerCustomerDemo
Index Type Non-Clustered
Unique False
Index FillFactor 0
Primary Key True
Ignore Duplicate Row False



PK_CustomerCustomerDemo - Columns Top
Column Name Sort Order
CustomerID Ascending
CustomerTypeID Ascending
Tables Views Stored Procedures Indexes


CustomerDemographics Top
Column Name Ordinal Position Default Value Null Allowed Data Type Precision Check Clause Description
 CustomerTypeID 1 No nchar 10
CustomerDesc 2 YES ntext 1073741823



PK_CustomerDemographics Top
Name PK_CustomerDemographics
Table Name CustomerDemographics
Index Type Non-Clustered
Unique False
Index FillFactor 0
Primary Key True
Ignore Duplicate Row False



PK_CustomerDemographics - Columns Top
Column Name Sort Order
CustomerTypeID Ascending
Tables Views Stored Procedures Indexes


tCustomerDemographics Top
Name tCustomerDemographics
Table Name CustomerDemographics
Index Type Non-Clustered
Unique False
Index FillFactor 0
Primary Key False
Ignore Duplicate Row False