AdventureWorks Table+Column Mapping EF1

From dbscript Online Help
Jump to: navigation, search

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