| AWBuildVersion | SystemInformationID | tinyint identity NOT NULL | Primary key for AWBuildVersion records... O RLY? YA RLY!
|
| AWBuildVersion | Database Version | nvarchar(25) NOT NULL | Version number of the database in 9.yy.mm.dd.00 format.
|
| AWBuildVersion | VersionDate | datetime NOT NULL | Date and time the record was last updated.
|
| AWBuildVersion | ModifiedDate | datetime NOT NULL
= (getdate()) | Date and time the record was last updated.
|
| DatabaseLog | DatabaseLogID | int identity NOT NULL | Primary key for DatabaseLog records.
|
| DatabaseLog | PostTime | datetime NOT NULL | The date and time the DDL change occurred.
|
| DatabaseLog | DatabaseUser | sysname NOT NULL | The user who implemented the DDL change.
|
| DatabaseLog | Event | sysname NOT NULL | The type of DDL statement that was executed.
|
| DatabaseLog | Schema | sysname NULL | The schema to which the changed object belongs.
|
| DatabaseLog | Object | sysname NULL | The object that was changed by the DDL statment.
|
| DatabaseLog | TSQL | nvarchar(max) NOT NULL | The exact Transact-SQL statement that was executed.
|
| DatabaseLog | XmlEvent | xml NOT NULL | The raw XML data generated by database trigger.
|
| ErrorLog | ErrorLogID | int identity NOT NULL | Primary key for ErrorLog records.
|
| ErrorLog | ErrorTime | datetime NOT NULL
= (getdate()) | The date and time at which the error occurred.
|
| ErrorLog | UserName | sysname NOT NULL | The user who executed the batch in which the error occurred.
|
| ErrorLog | ErrorNumber | int NOT NULL | The error number of the error that occurred.
|
| ErrorLog | ErrorSeverity | int NULL | The severity of the error that occurred.
|
| ErrorLog | ErrorState | int NULL | The state number of the error that occurred.
|
| ErrorLog | ErrorProcedure | nvarchar(126) NULL | The name of the stored procedure or trigger where the error occurred.
|
| ErrorLog | ErrorLine | int NULL | The line number at which the error occurred.
|
| ErrorLog | ErrorMessage | nvarchar(4000) NOT NULL | The message text of the error that occurred.
|
| Department | DepartmentID | smallint identity NOT NULL | Primary key for Department records.
|
| Department | Name | Name NOT NULL | Name of the department.
|
| Department | GroupName | Name NOT NULL | Name of the group to which the department belongs.
|
| Department | ModifiedDate | datetime NOT NULL
= (getdate()) | Date and time the record was last updated.
|
| Employee | BusinessEntityID | int NOT NULL | Primary key for Employee records. Foreign key to BusinessEntity.BusinessEntityID.
|
| Employee | NationalIDNumber | nvarchar(15) NOT NULL | Unique national identification number such as a social security number.
|
| Employee | LoginID | nvarchar(256) NOT NULL | Network login.
|
| Employee | OrganizationNode | hierarchyid NULL | Where the employee is located in corporate hierarchy.
|
| Employee | OrganizationLevel | smallint NULL | The depth of the employee in the corporate hierarchy.
|
| Employee | JobTitle | nvarchar(50) NOT NULL | Work title such as Buyer or Sales Representative.
|
| Employee | BirthDate | date NOT NULL | Date of birth.
|
| Employee | MaritalStatus | nchar(1) NOT NULL | M = Married, S = Single
|
| Employee | Gender | nchar(1) NOT NULL | M = Male, F = Female
|
| Employee | HireDate | date NOT NULL | Employee hired on this date.
|
| Employee | SalariedFlag | Flag NOT NULL
= ((1)) | Job classification. 0 = Hourly, not exempt from collective bargaining. 1 = Salaried, exempt from collective bargaining.
|
| Employee | VacationHours | smallint NOT NULL
= ((0)) | Number of available vacation hours.
|
| Employee | SickLeaveHours | smallint NOT NULL
= ((0)) | Number of available sick leave hours.
|
| Employee | CurrentFlag | Flag NOT NULL
= ((1)) | 0 = Inactive, 1 = Active
|
| Employee | rowguid | uniqueidentifier NOT NULL
= (newid()) | ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
|
| Employee | ModifiedDate | datetime NOT NULL
= (getdate()) | Date and time the record was last updated.
|
| EmployeeDepartmentHistory | BusinessEntityID | int NOT NULL | Employee identification number. Foreign key to Employee.BusinessEntityID.
|
| EmployeeDepartmentHistory | DepartmentID | smallint NOT NULL | Department in which the employee worked including currently. Foreign key to Department.DepartmentID.
|
| EmployeeDepartmentHistory | ShiftID | tinyint NOT NULL | Identifies which 8-hour shift the employee works. Foreign key to Shift.Shift.ID.
|
| EmployeeDepartmentHistory | StartDate | date NOT NULL | Date the employee started work in the department.
|
| EmployeeDepartmentHistory | EndDate | date NULL | Date the employee left the department. NULL = Current department.
|
| EmployeeDepartmentHistory | ModifiedDate | datetime NOT NULL
= (getdate()) | Date and time the record was last updated.
|
| EmployeePayHistory | BusinessEntityID | int NOT NULL | Employee identification number. Foreign key to Employee.BusinessEntityID.
|
| EmployeePayHistory | RateChangeDate | datetime NOT NULL | Date the change in pay is effective
|
| EmployeePayHistory | Rate | money NOT NULL | Salary hourly rate.
|
| EmployeePayHistory | PayFrequency | tinyint NOT NULL | 1 = Salary received monthly, 2 = Salary received biweekly
|
| EmployeePayHistory | ModifiedDate | datetime NOT NULL
= (getdate()) | Date and time the record was last updated.
|
| JobCandidate | JobCandidateID | int identity NOT NULL | Primary key for JobCandidate records.
|
| JobCandidate | BusinessEntityID | int NULL | Employee identification number if applicant was hired. Foreign key to Employee.BusinessEntityID.
|
| JobCandidate | Resume | xml NULL | Résumé in XML format.
|
| JobCandidate | ModifiedDate | datetime NOT NULL
= (getdate()) | Date and time the record was last updated.
|
| Shift | ShiftID | tinyint identity NOT NULL | Primary key for Shift records.
|
| Shift | Name | Name NOT NULL | Shift description.
|
| Shift | StartTime | time NOT NULL | Shift start time.
|
| Shift | EndTime | time NOT NULL | Shift end time.
|
| Shift | ModifiedDate | datetime NOT NULL
= (getdate()) | Date and time the record was last updated.
|
| Address | AddressID | int identity NOT NULL | Primary key for Address records.
|
| Address | AddressLine1 | nvarchar(60) NOT NULL | First street address line.
|
| Address | AddressLine2 | nvarchar(60) NULL | Second street address line.
|
| Address | City | nvarchar(30) NOT NULL | Name of the city.
|
| Address | StateProvinceID | int NOT NULL | Unique identification number for the state or province. Foreign key to StateProvince table.
|
| Address | PostalCode | nvarchar(15) NOT NULL | Postal code for the street address.
|
| Address | SpatialLocation | geography NULL | Latitude and longitude of this address.
|
| Address | rowguid | uniqueidentifier NOT NULL
= (newid()) | ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
|
| Address | ModifiedDate | datetime NOT NULL
= (getdate()) | Date and time the record was last updated.
|
| AddressType | AddressTypeID | int identity NOT NULL | Primary key for AddressType records.
|
| AddressType | Name | Name NOT NULL | Address type description. For example, Billing, Home, or Shipping.
|
| AddressType | rowguid | uniqueidentifier NOT NULL
= (newid()) | ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
|
| AddressType | ModifiedDate | datetime NOT NULL
= (getdate()) | Date and time the record was last updated.
|
| BusinessEntity | BusinessEntityID | int identity NOT NULL | Primary key for all customers, vendors, and employees.
|
| BusinessEntity | rowguid | uniqueidentifier NOT NULL
= (newid()) | ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
|
| BusinessEntity | ModifiedDate | datetime NOT NULL
= (getdate()) | Date and time the record was last updated.
|
| BusinessEntityAddress | BusinessEntityID | int NOT NULL | Primary key. Foreign key to BusinessEntity.BusinessEntityID.
|
| BusinessEntityAddress | AddressID | int NOT NULL | Primary key. Foreign key to Address.AddressID.
|
| BusinessEntityAddress | AddressTypeID | int NOT NULL | Primary key. Foreign key to AddressType.AddressTypeID.
|
| BusinessEntityAddress | rowguid | uniqueidentifier NOT NULL
= (newid()) | ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
|
| BusinessEntityAddress | ModifiedDate | datetime NOT NULL
= (getdate()) | Date and time the record was last updated.
|
| BusinessEntityContact | BusinessEntityID | int NOT NULL | Primary key. Foreign key to BusinessEntity.BusinessEntityID.
|
| BusinessEntityContact | PersonID | int NOT NULL | Primary key. Foreign key to Person.BusinessEntityID.
|
| BusinessEntityContact | ContactTypeID | int NOT NULL | Primary key. Foreign key to ContactType.ContactTypeID.
|
| BusinessEntityContact | rowguid | uniqueidentifier NOT NULL
= (newid()) | ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
|
| BusinessEntityContact | ModifiedDate | datetime NOT NULL
= (getdate()) | Date and time the record was last updated.
|
| ContactType | ContactTypeID | int identity NOT NULL | Primary key for ContactType records.
|
| ContactType | Name | Name NOT NULL | Contact type description.
|
| ContactType | ModifiedDate | datetime NOT NULL
= (getdate()) | Date and time the record was last updated.
|
| CountryRegion | CountryRegionCode | nvarchar(3) NOT NULL | ISO standard code for countries and regions.
|
| CountryRegion | Name | Name NOT NULL | Country or region name.
|
| CountryRegion | ModifiedDate | datetime NOT NULL
= (getdate()) | Date and time the record was last updated.
|
| EmailAddress | BusinessEntityID | int NOT NULL | Primary key. Person associated with this email address. Foreign key to Person.BusinessEntityID
|
| EmailAddress | EmailAddressID | int identity NOT NULL | Primary key. ID of this email address.
|
| EmailAddress | EmailAddress | nvarchar(50) NULL | E-mail address for the person.
|
| EmailAddress | rowguid | uniqueidentifier NOT NULL
= (newid()) | ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
|
| EmailAddress | ModifiedDate | datetime NOT NULL
= (getdate()) | Date and time the record was last updated.
|
| Password | BusinessEntityID | int NOT NULL | |
| Password | PasswordHash | varchar(128) NOT NULL | Password for the e-mail account.
|
| Password | PasswordSalt | varchar(10) NOT NULL | Random value concatenated with the password string before the password is hashed.
|
| Password | rowguid | uniqueidentifier NOT NULL
= (newid()) | ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
|
| Password | ModifiedDate | datetime NOT NULL
= (getdate()) | Date and time the record was last updated.
|
| Person | BusinessEntityID | int NOT NULL | Primary key for Person records.
|
| Person | PersonType | nchar(2) NOT NULL | Primary type of person: SC = Store Contact, IN = Individual (retail) customer, SP = Sales person, EM = Employee (non-sales), VC = Vendor contact, GC = General contact
|
| Person | NameStyle | NameStyle 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.
|
| Person | Title | nvarchar(8) NULL | A courtesy title. For example, Mr. or Ms.
|
| Person | FirstName | Name NOT NULL | First name of the person.
|
| Person | MiddleName | Name NULL | Middle name or middle initial of the person.
|
| Person | LastName | Name NOT NULL | Last name of the person.
|
| Person | Suffix | nvarchar(10) NULL | Surname suffix. For example, Sr. or Jr.
|
| Person | EmailPromotion | int 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.
|
| Person | AdditionalContactInfo | xml NULL | Additional contact information about the person stored in xml format.
|
| Person | Demographics | xml NULL | Personal information such as hobbies, and income collected from online shoppers. Used for sales analysis.
|
| Person | rowguid | uniqueidentifier NOT NULL
= (newid()) | ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
|
| Person | ModifiedDate | datetime NOT NULL
= (getdate()) | Date and time the record was last updated.
|
| PersonPhone | BusinessEntityID | int NOT NULL | Business entity identification number. Foreign key to Person.BusinessEntityID.
|
| PersonPhone | PhoneNumber | Phone NOT NULL | Telephone number identification number.
|
| PersonPhone | PhoneNumberTypeID | int NOT NULL | Kind of phone number. Foreign key to PhoneNumberType.PhoneNumberTypeID.
|
| PersonPhone | ModifiedDate | datetime NOT NULL
= (getdate()) | Date and time the record was last updated.
|
| PhoneNumberType | PhoneNumberTypeID | int identity NOT NULL | Primary key for telephone number type records.
|
| PhoneNumberType | Name | Name NOT NULL | Name of the telephone number type
|
| PhoneNumberType | ModifiedDate | datetime NOT NULL
= (getdate()) | Date and time the record was last updated.
|
| StateProvince | StateProvinceID | int identity NOT NULL | Primary key for StateProvince records.
|
| StateProvince | StateProvinceCode | nchar(3) NOT NULL | ISO standard state or province code.
|
| StateProvince | CountryRegionCode | nvarchar(3) NOT NULL | ISO standard country or region code. Foreign key to CountryRegion.CountryRegionCode.
|
| StateProvince | IsOnlyStateProvinceFlag | Flag NOT NULL
= ((1)) | 0 = StateProvinceCode exists. 1 = StateProvinceCode unavailable, using CountryRegionCode.
|
| StateProvince | Name | Name NOT NULL | State or province description.
|
| StateProvince | TerritoryID | int NOT NULL | ID of the territory in which the state or province is located. Foreign key to SalesTerritory.SalesTerritoryID.
|
| StateProvince | rowguid | uniqueidentifier NOT NULL
= (newid()) | ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
|
| StateProvince | ModifiedDate | datetime NOT NULL
= (getdate()) | Date and time the record was last updated.
|
| BillOfMaterials | BillOfMaterialsID | int identity NOT NULL | Primary key for BillOfMaterials records.
|
| BillOfMaterials | ProductAssemblyID | int NULL | Parent product identification number. Foreign key to Product.ProductID.
|
| BillOfMaterials | ComponentID | int NOT NULL | Component identification number. Foreign key to Product.ProductID.
|
| BillOfMaterials | StartDate | datetime NOT NULL
= (getdate()) | Date the component started being used in the assembly item.
|
| BillOfMaterials | EndDate | datetime NULL | Date the component stopped being used in the assembly item.
|
| BillOfMaterials | UnitMeasureCode | nchar(3) NOT NULL | Standard code identifying the unit of measure for the quantity.
|
| BillOfMaterials | BOMLevel | smallint NOT NULL | Indicates the depth the component is from its parent (AssemblyID).
|
| BillOfMaterials | PerAssemblyQty | decimal(8,2) NOT NULL
= ((1.00)) | Quantity of the component needed to create the assembly.
|
| BillOfMaterials | ModifiedDate | datetime NOT NULL
= (getdate()) | Date and time the record was last updated.
|
| Culture | CultureID | nchar(6) NOT NULL | Primary key for Culture records.
|
| Culture | Name | Name NOT NULL | Culture description.
|
| Culture | ModifiedDate | datetime NOT NULL
= (getdate()) | Date and time the record was last updated.
|
| Document | DocumentNode | hierarchyid NOT NULL | Primary key for Document records.
|
| Document | DocumentLevel | smallint NULL | Depth in the document hierarchy.
|
| Document | Title | nvarchar(50) NOT NULL | Title of the document.
|
| Document | Owner | int NOT NULL | Employee who controls the document. Foreign key to Employee.BusinessEntityID
|
| Document | FolderFlag | bit NOT NULL
= ((0)) | 0 = This is a folder, 1 = This is a document.
|
| Document | FileName | nvarchar(400) NOT NULL | File name of the document
|
| Document | FileExtension | nvarchar(8) NOT NULL | File extension indicating the document type. For example, .doc or .txt.
|
| Document | Revision | nchar(5) NOT NULL | Revision number of the document.
|
| Document | ChangeNumber | int NOT NULL
= ((0)) | Engineering change approval number.
|
| Document | Status | tinyint NOT NULL | 1 = Pending approval, 2 = Approved, 3 = Obsolete
|
| Document | DocumentSummary | nvarchar(max) NULL | Document abstract.
|
| Document | Document | varbinary NULL | Complete document.
|
| Document | rowguid | uniqueidentifier NOT NULL
= (newid()) | ROWGUIDCOL number uniquely identifying the record. Required for FileStream.
|
| Document | ModifiedDate | datetime NOT NULL
= (getdate()) | Date and time the record was last updated.
|
| Illustration | IllustrationID | int identity NOT NULL | Primary key for Illustration records.
|
| Illustration | Diagram | xml NULL | Illustrations used in manufacturing instructions. Stored as XML.
|
| Illustration | ModifiedDate | datetime NOT NULL
= (getdate()) | Date and time the record was last updated.
|
| Location | LocationID | smallint identity NOT NULL | Primary key for Location records.
|
| Location | Name | Name NOT NULL | Location description.
|
| Location | CostRate | smallmoney NOT NULL
= ((0.00)) | Standard hourly cost of the manufacturing location.
|
| Location | Availability | decimal(8,2) NOT NULL
= ((0.00)) | Work capacity (in hours) of the manufacturing location.
|
| Location | ModifiedDate | datetime NOT NULL
= (getdate()) | Date and time the record was last updated.
|
| Product | ProductID | int identity NOT NULL | Primary key for Product records.
|
| Product | Name | Name NOT NULL | Name of the product.
|
| Product | ProductNumber | nvarchar(25) NOT NULL | Unique product identification number.
|
| Product | MakeFlag | Flag NOT NULL
= ((1)) | 0 = Product is purchased, 1 = Product is manufactured in-house.
|
| Product | FinishedGoodsFlag | Flag NOT NULL
= ((1)) | 0 = Product is not a salable item. 1 = Product is salable.
|
| Product | Color | nvarchar(15) NULL | Product color.
|
| Product | SafetyStockLevel | smallint NOT NULL | Minimum inventory quantity.
|
| Product | ReorderPoint | smallint NOT NULL | Inventory level that triggers a purchase order or work order.
|
| Product | StandardCost | money NOT NULL | Standard cost of the product.
|
| Product | ListPrice | money NOT NULL | Selling price.
|
| Product | Size | nvarchar(5) NULL | Product size.
|
| Product | SizeUnitMeasureCode | nchar(3) NULL | Unit of measure for Size column.
|
| Product | WeightUnitMeasureCode | nchar(3) NULL | Unit of measure for Weight column.
|
| Product | Weight | decimal(8,2) NULL | Product weight.
|
| Product | DaysToManufacture | int NOT NULL | Number of days required to manufacture the product.
|
| Product | ProductLine | nchar(2) NULL | R = Road, M = Mountain, T = Touring, S = Standard
|
| Product | Class | nchar(2) NULL | H = High, M = Medium, L = Low
|
| Product | Style | nchar(2) NULL | W = Womens, M = Mens, U = Universal
|
| Product | ProductSubcategoryID | int NULL | Product is a member of this product subcategory. Foreign key to ProductSubCategory.ProductSubCategoryID.
|
| Product | ProductModelID | int NULL | Product is a member of this product model. Foreign key to ProductModel.ProductModelID.
|
| Product | SellStartDate | datetime NOT NULL | Date the product was available for sale.
|
| Product | SellEndDate | datetime NULL | Date the product was no longer available for sale.
|
| Product | DiscontinuedDate | datetime NULL | Date the product was discontinued.
|
| Product | rowguid | uniqueidentifier NOT NULL
= (newid()) | ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
|
| Product | ModifiedDate | datetime NOT NULL
= (getdate()) | Date and time the record was last updated.
|
| ProductCategory | ProductCategoryID | int identity NOT NULL | Primary key for ProductCategory records.
|
| ProductCategory | Name | Name NOT NULL | Category description.
|
| ProductCategory | rowguid | uniqueidentifier NOT NULL
= (newid()) | ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
|
| ProductCategory | ModifiedDate | datetime NOT NULL
= (getdate()) | Date and time the record was last updated.
|
| ProductCostHistory | ProductID | int NOT NULL | Product identification number. Foreign key to Product.ProductID
|
| ProductCostHistory | StartDate | datetime NOT NULL | Product cost start date.
|
| ProductCostHistory | EndDate | datetime NULL | Product cost end date.
|
| ProductCostHistory | StandardCost | money NOT NULL | Standard cost of the product.
|
| ProductCostHistory | ModifiedDate | datetime NOT NULL
= (getdate()) | Date and time the record was last updated.
|
| ProductDescription | ProductDescriptionID | int identity NOT NULL | Primary key for ProductDescription records.
|
| ProductDescription | Description | nvarchar(400) NOT NULL | Description of the product.
|
| ProductDescription | rowguid | uniqueidentifier NOT NULL
= (newid()) | ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
|
| ProductDescription | ModifiedDate | datetime NOT NULL
= (getdate()) | Date and time the record was last updated.
|
| ProductDocument | ProductID | int NOT NULL | Product identification number. Foreign key to Product.ProductID.
|
| ProductDocument | DocumentNode | hierarchyid NOT NULL | Document identification number. Foreign key to Document.DocumentNode.
|
| ProductDocument | ModifiedDate | datetime NOT NULL
= (getdate()) | Date and time the record was last updated.
|
| ProductInventory | ProductID | int NOT NULL | Product identification number. Foreign key to Product.ProductID.
|
| ProductInventory | LocationID | smallint NOT NULL | Inventory location identification number. Foreign key to Location.LocationID.
|
| ProductInventory | Shelf | nvarchar(10) NOT NULL | Storage compartment within an inventory location.
|
| ProductInventory | Bin | tinyint NOT NULL | Storage container on a shelf in an inventory location.
|
| ProductInventory | Quantity | smallint NOT NULL
= ((0)) | Quantity of products in the inventory location.
|
| ProductInventory | rowguid | uniqueidentifier NOT NULL
= (newid()) | ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
|
| ProductInventory | ModifiedDate | datetime NOT NULL
= (getdate()) | Date and time the record was last updated.
|
| ProductListPriceHistory | ProductID | int NOT NULL | Product identification number. Foreign key to Product.ProductID
|
| ProductListPriceHistory | StartDate | datetime NOT NULL | List price start date.
|
| ProductListPriceHistory | EndDate | datetime NULL | List price end date
|
| ProductListPriceHistory | ListPrice | money NOT NULL | Product list price.
|
| ProductListPriceHistory | ModifiedDate | datetime NOT NULL
= (getdate()) | Date and time the record was last updated.
|
| ProductModel | ProductModelID | int identity NOT NULL | Primary key for ProductModel records.
|
| ProductModel | Name | Name NOT NULL | Product model description.
|
| ProductModel | CatalogDescription | xml NULL | Detailed product catalog information in xml format.
|
| ProductModel | Instructions | xml NULL | Manufacturing instructions in xml format.
|
| ProductModel | rowguid | uniqueidentifier NOT NULL
= (newid()) | ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
|
| ProductModel | ModifiedDate | datetime NOT NULL
= (getdate()) | Date and time the record was last updated.
|
| ProductModelIllustration | ProductModelID | int NOT NULL | Primary key. Foreign key to ProductModel.ProductModelID.
|
| ProductModelIllustration | IllustrationID | int NOT NULL | Primary key. Foreign key to Illustration.IllustrationID.
|
| ProductModelIllustration | ModifiedDate | datetime NOT NULL
= (getdate()) | Date and time the record was last updated.
|
| ProductModelProductDescriptionCulture | ProductModelID | int NOT NULL | Primary key. Foreign key to ProductModel.ProductModelID.
|
| ProductModelProductDescriptionCulture | ProductDescriptionID | int NOT NULL | Primary key. Foreign key to ProductDescription.ProductDescriptionID.
|
| ProductModelProductDescriptionCulture | CultureID | nchar(6) NOT NULL | Culture identification number. Foreign key to Culture.CultureID.
|
| ProductModelProductDescriptionCulture | ModifiedDate | datetime NOT NULL
= (getdate()) | Date and time the record was last updated.
|
| ProductPhoto | ProductPhotoID | int identity NOT NULL | Primary key for ProductPhoto records.
|
| ProductPhoto | ThumbNailPhoto | varbinary NULL | Small image of the product.
|
| ProductPhoto | ThumbnailPhotoFileName | nvarchar(50) NULL | Small image file name.
|
| ProductPhoto | LargePhoto | varbinary NULL | Large image of the product.
|
| ProductPhoto | LargePhotoFileName | nvarchar(50) NULL | Large image file name.
|
| ProductPhoto | ModifiedDate | datetime NOT NULL
= (getdate()) | Date and time the record was last updated.
|
| ProductProductPhoto | ProductID | int NOT NULL | Product identification number. Foreign key to Product.ProductID.
|
| ProductProductPhoto | ProductPhotoID | int NOT NULL | Product photo identification number. Foreign key to ProductPhoto.ProductPhotoID.
|
| ProductProductPhoto | Primary | Flag NOT NULL
= ((0)) | 0 = Photo is not the principal image. 1 = Photo is the principal image.
|
| ProductProductPhoto | ModifiedDate | datetime NOT NULL
= (getdate()) | Date and time the record was last updated.
|
| ProductReview | ProductReviewID | int identity NOT NULL | Primary key for ProductReview records.
|
| ProductReview | ProductID | int NOT NULL | Product identification number. Foreign key to Product.ProductID.
|
| ProductReview | ReviewerName | Name NOT NULL | Name of the reviewer.
|
| ProductReview | ReviewDate | datetime NOT NULL
= (getdate()) | Date review was submitted.
|
| ProductReview | EmailAddress | nvarchar(50) NOT NULL | Reviewer's e-mail address.
|
| ProductReview | Rating | int NOT NULL | Product rating given by the reviewer. Scale is 1 to 5 with 5 as the highest rating.
|
| ProductReview | Comments | nvarchar(3850) NULL | Reviewer's comments
|
| ProductReview | ModifiedDate | datetime NOT NULL
= (getdate()) | Date and time the record was last updated.
|
| ProductSubcategory | ProductSubcategoryID | int identity NOT NULL | Primary key for ProductSubcategory records.
|
| ProductSubcategory | ProductCategoryID | int NOT NULL | Product category identification number. Foreign key to ProductCategory.ProductCategoryID.
|
| ProductSubcategory | Name | Name NOT NULL | Subcategory description.
|
| ProductSubcategory | rowguid | uniqueidentifier NOT NULL
= (newid()) | ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
|
| ProductSubcategory | ModifiedDate | datetime NOT NULL
= (getdate()) | Date and time the record was last updated.
|
| ScrapReason | ScrapReasonID | smallint identity NOT NULL | Primary key for ScrapReason records.
|
| ScrapReason | Name | Name NOT NULL | Failure description.
|
| ScrapReason | ModifiedDate | datetime NOT NULL
= (getdate()) | Date and time the record was last updated.
|
| TransactionHistory | TransactionID | int identity NOT NULL | Primary key for TransactionHistory records.
|
| TransactionHistory | ProductID | int NOT NULL | Product identification number. Foreign key to Product.ProductID.
|
| TransactionHistory | ReferenceOrderID | int NOT NULL | Purchase order, sales order, or work order identification number.
|
| TransactionHistory | ReferenceOrderLineID | int NOT NULL
= ((0)) | Line number associated with the purchase order, sales order, or work order.
|
| TransactionHistory | TransactionDate | datetime NOT NULL
= (getdate()) | Date and time of the transaction.
|
| TransactionHistory | TransactionType | nchar(1) NOT NULL | W = WorkOrder, S = SalesOrder, P = PurchaseOrder
|
| TransactionHistory | Quantity | int NOT NULL | Product quantity.
|
| TransactionHistory | ActualCost | money NOT NULL | Product cost.
|
| TransactionHistory | ModifiedDate | datetime NOT NULL
= (getdate()) | Date and time the record was last updated.
|
| TransactionHistoryArchive | TransactionID | int NOT NULL | Primary key for TransactionHistoryArchive records.
|
| TransactionHistoryArchive | ProductID | int NOT NULL | Product identification number. Foreign key to Product.ProductID.
|
| TransactionHistoryArchive | ReferenceOrderID | int NOT NULL | Purchase order, sales order, or work order identification number.
|
| TransactionHistoryArchive | ReferenceOrderLineID | int NOT NULL
= ((0)) | Line number associated with the purchase order, sales order, or work order.
|
| TransactionHistoryArchive | TransactionDate | datetime NOT NULL
= (getdate()) | Date and time of the transaction.
|
| TransactionHistoryArchive | TransactionType | nchar(1) NOT NULL | W = Work Order, S = Sales Order, P = Purchase Order
|
| TransactionHistoryArchive | Quantity | int NOT NULL | Product quantity.
|
| TransactionHistoryArchive | ActualCost | money NOT NULL | Product cost.
|
| TransactionHistoryArchive | ModifiedDate | datetime NOT NULL
= (getdate()) | Date and time the record was last updated.
|
| UnitMeasure | UnitMeasureCode | nchar(3) NOT NULL | Primary key.
|
| UnitMeasure | Name | Name NOT NULL | Unit of measure description.
|
| UnitMeasure | ModifiedDate | datetime NOT NULL
= (getdate()) | Date and time the record was last updated.
|
| WorkOrder | WorkOrderID | int identity NOT NULL | Primary key for WorkOrder records.
|
| WorkOrder | ProductID | int NOT NULL | Product identification number. Foreign key to Product.ProductID.
|
| WorkOrder | OrderQty | int NOT NULL | Product quantity to build.
|
| WorkOrder | StockedQty | int NOT NULL | Quantity built and put in inventory.
|
| WorkOrder | ScrappedQty | smallint NOT NULL | Quantity that failed inspection.
|
| WorkOrder | StartDate | datetime NOT NULL | Work order start date.
|
| WorkOrder | EndDate | datetime NULL | Work order end date.
|
| WorkOrder | DueDate | datetime NOT NULL | Work order due date.
|
| WorkOrder | ScrapReasonID | smallint NULL | Reason for inspection failure.
|
| WorkOrder | ModifiedDate | datetime NOT NULL
= (getdate()) | Date and time the record was last updated.
|
| WorkOrderRouting | WorkOrderID | int NOT NULL | Primary key. Foreign key to WorkOrder.WorkOrderID.
|
| WorkOrderRouting | ProductID | int NOT NULL | Primary key. Foreign key to Product.ProductID.
|
| WorkOrderRouting | OperationSequence | smallint NOT NULL | Primary key. Indicates the manufacturing process sequence.
|
| WorkOrderRouting | LocationID | smallint NOT NULL | Manufacturing location where the part is processed. Foreign key to Location.LocationID.
|
| WorkOrderRouting | ScheduledStartDate | datetime NOT NULL | Planned manufacturing start date.
|
| WorkOrderRouting | ScheduledEndDate | datetime NOT NULL | Planned manufacturing end date.
|
| WorkOrderRouting | ActualStartDate | datetime NULL | Actual start date.
|
| WorkOrderRouting | ActualEndDate | datetime NULL | Actual end date.
|
| WorkOrderRouting | ActualResourceHrs | decimal(9,4) NULL | Number of manufacturing hours used.
|
| WorkOrderRouting | PlannedCost | money NOT NULL | Estimated manufacturing cost.
|
| WorkOrderRouting | ActualCost | money NULL | Actual manufacturing cost.
|
| WorkOrderRouting | ModifiedDate | datetime NOT NULL
= (getdate()) | Date and time the record was last updated.
|
| ProductVendor | ProductID | int NOT NULL | Primary key. Foreign key to Product.ProductID.
|
| ProductVendor | BusinessEntityID | int NOT NULL | Primary key. Foreign key to Vendor.BusinessEntityID.
|
| ProductVendor | AverageLeadTime | int NOT NULL | The average span of time (in days) between placing an order with the vendor and receiving the purchased product.
|
| ProductVendor | StandardPrice | money NOT NULL | The vendor's usual selling price.
|
| ProductVendor | LastReceiptCost | money NULL | The selling price when last purchased.
|
| ProductVendor | LastReceiptDate | datetime NULL | Date the product was last received by the vendor.
|
| ProductVendor | MinOrderQty | int NOT NULL | The maximum quantity that should be ordered.
|
| ProductVendor | MaxOrderQty | int NOT NULL | The minimum quantity that should be ordered.
|
| ProductVendor | OnOrderQty | int NULL | The quantity currently on order.
|
| ProductVendor | UnitMeasureCode | nchar(3) NOT NULL | The product's unit of measure.
|
| ProductVendor | ModifiedDate | datetime NOT NULL
= (getdate()) | Date and time the record was last updated.
|
| PurchaseOrderDetail | PurchaseOrderID | int NOT NULL | Primary key. Foreign key to PurchaseOrderHeader.PurchaseOrderID.
|
| PurchaseOrderDetail | PurchaseOrderDetailID | int identity NOT NULL | Primary key. One line number per purchased product.
|
| PurchaseOrderDetail | DueDate | datetime NOT NULL | Date the product is expected to be received.
|
| PurchaseOrderDetail | OrderQty | smallint NOT NULL | Quantity ordered.
|
| PurchaseOrderDetail | ProductID | int NOT NULL | Product identification number. Foreign key to Product.ProductID.
|
| PurchaseOrderDetail | UnitPrice | money NOT NULL | Vendor's selling price of a single product.
|
| PurchaseOrderDetail | LineTotal | money NOT NULL | Per product subtotal. Computed as OrderQty * UnitPrice.
|
| PurchaseOrderDetail | ReceivedQty | decimal(8,2) NOT NULL | Quantity actually received from the vendor.
|
| PurchaseOrderDetail | RejectedQty | decimal(8,2) NOT NULL | Quantity rejected during inspection.
|
| PurchaseOrderDetail | StockedQty | decimal(9,2) NOT NULL | Quantity accepted into inventory. Computed as ReceivedQty - RejectedQty.
|
| PurchaseOrderDetail | ModifiedDate | datetime NOT NULL
= (getdate()) | Date and time the record was last updated.
|
| PurchaseOrderHeader | PurchaseOrderID | int identity NOT NULL | Primary key.
|
| PurchaseOrderHeader | RevisionNumber | tinyint NOT NULL
= ((0)) | Incremental number to track changes to the purchase order over time.
|
| PurchaseOrderHeader | Status | tinyint NOT NULL
= ((1)) | Order current status. 1 = Pending; 2 = Approved; 3 = Rejected; 4 = Complete
|
| PurchaseOrderHeader | EmployeeID | int NOT NULL | Employee who created the purchase order. Foreign key to Employee.BusinessEntityID.
|
| PurchaseOrderHeader | VendorID | int NOT NULL | Vendor with whom the purchase order is placed. Foreign key to Vendor.BusinessEntityID.
|
| PurchaseOrderHeader | ShipMethodID | int NOT NULL | Shipping method. Foreign key to ShipMethod.ShipMethodID.
|
| PurchaseOrderHeader | OrderDate | datetime NOT NULL
= (getdate()) | Purchase order creation date.
|
| PurchaseOrderHeader | ShipDate | datetime NULL | Estimated shipment date from the vendor.
|
| PurchaseOrderHeader | SubTotal | money NOT NULL
= ((0.00)) | Purchase order subtotal. Computed as SUM(PurchaseOrderDetail.LineTotal)for the appropriate PurchaseOrderID.
|
| PurchaseOrderHeader | TaxAmt | money NOT NULL
= ((0.00)) | Tax amount.
|
| PurchaseOrderHeader | Freight | money NOT NULL
= ((0.00)) | Shipping cost.
|
| PurchaseOrderHeader | TotalDue | money NOT NULL | Total due to vendor. Computed as Subtotal + TaxAmt + Freight.
|
| PurchaseOrderHeader | ModifiedDate | datetime NOT NULL
= (getdate()) | Date and time the record was last updated.
|
| ShipMethod | ShipMethodID | int identity NOT NULL | Primary key for ShipMethod records.
|
| ShipMethod | Name | Name NOT NULL | Shipping company name.
|
| ShipMethod | ShipBase | money NOT NULL
= ((0.00)) | Minimum shipping charge.
|
| ShipMethod | ShipRate | money NOT NULL
= ((0.00)) | Shipping charge per pound.
|
| ShipMethod | rowguid | uniqueidentifier NOT NULL
= (newid()) | ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
|
| ShipMethod | ModifiedDate | datetime NOT NULL
= (getdate()) | Date and time the record was last updated.
|
| Vendor | BusinessEntityID | int NOT NULL | Primary key for Vendor records. Foreign key to BusinessEntity.BusinessEntityID
|
| Vendor | AccountNumber | AccountNumber NOT NULL | Vendor account (identification) number.
|
| Vendor | Name | Name NOT NULL | Company name.
|
| Vendor | CreditRating | tinyint NOT NULL | 1 = Superior, 2 = Excellent, 3 = Above average, 4 = Average, 5 = Below average
|
| Vendor | PreferredVendorStatus | Flag NOT NULL
= ((1)) | 0 = Do not use if another vendor is available. 1 = Preferred over other vendors supplying the same product.
|
| Vendor | ActiveFlag | Flag NOT NULL
= ((1)) | 0 = Vendor no longer used. 1 = Vendor is actively used.
|
| Vendor | PurchasingWebServiceURL | nvarchar(1024) NULL | Vendor URL.
|
| Vendor | ModifiedDate | datetime NOT NULL
= (getdate()) | Date and time the record was last updated.
|
| CountryRegionCurrency | CountryRegionCode | nvarchar(3) NOT NULL | ISO code for countries and regions. Foreign key to CountryRegion.CountryRegionCode.
|
| CountryRegionCurrency | CurrencyCode | nchar(3) NOT NULL | ISO standard currency code. Foreign key to Currency.CurrencyCode.
|
| CountryRegionCurrency | ModifiedDate | datetime NOT NULL
= (getdate()) | Date and time the record was last updated.
|
| CreditCard | CreditCardID | int identity NOT NULL | Primary key for CreditCard records.
|
| CreditCard | CardType | nvarchar(50) NOT NULL | Credit card name.
|
| CreditCard | CardNumber | nvarchar(25) NOT NULL | Credit card number.
|
| CreditCard | ExpMonth | tinyint NOT NULL | Credit card expiration month.
|
| CreditCard | ExpYear | smallint NOT NULL | Credit card expiration year.
|
| CreditCard | ModifiedDate | datetime NOT NULL
= (getdate()) | Date and time the record was last updated.
|
| Currency | CurrencyCode | nchar(3) NOT NULL | The ISO code for the Currency.
|
| Currency | Name | Name NOT NULL | Currency name.
|
| Currency | ModifiedDate | datetime NOT NULL
= (getdate()) | Date and time the record was last updated.
|
| CurrencyRate | CurrencyRateID | int identity NOT NULL | Primary key for CurrencyRate records.
|
| CurrencyRate | CurrencyRateDate | datetime NOT NULL | Date and time the exchange rate was obtained.
|
| CurrencyRate | FromCurrencyCode | nchar(3) NOT NULL | Exchange rate was converted from this currency code.
|
| CurrencyRate | ToCurrencyCode | nchar(3) NOT NULL | Exchange rate was converted to this currency code.
|
| CurrencyRate | AverageRate | money NOT NULL | Average exchange rate for the day.
|
| CurrencyRate | EndOfDayRate | money NOT NULL | Final exchange rate for the day.
|
| CurrencyRate | ModifiedDate | datetime NOT NULL
= (getdate()) | Date and time the record was last updated.
|
| Customer | CustomerID | int identity NOT NULL | Primary key.
|
| Customer | PersonID | int NULL | Foreign key to Person.BusinessEntityID
|
| Customer | StoreID | int NULL | Foreign key to Store.BusinessEntityID
|
| Customer | TerritoryID | int NULL | ID of the territory in which the customer is located. Foreign key to SalesTerritory.SalesTerritoryID.
|
| Customer | AccountNumber | varchar(10) NOT NULL | Unique number identifying the customer assigned by the accounting system.
|
| Customer | rowguid | uniqueidentifier NOT NULL
= (newid()) | ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
|
| Customer | ModifiedDate | datetime NOT NULL
= (getdate()) | Date and time the record was last updated.
|
| PersonCreditCard | BusinessEntityID | int NOT NULL | Business entity identification number. Foreign key to Person.BusinessEntityID.
|
| PersonCreditCard | CreditCardID | int NOT NULL | Credit card identification number. Foreign key to CreditCard.CreditCardID.
|
| PersonCreditCard | ModifiedDate | datetime NOT NULL
= (getdate()) | Date and time the record was last updated.
|
| SalesOrderDetail | SalesOrderID | int NOT NULL | Primary key. Foreign key to SalesOrderHeader.SalesOrderID.
|
| SalesOrderDetail | SalesOrderDetailID | int identity NOT NULL | Primary key. One incremental unique number per product sold.
|
| SalesOrderDetail | CarrierTrackingNumber | nvarchar(25) NULL | Shipment tracking number supplied by the shipper.
|
| SalesOrderDetail | OrderQty | smallint NOT NULL | Quantity ordered per product.
|
| SalesOrderDetail | ProductID | int NOT NULL | Product sold to customer. Foreign key to Product.ProductID.
|
| SalesOrderDetail | SpecialOfferID | int NOT NULL | Promotional code. Foreign key to SpecialOffer.SpecialOfferID.
|
| SalesOrderDetail | UnitPrice | money NOT NULL | Selling price of a single product.
|
| SalesOrderDetail | UnitPriceDiscount | money NOT NULL
= ((0.0)) | Discount amount.
|
| SalesOrderDetail | LineTotal | numeric(38,6) NOT NULL | Per product subtotal. Computed as UnitPrice * (1 - UnitPriceDiscount) * OrderQty.
|
| SalesOrderDetail | rowguid | uniqueidentifier NOT NULL
= (newid()) | ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
|
| SalesOrderDetail | ModifiedDate | datetime NOT NULL
= (getdate()) | Date and time the record was last updated.
|
| SalesOrderHeader | SalesOrderID | int identity NOT NULL | Primary key.
|
| SalesOrderHeader | RevisionNumber | tinyint NOT NULL
= ((0)) | Incremental number to track changes to the sales order over time.
|
| SalesOrderHeader | OrderDate | datetime NOT NULL
= (getdate()) | Dates the sales order was created.
|
| SalesOrderHeader | DueDate | datetime NOT NULL | Date the order is due to the customer.
|
| SalesOrderHeader | ShipDate | datetime NULL | Date the order was shipped to the customer.
|
| SalesOrderHeader | Status | tinyint NOT NULL
= ((1)) | Order current status. 1 = In process; 2 = Approved; 3 = Backordered; 4 = Rejected; 5 = Shipped; 6 = Cancelled
|
| SalesOrderHeader | OnlineOrderFlag | Flag NOT NULL
= ((1)) | 0 = Order placed by sales person. 1 = Order placed online by customer.
|
| SalesOrderHeader | SalesOrderNumber | nvarchar(25) NOT NULL | Unique sales order identification number.
|
| SalesOrderHeader | PurchaseOrderNumber | OrderNumber NULL | Customer purchase order number reference.
|
| SalesOrderHeader | AccountNumber | AccountNumber NULL | Financial accounting number reference.
|
| SalesOrderHeader | CustomerID | int NOT NULL | Customer identification number. Foreign key to Customer.BusinessEntityID.
|
| SalesOrderHeader | SalesPersonID | int NULL | Sales person who created the sales order. Foreign key to SalesPerson.BusinessEntityID.
|
| SalesOrderHeader | TerritoryID | int NULL | Territory in which the sale was made. Foreign key to SalesTerritory.SalesTerritoryID.
|
| SalesOrderHeader | BillToAddressID | int NOT NULL | Customer billing address. Foreign key to Address.AddressID.
|
| SalesOrderHeader | ShipToAddressID | int NOT NULL | Customer shipping address. Foreign key to Address.AddressID.
|
| SalesOrderHeader | ShipMethodID | int NOT NULL | Shipping method. Foreign key to ShipMethod.ShipMethodID.
|
| SalesOrderHeader | CreditCardID | int NULL | Credit card identification number. Foreign key to CreditCard.CreditCardID.
|
| SalesOrderHeader | CreditCardApprovalCode | varchar(15) NULL | Approval code provided by the credit card company.
|
| SalesOrderHeader | CurrencyRateID | int NULL | Currency exchange rate used. Foreign key to CurrencyRate.CurrencyRateID.
|
| SalesOrderHeader | SubTotal | money NOT NULL
= ((0.00)) | Sales subtotal. Computed as SUM(SalesOrderDetail.LineTotal)for the appropriate SalesOrderID.
|
| SalesOrderHeader | TaxAmt | money NOT NULL
= ((0.00)) | Tax amount.
|
| SalesOrderHeader | Freight | money NOT NULL
= ((0.00)) | Shipping cost.
|
| SalesOrderHeader | TotalDue | money NOT NULL | Total due from customer. Computed as Subtotal + TaxAmt + Freight.
|
| SalesOrderHeader | Comment | nvarchar(128) NULL | Sales representative comments.
|
| SalesOrderHeader | rowguid | uniqueidentifier NOT NULL
= (newid()) | ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
|
| SalesOrderHeader | ModifiedDate | datetime NOT NULL
= (getdate()) | Date and time the record was last updated.
|
| SalesOrderHeaderSalesReason | SalesOrderID | int NOT NULL | Primary key. Foreign key to SalesOrderHeader.SalesOrderID.
|
| SalesOrderHeaderSalesReason | SalesReasonID | int NOT NULL | Primary key. Foreign key to SalesReason.SalesReasonID.
|
| SalesOrderHeaderSalesReason | ModifiedDate | datetime NOT NULL
= (getdate()) | Date and time the record was last updated.
|
| SalesPerson | BusinessEntityID | int NOT NULL | Primary key for SalesPerson records. Foreign key to Employee.BusinessEntityID
|
| SalesPerson | TerritoryID | int NULL | Territory currently assigned to. Foreign key to SalesTerritory.SalesTerritoryID.
|
| SalesPerson | SalesQuota | money NULL | Projected yearly sales.
|
| SalesPerson | Bonus | money NOT NULL
= ((0.00)) | Bonus due if quota is met.
|
| SalesPerson | CommissionPct | smallmoney NOT NULL
= ((0.00)) | Commision percent received per sale.
|
| SalesPerson | SalesYTD | money NOT NULL
= ((0.00)) | Sales total year to date.
|
| SalesPerson | SalesLastYear | money NOT NULL
= ((0.00)) | Sales total of previous year.
|
| SalesPerson | rowguid | uniqueidentifier NOT NULL
= (newid()) | ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
|
| SalesPerson | ModifiedDate | datetime NOT NULL
= (getdate()) | Date and time the record was last updated.
|
| SalesPersonQuotaHistory | BusinessEntityID | int NOT NULL | Sales person identification number. Foreign key to SalesPerson.BusinessEntityID.
|
| SalesPersonQuotaHistory | QuotaDate | datetime NOT NULL | Sales quota date.
|
| SalesPersonQuotaHistory | SalesQuota | money NOT NULL | Sales quota amount.
|
| SalesPersonQuotaHistory | rowguid | uniqueidentifier NOT NULL
= (newid()) | ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
|
| SalesPersonQuotaHistory | ModifiedDate | datetime NOT NULL
= (getdate()) | Date and time the record was last updated.
|
| SalesReason | SalesReasonID | int identity NOT NULL | Primary key for SalesReason records.
|
| SalesReason | Name | Name NOT NULL | Sales reason description.
|
| SalesReason | ReasonType | Name NOT NULL | Category the sales reason belongs to.
|
| SalesReason | ModifiedDate | datetime NOT NULL
= (getdate()) | Date and time the record was last updated.
|
| SalesTaxRate | SalesTaxRateID | int identity NOT NULL | Primary key for SalesTaxRate records.
|
| SalesTaxRate | StateProvinceID | int NOT NULL | State, province, or country/region the sales tax applies to.
|
| SalesTaxRate | TaxType | tinyint NOT NULL | 1 = Tax applied to retail transactions, 2 = Tax applied to wholesale transactions, 3 = Tax applied to all sales (retail and wholesale) transactions.
|
| SalesTaxRate | TaxRate | smallmoney NOT NULL
= ((0.00)) | Tax rate amount.
|
| SalesTaxRate | Name | Name NOT NULL | Tax rate description.
|
| SalesTaxRate | rowguid | uniqueidentifier NOT NULL
= (newid()) | ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
|
| SalesTaxRate | ModifiedDate | datetime NOT NULL
= (getdate()) | Date and time the record was last updated.
|
| SalesTerritory | TerritoryID | int identity NOT NULL | Primary key for SalesTerritory records.
|
| SalesTerritory | Name | Name NOT NULL | Sales territory description
|
| SalesTerritory | CountryRegionCode | nvarchar(3) NOT NULL | ISO standard country or region code. Foreign key to CountryRegion.CountryRegionCode.
|
| SalesTerritory | Group | nvarchar(50) NOT NULL | Geographic area to which the sales territory belong.
|
| SalesTerritory | SalesYTD | money NOT NULL
= ((0.00)) | Sales in the territory year to date.
|
| SalesTerritory | SalesLastYear | money NOT NULL
= ((0.00)) | Sales in the territory the previous year.
|
| SalesTerritory | CostYTD | money NOT NULL
= ((0.00)) | Business costs in the territory year to date.
|
| SalesTerritory | CostLastYear | money NOT NULL
= ((0.00)) | Business costs in the territory the previous year.
|
| SalesTerritory | rowguid | uniqueidentifier NOT NULL
= (newid()) | ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
|
| SalesTerritory | ModifiedDate | datetime NOT NULL
= (getdate()) | Date and time the record was last updated.
|
| SalesTerritoryHistory | BusinessEntityID | int NOT NULL | Primary key. The sales rep. Foreign key to SalesPerson.BusinessEntityID.
|
| SalesTerritoryHistory | TerritoryID | int NOT NULL | Primary key. Territory identification number. Foreign key to SalesTerritory.SalesTerritoryID.
|
| SalesTerritoryHistory | StartDate | datetime NOT NULL | Primary key. Date the sales representive started work in the territory.
|
| SalesTerritoryHistory | EndDate | datetime NULL | Date the sales representative left work in the territory.
|
| SalesTerritoryHistory | rowguid | uniqueidentifier NOT NULL
= (newid()) | ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
|
| SalesTerritoryHistory | ModifiedDate | datetime NOT NULL
= (getdate()) | Date and time the record was last updated.
|
| ShoppingCartItem | ShoppingCartItemID | int identity NOT NULL | Primary key for ShoppingCartItem records.
|
| ShoppingCartItem | ShoppingCartID | nvarchar(50) NOT NULL | Shopping cart identification number.
|
| ShoppingCartItem | Quantity | int NOT NULL
= ((1)) | Product quantity ordered.
|
| ShoppingCartItem | ProductID | int NOT NULL | Product ordered. Foreign key to Product.ProductID.
|
| ShoppingCartItem | DateCreated | datetime NOT NULL
= (getdate()) | Date the time the record was created.
|
| ShoppingCartItem | ModifiedDate | datetime NOT NULL
= (getdate()) | Date and time the record was last updated.
|
| SpecialOffer | SpecialOfferID | int identity NOT NULL | Primary key for SpecialOffer records.
|
| SpecialOffer | Description | nvarchar(255) NOT NULL | Discount description.
|
| SpecialOffer | DiscountPct | smallmoney NOT NULL
= ((0.00)) | Discount precentage.
|
| SpecialOffer | Type | nvarchar(50) NOT NULL | Discount type category.
|
| SpecialOffer | Category | nvarchar(50) NOT NULL | Group the discount applies to such as Reseller or Customer.
|
| SpecialOffer | StartDate | datetime NOT NULL | Discount start date.
|
| SpecialOffer | EndDate | datetime NOT NULL | Discount end date.
|
| SpecialOffer | MinQty | int NOT NULL
= ((0)) | Minimum discount percent allowed.
|
| SpecialOffer | MaxQty | int NULL | Maximum discount percent allowed.
|
| SpecialOffer | rowguid | uniqueidentifier NOT NULL
= (newid()) | ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
|
| SpecialOffer | ModifiedDate | datetime NOT NULL
= (getdate()) | Date and time the record was last updated.
|
| SpecialOfferProduct | SpecialOfferID | int NOT NULL | Primary key for SpecialOfferProduct records.
|
| SpecialOfferProduct | ProductID | int NOT NULL | Product identification number. Foreign key to Product.ProductID.
|
| SpecialOfferProduct | rowguid | uniqueidentifier NOT NULL
= (newid()) | ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
|
| SpecialOfferProduct | ModifiedDate | datetime NOT NULL
= (getdate()) | Date and time the record was last updated.
|
| Store | BusinessEntityID | int NOT NULL | Primary key. Foreign key to Customer.BusinessEntityID.
|
| Store | Name | Name NOT NULL | Name of the store.
|
| Store | SalesPersonID | int NULL | ID of the sales person assigned to the customer. Foreign key to SalesPerson.BusinessEntityID.
|
| Store | Demographics | xml NULL | Demographic informationg about the store such as the number of employees, annual sales and store type.
|
| Store | rowguid | uniqueidentifier NOT NULL
= (newid()) | ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
|
| Store | ModifiedDate | datetime NOT NULL
= (getdate()) | Date and time the record was last updated.
|
| vEmployee | BusinessEntityID | int NOT NULL | |
| vEmployee | Title | nvarchar(8) NULL | |
| vEmployee | FirstName | Name NOT NULL | |
| vEmployee | MiddleName | Name NULL | |
| vEmployee | LastName | Name NOT NULL | |
| vEmployee | Suffix | nvarchar(10) NULL | |
| vEmployee | JobTitle | nvarchar(50) NOT NULL | |
| vEmployee | PhoneNumber | Phone NULL | |
| vEmployee | PhoneNumberType | Name NULL | |
| vEmployee | EmailAddress | nvarchar(50) NULL | |
| vEmployee | EmailPromotion | int NOT NULL | |
| vEmployee | AddressLine1 | nvarchar(60) NOT NULL | |
| vEmployee | AddressLine2 | nvarchar(60) NULL | |
| vEmployee | City | nvarchar(30) NOT NULL | |
| vEmployee | StateProvinceName | Name NOT NULL | |
| vEmployee | PostalCode | nvarchar(15) NOT NULL | |
| vEmployee | CountryRegionName | Name NOT NULL | |
| vEmployee | AdditionalContactInfo | xml NULL | |
| vEmployeeDepartment | BusinessEntityID | int NOT NULL | |
| vEmployeeDepartment | Title | nvarchar(8) NULL | |
| vEmployeeDepartment | FirstName | Name NOT NULL | |
| vEmployeeDepartment | MiddleName | Name NULL | |
| vEmployeeDepartment | LastName | Name NOT NULL | |
| vEmployeeDepartment | Suffix | nvarchar(10) NULL | |
| vEmployeeDepartment | JobTitle | nvarchar(50) NOT NULL | |
| vEmployeeDepartment | Department | Name NOT NULL | |
| vEmployeeDepartment | GroupName | Name NOT NULL | |
| vEmployeeDepartment | StartDate | date NOT NULL | |
| vEmployeeDepartmentHistory | BusinessEntityID | int NOT NULL | |
| vEmployeeDepartmentHistory | Title | nvarchar(8) NULL | |
| vEmployeeDepartmentHistory | FirstName | Name NOT NULL | |
| vEmployeeDepartmentHistory | MiddleName | Name NULL | |
| vEmployeeDepartmentHistory | LastName | Name NOT NULL | |
| vEmployeeDepartmentHistory | Suffix | nvarchar(10) NULL | |
| vEmployeeDepartmentHistory | Shift | Name NOT NULL | |
| vEmployeeDepartmentHistory | Department | Name NOT NULL | |
| vEmployeeDepartmentHistory | GroupName | Name NOT NULL | |
| vEmployeeDepartmentHistory | StartDate | date NOT NULL | |
| vEmployeeDepartmentHistory | EndDate | date NULL | |
| vJobCandidate | JobCandidateID | int identity NOT NULL | |
| vJobCandidate | BusinessEntityID | int NULL | |
| vJobCandidate | Name.Prefix | nvarchar(30) NULL | |
| vJobCandidate | Name.First | nvarchar(30) NULL | |
| vJobCandidate | Name.Middle | nvarchar(30) NULL | |
| vJobCandidate | Name.Last | nvarchar(30) NULL | |
| vJobCandidate | Name.Suffix | nvarchar(30) NULL | |
| vJobCandidate | Skills | nvarchar(max) NULL | |
| vJobCandidate | Addr.Type | nvarchar(30) NULL | |
| vJobCandidate | Addr.Loc.CountryRegion | nvarchar(100) NULL | |
| vJobCandidate | Addr.Loc.State | nvarchar(100) NULL | |
| vJobCandidate | Addr.Loc.City | nvarchar(100) NULL | |
| vJobCandidate | Addr.PostalCode | nvarchar(20) NULL | |
| vJobCandidate | EMail | nvarchar(max) NULL | |
| vJobCandidate | WebSite | nvarchar(max) NULL | |
| vJobCandidate | ModifiedDate | datetime NOT NULL | |
| vJobCandidateEducation | JobCandidateID | int identity NOT NULL | |
| vJobCandidateEducation | Edu.Level | nvarchar(max) NULL | |
| vJobCandidateEducation | Edu.StartDate | datetime NULL | |
| vJobCandidateEducation | Edu.EndDate | datetime NULL | |
| vJobCandidateEducation | Edu.Degree | nvarchar(50) NULL | |
| vJobCandidateEducation | Edu.Major | nvarchar(50) NULL | |
| vJobCandidateEducation | Edu.Minor | nvarchar(50) NULL | |
| vJobCandidateEducation | Edu.GPA | nvarchar(5) NULL | the student's GPA
|
| vJobCandidateEducation | Edu.GPAScale | nvarchar(5) NULL | |
| vJobCandidateEducation | Edu.School | nvarchar(100) NULL | |
| vJobCandidateEducation | Edu.Loc.CountryRegion | nvarchar(100) NULL | |
| vJobCandidateEducation | Edu.Loc.State | nvarchar(100) NULL | |
| vJobCandidateEducation | Edu.Loc.City | nvarchar(100) NULL | |
| vJobCandidateEmployment | JobCandidateID | int identity NOT NULL | |
| vJobCandidateEmployment | Emp.StartDate | datetime NULL | |
| vJobCandidateEmployment | Emp.EndDate | datetime NULL | |
| vJobCandidateEmployment | Emp.OrgName | nvarchar(100) NULL | |
| vJobCandidateEmployment | Emp.JobTitle | nvarchar(100) NULL | |
| vJobCandidateEmployment | Emp.Responsibility | nvarchar(max) NULL | |
| vJobCandidateEmployment | Emp.FunctionCategory | nvarchar(max) NULL | |
| vJobCandidateEmployment | Emp.IndustryCategory | nvarchar(max) NULL | |
| vJobCandidateEmployment | Emp.Loc.CountryRegion | nvarchar(max) NULL | |
| vJobCandidateEmployment | Emp.Loc.State | nvarchar(max) NULL | |
| vJobCandidateEmployment | Emp.Loc.City | nvarchar(max) NULL | |
| vAdditionalContactInfo | BusinessEntityID | int NOT NULL | |
| vAdditionalContactInfo | FirstName | Name NOT NULL | |
| vAdditionalContactInfo | MiddleName | Name NULL | |
| vAdditionalContactInfo | LastName | Name NOT NULL | |
| vAdditionalContactInfo | TelephoneNumber | nvarchar(50) NULL | |
| vAdditionalContactInfo | TelephoneSpecialInstructions | nvarchar(max) NULL | |
| vAdditionalContactInfo | Street | nvarchar(50) NULL | |
| vAdditionalContactInfo | City | nvarchar(50) NULL | |
| vAdditionalContactInfo | StateProvince | nvarchar(50) NULL | |
| vAdditionalContactInfo | PostalCode | nvarchar(50) NULL | |
| vAdditionalContactInfo | CountryRegion | nvarchar(50) NULL | |
| vAdditionalContactInfo | HomeAddressSpecialInstructions | nvarchar(max) NULL | |
| vAdditionalContactInfo | EMailAddress | nvarchar(128) NULL | |
| vAdditionalContactInfo | EMailSpecialInstructions | nvarchar(max) NULL | |
| vAdditionalContactInfo | EMailTelephoneNumber | nvarchar(50) NULL | |
| vAdditionalContactInfo | rowguid | uniqueidentifier NOT NULL | |
| vAdditionalContactInfo | ModifiedDate | datetime NOT NULL | |
| vStateProvinceCountryRegion | StateProvinceID | int NOT NULL | |
| vStateProvinceCountryRegion | StateProvinceCode | nchar(3) NOT NULL | |
| vStateProvinceCountryRegion | IsOnlyStateProvinceFlag | Flag NOT NULL | |
| vStateProvinceCountryRegion | StateProvinceName | Name NOT NULL | |
| vStateProvinceCountryRegion | TerritoryID | int NOT NULL | |
| vStateProvinceCountryRegion | CountryRegionCode | nvarchar(3) NOT NULL | |
| vStateProvinceCountryRegion | CountryRegionName | Name NOT NULL | |
| vProductAndDescription | ProductID | int NOT NULL | |
| vProductAndDescription | Name | Name NOT NULL | |
| vProductAndDescription | ProductModel | Name NOT NULL | |
| vProductAndDescription | CultureID | nchar(6) NOT NULL | |
| vProductAndDescription | Description | nvarchar(400) NOT NULL | |
| vProductModelCatalogDescription | ProductModelID | int identity NOT NULL | |
| vProductModelCatalogDescription | Name | Name NOT NULL | |
| vProductModelCatalogDescription | Summary | nvarchar(max) NULL | |
| vProductModelCatalogDescription | Manufacturer | nvarchar(max) NULL | |
| vProductModelCatalogDescription | Copyright | nvarchar(30) NULL | |
| vProductModelCatalogDescription | ProductURL | nvarchar(256) NULL | |
| vProductModelCatalogDescription | WarrantyPeriod | nvarchar(256) NULL | |
| vProductModelCatalogDescription | WarrantyDescription | nvarchar(256) NULL | |
| vProductModelCatalogDescription | NoOfYears | nvarchar(256) NULL | |
| vProductModelCatalogDescription | MaintenanceDescription | nvarchar(256) NULL | |
| vProductModelCatalogDescription | Wheel | nvarchar(256) NULL | |
| vProductModelCatalogDescription | Saddle | nvarchar(256) NULL | |
| vProductModelCatalogDescription | Pedal | nvarchar(256) NULL | |
| vProductModelCatalogDescription | BikeFrame | nvarchar(max) NULL | |
| vProductModelCatalogDescription | Crankset | nvarchar(256) NULL | |
| vProductModelCatalogDescription | PictureAngle | nvarchar(256) NULL | |
| vProductModelCatalogDescription | PictureSize | nvarchar(256) NULL | |
| vProductModelCatalogDescription | ProductPhotoID | nvarchar(256) NULL | |
| vProductModelCatalogDescription | Material | nvarchar(256) NULL | |
| vProductModelCatalogDescription | Color | nvarchar(256) NULL | |
| vProductModelCatalogDescription | ProductLine | nvarchar(256) NULL | |
| vProductModelCatalogDescription | Style | nvarchar(256) NULL | |
| vProductModelCatalogDescription | RiderExperience | nvarchar(1024) NULL | |
| vProductModelCatalogDescription | rowguid | uniqueidentifier NOT NULL | |
| vProductModelCatalogDescription | ModifiedDate | datetime NOT NULL | |
| vProductModelInstructions | ProductModelID | int identity NOT NULL | |
| vProductModelInstructions | Name | Name NOT NULL | |
| vProductModelInstructions | Instructions | nvarchar(max) NULL | |
| vProductModelInstructions | LocationID | int NULL | |
| vProductModelInstructions | SetupHours | decimal(9,4) NULL | |
| vProductModelInstructions | MachineHours | decimal(9,4) NULL | |
| vProductModelInstructions | LaborHours | decimal(9,4) NULL | |
| vProductModelInstructions | LotSize | int NULL | |
| vProductModelInstructions | Step | nvarchar(1024) NULL | |
| vProductModelInstructions | rowguid | uniqueidentifier NOT NULL | |
| vProductModelInstructions | ModifiedDate | datetime NOT NULL | |
| vVendorWithAddresses | BusinessEntityID | int NOT NULL | |
| vVendorWithAddresses | Name | Name NOT NULL | |
| vVendorWithAddresses | AddressType | Name NOT NULL | |
| vVendorWithAddresses | AddressLine1 | nvarchar(60) NOT NULL | |
| vVendorWithAddresses | AddressLine2 | nvarchar(60) NULL | |
| vVendorWithAddresses | City | nvarchar(30) NOT NULL | |
| vVendorWithAddresses | StateProvinceName | Name NOT NULL | |
| vVendorWithAddresses | PostalCode | nvarchar(15) NOT NULL | |
| vVendorWithAddresses | CountryRegionName | Name NOT NULL | |
| vVendorWithContacts | BusinessEntityID | int NOT NULL | |
| vVendorWithContacts | Name | Name NOT NULL | |
| vVendorWithContacts | ContactType | Name NOT NULL | |
| vVendorWithContacts | Title | nvarchar(8) NULL | |
| vVendorWithContacts | FirstName | Name NOT NULL | |
| vVendorWithContacts | MiddleName | Name NULL | |
| vVendorWithContacts | LastName | Name NOT NULL | |
| vVendorWithContacts | Suffix | nvarchar(10) NULL | |
| vVendorWithContacts | PhoneNumber | Phone NULL | |
| vVendorWithContacts | PhoneNumberType | Name NULL | |
| vVendorWithContacts | EmailAddress | nvarchar(50) NULL | |
| vVendorWithContacts | EmailPromotion | int NOT NULL | |
| vIndividualCustomer | BusinessEntityID | int NOT NULL | |
| vIndividualCustomer | Title | nvarchar(8) NULL | |
| vIndividualCustomer | FirstName | Name NOT NULL | |
| vIndividualCustomer | MiddleName | Name NULL | |
| vIndividualCustomer | LastName | Name NOT NULL | |
| vIndividualCustomer | Suffix | nvarchar(10) NULL | |
| vIndividualCustomer | PhoneNumber | Phone NULL | |
| vIndividualCustomer | PhoneNumberType | Name NULL | |
| vIndividualCustomer | EmailAddress | nvarchar(50) NULL | |
| vIndividualCustomer | EmailPromotion | int NOT NULL | |
| vIndividualCustomer | AddressType | Name NOT NULL | |
| vIndividualCustomer | AddressLine1 | nvarchar(60) NOT NULL | |
| vIndividualCustomer | AddressLine2 | nvarchar(60) NULL | |
| vIndividualCustomer | City | nvarchar(30) NOT NULL | |
| vIndividualCustomer | StateProvinceName | Name NOT NULL | |
| vIndividualCustomer | PostalCode | nvarchar(15) NOT NULL | must be a zip code?
|
| vIndividualCustomer | CountryRegionName | Name NOT NULL | |
| vIndividualCustomer | Demographics | xml NULL | |
| vPersonDemographics | BusinessEntityID | int NOT NULL | |
| vPersonDemographics | TotalPurchaseYTD | money NULL | |
| vPersonDemographics | DateFirstPurchase | datetime NULL | |
| vPersonDemographics | BirthDate | datetime NULL | |
| vPersonDemographics | MaritalStatus | nvarchar(1) NULL | |
| vPersonDemographics | YearlyIncome | nvarchar(30) NULL | |
| vPersonDemographics | Gender | nvarchar(1) NULL | |
| vPersonDemographics | TotalChildren | int NULL | |
| vPersonDemographics | NumberChildrenAtHome | int NULL | |
| vPersonDemographics | Education | nvarchar(30) NULL | |
| vPersonDemographics | Occupation | nvarchar(30) NULL | |
| vPersonDemographics | HomeOwnerFlag | bit NULL | |
| vPersonDemographics | NumberCarsOwned | int NULL | |
| vSalesPerson | BusinessEntityID | int NOT NULL | |
| vSalesPerson | Title | nvarchar(8) NULL | |
| vSalesPerson | FirstName | Name NOT NULL | |
| vSalesPerson | MiddleName | Name NULL | |
| vSalesPerson | LastName | Name NOT NULL | |
| vSalesPerson | Suffix | nvarchar(10) NULL | |
| vSalesPerson | JobTitle | nvarchar(50) NOT NULL | |
| vSalesPerson | PhoneNumber | Phone NULL | |
| vSalesPerson | PhoneNumberType | Name NULL | |
| vSalesPerson | EmailAddress | nvarchar(50) NULL | |
| vSalesPerson | EmailPromotion | int NOT NULL | |
| vSalesPerson | AddressLine1 | nvarchar(60) NOT NULL | |
| vSalesPerson | AddressLine2 | nvarchar(60) NULL | |
| vSalesPerson | City | nvarchar(30) NOT NULL | |
| vSalesPerson | StateProvinceName | Name NOT NULL | |
| vSalesPerson | PostalCode | nvarchar(15) NOT NULL | |
| vSalesPerson | CountryRegionName | Name NOT NULL | |
| vSalesPerson | TerritoryName | Name NULL | |
| vSalesPerson | TerritoryGroup | nvarchar(50) NULL | |
| vSalesPerson | SalesQuota | money NULL | |
| vSalesPerson | SalesYTD | money NOT NULL | |
| vSalesPerson | SalesLastYear | money NOT NULL | |
| vSalesPersonSalesByFiscalYears | SalesPersonID | int NULL | |
| vSalesPersonSalesByFiscalYears | FullName | nvarchar(152) NULL | |
| vSalesPersonSalesByFiscalYears | JobTitle | nvarchar(50) NOT NULL | |
| vSalesPersonSalesByFiscalYears | SalesTerritory | Name NOT NULL | |
| vSalesPersonSalesByFiscalYears | 2002 | money NULL | what kind of blockhead would name a column with an integer???
|
| vSalesPersonSalesByFiscalYears | 2003 | money NULL | what kind of blockhead would name a column with an integer???
|
| vSalesPersonSalesByFiscalYears | 2004 | money NULL | what kind of blockhead would name a column with an integer???
|
| vStoreWithAddresses | BusinessEntityID | int NOT NULL | |
| vStoreWithAddresses | Name | Name NOT NULL | |
| vStoreWithAddresses | AddressType | Name NOT NULL | |
| vStoreWithAddresses | AddressLine1 | nvarchar(60) NOT NULL | |
| vStoreWithAddresses | AddressLine2 | nvarchar(60) NULL | |
| vStoreWithAddresses | City | nvarchar(30) NOT NULL | |
| vStoreWithAddresses | StateProvinceName | Name NOT NULL | |
| vStoreWithAddresses | PostalCode | nvarchar(15) NOT NULL | |
| vStoreWithAddresses | CountryRegionName | Name NOT NULL | |
| vStoreWithContacts | BusinessEntityID | int NOT NULL | |
| vStoreWithContacts | Name | Name NOT NULL | |
| vStoreWithContacts | ContactType | Name NOT NULL | |
| vStoreWithContacts | Title | nvarchar(8) NULL | |
| vStoreWithContacts | FirstName | Name NOT NULL | |
| vStoreWithContacts | MiddleName | Name NULL | |
| vStoreWithContacts | LastName | Name NOT NULL | |
| vStoreWithContacts | Suffix | nvarchar(10) NULL | |
| vStoreWithContacts | PhoneNumber | Phone NULL | |
| vStoreWithContacts | PhoneNumberType | Name NULL | |
| vStoreWithContacts | EmailAddress | nvarchar(50) NULL | |
| vStoreWithContacts | EmailPromotion | int NOT NULL | |
| vStoreWithDemographics | BusinessEntityID | int NOT NULL | |
| vStoreWithDemographics | Name | Name NOT NULL | |
| vStoreWithDemographics | AnnualSales | money NULL | |
| vStoreWithDemographics | AnnualRevenue | money NULL | |
| vStoreWithDemographics | BankName | nvarchar(50) NULL | |
| vStoreWithDemographics | BusinessType | nvarchar(5) NULL | |
| vStoreWithDemographics | YearOpened | int NULL | |
| vStoreWithDemographics | Specialty | nvarchar(50) NULL | |
| vStoreWithDemographics | SquareFeet | int NULL | |
| vStoreWithDemographics | Brands | nvarchar(30) NULL | |
| vStoreWithDemographics | Internet | nvarchar(30) NULL | |
| vStoreWithDemographics | NumberEmployees | int NULL | |