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