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


EmployeesTop
Column NameOrdinal PositionDefault ValueNull AllowedData TypePrecisionCheck ClauseDescription
 EmployeeID1No int10
LastName2No nvarchar20
FirstName3No nvarchar10
Title4YESnvarchar30
TitleOfCourtesy5YESnvarchar25
BirthDate6YESdatetime23
HireDate7YESdatetime23
Address8YESnvarchar60
City9YESnvarchar15
Region10YESnvarchar15
PostalCode11YESnvarchar10
Country12YESnvarchar15
HomePhone13YESnvarchar24
Extension14YESnvarchar4
Photo15YESimage2147483647
Notes16YESntext1073741823
ReportsTo17YESint10
PhotoPath18YESnvarchar255


EmployeesTop
NamePrimary Key TableForeign Key TableForeign Key ColumnUpdate RuleDelete RulePrimary Key Column
FK_Employees_EmployeesEmployeesEmployeesReportsToNO ACTIONNO ACTIONEmployeeID


PK_EmployeesTop
NamePK_Employees
Table NameEmployees
Index TypeClustered
UniqueFalse
Index FillFactor0
Primary KeyTrue
Ignore Duplicate RowFalse


PK_Employees - Columns Top
Column NameSort Order
EmployeeIDAscending
TablesViewsStored ProceduresIndexes

LastNameTop
NameLastName
Table NameEmployees
Index TypeNon-Clustered
UniqueTrue
Index FillFactor0
Primary KeyFalse
Ignore Duplicate RowFalse


LastName - Columns Top
Column NameSort Order
LastNameAscending
TablesViewsStored ProceduresIndexes

PostalCodeTop
NamePostalCode
Table NameEmployees
Index TypeNon-Clustered
UniqueTrue
Index FillFactor0
Primary KeyFalse
Ignore Duplicate RowFalse


PostalCode - Columns Top
Column NameSort Order
PostalCodeAscending
TablesViewsStored ProceduresIndexes

tEmployeesTop
NametEmployees
Table NameEmployees
Index TypeNon-Clustered
UniqueFalse
Index FillFactor0
Primary KeyFalse
Ignore Duplicate RowFalse

CategoriesTop
Column NameOrdinal PositionDefault ValueNull AllowedData TypePrecisionCheck ClauseDescription
 CategoryID1No int10
CategoryName2No nvarchar15
Description3YESntext1073741823
Picture4YESimage2147483647


PK_CategoriesTop
NamePK_Categories
Table NameCategories
Index TypeClustered
UniqueFalse
Index FillFactor0
Primary KeyTrue
Ignore Duplicate RowFalse


PK_Categories - Columns Top
Column NameSort Order
CategoryIDAscending
TablesViewsStored ProceduresIndexes

CategoryNameTop
NameCategoryName
Table NameCategories
Index TypeNon-Clustered
UniqueTrue
Index FillFactor0
Primary KeyFalse
Ignore Duplicate RowFalse


CategoryName - Columns Top
Column NameSort Order
CategoryNameAscending
TablesViewsStored ProceduresIndexes

tCategoriesTop
NametCategories
Table NameCategories
Index TypeNon-Clustered
UniqueFalse
Index FillFactor0
Primary KeyFalse
Ignore Duplicate RowFalse

CustomersTop
Column NameOrdinal PositionDefault ValueNull AllowedData TypePrecisionCheck ClauseDescription
 CustomerID1No nchar5
CompanyName2No nvarchar40
ContactName3YESnvarchar30
ContactTitle4YESnvarchar30
Address5YESnvarchar60
City6YESnvarchar15
Region7YESnvarchar15
PostalCode8YESnvarchar10
Country9YESnvarchar15
Phone10YESnvarchar24
Fax11YESnvarchar24


PK_CustomersTop
NamePK_Customers
Table NameCustomers
Index TypeClustered
UniqueFalse
Index FillFactor0
Primary KeyTrue
Ignore Duplicate RowFalse


PK_Customers - Columns Top
Column NameSort Order
CustomerIDAscending
TablesViewsStored ProceduresIndexes

CityTop
NameCity
Table NameCustomers
Index TypeNon-Clustered
UniqueTrue
Index FillFactor0
Primary KeyFalse
Ignore Duplicate RowFalse


City - Columns Top
Column NameSort Order
CityAscending
TablesViewsStored ProceduresIndexes

CompanyNameTop
NameCompanyName
Table NameCustomers
Index TypeNon-Clustered
UniqueTrue
Index FillFactor0
Primary KeyFalse
Ignore Duplicate RowFalse


CompanyName - Columns Top
Column NameSort Order
CompanyNameAscending
TablesViewsStored ProceduresIndexes

PostalCodeTop
NamePostalCode
Table NameCustomers
Index TypeNon-Clustered
UniqueTrue
Index FillFactor0
Primary KeyFalse
Ignore Duplicate RowFalse


PostalCode - Columns Top
Column NameSort Order
PostalCodeAscending
TablesViewsStored ProceduresIndexes

RegionTop
NameRegion
Table NameCustomers
Index TypeNon-Clustered
UniqueTrue
Index FillFactor0
Primary KeyFalse
Ignore Duplicate RowFalse


Region - Columns Top
Column NameSort Order
RegionAscending
TablesViewsStored ProceduresIndexes

ShippersTop
Column NameOrdinal PositionDefault ValueNull AllowedData TypePrecisionCheck ClauseDescription
 ShipperID1No int10
CompanyName2No nvarchar40
Phone3YESnvarchar24


PK_ShippersTop
NamePK_Shippers
Table NameShippers
Index TypeClustered
UniqueFalse
Index FillFactor0
Primary KeyTrue
Ignore Duplicate RowFalse


PK_Shippers - Columns Top
Column NameSort Order
ShipperIDAscending
TablesViewsStored ProceduresIndexes

SuppliersTop
Column NameOrdinal PositionDefault ValueNull AllowedData TypePrecisionCheck ClauseDescription
 SupplierID1No int10
CompanyName2No nvarchar40
ContactName3YESnvarchar30
ContactTitle4YESnvarchar30
Address5YESnvarchar60
City6YESnvarchar15
Region7YESnvarchar15
PostalCode8YESnvarchar10
Country9YESnvarchar15
Phone10YESnvarchar24
Fax11YESnvarchar24
HomePage12YESntext1073741823


PK_SuppliersTop
NamePK_Suppliers
Table NameSuppliers
Index TypeClustered
UniqueFalse
Index FillFactor0
Primary KeyTrue
Ignore Duplicate RowFalse


PK_Suppliers - Columns Top
Column NameSort Order
SupplierIDAscending
TablesViewsStored ProceduresIndexes

CompanyNameTop
NameCompanyName
Table NameSuppliers
Index TypeNon-Clustered
UniqueTrue
Index FillFactor0
Primary KeyFalse
Ignore Duplicate RowFalse


CompanyName - Columns Top
Column NameSort Order
CompanyNameAscending
TablesViewsStored ProceduresIndexes

PostalCodeTop
NamePostalCode
Table NameSuppliers
Index TypeNon-Clustered
UniqueTrue
Index FillFactor0
Primary KeyFalse
Ignore Duplicate RowFalse


PostalCode - Columns Top
Column NameSort Order
PostalCodeAscending
TablesViewsStored ProceduresIndexes

tSuppliersTop
NametSuppliers
Table NameSuppliers
Index TypeNon-Clustered
UniqueFalse
Index FillFactor0
Primary KeyFalse
Ignore Duplicate RowFalse