edmx upload
Version |
20100609 200009 AdventureWorks2005ef1.edmx |
Version Date |
2010-06-09 |
Documentation generated by dbscript |
Table of Contents
AWBuildVersion (dbo) 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 |
DatabaseLog (dbo) 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 |
ErrorLog (dbo) 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 |
Department (HumanResources) 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 |
Employee (HumanResources) 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 |
EmployeeAddress (HumanResources) 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 |
EmployeeDepartmentHistory (HumanResources) 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 |
EmployeePayHistory (HumanResources) 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 |
JobCandidate (HumanResources) JobCandidate |
|
|
|
JobCandidateID int NOT NULL Identity |
JobCandidateID Int32 Employee |
|
EmployeeID int |
Employee |
|
Resume xml |
Resume String |
|
ModifiedDate datetime NOT NULL |
ModifiedDate DateTime |
Shift (HumanResources) 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 |
Address (Person) 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 |
AddressType (Person) 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 |
Contact (Person) 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 |
ContactType (Person) ContactType |
|
|
|
ContactTypeID int NOT NULL Identity |
ContactTypeID Int32 StoreContact |
|
Name nvarchar(50) NOT NULL |
Name String |
|
ModifiedDate datetime NOT NULL |
ModifiedDate DateTime |
CountryRegion (Person) CountryRegion |
|
|
|
CountryRegionCode nvarchar(3) NOT NULL |
CountryRegionCode String CountryRegionCurrency |
|
Name nvarchar(50) NOT NULL |
Name String |
|
ModifiedDate datetime NOT NULL |
ModifiedDate DateTime |
StateProvince (Person) 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 |
BillOfMaterials (Production) 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 |
Culture (Production) Culture |
|
|
|
CultureID nchar(6) NOT NULL |
CultureID String ProductModelProductDescriptionCulture |
|
Name nvarchar(50) NOT NULL |
Name String |
|
ModifiedDate datetime NOT NULL |
ModifiedDate DateTime |
Document (Production) 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 |
Illustration (Production) Illustration |
|
|
|
IllustrationID int NOT NULL Identity |
IllustrationID Int32 ProductModelIllustration |
|
Diagram xml |
Diagram String |
|
ModifiedDate datetime NOT NULL |
ModifiedDate DateTime |
Location (Production) 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 |
Product (Production) 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 |
ProductCategory (Production) 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 |
ProductCostHistory (Production) 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 |
ProductDescription (Production) 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 |
ProductDocument (Production) ProductDocument |
|
|
|
ProductID int NOT NULL |
ProductID Int32 Document |
|
DocumentID int NOT NULL |
DocumentID Int32 Document |
|
ModifiedDate datetime NOT NULL |
ModifiedDate DateTime |
ProductInventory (Production) 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 |
ProductListPriceHistory (Production) 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 |
ProductModel (Production) 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 |
ProductModelIllustration (Production) ProductModelIllustration |
|
|
|
ProductModelID int NOT NULL |
ProductModelID Int32 Illustration |
|
IllustrationID int NOT NULL |
IllustrationID Int32 Illustration |
|
ModifiedDate datetime NOT NULL |
ModifiedDate DateTime |
ProductModelProductDescriptionCulture (Production) 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 |
ProductPhoto (Production) 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 |
ProductProductPhoto (Production) 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 |
ProductReview (Production) 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 |
ProductSubcategory (Production) 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 |
ScrapReason (Production) ScrapReason |
|
|
|
ScrapReasonID smallint NOT NULL Identity |
ScrapReasonID Int16 WorkOrder |
|
Name nvarchar(50) NOT NULL |
Name String |
|
ModifiedDate datetime NOT NULL |
ModifiedDate DateTime |
TransactionHistory (Production) 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 |
TransactionHistoryArchive (Production) 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 |
UnitMeasure (Production) UnitMeasure |
|
|
|
UnitMeasureCode nchar(3) NOT NULL |
UnitMeasureCode String BillOfMaterials |
|
Name nvarchar(50) NOT NULL |
Name String |
|
ModifiedDate datetime NOT NULL |
ModifiedDate DateTime |
WorkOrder (Production) 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 |
WorkOrderRouting (Production) 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 |
ProductVendor (Purchasing) 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 |
PurchaseOrderDetail (Purchasing) 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 |
PurchaseOrderHeader (Purchasing) 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 |
ShipMethod (Purchasing) 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 |
Vendor (Purchasing) 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 |
VendorAddress (Purchasing) 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 |
VendorContact (Purchasing) 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 |
ContactCreditCard (Sales) ContactCreditCard |
|
|
|
ContactID int NOT NULL |
ContactID Int32 Contact |
|
CreditCardID int NOT NULL |
CreditCardID Int32 Contact |
|
ModifiedDate datetime NOT NULL |
ModifiedDate DateTime |
CountryRegionCurrency (Sales) CountryRegionCurrency |
|
|
|
CountryRegionCode nvarchar(3) NOT NULL |
CountryRegionCode String CountryRegion |
|
CurrencyCode nchar(3) NOT NULL |
CurrencyCode String CountryRegion |
|
ModifiedDate datetime NOT NULL |
ModifiedDate DateTime |
CreditCard (Sales) 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 |
Currency (Sales) Currency |
|
|
|
CurrencyCode nchar(3) NOT NULL |
CurrencyCode String CountryRegionCurrency |
|
Name nvarchar(50) NOT NULL |
Name String |
|
ModifiedDate datetime NOT NULL |
ModifiedDate DateTime |
CurrencyRate (Sales) 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 |
Customer (Sales) 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 |
CustomerAddress (Sales) 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 |
Individual (Sales) Individual |
|
|
|
CustomerID int NOT NULL |
CustomerID Int32 Contact |
|
ContactID int NOT NULL |
Contact |
|
Demographics xml |
Demographics String |
|
ModifiedDate datetime NOT NULL |
ModifiedDate DateTime |
SalesOrderDetail (Sales) 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 |
SalesOrderHeader (Sales) 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 |
SalesOrderHeaderSalesReason (Sales) SalesOrderHeaderSalesReason |
|
|
|
SalesOrderID int NOT NULL |
SalesOrderID Int32 SalesOrderHeader |
|
SalesReasonID int NOT NULL |
SalesReasonID Int32 SalesOrderHeader |
|
ModifiedDate datetime NOT NULL |
ModifiedDate DateTime |
SalesPerson (Sales) 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 |
SalesPersonQuotaHistory (Sales) 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 |
SalesReason (Sales) 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 |
SalesTaxRate (Sales) 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 |
SalesTerritory (Sales) 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 |
SalesTerritoryHistory (Sales) 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 |
ShoppingCartItem (Sales) 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 |
SpecialOffer (Sales) 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 |
SpecialOfferProduct (Sales) 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 |
Store (Sales) 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 |
StoreContact (Sales) 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 |
vEmployee (HumanResources) 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 |
vEmployeeDepartment (HumanResources) 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 |
vEmployeeDepartmentHistory (HumanResources) 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 |
vJobCandidate (HumanResources) 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 |
vJobCandidateEducation (HumanResources) 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 |
vJobCandidateEmployment (HumanResources) 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 |
vAdditionalContactInfo (Person) 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 |
vStateProvinceCountryRegion (Person) 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 |
vProductAndDescription (Production) 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 |
vProductModelCatalogDescription (Production) 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 |
vProductModelInstructions (Production) 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 |
vVendor (Purchasing) 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 |
vIndividualCustomer (Sales) 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 |
vIndividualDemographics (Sales) 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 |
vSalesPerson (Sales) 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 |
vSalesPersonSalesByFiscalYears (Sales) 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 |
vStoreWithDemographics (Sales) 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 |