Database reference - AdventureWorks

AdventureWorks -  table columns

All table columns

parentcolumndefinitioncomment
AWBuildVersionSystemInformationIDtinyint identity NOT NULLPrimary key for AWBuildVersion records. 
AWBuildVersionDatabase Versionnvarchar(25) NOT NULLVersion number of the database in 9.yy.mm.dd.00 format. 
AWBuildVersionVersionDatedatetime NOT NULLDate and time the record was last updated. 
AWBuildVersionModifiedDatedatetime NOT NULL = (getdate())Date and time the record was last updated. 
DatabaseLogDatabaseLogIDint identity NOT NULLPrimary key for DatabaseLog records. 
DatabaseLogPostTimedatetime NOT NULLThe date and time the DDL change occurred. 
DatabaseLogDatabaseUsersysname NOT NULLThe user who implemented the DDL change. 
DatabaseLogEventsysname NOT NULLThe type of DDL statement that was executed. 
DatabaseLogSchemasysname NULLThe schema to which the changed object belongs. 
DatabaseLogObjectsysname NULLThe object that was changed by the DDL statment. 
DatabaseLogTSQLnvarchar(max) NOT NULLThe exact Transact-SQL statement that was executed. 
DatabaseLogXmlEventxml NOT NULLThe raw XML data generated by database trigger. 
ErrorLogErrorLogIDint identity NOT NULLPrimary key for ErrorLog records. 
ErrorLogErrorTimedatetime NOT NULL = (getdate())The date and time at which the error occurred. 
ErrorLogUserNamesysname NOT NULLThe user who executed the batch in which the error occurred. 
ErrorLogErrorNumberint NOT NULLThe error number of the error that occurred. 
ErrorLogErrorSeverityint NULLThe severity of the error that occurred. 
ErrorLogErrorStateint NULLThe state number of the error that occurred. 
ErrorLogErrorProcedurenvarchar(126) NULLThe name of the stored procedure or trigger where the error occurred. 
ErrorLogErrorLineint NULLThe line number at which the error occurred. 
ErrorLogErrorMessagenvarchar(4000) NOT NULLThe message text of the error that occurred. 
DepartmentDepartmentIDsmallint identity NOT NULLPrimary key for Department records. 
DepartmentNameName NOT NULLName of the department. 
DepartmentGroupNameName NOT NULLName of the group to which the department belongs. 
DepartmentModifiedDatedatetime NOT NULL = (getdate())Date and time the record was last updated. 
EmployeeEmployeeIDint identity NOT NULLPrimary key for Employee records. 
EmployeeNationalIDNumbernvarchar(15) NOT NULLUnique national identification number such as a social security number. 
EmployeeContactIDint NOT NULLIdentifies the employee in the Contact table. Foreign key to Contact.ContactID. 
EmployeeLoginIDnvarchar(256) NOT NULLNetwork login. 
EmployeeManagerIDint NULLManager to whom the employee is assigned. Foreign Key to Employee.M 
EmployeeTitlenvarchar(50) NOT NULLWork title such as Buyer or Sales Representative. 
EmployeeBirthDatedatetime NOT NULLDate of birth. 
EmployeeMaritalStatusnchar(1) NOT NULLM = Married, S = Single 
EmployeeGendernchar(1) NOT NULLM = Male, F = Female 
EmployeeHireDatedatetime NOT NULLEmployee hired on this date. 
EmployeeSalariedFlagFlag NOT NULL = ((1))Job classification. 0 = Hourly, not exempt from collective bargaining. 1 = Salaried, exempt from collective bargaining. 
EmployeeVacationHourssmallint NOT NULL = ((0))Number of available vacation hours. 
EmployeeSickLeaveHourssmallint NOT NULL = ((0))Number of available sick leave hours. 
EmployeeCurrentFlagFlag NOT NULL = ((1))0 = Inactive, 1 = Active 
Employeerowguiduniqueidentifier NOT NULL = (newid())ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. 
EmployeeModifiedDatedatetime NOT NULL = (getdate())Date and time the record was last updated. 
EmployeeAddressEmployeeIDint NOT NULLPrimary key. Foreign key to Employee.EmployeeID. 
EmployeeAddressAddressIDint NOT NULLPrimary key. Foreign key to Address.AddressID. 
EmployeeAddressrowguiduniqueidentifier NOT NULL = (newid())ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. 
EmployeeAddressModifiedDatedatetime NOT NULL = (getdate())Date and time the record was last updated. 
EmployeeDepartmentHistoryEmployeeIDint NOT NULLEmployee identification number. Foreign key to Employee.EmployeeID. 
EmployeeDepartmentHistoryDepartmentIDsmallint NOT NULLDepartment in which the employee worked including currently. Foreign key to Department.DepartmentID. 
EmployeeDepartmentHistoryShiftIDtinyint NOT NULLIdentifies which 8-hour shift the employee works. Foreign key to Shift.Shift.ID. 
EmployeeDepartmentHistoryStartDatedatetime NOT NULLDate the employee started work in the department. 
EmployeeDepartmentHistoryEndDatedatetime NULLDate the employee left the department. NULL = Current department. 
EmployeeDepartmentHistoryModifiedDatedatetime NOT NULL = (getdate())Date and time the record was last updated. 
EmployeePayHistoryEmployeeIDint NOT NULLEmployee identification number. Foreign key to Employee.EmployeeID. 
EmployeePayHistoryRateChangeDatedatetime NOT NULLDate the change in pay is effective 
EmployeePayHistoryRatemoney NOT NULLSalary hourly rate. 
EmployeePayHistoryPayFrequencytinyint NOT NULL1 = Salary received monthly, 2 = Salary received biweekly 
EmployeePayHistoryModifiedDatedatetime NOT NULL = (getdate())Date and time the record was last updated. 
JobCandidateJobCandidateIDint identity NOT NULLPrimary key for JobCandidate records. 
JobCandidateEmployeeIDint NULLEmployee identification number if applicant was hired. Foreign key to Employee.EmployeeID. 
JobCandidateResumexml NULLRésumé in XML format. 
JobCandidateModifiedDatedatetime NOT NULL = (getdate())Date and time the record was last updated. 
ShiftShiftIDtinyint identity NOT NULLPrimary key for Shift records. 
ShiftNameName NOT NULLShift description. 
ShiftStartTimedatetime NOT NULLShift start time. 
ShiftEndTimedatetime NOT NULLShift end time. 
ShiftModifiedDatedatetime NOT NULL = (getdate())Date and time the record was last updated. 
AddressAddressIDint identity NOT NULLPrimary key for Address records. 
AddressAddressLine1nvarchar(60) NOT NULLFirst street address line. 
AddressAddressLine2nvarchar(60) NULLSecond street address line. 
AddressCitynvarchar(30) NOT NULLName of the city. 
AddressStateProvinceIDint NOT NULLUnique identification number for the state or province. Foreign key to StateProvince table. 
AddressPostalCodenvarchar(15) NOT NULLPostal code for the street address. 
Addressrowguiduniqueidentifier NOT NULL = (newid())ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. 
AddressModifiedDatedatetime NOT NULL = (getdate())Date and time the record was last updated. 
AddressTypeAddressTypeIDint identity NOT NULLPrimary key for AddressType records. 
AddressTypeNameName NOT NULLAddress type description. For example, Billing, Home, or Shipping. 
AddressTyperowguiduniqueidentifier NOT NULL = (newid())ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. 
AddressTypeModifiedDatedatetime NOT NULL = (getdate())Date and time the record was last updated. 
ContactContactIDint identity NOT NULLPrimary key for Contact records. 
ContactNameStyleNameStyle NOT NULL = ((0))0 = The data in FirstName and LastName are stored in western style (first name, last name) order. 1 = Eastern style (last name, first name) order. 
ContactTitlenvarchar(8) NULLA courtesy title. For example, Mr. or Ms. 
ContactFirstNameName NOT NULLFirst name of the person. 
ContactMiddleNameName NULLMiddle name or middle initial of the person. 
ContactLastNameName NOT NULLLast name of the person. 
ContactSuffixnvarchar(10) NULLSurname suffix. For example, Sr. or Jr. 
ContactEmailAddressnvarchar(50) NULLE-mail address for the person. 
ContactEmailPromotionint NOT NULL = ((0))0 = Contact does not wish to receive e-mail promotions, 1 = Contact does wish to receive e-mail promotions from AdventureWorks, 2 = Contact does wish to receive e-mail promotions from AdventureWorks and selected partners.  
ContactPhonePhone NULLPhone number associated with the person. 
ContactPasswordHashvarchar(128) NOT NULLPassword for the e-mail account. 
ContactPasswordSaltvarchar(10) NOT NULLRandom value concatenated with the password string before the password is hashed. 
ContactAdditionalContactInfoxml NULLAdditional contact information about the person stored in xml format.  
Contactrowguiduniqueidentifier NOT NULL = (newid())ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. 
ContactModifiedDatedatetime NOT NULL = (getdate())Date and time the record was last updated. 
ContactTypeContactTypeIDint identity NOT NULLPrimary key for ContactType records. 
ContactTypeNameName NOT NULLContact type description. 
ContactTypeModifiedDatedatetime NOT NULL = (getdate())Date and time the record was last updated. 
CountryRegionCountryRegionCodenvarchar(3) NOT NULLISO standard code for countries and regions. 
CountryRegionNameName NOT NULLCountry or region name. 
CountryRegionModifiedDatedatetime NOT NULL = (getdate())Date and time the record was last updated. 
StateProvinceStateProvinceIDint identity NOT NULLPrimary key for StateProvince records. 
StateProvinceStateProvinceCodenchar(3) NOT NULLISO standard state or province code. 
StateProvinceCountryRegionCodenvarchar(3) NOT NULLISO standard country or region code. Foreign key to CountryRegion.CountryRegionCode.  
StateProvinceIsOnlyStateProvinceFlagFlag NOT NULL = ((1))0 = StateProvinceCode exists. 1 = StateProvinceCode unavailable, using CountryRegionCode. 
StateProvinceNameName NOT NULLState or province description. 
StateProvinceTerritoryIDint NOT NULLID of the territory in which the state or province is located. Foreign key to SalesTerritory.SalesTerritoryID. 
StateProvincerowguiduniqueidentifier NOT NULL = (newid())ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. 
StateProvinceModifiedDatedatetime NOT NULL = (getdate())Date and time the record was last updated. 
BillOfMaterialsBillOfMaterialsIDint identity NOT NULLPrimary key for BillOfMaterials records. 
BillOfMaterialsProductAssemblyIDint NULLParent product identification number. Foreign key to Product.ProductID. 
BillOfMaterialsComponentIDint NOT NULLComponent identification number. Foreign key to Product.ProductID. 
BillOfMaterialsStartDatedatetime NOT NULL = (getdate())Date the component started being used in the assembly item. 
BillOfMaterialsEndDatedatetime NULLDate the component stopped being used in the assembly item. 
BillOfMaterialsUnitMeasureCodenchar(3) NOT NULLStandard code identifying the unit of measure for the quantity. 
BillOfMaterialsBOMLevelsmallint NOT NULLIndicates the depth the component is from its parent (AssemblyID). 
BillOfMaterialsPerAssemblyQtydecimal(8,2) NOT NULL = ((1.00))Quantity of the component needed to create the assembly. 
BillOfMaterialsModifiedDatedatetime NOT NULL = (getdate())Date and time the record was last updated. 
CultureCultureIDnchar(6) NOT NULLPrimary key for Culture records. 
CultureNameName NOT NULLCulture description. 
CultureModifiedDatedatetime NOT NULL = (getdate())Date and time the record was last updated. 
DocumentDocumentIDint identity NOT NULLPrimary key for Document records. 
DocumentTitlenvarchar(50) NOT NULLTitle of the document. 
DocumentFileNamenvarchar(400) NOT NULLDirectory path and file name of the document 
DocumentFileExtensionnvarchar(8) NOT NULLFile extension indicating the document type. For example, .doc or .txt. 
DocumentRevisionnchar(5) NOT NULLRevision number of the document.  
DocumentChangeNumberint NOT NULL = ((0))Engineering change approval number. 
DocumentStatustinyint NOT NULL1 = Pending approval, 2 = Approved, 3 = Obsolete 
DocumentDocumentSummarynvarchar(max) NULLDocument abstract. 
DocumentDocumentvarbinary NULLComplete document. 
DocumentModifiedDatedatetime NOT NULL = (getdate())Date and time the record was last updated. 
IllustrationIllustrationIDint identity NOT NULLPrimary key for Illustration records. 
IllustrationDiagramxml NULLIllustrations used in manufacturing instructions. Stored as XML. 
IllustrationModifiedDatedatetime NOT NULL = (getdate())Date and time the record was last updated. 
LocationLocationIDsmallint identity NOT NULLPrimary key for Location records. 
LocationNameName NOT NULLLocation description. 
LocationCostRatesmallmoney NOT NULL = ((0.00))Standard hourly cost of the manufacturing location. 
LocationAvailabilitydecimal(8,2) NOT NULL = ((0.00))Work capacity (in hours) of the manufacturing location. 
LocationModifiedDatedatetime NOT NULL = (getdate())Date and time the record was last updated. 
ProductProductIDint identity NOT NULLPrimary key for Product records. 
ProductNameName NOT NULLName of the product. 
ProductProductNumbernvarchar(25) NOT NULLUnique product identification number. 
ProductMakeFlagFlag NOT NULL = ((1))0 = Product is purchased, 1 = Product is manufactured in-house. 
ProductFinishedGoodsFlagFlag NOT NULL = ((1))0 = Product is not a salable item. 1 = Product is salable. 
ProductColornvarchar(15) NULLProduct color. 
ProductSafetyStockLevelsmallint NOT NULLMinimum inventory quantity.  
ProductReorderPointsmallint NOT NULLInventory level that triggers a purchase order or work order.  
ProductStandardCostmoney NOT NULLStandard cost of the product. 
ProductListPricemoney NOT NULLSelling price. 
ProductSizenvarchar(5) NULLProduct size. 
ProductSizeUnitMeasureCodenchar(3) NULLUnit of measure for Size column. 
ProductWeightUnitMeasureCodenchar(3) NULLUnit of measure for Weight column. 
ProductWeightdecimal(8,2) NULLProduct weight. 
ProductDaysToManufactureint NOT NULLNumber of days required to manufacture the product. 
ProductProductLinenchar(2) NULLR = Road, M = Mountain, T = Touring, S = Standard 
ProductClassnchar(2) NULLH = High, M = Medium, L = Low 
ProductStylenchar(2) NULLW = Womens, M = Mens, U = Universal 
ProductProductSubcategoryIDint NULLProduct is a member of this product subcategory. Foreign key to ProductSubCategory.ProductSubCategoryID.  
ProductProductModelIDint NULLProduct is a member of this product model. Foreign key to ProductModel.ProductModelID. 
ProductSellStartDatedatetime NOT NULLDate the product was available for sale. 
ProductSellEndDatedatetime NULLDate the product was no longer available for sale. 
ProductDiscontinuedDatedatetime NULLDate the product was discontinued. 
Productrowguiduniqueidentifier NOT NULL = (newid())ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. 
ProductModifiedDatedatetime NOT NULL = (getdate())Date and time the record was last updated. 
ProductCategoryProductCategoryIDint identity NOT NULLPrimary key for ProductCategory records. 
ProductCategoryNameName NOT NULLCategory description. 
ProductCategoryrowguiduniqueidentifier NOT NULL = (newid())ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. 
ProductCategoryModifiedDatedatetime NOT NULL = (getdate())Date and time the record was last updated. 
ProductCostHistoryProductIDint NOT NULLProduct identification number. Foreign key to Product.ProductID 
ProductCostHistoryStartDatedatetime NOT NULLProduct cost start date. 
ProductCostHistoryEndDatedatetime NULLProduct cost end date. 
ProductCostHistoryStandardCostmoney NOT NULLStandard cost of the product. 
ProductCostHistoryModifiedDatedatetime NOT NULL = (getdate())Date and time the record was last updated. 
ProductDescriptionProductDescriptionIDint identity NOT NULLPrimary key for ProductDescription records. 
ProductDescriptionDescriptionnvarchar(400) NOT NULLDescription of the product. 
ProductDescriptionrowguiduniqueidentifier NOT NULL = (newid())ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. 
ProductDescriptionModifiedDatedatetime NOT NULL = (getdate())Date and time the record was last updated. 
ProductDocumentProductIDint NOT NULLProduct identification number. Foreign key to Product.ProductID. 
ProductDocumentDocumentIDint NOT NULLDocument identification number. Foreign key to Document.DocumentID. 
ProductDocumentModifiedDatedatetime NOT NULL = (getdate())Date and time the record was last updated. 
ProductInventoryProductIDint NOT NULLProduct identification number. Foreign key to Product.ProductID. 
ProductInventoryLocationIDsmallint NOT NULLInventory location identification number. Foreign key to Location.LocationID.  
ProductInventoryShelfnvarchar(10) NOT NULLStorage compartment within an inventory location. 
ProductInventoryBintinyint NOT NULLStorage container on a shelf in an inventory location. 
ProductInventoryQuantitysmallint NOT NULL = ((0))Quantity of products in the inventory location. 
ProductInventoryrowguiduniqueidentifier NOT NULL = (newid())ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. 
ProductInventoryModifiedDatedatetime NOT NULL = (getdate())Date and time the record was last updated. 
ProductListPriceHistoryProductIDint NOT NULLProduct identification number. Foreign key to Product.ProductID 
ProductListPriceHistoryStartDatedatetime NOT NULLList price start date. 
ProductListPriceHistoryEndDatedatetime NULLList price end date 
ProductListPriceHistoryListPricemoney NOT NULLProduct list price. 
ProductListPriceHistoryModifiedDatedatetime NOT NULL = (getdate())Date and time the record was last updated. 
ProductModelProductModelIDint identity NOT NULLPrimary key for ProductModel records. 
ProductModelNameName NOT NULLProduct model description. 
ProductModelCatalogDescriptionxml NULLDetailed product catalog information in xml format. 
ProductModelInstructionsxml NULLManufacturing instructions in xml format. 
ProductModelrowguiduniqueidentifier NOT NULL = (newid())ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. 
ProductModelModifiedDatedatetime NOT NULL = (getdate())Date and time the record was last updated. 
ProductModelIllustrationProductModelIDint NOT NULLPrimary key. Foreign key to ProductModel.ProductModelID. 
ProductModelIllustrationIllustrationIDint NOT NULLPrimary key. Foreign key to Illustration.IllustrationID. 
ProductModelIllustrationModifiedDatedatetime NOT NULL = (getdate())Date and time the record was last updated. 
ProductModelProductDescriptionCultureProductModelIDint NOT NULLPrimary key. Foreign key to ProductModel.ProductModelID. 
ProductModelProductDescriptionCultureProductDescriptionIDint NOT NULLPrimary key. Foreign key to ProductDescription.ProductDescriptionID. 
ProductModelProductDescriptionCultureCultureIDnchar(6) NOT NULLCulture identification number. Foreign key to Culture.CultureID. 
ProductModelProductDescriptionCultureModifiedDatedatetime NOT NULL = (getdate())Date and time the record was last updated. 
ProductPhotoProductPhotoIDint identity NOT NULLPrimary key for ProductPhoto records. 
ProductPhotoThumbNailPhotovarbinary NULLSmall image of the product. 
ProductPhotoThumbnailPhotoFileNamenvarchar(50) NULLSmall image file name. 
ProductPhotoLargePhotovarbinary NULLLarge image of the product. 
ProductPhotoLargePhotoFileNamenvarchar(50) NULLLarge image file name. 
ProductPhotoModifiedDatedatetime NOT NULL = (getdate())Date and time the record was last updated. 
ProductProductPhotoProductIDint NOT NULLProduct identification number. Foreign key to Product.ProductID. 
ProductProductPhotoProductPhotoIDint NOT NULLProduct photo identification number. Foreign key to ProductPhoto.ProductPhotoID. 
ProductProductPhotoPrimaryFlag NOT NULL = ((0))0 = Photo is not the principal image. 1 = Photo is the principal image. 
ProductProductPhotoModifiedDatedatetime NOT NULL = (getdate())Date and time the record was last updated. 
ProductReviewProductReviewIDint identity NOT NULLPrimary key for ProductReview records. 
ProductReviewProductIDint NOT NULLProduct identification number. Foreign key to Product.ProductID. 
ProductReviewReviewerNameName NOT NULLName of the reviewer. 
ProductReviewReviewDatedatetime NOT NULL = (getdate())Date review was submitted. 
ProductReviewEmailAddressnvarchar(50) NOT NULLReviewer's e-mail address. 
ProductReviewRatingint NOT NULLProduct rating given by the reviewer. Scale is 1 to 5 with 5 as the highest rating. 
ProductReviewCommentsnvarchar(3850) NULLReviewer's comments 
ProductReviewModifiedDatedatetime NOT NULL = (getdate())Date and time the record was last updated. 
ProductSubcategoryProductSubcategoryIDint identity NOT NULLPrimary key for ProductSubcategory records. 
ProductSubcategoryProductCategoryIDint NOT NULLProduct category identification number. Foreign key to ProductCategory.ProductCategoryID. 
ProductSubcategoryNameName NOT NULLSubcategory description. 
ProductSubcategoryrowguiduniqueidentifier NOT NULL = (newid())ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. 
ProductSubcategoryModifiedDatedatetime NOT NULL = (getdate())Date and time the record was last updated. 
ScrapReasonScrapReasonIDsmallint identity NOT NULLPrimary key for ScrapReason records. 
ScrapReasonNameName NOT NULLFailure description. 
ScrapReasonModifiedDatedatetime NOT NULL = (getdate())Date and time the record was last updated. 
TransactionHistoryTransactionIDint identity NOT NULLPrimary key for TransactionHistory records. 
TransactionHistoryProductIDint NOT NULLProduct identification number. Foreign key to Product.ProductID. 
TransactionHistoryReferenceOrderIDint NOT NULLPurchase order, sales order, or work order identification number. 
TransactionHistoryReferenceOrderLineIDint NOT NULL = ((0))Line number associated with the purchase order, sales order, or work order. 
TransactionHistoryTransactionDatedatetime NOT NULL = (getdate())Date and time of the transaction. 
TransactionHistoryTransactionTypenchar(1) NOT NULLW = WorkOrder, S = SalesOrder, P = PurchaseOrder 
TransactionHistoryQuantityint NOT NULLProduct quantity. 
TransactionHistoryActualCostmoney NOT NULLProduct cost. 
TransactionHistoryModifiedDatedatetime NOT NULL = (getdate())Date and time the record was last updated. 
TransactionHistoryArchiveTransactionIDint NOT NULLPrimary key for TransactionHistoryArchive records. 
TransactionHistoryArchiveProductIDint NOT NULLProduct identification number. Foreign key to Product.ProductID. 
TransactionHistoryArchiveReferenceOrderIDint NOT NULLPurchase order, sales order, or work order identification number. 
TransactionHistoryArchiveReferenceOrderLineIDint NOT NULL = ((0))Line number associated with the purchase order, sales order, or work order. 
TransactionHistoryArchiveTransactionDatedatetime NOT NULL = (getdate())Date and time of the transaction. 
TransactionHistoryArchiveTransactionTypenchar(1) NOT NULLW = Work Order, S = Sales Order, P = Purchase Order 
TransactionHistoryArchiveQuantityint NOT NULLProduct quantity. 
TransactionHistoryArchiveActualCostmoney NOT NULLProduct cost. 
TransactionHistoryArchiveModifiedDatedatetime NOT NULL = (getdate())Date and time the record was last updated. 
UnitMeasureUnitMeasureCodenchar(3) NOT NULLPrimary key. 
UnitMeasureNameName NOT NULLUnit of measure description. 
UnitMeasureModifiedDatedatetime NOT NULL = (getdate())Date and time the record was last updated. 
WorkOrderWorkOrderIDint identity NOT NULLPrimary key for WorkOrder records. 
WorkOrderProductIDint NOT NULLProduct identification number. Foreign key to Product.ProductID. 
WorkOrderOrderQtyint NOT NULLProduct quantity to build. 
WorkOrderStockedQtyint NOT NULLQuantity built and put in inventory. 
WorkOrderScrappedQtysmallint NOT NULLQuantity that failed inspection. 
WorkOrderStartDatedatetime NOT NULLWork order start date. 
WorkOrderEndDatedatetime NULLWork order end date. 
WorkOrderDueDatedatetime NOT NULLWork order due date. 
WorkOrderScrapReasonIDsmallint NULLReason for inspection failure. 
WorkOrderModifiedDatedatetime NOT NULL = (getdate())Date and time the record was last updated. 
WorkOrderRoutingWorkOrderIDint NOT NULLPrimary key. Foreign key to WorkOrder.WorkOrderID. 
WorkOrderRoutingProductIDint NOT NULLPrimary key. Foreign key to Product.ProductID. 
WorkOrderRoutingOperationSequencesmallint NOT NULLPrimary key. Indicates the manufacturing process sequence. 
WorkOrderRoutingLocationIDsmallint NOT NULLManufacturing location where the part is processed. Foreign key to Location.LocationID. 
WorkOrderRoutingScheduledStartDatedatetime NOT NULLPlanned manufacturing start date. 
WorkOrderRoutingScheduledEndDatedatetime NOT NULLPlanned manufacturing end date. 
WorkOrderRoutingActualStartDatedatetime NULLActual start date. 
WorkOrderRoutingActualEndDatedatetime NULLActual end date. 
WorkOrderRoutingActualResourceHrsdecimal(9,4) NULLNumber of manufacturing hours used. 
WorkOrderRoutingPlannedCostmoney NOT NULLEstimated manufacturing cost. 
WorkOrderRoutingActualCostmoney NULLActual manufacturing cost. 
WorkOrderRoutingModifiedDatedatetime NOT NULL = (getdate())Date and time the record was last updated. 
ProductVendorProductIDint NOT NULLPrimary key. Foreign key to Product.ProductID. 
ProductVendorVendorIDint NOT NULLPrimary key. Foreign key to Vendor.VendorID. 
ProductVendorAverageLeadTimeint NOT NULLThe average span of time (in days) between placing an order with the vendor and receiving the purchased product. 
ProductVendorStandardPricemoney NOT NULLThe vendor's usual selling price. 
ProductVendorLastReceiptCostmoney NULLThe selling price when last purchased. 
ProductVendorLastReceiptDatedatetime NULLDate the product was last received by the vendor. 
ProductVendorMinOrderQtyint NOT NULLThe maximum quantity that should be ordered. 
ProductVendorMaxOrderQtyint NOT NULLThe minimum quantity that should be ordered. 
ProductVendorOnOrderQtyint NULLThe quantity currently on order. 
ProductVendorUnitMeasureCodenchar(3) NOT NULLThe product's unit of measure. 
ProductVendorModifiedDatedatetime NOT NULL = (getdate())Date and time the record was last updated. 
PurchaseOrderDetailPurchaseOrderIDint NOT NULLPrimary key. Foreign key to PurchaseOrderHeader.PurchaseOrderID. 
PurchaseOrderDetailPurchaseOrderDetailIDint identity NOT NULLPrimary key. One line number per purchased product. 
PurchaseOrderDetailDueDatedatetime NOT NULLDate the product is expected to be received. 
PurchaseOrderDetailOrderQtysmallint NOT NULLQuantity ordered. 
PurchaseOrderDetailProductIDint NOT NULLProduct identification number. Foreign key to Product.ProductID. 
PurchaseOrderDetailUnitPricemoney NOT NULLVendor's selling price of a single product. 
PurchaseOrderDetailLineTotalmoney NOT NULLPer product subtotal. Computed as OrderQty * UnitPrice. 
PurchaseOrderDetailReceivedQtydecimal(8,2) NOT NULLQuantity actually received from the vendor. 
PurchaseOrderDetailRejectedQtydecimal(8,2) NOT NULLQuantity rejected during inspection. 
PurchaseOrderDetailStockedQtydecimal(9,2) NOT NULLQuantity accepted into inventory. Computed as ReceivedQty - RejectedQty. 
PurchaseOrderDetailModifiedDatedatetime NOT NULL = (getdate())Date and time the record was last updated. 
PurchaseOrderHeaderPurchaseOrderIDint identity NOT NULLPrimary key. 
PurchaseOrderHeaderRevisionNumbertinyint NOT NULL = ((0))Incremental number to track changes to the purchase order over time. 
PurchaseOrderHeaderStatustinyint NOT NULL = ((1))Order current status. 1 = Pending; 2 = Approved; 3 = Rejected; 4 = Complete 
PurchaseOrderHeaderEmployeeIDint NOT NULLEmployee who created the purchase order. Foreign key to Employee.EmployeeID. 
PurchaseOrderHeaderVendorIDint NOT NULLVendor with whom the purchase order is placed. Foreign key to Vendor.VendorID. 
PurchaseOrderHeaderShipMethodIDint NOT NULLShipping method. Foreign key to ShipMethod.ShipMethodID. 
PurchaseOrderHeaderOrderDatedatetime NOT NULL = (getdate())Purchase order creation date. 
PurchaseOrderHeaderShipDatedatetime NULLEstimated shipment date from the vendor. 
PurchaseOrderHeaderSubTotalmoney NOT NULL = ((0.00))Purchase order subtotal. Computed as SUM(PurchaseOrderDetail.LineTotal)for the appropriate PurchaseOrderID. 
PurchaseOrderHeaderTaxAmtmoney NOT NULL = ((0.00))Tax amount. 
PurchaseOrderHeaderFreightmoney NOT NULL = ((0.00))Shipping cost. 
PurchaseOrderHeaderTotalDuemoney NOT NULLTotal due to vendor. Computed as Subtotal + TaxAmt + Freight. 
PurchaseOrderHeaderModifiedDatedatetime NOT NULL = (getdate())Date and time the record was last updated. 
ShipMethodShipMethodIDint identity NOT NULLPrimary key for ShipMethod records. 
ShipMethodNameName NOT NULLShipping company name. 
ShipMethodShipBasemoney NOT NULL = ((0.00))Minimum shipping charge. 
ShipMethodShipRatemoney NOT NULL = ((0.00))Shipping charge per pound. 
ShipMethodrowguiduniqueidentifier NOT NULL = (newid())ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. 
ShipMethodModifiedDatedatetime NOT NULL = (getdate())Date and time the record was last updated. 
VendorVendorIDint identity NOT NULLPrimary key for Vendor records. 
VendorAccountNumberAccountNumber NOT NULLVendor account (identification) number. 
VendorNameName NOT NULLCompany name. 
VendorCreditRatingtinyint NOT NULL1 = Superior, 2 = Excellent, 3 = Above average, 4 = Average, 5 = Below average 
VendorPreferredVendorStatusFlag NOT NULL = ((1))0 = Do not use if another vendor is available. 1 = Preferred over other vendors supplying the same product. 
VendorActiveFlagFlag NOT NULL = ((1))0 = Vendor no longer used. 1 = Vendor is actively used. 
VendorPurchasingWebServiceURLnvarchar(1024) NULLVendor URL. 
VendorModifiedDatedatetime NOT NULL = (getdate())Date and time the record was last updated. 
VendorAddressVendorIDint NOT NULLPrimary key. Foreign key to Vendor.VendorID. 
VendorAddressAddressIDint NOT NULLPrimary key. Foreign key to Address.AddressID. 
VendorAddressAddressTypeIDint NOT NULLAddress type. Foreign key to AddressType.AddressTypeID. 
VendorAddressModifiedDatedatetime NOT NULL = (getdate())Date and time the record was last updated. 
VendorContactVendorIDint NOT NULLPrimary key. 
VendorContactContactIDint NOT NULLContact (Vendor employee) identification number. Foreign key to Contact.ContactID. 
VendorContactContactTypeIDint NOT NULLContact type such as sales manager, or sales agent. 
VendorContactModifiedDatedatetime NOT NULL = (getdate())Date and time the record was last updated. 
ContactCreditCardContactIDint NOT NULLCustomer identification number. Foreign key to Contact.ContactID. 
ContactCreditCardCreditCardIDint NOT NULLCredit card identification number. Foreign key to CreditCard.CreditCardID. 
ContactCreditCardModifiedDatedatetime NOT NULL = (getdate())Date and time the record was last updated. 
CountryRegionCurrencyCountryRegionCodenvarchar(3) NOT NULLISO code for countries and regions. Foreign key to CountryRegion.CountryRegionCode. 
CountryRegionCurrencyCurrencyCodenchar(3) NOT NULLISO standard currency code. Foreign key to Currency.CurrencyCode. 
CountryRegionCurrencyModifiedDatedatetime NOT NULL = (getdate())Date and time the record was last updated. 
CreditCardCreditCardIDint identity NOT NULLPrimary key for CreditCard records. 
CreditCardCardTypenvarchar(50) NOT NULLCredit card name. 
CreditCardCardNumbernvarchar(25) NOT NULLCredit card number. 
CreditCardExpMonthtinyint NOT NULLCredit card expiration month. 
CreditCardExpYearsmallint NOT NULLCredit card expiration year. 
CreditCardModifiedDatedatetime NOT NULL = (getdate())Date and time the record was last updated. 
CurrencyCurrencyCodenchar(3) NOT NULLThe ISO code for the Currency. 
CurrencyNameName NOT NULLCurrency name. 
CurrencyModifiedDatedatetime NOT NULL = (getdate())Date and time the record was last updated. 
CurrencyRateCurrencyRateIDint identity NOT NULLPrimary key for CurrencyRate records. 
CurrencyRateCurrencyRateDatedatetime NOT NULLDate and time the exchange rate was obtained. 
CurrencyRateFromCurrencyCodenchar(3) NOT NULLExchange rate was converted from this currency code. 
CurrencyRateToCurrencyCodenchar(3) NOT NULLExchange rate was converted to this currency code. 
CurrencyRateAverageRatemoney NOT NULLAverage exchange rate for the day. 
CurrencyRateEndOfDayRatemoney NOT NULLFinal exchange rate for the day. 
CurrencyRateModifiedDatedatetime NOT NULL = (getdate())Date and time the record was last updated. 
CustomerCustomerIDint identity NOT NULLPrimary key for Customer records. 
CustomerTerritoryIDint NULLID of the territory in which the customer is located. Foreign key to SalesTerritory.SalesTerritoryID. 
CustomerAccountNumbervarchar(10) NOT NULLUnique number identifying the customer assigned by the accounting system. 
CustomerCustomerTypenchar(1) NOT NULLCustomer type: I = Individual, S = Store 
Customerrowguiduniqueidentifier NOT NULL = (newid())ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. 
CustomerModifiedDatedatetime NOT NULL = (getdate())Date and time the record was last updated. 
CustomerAddressCustomerIDint NOT NULLPrimary key. Foreign key to Customer.CustomerID. 
CustomerAddressAddressIDint NOT NULLPrimary key. Foreign key to Address.AddressID. 
CustomerAddressAddressTypeIDint NOT NULLAddress type. Foreign key to AddressType.AddressTypeID. 
CustomerAddressrowguiduniqueidentifier NOT NULL = (newid())ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. 
CustomerAddressModifiedDatedatetime NOT NULL = (getdate())Date and time the record was last updated. 
IndividualCustomerIDint NOT NULLUnique customer identification number. Foreign key to Customer.CustomerID. 
IndividualContactIDint NOT NULLIdentifies the customer in the Contact table. Foreign key to Contact.ContactID. 
IndividualDemographicsxml NULLPersonal information such as hobbies, and income collected from online shoppers. Used for sales analysis. 
IndividualModifiedDatedatetime NOT NULL = (getdate())Date and time the record was last updated. 
SalesOrderDetailSalesOrderIDint NOT NULLPrimary key. Foreign key to SalesOrderHeader.SalesOrderID. 
SalesOrderDetailSalesOrderDetailIDint identity NOT NULLPrimary key. One incremental unique number per product sold. 
SalesOrderDetailCarrierTrackingNumbernvarchar(25) NULLShipment tracking number supplied by the shipper. 
SalesOrderDetailOrderQtysmallint NOT NULLQuantity ordered per product. 
SalesOrderDetailProductIDint NOT NULLProduct sold to customer. Foreign key to Product.ProductID. 
SalesOrderDetailSpecialOfferIDint NOT NULLPromotional code. Foreign key to SpecialOffer.SpecialOfferID. 
SalesOrderDetailUnitPricemoney NOT NULLSelling price of a single product. 
SalesOrderDetailUnitPriceDiscountmoney NOT NULL = ((0.0))Discount amount. 
SalesOrderDetailLineTotalnumeric(38,6) NOT NULLPer product subtotal. Computed as UnitPrice * (1 - UnitPriceDiscount) * OrderQty. 
SalesOrderDetailrowguiduniqueidentifier NOT NULL = (newid())ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. 
SalesOrderDetailModifiedDatedatetime NOT NULL = (getdate())Date and time the record was last updated. 
SalesOrderHeaderSalesOrderIDint identity NOT NULLPrimary key. 
SalesOrderHeaderRevisionNumbertinyint NOT NULL = ((0))Incremental number to track changes to the sales order over time. 
SalesOrderHeaderOrderDatedatetime NOT NULL = (getdate())Dates the sales order was created. 
SalesOrderHeaderDueDatedatetime NOT NULLDate the order is due to the customer. 
SalesOrderHeaderShipDatedatetime NULLDate the order was shipped to the customer. 
SalesOrderHeaderStatustinyint NOT NULL = ((1))Order current status. 1 = In process; 2 = Approved; 3 = Backordered; 4 = Rejected; 5 = Shipped; 6 = Cancelled 
SalesOrderHeaderOnlineOrderFlagFlag NOT NULL = ((1))0 = Order placed by sales person. 1 = Order placed online by customer. 
SalesOrderHeaderSalesOrderNumbernvarchar(25) NOT NULLUnique sales order identification number. 
SalesOrderHeaderPurchaseOrderNumberOrderNumber NULLCustomer purchase order number reference.  
SalesOrderHeaderAccountNumberAccountNumber NULLFinancial accounting number reference. 
SalesOrderHeaderCustomerIDint NOT NULLCustomer identification number. Foreign key to Customer.CustomerID. 
SalesOrderHeaderContactIDint NOT NULLCustomer contact identification number. Foreign key to Contact.ContactID. 
SalesOrderHeaderSalesPersonIDint NULLSales person who created the sales order. Foreign key to SalesPerson.SalePersonID. 
SalesOrderHeaderTerritoryIDint NULLTerritory in which the sale was made. Foreign key to SalesTerritory.SalesTerritoryID. 
SalesOrderHeaderBillToAddressIDint NOT NULLCustomer billing address. Foreign key to Address.AddressID. 
SalesOrderHeaderShipToAddressIDint NOT NULLCustomer shipping address. Foreign key to Address.AddressID. 
SalesOrderHeaderShipMethodIDint NOT NULLShipping method. Foreign key to ShipMethod.ShipMethodID. 
SalesOrderHeaderCreditCardIDint NULLCredit card identification number. Foreign key to CreditCard.CreditCardID. 
SalesOrderHeaderCreditCardApprovalCodevarchar(15) NULLApproval code provided by the credit card company. 
SalesOrderHeaderCurrencyRateIDint NULLCurrency exchange rate used. Foreign key to CurrencyRate.CurrencyRateID. 
SalesOrderHeaderSubTotalmoney NOT NULL = ((0.00))Sales subtotal. Computed as SUM(SalesOrderDetail.LineTotal)for the appropriate SalesOrderID. 
SalesOrderHeaderTaxAmtmoney NOT NULL = ((0.00))Tax amount. 
SalesOrderHeaderFreightmoney NOT NULL = ((0.00))Shipping cost. 
SalesOrderHeaderTotalDuemoney NOT NULLTotal due from customer. Computed as Subtotal + TaxAmt + Freight. 
SalesOrderHeaderCommentnvarchar(128) NULLSales representative comments. 
SalesOrderHeaderrowguiduniqueidentifier NOT NULL = (newid())ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. 
SalesOrderHeaderModifiedDatedatetime NOT NULL = (getdate())Date and time the record was last updated. 
SalesOrderHeaderSalesReasonSalesOrderIDint NOT NULLPrimary key. Foreign key to SalesOrderHeader.SalesOrderID. 
SalesOrderHeaderSalesReasonSalesReasonIDint NOT NULLPrimary key. Foreign key to SalesReason.SalesReasonID. 
SalesOrderHeaderSalesReasonModifiedDatedatetime NOT NULL = (getdate())Date and time the record was last updated. 
SalesPersonSalesPersonIDint NOT NULLPrimary key for SalesPerson records. 
SalesPersonTerritoryIDint NULLTerritory currently assigned to. Foreign key to SalesTerritory.SalesTerritoryID. 
SalesPersonSalesQuotamoney NULLProjected yearly sales. 
SalesPersonBonusmoney NOT NULL = ((0.00))Bonus due if quota is met. 
SalesPersonCommissionPctsmallmoney NOT NULL = ((0.00))Commision percent received per sale. 
SalesPersonSalesYTDmoney NOT NULL = ((0.00))Sales total year to date. 
SalesPersonSalesLastYearmoney NOT NULL = ((0.00))Sales total of previous year. 
SalesPersonrowguiduniqueidentifier NOT NULL = (newid())ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. 
SalesPersonModifiedDatedatetime NOT NULL = (getdate())Date and time the record was last updated. 
SalesPersonQuotaHistorySalesPersonIDint NOT NULLSales person identification number. Foreign key to SalesPerson.SalesPersonID. 
SalesPersonQuotaHistoryQuotaDatedatetime NOT NULLSales quota date. 
SalesPersonQuotaHistorySalesQuotamoney NOT NULLSales quota amount. 
SalesPersonQuotaHistoryrowguiduniqueidentifier NOT NULL = (newid())ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. 
SalesPersonQuotaHistoryModifiedDatedatetime NOT NULL = (getdate())Date and time the record was last updated. 
SalesReasonSalesReasonIDint identity NOT NULLPrimary key for SalesReason records. 
SalesReasonNameName NOT NULLSales reason description. 
SalesReasonReasonTypeName NOT NULLCategory the sales reason belongs to. 
SalesReasonModifiedDatedatetime NOT NULL = (getdate())Date and time the record was last updated. 
SalesTaxRateSalesTaxRateIDint identity NOT NULLPrimary key for SalesTaxRate records. 
SalesTaxRateStateProvinceIDint NOT NULLState, province, or country/region the sales tax applies to. 
SalesTaxRateTaxTypetinyint NOT NULL1 = Tax applied to retail transactions, 2 = Tax applied to wholesale transactions, 3 = Tax applied to all sales (retail and wholesale) transactions. 
SalesTaxRateTaxRatesmallmoney NOT NULL = ((0.00))Tax rate amount. 
SalesTaxRateNameName NOT NULLTax rate description. 
SalesTaxRaterowguiduniqueidentifier NOT NULL = (newid())ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. 
SalesTaxRateModifiedDatedatetime NOT NULL = (getdate())Date and time the record was last updated. 
SalesTerritoryTerritoryIDint identity NOT NULLPrimary key for SalesTerritory records. 
SalesTerritoryNameName NOT NULLSales territory description 
SalesTerritoryCountryRegionCodenvarchar(3) NOT NULLISO standard country or region code. Foreign key to CountryRegion.CountryRegionCode.  
SalesTerritoryGroupnvarchar(50) NOT NULLGeographic area to which the sales territory belong. 
SalesTerritorySalesYTDmoney NOT NULL = ((0.00))Sales in the territory year to date. 
SalesTerritorySalesLastYearmoney NOT NULL = ((0.00))Sales in the territory the previous year. 
SalesTerritoryCostYTDmoney NOT NULL = ((0.00))Business costs in the territory year to date. 
SalesTerritoryCostLastYearmoney NOT NULL = ((0.00))Business costs in the territory the previous year. 
SalesTerritoryrowguiduniqueidentifier NOT NULL = (newid())ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. 
SalesTerritoryModifiedDatedatetime NOT NULL = (getdate())Date and time the record was last updated. 
SalesTerritoryHistorySalesPersonIDint NOT NULLPrimary key for SalesTerritoryHistory records. 
SalesTerritoryHistoryTerritoryIDint NOT NULLTerritory identification number. Foreign key to SalesTerritory.SalesTerritoryID. 
SalesTerritoryHistoryStartDatedatetime NOT NULLDate the sales representive started work in the territory. 
SalesTerritoryHistoryEndDatedatetime NULLDate the sales representative left work in the territory. 
SalesTerritoryHistoryrowguiduniqueidentifier NOT NULL = (newid())ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. 
SalesTerritoryHistoryModifiedDatedatetime NOT NULL = (getdate())Date and time the record was last updated. 
ShoppingCartItemShoppingCartItemIDint identity NOT NULLPrimary key for ShoppingCartItem records. 
ShoppingCartItemShoppingCartIDnvarchar(50) NOT NULLShopping cart identification number. 
ShoppingCartItemQuantityint NOT NULL = ((1))Product quantity ordered. 
ShoppingCartItemProductIDint NOT NULLProduct ordered. Foreign key to Product.ProductID. 
ShoppingCartItemDateCreateddatetime NOT NULL = (getdate())Date the time the record was created. 
ShoppingCartItemModifiedDatedatetime NOT NULL = (getdate())Date and time the record was last updated. 
SpecialOfferSpecialOfferIDint identity NOT NULLPrimary key for SpecialOffer records. 
SpecialOfferDescriptionnvarchar(255) NOT NULLDiscount description. 
SpecialOfferDiscountPctsmallmoney NOT NULL = ((0.00))Discount precentage. 
SpecialOfferTypenvarchar(50) NOT NULLDiscount type category. 
SpecialOfferCategorynvarchar(50) NOT NULLGroup the discount applies to such as Reseller or Customer. 
SpecialOfferStartDatedatetime NOT NULLDiscount start date. 
SpecialOfferEndDatedatetime NOT NULLDiscount end date. 
SpecialOfferMinQtyint NOT NULL = ((0))Minimum discount percent allowed. 
SpecialOfferMaxQtyint NULLMaximum discount percent allowed. 
SpecialOfferrowguiduniqueidentifier NOT NULL = (newid())ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. 
SpecialOfferModifiedDatedatetime NOT NULL = (getdate())Date and time the record was last updated. 
SpecialOfferProductSpecialOfferIDint NOT NULLPrimary key for SpecialOfferProduct records. 
SpecialOfferProductProductIDint NOT NULLProduct identification number. Foreign key to Product.ProductID. 
SpecialOfferProductrowguiduniqueidentifier NOT NULL = (newid())ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. 
SpecialOfferProductModifiedDatedatetime NOT NULL = (getdate())Date and time the record was last updated. 
StoreCustomerIDint NOT NULLPrimary key. Foreign key to Customer.CustomerID. 
StoreNameName NOT NULLName of the store. 
StoreSalesPersonIDint NULLID of the sales person assigned to the customer. Foreign key to SalesPerson.SalesPersonID. 
StoreDemographicsxml NULLDemographic informationg about the store such as the number of employees, annual sales and store type. 
Storerowguiduniqueidentifier NOT NULL = (newid())ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. 
StoreModifiedDatedatetime NOT NULL = (getdate())Date and time the record was last updated. 
StoreContactCustomerIDint NOT NULLStore identification number. Foreign key to Customer.CustomerID. 
StoreContactContactIDint NOT NULLContact (store employee) identification number. Foreign key to Contact.ContactID. 
StoreContactContactTypeIDint NOT NULLContact type such as owner or purchasing agent. Foreign key to ContactType.ContactTypeID. 
StoreContactrowguiduniqueidentifier NOT NULL = (newid())ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. 
StoreContactModifiedDatedatetime NOT NULL = (getdate())Date and time the record was last updated. 
vEmployeeEmployeeIDint NOT NULL 
vEmployeeTitlenvarchar(8) NULL 
vEmployeeFirstNameName NOT NULL 
vEmployeeMiddleNameName NULL 
vEmployeeLastNameName NOT NULL 
vEmployeeSuffixnvarchar(10) NULL 
vEmployeeJobTitlenvarchar(50) NOT NULL 
vEmployeePhonePhone NULL 
vEmployeeEmailAddressnvarchar(50) NULL 
vEmployeeEmailPromotionint NOT NULL 
vEmployeeAddressLine1nvarchar(60) NOT NULL 
vEmployeeAddressLine2nvarchar(60) NULL 
vEmployeeCitynvarchar(30) NOT NULL 
vEmployeeStateProvinceNameName NOT NULL 
vEmployeePostalCodenvarchar(15) NOT NULL 
vEmployeeCountryRegionNameName NOT NULL 
vEmployeeAdditionalContactInfoxml NULL 
vEmployeeDepartmentEmployeeIDint NOT NULL 
vEmployeeDepartmentTitlenvarchar(8) NULL 
vEmployeeDepartmentFirstNameName NOT NULL 
vEmployeeDepartmentMiddleNameName NULL 
vEmployeeDepartmentLastNameName NOT NULL 
vEmployeeDepartmentSuffixnvarchar(10) NULL 
vEmployeeDepartmentJobTitlenvarchar(50) NOT NULL 
vEmployeeDepartmentDepartmentName NOT NULL 
vEmployeeDepartmentGroupNameName NOT NULL 
vEmployeeDepartmentStartDatedatetime NOT NULL 
vEmployeeDepartmentHistoryEmployeeIDint NOT NULL 
vEmployeeDepartmentHistoryTitlenvarchar(8) NULL 
vEmployeeDepartmentHistoryFirstNameName NOT NULL 
vEmployeeDepartmentHistoryMiddleNameName NULL 
vEmployeeDepartmentHistoryLastNameName NOT NULL 
vEmployeeDepartmentHistorySuffixnvarchar(10) NULL 
vEmployeeDepartmentHistoryShiftName NOT NULL 
vEmployeeDepartmentHistoryDepartmentName NOT NULL 
vEmployeeDepartmentHistoryGroupNameName NOT NULL 
vEmployeeDepartmentHistoryStartDatedatetime NOT NULL 
vEmployeeDepartmentHistoryEndDatedatetime NULL 
vJobCandidateJobCandidateIDint identity NOT NULL 
vJobCandidateEmployeeIDint NULL 
vJobCandidateName.Prefixnvarchar(30) NULL 
vJobCandidateName.Firstnvarchar(30) NULL 
vJobCandidateName.Middlenvarchar(30) NULL 
vJobCandidateName.Lastnvarchar(30) NULL 
vJobCandidateName.Suffixnvarchar(30) NULL 
vJobCandidateSkillsnvarchar(max) NULL 
vJobCandidateAddr.Typenvarchar(30) NULL 
vJobCandidateAddr.Loc.CountryRegionnvarchar(100) NULL 
vJobCandidateAddr.Loc.Statenvarchar(100) NULL 
vJobCandidateAddr.Loc.Citynvarchar(100) NULL 
vJobCandidateAddr.PostalCodenvarchar(20) NULL 
vJobCandidateEMailnvarchar(max) NULL 
vJobCandidateWebSitenvarchar(max) NULL 
vJobCandidateModifiedDatedatetime NOT NULL 
vJobCandidateEducationJobCandidateIDint identity NOT NULL 
vJobCandidateEducationEdu.Levelnvarchar(max) NULL 
vJobCandidateEducationEdu.StartDatedatetime NULL 
vJobCandidateEducationEdu.EndDatedatetime NULL 
vJobCandidateEducationEdu.Degreenvarchar(50) NULL 
vJobCandidateEducationEdu.Majornvarchar(50) NULL 
vJobCandidateEducationEdu.Minornvarchar(50) NULL 
vJobCandidateEducationEdu.GPAnvarchar(5) NULL 
vJobCandidateEducationEdu.GPAScalenvarchar(5) NULL 
vJobCandidateEducationEdu.Schoolnvarchar(100) NULL 
vJobCandidateEducationEdu.Loc.CountryRegionnvarchar(100) NULL 
vJobCandidateEducationEdu.Loc.Statenvarchar(100) NULL 
vJobCandidateEducationEdu.Loc.Citynvarchar(100) NULL 
vJobCandidateEmploymentJobCandidateIDint identity NOT NULL 
vJobCandidateEmploymentEmp.StartDatedatetime NULL 
vJobCandidateEmploymentEmp.EndDatedatetime NULL 
vJobCandidateEmploymentEmp.OrgNamenvarchar(100) NULL 
vJobCandidateEmploymentEmp.JobTitlenvarchar(100) NULL 
vJobCandidateEmploymentEmp.Responsibilitynvarchar(max) NULL 
vJobCandidateEmploymentEmp.FunctionCategorynvarchar(max) NULL 
vJobCandidateEmploymentEmp.IndustryCategorynvarchar(max) NULL 
vJobCandidateEmploymentEmp.Loc.CountryRegionnvarchar(max) NULL 
vJobCandidateEmploymentEmp.Loc.Statenvarchar(max) NULL 
vJobCandidateEmploymentEmp.Loc.Citynvarchar(max) NULL 
vAdditionalContactInfoContactIDint identity NOT NULL 
vAdditionalContactInfoFirstNameName NOT NULL 
vAdditionalContactInfoMiddleNameName NULL 
vAdditionalContactInfoLastNameName NOT NULL 
vAdditionalContactInfoTelephoneNumbernvarchar(50) NULL 
vAdditionalContactInfoTelephoneSpecialInstructionsnvarchar(max) NULL 
vAdditionalContactInfoStreetnvarchar(50) NULL 
vAdditionalContactInfoCitynvarchar(50) NULL 
vAdditionalContactInfoStateProvincenvarchar(50) NULL 
vAdditionalContactInfoPostalCodenvarchar(50) NULL 
vAdditionalContactInfoCountryRegionnvarchar(50) NULL 
vAdditionalContactInfoHomeAddressSpecialInstructionsnvarchar(max) NULL 
vAdditionalContactInfoEMailAddressnvarchar(128) NULL 
vAdditionalContactInfoEMailSpecialInstructionsnvarchar(max) NULL 
vAdditionalContactInfoEMailTelephoneNumbernvarchar(50) NULL 
vAdditionalContactInforowguiduniqueidentifier NOT NULL 
vAdditionalContactInfoModifiedDatedatetime NOT NULL 
vStateProvinceCountryRegionStateProvinceIDint NOT NULL 
vStateProvinceCountryRegionStateProvinceCodenchar(3) NOT NULL 
vStateProvinceCountryRegionIsOnlyStateProvinceFlagFlag NOT NULL 
vStateProvinceCountryRegionStateProvinceNameName NOT NULL 
vStateProvinceCountryRegionTerritoryIDint NOT NULL 
vStateProvinceCountryRegionCountryRegionCodenvarchar(3) NOT NULL 
vStateProvinceCountryRegionCountryRegionNameName NOT NULL 
vProductAndDescriptionProductIDint NOT NULL 
vProductAndDescriptionNameName NOT NULL 
vProductAndDescriptionProductModelName NOT NULL 
vProductAndDescriptionCultureIDnchar(6) NOT NULL 
vProductAndDescriptionDescriptionnvarchar(400) NOT NULL 
vProductModelCatalogDescriptionProductModelIDint identity NOT NULL 
vProductModelCatalogDescriptionNameName NOT NULL 
vProductModelCatalogDescriptionSummarynvarchar(max) NULL 
vProductModelCatalogDescriptionManufacturernvarchar(max) NULL 
vProductModelCatalogDescriptionCopyrightnvarchar(30) NULL 
vProductModelCatalogDescriptionProductURLnvarchar(256) NULL 
vProductModelCatalogDescriptionWarrantyPeriodnvarchar(256) NULL 
vProductModelCatalogDescriptionWarrantyDescriptionnvarchar(256) NULL 
vProductModelCatalogDescriptionNoOfYearsnvarchar(256) NULL 
vProductModelCatalogDescriptionMaintenanceDescriptionnvarchar(256) NULL 
vProductModelCatalogDescriptionWheelnvarchar(256) NULL 
vProductModelCatalogDescriptionSaddlenvarchar(256) NULL 
vProductModelCatalogDescriptionPedalnvarchar(256) NULL 
vProductModelCatalogDescriptionBikeFramenvarchar(max) NULL 
vProductModelCatalogDescriptionCranksetnvarchar(256) NULL 
vProductModelCatalogDescriptionPictureAnglenvarchar(256) NULL 
vProductModelCatalogDescriptionPictureSizenvarchar(256) NULL 
vProductModelCatalogDescriptionProductPhotoIDnvarchar(256) NULL 
vProductModelCatalogDescriptionMaterialnvarchar(256) NULL 
vProductModelCatalogDescriptionColornvarchar(256) NULL 
vProductModelCatalogDescriptionProductLinenvarchar(256) NULL 
vProductModelCatalogDescriptionStylenvarchar(256) NULL 
vProductModelCatalogDescriptionRiderExperiencenvarchar(1024) NULL 
vProductModelCatalogDescriptionrowguiduniqueidentifier NOT NULL 
vProductModelCatalogDescriptionModifiedDatedatetime NOT NULL 
vProductModelInstructionsProductModelIDint identity NOT NULL 
vProductModelInstructionsNameName NOT NULL 
vProductModelInstructionsInstructionsnvarchar(max) NULL 
vProductModelInstructionsLocationIDint NULL 
vProductModelInstructionsSetupHoursdecimal(9,4) NULL 
vProductModelInstructionsMachineHoursdecimal(9,4) NULL 
vProductModelInstructionsLaborHoursdecimal(9,4) NULL 
vProductModelInstructionsLotSizeint NULL 
vProductModelInstructionsStepnvarchar(1024) NULL 
vProductModelInstructionsrowguiduniqueidentifier NOT NULL 
vProductModelInstructionsModifiedDatedatetime NOT NULL 
vVendorVendorIDint NOT NULL 
vVendorNameName NOT NULL 
vVendorContactTypeName NOT NULL 
vVendorTitlenvarchar(8) NULL 
vVendorFirstNameName NOT NULL 
vVendorMiddleNameName NULL 
vVendorLastNameName NOT NULL 
vVendorSuffixnvarchar(10) NULL 
vVendorPhonePhone NULL 
vVendorEmailAddressnvarchar(50) NULL 
vVendorEmailPromotionint NOT NULL 
vVendorAddressLine1nvarchar(60) NOT NULL 
vVendorAddressLine2nvarchar(60) NULL 
vVendorCitynvarchar(30) NOT NULL 
vVendorStateProvinceNameName NOT NULL 
vVendorPostalCodenvarchar(15) NOT NULL 
vVendorCountryRegionNameName NOT NULL 
vIndividualCustomerCustomerIDint NOT NULL 
vIndividualCustomerTitlenvarchar(8) NULL 
vIndividualCustomerFirstNameName NOT NULL 
vIndividualCustomerMiddleNameName NULL 
vIndividualCustomerLastNameName NOT NULL 
vIndividualCustomerSuffixnvarchar(10) NULL 
vIndividualCustomerPhonePhone NULL 
vIndividualCustomerEmailAddressnvarchar(50) NULL 
vIndividualCustomerEmailPromotionint NOT NULL 
vIndividualCustomerAddressTypeName NOT NULL 
vIndividualCustomerAddressLine1nvarchar(60) NOT NULL 
vIndividualCustomerAddressLine2nvarchar(60) NULL 
vIndividualCustomerCitynvarchar(30) NOT NULL 
vIndividualCustomerStateProvinceNameName NOT NULL 
vIndividualCustomerPostalCodenvarchar(15) NOT NULL 
vIndividualCustomerCountryRegionNameName NOT NULL 
vIndividualCustomerDemographicsxml NULL 
vIndividualDemographicsCustomerIDint NOT NULL 
vIndividualDemographicsTotalPurchaseYTDmoney NULL 
vIndividualDemographicsDateFirstPurchasedatetime NULL 
vIndividualDemographicsBirthDatedatetime NULL 
vIndividualDemographicsMaritalStatusnvarchar(1) NULL 
vIndividualDemographicsYearlyIncomenvarchar(30) NULL 
vIndividualDemographicsGendernvarchar(1) NULL 
vIndividualDemographicsTotalChildrenint NULL 
vIndividualDemographicsNumberChildrenAtHomeint NULL 
vIndividualDemographicsEducationnvarchar(30) NULL 
vIndividualDemographicsOccupationnvarchar(30) NULL 
vIndividualDemographicsHomeOwnerFlagbit NULL 
vIndividualDemographicsNumberCarsOwnedint NULL 
vSalesPersonSalesPersonIDint NOT NULL 
vSalesPersonTitlenvarchar(8) NULL 
vSalesPersonFirstNameName NOT NULL 
vSalesPersonMiddleNameName NULL 
vSalesPersonLastNameName NOT NULL 
vSalesPersonSuffixnvarchar(10) NULL 
vSalesPersonJobTitlenvarchar(50) NOT NULL 
vSalesPersonPhonePhone NULL 
vSalesPersonEmailAddressnvarchar(50) NULL 
vSalesPersonEmailPromotionint NOT NULL 
vSalesPersonAddressLine1nvarchar(60) NOT NULL 
vSalesPersonAddressLine2nvarchar(60) NULL 
vSalesPersonCitynvarchar(30) NOT NULL 
vSalesPersonStateProvinceNameName NOT NULL 
vSalesPersonPostalCodenvarchar(15) NOT NULL 
vSalesPersonCountryRegionNameName NOT NULL 
vSalesPersonTerritoryNameName NULL 
vSalesPersonTerritoryGroupnvarchar(50) NULL 
vSalesPersonSalesQuotamoney NULL 
vSalesPersonSalesYTDmoney NOT NULL 
vSalesPersonSalesLastYearmoney NOT NULL 
vSalesPersonSalesByFiscalYearsSalesPersonIDint NULL 
vSalesPersonSalesByFiscalYearsFullNamenvarchar(152) NULL 
vSalesPersonSalesByFiscalYearsTitlenvarchar(50) NOT NULL 
vSalesPersonSalesByFiscalYearsSalesTerritoryName NOT NULL 
vSalesPersonSalesByFiscalYears2002money NULL 
vSalesPersonSalesByFiscalYears2003money NULL 
vSalesPersonSalesByFiscalYears2004money NULL 
vStoreWithDemographicsCustomerIDint NOT NULL 
vStoreWithDemographicsNameName NOT NULL 
vStoreWithDemographicsContactTypeName NOT NULL 
vStoreWithDemographicsTitlenvarchar(8) NULL 
vStoreWithDemographicsFirstNameName NOT NULL 
vStoreWithDemographicsMiddleNameName NULL 
vStoreWithDemographicsLastNameName NOT NULL 
vStoreWithDemographicsSuffixnvarchar(10) NULL 
vStoreWithDemographicsPhonePhone NULL 
vStoreWithDemographicsEmailAddressnvarchar(50) NULL 
vStoreWithDemographicsEmailPromotionint NOT NULL 
vStoreWithDemographicsAddressTypeName NOT NULL 
vStoreWithDemographicsAddressLine1nvarchar(60) NOT NULL 
vStoreWithDemographicsAddressLine2nvarchar(60) NULL 
vStoreWithDemographicsCitynvarchar(30) NOT NULL 
vStoreWithDemographicsStateProvinceNameName NOT NULL 
vStoreWithDemographicsPostalCodenvarchar(15) NOT NULL 
vStoreWithDemographicsCountryRegionNameName NOT NULL 
vStoreWithDemographicsAnnualSalesmoney NULL 
vStoreWithDemographicsAnnualRevenuemoney NULL 
vStoreWithDemographicsBankNamenvarchar(50) NULL 
vStoreWithDemographicsBusinessTypenvarchar(5) NULL 
vStoreWithDemographicsYearOpenedint NULL 
vStoreWithDemographicsSpecialtynvarchar(50) NULL 
vStoreWithDemographicsSquareFeetint NULL 
vStoreWithDemographicsBrandsnvarchar(30) NULL 
vStoreWithDemographicsInternetnvarchar(30) NULL 
vStoreWithDemographicsNumberEmployeesint NULL 

Powered by Yoyodyne © 1971