Difference between revisions of "AdventureWorks Table+Column Mapping EF1"

From dbscript Online Help
Jump to: navigation, search
(New page: edmx upload (20100609 200009 AdventureWorks2005ef1.edmx) === Namespace === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- valign="top" | [[dbo...)
 
 
Line 1: Line 1:
 +
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
 +
|}
 +
 +
== wikibot ==
 
edmx upload (20100609 200009 AdventureWorks2005ef1.edmx)
 
edmx upload (20100609 200009 AdventureWorks2005ef1.edmx)
 
    
 
    

Latest revision as of 01:09, 24 June 2010

edmx upload (20100609 200009 AdventureWorks2005ef1.edmx)

Namespace[edit]

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

wikibot[edit]

edmx upload (20100609 200009 AdventureWorks2005ef1.edmx)

Namespace[edit]

dbo.AWBuildVersion AWBuildVersion
SystemInformationID tinyint NOT NULL Identity SystemInformationID Byte
Database Version nvarchar(25) NOT NULL Database_Version String
VersionDate datetime NOT NULL VersionDate DateTime
ModifiedDate datetime NOT NULL ModifiedDate DateTime
dbo.DatabaseLog DatabaseLog
DatabaseLogID int NOT NULL Identity DatabaseLogID Int32
PostTime datetime NOT NULL PostTime DateTime
DatabaseUser nvarchar(128) NOT NULL DatabaseUser String
Event nvarchar(128) NOT NULL Event String
Schema nvarchar(128) Schema String
Object nvarchar(128) Object String
TSQL nvarchar(max) NOT NULL TSQL String
XmlEvent xml NOT NULL XmlEvent String
dbo.ErrorLog ErrorLog
ErrorLogID int NOT NULL Identity ErrorLogID Int32
ErrorTime datetime NOT NULL ErrorTime DateTime
UserName nvarchar(128) NOT NULL UserName String
ErrorNumber int NOT NULL ErrorNumber Int32
ErrorSeverity int ErrorSeverity Int32
ErrorState int ErrorState Int32
ErrorProcedure nvarchar(126) ErrorProcedure String
ErrorLine int ErrorLine Int32
ErrorMessage nvarchar NOT NULL ErrorMessage String
HumanResources.Department Department
DepartmentID smallint NOT NULL Identity DepartmentID Int16 EmployeeDepartmentHistory
Name nvarchar(50) NOT NULL Name String
GroupName nvarchar(50) NOT NULL GroupName String
ModifiedDate datetime NOT NULL ModifiedDate DateTime
HumanResources.Employee Employee
EmployeeID int NOT NULL Identity EmployeeID Int32 Contact
NationalIDNumber nvarchar(15) NOT NULL NationalIDNumber String
ContactID int NOT NULL Contact
LoginID nvarchar(256) NOT NULL LoginID String
ManagerID int Employee1
Title nvarchar(50) NOT NULL Title String
BirthDate datetime NOT NULL BirthDate DateTime
MaritalStatus nchar(1) NOT NULL MaritalStatus String
Gender nchar(1) NOT NULL Gender String
HireDate datetime NOT NULL HireDate DateTime
SalariedFlag bit NOT NULL SalariedFlag Boolean
VacationHours smallint NOT NULL VacationHours Int16
SickLeaveHours smallint NOT NULL SickLeaveHours Int16
CurrentFlag bit NOT NULL CurrentFlag Boolean
rowguid uniqueidentifier NOT NULL rowguid Guid
ModifiedDate datetime NOT NULL ModifiedDate DateTime
HumanResources.EmployeeAddress EmployeeAddress
EmployeeID int NOT NULL EmployeeID Int32 Employee
AddressID int NOT NULL AddressID Int32 Employee
rowguid uniqueidentifier NOT NULL rowguid Guid
ModifiedDate datetime NOT NULL ModifiedDate DateTime
HumanResources.EmployeeDepartmentHistory EmployeeDepartmentHistory
EmployeeID int NOT NULL EmployeeID Int32 Department
DepartmentID smallint NOT NULL DepartmentID Int16 Department
ShiftID tinyint NOT NULL ShiftID Byte Department
StartDate datetime NOT NULL StartDate DateTime Department
EndDate datetime EndDate DateTime
ModifiedDate datetime NOT NULL ModifiedDate DateTime
HumanResources.EmployeePayHistory EmployeePayHistory
EmployeeID int NOT NULL EmployeeID Int32 Employee
RateChangeDate datetime NOT NULL RateChangeDate DateTime Employee
Rate money NOT NULL Rate Decimal
PayFrequency tinyint NOT NULL PayFrequency Byte
ModifiedDate datetime NOT NULL ModifiedDate DateTime
HumanResources.JobCandidate JobCandidate
JobCandidateID int NOT NULL Identity JobCandidateID Int32 Employee
EmployeeID int Employee
Resume xml Resume String
ModifiedDate datetime NOT NULL ModifiedDate DateTime
HumanResources.Shift Shift
ShiftID tinyint NOT NULL Identity ShiftID Byte EmployeeDepartmentHistory
Name nvarchar(50) NOT NULL Name String
StartTime datetime NOT NULL StartTime DateTime
EndTime datetime NOT NULL EndTime DateTime
ModifiedDate datetime NOT NULL ModifiedDate DateTime
Person.Address Address
AddressID int NOT NULL Identity AddressID Int32 EmployeeAddress
AddressLine1 nvarchar(60) NOT NULL AddressLine1 String
AddressLine2 nvarchar(60) AddressLine2 String
City nvarchar(30) NOT NULL City String
StateProvinceID int NOT NULL StateProvince
PostalCode nvarchar(15) NOT NULL PostalCode String
rowguid uniqueidentifier NOT NULL rowguid Guid
ModifiedDate datetime NOT NULL ModifiedDate DateTime
Person.AddressType AddressType
AddressTypeID int NOT NULL Identity AddressTypeID Int32 CustomerAddress
Name nvarchar(50) NOT NULL Name String
rowguid uniqueidentifier NOT NULL rowguid Guid
ModifiedDate datetime NOT NULL ModifiedDate DateTime
Person.Contact Contact
ContactID int NOT NULL Identity ContactID Int32 Employee
NameStyle bit NOT NULL NameStyle Boolean
Title nvarchar(8) Title String
FirstName nvarchar(50) NOT NULL FirstName String
MiddleName nvarchar(50) MiddleName String
LastName nvarchar(50) NOT NULL LastName String
Suffix nvarchar(10) Suffix String
EmailAddress nvarchar(50) EmailAddress String
EmailPromotion int NOT NULL EmailPromotion Int32
Phone nvarchar(25) Phone String
PasswordHash varchar(128) NOT NULL PasswordHash String
PasswordSalt varchar(10) NOT NULL PasswordSalt String
AdditionalContactInfo xml AdditionalContactInfo String
rowguid uniqueidentifier NOT NULL rowguid Guid
ModifiedDate datetime NOT NULL ModifiedDate DateTime
Person.ContactType ContactType
ContactTypeID int NOT NULL Identity ContactTypeID Int32 StoreContact
Name nvarchar(50) NOT NULL Name String
ModifiedDate datetime NOT NULL ModifiedDate DateTime
Person.CountryRegion CountryRegion
CountryRegionCode nvarchar(3) NOT NULL CountryRegionCode String CountryRegionCurrency
Name nvarchar(50) NOT NULL Name String
ModifiedDate datetime NOT NULL ModifiedDate DateTime
Person.StateProvince StateProvince
StateProvinceID int NOT NULL Identity StateProvinceID Int32 Address
StateProvinceCode nchar(3) NOT NULL StateProvinceCode String
CountryRegionCode nvarchar(3) NOT NULL CountryRegion
IsOnlyStateProvinceFlag bit NOT NULL IsOnlyStateProvinceFlag Boolean
Name nvarchar(50) NOT NULL Name String
TerritoryID int NOT NULL SalesTerritory
rowguid uniqueidentifier NOT NULL rowguid Guid
ModifiedDate datetime NOT NULL ModifiedDate DateTime
Production.BillOfMaterials BillOfMaterials
BillOfMaterialsID int NOT NULL Identity BillOfMaterialsID Int32 Product
ProductAssemblyID int Product1
ComponentID int NOT NULL Product
StartDate datetime NOT NULL StartDate DateTime
EndDate datetime EndDate DateTime
UnitMeasureCode nchar(3) NOT NULL UnitMeasure
BOMLevel smallint NOT NULL BOMLevel Int16
PerAssemblyQty decimal NOT NULL PerAssemblyQty Decimal
ModifiedDate datetime NOT NULL ModifiedDate DateTime
Production.Culture Culture
CultureID nchar(6) NOT NULL CultureID String ProductModelProductDescriptionCulture
Name nvarchar(50) NOT NULL Name String
ModifiedDate datetime NOT NULL ModifiedDate DateTime
Production.Document Document
DocumentID int NOT NULL Identity DocumentID Int32 ProductDocument
Title nvarchar(50) NOT NULL Title String
FileName nvarchar(400) NOT NULL FileName String
FileExtension nvarchar(8) NOT NULL FileExtension String
Revision nchar(5) NOT NULL Revision String
ChangeNumber int NOT NULL ChangeNumber Int32
Status tinyint NOT NULL Status Byte
DocumentSummary nvarchar(max) DocumentSummary String
Document varbinary(max) Document1 Binary
ModifiedDate datetime NOT NULL ModifiedDate DateTime
Production.Illustration Illustration
IllustrationID int NOT NULL Identity IllustrationID Int32 ProductModelIllustration
Diagram xml Diagram String
ModifiedDate datetime NOT NULL ModifiedDate DateTime
Production.Location Location
LocationID smallint NOT NULL Identity LocationID Int16 ProductInventory
Name nvarchar(50) NOT NULL Name String
CostRate smallmoney NOT NULL CostRate Decimal
Availability decimal NOT NULL Availability Decimal
ModifiedDate datetime NOT NULL ModifiedDate DateTime
Production.Product Product
ProductID int NOT NULL Identity ProductID Int32 ProductModel
Name nvarchar(50) NOT NULL Name String
ProductNumber nvarchar(25) NOT NULL ProductNumber String
MakeFlag bit NOT NULL MakeFlag Boolean
FinishedGoodsFlag bit NOT NULL FinishedGoodsFlag Boolean
Color nvarchar(15) Color String
SafetyStockLevel smallint NOT NULL SafetyStockLevel Int16
ReorderPoint smallint NOT NULL ReorderPoint Int16
StandardCost money NOT NULL StandardCost Decimal
ListPrice money NOT NULL ListPrice Decimal
Size nvarchar(5) Size String
SizeUnitMeasureCode nchar(3) UnitMeasure
WeightUnitMeasureCode nchar(3) UnitMeasure1
Weight decimal Weight Decimal
DaysToManufacture int NOT NULL DaysToManufacture Int32
ProductLine nchar(2) ProductLine String
Class nchar(2) Class String
Style nchar(2) Style String
ProductSubcategoryID int ProductSubcategory
ProductModelID int ProductModel
SellStartDate datetime NOT NULL SellStartDate DateTime
SellEndDate datetime SellEndDate DateTime
DiscontinuedDate datetime DiscontinuedDate DateTime
rowguid uniqueidentifier NOT NULL rowguid Guid
ModifiedDate datetime NOT NULL ModifiedDate DateTime
Production.ProductCategory ProductCategory
ProductCategoryID int NOT NULL Identity ProductCategoryID Int32 ProductSubcategory
Name nvarchar(50) NOT NULL Name String
rowguid uniqueidentifier NOT NULL rowguid Guid
ModifiedDate datetime NOT NULL ModifiedDate DateTime
Production.ProductCostHistory ProductCostHistory
ProductID int NOT NULL ProductID Int32 Product
StartDate datetime NOT NULL StartDate DateTime Product
EndDate datetime EndDate DateTime
StandardCost money NOT NULL StandardCost Decimal
ModifiedDate datetime NOT NULL ModifiedDate DateTime
Production.ProductDescription ProductDescription
ProductDescriptionID int NOT NULL Identity ProductDescriptionID Int32 ProductModelProductDescriptionCulture
Description nvarchar(400) NOT NULL Description String
rowguid uniqueidentifier NOT NULL rowguid Guid
ModifiedDate datetime NOT NULL ModifiedDate DateTime
Production.ProductDocument ProductDocument
ProductID int NOT NULL ProductID Int32 Document
DocumentID int NOT NULL DocumentID Int32 Document
ModifiedDate datetime NOT NULL ModifiedDate DateTime
Production.ProductInventory ProductInventory
ProductID int NOT NULL ProductID Int32 Location
LocationID smallint NOT NULL LocationID Int16 Location
Shelf nvarchar(10) NOT NULL Shelf String
Bin tinyint NOT NULL Bin Byte
Quantity smallint NOT NULL Quantity Int16
rowguid uniqueidentifier NOT NULL rowguid Guid
ModifiedDate datetime NOT NULL ModifiedDate DateTime
Production.ProductListPriceHistory ProductListPriceHistory
ProductID int NOT NULL ProductID Int32 Product
StartDate datetime NOT NULL StartDate DateTime Product
EndDate datetime EndDate DateTime
ListPrice money NOT NULL ListPrice Decimal
ModifiedDate datetime NOT NULL ModifiedDate DateTime
Production.ProductModel ProductModel
ProductModelID int NOT NULL Identity ProductModelID Int32 Product
Name nvarchar(50) NOT NULL Name String
CatalogDescription xml CatalogDescription String
Instructions xml Instructions String
rowguid uniqueidentifier NOT NULL rowguid Guid
ModifiedDate datetime NOT NULL ModifiedDate DateTime
Production.ProductModelIllustration ProductModelIllustration
ProductModelID int NOT NULL ProductModelID Int32 Illustration
IllustrationID int NOT NULL IllustrationID Int32 Illustration
ModifiedDate datetime NOT NULL ModifiedDate DateTime
Production.ProductModelProductDescriptionCulture ProductModelProductDescriptionCulture
ProductModelID int NOT NULL ProductModelID Int32 Culture
ProductDescriptionID int NOT NULL ProductDescriptionID Int32 Culture
CultureID nchar(6) NOT NULL CultureID String Culture
ModifiedDate datetime NOT NULL ModifiedDate DateTime
Production.ProductPhoto ProductPhoto
ProductPhotoID int NOT NULL Identity ProductPhotoID Int32 ProductProductPhoto
ThumbNailPhoto varbinary(max) ThumbNailPhoto Binary
ThumbnailPhotoFileName nvarchar(50) ThumbnailPhotoFileName String
LargePhoto varbinary(max) LargePhoto Binary
LargePhotoFileName nvarchar(50) LargePhotoFileName String
ModifiedDate datetime NOT NULL ModifiedDate DateTime
Production.ProductProductPhoto ProductProductPhoto
ProductID int NOT NULL ProductID Int32 Product
ProductPhotoID int NOT NULL ProductPhotoID Int32 Product
Primary bit NOT NULL Primary Boolean
ModifiedDate datetime NOT NULL ModifiedDate DateTime
Production.ProductReview ProductReview
ProductReviewID int NOT NULL Identity ProductReviewID Int32 Product
ProductID int NOT NULL Product
ReviewerName nvarchar(50) NOT NULL ReviewerName String
ReviewDate datetime NOT NULL ReviewDate DateTime
EmailAddress nvarchar(50) NOT NULL EmailAddress String
Rating int NOT NULL Rating Int32
Comments nvarchar(3850) Comments String
ModifiedDate datetime NOT NULL ModifiedDate DateTime
Production.ProductSubcategory ProductSubcategory
ProductSubcategoryID int NOT NULL Identity ProductSubcategoryID Int32 Product
ProductCategoryID int NOT NULL ProductCategory
Name nvarchar(50) NOT NULL Name String
rowguid uniqueidentifier NOT NULL rowguid Guid
ModifiedDate datetime NOT NULL ModifiedDate DateTime
Production.ScrapReason ScrapReason
ScrapReasonID smallint NOT NULL Identity ScrapReasonID Int16 WorkOrder
Name nvarchar(50) NOT NULL Name String
ModifiedDate datetime NOT NULL ModifiedDate DateTime
Production.TransactionHistory TransactionHistory
TransactionID int NOT NULL Identity TransactionID Int32 Product
ProductID int NOT NULL Product
ReferenceOrderID int NOT NULL ReferenceOrderID Int32
ReferenceOrderLineID int NOT NULL ReferenceOrderLineID Int32
TransactionDate datetime NOT NULL TransactionDate DateTime
TransactionType nchar(1) NOT NULL TransactionType String
Quantity int NOT NULL Quantity Int32
ActualCost money NOT NULL ActualCost Decimal
ModifiedDate datetime NOT NULL ModifiedDate DateTime
Production.TransactionHistoryArchive TransactionHistoryArchive
TransactionID int NOT NULL TransactionID Int32
ProductID int NOT NULL ProductID Int32
ReferenceOrderID int NOT NULL ReferenceOrderID Int32
ReferenceOrderLineID int NOT NULL ReferenceOrderLineID Int32
TransactionDate datetime NOT NULL TransactionDate DateTime
TransactionType nchar(1) NOT NULL TransactionType String
Quantity int NOT NULL Quantity Int32
ActualCost money NOT NULL ActualCost Decimal
ModifiedDate datetime NOT NULL ModifiedDate DateTime
Production.UnitMeasure UnitMeasure
UnitMeasureCode nchar(3) NOT NULL UnitMeasureCode String BillOfMaterials
Name nvarchar(50) NOT NULL Name String
ModifiedDate datetime NOT NULL ModifiedDate DateTime
Production.WorkOrder WorkOrder
WorkOrderID int NOT NULL Identity WorkOrderID Int32 Product
ProductID int NOT NULL Product
OrderQty int NOT NULL OrderQty Int32
StockedQty int NOT NULL Computed StockedQty Int32
ScrappedQty smallint NOT NULL ScrappedQty Int16
StartDate datetime NOT NULL StartDate DateTime
EndDate datetime EndDate DateTime
DueDate datetime NOT NULL DueDate DateTime
ScrapReasonID smallint ScrapReason
ModifiedDate datetime NOT NULL ModifiedDate DateTime
Production.WorkOrderRouting WorkOrderRouting
WorkOrderID int NOT NULL WorkOrderID Int32 Location
ProductID int NOT NULL ProductID Int32 Location
OperationSequence smallint NOT NULL OperationSequence Int16 Location
LocationID smallint NOT NULL Location
ScheduledStartDate datetime NOT NULL ScheduledStartDate DateTime
ScheduledEndDate datetime NOT NULL ScheduledEndDate DateTime
ActualStartDate datetime ActualStartDate DateTime
ActualEndDate datetime ActualEndDate DateTime
ActualResourceHrs decimal ActualResourceHrs Decimal
PlannedCost money NOT NULL PlannedCost Decimal
ActualCost money ActualCost Decimal
ModifiedDate datetime NOT NULL ModifiedDate DateTime
Purchasing.ProductVendor ProductVendor
ProductID int NOT NULL ProductID Int32 Product
VendorID int NOT NULL VendorID Int32 Product
AverageLeadTime int NOT NULL AverageLeadTime Int32
StandardPrice money NOT NULL StandardPrice Decimal
LastReceiptCost money LastReceiptCost Decimal
LastReceiptDate datetime LastReceiptDate DateTime
MinOrderQty int NOT NULL MinOrderQty Int32
MaxOrderQty int NOT NULL MaxOrderQty Int32
OnOrderQty int OnOrderQty Int32
UnitMeasureCode nchar(3) NOT NULL UnitMeasure
ModifiedDate datetime NOT NULL ModifiedDate DateTime
Purchasing.PurchaseOrderDetail PurchaseOrderDetail
PurchaseOrderID int NOT NULL PurchaseOrderID Int32 Product
PurchaseOrderDetailID int NOT NULL Identity PurchaseOrderDetailID Int32 Product
DueDate datetime NOT NULL DueDate DateTime
OrderQty smallint NOT NULL OrderQty Int16
ProductID int NOT NULL Product
UnitPrice money NOT NULL UnitPrice Decimal
LineTotal money NOT NULL Computed LineTotal Decimal
ReceivedQty decimal NOT NULL ReceivedQty Decimal
RejectedQty decimal NOT NULL RejectedQty Decimal
StockedQty decimal NOT NULL Computed StockedQty Decimal
ModifiedDate datetime NOT NULL ModifiedDate DateTime
Purchasing.PurchaseOrderHeader PurchaseOrderHeader
PurchaseOrderID int NOT NULL Identity PurchaseOrderID Int32 Employee
RevisionNumber tinyint NOT NULL RevisionNumber Byte
Status tinyint NOT NULL Status Byte
EmployeeID int NOT NULL Employee
VendorID int NOT NULL Vendor
ShipMethodID int NOT NULL ShipMethod
OrderDate datetime NOT NULL OrderDate DateTime
ShipDate datetime ShipDate DateTime
SubTotal money NOT NULL SubTotal Decimal
TaxAmt money NOT NULL TaxAmt Decimal
Freight money NOT NULL Freight Decimal
TotalDue money NOT NULL Computed TotalDue Decimal
ModifiedDate datetime NOT NULL ModifiedDate DateTime
Purchasing.ShipMethod ShipMethod
ShipMethodID int NOT NULL Identity ShipMethodID Int32 PurchaseOrderHeader
Name nvarchar(50) NOT NULL Name String
ShipBase money NOT NULL ShipBase Decimal
ShipRate money NOT NULL ShipRate Decimal
rowguid uniqueidentifier NOT NULL rowguid Guid
ModifiedDate datetime NOT NULL ModifiedDate DateTime
Purchasing.Vendor Vendor
VendorID int NOT NULL Identity VendorID Int32 ProductVendor
AccountNumber nvarchar(15) NOT NULL AccountNumber String
Name nvarchar(50) NOT NULL Name String
CreditRating tinyint NOT NULL CreditRating Byte
PreferredVendorStatus bit NOT NULL PreferredVendorStatus Boolean
ActiveFlag bit NOT NULL ActiveFlag Boolean
PurchasingWebServiceURL nvarchar(1024) PurchasingWebServiceURL String
ModifiedDate datetime NOT NULL ModifiedDate DateTime
Purchasing.VendorAddress VendorAddress
VendorID int NOT NULL VendorID Int32 Address
AddressID int NOT NULL AddressID Int32 Address
AddressTypeID int NOT NULL AddressType
ModifiedDate datetime NOT NULL ModifiedDate DateTime
Purchasing.VendorContact VendorContact
VendorID int NOT NULL VendorID Int32 Contact
ContactID int NOT NULL ContactID Int32 Contact
ContactTypeID int NOT NULL ContactType
ModifiedDate datetime NOT NULL ModifiedDate DateTime
Sales.ContactCreditCard ContactCreditCard
ContactID int NOT NULL ContactID Int32 Contact
CreditCardID int NOT NULL CreditCardID Int32 Contact
ModifiedDate datetime NOT NULL ModifiedDate DateTime
Sales.CountryRegionCurrency CountryRegionCurrency
CountryRegionCode nvarchar(3) NOT NULL CountryRegionCode String CountryRegion
CurrencyCode nchar(3) NOT NULL CurrencyCode String CountryRegion
ModifiedDate datetime NOT NULL ModifiedDate DateTime
Sales.CreditCard CreditCard
CreditCardID int NOT NULL Identity CreditCardID Int32 ContactCreditCard
CardType nvarchar(50) NOT NULL CardType String
CardNumber nvarchar(25) NOT NULL CardNumber String
ExpMonth tinyint NOT NULL ExpMonth Byte
ExpYear smallint NOT NULL ExpYear Int16
ModifiedDate datetime NOT NULL ModifiedDate DateTime
Sales.Currency Currency
CurrencyCode nchar(3) NOT NULL CurrencyCode String CountryRegionCurrency
Name nvarchar(50) NOT NULL Name String
ModifiedDate datetime NOT NULL ModifiedDate DateTime
Sales.CurrencyRate CurrencyRate
CurrencyRateID int NOT NULL Identity CurrencyRateID Int32 Currency
CurrencyRateDate datetime NOT NULL CurrencyRateDate DateTime
FromCurrencyCode nchar(3) NOT NULL Currency
ToCurrencyCode nchar(3) NOT NULL Currency1
AverageRate money NOT NULL AverageRate Decimal
EndOfDayRate money NOT NULL EndOfDayRate Decimal
ModifiedDate datetime NOT NULL ModifiedDate DateTime
Sales.Customer Customer
CustomerID int NOT NULL Identity CustomerID Int32 SalesTerritory
TerritoryID int SalesTerritory
AccountNumber varchar(10) NOT NULL Computed AccountNumber String
CustomerType nchar(1) NOT NULL CustomerType String
rowguid uniqueidentifier NOT NULL rowguid Guid
ModifiedDate datetime NOT NULL ModifiedDate DateTime
Sales.CustomerAddress CustomerAddress
CustomerID int NOT NULL CustomerID Int32 Address
AddressID int NOT NULL AddressID Int32 Address
AddressTypeID int NOT NULL AddressType
rowguid uniqueidentifier NOT NULL rowguid Guid
ModifiedDate datetime NOT NULL ModifiedDate DateTime
Sales.Individual Individual
CustomerID int NOT NULL CustomerID Int32 Contact
ContactID int NOT NULL Contact
Demographics xml Demographics String
ModifiedDate datetime NOT NULL ModifiedDate DateTime
Sales.SalesOrderDetail SalesOrderDetail
SalesOrderID int NOT NULL SalesOrderID Int32 SalesOrderHeader
SalesOrderDetailID int NOT NULL Identity SalesOrderDetailID Int32 SalesOrderHeader
CarrierTrackingNumber nvarchar(25) CarrierTrackingNumber String
OrderQty smallint NOT NULL OrderQty Int16
ProductID int NOT NULL SpecialOfferProduct
SpecialOfferID int NOT NULL SpecialOfferProduct
UnitPrice money NOT NULL UnitPrice Decimal
UnitPriceDiscount money NOT NULL UnitPriceDiscount Decimal
LineTotal numeric NOT NULL Computed LineTotal Decimal
rowguid uniqueidentifier NOT NULL rowguid Guid
ModifiedDate datetime NOT NULL ModifiedDate DateTime
Sales.SalesOrderHeader SalesOrderHeader
SalesOrderID int NOT NULL Identity SalesOrderID Int32 Address
RevisionNumber tinyint NOT NULL RevisionNumber Byte
OrderDate datetime NOT NULL OrderDate DateTime
DueDate datetime NOT NULL DueDate DateTime
ShipDate datetime ShipDate DateTime
Status tinyint NOT NULL Status Byte
OnlineOrderFlag bit NOT NULL OnlineOrderFlag Boolean
SalesOrderNumber nvarchar(25) NOT NULL Computed SalesOrderNumber String
PurchaseOrderNumber nvarchar(25) PurchaseOrderNumber String
AccountNumber nvarchar(15) AccountNumber String
CustomerID int NOT NULL Customer
ContactID int NOT NULL Contact
SalesPersonID int SalesPerson
TerritoryID int SalesTerritory
BillToAddressID int NOT NULL Address
ShipToAddressID int NOT NULL Address1
ShipMethodID int NOT NULL ShipMethod
CreditCardID int CreditCard
CreditCardApprovalCode varchar(15) CreditCardApprovalCode String
CurrencyRateID int CurrencyRate
SubTotal money NOT NULL SubTotal Decimal
TaxAmt money NOT NULL TaxAmt Decimal
Freight money NOT NULL Freight Decimal
TotalDue money NOT NULL Computed TotalDue Decimal
Comment nvarchar(128) Comment String
rowguid uniqueidentifier NOT NULL rowguid Guid
ModifiedDate datetime NOT NULL ModifiedDate DateTime
Sales.SalesOrderHeaderSalesReason SalesOrderHeaderSalesReason
SalesOrderID int NOT NULL SalesOrderID Int32 SalesOrderHeader
SalesReasonID int NOT NULL SalesReasonID Int32 SalesOrderHeader
ModifiedDate datetime NOT NULL ModifiedDate DateTime
Sales.SalesPerson SalesPerson
SalesPersonID int NOT NULL SalesPersonID Int32 Employee
TerritoryID int SalesTerritory
SalesQuota money SalesQuota Decimal
Bonus money NOT NULL Bonus Decimal
CommissionPct smallmoney NOT NULL CommissionPct Decimal
SalesYTD money NOT NULL SalesYTD Decimal
SalesLastYear money NOT NULL SalesLastYear Decimal
rowguid uniqueidentifier NOT NULL rowguid Guid
ModifiedDate datetime NOT NULL ModifiedDate DateTime
Sales.SalesPersonQuotaHistory SalesPersonQuotaHistory
SalesPersonID int NOT NULL SalesPersonID Int32 SalesPerson
QuotaDate datetime NOT NULL QuotaDate DateTime SalesPerson
SalesQuota money NOT NULL SalesQuota Decimal
rowguid uniqueidentifier NOT NULL rowguid Guid
ModifiedDate datetime NOT NULL ModifiedDate DateTime
Sales.SalesReason SalesReason
SalesReasonID int NOT NULL Identity SalesReasonID Int32 SalesOrderHeaderSalesReason
Name nvarchar(50) NOT NULL Name String
ReasonType nvarchar(50) NOT NULL ReasonType String
ModifiedDate datetime NOT NULL ModifiedDate DateTime
Sales.SalesTaxRate SalesTaxRate
SalesTaxRateID int NOT NULL Identity SalesTaxRateID Int32 StateProvince
StateProvinceID int NOT NULL StateProvince
TaxType tinyint NOT NULL TaxType Byte
TaxRate smallmoney NOT NULL TaxRate Decimal
Name nvarchar(50) NOT NULL Name String
rowguid uniqueidentifier NOT NULL rowguid Guid
ModifiedDate datetime NOT NULL ModifiedDate DateTime
Sales.SalesTerritory SalesTerritory
TerritoryID int NOT NULL Identity TerritoryID Int32 StateProvince
Name nvarchar(50) NOT NULL Name String
CountryRegionCode nvarchar(3) NOT NULL CountryRegionCode String
Group nvarchar(50) NOT NULL Group String
SalesYTD money NOT NULL SalesYTD Decimal
SalesLastYear money NOT NULL SalesLastYear Decimal
CostYTD money NOT NULL CostYTD Decimal
CostLastYear money NOT NULL CostLastYear Decimal
rowguid uniqueidentifier NOT NULL rowguid Guid
ModifiedDate datetime NOT NULL ModifiedDate DateTime
Sales.SalesTerritoryHistory SalesTerritoryHistory
SalesPersonID int NOT NULL SalesPersonID Int32 SalesPerson
TerritoryID int NOT NULL TerritoryID Int32 SalesPerson
StartDate datetime NOT NULL StartDate DateTime SalesPerson
EndDate datetime EndDate DateTime
rowguid uniqueidentifier NOT NULL rowguid Guid
ModifiedDate datetime NOT NULL ModifiedDate DateTime
Sales.ShoppingCartItem ShoppingCartItem
ShoppingCartItemID int NOT NULL Identity ShoppingCartItemID Int32 Product
ShoppingCartID nvarchar(50) NOT NULL ShoppingCartID String
Quantity int NOT NULL Quantity Int32
ProductID int NOT NULL Product
DateCreated datetime NOT NULL DateCreated DateTime
ModifiedDate datetime NOT NULL ModifiedDate DateTime
Sales.SpecialOffer SpecialOffer
SpecialOfferID int NOT NULL Identity SpecialOfferID Int32 SpecialOfferProduct
Description nvarchar(255) NOT NULL Description String
DiscountPct smallmoney NOT NULL DiscountPct Decimal
Type nvarchar(50) NOT NULL Type String
Category nvarchar(50) NOT NULL Category String
StartDate datetime NOT NULL StartDate DateTime
EndDate datetime NOT NULL EndDate DateTime
MinQty int NOT NULL MinQty Int32
MaxQty int MaxQty Int32
rowguid uniqueidentifier NOT NULL rowguid Guid
ModifiedDate datetime NOT NULL ModifiedDate DateTime
Sales.SpecialOfferProduct SpecialOfferProduct
SpecialOfferID int NOT NULL SpecialOfferID Int32 Product
ProductID int NOT NULL ProductID Int32 Product
rowguid uniqueidentifier NOT NULL rowguid Guid
ModifiedDate datetime NOT NULL ModifiedDate DateTime
Sales.Store Store
CustomerID int NOT NULL CustomerID Int32 Customer
Name nvarchar(50) NOT NULL Name String
SalesPersonID int SalesPerson
Demographics xml Demographics String
rowguid uniqueidentifier NOT NULL rowguid Guid
ModifiedDate datetime NOT NULL ModifiedDate DateTime
Sales.StoreContact StoreContact
CustomerID int NOT NULL CustomerID Int32 Contact
ContactID int NOT NULL ContactID Int32 Contact
ContactTypeID int NOT NULL ContactType
rowguid uniqueidentifier NOT NULL rowguid Guid
ModifiedDate datetime NOT NULL ModifiedDate DateTime
HumanResources.vEmployee vEmployee
EmployeeID int NOT NULL EmployeeID Int32
Title nvarchar(8) Title String
FirstName nvarchar(50) NOT NULL FirstName String
MiddleName nvarchar(50) MiddleName String
LastName nvarchar(50) NOT NULL LastName String
Suffix nvarchar(10) Suffix String
JobTitle nvarchar(50) NOT NULL JobTitle String
Phone nvarchar(25) Phone String
EmailAddress nvarchar(50) EmailAddress String
EmailPromotion int NOT NULL EmailPromotion Int32
AddressLine1 nvarchar(60) NOT NULL AddressLine1 String
AddressLine2 nvarchar(60) AddressLine2 String
City nvarchar(30) NOT NULL City String
StateProvinceName nvarchar(50) NOT NULL StateProvinceName String
PostalCode nvarchar(15) NOT NULL PostalCode String
CountryRegionName nvarchar(50) NOT NULL CountryRegionName String
AdditionalContactInfo xml AdditionalContactInfo String
HumanResources.vEmployeeDepartment vEmployeeDepartment
EmployeeID int NOT NULL EmployeeID Int32
Title nvarchar(8) Title String
FirstName nvarchar(50) NOT NULL FirstName String
MiddleName nvarchar(50) MiddleName String
LastName nvarchar(50) NOT NULL LastName String
Suffix nvarchar(10) Suffix String
JobTitle nvarchar(50) NOT NULL JobTitle String
Department nvarchar(50) NOT NULL Department String
GroupName nvarchar(50) NOT NULL GroupName String
StartDate datetime NOT NULL StartDate DateTime
HumanResources.vEmployeeDepartmentHistory vEmployeeDepartmentHistory
EmployeeID int NOT NULL EmployeeID Int32
Title nvarchar(8) Title String
FirstName nvarchar(50) NOT NULL FirstName String
MiddleName nvarchar(50) MiddleName String
LastName nvarchar(50) NOT NULL LastName String
Suffix nvarchar(10) Suffix String
Shift nvarchar(50) NOT NULL Shift String
Department nvarchar(50) NOT NULL Department String
GroupName nvarchar(50) NOT NULL GroupName String
StartDate datetime NOT NULL StartDate DateTime
EndDate datetime EndDate DateTime
HumanResources.vJobCandidate vJobCandidate
JobCandidateID int NOT NULL Identity JobCandidateID Int32
EmployeeID int EmployeeID Int32
Name.Prefix nvarchar(30) Name_Prefix String
Name.First nvarchar(30) Name_First String
Name.Middle nvarchar(30) Name_Middle String
Name.Last nvarchar(30) Name_Last String
Name.Suffix nvarchar(30) Name_Suffix String
Skills nvarchar(max) Skills String
Addr.Type nvarchar(30) Addr_Type String
Addr.Loc.CountryRegion nvarchar(100) Addr_Loc_CountryRegion String
Addr.Loc.State nvarchar(100) Addr_Loc_State String
Addr.Loc.City nvarchar(100) Addr_Loc_City String
Addr.PostalCode nvarchar(20) Addr_PostalCode String
EMail nvarchar(max) EMail String
WebSite nvarchar(max) WebSite String
ModifiedDate datetime NOT NULL ModifiedDate DateTime
HumanResources.vJobCandidateEducation vJobCandidateEducation
JobCandidateID int NOT NULL Identity JobCandidateID Int32
Edu.Level nvarchar(max) Edu_Level String
Edu.StartDate datetime Edu_StartDate DateTime
Edu.EndDate datetime Edu_EndDate DateTime
Edu.Degree nvarchar(50) Edu_Degree String
Edu.Major nvarchar(50) Edu_Major String
Edu.Minor nvarchar(50) Edu_Minor String
Edu.GPA nvarchar(5) Edu_GPA String
Edu.GPAScale nvarchar(5) Edu_GPAScale String
Edu.School nvarchar(100) Edu_School String
Edu.Loc.CountryRegion nvarchar(100) Edu_Loc_CountryRegion String
Edu.Loc.State nvarchar(100) Edu_Loc_State String
Edu.Loc.City nvarchar(100) Edu_Loc_City String
HumanResources.vJobCandidateEmployment vJobCandidateEmployment
JobCandidateID int NOT NULL Identity JobCandidateID Int32
Emp.StartDate datetime Emp_StartDate DateTime
Emp.EndDate datetime Emp_EndDate DateTime
Emp.OrgName nvarchar(100) Emp_OrgName String
Emp.JobTitle nvarchar(100) Emp_JobTitle String
Emp.Responsibility nvarchar(max) Emp_Responsibility String
Emp.FunctionCategory nvarchar(max) Emp_FunctionCategory String
Emp.IndustryCategory nvarchar(max) Emp_IndustryCategory String
Emp.Loc.CountryRegion nvarchar(max) Emp_Loc_CountryRegion String
Emp.Loc.State nvarchar(max) Emp_Loc_State String
Emp.Loc.City nvarchar(max) Emp_Loc_City String
Person.vAdditionalContactInfo vAdditionalContactInfo
ContactID int NOT NULL Identity ContactID Int32
FirstName nvarchar(50) NOT NULL FirstName String
MiddleName nvarchar(50) MiddleName String
LastName nvarchar(50) NOT NULL LastName String
TelephoneNumber nvarchar(50) TelephoneNumber String
TelephoneSpecialInstructions nvarchar(max) TelephoneSpecialInstructions String
Street nvarchar(50) Street String
City nvarchar(50) City String
StateProvince nvarchar(50) StateProvince String
PostalCode nvarchar(50) PostalCode String
CountryRegion nvarchar(50) CountryRegion String
HomeAddressSpecialInstructions nvarchar(max) HomeAddressSpecialInstructions String
EMailAddress nvarchar(128) EMailAddress String
EMailSpecialInstructions nvarchar(max) EMailSpecialInstructions String
EMailTelephoneNumber nvarchar(50) EMailTelephoneNumber String
rowguid uniqueidentifier NOT NULL rowguid Guid
ModifiedDate datetime NOT NULL ModifiedDate DateTime
Person.vStateProvinceCountryRegion vStateProvinceCountryRegion
StateProvinceID int NOT NULL StateProvinceID Int32
StateProvinceCode nchar(3) NOT NULL StateProvinceCode String
IsOnlyStateProvinceFlag bit NOT NULL IsOnlyStateProvinceFlag Boolean
StateProvinceName nvarchar(50) NOT NULL StateProvinceName String
TerritoryID int NOT NULL TerritoryID Int32
CountryRegionCode nvarchar(3) NOT NULL CountryRegionCode String
CountryRegionName nvarchar(50) NOT NULL CountryRegionName String
Production.vProductAndDescription vProductAndDescription
ProductID int NOT NULL ProductID Int32
Name nvarchar(50) NOT NULL Name String
ProductModel nvarchar(50) NOT NULL ProductModel String
CultureID nchar(6) NOT NULL CultureID String
Description nvarchar(400) NOT NULL Description String
Production.vProductModelCatalogDescription vProductModelCatalogDescription
ProductModelID int NOT NULL Identity ProductModelID Int32
Name nvarchar(50) NOT NULL Name String
Summary nvarchar(max) Summary String
Manufacturer nvarchar(max) Manufacturer String
Copyright nvarchar(30) Copyright String
ProductURL nvarchar(256) ProductURL String
WarrantyPeriod nvarchar(256) WarrantyPeriod String
WarrantyDescription nvarchar(256) WarrantyDescription String
NoOfYears nvarchar(256) NoOfYears String
MaintenanceDescription nvarchar(256) MaintenanceDescription String
Wheel nvarchar(256) Wheel String
Saddle nvarchar(256) Saddle String
Pedal nvarchar(256) Pedal String
BikeFrame nvarchar(max) BikeFrame String
Crankset nvarchar(256) Crankset String
PictureAngle nvarchar(256) PictureAngle String
PictureSize nvarchar(256) PictureSize String
ProductPhotoID nvarchar(256) ProductPhotoID String
Material nvarchar(256) Material String
Color nvarchar(256) Color String
ProductLine nvarchar(256) ProductLine String
Style nvarchar(256) Style String
RiderExperience nvarchar(1024) RiderExperience String
rowguid uniqueidentifier NOT NULL rowguid Guid
ModifiedDate datetime NOT NULL ModifiedDate DateTime
Production.vProductModelInstructions vProductModelInstructions
ProductModelID int NOT NULL Identity ProductModelID Int32
Name nvarchar(50) NOT NULL Name String
Instructions nvarchar(max) Instructions String
LocationID int LocationID Int32
SetupHours decimal SetupHours Decimal
MachineHours decimal MachineHours Decimal
LaborHours decimal LaborHours Decimal
LotSize int LotSize Int32
Step nvarchar(1024) Step String
rowguid uniqueidentifier NOT NULL rowguid Guid
ModifiedDate datetime NOT NULL ModifiedDate DateTime
Purchasing.vVendor vVendor
VendorID int NOT NULL VendorID Int32
Name nvarchar(50) NOT NULL Name String
ContactType nvarchar(50) NOT NULL ContactType String
Title nvarchar(8) Title String
FirstName nvarchar(50) NOT NULL FirstName String
MiddleName nvarchar(50) MiddleName String
LastName nvarchar(50) NOT NULL LastName String
Suffix nvarchar(10) Suffix String
Phone nvarchar(25) Phone String
EmailAddress nvarchar(50) EmailAddress String
EmailPromotion int NOT NULL EmailPromotion Int32
AddressLine1 nvarchar(60) NOT NULL AddressLine1 String
AddressLine2 nvarchar(60) AddressLine2 String
City nvarchar(30) NOT NULL City String
StateProvinceName nvarchar(50) NOT NULL StateProvinceName String
PostalCode nvarchar(15) NOT NULL PostalCode String
CountryRegionName nvarchar(50) NOT NULL CountryRegionName String
Sales.vIndividualCustomer vIndividualCustomer
CustomerID int NOT NULL CustomerID Int32
Title nvarchar(8) Title String
FirstName nvarchar(50) NOT NULL FirstName String
MiddleName nvarchar(50) MiddleName String
LastName nvarchar(50) NOT NULL LastName String
Suffix nvarchar(10) Suffix String
Phone nvarchar(25) Phone String
EmailAddress nvarchar(50) EmailAddress String
EmailPromotion int NOT NULL EmailPromotion Int32
AddressType nvarchar(50) NOT NULL AddressType String
AddressLine1 nvarchar(60) NOT NULL AddressLine1 String
AddressLine2 nvarchar(60) AddressLine2 String
City nvarchar(30) NOT NULL City String
StateProvinceName nvarchar(50) NOT NULL StateProvinceName String
PostalCode nvarchar(15) NOT NULL PostalCode String
CountryRegionName nvarchar(50) NOT NULL CountryRegionName String
Demographics xml Demographics String
Sales.vIndividualDemographics vIndividualDemographics
CustomerID int NOT NULL CustomerID Int32
TotalPurchaseYTD money TotalPurchaseYTD Decimal
DateFirstPurchase datetime DateFirstPurchase DateTime
BirthDate datetime BirthDate DateTime
MaritalStatus nvarchar(1) MaritalStatus String
YearlyIncome nvarchar(30) YearlyIncome String
Gender nvarchar(1) Gender String
TotalChildren int TotalChildren Int32
NumberChildrenAtHome int NumberChildrenAtHome Int32
Education nvarchar(30) Education String
Occupation nvarchar(30) Occupation String
HomeOwnerFlag bit HomeOwnerFlag Boolean
NumberCarsOwned int NumberCarsOwned Int32
Sales.vSalesPerson vSalesPerson
SalesPersonID int NOT NULL SalesPersonID Int32
Title nvarchar(8) Title String
FirstName nvarchar(50) NOT NULL FirstName String
MiddleName nvarchar(50) MiddleName String
LastName nvarchar(50) NOT NULL LastName String
Suffix nvarchar(10) Suffix String
JobTitle nvarchar(50) NOT NULL JobTitle String
Phone nvarchar(25) Phone String
EmailAddress nvarchar(50) EmailAddress String
EmailPromotion int NOT NULL EmailPromotion Int32
AddressLine1 nvarchar(60) NOT NULL AddressLine1 String
AddressLine2 nvarchar(60) AddressLine2 String
City nvarchar(30) NOT NULL City String
StateProvinceName nvarchar(50) NOT NULL StateProvinceName String
PostalCode nvarchar(15) NOT NULL PostalCode String
CountryRegionName nvarchar(50) NOT NULL CountryRegionName String
TerritoryName nvarchar(50) TerritoryName String
TerritoryGroup nvarchar(50) TerritoryGroup String
SalesQuota money SalesQuota Decimal
SalesYTD money NOT NULL SalesYTD Decimal
SalesLastYear money NOT NULL SalesLastYear Decimal
Sales.vSalesPersonSalesByFiscalYears vSalesPersonSalesByFiscalYears
SalesPersonID int SalesPersonID Int32
FullName nvarchar(152) FullName String
Title nvarchar(50) NOT NULL Title String
SalesTerritory nvarchar(50) NOT NULL SalesTerritory String
2002 money C2002 Decimal
2003 money C2003 Decimal
2004 money C2004 Decimal
Sales.vStoreWithDemographics vStoreWithDemographics
CustomerID int NOT NULL CustomerID Int32
Name nvarchar(50) NOT NULL Name String
ContactType nvarchar(50) NOT NULL ContactType String
Title nvarchar(8) Title String
FirstName nvarchar(50) NOT NULL FirstName String
MiddleName nvarchar(50) MiddleName String
LastName nvarchar(50) NOT NULL LastName String
Suffix nvarchar(10) Suffix String
Phone nvarchar(25) Phone String
EmailAddress nvarchar(50) EmailAddress String
EmailPromotion int NOT NULL EmailPromotion Int32
AddressType nvarchar(50) NOT NULL AddressType String
AddressLine1 nvarchar(60) NOT NULL AddressLine1 String
AddressLine2 nvarchar(60) AddressLine2 String
City nvarchar(30) NOT NULL City String
StateProvinceName nvarchar(50) NOT NULL StateProvinceName String
PostalCode nvarchar(15) NOT NULL PostalCode String
CountryRegionName nvarchar(50) NOT NULL CountryRegionName String
AnnualSales money AnnualSales Decimal
AnnualRevenue money AnnualRevenue Decimal
BankName nvarchar(50) BankName String
BusinessType nvarchar(5) BusinessType String
YearOpened int YearOpened Int32
Specialty nvarchar(50) Specialty String
SquareFeet int SquareFeet Int32
Brands nvarchar(30) Brands String
Internet nvarchar(30) Internet String
NumberEmployees int NumberEmployees Int32
Retrieved from "http://dbshelp.devio.at/index.php?title=AdventureWorks_Table%2BColumn_Mapping_EF1&oldid=2703"