Editing AdventureWorks Table+Column Mapping EF1

edmx upload (20100609 200009 AdventureWorks2005ef1.edmx)
  
=== Namespace  ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
      
|- valign="top"
| [[dbo.AWBuildVersion_(table)|dbo.AWBuildVersion]] [[AWBuildVersion_(class)|AWBuildVersion]]
| 
| 
          
|- valign="top"
| 
|         SystemInformationID tinyint NOT NULL Identity
|         SystemInformationID Byte 
|- valign="top"
| 
|         Database Version nvarchar(25) NOT NULL 
|         Database_Version String 
|- valign="top"
| 
|         VersionDate datetime NOT NULL 
|         VersionDate DateTime 
|- valign="top"
| 
|         ModifiedDate datetime NOT NULL 
|         ModifiedDate DateTime 
|- valign="top"
| [[dbo.DatabaseLog_(table)|dbo.DatabaseLog]] [[DatabaseLog_(class)|DatabaseLog]]
| 
| 
          
|- valign="top"
| 
|         DatabaseLogID int NOT NULL Identity
|         DatabaseLogID Int32 
|- valign="top"
| 
|         PostTime datetime NOT NULL 
|         PostTime DateTime 
|- valign="top"
| 
|         DatabaseUser nvarchar(128) NOT NULL 
|         DatabaseUser String 
|- valign="top"
| 
|         Event nvarchar(128) NOT NULL 
|         Event String 
|- valign="top"
| 
|         Schema nvarchar(128)  
|         Schema String 
|- valign="top"
| 
|         Object nvarchar(128)  
|         Object String 
|- valign="top"
| 
|         TSQL nvarchar(max) NOT NULL 
|         TSQL String 
|- valign="top"
| 
|         XmlEvent xml NOT NULL 
|         XmlEvent String 
|- valign="top"
| [[dbo.ErrorLog_(table)|dbo.ErrorLog]] [[ErrorLog_(class)|ErrorLog]]
| 
| 
          
|- valign="top"
| 
|         ErrorLogID int NOT NULL Identity
|         ErrorLogID Int32 
|- valign="top"
| 
|         ErrorTime datetime NOT NULL 
|         ErrorTime DateTime 
|- valign="top"
| 
|         UserName nvarchar(128) NOT NULL 
|         UserName String 
|- valign="top"
| 
|         ErrorNumber int NOT NULL 
|         ErrorNumber Int32 
|- valign="top"
| 
|         ErrorSeverity int  
|         ErrorSeverity Int32 
|- valign="top"
| 
|         ErrorState int  
|         ErrorState Int32 
|- valign="top"
| 
|         ErrorProcedure nvarchar(126)  
|         ErrorProcedure String 
|- valign="top"
| 
|         ErrorLine int  
|         ErrorLine Int32 
|- valign="top"
| 
|         ErrorMessage nvarchar NOT NULL 
|         ErrorMessage String 
|- valign="top"
| [[HumanResources.Department_(table)|HumanResources.Department]] [[Department_(class)|Department]]
| 
| 
          
|- valign="top"
| 
|         DepartmentID smallint NOT NULL Identity
|         DepartmentID Int16 EmployeeDepartmentHistory
|- valign="top"
| 
|         Name nvarchar(50) NOT NULL 
|         Name String 
|- valign="top"
| 
|         GroupName nvarchar(50) NOT NULL 
|         GroupName String 
|- valign="top"
| 
|         ModifiedDate datetime NOT NULL 
|         ModifiedDate DateTime 
|- valign="top"
| [[HumanResources.Employee_(table)|HumanResources.Employee]] [[Employee_(class)|Employee]]
| 
| 
          
|- valign="top"
| 
|         EmployeeID int NOT NULL Identity
|         EmployeeID Int32 Contact
|- valign="top"
| 
|         NationalIDNumber nvarchar(15) NOT NULL 
|         NationalIDNumber String 
|- valign="top"
| 
|         ContactID int NOT NULL 
|           Contact
|- valign="top"
| 
|         LoginID nvarchar(256) NOT NULL 
|         LoginID String 
|- valign="top"
| 
|         ManagerID int  
|           Employee1
|- valign="top"
| 
|         Title nvarchar(50) NOT NULL 
|         Title String 
|- valign="top"
| 
|         BirthDate datetime NOT NULL 
|         BirthDate DateTime 
|- valign="top"
| 
|         MaritalStatus nchar(1) NOT NULL 
|         MaritalStatus String 
|- valign="top"
| 
|         Gender nchar(1) NOT NULL 
|         Gender String 
|- valign="top"
| 
|         HireDate datetime NOT NULL 
|         HireDate DateTime 
|- valign="top"
| 
|         SalariedFlag bit NOT NULL 
|         SalariedFlag Boolean 
|- valign="top"
| 
|         VacationHours smallint NOT NULL 
|         VacationHours Int16 
|- valign="top"
| 
|         SickLeaveHours smallint NOT NULL 
|         SickLeaveHours Int16 
|- valign="top"
| 
|         CurrentFlag bit NOT NULL 
|         CurrentFlag Boolean 
|- valign="top"
| 
|         rowguid uniqueidentifier NOT NULL 
|         rowguid Guid 
|- valign="top"
| 
|         ModifiedDate datetime NOT NULL 
|         ModifiedDate DateTime 
|- valign="top"
| [[HumanResources.EmployeeAddress_(table)|HumanResources.EmployeeAddress]] [[EmployeeAddress_(class)|EmployeeAddress]]
| 
| 
          
|- valign="top"
| 
|         EmployeeID int NOT NULL 
|         EmployeeID Int32 Employee
|- valign="top"
| 
|         AddressID int NOT NULL 
|         AddressID Int32 Employee
|- valign="top"
| 
|         rowguid uniqueidentifier NOT NULL 
|         rowguid Guid 
|- valign="top"
| 
|         ModifiedDate datetime NOT NULL 
|         ModifiedDate DateTime 
|- valign="top"
| [[HumanResources.EmployeeDepartmentHistory_(table)|HumanResources.EmployeeDepartmentHistory]] [[EmployeeDepartmentHistory_(class)|EmployeeDepartmentHistory]]
| 
| 
          
|- valign="top"
| 
|         EmployeeID int NOT NULL 
|         EmployeeID Int32 Department
|- valign="top"
| 
|         DepartmentID smallint NOT NULL 
|         DepartmentID Int16 Department
|- valign="top"
| 
|         ShiftID tinyint NOT NULL 
|         ShiftID Byte Department
|- valign="top"
| 
|         StartDate datetime NOT NULL 
|         StartDate DateTime Department
|- valign="top"
| 
|         EndDate datetime  
|         EndDate DateTime 
|- valign="top"
| 
|         ModifiedDate datetime NOT NULL 
|         ModifiedDate DateTime 
|- valign="top"
| [[HumanResources.EmployeePayHistory_(table)|HumanResources.EmployeePayHistory]] [[EmployeePayHistory_(class)|EmployeePayHistory]]
| 
| 
          
|- valign="top"
| 
|         EmployeeID int NOT NULL 
|         EmployeeID Int32 Employee
|- valign="top"
| 
|         RateChangeDate datetime NOT NULL 
|         RateChangeDate DateTime Employee
|- valign="top"
| 
|         Rate money NOT NULL 
|         Rate Decimal 
|- valign="top"
| 
|         PayFrequency tinyint NOT NULL 
|         PayFrequency Byte 
|- valign="top"
| 
|         ModifiedDate datetime NOT NULL 
|         ModifiedDate DateTime 
|- valign="top"
| [[HumanResources.JobCandidate_(table)|HumanResources.JobCandidate]] [[JobCandidate_(class)|JobCandidate]]
| 
| 
          
|- valign="top"
| 
|         JobCandidateID int NOT NULL Identity
|         JobCandidateID Int32 Employee
|- valign="top"
| 
|         EmployeeID int  
|           Employee
|- valign="top"
| 
|         Resume xml  
|         Resume String 
|- valign="top"
| 
|         ModifiedDate datetime NOT NULL 
|         ModifiedDate DateTime 
|- valign="top"
| [[HumanResources.Shift_(table)|HumanResources.Shift]] [[Shift_(class)|Shift]]
| 
| 
          
|- valign="top"
| 
|         ShiftID tinyint NOT NULL Identity
|         ShiftID Byte EmployeeDepartmentHistory
|- valign="top"
| 
|         Name nvarchar(50) NOT NULL 
|         Name String 
|- valign="top"
| 
|         StartTime datetime NOT NULL 
|         StartTime DateTime 
|- valign="top"
| 
|         EndTime datetime NOT NULL 
|         EndTime DateTime 
|- valign="top"
| 
|         ModifiedDate datetime NOT NULL 
|         ModifiedDate DateTime 
|- valign="top"
| [[Person.Address_(table)|Person.Address]] [[Address_(class)|Address]]
| 
| 
          
|- valign="top"
| 
|         AddressID int NOT NULL Identity
|         AddressID Int32 EmployeeAddress
|- valign="top"
| 
|         AddressLine1 nvarchar(60) NOT NULL 
|         AddressLine1 String 
|- valign="top"
| 
|         AddressLine2 nvarchar(60)  
|         AddressLine2 String 
|- valign="top"
| 
|         City nvarchar(30) NOT NULL 
|         City String 
|- valign="top"
| 
|         StateProvinceID int NOT NULL 
|           StateProvince
|- valign="top"
| 
|         PostalCode nvarchar(15) NOT NULL 
|         PostalCode String 
|- valign="top"
| 
|         rowguid uniqueidentifier NOT NULL 
|         rowguid Guid 
|- valign="top"
| 
|         ModifiedDate datetime NOT NULL 
|         ModifiedDate DateTime 
|- valign="top"
| [[Person.AddressType_(table)|Person.AddressType]] [[AddressType_(class)|AddressType]]
| 
| 
          
|- valign="top"
| 
|         AddressTypeID int NOT NULL Identity
|         AddressTypeID Int32 CustomerAddress
|- valign="top"
| 
|         Name nvarchar(50) NOT NULL 
|         Name String 
|- valign="top"
| 
|         rowguid uniqueidentifier NOT NULL 
|         rowguid Guid 
|- valign="top"
| 
|         ModifiedDate datetime NOT NULL 
|         ModifiedDate DateTime 
|- valign="top"
| [[Person.Contact_(table)|Person.Contact]] [[Contact_(class)|Contact]]
| 
| 
          
|- valign="top"
| 
|         ContactID int NOT NULL Identity
|         ContactID Int32 Employee
|- valign="top"
| 
|         NameStyle bit NOT NULL 
|         NameStyle Boolean 
|- valign="top"
| 
|         Title nvarchar(8)  
|         Title String 
|- valign="top"
| 
|         FirstName nvarchar(50) NOT NULL 
|         FirstName String 
|- valign="top"
| 
|         MiddleName nvarchar(50)  
|         MiddleName String 
|- valign="top"
| 
|         LastName nvarchar(50) NOT NULL 
|         LastName String 
|- valign="top"
| 
|         Suffix nvarchar(10)  
|         Suffix String 
|- valign="top"
| 
|         EmailAddress nvarchar(50)  
|         EmailAddress String 
|- valign="top"
| 
|         EmailPromotion int NOT NULL 
|         EmailPromotion Int32 
|- valign="top"
| 
|         Phone nvarchar(25)  
|         Phone String 
|- valign="top"
| 
|         PasswordHash varchar(128) NOT NULL 
|         PasswordHash String 
|- valign="top"
| 
|         PasswordSalt varchar(10) NOT NULL 
|         PasswordSalt String 
|- valign="top"
| 
|         AdditionalContactInfo xml  
|         AdditionalContactInfo String 
|- valign="top"
| 
|         rowguid uniqueidentifier NOT NULL 
|         rowguid Guid 
|- valign="top"
| 
|         ModifiedDate datetime NOT NULL 
|         ModifiedDate DateTime 
|- valign="top"
| [[Person.ContactType_(table)|Person.ContactType]] [[ContactType_(class)|ContactType]]
| 
| 
          
|- valign="top"
| 
|         ContactTypeID int NOT NULL Identity
|         ContactTypeID Int32 StoreContact
|- valign="top"
| 
|         Name nvarchar(50) NOT NULL 
|         Name String 
|- valign="top"
| 
|         ModifiedDate datetime NOT NULL 
|         ModifiedDate DateTime 
|- valign="top"
| [[Person.CountryRegion_(table)|Person.CountryRegion]] [[CountryRegion_(class)|CountryRegion]]
| 
| 
          
|- valign="top"
| 
|         CountryRegionCode nvarchar(3) NOT NULL 
|         CountryRegionCode String CountryRegionCurrency
|- valign="top"
| 
|         Name nvarchar(50) NOT NULL 
|         Name String 
|- valign="top"
| 
|         ModifiedDate datetime NOT NULL 
|         ModifiedDate DateTime 
|- valign="top"
| [[Person.StateProvince_(table)|Person.StateProvince]] [[StateProvince_(class)|StateProvince]]
| 
| 
          
|- valign="top"
| 
|         StateProvinceID int NOT NULL Identity
|         StateProvinceID Int32 Address
|- valign="top"
| 
|         StateProvinceCode nchar(3) NOT NULL 
|         StateProvinceCode String 
|- valign="top"
| 
|         CountryRegionCode nvarchar(3) NOT NULL 
|           CountryRegion
|- valign="top"
| 
|         IsOnlyStateProvinceFlag bit NOT NULL 
|         IsOnlyStateProvinceFlag Boolean 
|- valign="top"
| 
|         Name nvarchar(50) NOT NULL 
|         Name String 
|- valign="top"
| 
|         TerritoryID int NOT NULL 
|           SalesTerritory
|- valign="top"
| 
|         rowguid uniqueidentifier NOT NULL 
|         rowguid Guid 
|- valign="top"
| 
|         ModifiedDate datetime NOT NULL 
|         ModifiedDate DateTime 
|- valign="top"
| [[Production.BillOfMaterials_(table)|Production.BillOfMaterials]] [[BillOfMaterials_(class)|BillOfMaterials]]
| 
| 
          
|- valign="top"
| 
|         BillOfMaterialsID int NOT NULL Identity
|         BillOfMaterialsID Int32 Product
|- valign="top"
| 
|         ProductAssemblyID int  
|           Product1
|- valign="top"
| 
|         ComponentID int NOT NULL 
|           Product
|- valign="top"
| 
|         StartDate datetime NOT NULL 
|         StartDate DateTime 
|- valign="top"
| 
|         EndDate datetime  
|         EndDate DateTime 
|- valign="top"
| 
|         UnitMeasureCode nchar(3) NOT NULL 
|           UnitMeasure
|- valign="top"
| 
|         BOMLevel smallint NOT NULL 
|         BOMLevel Int16 
|- valign="top"
| 
|         PerAssemblyQty decimal NOT NULL 
|         PerAssemblyQty Decimal 
|- valign="top"
| 
|         ModifiedDate datetime NOT NULL 
|         ModifiedDate DateTime 
|- valign="top"
| [[Production.Culture_(table)|Production.Culture]] [[Culture_(class)|Culture]]
| 
| 
          
|- valign="top"
| 
|         CultureID nchar(6) NOT NULL 
|         CultureID String ProductModelProductDescriptionCulture
|- valign="top"
| 
|         Name nvarchar(50) NOT NULL 
|         Name String 
|- valign="top"
| 
|         ModifiedDate datetime NOT NULL 
|         ModifiedDate DateTime 
|- valign="top"
| [[Production.Document_(table)|Production.Document]] [[Document_(class)|Document]]
| 
| 
          
|- valign="top"
| 
|         DocumentID int NOT NULL Identity
|         DocumentID Int32 ProductDocument
|- valign="top"
| 
|         Title nvarchar(50) NOT NULL 
|         Title String 
|- valign="top"
| 
|         FileName nvarchar(400) NOT NULL 
|         FileName String 
|- valign="top"
| 
|         FileExtension nvarchar(8) NOT NULL 
|         FileExtension String 
|- valign="top"
| 
|         Revision nchar(5) NOT NULL 
|         Revision String 
|- valign="top"
| 
|         ChangeNumber int NOT NULL 
|         ChangeNumber Int32 
|- valign="top"
| 
|         Status tinyint NOT NULL 
|         Status Byte 
|- valign="top"
| 
|         DocumentSummary nvarchar(max)  
|         DocumentSummary String 
|- valign="top"
| 
|         Document varbinary(max)  
|         Document1 Binary 
|- valign="top"
| 
|         ModifiedDate datetime NOT NULL 
|         ModifiedDate DateTime 
|- valign="top"
| [[Production.Illustration_(table)|Production.Illustration]] [[Illustration_(class)|Illustration]]
| 
| 
          
|- valign="top"
| 
|         IllustrationID int NOT NULL Identity
|         IllustrationID Int32 ProductModelIllustration
|- valign="top"
| 
|         Diagram xml  
|         Diagram String 
|- valign="top"
| 
|         ModifiedDate datetime NOT NULL 
|         ModifiedDate DateTime 
|- valign="top"
| [[Production.Location_(table)|Production.Location]] [[Location_(class)|Location]]
| 
| 
          
|- valign="top"
| 
|         LocationID smallint NOT NULL Identity
|         LocationID Int16 ProductInventory
|- valign="top"
| 
|         Name nvarchar(50) NOT NULL 
|         Name String 
|- valign="top"
| 
|         CostRate smallmoney NOT NULL 
|         CostRate Decimal 
|- valign="top"
| 
|         Availability decimal NOT NULL 
|         Availability Decimal 
|- valign="top"
| 
|         ModifiedDate datetime NOT NULL 
|         ModifiedDate DateTime 
|- valign="top"
| [[Production.Product_(table)|Production.Product]] [[Product_(class)|Product]]
| 
| 
          
|- valign="top"
| 
|         ProductID int NOT NULL Identity
|         ProductID Int32 ProductModel
|- valign="top"
| 
|         Name nvarchar(50) NOT NULL 
|         Name String 
|- valign="top"
| 
|         ProductNumber nvarchar(25) NOT NULL 
|         ProductNumber String 
|- valign="top"
| 
|         MakeFlag bit NOT NULL 
|         MakeFlag Boolean 
|- valign="top"
| 
|         FinishedGoodsFlag bit NOT NULL 
|         FinishedGoodsFlag Boolean 
|- valign="top"
| 
|         Color nvarchar(15)  
|         Color String 
|- valign="top"
| 
|         SafetyStockLevel smallint NOT NULL 
|         SafetyStockLevel Int16 
|- valign="top"
| 
|         ReorderPoint smallint NOT NULL 
|         ReorderPoint Int16 
|- valign="top"
| 
|         StandardCost money NOT NULL 
|         StandardCost Decimal 
|- valign="top"
| 
|         ListPrice money NOT NULL 
|         ListPrice Decimal 
|- valign="top"
| 
|         Size nvarchar(5)  
|         Size String 
|- valign="top"
| 
|         SizeUnitMeasureCode nchar(3)  
|           UnitMeasure
|- valign="top"
| 
|         WeightUnitMeasureCode nchar(3)  
|           UnitMeasure1
|- valign="top"
| 
|         Weight decimal  
|         Weight Decimal 
|- valign="top"
| 
|         DaysToManufacture int NOT NULL 
|         DaysToManufacture Int32 
|- valign="top"
| 
|         ProductLine nchar(2)  
|         ProductLine String 
|- valign="top"
| 
|         Class nchar(2)  
|         Class String 
|- valign="top"
| 
|         Style nchar(2)  
|         Style String 
|- valign="top"
| 
|         ProductSubcategoryID int  
|           ProductSubcategory
|- valign="top"
| 
|         ProductModelID int  
|           ProductModel
|- valign="top"
| 
|         SellStartDate datetime NOT NULL 
|         SellStartDate DateTime 
|- valign="top"
| 
|         SellEndDate datetime  
|         SellEndDate DateTime 
|- valign="top"
| 
|         DiscontinuedDate datetime  
|         DiscontinuedDate DateTime 
|- valign="top"
| 
|         rowguid uniqueidentifier NOT NULL 
|         rowguid Guid 
|- valign="top"
| 
|         ModifiedDate datetime NOT NULL 
|         ModifiedDate DateTime 
|- valign="top"
| [[Production.ProductCategory_(table)|Production.ProductCategory]] [[ProductCategory_(class)|ProductCategory]]
| 
| 
          
|- valign="top"
| 
|         ProductCategoryID int NOT NULL Identity
|         ProductCategoryID Int32 ProductSubcategory
|- valign="top"
| 
|         Name nvarchar(50) NOT NULL 
|         Name String 
|- valign="top"
| 
|         rowguid uniqueidentifier NOT NULL 
|         rowguid Guid 
|- valign="top"
| 
|         ModifiedDate datetime NOT NULL 
|         ModifiedDate DateTime 
|- valign="top"
| [[Production.ProductCostHistory_(table)|Production.ProductCostHistory]] [[ProductCostHistory_(class)|ProductCostHistory]]
| 
| 
          
|- valign="top"
| 
|         ProductID int NOT NULL 
|         ProductID Int32 Product
|- valign="top"
| 
|         StartDate datetime NOT NULL 
|         StartDate DateTime Product
|- valign="top"
| 
|         EndDate datetime  
|         EndDate DateTime 
|- valign="top"
| 
|         StandardCost money NOT NULL 
|         StandardCost Decimal 
|- valign="top"
| 
|         ModifiedDate datetime NOT NULL 
|         ModifiedDate DateTime 
|- valign="top"
| [[Production.ProductDescription_(table)|Production.ProductDescription]] [[ProductDescription_(class)|ProductDescription]]
| 
| 
          
|- valign="top"
| 
|         ProductDescriptionID int NOT NULL Identity
|         ProductDescriptionID Int32 ProductModelProductDescriptionCulture
|- valign="top"
| 
|         Description nvarchar(400) NOT NULL 
|         Description String 
|- valign="top"
| 
|         rowguid uniqueidentifier NOT NULL 
|         rowguid Guid 
|- valign="top"
| 
|         ModifiedDate datetime NOT NULL 
|         ModifiedDate DateTime 
|- valign="top"
| [[Production.ProductDocument_(table)|Production.ProductDocument]] [[ProductDocument_(class)|ProductDocument]]
| 
| 
          
|- valign="top"
| 
|         ProductID int NOT NULL 
|         ProductID Int32 Document
|- valign="top"
| 
|         DocumentID int NOT NULL 
|         DocumentID Int32 Document
|- valign="top"
| 
|         ModifiedDate datetime NOT NULL 
|         ModifiedDate DateTime 
|- valign="top"
| [[Production.ProductInventory_(table)|Production.ProductInventory]] [[ProductInventory_(class)|ProductInventory]]
| 
| 
          
|- valign="top"
| 
|         ProductID int NOT NULL 
|         ProductID Int32 Location
|- valign="top"
| 
|         LocationID smallint NOT NULL 
|         LocationID Int16 Location
|- valign="top"
| 
|         Shelf nvarchar(10) NOT NULL 
|         Shelf String 
|- valign="top"
| 
|         Bin tinyint NOT NULL 
|         Bin Byte 
|- valign="top"
| 
|         Quantity smallint NOT NULL 
|         Quantity Int16 
|- valign="top"
| 
|         rowguid uniqueidentifier NOT NULL 
|         rowguid Guid 
|- valign="top"
| 
|         ModifiedDate datetime NOT NULL 
|         ModifiedDate DateTime 
|- valign="top"
| [[Production.ProductListPriceHistory_(table)|Production.ProductListPriceHistory]] [[ProductListPriceHistory_(class)|ProductListPriceHistory]]
| 
| 
          
|- valign="top"
| 
|         ProductID int NOT NULL 
|         ProductID Int32 Product
|- valign="top"
| 
|         StartDate datetime NOT NULL 
|         StartDate DateTime Product
|- valign="top"
| 
|         EndDate datetime  
|         EndDate DateTime 
|- valign="top"
| 
|         ListPrice money NOT NULL 
|         ListPrice Decimal 
|- valign="top"
| 
|         ModifiedDate datetime NOT NULL 
|         ModifiedDate DateTime 
|- valign="top"
| [[Production.ProductModel_(table)|Production.ProductModel]] [[ProductModel_(class)|ProductModel]]
| 
| 
          
|- valign="top"
| 
|         ProductModelID int NOT NULL Identity
|         ProductModelID Int32 Product
|- valign="top"
| 
|         Name nvarchar(50) NOT NULL 
|         Name String 
|- valign="top"
| 
|         CatalogDescription xml  
|         CatalogDescription String 
|- valign="top"
| 
|         Instructions xml  
|         Instructions String 
|- valign="top"
| 
|         rowguid uniqueidentifier NOT NULL 
|         rowguid Guid 
|- valign="top"
| 
|         ModifiedDate datetime NOT NULL 
|         ModifiedDate DateTime 
|- valign="top"
| [[Production.ProductModelIllustration_(table)|Production.ProductModelIllustration]] [[ProductModelIllustration_(class)|ProductModelIllustration]]
| 
| 
          
|- valign="top"
| 
|         ProductModelID int NOT NULL 
|         ProductModelID Int32 Illustration
|- valign="top"
| 
|         IllustrationID int NOT NULL 
|         IllustrationID Int32 Illustration
|- valign="top"
| 
|         ModifiedDate datetime NOT NULL 
|         ModifiedDate DateTime 
|- valign="top"
| [[Production.ProductModelProductDescriptionCulture_(table)|Production.ProductModelProductDescriptionCulture]] [[ProductModelProductDescriptionCulture_(class)|ProductModelProductDescriptionCulture]]
| 
| 
          
|- valign="top"
| 
|         ProductModelID int NOT NULL 
|         ProductModelID Int32 Culture
|- valign="top"
| 
|         ProductDescriptionID int NOT NULL 
|         ProductDescriptionID Int32 Culture
|- valign="top"
| 
|         CultureID nchar(6) NOT NULL 
|         CultureID String Culture
|- valign="top"
| 
|         ModifiedDate datetime NOT NULL 
|         ModifiedDate DateTime 
|- valign="top"
| [[Production.ProductPhoto_(table)|Production.ProductPhoto]] [[ProductPhoto_(class)|ProductPhoto]]
| 
| 
          
|- valign="top"
| 
|         ProductPhotoID int NOT NULL Identity
|         ProductPhotoID Int32 ProductProductPhoto
|- valign="top"
| 
|         ThumbNailPhoto varbinary(max)  
|         ThumbNailPhoto Binary 
|- valign="top"
| 
|         ThumbnailPhotoFileName nvarchar(50)  
|         ThumbnailPhotoFileName String 
|- valign="top"
| 
|         LargePhoto varbinary(max)  
|         LargePhoto Binary 
|- valign="top"
| 
|         LargePhotoFileName nvarchar(50)  
|         LargePhotoFileName String 
|- valign="top"
| 
|         ModifiedDate datetime NOT NULL 
|         ModifiedDate DateTime 
|- valign="top"
| [[Production.ProductProductPhoto_(table)|Production.ProductProductPhoto]] [[ProductProductPhoto_(class)|ProductProductPhoto]]
| 
| 
          
|- valign="top"
| 
|         ProductID int NOT NULL 
|         ProductID Int32 Product
|- valign="top"
| 
|         ProductPhotoID int NOT NULL 
|         ProductPhotoID Int32 Product
|- valign="top"
| 
|         Primary bit NOT NULL 
|         Primary Boolean 
|- valign="top"
| 
|         ModifiedDate datetime NOT NULL 
|         ModifiedDate DateTime 
|- valign="top"
| [[Production.ProductReview_(table)|Production.ProductReview]] [[ProductReview_(class)|ProductReview]]
| 
| 
          
|- valign="top"
| 
|         ProductReviewID int NOT NULL Identity
|         ProductReviewID Int32 Product
|- valign="top"
| 
|         ProductID int NOT NULL 
|           Product
|- valign="top"
| 
|         ReviewerName nvarchar(50) NOT NULL 
|         ReviewerName String 
|- valign="top"
| 
|         ReviewDate datetime NOT NULL 
|         ReviewDate DateTime 
|- valign="top"
| 
|         EmailAddress nvarchar(50) NOT NULL 
|         EmailAddress String 
|- valign="top"
| 
|         Rating int NOT NULL 
|         Rating Int32 
|- valign="top"
| 
|         Comments nvarchar(3850)  
|         Comments String 
|- valign="top"
| 
|         ModifiedDate datetime NOT NULL 
|         ModifiedDate DateTime 
|- valign="top"
| [[Production.ProductSubcategory_(table)|Production.ProductSubcategory]] [[ProductSubcategory_(class)|ProductSubcategory]]
| 
| 
          
|- valign="top"
| 
|         ProductSubcategoryID int NOT NULL Identity
|         ProductSubcategoryID Int32 Product
|- valign="top"
| 
|         ProductCategoryID int NOT NULL 
|           ProductCategory
|- valign="top"
| 
|         Name nvarchar(50) NOT NULL 
|         Name String 
|- valign="top"
| 
|         rowguid uniqueidentifier NOT NULL 
|         rowguid Guid 
|- valign="top"
| 
|         ModifiedDate datetime NOT NULL 
|         ModifiedDate DateTime 
|- valign="top"
| [[Production.ScrapReason_(table)|Production.ScrapReason]] [[ScrapReason_(class)|ScrapReason]]
| 
| 
          
|- valign="top"
| 
|         ScrapReasonID smallint NOT NULL Identity
|         ScrapReasonID Int16 WorkOrder
|- valign="top"
| 
|         Name nvarchar(50) NOT NULL 
|         Name String 
|- valign="top"
| 
|         ModifiedDate datetime NOT NULL 
|         ModifiedDate DateTime 
|- valign="top"
| [[Production.TransactionHistory_(table)|Production.TransactionHistory]] [[TransactionHistory_(class)|TransactionHistory]]
| 
| 
          
|- valign="top"
| 
|         TransactionID int NOT NULL Identity
|         TransactionID Int32 Product
|- valign="top"
| 
|         ProductID int NOT NULL 
|           Product
|- valign="top"
| 
|         ReferenceOrderID int NOT NULL 
|         ReferenceOrderID Int32 
|- valign="top"
| 
|         ReferenceOrderLineID int NOT NULL 
|         ReferenceOrderLineID Int32 
|- valign="top"
| 
|         TransactionDate datetime NOT NULL 
|         TransactionDate DateTime 
|- valign="top"
| 
|         TransactionType nchar(1) NOT NULL 
|         TransactionType String 
|- valign="top"
| 
|         Quantity int NOT NULL 
|         Quantity Int32 
|- valign="top"
| 
|         ActualCost money NOT NULL 
|         ActualCost Decimal 
|- valign="top"
| 
|         ModifiedDate datetime NOT NULL 
|         ModifiedDate DateTime 
|- valign="top"
| [[Production.TransactionHistoryArchive_(table)|Production.TransactionHistoryArchive]] [[TransactionHistoryArchive_(class)|TransactionHistoryArchive]]
| 
| 
          
|- valign="top"
| 
|         TransactionID int NOT NULL 
|         TransactionID Int32 
|- valign="top"
| 
|         ProductID int NOT NULL 
|         ProductID Int32 
|- valign="top"
| 
|         ReferenceOrderID int NOT NULL 
|         ReferenceOrderID Int32 
|- valign="top"
| 
|         ReferenceOrderLineID int NOT NULL 
|         ReferenceOrderLineID Int32 
|- valign="top"
| 
|         TransactionDate datetime NOT NULL 
|         TransactionDate DateTime 
|- valign="top"
| 
|         TransactionType nchar(1) NOT NULL 
|         TransactionType String 
|- valign="top"
| 
|         Quantity int NOT NULL 
|         Quantity Int32 
|- valign="top"
| 
|         ActualCost money NOT NULL 
|         ActualCost Decimal 
|- valign="top"
| 
|         ModifiedDate datetime NOT NULL 
|         ModifiedDate DateTime 
|- valign="top"
| [[Production.UnitMeasure_(table)|Production.UnitMeasure]] [[UnitMeasure_(class)|UnitMeasure]]
| 
| 
          
|- valign="top"
| 
|         UnitMeasureCode nchar(3) NOT NULL 
|         UnitMeasureCode String BillOfMaterials
|- valign="top"
| 
|         Name nvarchar(50) NOT NULL 
|         Name String 
|- valign="top"
| 
|         ModifiedDate datetime NOT NULL 
|         ModifiedDate DateTime 
|- valign="top"
| [[Production.WorkOrder_(table)|Production.WorkOrder]] [[WorkOrder_(class)|WorkOrder]]
| 
| 
          
|- valign="top"
| 
|         WorkOrderID int NOT NULL Identity
|         WorkOrderID Int32 Product
|- valign="top"
| 
|         ProductID int NOT NULL 
|           Product
|- valign="top"
| 
|         OrderQty int NOT NULL 
|         OrderQty Int32 
|- valign="top"
| 
|         StockedQty int NOT NULL Computed
|         StockedQty Int32 
|- valign="top"
| 
|         ScrappedQty smallint NOT NULL 
|         ScrappedQty Int16 
|- valign="top"
| 
|         StartDate datetime NOT NULL 
|         StartDate DateTime 
|- valign="top"
| 
|         EndDate datetime  
|         EndDate DateTime 
|- valign="top"
| 
|         DueDate datetime NOT NULL 
|         DueDate DateTime 
|- valign="top"
| 
|         ScrapReasonID smallint  
|           ScrapReason
|- valign="top"
| 
|         ModifiedDate datetime NOT NULL 
|         ModifiedDate DateTime 
|- valign="top"
| [[Production.WorkOrderRouting_(table)|Production.WorkOrderRouting]] [[WorkOrderRouting_(class)|WorkOrderRouting]]
| 
| 
          
|- valign="top"
| 
|         WorkOrderID int NOT NULL 
|         WorkOrderID Int32 Location
|- valign="top"
| 
|         ProductID int NOT NULL 
|         ProductID Int32 Location
|- valign="top"
| 
|         OperationSequence smallint NOT NULL 
|         OperationSequence Int16 Location
|- valign="top"
| 
|         LocationID smallint NOT NULL 
|           Location
|- valign="top"
| 
|         ScheduledStartDate datetime NOT NULL 
|         ScheduledStartDate DateTime 
|- valign="top"
| 
|         ScheduledEndDate datetime NOT NULL 
|         ScheduledEndDate DateTime 
|- valign="top"
| 
|         ActualStartDate datetime  
|         ActualStartDate DateTime 
|- valign="top"
| 
|         ActualEndDate datetime  
|         ActualEndDate DateTime 
|- valign="top"
| 
|         ActualResourceHrs decimal  
|         ActualResourceHrs Decimal 
|- valign="top"
| 
|         PlannedCost money NOT NULL 
|         PlannedCost Decimal 
|- valign="top"
| 
|         ActualCost money  
|         ActualCost Decimal 
|- valign="top"
| 
|         ModifiedDate datetime NOT NULL 
|         ModifiedDate DateTime 
|- valign="top"
| [[Purchasing.ProductVendor_(table)|Purchasing.ProductVendor]] [[ProductVendor_(class)|ProductVendor]]
| 
| 
          
|- valign="top"
| 
|         ProductID int NOT NULL 
|         ProductID Int32 Product
|- valign="top"
| 
|         VendorID int NOT NULL 
|         VendorID Int32 Product
|- valign="top"
| 
|         AverageLeadTime int NOT NULL 
|         AverageLeadTime Int32 
|- valign="top"
| 
|         StandardPrice money NOT NULL 
|         StandardPrice Decimal 
|- valign="top"
| 
|         LastReceiptCost money  
|         LastReceiptCost Decimal 
|- valign="top"
| 
|         LastReceiptDate datetime  
|         LastReceiptDate DateTime 
|- valign="top"
| 
|         MinOrderQty int NOT NULL 
|         MinOrderQty Int32 
|- valign="top"
| 
|         MaxOrderQty int NOT NULL 
|         MaxOrderQty Int32 
|- valign="top"
| 
|         OnOrderQty int  
|         OnOrderQty Int32 
|- valign="top"
| 
|         UnitMeasureCode nchar(3) NOT NULL 
|           UnitMeasure
|- valign="top"
| 
|         ModifiedDate datetime NOT NULL 
|         ModifiedDate DateTime 
|- valign="top"
| [[Purchasing.PurchaseOrderDetail_(table)|Purchasing.PurchaseOrderDetail]] [[PurchaseOrderDetail_(class)|PurchaseOrderDetail]]
| 
| 
          
|- valign="top"
| 
|         PurchaseOrderID int NOT NULL 
|         PurchaseOrderID Int32 Product
|- valign="top"
| 
|         PurchaseOrderDetailID int NOT NULL Identity
|         PurchaseOrderDetailID Int32 Product
|- valign="top"
| 
|         DueDate datetime NOT NULL 
|         DueDate DateTime 
|- valign="top"
| 
|         OrderQty smallint NOT NULL 
|         OrderQty Int16 
|- valign="top"
| 
|         ProductID int NOT NULL 
|           Product
|- valign="top"
| 
|         UnitPrice money NOT NULL 
|         UnitPrice Decimal 
|- valign="top"
| 
|         LineTotal money NOT NULL Computed
|         LineTotal Decimal 
|- valign="top"
| 
|         ReceivedQty decimal NOT NULL 
|         ReceivedQty Decimal 
|- valign="top"
| 
|         RejectedQty decimal NOT NULL 
|         RejectedQty Decimal 
|- valign="top"
| 
|         StockedQty decimal NOT NULL Computed
|         StockedQty Decimal 
|- valign="top"
| 
|         ModifiedDate datetime NOT NULL 
|         ModifiedDate DateTime 
|- valign="top"
| [[Purchasing.PurchaseOrderHeader_(table)|Purchasing.PurchaseOrderHeader]] [[PurchaseOrderHeader_(class)|PurchaseOrderHeader]]
| 
| 
          
|- valign="top"
| 
|         PurchaseOrderID int NOT NULL Identity
|         PurchaseOrderID Int32 Employee
|- valign="top"
| 
|         RevisionNumber tinyint NOT NULL 
|         RevisionNumber Byte 
|- valign="top"
| 
|         Status tinyint NOT NULL 
|         Status Byte 
|- valign="top"
| 
|         EmployeeID int NOT NULL 
|           Employee
|- valign="top"
| 
|         VendorID int NOT NULL 
|           Vendor
|- valign="top"
| 
|         ShipMethodID int NOT NULL 
|           ShipMethod
|- valign="top"
| 
|         OrderDate datetime NOT NULL 
|         OrderDate DateTime 
|- valign="top"
| 
|         ShipDate datetime  
|         ShipDate DateTime 
|- valign="top"
| 
|         SubTotal money NOT NULL 
|         SubTotal Decimal 
|- valign="top"
| 
|         TaxAmt money NOT NULL 
|         TaxAmt Decimal 
|- valign="top"
| 
|         Freight money NOT NULL 
|         Freight Decimal 
|- valign="top"
| 
|         TotalDue money NOT NULL Computed
|         TotalDue Decimal 
|- valign="top"
| 
|         ModifiedDate datetime NOT NULL 
|         ModifiedDate DateTime 
|- valign="top"
| [[Purchasing.ShipMethod_(table)|Purchasing.ShipMethod]] [[ShipMethod_(class)|ShipMethod]]
| 
| 
          
|- valign="top"
| 
|         ShipMethodID int NOT NULL Identity
|         ShipMethodID Int32 PurchaseOrderHeader
|- valign="top"
| 
|         Name nvarchar(50) NOT NULL 
|         Name String 
|- valign="top"
| 
|         ShipBase money NOT NULL 
|         ShipBase Decimal 
|- valign="top"
| 
|         ShipRate money NOT NULL 
|         ShipRate Decimal 
|- valign="top"
| 
|         rowguid uniqueidentifier NOT NULL 
|         rowguid Guid 
|- valign="top"
| 
|         ModifiedDate datetime NOT NULL 
|         ModifiedDate DateTime 
|- valign="top"
| [[Purchasing.Vendor_(table)|Purchasing.Vendor]] [[Vendor_(class)|Vendor]]
| 
| 
          
|- valign="top"
| 
|         VendorID int NOT NULL Identity
|         VendorID Int32 ProductVendor
|- valign="top"
| 
|         AccountNumber nvarchar(15) NOT NULL 
|         AccountNumber String 
|- valign="top"
| 
|         Name nvarchar(50) NOT NULL 
|         Name String 
|- valign="top"
| 
|         CreditRating tinyint NOT NULL 
|         CreditRating Byte 
|- valign="top"
| 
|         PreferredVendorStatus bit NOT NULL 
|         PreferredVendorStatus Boolean 
|- valign="top"
| 
|         ActiveFlag bit NOT NULL 
|         ActiveFlag Boolean 
|- valign="top"
| 
|         PurchasingWebServiceURL nvarchar(1024)  
|         PurchasingWebServiceURL String 
|- valign="top"
| 
|         ModifiedDate datetime NOT NULL 
|         ModifiedDate DateTime 
|- valign="top"
| [[Purchasing.VendorAddress_(table)|Purchasing.VendorAddress]] [[VendorAddress_(class)|VendorAddress]]
| 
| 
          
|- valign="top"
| 
|         VendorID int NOT NULL 
|         VendorID Int32 Address
|- valign="top"
| 
|         AddressID int NOT NULL 
|         AddressID Int32 Address
|- valign="top"
| 
|         AddressTypeID int NOT NULL 
|           AddressType
|- valign="top"
| 
|         ModifiedDate datetime NOT NULL 
|         ModifiedDate DateTime 
|- valign="top"
| [[Purchasing.VendorContact_(table)|Purchasing.VendorContact]] [[VendorContact_(class)|VendorContact]]
| 
| 
          
|- valign="top"
| 
|         VendorID int NOT NULL 
|         VendorID Int32 Contact
|- valign="top"
| 
|         ContactID int NOT NULL 
|         ContactID Int32 Contact
|- valign="top"
| 
|         ContactTypeID int NOT NULL 
|           ContactType
|- valign="top"
| 
|         ModifiedDate datetime NOT NULL 
|         ModifiedDate DateTime 
|- valign="top"
| [[Sales.ContactCreditCard_(table)|Sales.ContactCreditCard]] [[ContactCreditCard_(class)|ContactCreditCard]]
| 
| 
          
|- valign="top"
| 
|         ContactID int NOT NULL 
|         ContactID Int32 Contact
|- valign="top"
| 
|         CreditCardID int NOT NULL 
|         CreditCardID Int32 Contact
|- valign="top"
| 
|         ModifiedDate datetime NOT NULL 
|         ModifiedDate DateTime 
|- valign="top"
| [[Sales.CountryRegionCurrency_(table)|Sales.CountryRegionCurrency]] [[CountryRegionCurrency_(class)|CountryRegionCurrency]]
| 
| 
          
|- valign="top"
| 
|         CountryRegionCode nvarchar(3) NOT NULL 
|         CountryRegionCode String CountryRegion
|- valign="top"
| 
|         CurrencyCode nchar(3) NOT NULL 
|         CurrencyCode String CountryRegion
|- valign="top"
| 
|         ModifiedDate datetime NOT NULL 
|         ModifiedDate DateTime 
|- valign="top"
| [[Sales.CreditCard_(table)|Sales.CreditCard]] [[CreditCard_(class)|CreditCard]]
| 
| 
          
|- valign="top"
| 
|         CreditCardID int NOT NULL Identity
|         CreditCardID Int32 ContactCreditCard
|- valign="top"
| 
|         CardType nvarchar(50) NOT NULL 
|         CardType String 
|- valign="top"
| 
|         CardNumber nvarchar(25) NOT NULL 
|         CardNumber String 
|- valign="top"
| 
|         ExpMonth tinyint NOT NULL 
|         ExpMonth Byte 
|- valign="top"
| 
|         ExpYear smallint NOT NULL 
|         ExpYear Int16 
|- valign="top"
| 
|         ModifiedDate datetime NOT NULL 
|         ModifiedDate DateTime 
|- valign="top"
| [[Sales.Currency_(table)|Sales.Currency]] [[Currency_(class)|Currency]]
| 
| 
          
|- valign="top"
| 
|         CurrencyCode nchar(3) NOT NULL 
|         CurrencyCode String CountryRegionCurrency
|- valign="top"
| 
|         Name nvarchar(50) NOT NULL 
|         Name String 
|- valign="top"
| 
|         ModifiedDate datetime NOT NULL 
|         ModifiedDate DateTime 
|- valign="top"
| [[Sales.CurrencyRate_(table)|Sales.CurrencyRate]] [[CurrencyRate_(class)|CurrencyRate]]
| 
| 
          
|- valign="top"
| 
|         CurrencyRateID int NOT NULL Identity
|         CurrencyRateID Int32 Currency
|- valign="top"
| 
|         CurrencyRateDate datetime NOT NULL 
|         CurrencyRateDate DateTime 
|- valign="top"
| 
|         FromCurrencyCode nchar(3) NOT NULL 
|           Currency
|- valign="top"
| 
|         ToCurrencyCode nchar(3) NOT NULL 
|           Currency1
|- valign="top"
| 
|         AverageRate money NOT NULL 
|         AverageRate Decimal 
|- valign="top"
| 
|         EndOfDayRate money NOT NULL 
|         EndOfDayRate Decimal 
|- valign="top"
| 
|         ModifiedDate datetime NOT NULL 
|         ModifiedDate DateTime 
|- valign="top"
| [[Sales.Customer_(table)|Sales.Customer]] [[Customer_(class)|Customer]]
| 
| 
          
|- valign="top"
| 
|         CustomerID int NOT NULL Identity
|         CustomerID Int32 SalesTerritory
|- valign="top"
| 
|         TerritoryID int  
|           SalesTerritory
|- valign="top"
| 
|         AccountNumber varchar(10) NOT NULL Computed
|         AccountNumber String 
|- valign="top"
| 
|         CustomerType nchar(1) NOT NULL 
|         CustomerType String 
|- valign="top"
| 
|         rowguid uniqueidentifier NOT NULL 
|         rowguid Guid 
|- valign="top"
| 
|         ModifiedDate datetime NOT NULL 
|         ModifiedDate DateTime 
|- valign="top"
| [[Sales.CustomerAddress_(table)|Sales.CustomerAddress]] [[CustomerAddress_(class)|CustomerAddress]]
| 
| 
          
|- valign="top"
| 
|         CustomerID int NOT NULL 
|         CustomerID Int32 Address
|- valign="top"
| 
|         AddressID int NOT NULL 
|         AddressID Int32 Address
|- valign="top"
| 
|         AddressTypeID int NOT NULL 
|           AddressType
|- valign="top"
| 
|         rowguid uniqueidentifier NOT NULL 
|         rowguid Guid 
|- valign="top"
| 
|         ModifiedDate datetime NOT NULL 
|         ModifiedDate DateTime 
|- valign="top"
| [[Sales.Individual_(table)|Sales.Individual]] [[Individual_(class)|Individual]]
| 
| 
          
|- valign="top"
| 
|         CustomerID int NOT NULL 
|         CustomerID Int32 Contact
|- valign="top"
| 
|         ContactID int NOT NULL 
|           Contact
|- valign="top"
| 
|         Demographics xml  
|         Demographics String 
|- valign="top"
| 
|         ModifiedDate datetime NOT NULL 
|         ModifiedDate DateTime 
|- valign="top"
| [[Sales.SalesOrderDetail_(table)|Sales.SalesOrderDetail]] [[SalesOrderDetail_(class)|SalesOrderDetail]]
| 
| 
          
|- valign="top"
| 
|         SalesOrderID int NOT NULL 
|         SalesOrderID Int32 SalesOrderHeader
|- valign="top"
| 
|         SalesOrderDetailID int NOT NULL Identity
|         SalesOrderDetailID Int32 SalesOrderHeader
|- valign="top"
| 
|         CarrierTrackingNumber nvarchar(25)  
|         CarrierTrackingNumber String 
|- valign="top"
| 
|         OrderQty smallint NOT NULL 
|         OrderQty Int16 
|- valign="top"
| 
|         ProductID int NOT NULL 
|           SpecialOfferProduct
|- valign="top"
| 
|         SpecialOfferID int NOT NULL 
|           SpecialOfferProduct
|- valign="top"
| 
|         UnitPrice money NOT NULL 
|         UnitPrice Decimal 
|- valign="top"
| 
|         UnitPriceDiscount money NOT NULL 
|         UnitPriceDiscount Decimal 
|- valign="top"
| 
|         LineTotal numeric NOT NULL Computed
|         LineTotal Decimal 
|- valign="top"
| 
|         rowguid uniqueidentifier NOT NULL 
|         rowguid Guid 
|- valign="top"
| 
|         ModifiedDate datetime NOT NULL 
|         ModifiedDate DateTime 
|- valign="top"
| [[Sales.SalesOrderHeader_(table)|Sales.SalesOrderHeader]] [[SalesOrderHeader_(class)|SalesOrderHeader]]
| 
| 
          
|- valign="top"
| 
|         SalesOrderID int NOT NULL Identity
|         SalesOrderID Int32 Address
|- valign="top"
| 
|         RevisionNumber tinyint NOT NULL 
|         RevisionNumber Byte 
|- valign="top"
| 
|         OrderDate datetime NOT NULL 
|         OrderDate DateTime 
|- valign="top"
| 
|         DueDate datetime NOT NULL 
|         DueDate DateTime 
|- valign="top"
| 
|         ShipDate datetime  
|         ShipDate DateTime 
|- valign="top"
| 
|         Status tinyint NOT NULL 
|         Status Byte 
|- valign="top"
| 
|         OnlineOrderFlag bit NOT NULL 
|         OnlineOrderFlag Boolean 
|- valign="top"
| 
|         SalesOrderNumber nvarchar(25) NOT NULL Computed
|         SalesOrderNumber String 
|- valign="top"
| 
|         PurchaseOrderNumber nvarchar(25)  
|         PurchaseOrderNumber String 
|- valign="top"
| 
|         AccountNumber nvarchar(15)  
|         AccountNumber String 
|- valign="top"
| 
|         CustomerID int NOT NULL 
|           Customer
|- valign="top"
| 
|         ContactID int NOT NULL 
|           Contact
|- valign="top"
| 
|         SalesPersonID int  
|           SalesPerson
|- valign="top"
| 
|         TerritoryID int  
|           SalesTerritory
|- valign="top"
| 
|         BillToAddressID int NOT NULL 
|           Address
|- valign="top"
| 
|         ShipToAddressID int NOT NULL 
|           Address1
|- valign="top"
| 
|         ShipMethodID int NOT NULL 
|           ShipMethod
|- valign="top"
| 
|         CreditCardID int  
|           CreditCard
|- valign="top"
| 
|         CreditCardApprovalCode varchar(15)  
|         CreditCardApprovalCode String 
|- valign="top"
| 
|         CurrencyRateID int  
|           CurrencyRate
|- valign="top"
| 
|         SubTotal money NOT NULL 
|         SubTotal Decimal 
|- valign="top"
| 
|         TaxAmt money NOT NULL 
|         TaxAmt Decimal 
|- valign="top"
| 
|         Freight money NOT NULL 
|         Freight Decimal 
|- valign="top"
| 
|         TotalDue money NOT NULL Computed
|         TotalDue Decimal 
|- valign="top"
| 
|         Comment nvarchar(128)  
|         Comment String 
|- valign="top"
| 
|         rowguid uniqueidentifier NOT NULL 
|         rowguid Guid 
|- valign="top"
| 
|         ModifiedDate datetime NOT NULL 
|         ModifiedDate DateTime 
|- valign="top"
| [[Sales.SalesOrderHeaderSalesReason_(table)|Sales.SalesOrderHeaderSalesReason]] [[SalesOrderHeaderSalesReason_(class)|SalesOrderHeaderSalesReason]]
| 
| 
          
|- valign="top"
| 
|         SalesOrderID int NOT NULL 
|         SalesOrderID Int32 SalesOrderHeader
|- valign="top"
| 
|         SalesReasonID int NOT NULL 
|         SalesReasonID Int32 SalesOrderHeader
|- valign="top"
| 
|         ModifiedDate datetime NOT NULL 
|         ModifiedDate DateTime 
|- valign="top"
| [[Sales.SalesPerson_(table)|Sales.SalesPerson]] [[SalesPerson_(class)|SalesPerson]]
| 
| 
          
|- valign="top"
| 
|         SalesPersonID int NOT NULL 
|         SalesPersonID Int32 Employee
|- valign="top"
| 
|         TerritoryID int  
|           SalesTerritory
|- valign="top"
| 
|         SalesQuota money  
|         SalesQuota Decimal 
|- valign="top"
| 
|         Bonus money NOT NULL 
|         Bonus Decimal 
|- valign="top"
| 
|         CommissionPct smallmoney NOT NULL 
|         CommissionPct Decimal 
|- valign="top"
| 
|         SalesYTD money NOT NULL 
|         SalesYTD Decimal 
|- valign="top"
| 
|         SalesLastYear money NOT NULL 
|         SalesLastYear Decimal 
|- valign="top"
| 
|         rowguid uniqueidentifier NOT NULL 
|         rowguid Guid 
|- valign="top"
| 
|         ModifiedDate datetime NOT NULL 
|         ModifiedDate DateTime 
|- valign="top"
| [[Sales.SalesPersonQuotaHistory_(table)|Sales.SalesPersonQuotaHistory]] [[SalesPersonQuotaHistory_(class)|SalesPersonQuotaHistory]]
| 
| 
          
|- valign="top"
| 
|         SalesPersonID int NOT NULL 
|         SalesPersonID Int32 SalesPerson
|- valign="top"
| 
|         QuotaDate datetime NOT NULL 
|         QuotaDate DateTime SalesPerson
|- valign="top"
| 
|         SalesQuota money NOT NULL 
|         SalesQuota Decimal 
|- valign="top"
| 
|         rowguid uniqueidentifier NOT NULL 
|         rowguid Guid 
|- valign="top"
| 
|         ModifiedDate datetime NOT NULL 
|         ModifiedDate DateTime 
|- valign="top"
| [[Sales.SalesReason_(table)|Sales.SalesReason]] [[SalesReason_(class)|SalesReason]]
| 
| 
          
|- valign="top"
| 
|         SalesReasonID int NOT NULL Identity
|         SalesReasonID Int32 SalesOrderHeaderSalesReason
|- valign="top"
| 
|         Name nvarchar(50) NOT NULL 
|         Name String 
|- valign="top"
| 
|         ReasonType nvarchar(50) NOT NULL 
|         ReasonType String 
|- valign="top"
| 
|         ModifiedDate datetime NOT NULL 
|         ModifiedDate DateTime 
|- valign="top"
| [[Sales.SalesTaxRate_(table)|Sales.SalesTaxRate]] [[SalesTaxRate_(class)|SalesTaxRate]]
| 
| 
          
|- valign="top"
| 
|         SalesTaxRateID int NOT NULL Identity
|         SalesTaxRateID Int32 StateProvince
|- valign="top"
| 
|         StateProvinceID int NOT NULL 
|           StateProvince
|- valign="top"
| 
|         TaxType tinyint NOT NULL 
|         TaxType Byte 
|- valign="top"
| 
|         TaxRate smallmoney NOT NULL 
|         TaxRate Decimal 
|- valign="top"
| 
|         Name nvarchar(50) NOT NULL 
|         Name String 
|- valign="top"
| 
|         rowguid uniqueidentifier NOT NULL 
|         rowguid Guid 
|- valign="top"
| 
|         ModifiedDate datetime NOT NULL 
|         ModifiedDate DateTime 
|- valign="top"
| [[Sales.SalesTerritory_(table)|Sales.SalesTerritory]] [[SalesTerritory_(class)|SalesTerritory]]
| 
| 
          
|- valign="top"
| 
|         TerritoryID int NOT NULL Identity
|         TerritoryID Int32 StateProvince
|- valign="top"
| 
|         Name nvarchar(50) NOT NULL 
|         Name String 
|- valign="top"
| 
|         CountryRegionCode nvarchar(3) NOT NULL 
|         CountryRegionCode String 
|- valign="top"
| 
|         Group nvarchar(50) NOT NULL 
|         Group String 
|- valign="top"
| 
|         SalesYTD money NOT NULL 
|         SalesYTD Decimal 
|- valign="top"
| 
|         SalesLastYear money NOT NULL 
|         SalesLastYear Decimal 
|- valign="top"
| 
|         CostYTD money NOT NULL 
|         CostYTD Decimal 
|- valign="top"
| 
|         CostLastYear money NOT NULL 
|         CostLastYear Decimal 
|- valign="top"
| 
|         rowguid uniqueidentifier NOT NULL 
|         rowguid Guid 
|- valign="top"
| 
|         ModifiedDate datetime NOT NULL 
|         ModifiedDate DateTime 
|- valign="top"
| [[Sales.SalesTerritoryHistory_(table)|Sales.SalesTerritoryHistory]] [[SalesTerritoryHistory_(class)|SalesTerritoryHistory]]
| 
| 
          
|- valign="top"
| 
|         SalesPersonID int NOT NULL 
|         SalesPersonID Int32 SalesPerson
|- valign="top"
| 
|         TerritoryID int NOT NULL 
|         TerritoryID Int32 SalesPerson
|- valign="top"
| 
|         StartDate datetime NOT NULL 
|         StartDate DateTime SalesPerson
|- valign="top"
| 
|         EndDate datetime  
|         EndDate DateTime 
|- valign="top"
| 
|         rowguid uniqueidentifier NOT NULL 
|         rowguid Guid 
|- valign="top"
| 
|         ModifiedDate datetime NOT NULL 
|         ModifiedDate DateTime 
|- valign="top"
| [[Sales.ShoppingCartItem_(table)|Sales.ShoppingCartItem]] [[ShoppingCartItem_(class)|ShoppingCartItem]]
| 
| 
          
|- valign="top"
| 
|         ShoppingCartItemID int NOT NULL Identity
|         ShoppingCartItemID Int32 Product
|- valign="top"
| 
|         ShoppingCartID nvarchar(50) NOT NULL 
|         ShoppingCartID String 
|- valign="top"
| 
|         Quantity int NOT NULL 
|         Quantity Int32 
|- valign="top"
| 
|         ProductID int NOT NULL 
|           Product
|- valign="top"
| 
|         DateCreated datetime NOT NULL 
|         DateCreated DateTime 
|- valign="top"
| 
|         ModifiedDate datetime NOT NULL 
|         ModifiedDate DateTime 
|- valign="top"
| [[Sales.SpecialOffer_(table)|Sales.SpecialOffer]] [[SpecialOffer_(class)|SpecialOffer]]
| 
| 
          
|- valign="top"
| 
|         SpecialOfferID int NOT NULL Identity
|         SpecialOfferID Int32 SpecialOfferProduct
|- valign="top"
| 
|         Description nvarchar(255) NOT NULL 
|         Description String 
|- valign="top"
| 
|         DiscountPct smallmoney NOT NULL 
|         DiscountPct Decimal 
|- valign="top"
| 
|         Type nvarchar(50) NOT NULL 
|         Type String 
|- valign="top"
| 
|         Category nvarchar(50) NOT NULL 
|         Category String 
|- valign="top"
| 
|         StartDate datetime NOT NULL 
|         StartDate DateTime 
|- valign="top"
| 
|         EndDate datetime NOT NULL 
|         EndDate DateTime 
|- valign="top"
| 
|         MinQty int NOT NULL 
|         MinQty Int32 
|- valign="top"
| 
|         MaxQty int  
|         MaxQty Int32 
|- valign="top"
| 
|         rowguid uniqueidentifier NOT NULL 
|         rowguid Guid 
|- valign="top"
| 
|         ModifiedDate datetime NOT NULL 
|         ModifiedDate DateTime 
|- valign="top"
| [[Sales.SpecialOfferProduct_(table)|Sales.SpecialOfferProduct]] [[SpecialOfferProduct_(class)|SpecialOfferProduct]]
| 
| 
          
|- valign="top"
| 
|         SpecialOfferID int NOT NULL 
|         SpecialOfferID Int32 Product
|- valign="top"
| 
|         ProductID int NOT NULL 
|         ProductID Int32 Product
|- valign="top"
| 
|         rowguid uniqueidentifier NOT NULL 
|         rowguid Guid 
|- valign="top"
| 
|         ModifiedDate datetime NOT NULL 
|         ModifiedDate DateTime 
|- valign="top"
| [[Sales.Store_(table)|Sales.Store]] [[Store_(class)|Store]]
| 
| 
          
|- valign="top"
| 
|         CustomerID int NOT NULL 
|         CustomerID Int32 Customer
|- valign="top"
| 
|         Name nvarchar(50) NOT NULL 
|         Name String 
|- valign="top"
| 
|         SalesPersonID int  
|           SalesPerson
|- valign="top"
| 
|         Demographics xml  
|         Demographics String 
|- valign="top"
| 
|         rowguid uniqueidentifier NOT NULL 
|         rowguid Guid 
|- valign="top"
| 
|         ModifiedDate datetime NOT NULL 
|         ModifiedDate DateTime 
|- valign="top"
| [[Sales.StoreContact_(table)|Sales.StoreContact]] [[StoreContact_(class)|StoreContact]]
| 
| 
          
|- valign="top"
| 
|         CustomerID int NOT NULL 
|         CustomerID Int32 Contact
|- valign="top"
| 
|         ContactID int NOT NULL 
|         ContactID Int32 Contact
|- valign="top"
| 
|         ContactTypeID int NOT NULL 
|           ContactType
|- valign="top"
| 
|         rowguid uniqueidentifier NOT NULL 
|         rowguid Guid 
|- valign="top"
| 
|         ModifiedDate datetime NOT NULL 
|         ModifiedDate DateTime 
|- valign="top"
| [[HumanResources.vEmployee_(view)|HumanResources.vEmployee]] [[vEmployee_(class)|vEmployee]]
| 
| 
          
|- valign="top"
| 
|         EmployeeID int NOT NULL 
|         EmployeeID Int32 
|- valign="top"
| 
|         Title nvarchar(8)  
|         Title String 
|- valign="top"
| 
|         FirstName nvarchar(50) NOT NULL 
|         FirstName String 
|- valign="top"
| 
|         MiddleName nvarchar(50)  
|         MiddleName String 
|- valign="top"
| 
|         LastName nvarchar(50) NOT NULL 
|         LastName String 
|- valign="top"
| 
|         Suffix nvarchar(10)  
|         Suffix String 
|- valign="top"
| 
|         JobTitle nvarchar(50) NOT NULL 
|         JobTitle String 
|- valign="top"
| 
|         Phone nvarchar(25)  
|         Phone String 
|- valign="top"
| 
|         EmailAddress nvarchar(50)  
|         EmailAddress String 
|- valign="top"
| 
|         EmailPromotion int NOT NULL 
|         EmailPromotion Int32 
|- valign="top"
| 
|         AddressLine1 nvarchar(60) NOT NULL 
|         AddressLine1 String 
|- valign="top"
| 
|         AddressLine2 nvarchar(60)  
|         AddressLine2 String 
|- valign="top"
| 
|         City nvarchar(30) NOT NULL 
|         City String 
|- valign="top"
| 
|         StateProvinceName nvarchar(50) NOT NULL 
|         StateProvinceName String 
|- valign="top"
| 
|         PostalCode nvarchar(15) NOT NULL 
|         PostalCode String 
|- valign="top"
| 
|         CountryRegionName nvarchar(50) NOT NULL 
|         CountryRegionName String 
|- valign="top"
| 
|         AdditionalContactInfo xml  
|         AdditionalContactInfo String 
|- valign="top"
| [[HumanResources.vEmployeeDepartment_(view)|HumanResources.vEmployeeDepartment]] [[vEmployeeDepartment_(class)|vEmployeeDepartment]]
| 
| 
          
|- valign="top"
| 
|         EmployeeID int NOT NULL 
|         EmployeeID Int32 
|- valign="top"
| 
|         Title nvarchar(8)  
|         Title String 
|- valign="top"
| 
|         FirstName nvarchar(50) NOT NULL 
|         FirstName String 
|- valign="top"
| 
|         MiddleName nvarchar(50)  
|         MiddleName String 
|- valign="top"
| 
|         LastName nvarchar(50) NOT NULL 
|         LastName String 
|- valign="top"
| 
|         Suffix nvarchar(10)  
|         Suffix String 
|- valign="top"
| 
|         JobTitle nvarchar(50) NOT NULL 
|         JobTitle String 
|- valign="top"
| 
|         Department nvarchar(50) NOT NULL 
|         Department String 
|- valign="top"
| 
|         GroupName nvarchar(50) NOT NULL 
|         GroupName String 
|- valign="top"
| 
|         StartDate datetime NOT NULL 
|         StartDate DateTime 
|- valign="top"
| [[HumanResources.vEmployeeDepartmentHistory_(view)|HumanResources.vEmployeeDepartmentHistory]] [[vEmployeeDepartmentHistory_(class)|vEmployeeDepartmentHistory]]
| 
| 
          
|- valign="top"
| 
|         EmployeeID int NOT NULL 
|         EmployeeID Int32 
|- valign="top"
| 
|         Title nvarchar(8)  
|         Title String 
|- valign="top"
| 
|         FirstName nvarchar(50) NOT NULL 
|         FirstName String 
|- valign="top"
| 
|         MiddleName nvarchar(50)  
|         MiddleName String 
|- valign="top"
| 
|         LastName nvarchar(50) NOT NULL 
|         LastName String 
|- valign="top"
| 
|         Suffix nvarchar(10)  
|         Suffix String 
|- valign="top"
| 
|         Shift nvarchar(50) NOT NULL 
|         Shift String 
|- valign="top"
| 
|         Department nvarchar(50) NOT NULL 
|         Department String 
|- valign="top"
| 
|         GroupName nvarchar(50) NOT NULL 
|         GroupName String 
|- valign="top"
| 
|         StartDate datetime NOT NULL 
|         StartDate DateTime 
|- valign="top"
| 
|         EndDate datetime  
|         EndDate DateTime 
|- valign="top"
| [[HumanResources.vJobCandidate_(view)|HumanResources.vJobCandidate]] [[vJobCandidate_(class)|vJobCandidate]]
| 
| 
          
|- valign="top"
| 
|         JobCandidateID int NOT NULL Identity
|         JobCandidateID Int32 
|- valign="top"
| 
|         EmployeeID int  
|         EmployeeID Int32 
|- valign="top"
| 
|         Name.Prefix nvarchar(30)  
|         Name_Prefix String 
|- valign="top"
| 
|         Name.First nvarchar(30)  
|         Name_First String 
|- valign="top"
| 
|         Name.Middle nvarchar(30)  
|         Name_Middle String 
|- valign="top"
| 
|         Name.Last nvarchar(30)  
|         Name_Last String 
|- valign="top"
| 
|         Name.Suffix nvarchar(30)  
|         Name_Suffix String 
|- valign="top"
| 
|         Skills nvarchar(max)  
|         Skills String 
|- valign="top"
| 
|         Addr.Type nvarchar(30)  
|         Addr_Type String 
|- valign="top"
| 
|         Addr.Loc.CountryRegion nvarchar(100)  
|         Addr_Loc_CountryRegion String 
|- valign="top"
| 
|         Addr.Loc.State nvarchar(100)  
|         Addr_Loc_State String 
|- valign="top"
| 
|         Addr.Loc.City nvarchar(100)  
|         Addr_Loc_City String 
|- valign="top"
| 
|         Addr.PostalCode nvarchar(20)  
|         Addr_PostalCode String 
|- valign="top"
| 
|         EMail nvarchar(max)  
|         EMail String 
|- valign="top"
| 
|         WebSite nvarchar(max)  
|         WebSite String 
|- valign="top"
| 
|         ModifiedDate datetime NOT NULL 
|         ModifiedDate DateTime 
|- valign="top"
| [[HumanResources.vJobCandidateEducation_(view)|HumanResources.vJobCandidateEducation]] [[vJobCandidateEducation_(class)|vJobCandidateEducation]]
| 
| 
          
|- valign="top"
| 
|         JobCandidateID int NOT NULL Identity
|         JobCandidateID Int32 
|- valign="top"
| 
|         Edu.Level nvarchar(max)  
|         Edu_Level String 
|- valign="top"
| 
|         Edu.StartDate datetime  
|         Edu_StartDate DateTime 
|- valign="top"
| 
|         Edu.EndDate datetime  
|         Edu_EndDate DateTime 
|- valign="top"
| 
|         Edu.Degree nvarchar(50)  
|         Edu_Degree String 
|- valign="top"
| 
|         Edu.Major nvarchar(50)  
|         Edu_Major String 
|- valign="top"
| 
|         Edu.Minor nvarchar(50)  
|         Edu_Minor String 
|- valign="top"
| 
|         Edu.GPA nvarchar(5)  
|         Edu_GPA String 
|- valign="top"
| 
|         Edu.GPAScale nvarchar(5)  
|         Edu_GPAScale String 
|- valign="top"
| 
|         Edu.School nvarchar(100)  
|         Edu_School String 
|- valign="top"
| 
|         Edu.Loc.CountryRegion nvarchar(100)  
|         Edu_Loc_CountryRegion String 
|- valign="top"
| 
|         Edu.Loc.State nvarchar(100)  
|         Edu_Loc_State String 
|- valign="top"
| 
|         Edu.Loc.City nvarchar(100)  
|         Edu_Loc_City String 
|- valign="top"
| [[HumanResources.vJobCandidateEmployment_(view)|HumanResources.vJobCandidateEmployment]] [[vJobCandidateEmployment_(class)|vJobCandidateEmployment]]
| 
| 
          
|- valign="top"
| 
|         JobCandidateID int NOT NULL Identity
|         JobCandidateID Int32 
|- valign="top"
| 
|         Emp.StartDate datetime  
|         Emp_StartDate DateTime 
|- valign="top"
| 
|         Emp.EndDate datetime  
|         Emp_EndDate DateTime 
|- valign="top"
| 
|         Emp.OrgName nvarchar(100)  
|         Emp_OrgName String 
|- valign="top"
| 
|         Emp.JobTitle nvarchar(100)  
|         Emp_JobTitle String 
|- valign="top"
| 
|         Emp.Responsibility nvarchar(max)  
|         Emp_Responsibility String 
|- valign="top"
| 
|         Emp.FunctionCategory nvarchar(max)  
|         Emp_FunctionCategory String 
|- valign="top"
| 
|         Emp.IndustryCategory nvarchar(max)  
|         Emp_IndustryCategory String 
|- valign="top"
| 
|         Emp.Loc.CountryRegion nvarchar(max)  
|         Emp_Loc_CountryRegion String 
|- valign="top"
| 
|         Emp.Loc.State nvarchar(max)  
|         Emp_Loc_State String 
|- valign="top"
| 
|         Emp.Loc.City nvarchar(max)  
|         Emp_Loc_City String 
|- valign="top"
| [[Person.vAdditionalContactInfo_(view)|Person.vAdditionalContactInfo]] [[vAdditionalContactInfo_(class)|vAdditionalContactInfo]]
| 
| 
          
|- valign="top"
| 
|         ContactID int NOT NULL Identity
|         ContactID Int32 
|- valign="top"
| 
|         FirstName nvarchar(50) NOT NULL 
|         FirstName String 
|- valign="top"
| 
|         MiddleName nvarchar(50)  
|         MiddleName String 
|- valign="top"
| 
|         LastName nvarchar(50) NOT NULL 
|         LastName String 
|- valign="top"
| 
|         TelephoneNumber nvarchar(50)  
|         TelephoneNumber String 
|- valign="top"
| 
|         TelephoneSpecialInstructions nvarchar(max)  
|         TelephoneSpecialInstructions String 
|- valign="top"
| 
|         Street nvarchar(50)  
|         Street String 
|- valign="top"
| 
|         City nvarchar(50)  
|         City String 
|- valign="top"
| 
|         StateProvince nvarchar(50)  
|         StateProvince String 
|- valign="top"
| 
|         PostalCode nvarchar(50)  
|         PostalCode String 
|- valign="top"
| 
|         CountryRegion nvarchar(50)  
|         CountryRegion String 
|- valign="top"
| 
|         HomeAddressSpecialInstructions nvarchar(max)  
|         HomeAddressSpecialInstructions String 
|- valign="top"
| 
|         EMailAddress nvarchar(128)  
|         EMailAddress String 
|- valign="top"
| 
|         EMailSpecialInstructions nvarchar(max)  
|         EMailSpecialInstructions String 
|- valign="top"
| 
|         EMailTelephoneNumber nvarchar(50)  
|         EMailTelephoneNumber String 
|- valign="top"
| 
|         rowguid uniqueidentifier NOT NULL 
|         rowguid Guid 
|- valign="top"
| 
|         ModifiedDate datetime NOT NULL 
|         ModifiedDate DateTime 
|- valign="top"
| [[Person.vStateProvinceCountryRegion_(view)|Person.vStateProvinceCountryRegion]] [[vStateProvinceCountryRegion_(class)|vStateProvinceCountryRegion]]
| 
| 
          
|- valign="top"
| 
|         StateProvinceID int NOT NULL 
|         StateProvinceID Int32 
|- valign="top"
| 
|         StateProvinceCode nchar(3) NOT NULL 
|         StateProvinceCode String 
|- valign="top"
| 
|         IsOnlyStateProvinceFlag bit NOT NULL 
|         IsOnlyStateProvinceFlag Boolean 
|- valign="top"
| 
|         StateProvinceName nvarchar(50) NOT NULL 
|         StateProvinceName String 
|- valign="top"
| 
|         TerritoryID int NOT NULL 
|         TerritoryID Int32 
|- valign="top"
| 
|         CountryRegionCode nvarchar(3) NOT NULL 
|         CountryRegionCode String 
|- valign="top"
| 
|         CountryRegionName nvarchar(50) NOT NULL 
|         CountryRegionName String 
|- valign="top"
| [[Production.vProductAndDescription_(view)|Production.vProductAndDescription]] [[vProductAndDescription_(class)|vProductAndDescription]]
| 
| 
          
|- valign="top"
| 
|         ProductID int NOT NULL 
|         ProductID Int32 
|- valign="top"
| 
|         Name nvarchar(50) NOT NULL 
|         Name String 
|- valign="top"
| 
|         ProductModel nvarchar(50) NOT NULL 
|         ProductModel String 
|- valign="top"
| 
|         CultureID nchar(6) NOT NULL 
|         CultureID String 
|- valign="top"
| 
|         Description nvarchar(400) NOT NULL 
|         Description String 
|- valign="top"
| [[Production.vProductModelCatalogDescription_(view)|Production.vProductModelCatalogDescription]] [[vProductModelCatalogDescription_(class)|vProductModelCatalogDescription]]
| 
| 
          
|- valign="top"
| 
|         ProductModelID int NOT NULL Identity
|         ProductModelID Int32 
|- valign="top"
| 
|         Name nvarchar(50) NOT NULL 
|         Name String 
|- valign="top"
| 
|         Summary nvarchar(max)  
|         Summary String 
|- valign="top"
| 
|         Manufacturer nvarchar(max)  
|         Manufacturer String 
|- valign="top"
| 
|         Copyright nvarchar(30)  
|         Copyright String 
|- valign="top"
| 
|         ProductURL nvarchar(256)  
|         ProductURL String 
|- valign="top"
| 
|         WarrantyPeriod nvarchar(256)  
|         WarrantyPeriod String 
|- valign="top"
| 
|         WarrantyDescription nvarchar(256)  
|         WarrantyDescription String 
|- valign="top"
| 
|         NoOfYears nvarchar(256)  
|         NoOfYears String 
|- valign="top"
| 
|         MaintenanceDescription nvarchar(256)  
|         MaintenanceDescription String 
|- valign="top"
| 
|         Wheel nvarchar(256)  
|         Wheel String 
|- valign="top"
| 
|         Saddle nvarchar(256)  
|         Saddle String 
|- valign="top"
| 
|         Pedal nvarchar(256)  
|         Pedal String 
|- valign="top"
| 
|         BikeFrame nvarchar(max)  
|         BikeFrame String 
|- valign="top"
| 
|         Crankset nvarchar(256)  
|         Crankset String 
|- valign="top"
| 
|         PictureAngle nvarchar(256)  
|         PictureAngle String 
|- valign="top"
| 
|         PictureSize nvarchar(256)  
|         PictureSize String 
|- valign="top"
| 
|         ProductPhotoID nvarchar(256)  
|         ProductPhotoID String 
|- valign="top"
| 
|         Material nvarchar(256)  
|         Material String 
|- valign="top"
| 
|         Color nvarchar(256)  
|         Color String 
|- valign="top"
| 
|         ProductLine nvarchar(256)  
|         ProductLine String 
|- valign="top"
| 
|         Style nvarchar(256)  
|         Style String 
|- valign="top"
| 
|         RiderExperience nvarchar(1024)  
|         RiderExperience String 
|- valign="top"
| 
|         rowguid uniqueidentifier NOT NULL 
|         rowguid Guid 
|- valign="top"
| 
|         ModifiedDate datetime NOT NULL 
|         ModifiedDate DateTime 
|- valign="top"
| [[Production.vProductModelInstructions_(view)|Production.vProductModelInstructions]] [[vProductModelInstructions_(class)|vProductModelInstructions]]
| 
| 
          
|- valign="top"
| 
|         ProductModelID int NOT NULL Identity
|         ProductModelID Int32 
|- valign="top"
| 
|         Name nvarchar(50) NOT NULL 
|         Name String 
|- valign="top"
| 
|         Instructions nvarchar(max)  
|         Instructions String 
|- valign="top"
| 
|         LocationID int  
|         LocationID Int32 
|- valign="top"
| 
|         SetupHours decimal  
|         SetupHours Decimal 
|- valign="top"
| 
|         MachineHours decimal  
|         MachineHours Decimal 
|- valign="top"
| 
|         LaborHours decimal  
|         LaborHours Decimal 
|- valign="top"
| 
|         LotSize int  
|         LotSize Int32 
|- valign="top"
| 
|         Step nvarchar(1024)  
|         Step String 
|- valign="top"
| 
|         rowguid uniqueidentifier NOT NULL 
|         rowguid Guid 
|- valign="top"
| 
|         ModifiedDate datetime NOT NULL 
|         ModifiedDate DateTime 
|- valign="top"
| [[Purchasing.vVendor_(view)|Purchasing.vVendor]] [[vVendor_(class)|vVendor]]
| 
| 
          
|- valign="top"
| 
|         VendorID int NOT NULL 
|         VendorID Int32 
|- valign="top"
| 
|         Name nvarchar(50) NOT NULL 
|         Name String 
|- valign="top"
| 
|         ContactType nvarchar(50) NOT NULL 
|         ContactType String 
|- valign="top"
| 
|         Title nvarchar(8)  
|         Title String 
|- valign="top"
| 
|         FirstName nvarchar(50) NOT NULL 
|         FirstName String 
|- valign="top"
| 
|         MiddleName nvarchar(50)  
|         MiddleName String 
|- valign="top"
| 
|         LastName nvarchar(50) NOT NULL 
|         LastName String 
|- valign="top"
| 
|         Suffix nvarchar(10)  
|         Suffix String 
|- valign="top"
| 
|         Phone nvarchar(25)  
|         Phone String 
|- valign="top"
| 
|         EmailAddress nvarchar(50)  
|         EmailAddress String 
|- valign="top"
| 
|         EmailPromotion int NOT NULL 
|         EmailPromotion Int32 
|- valign="top"
| 
|         AddressLine1 nvarchar(60) NOT NULL 
|         AddressLine1 String 
|- valign="top"
| 
|         AddressLine2 nvarchar(60)  
|         AddressLine2 String 
|- valign="top"
| 
|         City nvarchar(30) NOT NULL 
|         City String 
|- valign="top"
| 
|         StateProvinceName nvarchar(50) NOT NULL 
|         StateProvinceName String 
|- valign="top"
| 
|         PostalCode nvarchar(15) NOT NULL 
|         PostalCode String 
|- valign="top"
| 
|         CountryRegionName nvarchar(50) NOT NULL 
|         CountryRegionName String 
|- valign="top"
| [[Sales.vIndividualCustomer_(view)|Sales.vIndividualCustomer]] [[vIndividualCustomer_(class)|vIndividualCustomer]]
| 
| 
          
|- valign="top"
| 
|         CustomerID int NOT NULL 
|         CustomerID Int32 
|- valign="top"
| 
|         Title nvarchar(8)  
|         Title String 
|- valign="top"
| 
|         FirstName nvarchar(50) NOT NULL 
|         FirstName String 
|- valign="top"
| 
|         MiddleName nvarchar(50)  
|         MiddleName String 
|- valign="top"
| 
|         LastName nvarchar(50) NOT NULL 
|         LastName String 
|- valign="top"
| 
|         Suffix nvarchar(10)  
|         Suffix String 
|- valign="top"
| 
|         Phone nvarchar(25)  
|         Phone String 
|- valign="top"
| 
|         EmailAddress nvarchar(50)  
|         EmailAddress String 
|- valign="top"
| 
|         EmailPromotion int NOT NULL 
|         EmailPromotion Int32 
|- valign="top"
| 
|         AddressType nvarchar(50) NOT NULL 
|         AddressType String 
|- valign="top"
| 
|         AddressLine1 nvarchar(60) NOT NULL 
|         AddressLine1 String 
|- valign="top"
| 
|         AddressLine2 nvarchar(60)  
|         AddressLine2 String 
|- valign="top"
| 
|         City nvarchar(30) NOT NULL 
|         City String 
|- valign="top"
| 
|         StateProvinceName nvarchar(50) NOT NULL 
|         StateProvinceName String 
|- valign="top"
| 
|         PostalCode nvarchar(15) NOT NULL 
|         PostalCode String 
|- valign="top"
| 
|         CountryRegionName nvarchar(50) NOT NULL 
|         CountryRegionName String 
|- valign="top"
| 
|         Demographics xml  
|         Demographics String 
|- valign="top"
| [[Sales.vIndividualDemographics_(view)|Sales.vIndividualDemographics]] [[vIndividualDemographics_(class)|vIndividualDemographics]]
| 
| 
          
|- valign="top"
| 
|         CustomerID int NOT NULL 
|         CustomerID Int32 
|- valign="top"
| 
|         TotalPurchaseYTD money  
|         TotalPurchaseYTD Decimal 
|- valign="top"
| 
|         DateFirstPurchase datetime  
|         DateFirstPurchase DateTime 
|- valign="top"
| 
|         BirthDate datetime  
|         BirthDate DateTime 
|- valign="top"
| 
|         MaritalStatus nvarchar(1)  
|         MaritalStatus String 
|- valign="top"
| 
|         YearlyIncome nvarchar(30)  
|         YearlyIncome String 
|- valign="top"
| 
|         Gender nvarchar(1)  
|         Gender String 
|- valign="top"
| 
|         TotalChildren int  
|         TotalChildren Int32 
|- valign="top"
| 
|         NumberChildrenAtHome int  
|         NumberChildrenAtHome Int32 
|- valign="top"
| 
|         Education nvarchar(30)  
|         Education String 
|- valign="top"
| 
|         Occupation nvarchar(30)  
|         Occupation String 
|- valign="top"
| 
|         HomeOwnerFlag bit  
|         HomeOwnerFlag Boolean 
|- valign="top"
| 
|         NumberCarsOwned int  
|         NumberCarsOwned Int32 
|- valign="top"
| [[Sales.vSalesPerson_(view)|Sales.vSalesPerson]] [[vSalesPerson_(class)|vSalesPerson]]
| 
| 
          
|- valign="top"
| 
|         SalesPersonID int NOT NULL 
|         SalesPersonID Int32 
|- valign="top"
| 
|         Title nvarchar(8)  
|         Title String 
|- valign="top"
| 
|         FirstName nvarchar(50) NOT NULL 
|         FirstName String 
|- valign="top"
| 
|         MiddleName nvarchar(50)  
|         MiddleName String 
|- valign="top"
| 
|         LastName nvarchar(50) NOT NULL 
|         LastName String 
|- valign="top"
| 
|         Suffix nvarchar(10)  
|         Suffix String 
|- valign="top"
| 
|         JobTitle nvarchar(50) NOT NULL 
|         JobTitle String 
|- valign="top"
| 
|         Phone nvarchar(25)  
|         Phone String 
|- valign="top"
| 
|         EmailAddress nvarchar(50)  
|         EmailAddress String 
|- valign="top"
| 
|         EmailPromotion int NOT NULL 
|         EmailPromotion Int32 
|- valign="top"
| 
|         AddressLine1 nvarchar(60) NOT NULL 
|         AddressLine1 String 
|- valign="top"
| 
|         AddressLine2 nvarchar(60)  
|         AddressLine2 String 
|- valign="top"
| 
|         City nvarchar(30) NOT NULL 
|         City String 
|- valign="top"
| 
|         StateProvinceName nvarchar(50) NOT NULL 
|         StateProvinceName String 
|- valign="top"
| 
|         PostalCode nvarchar(15) NOT NULL 
|         PostalCode String 
|- valign="top"
| 
|         CountryRegionName nvarchar(50) NOT NULL 
|         CountryRegionName String 
|- valign="top"
| 
|         TerritoryName nvarchar(50)  
|         TerritoryName String 
|- valign="top"
| 
|         TerritoryGroup nvarchar(50)  
|         TerritoryGroup String 
|- valign="top"
| 
|         SalesQuota money  
|         SalesQuota Decimal 
|- valign="top"
| 
|         SalesYTD money NOT NULL 
|         SalesYTD Decimal 
|- valign="top"
| 
|         SalesLastYear money NOT NULL 
|         SalesLastYear Decimal 
|- valign="top"
| [[Sales.vSalesPersonSalesByFiscalYears_(view)|Sales.vSalesPersonSalesByFiscalYears]] [[vSalesPersonSalesByFiscalYears_(class)|vSalesPersonSalesByFiscalYears]]
| 
| 
          
|- valign="top"
| 
|         SalesPersonID int  
|         SalesPersonID Int32 
|- valign="top"
| 
|         FullName nvarchar(152)  
|         FullName String 
|- valign="top"
| 
|         Title nvarchar(50) NOT NULL 
|         Title String 
|- valign="top"
| 
|         SalesTerritory nvarchar(50) NOT NULL 
|         SalesTerritory String 
|- valign="top"
| 
|         2002 money  
|         C2002 Decimal 
|- valign="top"
| 
|         2003 money  
|         C2003 Decimal 
|- valign="top"
| 
|         2004 money  
|         C2004 Decimal 
|- valign="top"
| [[Sales.vStoreWithDemographics_(view)|Sales.vStoreWithDemographics]] [[vStoreWithDemographics_(class)|vStoreWithDemographics]]
| 
| 
          
|- valign="top"
| 
|         CustomerID int NOT NULL 
|         CustomerID Int32 
|- valign="top"
| 
|         Name nvarchar(50) NOT NULL 
|         Name String 
|- valign="top"
| 
|         ContactType nvarchar(50) NOT NULL 
|         ContactType String 
|- valign="top"
| 
|         Title nvarchar(8)  
|         Title String 
|- valign="top"
| 
|         FirstName nvarchar(50) NOT NULL 
|         FirstName String 
|- valign="top"
| 
|         MiddleName nvarchar(50)  
|         MiddleName String 
|- valign="top"
| 
|         LastName nvarchar(50) NOT NULL 
|         LastName String 
|- valign="top"
| 
|         Suffix nvarchar(10)  
|         Suffix String 
|- valign="top"
| 
|         Phone nvarchar(25)  
|         Phone String 
|- valign="top"
| 
|         EmailAddress nvarchar(50)  
|         EmailAddress String 
|- valign="top"
| 
|         EmailPromotion int NOT NULL 
|         EmailPromotion Int32 
|- valign="top"
| 
|         AddressType nvarchar(50) NOT NULL 
|         AddressType String 
|- valign="top"
| 
|         AddressLine1 nvarchar(60) NOT NULL 
|         AddressLine1 String 
|- valign="top"
| 
|         AddressLine2 nvarchar(60)  
|         AddressLine2 String 
|- valign="top"
| 
|         City nvarchar(30) NOT NULL 
|         City String 
|- valign="top"
| 
|         StateProvinceName nvarchar(50) NOT NULL 
|         StateProvinceName String 
|- valign="top"
| 
|         PostalCode nvarchar(15) NOT NULL 
|         PostalCode String 
|- valign="top"
| 
|         CountryRegionName nvarchar(50) NOT NULL 
|         CountryRegionName String 
|- valign="top"
| 
|         AnnualSales money  
|         AnnualSales Decimal 
|- valign="top"
| 
|         AnnualRevenue money  
|         AnnualRevenue Decimal 
|- valign="top"
| 
|         BankName nvarchar(50)  
|         BankName String 
|- valign="top"
| 
|         BusinessType nvarchar(5)  
|         BusinessType String 
|- valign="top"
| 
|         YearOpened int  
|         YearOpened Int32 
|- valign="top"
| 
|         Specialty nvarchar(50)  
|         Specialty String 
|- valign="top"
| 
|         SquareFeet int  
|         SquareFeet Int32 
|- valign="top"
| 
|         Brands nvarchar(30)  
|         Brands String 
|- valign="top"
| 
|         Internet nvarchar(30)  
|         Internet String 
|- valign="top"
| 
|         NumberEmployees int  
|         NumberEmployees Int32 
|}