[User: Saurabh Sharma]

Server

Server Name Start Time(Only Primary) Classification Sql Version
CommonDBServer1(CommonDBServer1) 2019/09/24 10:02:21 PM Primary Microsoft SQL Server 2017 (RTM) - 14.0.1000.169 (X64) Aug 22 2017 17:04:49 Copyright (C) 2017 Microsoft Corporation Developer Edition (64-bit) on Windows 10 Pro 10.0 (Build 14393: )
CommonDBServer2(CommonDBServer2) Linked

Databases

Database Classification Created Date Log Size(MB) Data Size(MB) Total Size(MB) Recovery Model DB Collation Object Desc Object ProcessMapping
TicketReservations Secondary 2019/07/09 04:58:45 PM 3154.75 712.00 3866.75 FULL Latin1_General_CI_AI
DatabaseA Secondary 2019/05/12 06:40:50 PM 8.00 8.00 16.00 FULL Latin1_General_CI_AI
AdventureWorks2017 Primary 2019/08/11 10:02:46 PM 72.00 264.00 336.00 SIMPLE SQL_Latin1_General_CP1_CI_AS
db_monitor Secondary 2019/08/31 01:42:58 PM 8.00 8.00 16.00 FULL Latin1_General_CI_AI
db_monitor1 Secondary 2019/09/01 01:11:32 PM 8.00 8.00 16.00 FULL Latin1_General_CI_AI

Scheduled Jobs

Server Name JobName isEnabled JobSubSystem Description CreationDatetime ModificationDatetime JobServerName ProviderName DataSource Step_name Command Output_File_Name RunDurationMinute LastRunDuration LastRunDateTime LastRunStatus NextRunDateTime Occurrence Recurrence Frequency
CommonDBServer1 sp_run Enabled TSQL No description available. 2019/04/30 04:27:18 PM 2019/04/30 04:27:18 PM CommonDBServer1 SQLOLEDB CommonDBServer1 Verify that automation is enabled. IF (msdb.dbo.fn_syspolicy_is_automation_enabled() != 1) BEGIN RAISERROR(34022, 16, 1) END Failed Daily Occurs every 1 day(s) Occurs once at 02:00:00
CommonDBServer1 sp_run Enabled TSQL No description available. 2019/04/30 04:27:18 PM 2019/04/30 04:27:18 PM CommonDBServer1 SQLOLEDB CommonDBServer1 Purge history. EXEC msdb.dbo.sp_sp_run Failed Daily Occurs every 1 day(s) Occurs once at 02:00:00
CommonDBServer1 sp_run Enabled PowerShell No description available. 2019/04/30 04:27:18 PM 2019/04/30 04:27:18 PM CommonDBServer1 SQLOLEDB CommonDBServer1 Erase Phantom System Health Records. if ('$(ESCAPE_SQUOTE(INST))' -eq 'MSSQLSERVER') {$a = '\DEFAULT'} ELSE {$a = ''}; (Get-Item SQLSERVER:\SQLPolicy\$(ESCAPE_NONE(SRVR))$a).EraseSystemHealthPhantomRecords() Failed Daily Occurs every 1 day(s) Occurs once at 02:00:00

User Permissions

Database User Type Database User Name Login Name Role Permission Type Permission State Object Type Schema Name Object Name Column Name
AdventureWorks2017 SQL User guest
AdventureWorks2017 Windows User dbo CONNECT GRANT DATABASE
AdventureWorks2017 Windows User dbo db_owner

Table

Schema Name Table Name Table Row Count Total Space KB Used Space KB UnUsed Space KB Classification Created Date Last Modified Date Object Desc Object Process Mapping
dbo AWBuildVersion 1 72 16 56 RegularTable 2017/10/27 02:33:01 PM 2017/10/27 02:33:06 PM
dbo DatabaseLog 1596 6680 6600 80 RegularTable 2017/10/27 02:33:01 PM 2017/10/27 02:33:07 PM
dbo ErrorLog 0 0 0 0 RegularTable 2017/10/27 02:33:01 PM 2017/10/27 02:33:01 PM
HumanResources Department 16 144 32 112 RegularTable 2017/10/27 02:33:01 PM 2017/10/27 02:33:14 PM
HumanResources Employee 290 752 192 560 RegularTable 2017/10/27 02:33:01 PM 2019/09/13 04:38:57 PM
HumanResources EmployeeDepartmentHistory 296 344 64 280 RegularTable 2017/10/27 02:33:01 PM 2017/10/27 02:33:14 PM
HumanResources EmployeePayHistory 316 200 32 168 RegularTable 2017/10/27 02:33:01 PM 2017/10/27 02:33:14 PM
HumanResources JobCandidate 13 472 160 312 RegularTable 2017/10/27 02:33:01 PM 2017/10/27 02:33:14 PM
HumanResources Shift 3 216 48 168 RegularTable 2017/10/27 02:33:01 PM 2017/10/27 02:33:14 PM
Person Address 19614 6128 5408 720 RegularTable 2017/10/27 02:33:01 PM 2017/10/27 02:33:14 PM
Person AddressType 6 216 48 168 RegularTable 2017/10/27 02:33:01 PM 2017/10/27 02:33:14 PM
Person BusinessEntity 20777 1488 1336 152 RegularTable 2017/10/27 02:33:01 PM 2017/10/27 02:33:14 PM
Person BusinessEntityAddress 19614 2656 2312 344 RegularTable 2017/10/27 02:33:01 PM 2017/10/27 02:33:14 PM
Person BusinessEntityContact 909 800 192 608 RegularTable 2017/10/27 02:33:01 PM 2017/10/27 02:33:14 PM
Person ContactType 20 144 32 112 RegularTable 2017/10/27 02:33:01 PM 2017/10/27 02:33:14 PM
Person CountryRegion 238 400 64 336 RegularTable 2017/10/27 02:33:01 PM 2017/10/27 02:33:15 PM
Person EmailAddress 19972 3664 3496 168 RegularTable 2017/10/27 02:33:01 PM 2017/10/27 02:33:14 PM
Person Password 19972 1992 1896 96 RegularTable 2017/10/27 02:33:01 PM 2017/10/27 02:33:14 PM
Person Person 19972 33448 32120 1328 RegularTable 2017/10/27 02:33:01 PM 2017/10/27 02:33:14 PM
Person PersonPhone 19972 2320 2176 144 RegularTable 2017/10/27 02:33:01 PM 2017/10/27 02:33:14 PM
Person PhoneNumberType 3 72 16 56 RegularTable 2017/10/27 02:33:01 PM 2017/10/27 02:33:14 PM
Person StateProvince 181 416 80 336 RegularTable 2017/10/27 02:33:01 PM 2017/10/27 02:33:15 PM
Production BillOfMaterials 2679 792 360 432 RegularTable 2017/10/27 02:33:01 PM 2017/10/27 02:33:14 PM
Production Culture 8 144 32 112 RegularTable 2017/10/27 02:33:01 PM 2017/10/27 02:33:14 PM
Production Document 13 752 408 344 RegularTable 2017/10/27 02:33:01 PM 2017/10/27 02:33:14 PM
Production Illustration 5 400 248 152 RegularTable 2017/10/27 02:33:01 PM 2017/10/27 02:33:14 PM
Production Location 14 144 32 112 RegularTable 2017/10/27 02:33:01 PM 2017/10/27 02:33:14 PM
Production Product 504 864 232 632 RegularTable 2017/10/27 02:33:01 PM 2017/10/27 02:33:15 PM
Production ProductCategory 4 216 48 168 RegularTable 2017/10/27 02:33:01 PM 2017/10/27 02:33:14 PM
Production ProductCostHistory 395 200 40 160 RegularTable 2017/10/27 02:33:01 PM 2017/10/27 02:33:14 PM
Production ProductDescription 762 464 200 264 RegularTable 2017/10/27 02:33:01 PM 2017/10/27 02:33:15 PM
Production ProductDocument 32 72 16 56 RegularTable 2017/10/27 02:33:01 PM 2017/10/27 02:33:14 PM
Production ProductInventory 1069 200 72 128 RegularTable 2017/10/27 02:33:01 PM 2017/10/27 02:33:14 PM
Production ProductListPriceHistory 395 200 40 160 RegularTable 2017/10/27 02:33:01 PM 2017/10/27 02:33:14 PM
Production ProductModel 128 480 192 288 RegularTable 2017/10/27 02:33:01 PM 2017/10/27 02:33:15 PM
Production ProductModelIllustration 7 72 16 56 RegularTable 2017/10/27 02:33:01 PM 2017/10/27 02:33:14 PM
Production ProductModelProductDescriptionCulture 762 200 48 152 RegularTable 2017/10/27 02:33:01 PM 2017/10/27 02:33:15 PM
Production ProductPhoto 101 2512 2296 216 RegularTable 2017/10/27 02:33:01 PM 2017/10/27 02:33:14 PM
Production ProductProductPhoto 504 272 56 216 RegularTable 2017/10/27 02:33:01 PM 2017/10/27 02:33:14 PM
Production ProductReview 4 400 72 328 RegularTable 2017/10/27 02:33:01 PM 2017/10/27 02:33:14 PM
Production ProductSubcategory 37 216 48 168 RegularTable 2017/10/27 02:33:01 PM 2017/10/27 02:33:14 PM
Production ScrapReason 16 144 32 112 RegularTable 2017/10/27 02:33:01 PM 2017/10/27 02:33:14 PM
Production TransactionHistory 113443 11800 10264 1536 RegularTable 2017/10/27 02:33:01 PM 2017/10/27 02:33:14 PM
Production TransactionHistoryArchive 89253 9688 8136 1552 RegularTable 2017/10/27 02:33:01 PM 2017/10/27 02:33:09 PM
Production UnitMeasure 38 144 32 112 RegularTable 2017/10/27 02:33:01 PM 2017/10/27 02:33:14 PM
Production WorkOrder 72591 7576 6312 1264 RegularTable 2017/10/27 02:33:01 PM 2017/10/27 02:33:14 PM
Production WorkOrderRouting 67131 8016 6856 1160 RegularTable 2017/10/27 02:33:01 PM 2017/10/27 02:33:14 PM
Purchasing ProductVendor 460 472 104 368 RegularTable 2017/10/27 02:33:01 PM 2017/10/27 02:33:14 PM
Purchasing PurchaseOrderDetail 8845 912 704 208 RegularTable 2017/10/27 02:33:01 PM 2017/10/27 02:33:14 PM
Purchasing PurchaseOrderHeader 4012 856 496 360 RegularTable 2017/10/27 02:33:01 PM 2017/10/27 02:33:14 PM
Purchasing ShipMethod 5 216 48 168 RegularTable 2017/10/27 02:33:01 PM 2017/10/27 02:33:14 PM
Purchasing Vendor 104 272 48 224 RegularTable 2017/10/27 02:33:01 PM 2017/10/27 02:33:14 PM
Sales CountryRegionCurrency 109 144 32 112 RegularTable 2017/10/27 02:33:01 PM 2017/10/27 02:33:14 PM
Sales CreditCard 19118 2512 2328 184 RegularTable 2017/10/27 02:33:01 PM 2017/10/27 02:33:14 PM
Sales Currency 105 144 32 112 RegularTable 2017/10/27 02:33:01 PM 2017/10/27 02:33:14 PM
Sales CurrencyRate 13532 1360 1208 152 RegularTable 2017/10/27 02:33:01 PM 2017/10/27 02:33:14 PM
Sales Customer 19820 2656 2296 360 RegularTable 2017/10/27 02:33:01 PM 2017/10/27 02:33:14 PM
Sales PersonCreditCard 19118 584 496 88 RegularTable 2017/10/27 02:33:01 PM 2017/10/27 02:33:14 PM
Sales SalesOrderDetail 121317 17752 16072 1680 RegularTable 2017/10/27 02:33:01 PM 2017/10/27 02:33:14 PM
Sales SalesOrderHeader 31465 8808 8208 600 RegularTable 2017/10/27 02:33:01 PM 2017/10/27 02:33:14 PM
Sales SalesOrderHeaderSalesReason 27647 776 704 72 RegularTable 2017/10/27 02:33:01 PM 2017/10/27 02:33:14 PM
Sales SalesPerson 17 144 32 112 RegularTable 2017/10/27 02:33:01 PM 2017/10/27 02:33:14 PM
Sales SalesPersonQuotaHistory 163 272 48 224 RegularTable 2017/10/27 02:33:01 PM 2017/10/27 02:33:14 PM
Sales SalesReason 10 72 16 56 RegularTable 2017/10/27 02:33:01 PM 2017/10/27 02:33:14 PM
Sales SalesTaxRate 29 216 48 168 RegularTable 2017/10/27 02:33:01 PM 2017/10/27 02:33:14 PM
Sales SalesTerritory 10 216 48 168 RegularTable 2017/10/27 02:33:01 PM 2017/10/27 02:33:14 PM
Sales SalesTerritoryHistory 17 144 32 112 RegularTable 2017/10/27 02:33:01 PM 2017/10/27 02:33:14 PM
Sales ShoppingCartItem 3 144 32 112 RegularTable 2017/10/27 02:33:01 PM 2017/10/27 02:33:14 PM
Sales SpecialOffer 16 144 32 112 RegularTable 2017/10/27 02:33:01 PM 2017/10/27 02:33:14 PM
Sales SpecialOfferProduct 538 472 88 384 RegularTable 2017/10/27 02:33:01 PM 2017/10/27 02:33:14 PM
Sales Store 701 1304 896 408 RegularTable 2017/10/27 02:33:01 PM 2017/10/27 02:33:14 PM

View

Schema Name View Name Created Date Modified Date Object Desc Object Process Mapping
HumanResources vJobCandidate 2017/10/27 02:33:14 PM 2017/10/27 02:33:14 PM
HumanResources vJobCandidateEmployment 2017/10/27 02:33:14 PM 2017/10/27 02:33:14 PM
HumanResources vJobCandidateEducation 2017/10/27 02:33:14 PM 2017/10/27 02:33:14 PM
HumanResources vEmployee 2017/10/27 02:33:14 PM 2017/10/27 02:33:14 PM
HumanResources vEmployeeDepartment 2017/10/27 02:33:14 PM 2017/10/27 02:33:14 PM
HumanResources vEmployeeDepartmentHistory 2017/10/27 02:33:14 PM 2017/10/27 02:33:14 PM
Person vStateProvinceCountryRegion 2017/10/27 02:33:15 PM 2017/10/27 02:33:15 PM
Person vAdditionalContactInfo 2017/10/27 02:33:14 PM 2017/10/27 02:33:14 PM
Production vProductAndDescription 2017/10/27 02:33:14 PM 2017/10/27 02:33:15 PM
Production vProductModelCatalogDescription 2017/10/27 02:33:15 PM 2017/10/27 02:33:15 PM
Production vProductModelInstructions 2017/10/27 02:33:15 PM 2017/10/27 02:33:15 PM
Purchasing vVendorWithContacts 2017/10/27 02:33:15 PM 2017/10/27 02:33:15 PM
Purchasing vVendorWithAddresses 2017/10/27 02:33:15 PM 2017/10/27 02:33:15 PM
Sales vSalesPerson 2017/10/27 02:33:15 PM 2017/10/27 02:33:15 PM
Sales vSalesPersonSalesByFiscalYears 2017/10/27 02:33:15 PM 2017/10/27 02:33:15 PM
Sales vStoreWithDemographics 2017/10/27 02:33:15 PM 2017/10/27 02:33:15 PM
Sales vStoreWithContacts 2017/10/27 02:33:15 PM 2017/10/27 02:33:15 PM
Sales vStoreWithAddresses 2017/10/27 02:33:15 PM 2017/10/27 02:33:15 PM
Sales vIndividualCustomer 2017/10/27 02:33:14 PM 2017/10/27 02:33:14 PM
Sales vPersonDemographics 2017/10/27 02:33:14 PM 2017/10/27 02:33:14 PM

Columns

Schema Name Table Name Column Name Is_Nullable Column Collation MaxLength Precision Scale Datatype Datatype Desc Default Value Primary Key Foreign Key unique_key Check Constraint Computed Column Definition Object Desc Object Process Mapping
HumanResources EmployeePayHistory BusinessEntityID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK FK
HumanResources EmployeePayHistory RateChangeDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime PK
HumanResources EmployeePayHistory Rate False SQL_Latin1_General_CP1_CI_AS 8 19 4 money money CK_EmployeePayHistory_Rate
HumanResources EmployeePayHistory PayFrequency False SQL_Latin1_General_CP1_CI_AS 1 3 0 tinyint tinyint CK_EmployeePayHistory_PayFrequency
HumanResources EmployeePayHistory ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Sales SalesOrderHeaderSalesReason SalesOrderID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK FK
Sales SalesOrderHeaderSalesReason SalesReasonID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK FK
Sales SalesOrderHeaderSalesReason ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Sales SalesPerson BusinessEntityID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK FK
Sales SalesPerson TerritoryID True SQL_Latin1_General_CP1_CI_AS 4 10 0 int int FK
Sales SalesPerson SalesQuota True SQL_Latin1_General_CP1_CI_AS 8 19 4 money money CK_SalesPerson_SalesQuota
Sales SalesPerson Bonus False SQL_Latin1_General_CP1_CI_AS 8 19 4 money money ((0.00)) CK_SalesPerson_Bonus
Sales SalesPerson CommissionPct False SQL_Latin1_General_CP1_CI_AS 4 10 4 smallmoney smallmoney ((0.00)) CK_SalesPerson_CommissionPct
Sales SalesPerson SalesYTD False SQL_Latin1_General_CP1_CI_AS 8 19 4 money money ((0.00)) CK_SalesPerson_SalesYTD
Sales SalesPerson SalesLastYear False SQL_Latin1_General_CP1_CI_AS 8 19 4 money money ((0.00)) CK_SalesPerson_SalesLastYear
Sales SalesPerson rowguid False SQL_Latin1_General_CP1_CI_AS 16 0 0 uniqueidentifier uniqueidentifier (newid())
Sales SalesPerson ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Production Illustration IllustrationID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK
Production Illustration Diagram True SQL_Latin1_General_CP1_CI_AS -1 0 0 xml xml
Production Illustration ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
HumanResources JobCandidate JobCandidateID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK
HumanResources JobCandidate BusinessEntityID True SQL_Latin1_General_CP1_CI_AS 4 10 0 int int FK
HumanResources JobCandidate Resume True SQL_Latin1_General_CP1_CI_AS -1 0 0 xml xml
HumanResources JobCandidate ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Production Location LocationID False SQL_Latin1_General_CP1_CI_AS 2 5 0 smallint smallint PK
Production Location Name False SQL_Latin1_General_CP1_CI_AS 100 0 0 Name Name:nvarchar(100)
Production Location CostRate False SQL_Latin1_General_CP1_CI_AS 4 10 4 smallmoney smallmoney ((0.00)) CK_Location_CostRate
Production Location Availability False SQL_Latin1_General_CP1_CI_AS 5 8 2 decimal decimal(8, 2) ((0.00)) CK_Location_Availability
Production Location ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Person Password BusinessEntityID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK FK
Person Password PasswordHash False SQL_Latin1_General_CP1_CI_AS 128 0 0 varchar varchar(128)
Person Password PasswordSalt False SQL_Latin1_General_CP1_CI_AS 10 0 0 varchar varchar(10)
Person Password rowguid False SQL_Latin1_General_CP1_CI_AS 16 0 0 uniqueidentifier uniqueidentifier (newid())
Person Password ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Sales SalesPersonQuotaHistory BusinessEntityID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK FK
Sales SalesPersonQuotaHistory QuotaDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime PK
Sales SalesPersonQuotaHistory SalesQuota False SQL_Latin1_General_CP1_CI_AS 8 19 4 money money CK_SalesPersonQuotaHistory_SalesQuota
Sales SalesPersonQuotaHistory rowguid False SQL_Latin1_General_CP1_CI_AS 16 0 0 uniqueidentifier uniqueidentifier (newid())
Sales SalesPersonQuotaHistory ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Person Person BusinessEntityID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK FK
Person Person PersonType False SQL_Latin1_General_CP1_CI_AS 4 0 0 nchar nchar(2) CK_Person_PersonType
Person Person NameStyle False SQL_Latin1_General_CP1_CI_AS 1 1 0 NameStyle NameStyle:bit ((0))
Person Person Title True SQL_Latin1_General_CP1_CI_AS 16 0 0 nvarchar nvarchar(8)
Person Person FirstName False SQL_Latin1_General_CP1_CI_AS 100 0 0 Name Name:nvarchar(100)
Person Person MiddleName True SQL_Latin1_General_CP1_CI_AS 100 0 0 Name Name:nvarchar(100)
Person Person LastName False SQL_Latin1_General_CP1_CI_AS 100 0 0 Name Name:nvarchar(100)
Person Person Suffix True SQL_Latin1_General_CP1_CI_AS 20 0 0 nvarchar nvarchar(10)
Person Person EmailPromotion False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int ((0)) CK_Person_EmailPromotion
Person Person AdditionalContactInfo True SQL_Latin1_General_CP1_CI_AS -1 0 0 xml xml
Person Person Demographics True SQL_Latin1_General_CP1_CI_AS -1 0 0 xml xml
Person Person rowguid False SQL_Latin1_General_CP1_CI_AS 16 0 0 uniqueidentifier uniqueidentifier (newid())
Person Person ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Sales SalesReason SalesReasonID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK
Sales SalesReason Name False SQL_Latin1_General_CP1_CI_AS 100 0 0 Name Name:nvarchar(100)
Sales SalesReason ReasonType False SQL_Latin1_General_CP1_CI_AS 100 0 0 Name Name:nvarchar(100)
Sales SalesReason ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Sales SalesTaxRate SalesTaxRateID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK
Sales SalesTaxRate StateProvinceID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int FK
Sales SalesTaxRate TaxType False SQL_Latin1_General_CP1_CI_AS 1 3 0 tinyint tinyint CK_SalesTaxRate_TaxType
Sales SalesTaxRate TaxRate False SQL_Latin1_General_CP1_CI_AS 4 10 4 smallmoney smallmoney ((0.00))
Sales SalesTaxRate Name False SQL_Latin1_General_CP1_CI_AS 100 0 0 Name Name:nvarchar(100)
Sales SalesTaxRate rowguid False SQL_Latin1_General_CP1_CI_AS 16 0 0 uniqueidentifier uniqueidentifier (newid())
Sales SalesTaxRate ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Sales PersonCreditCard BusinessEntityID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK FK
Sales PersonCreditCard CreditCardID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK FK
Sales PersonCreditCard ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Person PersonPhone BusinessEntityID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK FK
Person PersonPhone PhoneNumber False SQL_Latin1_General_CP1_CI_AS 50 0 0 Phone Phone:nvarchar(50) PK
Person PersonPhone PhoneNumberTypeID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK FK
Person PersonPhone ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Sales SalesTerritory TerritoryID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK
Sales SalesTerritory Name False SQL_Latin1_General_CP1_CI_AS 100 0 0 Name Name:nvarchar(100)
Sales SalesTerritory CountryRegionCode False SQL_Latin1_General_CP1_CI_AS 6 0 0 nvarchar nvarchar(3) FK
Sales SalesTerritory Group False SQL_Latin1_General_CP1_CI_AS 100 0 0 nvarchar nvarchar(50)
Sales SalesTerritory SalesYTD False SQL_Latin1_General_CP1_CI_AS 8 19 4 money money ((0.00)) CK_SalesTerritory_SalesYTD
Sales SalesTerritory SalesLastYear False SQL_Latin1_General_CP1_CI_AS 8 19 4 money money ((0.00)) CK_SalesTerritory_SalesLastYear
Sales SalesTerritory CostYTD False SQL_Latin1_General_CP1_CI_AS 8 19 4 money money ((0.00)) CK_SalesTerritory_CostYTD
Sales SalesTerritory CostLastYear False SQL_Latin1_General_CP1_CI_AS 8 19 4 money money ((0.00)) CK_SalesTerritory_CostLastYear
Sales SalesTerritory rowguid False SQL_Latin1_General_CP1_CI_AS 16 0 0 uniqueidentifier uniqueidentifier (newid())
Sales SalesTerritory ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Person PhoneNumberType PhoneNumberTypeID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK
Person PhoneNumberType Name False SQL_Latin1_General_CP1_CI_AS 100 0 0 Name Name:nvarchar(100)
Person PhoneNumberType ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Production Product ProductID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK
Production Product Name False SQL_Latin1_General_CP1_CI_AS 100 0 0 Name Name:nvarchar(100)
Production Product ProductNumber False SQL_Latin1_General_CP1_CI_AS 50 0 0 nvarchar nvarchar(25)
Production Product MakeFlag False SQL_Latin1_General_CP1_CI_AS 1 1 0 Flag Flag:bit ((1))
Production Product FinishedGoodsFlag False SQL_Latin1_General_CP1_CI_AS 1 1 0 Flag Flag:bit ((1))
Production Product Color True SQL_Latin1_General_CP1_CI_AS 30 0 0 nvarchar nvarchar(15)
Production Product SafetyStockLevel False SQL_Latin1_General_CP1_CI_AS 2 5 0 smallint smallint CK_Product_SafetyStockLevel
Production Product ReorderPoint False SQL_Latin1_General_CP1_CI_AS 2 5 0 smallint smallint CK_Product_ReorderPoint
Production Product StandardCost False SQL_Latin1_General_CP1_CI_AS 8 19 4 money money CK_Product_StandardCost
Production Product ListPrice False SQL_Latin1_General_CP1_CI_AS 8 19 4 money money CK_Product_ListPrice
Production Product Size True SQL_Latin1_General_CP1_CI_AS 10 0 0 nvarchar nvarchar(5)
Production Product SizeUnitMeasureCode True SQL_Latin1_General_CP1_CI_AS 6 0 0 nchar nchar(3) FK
Production Product WeightUnitMeasureCode True SQL_Latin1_General_CP1_CI_AS 6 0 0 nchar nchar(3) FK
Production Product Weight True SQL_Latin1_General_CP1_CI_AS 5 8 2 decimal decimal(8, 2) CK_Product_Weight
Production Product DaysToManufacture False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int CK_Product_DaysToManufacture
Production Product ProductLine True SQL_Latin1_General_CP1_CI_AS 4 0 0 nchar nchar(2) CK_Product_ProductLine
Production Product Class True SQL_Latin1_General_CP1_CI_AS 4 0 0 nchar nchar(2) CK_Product_Class
Production Product Style True SQL_Latin1_General_CP1_CI_AS 4 0 0 nchar nchar(2) CK_Product_Style
Production Product ProductSubcategoryID True SQL_Latin1_General_CP1_CI_AS 4 10 0 int int FK
Production Product ProductModelID True SQL_Latin1_General_CP1_CI_AS 4 10 0 int int FK
Production Product SellStartDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime
Production Product SellEndDate True SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime
Production Product DiscontinuedDate True SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime
Production Product rowguid False SQL_Latin1_General_CP1_CI_AS 16 0 0 uniqueidentifier uniqueidentifier (newid())
Production Product ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Sales SalesTerritoryHistory BusinessEntityID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK FK
Sales SalesTerritoryHistory TerritoryID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK FK
Sales SalesTerritoryHistory StartDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime PK
Sales SalesTerritoryHistory EndDate True SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime
Sales SalesTerritoryHistory rowguid False SQL_Latin1_General_CP1_CI_AS 16 0 0 uniqueidentifier uniqueidentifier (newid())
Sales SalesTerritoryHistory ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Production ScrapReason ScrapReasonID False SQL_Latin1_General_CP1_CI_AS 2 5 0 smallint smallint PK
Production ScrapReason Name False SQL_Latin1_General_CP1_CI_AS 100 0 0 Name Name:nvarchar(100)
Production ScrapReason ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
HumanResources Shift ShiftID False SQL_Latin1_General_CP1_CI_AS 1 3 0 tinyint tinyint PK
HumanResources Shift Name False SQL_Latin1_General_CP1_CI_AS 100 0 0 Name Name:nvarchar(100)
HumanResources Shift StartTime False SQL_Latin1_General_CP1_CI_AS 5 16 7 time time(7)
HumanResources Shift EndTime False SQL_Latin1_General_CP1_CI_AS 5 16 7 time time(7)
HumanResources Shift ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Production ProductCategory ProductCategoryID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK
Production ProductCategory Name False SQL_Latin1_General_CP1_CI_AS 100 0 0 Name Name:nvarchar(100)
Production ProductCategory rowguid False SQL_Latin1_General_CP1_CI_AS 16 0 0 uniqueidentifier uniqueidentifier (newid())
Production ProductCategory ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Purchasing ShipMethod ShipMethodID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK
Purchasing ShipMethod Name False SQL_Latin1_General_CP1_CI_AS 100 0 0 Name Name:nvarchar(100)
Purchasing ShipMethod ShipBase False SQL_Latin1_General_CP1_CI_AS 8 19 4 money money ((0.00)) CK_ShipMethod_ShipBase
Purchasing ShipMethod ShipRate False SQL_Latin1_General_CP1_CI_AS 8 19 4 money money ((0.00)) CK_ShipMethod_ShipRate
Purchasing ShipMethod rowguid False SQL_Latin1_General_CP1_CI_AS 16 0 0 uniqueidentifier uniqueidentifier (newid())
Purchasing ShipMethod ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Production ProductCostHistory ProductID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK FK
Production ProductCostHistory StartDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime PK
Production ProductCostHistory EndDate True SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime
Production ProductCostHistory StandardCost False SQL_Latin1_General_CP1_CI_AS 8 19 4 money money CK_ProductCostHistory_StandardCost
Production ProductCostHistory ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Production ProductDescription ProductDescriptionID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK
Production ProductDescription Description False SQL_Latin1_General_CP1_CI_AS 800 0 0 nvarchar nvarchar(400)
Production ProductDescription rowguid False SQL_Latin1_General_CP1_CI_AS 16 0 0 uniqueidentifier uniqueidentifier (newid())
Production ProductDescription ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Sales ShoppingCartItem ShoppingCartItemID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK
Sales ShoppingCartItem ShoppingCartID False SQL_Latin1_General_CP1_CI_AS 100 0 0 nvarchar nvarchar(50)
Sales ShoppingCartItem Quantity False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int ((1)) CK_ShoppingCartItem_Quantity
Sales ShoppingCartItem ProductID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int FK
Sales ShoppingCartItem DateCreated False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Sales ShoppingCartItem ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Production ProductDocument ProductID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK FK
Production ProductDocument DocumentNode False SQL_Latin1_General_CP1_CI_AS 892 0 0 hierarchyid hierarchyid PK FK
Production ProductDocument ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
dbo DatabaseLog DatabaseLogID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK
dbo DatabaseLog PostTime False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime
dbo DatabaseLog DatabaseUser False SQL_Latin1_General_CP1_CI_AS 256 0 0 sysname sysname
dbo DatabaseLog Event False SQL_Latin1_General_CP1_CI_AS 256 0 0 sysname sysname
dbo DatabaseLog Schema True SQL_Latin1_General_CP1_CI_AS 256 0 0 sysname sysname
dbo DatabaseLog Object True SQL_Latin1_General_CP1_CI_AS 256 0 0 sysname sysname
dbo DatabaseLog TSQL False SQL_Latin1_General_CP1_CI_AS -1 0 0 nvarchar nvarchar(MAX)
dbo DatabaseLog XmlEvent False SQL_Latin1_General_CP1_CI_AS -1 0 0 xml xml
Production ProductInventory ProductID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK FK
Production ProductInventory LocationID False SQL_Latin1_General_CP1_CI_AS 2 5 0 smallint smallint PK FK
Production ProductInventory Shelf False SQL_Latin1_General_CP1_CI_AS 20 0 0 nvarchar nvarchar(10) CK_ProductInventory_Shelf
Production ProductInventory Bin False SQL_Latin1_General_CP1_CI_AS 1 3 0 tinyint tinyint CK_ProductInventory_Bin
Production ProductInventory Quantity False SQL_Latin1_General_CP1_CI_AS 2 5 0 smallint smallint ((0))
Production ProductInventory rowguid False SQL_Latin1_General_CP1_CI_AS 16 0 0 uniqueidentifier uniqueidentifier (newid())
Production ProductInventory ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Sales SpecialOffer SpecialOfferID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK
Sales SpecialOffer Description False SQL_Latin1_General_CP1_CI_AS 510 0 0 nvarchar nvarchar(255)
Sales SpecialOffer DiscountPct False SQL_Latin1_General_CP1_CI_AS 4 10 4 smallmoney smallmoney ((0.00)) CK_SpecialOffer_DiscountPct
Sales SpecialOffer Type False SQL_Latin1_General_CP1_CI_AS 100 0 0 nvarchar nvarchar(50)
Sales SpecialOffer Category False SQL_Latin1_General_CP1_CI_AS 100 0 0 nvarchar nvarchar(50)
Sales SpecialOffer StartDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime
Sales SpecialOffer EndDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime
Sales SpecialOffer MinQty False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int ((0)) CK_SpecialOffer_MinQty
Sales SpecialOffer MaxQty True SQL_Latin1_General_CP1_CI_AS 4 10 0 int int CK_SpecialOffer_MaxQty
Sales SpecialOffer rowguid False SQL_Latin1_General_CP1_CI_AS 16 0 0 uniqueidentifier uniqueidentifier (newid())
Sales SpecialOffer ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
dbo ErrorLog ErrorLogID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK
dbo ErrorLog ErrorTime False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
dbo ErrorLog UserName False SQL_Latin1_General_CP1_CI_AS 256 0 0 sysname sysname
dbo ErrorLog ErrorNumber False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int
dbo ErrorLog ErrorSeverity True SQL_Latin1_General_CP1_CI_AS 4 10 0 int int
dbo ErrorLog ErrorState True SQL_Latin1_General_CP1_CI_AS 4 10 0 int int
dbo ErrorLog ErrorProcedure True SQL_Latin1_General_CP1_CI_AS 252 0 0 nvarchar nvarchar(126)
dbo ErrorLog ErrorLine True SQL_Latin1_General_CP1_CI_AS 4 10 0 int int
dbo ErrorLog ErrorMessage False SQL_Latin1_General_CP1_CI_AS 8000 0 0 nvarchar nvarchar(4000)
Production ProductListPriceHistory ProductID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK FK
Production ProductListPriceHistory StartDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime PK
Production ProductListPriceHistory EndDate True SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime
Production ProductListPriceHistory ListPrice False SQL_Latin1_General_CP1_CI_AS 8 19 4 money money CK_ProductListPriceHistory_ListPrice
Production ProductListPriceHistory ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Person Address AddressID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK
Person Address AddressLine1 False SQL_Latin1_General_CP1_CI_AS 120 0 0 nvarchar nvarchar(60)
Person Address AddressLine2 True SQL_Latin1_General_CP1_CI_AS 120 0 0 nvarchar nvarchar(60)
Person Address City False SQL_Latin1_General_CP1_CI_AS 60 0 0 nvarchar nvarchar(30)
Person Address StateProvinceID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int FK
Person Address PostalCode False SQL_Latin1_General_CP1_CI_AS 30 0 0 nvarchar nvarchar(15)
Person Address SpatialLocation True SQL_Latin1_General_CP1_CI_AS -1 0 0 geography geography
Person Address rowguid False SQL_Latin1_General_CP1_CI_AS 16 0 0 uniqueidentifier uniqueidentifier (newid())
Person Address ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Sales SpecialOfferProduct SpecialOfferID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK FK
Sales SpecialOfferProduct ProductID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK FK
Sales SpecialOfferProduct rowguid False SQL_Latin1_General_CP1_CI_AS 16 0 0 uniqueidentifier uniqueidentifier (newid())
Sales SpecialOfferProduct ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Production ProductModel ProductModelID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK
Production ProductModel Name False SQL_Latin1_General_CP1_CI_AS 100 0 0 Name Name:nvarchar(100)
Production ProductModel CatalogDescription True SQL_Latin1_General_CP1_CI_AS -1 0 0 xml xml
Production ProductModel Instructions True SQL_Latin1_General_CP1_CI_AS -1 0 0 xml xml
Production ProductModel rowguid False SQL_Latin1_General_CP1_CI_AS 16 0 0 uniqueidentifier uniqueidentifier (newid())
Production ProductModel ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Person AddressType AddressTypeID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK
Person AddressType Name False SQL_Latin1_General_CP1_CI_AS 100 0 0 Name Name:nvarchar(100)
Person AddressType rowguid False SQL_Latin1_General_CP1_CI_AS 16 0 0 uniqueidentifier uniqueidentifier (newid())
Person AddressType ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Person StateProvince StateProvinceID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK
Person StateProvince StateProvinceCode False SQL_Latin1_General_CP1_CI_AS 6 0 0 nchar nchar(3)
Person StateProvince CountryRegionCode False SQL_Latin1_General_CP1_CI_AS 6 0 0 nvarchar nvarchar(3) FK
Person StateProvince IsOnlyStateProvinceFlag False SQL_Latin1_General_CP1_CI_AS 1 1 0 Flag Flag:bit ((1))
Person StateProvince Name False SQL_Latin1_General_CP1_CI_AS 100 0 0 Name Name:nvarchar(100)
Person StateProvince TerritoryID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int FK
Person StateProvince rowguid False SQL_Latin1_General_CP1_CI_AS 16 0 0 uniqueidentifier uniqueidentifier (newid())
Person StateProvince ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Production ProductModelIllustration ProductModelID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK FK
Production ProductModelIllustration IllustrationID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK FK
Production ProductModelIllustration ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
dbo AWBuildVersion SystemInformationID False SQL_Latin1_General_CP1_CI_AS 1 3 0 tinyint tinyint PK
dbo AWBuildVersion Database Version False SQL_Latin1_General_CP1_CI_AS 50 0 0 nvarchar nvarchar(25)
dbo AWBuildVersion VersionDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime
dbo AWBuildVersion ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Production ProductModelProductDescriptionCulture ProductModelID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK FK
Production ProductModelProductDescriptionCulture ProductDescriptionID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK FK
Production ProductModelProductDescriptionCulture CultureID False SQL_Latin1_General_CP1_CI_AS 12 0 0 nchar nchar(6) PK FK
Production ProductModelProductDescriptionCulture ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Production BillOfMaterials BillOfMaterialsID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK
Production BillOfMaterials ProductAssemblyID True SQL_Latin1_General_CP1_CI_AS 4 10 0 int int FK
Production BillOfMaterials ComponentID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int FK
Production BillOfMaterials StartDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Production BillOfMaterials EndDate True SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime
Production BillOfMaterials UnitMeasureCode False SQL_Latin1_General_CP1_CI_AS 6 0 0 nchar nchar(3) FK
Production BillOfMaterials BOMLevel False SQL_Latin1_General_CP1_CI_AS 2 5 0 smallint smallint
Production BillOfMaterials PerAssemblyQty False SQL_Latin1_General_CP1_CI_AS 5 8 2 decimal decimal(8, 2) ((1.00)) CK_BillOfMaterials_PerAssemblyQty
Production BillOfMaterials ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Sales Store BusinessEntityID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK FK
Sales Store Name False SQL_Latin1_General_CP1_CI_AS 100 0 0 Name Name:nvarchar(100)
Sales Store SalesPersonID True SQL_Latin1_General_CP1_CI_AS 4 10 0 int int FK
Sales Store Demographics True SQL_Latin1_General_CP1_CI_AS -1 0 0 xml xml
Sales Store rowguid False SQL_Latin1_General_CP1_CI_AS 16 0 0 uniqueidentifier uniqueidentifier (newid())
Sales Store ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Production ProductPhoto ProductPhotoID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK
Production ProductPhoto ThumbNailPhoto True SQL_Latin1_General_CP1_CI_AS -1 0 0 varbinary varbinary(MAX)
Production ProductPhoto ThumbnailPhotoFileName True SQL_Latin1_General_CP1_CI_AS 100 0 0 nvarchar nvarchar(50)
Production ProductPhoto LargePhoto True SQL_Latin1_General_CP1_CI_AS -1 0 0 varbinary varbinary(MAX)
Production ProductPhoto LargePhotoFileName True SQL_Latin1_General_CP1_CI_AS 100 0 0 nvarchar nvarchar(50)
Production ProductPhoto ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Production ProductProductPhoto ProductID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK FK
Production ProductProductPhoto ProductPhotoID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK FK
Production ProductProductPhoto Primary False SQL_Latin1_General_CP1_CI_AS 1 1 0 Flag Flag:bit ((0))
Production ProductProductPhoto ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Production TransactionHistory TransactionID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK
Production TransactionHistory ProductID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int FK
Production TransactionHistory ReferenceOrderID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int
Production TransactionHistory ReferenceOrderLineID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int ((0))
Production TransactionHistory TransactionDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Production TransactionHistory TransactionType False SQL_Latin1_General_CP1_CI_AS 2 0 0 nchar nchar(1) CK_TransactionHistory_TransactionType
Production TransactionHistory Quantity False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int
Production TransactionHistory ActualCost False SQL_Latin1_General_CP1_CI_AS 8 19 4 money money
Production TransactionHistory ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Production ProductReview ProductReviewID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK
Production ProductReview ProductID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int FK
Production ProductReview ReviewerName False SQL_Latin1_General_CP1_CI_AS 100 0 0 Name Name:nvarchar(100)
Production ProductReview ReviewDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Production ProductReview EmailAddress False SQL_Latin1_General_CP1_CI_AS 100 0 0 nvarchar nvarchar(50)
Production ProductReview Rating False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int CK_ProductReview_Rating
Production ProductReview Comments True SQL_Latin1_General_CP1_CI_AS 7700 0 0 nvarchar nvarchar(3850)
Production ProductReview ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Person BusinessEntity BusinessEntityID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK
Person BusinessEntity rowguid False SQL_Latin1_General_CP1_CI_AS 16 0 0 uniqueidentifier uniqueidentifier (newid())
Person BusinessEntity ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Production TransactionHistoryArchive TransactionID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK
Production TransactionHistoryArchive ProductID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int
Production TransactionHistoryArchive ReferenceOrderID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int
Production TransactionHistoryArchive ReferenceOrderLineID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int ((0))
Production TransactionHistoryArchive TransactionDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Production TransactionHistoryArchive TransactionType False SQL_Latin1_General_CP1_CI_AS 2 0 0 nchar nchar(1) CK_TransactionHistoryArchive_TransactionType
Production TransactionHistoryArchive Quantity False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int
Production TransactionHistoryArchive ActualCost False SQL_Latin1_General_CP1_CI_AS 8 19 4 money money
Production TransactionHistoryArchive ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Production ProductSubcategory ProductSubcategoryID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK
Production ProductSubcategory ProductCategoryID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int FK
Production ProductSubcategory Name False SQL_Latin1_General_CP1_CI_AS 100 0 0 Name Name:nvarchar(100)
Production ProductSubcategory rowguid False SQL_Latin1_General_CP1_CI_AS 16 0 0 uniqueidentifier uniqueidentifier (newid())
Production ProductSubcategory ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Person BusinessEntityAddress BusinessEntityID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK FK
Person BusinessEntityAddress AddressID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK FK
Person BusinessEntityAddress AddressTypeID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK FK
Person BusinessEntityAddress rowguid False SQL_Latin1_General_CP1_CI_AS 16 0 0 uniqueidentifier uniqueidentifier (newid())
Person BusinessEntityAddress ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Purchasing ProductVendor ProductID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK FK
Purchasing ProductVendor BusinessEntityID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK FK
Purchasing ProductVendor AverageLeadTime False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int CK_ProductVendor_AverageLeadTime
Purchasing ProductVendor StandardPrice False SQL_Latin1_General_CP1_CI_AS 8 19 4 money money CK_ProductVendor_StandardPrice
Purchasing ProductVendor LastReceiptCost True SQL_Latin1_General_CP1_CI_AS 8 19 4 money money CK_ProductVendor_LastReceiptCost
Purchasing ProductVendor LastReceiptDate True SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime
Purchasing ProductVendor MinOrderQty False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int CK_ProductVendor_MinOrderQty
Purchasing ProductVendor MaxOrderQty False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int CK_ProductVendor_MaxOrderQty
Purchasing ProductVendor OnOrderQty True SQL_Latin1_General_CP1_CI_AS 4 10 0 int int CK_ProductVendor_OnOrderQty
Purchasing ProductVendor UnitMeasureCode False SQL_Latin1_General_CP1_CI_AS 6 0 0 nchar nchar(3) FK
Purchasing ProductVendor ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Person BusinessEntityContact BusinessEntityID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK FK
Person BusinessEntityContact PersonID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK FK
Person BusinessEntityContact ContactTypeID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK FK
Person BusinessEntityContact rowguid False SQL_Latin1_General_CP1_CI_AS 16 0 0 uniqueidentifier uniqueidentifier (newid())
Person BusinessEntityContact ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Production UnitMeasure UnitMeasureCode False SQL_Latin1_General_CP1_CI_AS 6 0 0 nchar nchar(3) PK
Production UnitMeasure Name False SQL_Latin1_General_CP1_CI_AS 100 0 0 Name Name:nvarchar(100)
Production UnitMeasure ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Purchasing Vendor BusinessEntityID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK FK
Purchasing Vendor AccountNumber False SQL_Latin1_General_CP1_CI_AS 30 0 0 AccountNumber AccountNumber:nvarchar(30)
Purchasing Vendor Name False SQL_Latin1_General_CP1_CI_AS 100 0 0 Name Name:nvarchar(100)
Purchasing Vendor CreditRating False SQL_Latin1_General_CP1_CI_AS 1 3 0 tinyint tinyint CK_Vendor_CreditRating
Purchasing Vendor PreferredVendorStatus False SQL_Latin1_General_CP1_CI_AS 1 1 0 Flag Flag:bit ((1))
Purchasing Vendor ActiveFlag False SQL_Latin1_General_CP1_CI_AS 1 1 0 Flag Flag:bit ((1))
Purchasing Vendor PurchasingWebServiceURL True SQL_Latin1_General_CP1_CI_AS 2048 0 0 nvarchar nvarchar(1024)
Purchasing Vendor ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Person ContactType ContactTypeID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK
Person ContactType Name False SQL_Latin1_General_CP1_CI_AS 100 0 0 Name Name:nvarchar(100)
Person ContactType ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Sales CountryRegionCurrency CountryRegionCode False SQL_Latin1_General_CP1_CI_AS 6 0 0 nvarchar nvarchar(3) PK FK
Sales CountryRegionCurrency CurrencyCode False SQL_Latin1_General_CP1_CI_AS 6 0 0 nchar nchar(3) PK FK
Sales CountryRegionCurrency ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Person CountryRegion CountryRegionCode False SQL_Latin1_General_CP1_CI_AS 6 0 0 nvarchar nvarchar(3) PK
Person CountryRegion Name False SQL_Latin1_General_CP1_CI_AS 100 0 0 Name Name:nvarchar(100)
Person CountryRegion ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Production WorkOrder WorkOrderID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK
Production WorkOrder ProductID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int FK
Production WorkOrder OrderQty False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int CK_WorkOrder_OrderQty
Production WorkOrder StockedQty False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int (isnull([OrderQty]-[ScrappedQty],(0)))
Production WorkOrder ScrappedQty False SQL_Latin1_General_CP1_CI_AS 2 5 0 smallint smallint CK_WorkOrder_ScrappedQty
Production WorkOrder StartDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime
Production WorkOrder EndDate True SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime
Production WorkOrder DueDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime
Production WorkOrder ScrapReasonID True SQL_Latin1_General_CP1_CI_AS 2 5 0 smallint smallint FK
Production WorkOrder ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Purchasing PurchaseOrderDetail PurchaseOrderID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK FK
Purchasing PurchaseOrderDetail PurchaseOrderDetailID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK
Purchasing PurchaseOrderDetail DueDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime
Purchasing PurchaseOrderDetail OrderQty False SQL_Latin1_General_CP1_CI_AS 2 5 0 smallint smallint CK_PurchaseOrderDetail_OrderQty
Purchasing PurchaseOrderDetail ProductID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int FK
Purchasing PurchaseOrderDetail UnitPrice False SQL_Latin1_General_CP1_CI_AS 8 19 4 money money CK_PurchaseOrderDetail_UnitPrice
Purchasing PurchaseOrderDetail LineTotal False SQL_Latin1_General_CP1_CI_AS 8 19 4 money money (isnull([OrderQty]*[UnitPrice],(0.00)))
Purchasing PurchaseOrderDetail ReceivedQty False SQL_Latin1_General_CP1_CI_AS 5 8 2 decimal decimal(8, 2) CK_PurchaseOrderDetail_ReceivedQty
Purchasing PurchaseOrderDetail RejectedQty False SQL_Latin1_General_CP1_CI_AS 5 8 2 decimal decimal(8, 2) CK_PurchaseOrderDetail_RejectedQty
Purchasing PurchaseOrderDetail StockedQty False SQL_Latin1_General_CP1_CI_AS 5 9 2 decimal decimal(9, 2) (isnull([ReceivedQty]-[RejectedQty],(0.00)))
Purchasing PurchaseOrderDetail ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Sales CreditCard CreditCardID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK
Sales CreditCard CardType False SQL_Latin1_General_CP1_CI_AS 100 0 0 nvarchar nvarchar(50)
Sales CreditCard CardNumber False SQL_Latin1_General_CP1_CI_AS 50 0 0 nvarchar nvarchar(25)
Sales CreditCard ExpMonth False SQL_Latin1_General_CP1_CI_AS 1 3 0 tinyint tinyint
Sales CreditCard ExpYear False SQL_Latin1_General_CP1_CI_AS 2 5 0 smallint smallint
Sales CreditCard ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Production Culture CultureID False SQL_Latin1_General_CP1_CI_AS 12 0 0 nchar nchar(6) PK
Production Culture Name False SQL_Latin1_General_CP1_CI_AS 100 0 0 Name Name:nvarchar(100)
Production Culture ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Production WorkOrderRouting WorkOrderID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK FK
Production WorkOrderRouting ProductID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK
Production WorkOrderRouting OperationSequence False SQL_Latin1_General_CP1_CI_AS 2 5 0 smallint smallint PK
Production WorkOrderRouting LocationID False SQL_Latin1_General_CP1_CI_AS 2 5 0 smallint smallint FK
Production WorkOrderRouting ScheduledStartDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime
Production WorkOrderRouting ScheduledEndDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime
Production WorkOrderRouting ActualStartDate True SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime
Production WorkOrderRouting ActualEndDate True SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime
Production WorkOrderRouting ActualResourceHrs True SQL_Latin1_General_CP1_CI_AS 5 9 4 decimal decimal(9, 4) CK_WorkOrderRouting_ActualResourceHrs
Production WorkOrderRouting PlannedCost False SQL_Latin1_General_CP1_CI_AS 8 19 4 money money CK_WorkOrderRouting_PlannedCost
Production WorkOrderRouting ActualCost True SQL_Latin1_General_CP1_CI_AS 8 19 4 money money CK_WorkOrderRouting_ActualCost
Production WorkOrderRouting ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Sales Currency CurrencyCode False SQL_Latin1_General_CP1_CI_AS 6 0 0 nchar nchar(3) PK
Sales Currency Name False SQL_Latin1_General_CP1_CI_AS 100 0 0 Name Name:nvarchar(100)
Sales Currency ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Purchasing PurchaseOrderHeader PurchaseOrderID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK
Purchasing PurchaseOrderHeader RevisionNumber False SQL_Latin1_General_CP1_CI_AS 1 3 0 tinyint tinyint ((0))
Purchasing PurchaseOrderHeader Status False SQL_Latin1_General_CP1_CI_AS 1 3 0 tinyint tinyint ((1)) CK_PurchaseOrderHeader_Status
Purchasing PurchaseOrderHeader EmployeeID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int FK
Purchasing PurchaseOrderHeader VendorID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int FK
Purchasing PurchaseOrderHeader ShipMethodID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int FK
Purchasing PurchaseOrderHeader OrderDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Purchasing PurchaseOrderHeader ShipDate True SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime
Purchasing PurchaseOrderHeader SubTotal False SQL_Latin1_General_CP1_CI_AS 8 19 4 money money ((0.00)) CK_PurchaseOrderHeader_SubTotal
Purchasing PurchaseOrderHeader TaxAmt False SQL_Latin1_General_CP1_CI_AS 8 19 4 money money ((0.00)) CK_PurchaseOrderHeader_TaxAmt
Purchasing PurchaseOrderHeader Freight False SQL_Latin1_General_CP1_CI_AS 8 19 4 money money ((0.00)) CK_PurchaseOrderHeader_Freight
Purchasing PurchaseOrderHeader TotalDue False SQL_Latin1_General_CP1_CI_AS 8 19 4 money money (isnull(([SubTotal]+[TaxAmt])+[Freight],(0)))
Purchasing PurchaseOrderHeader ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Sales CurrencyRate CurrencyRateID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK
Sales CurrencyRate CurrencyRateDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime
Sales CurrencyRate FromCurrencyCode False SQL_Latin1_General_CP1_CI_AS 6 0 0 nchar nchar(3) FK
Sales CurrencyRate ToCurrencyCode False SQL_Latin1_General_CP1_CI_AS 6 0 0 nchar nchar(3) FK
Sales CurrencyRate AverageRate False SQL_Latin1_General_CP1_CI_AS 8 19 4 money money
Sales CurrencyRate EndOfDayRate False SQL_Latin1_General_CP1_CI_AS 8 19 4 money money
Sales CurrencyRate ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Sales Customer CustomerID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK
Sales Customer PersonID True SQL_Latin1_General_CP1_CI_AS 4 10 0 int int FK
Sales Customer StoreID True SQL_Latin1_General_CP1_CI_AS 4 10 0 int int FK
Sales Customer TerritoryID True SQL_Latin1_General_CP1_CI_AS 4 10 0 int int FK
Sales Customer AccountNumber False SQL_Latin1_General_CP1_CI_AS 10 0 0 varchar varchar(10) (isnull('AW'+[dbo].[ufnLeadingZeros]([CustomerID]),''))
Sales Customer rowguid False SQL_Latin1_General_CP1_CI_AS 16 0 0 uniqueidentifier uniqueidentifier (newid())
Sales Customer ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
HumanResources Department DepartmentID False SQL_Latin1_General_CP1_CI_AS 2 5 0 smallint smallint PK
HumanResources Department Name False SQL_Latin1_General_CP1_CI_AS 100 0 0 Name Name:nvarchar(100)
HumanResources Department GroupName False SQL_Latin1_General_CP1_CI_AS 100 0 0 Name Name:nvarchar(100)
HumanResources Department ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Production Document DocumentNode False SQL_Latin1_General_CP1_CI_AS 892 0 0 hierarchyid hierarchyid PK
Production Document DocumentLevel True SQL_Latin1_General_CP1_CI_AS 2 5 0 smallint smallint ([DocumentNode].[GetLevel]())
Production Document Title False SQL_Latin1_General_CP1_CI_AS 100 0 0 nvarchar nvarchar(50)
Production Document Owner False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int FK
Production Document FolderFlag False SQL_Latin1_General_CP1_CI_AS 1 1 0 bit bit ((0))
Production Document FileName False SQL_Latin1_General_CP1_CI_AS 800 0 0 nvarchar nvarchar(400)
Production Document FileExtension False SQL_Latin1_General_CP1_CI_AS 16 0 0 nvarchar nvarchar(8)
Production Document Revision False SQL_Latin1_General_CP1_CI_AS 10 0 0 nchar nchar(5)
Production Document ChangeNumber False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int ((0))
Production Document Status False SQL_Latin1_General_CP1_CI_AS 1 3 0 tinyint tinyint CK_Document_Status
Production Document DocumentSummary True SQL_Latin1_General_CP1_CI_AS -1 0 0 nvarchar nvarchar(MAX)
Production Document Document True SQL_Latin1_General_CP1_CI_AS -1 0 0 varbinary varbinary(MAX)
Production Document rowguid False SQL_Latin1_General_CP1_CI_AS 16 0 0 uniqueidentifier uniqueidentifier (newid()) UK
Production Document ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Sales SalesOrderDetail SalesOrderID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK FK
Sales SalesOrderDetail SalesOrderDetailID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK
Sales SalesOrderDetail CarrierTrackingNumber True SQL_Latin1_General_CP1_CI_AS 50 0 0 nvarchar nvarchar(25)
Sales SalesOrderDetail OrderQty False SQL_Latin1_General_CP1_CI_AS 2 5 0 smallint smallint CK_SalesOrderDetail_OrderQty
Sales SalesOrderDetail ProductID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int FK
Sales SalesOrderDetail SpecialOfferID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int FK
Sales SalesOrderDetail UnitPrice False SQL_Latin1_General_CP1_CI_AS 8 19 4 money money CK_SalesOrderDetail_UnitPrice
Sales SalesOrderDetail UnitPriceDiscount False SQL_Latin1_General_CP1_CI_AS 8 19 4 money money ((0.0)) CK_SalesOrderDetail_UnitPriceDiscount
Sales SalesOrderDetail LineTotal False SQL_Latin1_General_CP1_CI_AS 17 38 6 numeric numeric(38, 6) (isnull(([UnitPrice]*((1.0)-[UnitPriceDiscount]))*[OrderQty],(0.0)))
Sales SalesOrderDetail rowguid False SQL_Latin1_General_CP1_CI_AS 16 0 0 uniqueidentifier uniqueidentifier (newid())
Sales SalesOrderDetail ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Person EmailAddress BusinessEntityID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK FK
Person EmailAddress EmailAddressID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK
Person EmailAddress EmailAddress True SQL_Latin1_General_CP1_CI_AS 100 0 0 nvarchar nvarchar(50)
Person EmailAddress rowguid False SQL_Latin1_General_CP1_CI_AS 16 0 0 uniqueidentifier uniqueidentifier (newid())
Person EmailAddress ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
HumanResources Employee BusinessEntityID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK FK
HumanResources Employee NationalIDNumber False SQL_Latin1_General_CP1_CI_AS 30 0 0 nvarchar nvarchar(15)
HumanResources Employee LoginID False SQL_Latin1_General_CP1_CI_AS 512 0 0 nvarchar nvarchar(256)
HumanResources Employee OrganizationNode True SQL_Latin1_General_CP1_CI_AS 892 0 0 hierarchyid hierarchyid
HumanResources Employee OrganizationLevel True SQL_Latin1_General_CP1_CI_AS 2 5 0 smallint smallint ([OrganizationNode].[GetLevel]())
HumanResources Employee JobTitle False SQL_Latin1_General_CP1_CI_AS 100 0 0 nvarchar nvarchar(50)
HumanResources Employee BirthDate False SQL_Latin1_General_CP1_CI_AS 3 10 0 date date CK_Employee_BirthDate
HumanResources Employee MaritalStatus False SQL_Latin1_General_CP1_CI_AS 2 0 0 nchar nchar(1) CK_Employee_MaritalStatus
HumanResources Employee Gender False SQL_Latin1_General_CP1_CI_AS 2 0 0 nchar nchar(1) CK_Employee_Gender
HumanResources Employee HireDate False SQL_Latin1_General_CP1_CI_AS 3 10 0 date date CK_Employee_HireDate
HumanResources Employee SalariedFlag False SQL_Latin1_General_CP1_CI_AS 1 1 0 Flag Flag:bit ((1))
HumanResources Employee VacationHours False SQL_Latin1_General_CP1_CI_AS 2 5 0 smallint smallint ((0)) CK_Employee_VacationHours
HumanResources Employee SickLeaveHours False SQL_Latin1_General_CP1_CI_AS 2 5 0 smallint smallint ((0)) CK_Employee_SickLeaveHours
HumanResources Employee CurrentFlag False SQL_Latin1_General_CP1_CI_AS 1 1 0 Flag Flag:bit ((1))
HumanResources Employee rowguid False SQL_Latin1_General_CP1_CI_AS 16 0 0 uniqueidentifier uniqueidentifier (newid())
HumanResources Employee ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Sales SalesOrderHeader SalesOrderID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK
Sales SalesOrderHeader RevisionNumber False SQL_Latin1_General_CP1_CI_AS 1 3 0 tinyint tinyint ((0))
Sales SalesOrderHeader OrderDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
Sales SalesOrderHeader DueDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime
Sales SalesOrderHeader ShipDate True SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime
Sales SalesOrderHeader Status False SQL_Latin1_General_CP1_CI_AS 1 3 0 tinyint tinyint ((1)) CK_SalesOrderHeader_Status
Sales SalesOrderHeader OnlineOrderFlag False SQL_Latin1_General_CP1_CI_AS 1 1 0 Flag Flag:bit ((1))
Sales SalesOrderHeader SalesOrderNumber False SQL_Latin1_General_CP1_CI_AS 50 0 0 nvarchar nvarchar(25) (isnull(N'SO'+CONVERT([nvarchar](23),[SalesOrderID]),N'*** ERROR ***'))
Sales SalesOrderHeader PurchaseOrderNumber True SQL_Latin1_General_CP1_CI_AS 50 0 0 OrderNumber OrderNumber:nvarchar(50)
Sales SalesOrderHeader AccountNumber True SQL_Latin1_General_CP1_CI_AS 30 0 0 AccountNumber AccountNumber:nvarchar(30)
Sales SalesOrderHeader CustomerID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int FK
Sales SalesOrderHeader SalesPersonID True SQL_Latin1_General_CP1_CI_AS 4 10 0 int int FK
Sales SalesOrderHeader TerritoryID True SQL_Latin1_General_CP1_CI_AS 4 10 0 int int FK
Sales SalesOrderHeader BillToAddressID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int FK
Sales SalesOrderHeader ShipToAddressID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int FK
Sales SalesOrderHeader ShipMethodID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int FK
Sales SalesOrderHeader CreditCardID True SQL_Latin1_General_CP1_CI_AS 4 10 0 int int FK
Sales SalesOrderHeader CreditCardApprovalCode True SQL_Latin1_General_CP1_CI_AS 15 0 0 varchar varchar(15)
Sales SalesOrderHeader CurrencyRateID True SQL_Latin1_General_CP1_CI_AS 4 10 0 int int FK
Sales SalesOrderHeader SubTotal False SQL_Latin1_General_CP1_CI_AS 8 19 4 money money ((0.00)) CK_SalesOrderHeader_SubTotal
Sales SalesOrderHeader TaxAmt False SQL_Latin1_General_CP1_CI_AS 8 19 4 money money ((0.00)) CK_SalesOrderHeader_TaxAmt
Sales SalesOrderHeader Freight False SQL_Latin1_General_CP1_CI_AS 8 19 4 money money ((0.00)) CK_SalesOrderHeader_Freight
Sales SalesOrderHeader TotalDue False SQL_Latin1_General_CP1_CI_AS 8 19 4 money money (isnull(([SubTotal]+[TaxAmt])+[Freight],(0)))
Sales SalesOrderHeader Comment True SQL_Latin1_General_CP1_CI_AS 256 0 0 nvarchar nvarchar(128)
Sales SalesOrderHeader rowguid False SQL_Latin1_General_CP1_CI_AS 16 0 0 uniqueidentifier uniqueidentifier (newid())
Sales SalesOrderHeader ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())
HumanResources EmployeeDepartmentHistory BusinessEntityID False SQL_Latin1_General_CP1_CI_AS 4 10 0 int int PK FK
HumanResources EmployeeDepartmentHistory DepartmentID False SQL_Latin1_General_CP1_CI_AS 2 5 0 smallint smallint PK FK
HumanResources EmployeeDepartmentHistory ShiftID False SQL_Latin1_General_CP1_CI_AS 1 3 0 tinyint tinyint PK FK
HumanResources EmployeeDepartmentHistory StartDate False SQL_Latin1_General_CP1_CI_AS 3 10 0 date date PK
HumanResources EmployeeDepartmentHistory EndDate True SQL_Latin1_General_CP1_CI_AS 3 10 0 date date
HumanResources EmployeeDepartmentHistory ModifiedDate False SQL_Latin1_General_CP1_CI_AS 8 23 3 datetime datetime (getdate())

Stored Procedures

Schema Name SP Name SP Parameters Classification Created Date Last Modified Date Cached Time
(From Cache)		 Total Execution Count
(From Cache)		 Last Execution Time
(From Cache)		 Uses_Ansi_Nulls Uses_Quoted_Identifier Object Desc Object Process Mapping
dbo uspGetBillOfMaterials @StartProductID int, @CheckDate datetime SQL Stored Procedure 2017/10/27 02:33:15 PM 2017/10/27 02:33:15 PM True True
dbo uspGetEmployeeManagers @BusinessEntityID int SQL Stored Procedure 2017/10/27 02:33:15 PM 2017/10/27 02:33:15 PM True True
dbo uspGetManagerEmployees @BusinessEntityID int SQL Stored Procedure 2017/10/27 02:33:15 PM 2017/10/27 02:33:15 PM True True
dbo uspGetWhereUsedProductID @StartProductID int, @CheckDate datetime SQL Stored Procedure 2017/10/27 02:33:15 PM 2017/10/27 02:33:15 PM True True
HumanResources uspUpdateEmployeeHireInfo @BusinessEntityID int, @JobTitle nvarchar, @HireDate datetime, @RateChangeDate datetime, @Rate money, @PayFrequency tinyint SQL Stored Procedure 2017/10/27 02:33:15 PM 2017/10/27 02:33:15 PM True True
HumanResources uspUpdateEmployeeLogin @BusinessEntityID int, @OrganizationNode hierarchyid, @LoginID nvarchar, @JobTitle nvarchar, @HireDate datetime SQL Stored Procedure 2017/10/27 02:33:15 PM 2017/10/27 02:33:15 PM True True
dbo uspPrintError SQL Stored Procedure 2017/10/27 02:33:01 PM 2017/10/27 02:33:01 PM True True
HumanResources uspUpdateEmployeePersonalInfo @BusinessEntityID int, @NationalIDNumber nvarchar, @BirthDate datetime, @MaritalStatus nchar, @Gender nchar SQL Stored Procedure 2017/10/27 02:33:15 PM 2017/10/27 02:33:15 PM True True
dbo uspLogError @ErrorLogID int SQL Stored Procedure 2017/10/27 02:33:01 PM 2017/10/27 02:33:01 PM True True
dbo uspSearchCandidateResumes @searchString nvarchar, @useInflectional bit, @useThesaurus bit, @language int SQL Stored Procedure 2017/10/27 02:33:15 PM 2017/10/27 02:33:15 PM True True
dbo Usp_MyStoredProc @paramList int SQL Stored Procedure 2019/09/13 12:00:14 PM 2019/09/13 12:00:14 PM True True

Function

Schema Name Function Name Classification Function Parameters Function Return Type Created Date Last Modified Date Object Desc Object Process Mapping
dbo ufnGetAccountingStartDate SQL scalar function datetime 2017/10/27 02:33:15 PM 2017/10/27 02:33:15 PM
dbo ufnGetAccountingEndDate SQL scalar function datetime 2017/10/27 02:33:15 PM 2017/10/27 02:33:15 PM
dbo ufnGetContactInformation SQL inline table-valued function @PersonID int 2017/10/27 02:33:15 PM 2017/10/27 02:33:15 PM
dbo ufnGetProductDealerPrice SQL scalar function @ProductID int, @OrderDate datetime money 2017/10/27 02:33:15 PM 2017/10/27 02:33:15 PM
dbo ufnGetProductListPrice SQL scalar function @ProductID int, @OrderDate datetime money 2017/10/27 02:33:15 PM 2017/10/27 02:33:15 PM
dbo ufnGetProductStandardCost SQL scalar function @ProductID int, @OrderDate datetime money 2017/10/27 02:33:15 PM 2017/10/27 02:33:15 PM
dbo ufnGetStock SQL scalar function @ProductID int int 2017/10/27 02:33:15 PM 2017/10/27 02:33:15 PM
dbo ufnGetDocumentStatusText SQL scalar function @Status tinyint nvarchar 2017/10/27 02:33:15 PM 2017/10/27 02:33:15 PM
dbo ufnGetPurchaseOrderStatusText SQL scalar function @Status tinyint nvarchar 2017/10/27 02:33:15 PM 2017/10/27 02:33:15 PM
dbo ufnGetSalesOrderStatusText SQL scalar function @Status tinyint nvarchar 2017/10/27 02:33:15 PM 2017/10/27 02:33:15 PM
dbo ufnLeadingZeros SQL scalar function @Value int varchar 2017/10/27 02:33:01 PM 2017/10/27 02:33:01 PM

Misc

Name Type Classification Created Date Last Modified Date Object Desc Object Process Mapping
ddlDatabaseTriggerLog TR SQL_TRIGGER 2017/10/27 02:33:01 PM 2017/10/27 02:33:17 PM
dEmployee TR SQL_TRIGGER 2017/10/27 02:33:14 PM 2017/10/27 02:33:14 PM
dVendor TR SQL_TRIGGER 2017/10/27 02:33:14 PM 2017/10/27 02:33:14 PM
filestream_tombstone_2073058421 IT INTERNAL_TABLE 2017/08/22 07:38:03 PM 2017/08/22 07:38:04 PM
filetable_updates_2105058535 IT INTERNAL_TABLE 2017/08/22 07:38:04 PM 2017/08/22 07:38:04 PM
fulltext_avdl_1266103551 IT INTERNAL_TABLE 2017/10/27 02:33:13 PM 2017/10/27 02:33:13 PM
fulltext_avdl_1733581214 IT INTERNAL_TABLE 2017/10/27 02:33:13 PM 2017/10/27 02:33:13 PM
fulltext_avdl_98099390 IT INTERNAL_TABLE 2017/10/27 02:33:13 PM 2017/10/27 02:33:13 PM
fulltext_docidfilter_1266103551 IT INTERNAL_TABLE 2017/10/27 02:33:13 PM 2017/10/27 02:33:13 PM
fulltext_docidfilter_1733581214 IT INTERNAL_TABLE 2017/10/27 02:33:13 PM 2017/10/27 02:33:13 PM
fulltext_docidfilter_98099390 IT INTERNAL_TABLE 2017/10/27 02:33:13 PM 2017/10/27 02:33:13 PM
fulltext_index_docidmap_1733581214 IT INTERNAL_TABLE 2017/10/27 02:33:13 PM 2017/10/27 02:33:13 PM
fulltext_index_docidstatus_1266103551 IT INTERNAL_TABLE 2017/10/27 02:33:13 PM 2017/10/27 02:33:13 PM
fulltext_index_docidstatus_1733581214 IT INTERNAL_TABLE 2017/10/27 02:33:13 PM 2017/10/27 02:33:13 PM
fulltext_index_docidstatus_98099390 IT INTERNAL_TABLE 2017/10/27 02:33:13 PM 2017/10/27 02:33:13 PM
fulltext_indexeddocid_1266103551 IT INTERNAL_TABLE 2017/10/27 02:33:13 PM 2017/10/27 02:33:13 PM
fulltext_indexeddocid_1733581214 IT INTERNAL_TABLE 2017/10/27 02:33:13 PM 2017/10/27 02:33:13 PM
fulltext_indexeddocid_98099390 IT INTERNAL_TABLE 2017/10/27 02:33:13 PM 2017/10/27 02:33:13 PM
iduSalesOrderDetail TR SQL_TRIGGER 2017/10/27 02:33:14 PM 2017/10/27 02:33:14 PM
ifts_comp_fragment_1266103551_4 IT INTERNAL_TABLE 2017/10/27 02:33:19 PM 2017/10/27 02:33:19 PM
ifts_comp_fragment_1733581214_2 IT INTERNAL_TABLE 2017/10/27 02:33:19 PM 2017/10/27 02:33:19 PM
ifts_comp_fragment_98099390_5 IT INTERNAL_TABLE 2017/10/27 02:33:20 PM 2017/10/27 02:33:20 PM
iPurchaseOrderDetail TR SQL_TRIGGER 2017/10/27 02:33:14 PM 2017/10/27 02:33:14 PM
iuPerson TR SQL_TRIGGER 2017/10/27 02:33:14 PM 2017/10/27 02:33:14 PM
iWorkOrder TR SQL_TRIGGER 2017/10/27 02:33:14 PM 2017/10/27 02:33:14 PM
persistent_version_store IT INTERNAL_TABLE 2017/10/17 08:29:51 PM 2017/10/17 08:29:51 PM
persistent_version_store_long_term IT INTERNAL_TABLE 2017/10/17 08:29:51 PM 2017/10/17 08:29:51 PM
plan_persist_context_settings IT INTERNAL_TABLE 2017/08/22 07:38:04 PM 2017/08/22 07:38:04 PM
plan_persist_plan IT INTERNAL_TABLE 2017/08/22 07:38:04 PM 2017/08/22 07:38:04 PM
plan_persist_query IT INTERNAL_TABLE 2017/08/22 07:38:04 PM 2017/10/17 08:29:51 PM
plan_persist_query_hints IT INTERNAL_TABLE 2017/08/22 07:38:04 PM 2017/08/22 07:38:04 PM
plan_persist_query_template_parameterization IT INTERNAL_TABLE 2017/08/22 07:38:04 PM 2017/08/22 07:38:04 PM
plan_persist_query_text IT INTERNAL_TABLE 2017/08/22 07:38:04 PM 2017/08/22 07:38:04 PM
plan_persist_runtime_stats IT INTERNAL_TABLE 2017/08/22 07:38:04 PM 2017/08/22 07:38:04 PM
plan_persist_runtime_stats_interval IT INTERNAL_TABLE 2017/08/22 07:38:04 PM 2017/08/22 07:38:04 PM
plan_persist_wait_stats IT INTERNAL_TABLE 2017/08/22 07:38:04 PM 2017/08/22 07:38:04 PM
queue_messages_1977058079 IT INTERNAL_TABLE 2009/04/13 12:59:13 PM 2017/08/22 07:38:04 PM
queue_messages_2009058193 IT INTERNAL_TABLE 2009/04/13 12:59:13 PM 2017/08/22 07:38:04 PM
queue_messages_2041058307 IT INTERNAL_TABLE 2009/04/13 12:59:13 PM 2017/08/22 07:38:04 PM
sqlagent_job_history IT INTERNAL_TABLE 2017/08/22 07:38:04 PM 2017/08/22 07:38:04 PM
sqlagent_jobs IT INTERNAL_TABLE 2017/08/22 07:38:04 PM 2017/08/22 07:38:04 PM
sqlagent_jobsteps IT INTERNAL_TABLE 2017/08/22 07:38:04 PM 2017/08/22 07:38:04 PM
sqlagent_jobsteps_logs IT INTERNAL_TABLE 2017/08/22 07:38:04 PM 2017/08/22 07:38:04 PM
syscommittab IT INTERNAL_TABLE 2017/08/22 07:38:03 PM 2017/08/22 07:38:03 PM
trg_Employee TR SQL_TRIGGER 2019/09/13 04:38:57 PM 2019/09/13 04:38:57 PM
uPurchaseOrderDetail TR SQL_TRIGGER 2017/10/27 02:33:14 PM 2017/10/27 02:33:14 PM
uPurchaseOrderHeader TR SQL_TRIGGER 2017/10/27 02:33:14 PM 2017/10/27 02:33:14 PM
uSalesOrderHeader TR SQL_TRIGGER 2017/10/27 02:33:14 PM 2017/10/27 02:33:14 PM
uWorkOrder TR SQL_TRIGGER 2017/10/27 02:33:14 PM 2017/10/27 02:33:14 PM
wpr_bucket_table IT INTERNAL_TABLE 2017/10/27 02:33:01 PM 2017/10/27 02:33:01 PM
xml_index_nodes_1074102867_256000 IT INTERNAL_TABLE 2017/10/27 02:33:13 PM 2017/10/27 02:33:13 PM
xml_index_nodes_1074102867_256001 IT INTERNAL_TABLE 2017/10/27 02:33:13 PM 2017/10/27 02:33:13 PM
xml_index_nodes_1182627256_256000 IT INTERNAL_TABLE 2017/10/27 02:33:13 PM 2017/10/27 02:33:13 PM
xml_index_nodes_274100017_256000 IT INTERNAL_TABLE 2017/10/27 02:33:10 PM 2017/10/27 02:33:10 PM
xml_index_nodes_274100017_256001 IT INTERNAL_TABLE 2017/10/27 02:33:10 PM 2017/10/27 02:33:13 PM

ServiceBroker

Service Name Service Owner Queue Name Contract Name Contract Owner Sent By Message Type Name Message Type Owner Validation Desc Validation Schema

Documentation

Classification ObjectName Object Description Key Name Key Detail
Object HumanResources.EmployeePayHistory schema/table MS_Description Employee pay history.
Object HumanResources.EmployeePayHistory.BusinessEntityID schema/table/column MS_Description Employee identification number. Foreign key to Employee.BusinessEntityID.
Object HumanResources.EmployeePayHistory.RateChangeDate schema/table/column MS_Description Date the change in pay is effective
Object HumanResources.EmployeePayHistory.Rate schema/table/column MS_Description Salary hourly rate.
Object HumanResources.EmployeePayHistory.PayFrequency schema/table/column MS_Description 1 = Salary received monthly, 2 = Salary received biweekly
Object HumanResources.EmployeePayHistory.ModifiedDate schema/table/column MS_Description Date and time the record was last updated.
Object Sales.FK_SalesTerritoryHistory_SalesPerson_BusinessEntityID.FK_SalesTerritoryHistory_SalesPerson_BusinessEntityID schema/table/foreign_key_constraint MS_Description Foreign key constraint referencing SalesPerson.SalesPersonID.
Object Person.PK_PhoneNumberType_PhoneNumberTypeID.PK_PhoneNumberType_PhoneNumberTypeID schema/table/primary_key_constraint MS_Description Primary key (clustered) constraint
Object Sales.CK_SalesOrderHeader_Freight.CK_SalesOrderHeader_Freight schema/table/check_constraint MS_Description Check constraint [Freight] >= (0.00)
Object HumanResources.DF_EmployeePayHistory_ModifiedDate.DF_EmployeePayHistory_ModifiedDate schema/table/default_constraint MS_Description Default constraint value of GETDATE()
Object Sales.FK_SalesTerritoryHistory_SalesTerritory_TerritoryID.FK_SalesTerritoryHistory_SalesTerritory_TerritoryID schema/table/foreign_key_constraint MS_Description Foreign key constraint referencing SalesTerritory.TerritoryID.
Object Production.PK_Product_ProductID.PK_Product_ProductID schema/table/primary_key_constraint MS_Description Primary key (clustered) constraint
Object Sales.SalesOrderHeaderSalesReason schema/table MS_Description Cross-reference table mapping sales orders to sales reason codes.
Object Sales.SalesOrderHeaderSalesReason.SalesOrderID schema/table/column MS_Description Primary key. Foreign key to SalesOrderHeader.SalesOrderID.
Object Sales.SalesOrderHeaderSalesReason.SalesReasonID schema/table/column MS_Description Primary key. Foreign key to SalesReason.SalesReasonID.
Object Sales.SalesOrderHeaderSalesReason.ModifiedDate schema/table/column MS_Description Date and time the record was last updated.
Object HumanResources.CK_EmployeePayHistory_PayFrequency.CK_EmployeePayHistory_PayFrequency schema/table/check_constraint MS_Description Check constraint [PayFrequency]=(3) OR [PayFrequency]=(2) OR [PayFrequency]=(1)
Object Sales.FK_ShoppingCartItem_Product_ProductID.FK_ShoppingCartItem_Product_ProductID schema/table/foreign_key_constraint MS_Description Foreign key constraint referencing Product.ProductID.
Object Production.PK_ProductCategory_ProductCategoryID.PK_ProductCategory_ProductCategoryID schema/table/primary_key_constraint MS_Description Primary key (clustered) constraint
Object Sales.DF_SalesOrderHeaderSalesReason_ModifiedDate.DF_SalesOrderHeaderSalesReason_ModifiedDate schema/table/default_constraint MS_Description Default constraint value of GETDATE()
Object HumanResources.CK_EmployeePayHistory_Rate.CK_EmployeePayHistory_Rate schema/table/check_constraint MS_Description Check constraint [Rate] >= (6.50) AND [Rate] <= (200.00)
Object Sales.FK_SpecialOfferProduct_Product_ProductID.FK_SpecialOfferProduct_Product_ProductID schema/table/foreign_key_constraint MS_Description Foreign key constraint referencing Product.ProductID.
Object Production.PK_ProductCostHistory_ProductID_StartDate.PK_ProductCostHistory_ProductID_StartDate schema/table/primary_key_constraint MS_Description Primary key (clustered) constraint
Object Sales.SalesPerson schema/table MS_Description Sales representative current information.
Object Sales.SalesPerson.BusinessEntityID schema/table/column MS_Description Primary key for SalesPerson records. Foreign key to Employee.BusinessEntityID
Object Sales.SalesPerson.TerritoryID schema/table/column MS_Description Territory currently assigned to. Foreign key to SalesTerritory.SalesTerritoryID.
Object Sales.SalesPerson.SalesQuota schema/table/column MS_Description Projected yearly sales.
Object Sales.SalesPerson.Bonus schema/table/column MS_Description Bonus due if quota is met.
Object Sales.SalesPerson.CommissionPct schema/table/column MS_Description Commision percent received per sale.
Object Sales.SalesPerson.SalesYTD schema/table/column MS_Description Sales total year to date.
Object Sales.SalesPerson.SalesLastYear schema/table/column MS_Description Sales total of previous year.
Object Sales.SalesPerson.rowguid schema/table/column MS_Description ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
Object Sales.SalesPerson.ModifiedDate schema/table/column MS_Description Date and time the record was last updated.
Object Production.Illustration schema/table MS_Description Bicycle assembly diagrams.
Object Production.Illustration.IllustrationID schema/table/column MS_Description Primary key for Illustration records.
Object Production.Illustration.Diagram schema/table/column MS_Description Illustrations used in manufacturing instructions. Stored as XML.
Object Production.Illustration.ModifiedDate schema/table/column MS_Description Date and time the record was last updated.
Object Sales.FK_SpecialOfferProduct_SpecialOffer_SpecialOfferID.FK_SpecialOfferProduct_SpecialOffer_SpecialOfferID schema/table/foreign_key_constraint MS_Description Foreign key constraint referencing SpecialOffer.SpecialOfferID.
Object Production.PK_ProductDescription_ProductDescriptionID.PK_ProductDescription_ProductDescriptionID schema/table/primary_key_constraint MS_Description Primary key (clustered) constraint
Object Sales.DF_SalesPerson_Bonus.DF_SalesPerson_Bonus schema/table/default_constraint MS_Description Default constraint value of 0.0
Object Production.DF_Illustration_ModifiedDate.DF_Illustration_ModifiedDate schema/table/default_constraint MS_Description Default constraint value of GETDATE()
Object Person.FK_StateProvince_CountryRegion_CountryRegionCode.FK_StateProvince_CountryRegion_CountryRegionCode schema/table/foreign_key_constraint MS_Description Foreign key constraint referencing CountryRegion.CountryRegionCode.
Object Production.PK_ProductDocument_ProductID_DocumentNode.PK_ProductDocument_ProductID_DocumentNode schema/table/primary_key_constraint MS_Description Primary key (clustered) constraint
Object Sales.DF_SalesPerson_CommissionPct.DF_SalesPerson_CommissionPct schema/table/default_constraint MS_Description Default constraint value of 0.0
Object HumanResources.JobCandidate schema/table MS_Description Résumés submitted to Human Resources by job applicants.
Object HumanResources.JobCandidate.JobCandidateID schema/table/column MS_Description Primary key for JobCandidate records.
Object HumanResources.JobCandidate.BusinessEntityID schema/table/column MS_Description Employee identification number if applicant was hired. Foreign key to Employee.BusinessEntityID.
Object HumanResources.JobCandidate.Resume schema/table/column MS_Description Résumé in XML format.
Object HumanResources.JobCandidate.ModifiedDate schema/table/column MS_Description Date and time the record was last updated.
Object Person.FK_StateProvince_SalesTerritory_TerritoryID.FK_StateProvince_SalesTerritory_TerritoryID schema/table/foreign_key_constraint MS_Description Foreign key constraint referencing SalesTerritory.TerritoryID.
Object Production.PK_ProductInventory_ProductID_LocationID.PK_ProductInventory_ProductID_LocationID schema/table/primary_key_constraint MS_Description Primary key (clustered) constraint
Object Sales.DF_SalesPerson_SalesYTD.DF_SalesPerson_SalesYTD schema/table/default_constraint MS_Description Default constraint value of 0.0
Object HumanResources.DF_JobCandidate_ModifiedDate.DF_JobCandidate_ModifiedDate schema/table/default_constraint MS_Description Default constraint value of GETDATE()
Object Sales.FK_Store_BusinessEntity_BusinessEntityID.FK_Store_BusinessEntity_BusinessEntityID schema/table/foreign_key_constraint MS_Description Foreign key constraint referencing BusinessEntity.BusinessEntityID
Object Production.PK_ProductListPriceHistory_ProductID_StartDate.PK_ProductListPriceHistory_ProductID_StartDate schema/table/primary_key_constraint MS_Description Primary key (clustered) constraint
Object Sales.DF_SalesPerson_SalesLastYear.DF_SalesPerson_SalesLastYear schema/table/default_constraint MS_Description Default constraint value of 0.0
Object Production.Location schema/table MS_Description Product inventory and manufacturing locations.
Object Production.Location.LocationID schema/table/column MS_Description Primary key for Location records.
Object Production.Location.Name schema/table/column MS_Description Location description.
Object Production.Location.CostRate schema/table/column MS_Description Standard hourly cost of the manufacturing location.
Object Production.Location.Availability schema/table/column MS_Description Work capacity (in hours) of the manufacturing location.
Object Production.Location.ModifiedDate schema/table/column MS_Description Date and time the record was last updated.
Object Sales.FK_Store_SalesPerson_SalesPersonID.FK_Store_SalesPerson_SalesPersonID schema/table/foreign_key_constraint MS_Description Foreign key constraint referencing SalesPerson.SalesPersonID
Object Production.PK_ProductModel_ProductModelID.PK_ProductModel_ProductModelID schema/table/primary_key_constraint MS_Description Primary key (clustered) constraint
Object Sales.DF_SalesPerson_rowguid.DF_SalesPerson_rowguid schema/table/default_constraint MS_Description Default constraint value of NEWID()
Object Production.DF_Location_CostRate.DF_Location_CostRate schema/table/default_constraint MS_Description Default constraint value of 0.0
Object Production.FK_TransactionHistory_Product_ProductID.FK_TransactionHistory_Product_ProductID schema/table/foreign_key_constraint MS_Description Foreign key constraint referencing Product.ProductID.
Object Production.PK_ProductModelIllustration_ProductModelID_IllustrationID.PK_ProductModelIllustration_ProductModelID_IllustrationID schema/table/primary_key_constraint MS_Description Primary key (clustered) constraint
Object Sales.DF_SalesPerson_ModifiedDate.DF_SalesPerson_ModifiedDate schema/table/default_constraint MS_Description Default constraint value of GETDATE()
Object Production.DF_Location_Availability.DF_Location_Availability schema/table/default_constraint MS_Description Default constraint value of 0.00
Object Purchasing.FK_Vendor_BusinessEntity_BusinessEntityID.FK_Vendor_BusinessEntity_BusinessEntityID schema/table/foreign_key_constraint MS_Description Foreign key constraint referencing BusinessEntity.BusinessEntityID
Object Production.PK_ProductModelProductDescriptionCulture_ProductModelID_ProductDescriptionID_CultureID.PK_ProductModelProductDescriptionCulture_ProductModelID_ProductDescriptionID_CultureID schema/table/primary_key_constraint MS_Description Primary key (clustered) constraint
Object Sales.CK_SalesPerson_SalesQuota.CK_SalesPerson_SalesQuota schema/table/check_constraint MS_Description Check constraint [SalesQuota] > (0.00)
Object Production.DF_Location_ModifiedDate.DF_Location_ModifiedDate schema/table/default_constraint MS_Description Default constraint value of GETDATE()
Object Production.FK_WorkOrder_Product_ProductID.FK_WorkOrder_Product_ProductID schema/table/foreign_key_constraint MS_Description Foreign key constraint referencing Product.ProductID.
Object Production.PK_ProductPhoto_ProductPhotoID.PK_ProductPhoto_ProductPhotoID schema/table/primary_key_constraint MS_Description Primary key (clustered) constraint
Object Sales.CK_SalesPerson_Bonus.CK_SalesPerson_Bonus schema/table/check_constraint MS_Description Check constraint [Bonus] >= (0.00)
Object Production.CK_Location_CostRate.CK_Location_CostRate schema/table/check_constraint MS_Description Check constraint [CostRate] >= (0.00)
Object Production.FK_WorkOrder_ScrapReason_ScrapReasonID.FK_WorkOrder_ScrapReason_ScrapReasonID schema/table/foreign_key_constraint MS_Description Foreign key constraint referencing ScrapReason.ScrapReasonID.
Object Production.PK_ProductProductPhoto_ProductID_ProductPhotoID.PK_ProductProductPhoto_ProductID_ProductPhotoID schema/table/primary_key_constraint MS_Description Primary key (clustered) constraint
Object Sales.CK_SalesPerson_CommissionPct.CK_SalesPerson_CommissionPct schema/table/check_constraint MS_Description Check constraint [CommissionPct] >= (0.00)
Object Production.CK_Location_Availability.CK_Location_Availability schema/table/check_constraint MS_Description Check constraint [Availability] >= (0.00)
Object Production.FK_WorkOrderRouting_Location_LocationID.FK_WorkOrderRouting_Location_LocationID schema/table/foreign_key_constraint MS_Description Foreign key constraint referencing Location.LocationID.
Object Production.PK_ProductReview_ProductReviewID.PK_ProductReview_ProductReviewID schema/table/primary_key_constraint MS_Description Primary key (clustered) constraint
Object Sales.CK_SalesPerson_SalesYTD.CK_SalesPerson_SalesYTD schema/table/check_constraint MS_Description Check constraint [SalesYTD] >= (0.00)
Object Person.Password schema/table MS_Description One way hashed authentication information
Object Person.Password.PasswordHash schema/table/column MS_Description Password for the e-mail account.
Object Person.Password.PasswordSalt schema/table/column MS_Description Random value concatenated with the password string before the password is hashed.
Object Person.Password.rowguid schema/table/column MS_Description ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
Object Person.Password.ModifiedDate schema/table/column MS_Description Date and time the record was last updated.
Object Production.FK_WorkOrderRouting_WorkOrder_WorkOrderID.FK_WorkOrderRouting_WorkOrder_WorkOrderID schema/table/foreign_key_constraint MS_Description Foreign key constraint referencing WorkOrder.WorkOrderID.
Object Production.PK_ProductSubcategory_ProductSubcategoryID.PK_ProductSubcategory_ProductSubcategoryID schema/table/primary_key_constraint MS_Description Primary key (clustered) constraint
Object Sales.CK_SalesPerson_SalesLastYear.CK_SalesPerson_SalesLastYear schema/table/check_constraint MS_Description Check constraint [SalesLastYear] >= (0.00)
Object Person.DF_Password_rowguid.DF_Password_rowguid schema/table/default_constraint MS_Description Default constraint value of NEWID()
Object HumanResources.dEmployee.dEmployee schema/table/sql_trigger MS_Description INSTEAD OF DELETE trigger which keeps Employees from being deleted.
Object Purchasing.PK_ProductVendor_ProductID_BusinessEntityID.PK_ProductVendor_ProductID_BusinessEntityID schema/table/primary_key_constraint MS_Description Primary key (clustered) constraint
Object Sales.SalesPersonQuotaHistory schema/table MS_Description Sales performance tracking.
Object Sales.SalesPersonQuotaHistory.BusinessEntityID schema/table/column MS_Description Sales person identification number. Foreign key to SalesPerson.BusinessEntityID.
Object Sales.SalesPersonQuotaHistory.QuotaDate schema/table/column MS_Description Sales quota date.
Object Sales.SalesPersonQuotaHistory.SalesQuota schema/table/column MS_Description Sales quota amount.
Object Sales.SalesPersonQuotaHistory.rowguid schema/table/column MS_Description ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
Object Sales.SalesPersonQuotaHistory.ModifiedDate schema/table/column MS_Description Date and time the record was last updated.
Object Person.DF_Password_ModifiedDate.DF_Password_ModifiedDate schema/table/default_constraint MS_Description Default constraint value of GETDATE()
Object Person.iuPerson.iuPerson schema/table/sql_trigger MS_Description AFTER INSERT, UPDATE trigger inserting Individual only if the Customer does not exist in the Store table and setting the ModifiedDate column in the Person table to the current date.
Object Purchasing.PK_PurchaseOrderDetail_PurchaseOrderID_PurchaseOrderDetailID.PK_PurchaseOrderDetail_PurchaseOrderID_PurchaseOrderDetailID schema/table/primary_key_constraint MS_Description Primary key (clustered) constraint
Object Sales.DF_SalesPersonQuotaHistory_rowguid.DF_SalesPersonQuotaHistory_rowguid schema/table/default_constraint MS_Description Default constraint value of NEWID()
Object Person.Person schema/table MS_Description Human beings involved with AdventureWorks: employees, customer contacts, and vendor contacts.
Object Person.Person.BusinessEntityID schema/table/column MS_Description Primary key for Person records.
Object Person.Person.PersonType schema/table/column MS_Description Primary type of person: SC = Store Contact, IN = Individual (retail) customer, SP = Sales person, EM = Employee (non-sales), VC = Vendor contact, GC = General contact
Object Person.Person.NameStyle schema/table/column MS_Description 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.
Object Person.Person.Title schema/table/column MS_Description A courtesy title. For example, Mr. or Ms.
Object Person.Person.FirstName schema/table/column MS_Description First name of the person.
Object Person.Person.MiddleName schema/table/column MS_Description Middle name or middle initial of the person.
Object Person.Person.LastName schema/table/column MS_Description Last name of the person.
Object Person.Person.Suffix schema/table/column MS_Description Surname suffix. For example, Sr. or Jr.
Object Person.Person.EmailPromotion schema/table/column MS_Description 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.
Object Person.Person.AdditionalContactInfo schema/table/column MS_Description Additional contact information about the person stored in xml format.
Object Person.Person.Demographics schema/table/column MS_Description Personal information such as hobbies, and income collected from online shoppers. Used for sales analysis.
Object Person.Person.rowguid schema/table/column MS_Description ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
Object Person.Person.ModifiedDate schema/table/column MS_Description Date and time the record was last updated.
Object Purchasing.iPurchaseOrderDetail.iPurchaseOrderDetail schema/table/sql_trigger MS_Description AFTER INSERT trigger that inserts a row in the TransactionHistory table and updates the PurchaseOrderHeader.SubTotal column.
Object Purchasing.PK_PurchaseOrderHeader_PurchaseOrderID.PK_PurchaseOrderHeader_PurchaseOrderID schema/table/primary_key_constraint MS_Description Primary key (clustered) constraint
Object Sales.DF_SalesPersonQuotaHistory_ModifiedDate.DF_SalesPersonQuotaHistory_ModifiedDate schema/table/default_constraint MS_Description Default constraint value of GETDATE()
Object Person.DF_Person_NameStyle.DF_Person_NameStyle schema/table/default_constraint MS_Description Default constraint value of 0
Object Purchasing.uPurchaseOrderDetail.uPurchaseOrderDetail schema/table/sql_trigger MS_Description AFTER UPDATE trigger that inserts a row in the TransactionHistory table, updates ModifiedDate in PurchaseOrderDetail and updates the PurchaseOrderHeader.SubTotal column.
Object Sales.PK_SalesOrderDetail_SalesOrderID_SalesOrderDetailID.PK_SalesOrderDetail_SalesOrderID_SalesOrderDetailID schema/table/primary_key_constraint MS_Description Primary key (clustered) constraint
Object Sales.CK_SalesPersonQuotaHistory_SalesQuota.CK_SalesPersonQuotaHistory_SalesQuota schema/table/check_constraint MS_Description Check constraint [SalesQuota] > (0.00)
Object Person.DF_Person_EmailPromotion.DF_Person_EmailPromotion schema/table/default_constraint MS_Description Default constraint value of 0
Object Purchasing.uPurchaseOrderHeader.uPurchaseOrderHeader schema/table/sql_trigger MS_Description AFTER UPDATE trigger that updates the RevisionNumber and ModifiedDate columns in the PurchaseOrderHeader table.
Object Sales.PK_SalesOrderHeader_SalesOrderID.PK_SalesOrderHeader_SalesOrderID schema/table/primary_key_constraint MS_Description Primary key (clustered) constraint
Object Sales.SalesReason schema/table MS_Description Lookup table of customer purchase reasons.
Object Sales.SalesReason.SalesReasonID schema/table/column MS_Description Primary key for SalesReason records.
Object Sales.SalesReason.Name schema/table/column MS_Description Sales reason description.
Object Sales.SalesReason.ReasonType schema/table/column MS_Description Category the sales reason belongs to.
Object Sales.SalesReason.ModifiedDate schema/table/column MS_Description Date and time the record was last updated.
Object Person.DF_Person_rowguid.DF_Person_rowguid schema/table/default_constraint MS_Description Default constraint value of NEWID()
Object Sales.iduSalesOrderDetail.iduSalesOrderDetail schema/table/sql_trigger MS_Description AFTER INSERT, DELETE, UPDATE trigger that inserts a row in the TransactionHistory table, updates ModifiedDate in SalesOrderDetail and updates the SalesOrderHeader.SubTotal column.
Object Sales.PK_SalesOrderHeaderSalesReason_SalesOrderID_SalesReasonID.PK_SalesOrderHeaderSalesReason_SalesOrderID_SalesReasonID schema/table/primary_key_constraint MS_Description Primary key (clustered) constraint
Object Sales.DF_SalesReason_ModifiedDate.DF_SalesReason_ModifiedDate schema/table/default_constraint MS_Description Default constraint value of GETDATE()
Object Person.DF_Person_ModifiedDate.DF_Person_ModifiedDate schema/table/default_constraint MS_Description Default constraint value of GETDATE()
Object Sales.uSalesOrderHeader.uSalesOrderHeader schema/table/sql_trigger MS_Description AFTER UPDATE trigger that updates the RevisionNumber and ModifiedDate columns in the SalesOrderHeader table.Updates the SalesYTD column in the SalesPerson and SalesTerritory tables.
Object Sales.PK_SalesPerson_BusinessEntityID.PK_SalesPerson_BusinessEntityID schema/table/primary_key_constraint MS_Description Primary key (clustered) constraint
Object Sales.SalesTaxRate schema/table MS_Description Tax rate lookup table.
Object Sales.SalesTaxRate.SalesTaxRateID schema/table/column MS_Description Primary key for SalesTaxRate records.
Object Sales.SalesTaxRate.StateProvinceID schema/table/column MS_Description State, province, or country/region the sales tax applies to.
Object Sales.SalesTaxRate.TaxType schema/table/column MS_Description 1 = Tax applied to retail transactions, 2 = Tax applied to wholesale transactions, 3 = Tax applied to all sales (retail and wholesale) transactions.
Object Sales.SalesTaxRate.TaxRate schema/table/column MS_Description Tax rate amount.
Object Sales.SalesTaxRate.Name schema/table/column MS_Description Tax rate description.
Object Sales.SalesTaxRate.rowguid schema/table/column MS_Description ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
Object Sales.SalesTaxRate.ModifiedDate schema/table/column MS_Description Date and time the record was last updated.
Object Person.CK_Person_EmailPromotion.CK_Person_EmailPromotion schema/table/check_constraint MS_Description Check constraint [EmailPromotion] >= (0) AND [EmailPromotion] <= (2)
Object Purchasing.dVendor.dVendor schema/table/sql_trigger MS_Description INSTEAD OF DELETE trigger which keeps Vendors from being deleted.
Object Sales.PK_SalesPersonQuotaHistory_BusinessEntityID_QuotaDate.PK_SalesPersonQuotaHistory_BusinessEntityID_QuotaDate schema/table/primary_key_constraint MS_Description Primary key (clustered) constraint
Object Sales.DF_SalesTaxRate_TaxRate.DF_SalesTaxRate_TaxRate schema/table/default_constraint MS_Description Default constraint value of 0.0
Object Person.CK_Person_PersonType.CK_Person_PersonType schema/table/check_constraint MS_Description Check constraint [PersonType] is one of SC, VC, IN, EM or SP.
Object Production.iWorkOrder.iWorkOrder schema/table/sql_trigger MS_Description AFTER INSERT trigger that inserts a row in the TransactionHistory table.
Object Sales.PK_SalesReason_SalesReasonID.PK_SalesReason_SalesReasonID schema/table/primary_key_constraint MS_Description Primary key (clustered) constraint
Object Sales.DF_SalesTaxRate_rowguid.DF_SalesTaxRate_rowguid schema/table/default_constraint MS_Description Default constraint value of NEWID()
Object Sales.PersonCreditCard schema/table MS_Description Cross-reference table mapping people to their credit card information in the CreditCard table.
Object Sales.PersonCreditCard.BusinessEntityID schema/table/column MS_Description Business entity identification number. Foreign key to Person.BusinessEntityID.
Object Sales.PersonCreditCard.CreditCardID schema/table/column MS_Description Credit card identification number. Foreign key to CreditCard.CreditCardID.
Object Sales.PersonCreditCard.ModifiedDate schema/table/column MS_Description Date and time the record was last updated.
Object Production.uWorkOrder.uWorkOrder schema/table/sql_trigger MS_Description AFTER UPDATE trigger that inserts a row in the TransactionHistory table, updates ModifiedDate in the WorkOrder table.
Object Sales.PK_SalesTaxRate_SalesTaxRateID.PK_SalesTaxRate_SalesTaxRateID schema/table/primary_key_constraint MS_Description Primary key (clustered) constraint
Object Sales.DF_SalesTaxRate_ModifiedDate.DF_SalesTaxRate_ModifiedDate schema/table/default_constraint MS_Description Default constraint value of GETDATE()
Object Sales.DF_PersonCreditCard_ModifiedDate.DF_PersonCreditCard_ModifiedDate schema/table/default_constraint MS_Description Default constraint value of GETDATE()
Interface Person.vAdditionalContactInfo schema/view MS_Description Displays the contact name and content from each element in the xml column AdditionalContactInfo for that person.
Object Sales.PK_SalesTerritory_TerritoryID.PK_SalesTerritory_TerritoryID schema/table/primary_key_constraint MS_Description Primary key (clustered) constraint
Object Sales.CK_SalesTaxRate_TaxType.CK_SalesTaxRate_TaxType schema/table/check_constraint MS_Description Check constraint [TaxType] BETWEEN (1) AND (3)
Object Person.PersonPhone schema/table MS_Description Telephone number and type of a person.
Object Person.PersonPhone.BusinessEntityID schema/table/column MS_Description Business entity identification number. Foreign key to Person.BusinessEntityID.
Object Person.PersonPhone.PhoneNumber schema/table/column MS_Description Telephone number identification number.
Object Person.PersonPhone.PhoneNumberTypeID schema/table/column MS_Description Kind of phone number. Foreign key to PhoneNumberType.PhoneNumberTypeID.
Object Person.PersonPhone.ModifiedDate schema/table/column MS_Description Date and time the record was last updated.
Interface HumanResources.vEmployee schema/view MS_Description Employee names and addresses.
Object Sales.PK_SalesTerritoryHistory_BusinessEntityID_StartDate_TerritoryID.PK_SalesTerritoryHistory_BusinessEntityID_StartDate_TerritoryID schema/table/primary_key_constraint MS_Description Primary key (clustered) constraint
Object Sales.SalesTerritory schema/table MS_Description Sales territory lookup table.
Object Sales.SalesTerritory.TerritoryID schema/table/column MS_Description Primary key for SalesTerritory records.
Object Sales.SalesTerritory.Name schema/table/column MS_Description Sales territory description
Object Sales.SalesTerritory.CountryRegionCode schema/table/column MS_Description ISO standard country or region code. Foreign key to CountryRegion.CountryRegionCode.
Object Sales.SalesTerritory.Group schema/table/column MS_Description Geographic area to which the sales territory belong.
Object Sales.SalesTerritory.SalesYTD schema/table/column MS_Description Sales in the territory year to date.
Object Sales.SalesTerritory.SalesLastYear schema/table/column MS_Description Sales in the territory the previous year.
Object Sales.SalesTerritory.CostYTD schema/table/column MS_Description Business costs in the territory year to date.
Object Sales.SalesTerritory.CostLastYear schema/table/column MS_Description Business costs in the territory the previous year.
Object Sales.SalesTerritory.rowguid schema/table/column MS_Description ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
Object Sales.SalesTerritory.ModifiedDate schema/table/column MS_Description Date and time the record was last updated.
Object Person.DF_PersonPhone_ModifiedDate.DF_PersonPhone_ModifiedDate schema/table/default_constraint MS_Description Default constraint value of GETDATE()
Interface HumanResources.vEmployeeDepartment schema/view MS_Description Returns employee name, title, and current department.
Object Production.PK_ScrapReason_ScrapReasonID.PK_ScrapReason_ScrapReasonID schema/table/primary_key_constraint MS_Description Primary key (clustered) constraint
Object Sales.DF_SalesTerritory_SalesYTD.DF_SalesTerritory_SalesYTD schema/table/default_constraint MS_Description Default constraint value of 0.0
Object Person.PhoneNumberType schema/table MS_Description Type of phone number of a person.
Object Person.PhoneNumberType.PhoneNumberTypeID schema/table/column MS_Description Primary key for telephone number type records.
Object Person.PhoneNumberType.Name schema/table/column MS_Description Name of the telephone number type
Object Person.PhoneNumberType.ModifiedDate schema/table/column MS_Description Date and time the record was last updated.
Interface HumanResources.vEmployeeDepartmentHistory schema/view MS_Description Returns employee name and current and previous departments.
Object HumanResources.PK_Shift_ShiftID.PK_Shift_ShiftID schema/table/primary_key_constraint MS_Description Primary key (clustered) constraint
Object Sales.DF_SalesTerritory_SalesLastYear.DF_SalesTerritory_SalesLastYear schema/table/default_constraint MS_Description Default constraint value of 0.0
Object Person.DF_PhoneNumberType_ModifiedDate.DF_PhoneNumberType_ModifiedDate schema/table/default_constraint MS_Description Default constraint value of GETDATE()
Interface Sales.vIndividualCustomer schema/view MS_Description Individual customers (names and addresses) that purchase Adventure Works Cycles products online.
Object Purchasing.PK_ShipMethod_ShipMethodID.PK_ShipMethod_ShipMethodID schema/table/primary_key_constraint MS_Description Primary key (clustered) constraint
Object Sales.DF_SalesTerritory_CostYTD.DF_SalesTerritory_CostYTD schema/table/default_constraint MS_Description Default constraint value of 0.0
Object Production.Product schema/table MS_Description Products sold or used in the manfacturing of sold products.
Object Production.Product.ProductID schema/table/column MS_Description Primary key for Product records.
Object Production.Product.Name schema/table/column MS_Description Name of the product.
Object Production.Product.ProductNumber schema/table/column MS_Description Unique product identification number.
Object Production.Product.MakeFlag schema/table/column MS_Description 0 = Product is purchased, 1 = Product is manufactured in-house.
Object Production.Product.FinishedGoodsFlag schema/table/column MS_Description 0 = Product is not a salable item. 1 = Product is salable.
Object Production.Product.Color schema/table/column MS_Description Product color.
Object Production.Product.SafetyStockLevel schema/table/column MS_Description Minimum inventory quantity.
Object Production.Product.ReorderPoint schema/table/column MS_Description Inventory level that triggers a purchase order or work order.
Object Production.Product.StandardCost schema/table/column MS_Description Standard cost of the product.
Object Production.Product.ListPrice schema/table/column MS_Description Selling price.
Object Production.Product.Size schema/table/column MS_Description Product size.
Object Production.Product.SizeUnitMeasureCode schema/table/column MS_Description Unit of measure for Size column.
Object Production.Product.WeightUnitMeasureCode schema/table/column MS_Description Unit of measure for Weight column.
Object Production.Product.Weight schema/table/column MS_Description Product weight.
Object Production.Product.DaysToManufacture schema/table/column MS_Description Number of days required to manufacture the product.
Object Production.Product.ProductLine schema/table/column MS_Description R = Road, M = Mountain, T = Touring, S = Standard
Object Production.Product.Class schema/table/column MS_Description H = High, M = Medium, L = Low
Object Production.Product.Style schema/table/column MS_Description W = Womens, M = Mens, U = Universal
Object Production.Product.ProductSubcategoryID schema/table/column MS_Description Product is a member of this product subcategory. Foreign key to ProductSubCategory.ProductSubCategoryID.
Object Production.Product.ProductModelID schema/table/column MS_Description Product is a member of this product model. Foreign key to ProductModel.ProductModelID.
Object Production.Product.SellStartDate schema/table/column MS_Description Date the product was available for sale.
Object Production.Product.SellEndDate schema/table/column MS_Description Date the product was no longer available for sale.
Object Production.Product.DiscontinuedDate schema/table/column MS_Description Date the product was discontinued.
Object Production.Product.rowguid schema/table/column MS_Description ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
Object Production.Product.ModifiedDate schema/table/column MS_Description Date and time the record was last updated.
Interface Sales.vPersonDemographics schema/view MS_Description Displays the content from each element in the xml column Demographics for each customer in the Person.Person table.
Object Sales.PK_ShoppingCartItem_ShoppingCartItemID.PK_ShoppingCartItem_ShoppingCartItemID schema/table/primary_key_constraint MS_Description Primary key (clustered) constraint
Object Sales.DF_SalesTerritory_CostLastYear.DF_SalesTerritory_CostLastYear schema/table/default_constraint MS_Description Default constraint value of 0.0
Object Production.DF_Product_MakeFlag.DF_Product_MakeFlag schema/table/default_constraint MS_Description Default constraint value of 1
Interface HumanResources.vJobCandidate schema/view MS_Description Job candidate names and resumes.
Object Sales.PK_SpecialOffer_SpecialOfferID.PK_SpecialOffer_SpecialOfferID schema/table/primary_key_constraint MS_Description Primary key (clustered) constraint
Object Sales.DF_SalesTerritory_rowguid.DF_SalesTerritory_rowguid schema/table/default_constraint MS_Description Default constraint value of NEWID()
Object Production.DF_Product_FinishedGoodsFlag.DF_Product_FinishedGoodsFlag schema/table/default_constraint MS_Description Default constraint value of 1
Interface HumanResources.vJobCandidateEmployment schema/view MS_Description Displays the content from each employement history related element in the xml column Resume in the HumanResources.JobCandidate table. The content has been localized into French, Simplified Chinese and Thai. Some data may not display correctly unless supplemental language support is installed.
Object Sales.PK_SpecialOfferProduct_SpecialOfferID_ProductID.PK_SpecialOfferProduct_SpecialOfferID_ProductID schema/table/primary_key_constraint MS_Description Primary key (clustered) constraint
Object Sales.DF_SalesTerritory_ModifiedDate.DF_SalesTerritory_ModifiedDate schema/table/default_constraint MS_Description Default constraint value of GETDATE()
Object Production.DF_Product_rowguid.DF_Product_rowguid schema/table/default_constraint MS_Description Default constraint value of NEWID()
Interface HumanResources.vJobCandidateEducation schema/view MS_Description Displays the content from each education related element in the xml column Resume in the HumanResources.JobCandidate table. The content has been localized into French, Simplified Chinese and Thai. Some data may not display correctly unless supplemental language support is installed.
Object Person.PK_StateProvince_StateProvinceID.PK_StateProvince_StateProvinceID schema/table/primary_key_constraint MS_Description Primary key (clustered) constraint
Object Sales.CK_SalesTerritory_SalesYTD.CK_SalesTerritory_SalesYTD schema/table/check_constraint MS_Description Check constraint [SalesYTD] >= (0.00)
Object Production.DF_Product_ModifiedDate.DF_Product_ModifiedDate schema/table/default_constraint MS_Description Default constraint value of GETDATE()
Interface Production.vProductAndDescription schema/view MS_Description Product names and descriptions. Product descriptions are provided in multiple languages.
Object Sales.PK_Store_BusinessEntityID.PK_Store_BusinessEntityID schema/table/primary_key_constraint MS_Description Primary key (clustered) constraint
Object Sales.CK_SalesTerritory_SalesLastYear.CK_SalesTerritory_SalesLastYear schema/table/check_constraint MS_Description Check constraint [SalesLastYear] >= (0.00)
Object Production.CK_Product_SafetyStockLevel.CK_Product_SafetyStockLevel schema/table/check_constraint MS_Description Check constraint [SafetyStockLevel] > (0)
Interface Production.vProductModelCatalogDescription schema/view MS_Description Displays the content from each element in the xml column CatalogDescription for each product in the Production.ProductModel table that has catalog data.
Object Production.PK_TransactionHistory_TransactionID.PK_TransactionHistory_TransactionID schema/table/primary_key_constraint MS_Description Primary key (clustered) constraint
Object Sales.CK_SalesTerritory_CostYTD.CK_SalesTerritory_CostYTD schema/table/check_constraint MS_Description Check constraint [CostYTD] >= (0.00)
Object Production.CK_Product_ReorderPoint.CK_Product_ReorderPoint schema/table/check_constraint MS_Description Check constraint [ReorderPoint] > (0)
Interface Production.vProductModelInstructions schema/view MS_Description Displays the content from each element in the xml column Instructions for each product in the Production.ProductModel table that has manufacturing instructions.
Object Production.PK_TransactionHistoryArchive_TransactionID.PK_TransactionHistoryArchive_TransactionID schema/table/primary_key_constraint MS_Description Primary key (clustered) constraint
Object Sales.CK_SalesTerritory_CostLastYear.CK_SalesTerritory_CostLastYear schema/table/check_constraint MS_Description Check constraint [CostLastYear] >= (0.00)
Object Production.CK_Product_StandardCost.CK_Product_StandardCost schema/table/check_constraint MS_Description Check constraint [SafetyStockLevel] > (0)
Interface Sales.vSalesPerson schema/view MS_Description Sales representiatives (names and addresses) and their sales-related information.
Object Production.PK_UnitMeasure_UnitMeasureCode.PK_UnitMeasure_UnitMeasureCode schema/table/primary_key_constraint MS_Description Primary key (clustered) constraint
Object Sales.SalesTerritoryHistory schema/table MS_Description Sales representative transfers to other sales territories.
Object Sales.SalesTerritoryHistory.BusinessEntityID schema/table/column MS_Description Primary key. The sales rep. Foreign key to SalesPerson.BusinessEntityID.
Object Sales.SalesTerritoryHistory.TerritoryID schema/table/column MS_Description Primary key. Territory identification number. Foreign key to SalesTerritory.SalesTerritoryID.
Object Sales.SalesTerritoryHistory.StartDate schema/table/column MS_Description Primary key. Date the sales representive started work in the territory.
Object Sales.SalesTerritoryHistory.EndDate schema/table/column MS_Description Date the sales representative left work in the territory.
Object Sales.SalesTerritoryHistory.rowguid schema/table/column MS_Description ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
Object Sales.SalesTerritoryHistory.ModifiedDate schema/table/column MS_Description Date and time the record was last updated.
Object Production.CK_Product_ListPrice.CK_Product_ListPrice schema/table/check_constraint MS_Description Check constraint [ListPrice] >= (0.00)
Interface Sales.vSalesPersonSalesByFiscalYears schema/view MS_Description Uses PIVOT to return aggregated sales information for each sales representative.
Object Purchasing.PK_Vendor_BusinessEntityID.PK_Vendor_BusinessEntityID schema/table/primary_key_constraint MS_Description Primary key (clustered) constraint
Object Sales.DF_SalesTerritoryHistory_rowguid.DF_SalesTerritoryHistory_rowguid schema/table/default_constraint MS_Description Default constraint value of NEWID()
Object Production.CK_Product_Weight.CK_Product_Weight schema/table/check_constraint MS_Description Check constraint [Weight] > (0.00)
Interface Person.vStateProvinceCountryRegion schema/view MS_Description Joins StateProvince table with CountryRegion table.
Object Production.PK_WorkOrder_WorkOrderID.PK_WorkOrder_WorkOrderID schema/table/primary_key_constraint MS_Description Primary key (clustered) constraint
Object Sales.DF_SalesTerritoryHistory_ModifiedDate.DF_SalesTerritoryHistory_ModifiedDate schema/table/default_constraint MS_Description Default constraint value of GETDATE()
Object Production.CK_Product_DaysToManufacture.CK_Product_DaysToManufacture schema/table/check_constraint MS_Description Check constraint [DaysToManufacture] >= (0)
Interface Sales.vStoreWithDemographics schema/view MS_Description Stores (including demographics) that sell Adventure Works Cycles products to consumers.
Object Production.PK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequence.PK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequence schema/table/primary_key_constraint MS_Description Primary key (clustered) constraint
Object Sales.CK_SalesTerritoryHistory_EndDate.CK_SalesTerritoryHistory_EndDate schema/table/check_constraint MS_Description Check constraint [EndDate] >= [StartDate] OR [EndDate] IS NULL
Object Production.CK_Product_ProductLine.CK_Product_ProductLine schema/table/check_constraint MS_Description Check constraint [ProductLine]='r' OR [ProductLine]='m' OR [ProductLine]='t' OR [ProductLine]='s' OR [ProductLine]='R' OR [ProductLine]='M' OR [ProductLine]='T' OR [ProductLine]='S' OR [ProductLine] IS NULL
Interface Sales.vStoreWithContacts schema/view MS_Description Stores (including store contacts) that sell Adventure Works Cycles products to consumers.
Object Production.ScrapReason schema/table MS_Description Manufacturing failure reasons lookup table.
Object Production.ScrapReason.ScrapReasonID schema/table/column MS_Description Primary key for ScrapReason records.
Object Production.ScrapReason.Name schema/table/column MS_Description Failure description.
Object Production.ScrapReason.ModifiedDate schema/table/column MS_Description Date and time the record was last updated.
Object Production.CK_Product_Class.CK_Product_Class schema/table/check_constraint MS_Description Check constraint [Class]='h' OR [Class]='m' OR [Class]='l' OR [Class]='H' OR [Class]='M' OR [Class]='L' OR [Class] IS NULL
Interface Sales.vStoreWithAddresses schema/view MS_Description Stores (including store addresses) that sell Adventure Works Cycles products to consumers.
Object Production.DF_ScrapReason_ModifiedDate.DF_ScrapReason_ModifiedDate schema/table/default_constraint MS_Description Default constraint value of GETDATE()
Object Production.CK_Product_Style.CK_Product_Style schema/table/check_constraint MS_Description Check constraint [Style]='u' OR [Style]='m' OR [Style]='w' OR [Style]='U' OR [Style]='M' OR [Style]='W' OR [Style] IS NULL
Interface Purchasing.vVendorWithContacts schema/view MS_Description Vendor (company) names and the names of vendor employees to contact.
Object HumanResources.Shift schema/table MS_Description Work shift lookup table.
Object HumanResources.Shift.ShiftID schema/table/column MS_Description Primary key for Shift records.
Object HumanResources.Shift.Name schema/table/column MS_Description Shift description.
Object HumanResources.Shift.StartTime schema/table/column MS_Description Shift start time.
Object HumanResources.Shift.EndTime schema/table/column MS_Description Shift end time.
Object HumanResources.Shift.ModifiedDate schema/table/column MS_Description Date and time the record was last updated.
Object Production.CK_Product_SellEndDate.CK_Product_SellEndDate schema/table/check_constraint MS_Description Check constraint [SellEndDate] >= [SellStartDate] OR [SellEndDate] IS NULL
Interface Purchasing.vVendorWithAddresses schema/view MS_Description Vendor (company) names and addresses .
Object HumanResources.DF_Shift_ModifiedDate.DF_Shift_ModifiedDate schema/table/default_constraint MS_Description Default constraint value of GETDATE()
Object Production.ProductCategory schema/table MS_Description High-level product categorization.
Object Production.ProductCategory.ProductCategoryID schema/table/column MS_Description Primary key for ProductCategory records.
Object Production.ProductCategory.Name schema/table/column MS_Description Category description.
Object Production.ProductCategory.rowguid schema/table/column MS_Description ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
Object Production.ProductCategory.ModifiedDate schema/table/column MS_Description Date and time the record was last updated.
Interface dbo.ufnGetAccountingStartDate schema/function MS_Description Scalar function used in the uSalesOrderHeader trigger to set the ending account date.
Object Purchasing.ShipMethod schema/table MS_Description Shipping company lookup table.
Object Purchasing.ShipMethod.ShipMethodID schema/table/column MS_Description Primary key for ShipMethod records.
Object Purchasing.ShipMethod.Name schema/table/column MS_Description Shipping company name.
Object Purchasing.ShipMethod.ShipBase schema/table/column MS_Description Minimum shipping charge.
Object Purchasing.ShipMethod.ShipRate schema/table/column MS_Description Shipping charge per pound.
Object Purchasing.ShipMethod.rowguid schema/table/column MS_Description ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
Object Purchasing.ShipMethod.ModifiedDate schema/table/column MS_Description Date and time the record was last updated.
Object Production.DF_ProductCategory_rowguid.DF_ProductCategory_rowguid schema/table/default_constraint MS_Description Default constraint value of NEWID()()
Interface dbo.ufnGetAccountingEndDate schema/function MS_Description Scalar function used in the uSalesOrderHeader trigger to set the starting account date.
Object Purchasing.DF_ShipMethod_ShipBase.DF_ShipMethod_ShipBase schema/table/default_constraint MS_Description Default constraint value of 0.0
Object Production.DF_ProductCategory_ModifiedDate.DF_ProductCategory_ModifiedDate schema/table/default_constraint MS_Description Default constraint value of GETDATE()
Interface dbo.ufnGetContactInformation schema/function MS_Description Table value function returning the first name, last name, job title and contact type for a given contact.
Object Purchasing.DF_ShipMethod_ShipRate.DF_ShipMethod_ShipRate schema/table/default_constraint MS_Description Default constraint value of 0.0
Object Production.ProductCostHistory schema/table MS_Description Changes in the cost of a product over time.
Object Production.ProductCostHistory.ProductID schema/table/column MS_Description Product identification number. Foreign key to Product.ProductID
Object Production.ProductCostHistory.StartDate schema/table/column MS_Description Product cost start date.
Object Production.ProductCostHistory.EndDate schema/table/column MS_Description Product cost end date.
Object Production.ProductCostHistory.StandardCost schema/table/column MS_Description Standard cost of the product.
Object Production.ProductCostHistory.ModifiedDate schema/table/column MS_Description Date and time the record was last updated.
Interface dbo.ufnGetProductDealerPrice schema/function MS_Description Scalar function returning the dealer price for a given product on a particular order date.
Object Purchasing.DF_ShipMethod_rowguid.DF_ShipMethod_rowguid schema/table/default_constraint MS_Description Default constraint value of NEWID()
Object Production.DF_ProductCostHistory_ModifiedDate.DF_ProductCostHistory_ModifiedDate schema/table/default_constraint MS_Description Default constraint value of GETDATE()
Interface dbo.ufnGetProductListPrice schema/function MS_Description Scalar function returning the list price for a given product on a particular order date.
Object Purchasing.DF_ShipMethod_ModifiedDate.DF_ShipMethod_ModifiedDate schema/table/default_constraint MS_Description Default constraint value of GETDATE()
Object Production.CK_ProductCostHistory_EndDate.CK_ProductCostHistory_EndDate schema/table/check_constraint MS_Description Check constraint [EndDate] >= [StartDate] OR [EndDate] IS NULL
Interface dbo.ufnGetProductStandardCost schema/function MS_Description Scalar function returning the standard cost for a given product on a particular order date.
Object Purchasing.CK_ShipMethod_ShipBase.CK_ShipMethod_ShipBase schema/table/check_constraint MS_Description Check constraint [ShipBase] > (0.00)
Object Production.CK_ProductCostHistory_StandardCost.CK_ProductCostHistory_StandardCost schema/table/check_constraint MS_Description Check constraint [StandardCost] >= (0.00)
Interface dbo.ufnGetStock schema/function MS_Description Scalar function returning the quantity of inventory in LocationID 6 (Miscellaneous Storage)for a specified ProductID.
Object Purchasing.CK_ShipMethod_ShipRate.CK_ShipMethod_ShipRate schema/table/check_constraint MS_Description Check constraint [ShipRate] > (0.00)
Object Production.ProductDescription schema/table MS_Description Product descriptions in several languages.
Object Production.ProductDescription.ProductDescriptionID schema/table/column MS_Description Primary key for ProductDescription records.
Object Production.ProductDescription.Description schema/table/column MS_Description Description of the product.
Object Production.ProductDescription.rowguid schema/table/column MS_Description ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
Object Production.ProductDescription.ModifiedDate schema/table/column MS_Description Date and time the record was last updated.
Interface dbo.ufnGetDocumentStatusText schema/function MS_Description Scalar function returning the text representation of the Status column in the Document table.
Object Sales.ShoppingCartItem schema/table MS_Description Contains online customer orders until the order is submitted or cancelled.
Object Sales.ShoppingCartItem.ShoppingCartItemID schema/table/column MS_Description Primary key for ShoppingCartItem records.
Object Sales.ShoppingCartItem.ShoppingCartID schema/table/column MS_Description Shopping cart identification number.
Object Sales.ShoppingCartItem.Quantity schema/table/column MS_Description Product quantity ordered.
Object Sales.ShoppingCartItem.ProductID schema/table/column MS_Description Product ordered. Foreign key to Product.ProductID.
Object Sales.ShoppingCartItem.DateCreated schema/table/column MS_Description Date the time the record was created.
Object Sales.ShoppingCartItem.ModifiedDate schema/table/column MS_Description Date and time the record was last updated.
Object Production.DF_ProductDescription_rowguid.DF_ProductDescription_rowguid schema/table/default_constraint MS_Description Default constraint value of NEWID()
Interface dbo.ufnGetPurchaseOrderStatusText schema/function MS_Description Scalar function returning the text representation of the Status column in the PurchaseOrderHeader table.
Object Sales.DF_ShoppingCartItem_Quantity.DF_ShoppingCartItem_Quantity schema/table/default_constraint MS_Description Default constraint value of 1
Object Production.DF_ProductDescription_ModifiedDate.DF_ProductDescription_ModifiedDate schema/table/default_constraint MS_Description Default constraint value of GETDATE()
Interface dbo.ufnGetSalesOrderStatusText schema/function MS_Description Scalar function returning the text representation of the Status column in the SalesOrderHeader table.
Object Sales.DF_ShoppingCartItem_DateCreated.DF_ShoppingCartItem_DateCreated schema/table/default_constraint MS_Description Default constraint value of GETDATE()
Object Production.ProductDocument schema/table MS_Description Cross-reference table mapping products to related product documents.
Object Production.ProductDocument.ProductID schema/table/column MS_Description Product identification number. Foreign key to Product.ProductID.
Object Production.ProductDocument.DocumentNode schema/table/column MS_Description Document identification number. Foreign key to Document.DocumentNode.
Object Production.ProductDocument.ModifiedDate schema/table/column MS_Description Date and time the record was last updated.
Interface dbo.uspGetBillOfMaterials schema/procedure MS_Description Stored procedure using a recursive query to return a multi-level bill of material for the specified ProductID.
Interface dbo.uspGetBillOfMaterials schema/procedure Purpose SamplePurpose
Object Sales.DF_ShoppingCartItem_ModifiedDate.DF_ShoppingCartItem_ModifiedDate schema/table/default_constraint MS_Description Default constraint value of GETDATE()
Object Production.DF_ProductDocument_ModifiedDate.DF_ProductDocument_ModifiedDate schema/table/default_constraint MS_Description Default constraint value of GETDATE()
Object dbo.DatabaseLog schema/table MS_Description Audit table tracking all DDL changes made to the AdventureWorks database. Data is captured by the database trigger ddlDatabaseTriggerLog.
Object dbo.DatabaseLog.DatabaseLogID schema/table/column MS_Description Primary key for DatabaseLog records.
Object dbo.DatabaseLog.PostTime schema/table/column MS_Description The date and time the DDL change occurred.
Object dbo.DatabaseLog.DatabaseUser schema/table/column MS_Description The user who implemented the DDL change.
Object dbo.DatabaseLog.Event schema/table/column MS_Description The type of DDL statement that was executed.
Object dbo.DatabaseLog.Schema schema/table/column MS_Description The schema to which the changed object belongs.
Object dbo.DatabaseLog.Object schema/table/column MS_Description The object that was changed by the DDL statment.
Object dbo.DatabaseLog.TSQL schema/table/column MS_Description The exact Transact-SQL statement that was executed.
Object dbo.DatabaseLog.XmlEvent schema/table/column MS_Description The raw XML data generated by database trigger.
Interface dbo.uspGetEmployeeManagers schema/procedure MS_Description Stored procedure using a recursive query to return the direct and indirect managers of the specified employee.
Object Sales.CK_ShoppingCartItem_Quantity.CK_ShoppingCartItem_Quantity schema/table/check_constraint MS_Description Check constraint [Quantity] >= (1)
Object Production.ProductInventory schema/table MS_Description Product inventory information.
Object Production.ProductInventory.ProductID schema/table/column MS_Description Product identification number. Foreign key to Product.ProductID.
Object Production.ProductInventory.LocationID schema/table/column MS_Description Inventory location identification number. Foreign key to Location.LocationID.
Object Production.ProductInventory.Shelf schema/table/column MS_Description Storage compartment within an inventory location.
Object Production.ProductInventory.Bin schema/table/column MS_Description Storage container on a shelf in an inventory location.
Object Production.ProductInventory.Quantity schema/table/column MS_Description Quantity of products in the inventory location.
Object Production.ProductInventory.rowguid schema/table/column MS_Description ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
Object Production.ProductInventory.ModifiedDate schema/table/column MS_Description Date and time the record was last updated.
Interface dbo.uspGetManagerEmployees schema/procedure MS_Description Stored procedure using a recursive query to return the direct and indirect employees of the specified manager.
Object Sales.SpecialOffer schema/table MS_Description Sale discounts lookup table.
Object Sales.SpecialOffer.SpecialOfferID schema/table/column MS_Description Primary key for SpecialOffer records.
Object Sales.SpecialOffer.Description schema/table/column MS_Description Discount description.
Object Sales.SpecialOffer.DiscountPct schema/table/column MS_Description Discount precentage.
Object Sales.SpecialOffer.Type schema/table/column MS_Description Discount type category.
Object Sales.SpecialOffer.Category schema/table/column MS_Description Group the discount applies to such as Reseller or Customer.
Object Sales.SpecialOffer.StartDate schema/table/column MS_Description Discount start date.
Object Sales.SpecialOffer.EndDate schema/table/column MS_Description Discount end date.
Object Sales.SpecialOffer.MinQty schema/table/column MS_Description Minimum discount percent allowed.
Object Sales.SpecialOffer.MaxQty schema/table/column MS_Description Maximum discount percent allowed.
Object Sales.SpecialOffer.rowguid schema/table/column MS_Description ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
Object Sales.SpecialOffer.ModifiedDate schema/table/column MS_Description Date and time the record was last updated.
Object Production.DF_ProductInventory_Quantity.DF_ProductInventory_Quantity schema/table/default_constraint MS_Description Default constraint value of 0
Object dbo.ErrorLog schema/table MS_Description Audit table tracking errors in the the AdventureWorks database that are caught by the CATCH block of a TRY...CATCH construct. Data is inserted by stored procedure dbo.uspLogError when it is executed from inside the CATCH block of a TRY...CATCH construct.
Object dbo.ErrorLog.ErrorLogID schema/table/column MS_Description Primary key for ErrorLog records.
Object dbo.ErrorLog.ErrorTime schema/table/column MS_Description The date and time at which the error occurred.
Object dbo.ErrorLog.UserName schema/table/column MS_Description The user who executed the batch in which the error occurred.
Object dbo.ErrorLog.ErrorNumber schema/table/column MS_Description The error number of the error that occurred.
Object dbo.ErrorLog.ErrorSeverity schema/table/column MS_Description The severity of the error that occurred.
Object dbo.ErrorLog.ErrorState schema/table/column MS_Description The state number of the error that occurred.
Object dbo.ErrorLog.ErrorProcedure schema/table/column MS_Description The name of the stored procedure or trigger where the error occurred.
Object dbo.ErrorLog.ErrorLine schema/table/column MS_Description The line number at which the error occurred.
Object dbo.ErrorLog.ErrorMessage schema/table/column MS_Description The message text of the error that occurred.
Interface dbo.uspGetWhereUsedProductID schema/procedure MS_Description Stored procedure using a recursive query to return all components or assemblies that directly or indirectly use the specified ProductID.
Object Sales.DF_SpecialOffer_DiscountPct.DF_SpecialOffer_DiscountPct schema/table/default_constraint MS_Description Default constraint value of 0.0
Object Production.DF_ProductInventory_rowguid.DF_ProductInventory_rowguid schema/table/default_constraint MS_Description Default constraint value of NEWID()
Object dbo.DF_ErrorLog_ErrorTime.DF_ErrorLog_ErrorTime schema/table/default_constraint MS_Description Default constraint value of GETDATE()
Interface HumanResources.uspUpdateEmployeeHireInfo schema/procedure MS_Description Updates the Employee table and inserts a new row in the EmployeePayHistory table with the values specified in the input parameters.
Object Person.FK_Address_StateProvince_StateProvinceID.FK_Address_StateProvince_StateProvinceID schema/table/foreign_key_constraint MS_Description Foreign key constraint referencing StateProvince.StateProvinceID.
Object Sales.DF_SpecialOffer_MinQty.DF_SpecialOffer_MinQty schema/table/default_constraint MS_Description Default constraint value of 0.0
Object Production.DF_ProductInventory_ModifiedDate.DF_ProductInventory_ModifiedDate schema/table/default_constraint MS_Description Default constraint value of GETDATE()
Object dbo.PK_ErrorLog_ErrorLogID.PK_ErrorLog_ErrorLogID schema/table/primary_key_constraint MS_Description Primary key (clustered) constraint
Interface HumanResources.uspUpdateEmployeeLogin schema/procedure MS_Description Updates the Employee table with the values specified in the input parameters for the given BusinessEntityID.
Object Production.FK_BillOfMaterials_Product_ProductAssemblyID.FK_BillOfMaterials_Product_ProductAssemblyID schema/table/foreign_key_constraint MS_Description Foreign key constraint referencing Product.ProductAssemblyID.
Object Sales.DF_SpecialOffer_rowguid.DF_SpecialOffer_rowguid schema/table/default_constraint MS_Description Default constraint value of NEWID()
Object Production.CK_ProductInventory_Shelf.CK_ProductInventory_Shelf schema/table/check_constraint MS_Description Check constraint [Shelf] like '[A-Za-z]' OR [Shelf]='N/A'
Interface dbo.uspPrintError schema/procedure MS_Description Prints error information about the error that caused execution to jump to the CATCH block of a TRY...CATCH construct. Should be executed from within the scope of a CATCH block otherwise it will return without printing any error information.
Interface HumanResources.uspUpdateEmployeePersonalInfo schema/procedure MS_Description Updates the Employee table with the values specified in the input parameters for the given EmployeeID.
Object Production.FK_BillOfMaterials_Product_ComponentID.FK_BillOfMaterials_Product_ComponentID schema/table/foreign_key_constraint MS_Description Foreign key constraint referencing Product.ComponentID.
Object Sales.DF_SpecialOffer_ModifiedDate.DF_SpecialOffer_ModifiedDate schema/table/default_constraint MS_Description Default constraint value of GETDATE()
Object Production.CK_ProductInventory_Bin.CK_ProductInventory_Bin schema/table/check_constraint MS_Description Check constraint [Bin] BETWEEN (0) AND (100)
Interface dbo.uspLogError schema/procedure MS_Description Logs error information in the ErrorLog table about the error that caused execution to jump to the CATCH block of a TRY...CATCH construct. Should be executed from within the scope of a CATCH block otherwise it will return without inserting error information.
Object Production.FK_BillOfMaterials_UnitMeasure_UnitMeasureCode.FK_BillOfMaterials_UnitMeasure_UnitMeasureCode schema/table/foreign_key_constraint MS_Description Foreign key constraint referencing UnitMeasure.UnitMeasureCode.
Object Sales.CK_SpecialOffer_EndDate.CK_SpecialOffer_EndDate schema/table/check_constraint MS_Description Check constraint [EndDate] >= [StartDate]
Object Production.ProductListPriceHistory schema/table MS_Description Changes in the list price of a product over time.
Object Production.ProductListPriceHistory.ProductID schema/table/column MS_Description Product identification number. Foreign key to Product.ProductID
Object Production.ProductListPriceHistory.StartDate schema/table/column MS_Description List price start date.
Object Production.ProductListPriceHistory.EndDate schema/table/column MS_Description List price end date
Object Production.ProductListPriceHistory.ListPrice schema/table/column MS_Description Product list price.
Object Production.ProductListPriceHistory.ModifiedDate schema/table/column MS_Description Date and time the record was last updated.
Interface dbo.ufnLeadingZeros schema/function MS_Description Scalar function used by the Sales.Customer table to help set the account number.
Object Person.FK_BusinessEntityAddress_Address_AddressID.FK_BusinessEntityAddress_Address_AddressID schema/table/foreign_key_constraint MS_Description Foreign key constraint referencing Address.AddressID.
Object Sales.CK_SpecialOffer_DiscountPct.CK_SpecialOffer_DiscountPct schema/table/check_constraint MS_Description Check constraint [DiscountPct] >= (0.00)
Object Production.DF_ProductListPriceHistory_ModifiedDate.DF_ProductListPriceHistory_ModifiedDate schema/table/default_constraint MS_Description Default constraint value of GETDATE()
Object Person.Address schema/table MS_Description Street address information for customers, employees, and vendors.
Object Person.Address.AddressID schema/table/column MS_Description Primary key for Address records.
Object Person.Address.AddressLine1 schema/table/column MS_Description First street address line.
Object Person.Address.AddressLine2 schema/table/column MS_Description Second street address line.
Object Person.Address.City schema/table/column MS_Description Name of the city.
Object Person.Address.StateProvinceID schema/table/column MS_Description Unique identification number for the state or province. Foreign key to StateProvince table.
Object Person.Address.PostalCode schema/table/column MS_Description Postal code for the street address.
Object Person.Address.SpatialLocation schema/table/column MS_Description Latitude and longitude of this address.
Object Person.Address.rowguid schema/table/column MS_Description ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
Object Person.Address.ModifiedDate schema/table/column MS_Description Date and time the record was last updated.
Object Person.FK_BusinessEntityAddress_AddressType_AddressTypeID.FK_BusinessEntityAddress_AddressType_AddressTypeID schema/table/foreign_key_constraint MS_Description Foreign key constraint referencing AddressType.AddressTypeID.
Object Sales.CK_SpecialOffer_MinQty.CK_SpecialOffer_MinQty schema/table/check_constraint MS_Description Check constraint [MinQty] >= (0)
Object Production.CK_ProductListPriceHistory_EndDate.CK_ProductListPriceHistory_EndDate schema/table/check_constraint MS_Description Check constraint [EndDate] >= [StartDate] OR [EndDate] IS NULL
Object Person.DF_Address_rowguid.DF_Address_rowguid schema/table/default_constraint MS_Description Default constraint value of NEWID()
Object Person.FK_BusinessEntityAddress_BusinessEntity_BusinessEntityID.FK_BusinessEntityAddress_BusinessEntity_BusinessEntityID schema/table/foreign_key_constraint MS_Description Foreign key constraint referencing BusinessEntity.BusinessEntityID.
Object Sales.CK_SpecialOffer_MaxQty.CK_SpecialOffer_MaxQty schema/table/check_constraint MS_Description Check constraint [MaxQty] >= (0)
Object Production.CK_ProductListPriceHistory_ListPrice.CK_ProductListPriceHistory_ListPrice schema/table/check_constraint MS_Description Check constraint [ListPrice] > (0.00)
Object Person.DF_Address_ModifiedDate.DF_Address_ModifiedDate schema/table/default_constraint MS_Description Default constraint value of GETDATE()
Object Person.FK_BusinessEntityContact_Person_PersonID.FK_BusinessEntityContact_Person_PersonID schema/table/foreign_key_constraint MS_Description Foreign key constraint referencing Person.BusinessEntityID.
Object Sales.SpecialOfferProduct schema/table MS_Description Cross-reference table mapping products to special offer discounts.
Object Sales.SpecialOfferProduct.SpecialOfferID schema/table/column MS_Description Primary key for SpecialOfferProduct records.
Object Sales.SpecialOfferProduct.ProductID schema/table/column MS_Description Product identification number. Foreign key to Product.ProductID.
Object Sales.SpecialOfferProduct.rowguid schema/table/column MS_Description ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
Object Sales.SpecialOfferProduct.ModifiedDate schema/table/column MS_Description Date and time the record was last updated.
Object Production.ProductModel schema/table MS_Description Product model classification.
Object Production.ProductModel.ProductModelID schema/table/column MS_Description Primary key for ProductModel records.
Object Production.ProductModel.Name schema/table/column MS_Description Product model description.
Object Production.ProductModel.CatalogDescription schema/table/column MS_Description Detailed product catalog information in xml format.
Object Production.ProductModel.Instructions schema/table/column MS_Description Manufacturing instructions in xml format.
Object Production.ProductModel.rowguid schema/table/column MS_Description ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
Object Production.ProductModel.ModifiedDate schema/table/column MS_Description Date and time the record was last updated.
Object Person.AddressType schema/table MS_Description Types of addresses stored in the Address table.
Object Person.AddressType.AddressTypeID schema/table/column MS_Description Primary key for AddressType records.
Object Person.AddressType.Name schema/table/column MS_Description Address type description. For example, Billing, Home, or Shipping.
Object Person.AddressType.rowguid schema/table/column MS_Description ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
Object Person.AddressType.ModifiedDate schema/table/column MS_Description Date and time the record was last updated.
Object Person.FK_BusinessEntityContact_ContactType_ContactTypeID.FK_BusinessEntityContact_ContactType_ContactTypeID schema/table/foreign_key_constraint MS_Description Foreign key constraint referencing ContactType.ContactTypeID.
Object Sales.DF_SpecialOfferProduct_rowguid.DF_SpecialOfferProduct_rowguid schema/table/default_constraint MS_Description Default constraint value of NEWID()
Object Production.DF_ProductModel_rowguid.DF_ProductModel_rowguid schema/table/default_constraint MS_Description Default constraint value of NEWID()
Object Person.DF_AddressType_rowguid.DF_AddressType_rowguid schema/table/default_constraint MS_Description Default constraint value of NEWID()
Object Person.FK_BusinessEntityContact_BusinessEntity_BusinessEntityID.FK_BusinessEntityContact_BusinessEntity_BusinessEntityID schema/table/foreign_key_constraint MS_Description Foreign key constraint referencing BusinessEntity.BusinessEntityID.
Object Sales.DF_SpecialOfferProduct_ModifiedDate.DF_SpecialOfferProduct_ModifiedDate schema/table/default_constraint MS_Description Default constraint value of GETDATE()
Object Production.DF_ProductModel_ModifiedDate.DF_ProductModel_ModifiedDate schema/table/default_constraint MS_Description Default constraint value of GETDATE()
Object Person.DF_AddressType_ModifiedDate.DF_AddressType_ModifiedDate schema/table/default_constraint MS_Description Default constraint value of GETDATE()
Object Sales.FK_CountryRegionCurrency_CountryRegion_CountryRegionCode.FK_CountryRegionCurrency_CountryRegion_CountryRegionCode schema/table/foreign_key_constraint MS_Description Foreign key constraint referencing CountryRegion.CountryRegionCode.
Object Person.StateProvince schema/table MS_Description State and province lookup table.
Object Person.StateProvince.StateProvinceID schema/table/column MS_Description Primary key for StateProvince records.
Object Person.StateProvince.StateProvinceCode schema/table/column MS_Description ISO standard state or province code.
Object Person.StateProvince.CountryRegionCode schema/table/column MS_Description ISO standard country or region code. Foreign key to CountryRegion.CountryRegionCode.
Object Person.StateProvince.IsOnlyStateProvinceFlag schema/table/column MS_Description 0 = StateProvinceCode exists. 1 = StateProvinceCode unavailable, using CountryRegionCode.
Object Person.StateProvince.Name schema/table/column MS_Description State or province description.
Object Person.StateProvince.TerritoryID schema/table/column MS_Description ID of the territory in which the state or province is located. Foreign key to SalesTerritory.SalesTerritoryID.
Object Person.StateProvince.rowguid schema/table/column MS_Description ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
Object Person.StateProvince.ModifiedDate schema/table/column MS_Description Date and time the record was last updated.
Object Production.ProductModelIllustration schema/table MS_Description Cross-reference table mapping product models and illustrations.
Object Production.ProductModelIllustration.ProductModelID schema/table/column MS_Description Primary key. Foreign key to ProductModel.ProductModelID.
Object Production.ProductModelIllustration.IllustrationID schema/table/column MS_Description Primary key. Foreign key to Illustration.IllustrationID.
Object Production.ProductModelIllustration.ModifiedDate schema/table/column MS_Description Date and time the record was last updated.
Object dbo.AWBuildVersion schema/table MS_Description Current version number of the AdventureWorks 2016 sample database.
Object dbo.AWBuildVersion.SystemInformationID schema/table/column MS_Description Primary key for AWBuildVersion records.
Object dbo.AWBuildVersion.Database Version schema/table/column MS_Description Version number of the database in 9.yy.mm.dd.00 format.
Object dbo.AWBuildVersion.VersionDate schema/table/column MS_Description Date and time the record was last updated.
Object dbo.AWBuildVersion.ModifiedDate schema/table/column MS_Description Date and time the record was last updated.
Object Sales.FK_CountryRegionCurrency_Currency_CurrencyCode.FK_CountryRegionCurrency_Currency_CurrencyCode schema/table/foreign_key_constraint MS_Description Foreign key constraint referencing Currency.CurrencyCode.
Object Person.DF_StateProvince_IsOnlyStateProvinceFlag.DF_StateProvince_IsOnlyStateProvinceFlag schema/table/default_constraint MS_Description Default constraint value of 1 (TRUE)
Object Production.DF_ProductModelIllustration_ModifiedDate.DF_ProductModelIllustration_ModifiedDate schema/table/default_constraint MS_Description Default constraint value of GETDATE()
Object dbo.DF_AWBuildVersion_ModifiedDate.DF_AWBuildVersion_ModifiedDate schema/table/default_constraint MS_Description Default constraint value of GETDATE()
Object Sales.FK_CurrencyRate_Currency_FromCurrencyCode.FK_CurrencyRate_Currency_FromCurrencyCode schema/table/foreign_key_constraint MS_Description Foreign key constraint referencing Currency.FromCurrencyCode.
Object Person.DF_StateProvince_rowguid.DF_StateProvince_rowguid schema/table/default_constraint MS_Description Default constraint value of NEWID()
Object Production.ProductModelProductDescriptionCulture schema/table MS_Description Cross-reference table mapping product descriptions and the language the description is written in.
Object Production.ProductModelProductDescriptionCulture.ProductModelID schema/table/column MS_Description Primary key. Foreign key to ProductModel.ProductModelID.
Object Production.ProductModelProductDescriptionCulture.ProductDescriptionID schema/table/column MS_Description Primary key. Foreign key to ProductDescription.ProductDescriptionID.
Object Production.ProductModelProductDescriptionCulture.CultureID schema/table/column MS_Description Culture identification number. Foreign key to Culture.CultureID.
Object Production.ProductModelProductDescriptionCulture.ModifiedDate schema/table/column MS_Description Date and time the record was last updated.
Object Production.BillOfMaterials schema/table MS_Description Items required to make bicycles and bicycle subassemblies. It identifies the heirarchical relationship between a parent product and its components.
Object Production.BillOfMaterials.BillOfMaterialsID schema/table/column MS_Description Primary key for BillOfMaterials records.
Object Production.BillOfMaterials.ProductAssemblyID schema/table/column MS_Description Parent product identification number. Foreign key to Product.ProductID.
Object Production.BillOfMaterials.ComponentID schema/table/column MS_Description Component identification number. Foreign key to Product.ProductID.
Object Production.BillOfMaterials.StartDate schema/table/column MS_Description Date the component started being used in the assembly item.
Object Production.BillOfMaterials.EndDate schema/table/column MS_Description Date the component stopped being used in the assembly item.
Object Production.BillOfMaterials.UnitMeasureCode schema/table/column MS_Description Standard code identifying the unit of measure for the quantity.
Object Production.BillOfMaterials.BOMLevel schema/table/column MS_Description Indicates the depth the component is from its parent (AssemblyID).
Object Production.BillOfMaterials.PerAssemblyQty schema/table/column MS_Description Quantity of the component needed to create the assembly.
Object Production.BillOfMaterials.ModifiedDate schema/table/column MS_Description Date and time the record was last updated.
Object Sales.FK_CurrencyRate_Currency_ToCurrencyCode.FK_CurrencyRate_Currency_ToCurrencyCode schema/table/foreign_key_constraint MS_Description Foreign key constraint referencing Currency.ToCurrencyCode.
Object Person.DF_StateProvince_ModifiedDate.DF_StateProvince_ModifiedDate schema/table/default_constraint MS_Description Default constraint value of GETDATE()
Object Production.DF_ProductModelProductDescriptionCulture_ModifiedDate.DF_ProductModelProductDescriptionCulture_ModifiedDate schema/table/default_constraint MS_Description Default constraint value of GETDATE()
Object Production.DF_BillOfMaterials_StartDate.DF_BillOfMaterials_StartDate schema/table/default_constraint MS_Description Default constraint value of GETDATE()
Object Sales.FK_Customer_Person_PersonID.FK_Customer_Person_PersonID schema/table/foreign_key_constraint MS_Description Foreign key constraint referencing Person.BusinessEntityID.
Object Sales.Store schema/table MS_Description Customers (resellers) of Adventure Works products.
Object Sales.Store.BusinessEntityID schema/table/column MS_Description Primary key. Foreign key to Customer.BusinessEntityID.
Object Sales.Store.Name schema/table/column MS_Description Name of the store.
Object Sales.Store.SalesPersonID schema/table/column MS_Description ID of the sales person assigned to the customer. Foreign key to SalesPerson.BusinessEntityID.
Object Sales.Store.Demographics schema/table/column MS_Description Demographic informationg about the store such as the number of employees, annual sales and store type.
Object Sales.Store.rowguid schema/table/column MS_Description ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
Object Sales.Store.ModifiedDate schema/table/column MS_Description Date and time the record was last updated.
Object Production.ProductPhoto schema/table MS_Description Product images.
Object Production.ProductPhoto.ProductPhotoID schema/table/column MS_Description Primary key for ProductPhoto records.
Object Production.ProductPhoto.ThumbNailPhoto schema/table/column MS_Description Small image of the product.
Object Production.ProductPhoto.ThumbnailPhotoFileName schema/table/column MS_Description Small image file name.
Object Production.ProductPhoto.LargePhoto schema/table/column MS_Description Large image of the product.
Object Production.ProductPhoto.LargePhotoFileName schema/table/column MS_Description Large image file name.
Object Production.ProductPhoto.ModifiedDate schema/table/column MS_Description Date and time the record was last updated.
Object Production.DF_BillOfMaterials_PerAssemblyQty.DF_BillOfMaterials_PerAssemblyQty schema/table/default_constraint MS_Description Default constraint value of 1.0
Object Sales.FK_Customer_Store_StoreID.FK_Customer_Store_StoreID schema/table/foreign_key_constraint MS_Description Foreign key constraint referencing Store.BusinessEntityID.
Object Sales.DF_Store_rowguid.DF_Store_rowguid schema/table/default_constraint MS_Description Default constraint value of NEWID()
Object Production.DF_ProductPhoto_ModifiedDate.DF_ProductPhoto_ModifiedDate schema/table/default_constraint MS_Description Default constraint value of GETDATE()
Object Production.DF_BillOfMaterials_ModifiedDate.DF_BillOfMaterials_ModifiedDate schema/table/default_constraint MS_Description Default constraint value of GETDATE()
Object Sales.FK_Customer_SalesTerritory_TerritoryID.FK_Customer_SalesTerritory_TerritoryID schema/table/foreign_key_constraint MS_Description Foreign key constraint referencing SalesTerritory.TerritoryID.
Object Sales.DF_Store_ModifiedDate.DF_Store_ModifiedDate schema/table/default_constraint MS_Description Default constraint value of GETDATE()
Object Production.ProductProductPhoto schema/table MS_Description Cross-reference table mapping products and product photos.
Object Production.ProductProductPhoto.ProductID schema/table/column MS_Description Product identification number. Foreign key to Product.ProductID.
Object Production.ProductProductPhoto.ProductPhotoID schema/table/column MS_Description Product photo identification number. Foreign key to ProductPhoto.ProductPhotoID.
Object Production.ProductProductPhoto.Primary schema/table/column MS_Description 0 = Photo is not the principal image. 1 = Photo is the principal image.
Object Production.ProductProductPhoto.ModifiedDate schema/table/column MS_Description Date and time the record was last updated.
Object Production.CK_BillOfMaterials_EndDate.CK_BillOfMaterials_EndDate schema/table/check_constraint MS_Description Check constraint EndDate] > [StartDate] OR [EndDate] IS NULL
Object Production.FK_Document_Employee_Owner.FK_Document_Employee_Owner schema/table/foreign_key_constraint MS_Description Foreign key constraint referencing Employee.BusinessEntityID.
Object Production.TransactionHistory schema/table MS_Description Record of each purchase order, sales order, or work order transaction year to date.
Object Production.TransactionHistory.TransactionID schema/table/column MS_Description Primary key for TransactionHistory records.
Object Production.TransactionHistory.ProductID schema/table/column MS_Description Product identification number. Foreign key to Product.ProductID.
Object Production.TransactionHistory.ReferenceOrderID schema/table/column MS_Description Purchase order, sales order, or work order identification number.
Object Production.TransactionHistory.ReferenceOrderLineID schema/table/column MS_Description Line number associated with the purchase order, sales order, or work order.
Object Production.TransactionHistory.TransactionDate schema/table/column MS_Description Date and time of the transaction.
Object Production.TransactionHistory.TransactionType schema/table/column MS_Description W = WorkOrder, S = SalesOrder, P = PurchaseOrder
Object Production.TransactionHistory.Quantity schema/table/column MS_Description Product quantity.
Object Production.TransactionHistory.ActualCost schema/table/column MS_Description Product cost.
Object Production.TransactionHistory.ModifiedDate schema/table/column MS_Description Date and time the record was last updated.
Object Production.DF_ProductProductPhoto_Primary.DF_ProductProductPhoto_Primary schema/table/default_constraint MS_Description Default constraint value of 0 (FALSE)
Object Production.CK_BillOfMaterials_ProductAssemblyID.CK_BillOfMaterials_ProductAssemblyID schema/table/check_constraint MS_Description Check constraint [ProductAssemblyID] <> [ComponentID]
Object Person.FK_EmailAddress_Person_BusinessEntityID.FK_EmailAddress_Person_BusinessEntityID schema/table/foreign_key_constraint MS_Description Foreign key constraint referencing Person.BusinessEntityID.
Object Production.DF_TransactionHistory_ReferenceOrderLineID.DF_TransactionHistory_ReferenceOrderLineID schema/table/default_constraint MS_Description Default constraint value of 0
Object Production.DF_ProductProductPhoto_ModifiedDate.DF_ProductProductPhoto_ModifiedDate schema/table/default_constraint MS_Description Default constraint value of GETDATE()
Object Production.CK_BillOfMaterials_BOMLevel.CK_BillOfMaterials_BOMLevel schema/table/check_constraint MS_Description Check constraint [ProductAssemblyID] IS NULL AND [BOMLevel] = (0) AND [PerAssemblyQty] = (1) OR [ProductAssemblyID] IS NOT NULL AND [BOMLevel] >= (1)
Interface dbo.Usp_MyStoredProc schema/procedure Purpose Purpose of Usp_MyStoredProc
Object HumanResources.FK_Employee_Person_BusinessEntityID.FK_Employee_Person_BusinessEntityID schema/table/foreign_key_constraint MS_Description Foreign key constraint referencing Person.BusinessEntityID.
Object Production.DF_TransactionHistory_TransactionDate.DF_TransactionHistory_TransactionDate schema/table/default_constraint MS_Description Default constraint value of GETDATE()
Object Production.ProductReview schema/table MS_Description Customer reviews of products they have purchased.
Object Production.ProductReview.ProductReviewID schema/table/column MS_Description Primary key for ProductReview records.
Object Production.ProductReview.ProductID schema/table/column MS_Description Product identification number. Foreign key to Product.ProductID.
Object Production.ProductReview.ReviewerName schema/table/column MS_Description Name of the reviewer.
Object Production.ProductReview.ReviewDate schema/table/column MS_Description Date review was submitted.
Object Production.ProductReview.EmailAddress schema/table/column MS_Description Reviewer's e-mail address.
Object Production.ProductReview.Rating schema/table/column MS_Description Product rating given by the reviewer. Scale is 1 to 5 with 5 as the highest rating.
Object Production.ProductReview.Comments schema/table/column MS_Description Reviewer's comments
Object Production.ProductReview.ModifiedDate schema/table/column MS_Description Date and time the record was last updated.
Object Production.CK_BillOfMaterials_PerAssemblyQty.CK_BillOfMaterials_PerAssemblyQty schema/table/check_constraint MS_Description Check constraint [PerAssemblyQty] >= (1.00)
Object HumanResources.FK_EmployeeDepartmentHistory_Department_DepartmentID.FK_EmployeeDepartmentHistory_Department_DepartmentID schema/table/foreign_key_constraint MS_Description Foreign key constraint referencing Department.DepartmentID.
Object Production.DF_TransactionHistory_ModifiedDate.DF_TransactionHistory_ModifiedDate schema/table/default_constraint MS_Description Default constraint value of GETDATE()
Object Production.DF_ProductReview_ReviewDate.DF_ProductReview_ReviewDate schema/table/default_constraint MS_Description Default constraint value of GETDATE()
Object Person.BusinessEntity schema/table MS_Description Source of the ID that connects vendors, customers, and employees with address and contact information.
Object Person.BusinessEntity.BusinessEntityID schema/table/column MS_Description Primary key for all customers, vendors, and employees.
Object Person.BusinessEntity.rowguid schema/table/column MS_Description ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
Object Person.BusinessEntity.ModifiedDate schema/table/column MS_Description Date and time the record was last updated.
Object HumanResources.FK_EmployeeDepartmentHistory_Employee_BusinessEntityID.FK_EmployeeDepartmentHistory_Employee_BusinessEntityID schema/table/foreign_key_constraint MS_Description Foreign key constraint referencing Employee.EmployeeID.
Object Production.CK_TransactionHistory_TransactionType.CK_TransactionHistory_TransactionType schema/table/check_constraint MS_Description Check constraint [TransactionType]='p' OR [TransactionType]='s' OR [TransactionType]='w' OR [TransactionType]='P' OR [TransactionType]='S' OR [TransactionType]='W')
Object Production.DF_ProductReview_ModifiedDate.DF_ProductReview_ModifiedDate schema/table/default_constraint MS_Description Default constraint value of GETDATE()
Object Person.DF_BusinessEntity_rowguid.DF_BusinessEntity_rowguid schema/table/default_constraint MS_Description Default constraint value of NEWID()
Object HumanResources.FK_EmployeeDepartmentHistory_Shift_ShiftID.FK_EmployeeDepartmentHistory_Shift_ShiftID schema/table/foreign_key_constraint MS_Description Foreign key constraint referencing Shift.ShiftID
Object Production.TransactionHistoryArchive schema/table MS_Description Transactions for previous years.
Object Production.TransactionHistoryArchive.TransactionID schema/table/column MS_Description Primary key for TransactionHistoryArchive records.
Object Production.TransactionHistoryArchive.ProductID schema/table/column MS_Description Product identification number. Foreign key to Product.ProductID.
Object Production.TransactionHistoryArchive.ReferenceOrderID schema/table/column MS_Description Purchase order, sales order, or work order identification number.
Object Production.TransactionHistoryArchive.ReferenceOrderLineID schema/table/column MS_Description Line number associated with the purchase order, sales order, or work order.
Object Production.TransactionHistoryArchive.TransactionDate schema/table/column MS_Description Date and time of the transaction.
Object Production.TransactionHistoryArchive.TransactionType schema/table/column MS_Description W = Work Order, S = Sales Order, P = Purchase Order
Object Production.TransactionHistoryArchive.Quantity schema/table/column MS_Description Product quantity.
Object Production.TransactionHistoryArchive.ActualCost schema/table/column MS_Description Product cost.
Object Production.TransactionHistoryArchive.ModifiedDate schema/table/column MS_Description Date and time the record was last updated.
Object Production.CK_ProductReview_Rating.CK_ProductReview_Rating schema/table/check_constraint MS_Description Check constraint [Rating] BETWEEN (1) AND (5)
Object Person.DF_BusinessEntity_ModifiedDate.DF_BusinessEntity_ModifiedDate schema/table/default_constraint MS_Description Default constraint value of GETDATE()
Object HumanResources.FK_EmployeePayHistory_Employee_BusinessEntityID.FK_EmployeePayHistory_Employee_BusinessEntityID schema/table/foreign_key_constraint MS_Description Foreign key constraint referencing Employee.EmployeeID.
Object Production.DF_TransactionHistoryArchive_ReferenceOrderLineID.DF_TransactionHistoryArchive_ReferenceOrderLineID schema/table/default_constraint MS_Description Default constraint value of 0
Object Production.ProductSubcategory schema/table MS_Description Product subcategories. See ProductCategory table.
Object Production.ProductSubcategory.ProductSubcategoryID schema/table/column MS_Description Primary key for ProductSubcategory records.
Object Production.ProductSubcategory.ProductCategoryID schema/table/column MS_Description Product category identification number. Foreign key to ProductCategory.ProductCategoryID.
Object Production.ProductSubcategory.Name schema/table/column MS_Description Subcategory description.
Object Production.ProductSubcategory.rowguid schema/table/column MS_Description ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
Object Production.ProductSubcategory.ModifiedDate schema/table/column MS_Description Date and time the record was last updated.
Object Person.BusinessEntityAddress schema/table MS_Description Cross-reference table mapping customers, vendors, and employees to their addresses.
Object Person.BusinessEntityAddress.BusinessEntityID schema/table/column MS_Description Primary key. Foreign key to BusinessEntity.BusinessEntityID.
Object Person.BusinessEntityAddress.AddressID schema/table/column MS_Description Primary key. Foreign key to Address.AddressID.
Object Person.BusinessEntityAddress.AddressTypeID schema/table/column MS_Description Primary key. Foreign key to AddressType.AddressTypeID.
Object Person.BusinessEntityAddress.rowguid schema/table/column MS_Description ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
Object Person.BusinessEntityAddress.ModifiedDate schema/table/column MS_Description Date and time the record was last updated.
Object HumanResources.FK_JobCandidate_Employee_BusinessEntityID.FK_JobCandidate_Employee_BusinessEntityID schema/table/foreign_key_constraint MS_Description Foreign key constraint referencing Employee.EmployeeID.
Object Production.DF_TransactionHistoryArchive_TransactionDate.DF_TransactionHistoryArchive_TransactionDate schema/table/default_constraint MS_Description Default constraint value of GETDATE()
Object Production.DF_ProductSubcategory_rowguid.DF_ProductSubcategory_rowguid schema/table/default_constraint MS_Description Default constraint value of NEWID()
Object Person.DF_BusinessEntityAddress_rowguid.DF_BusinessEntityAddress_rowguid schema/table/default_constraint MS_Description Default constraint value of NEWID()
Object Person.FK_Password_Person_BusinessEntityID.FK_Password_Person_BusinessEntityID schema/table/foreign_key_constraint MS_Description Foreign key constraint referencing Person.BusinessEntityID.
Object Production.DF_TransactionHistoryArchive_ModifiedDate.DF_TransactionHistoryArchive_ModifiedDate schema/table/default_constraint MS_Description Default constraint value of GETDATE()
Object Production.DF_ProductSubcategory_ModifiedDate.DF_ProductSubcategory_ModifiedDate schema/table/default_constraint MS_Description Default constraint value of GETDATE()
Object Person.DF_BusinessEntityAddress_ModifiedDate.DF_BusinessEntityAddress_ModifiedDate schema/table/default_constraint MS_Description Default constraint value of GETDATE()
Object Person.FK_Person_BusinessEntity_BusinessEntityID.FK_Person_BusinessEntity_BusinessEntityID schema/table/foreign_key_constraint MS_Description Foreign key constraint referencing BusinessEntity.BusinessEntityID.
Object Production.CK_TransactionHistoryArchive_TransactionType.CK_TransactionHistoryArchive_TransactionType schema/table/check_constraint MS_Description Check constraint [TransactionType]='p' OR [TransactionType]='s' OR [TransactionType]='w' OR [TransactionType]='P' OR [TransactionType]='S' OR [TransactionType]='W'
Object Purchasing.ProductVendor schema/table MS_Description Cross-reference table mapping vendors with the products they supply.
Object Purchasing.ProductVendor.ProductID schema/table/column MS_Description Primary key. Foreign key to Product.ProductID.
Object Purchasing.ProductVendor.BusinessEntityID schema/table/column MS_Description Primary key. Foreign key to Vendor.BusinessEntityID.
Object Purchasing.ProductVendor.AverageLeadTime schema/table/column MS_Description The average span of time (in days) between placing an order with the vendor and receiving the purchased product.
Object Purchasing.ProductVendor.StandardPrice schema/table/column MS_Description The vendor's usual selling price.
Object Purchasing.ProductVendor.LastReceiptCost schema/table/column MS_Description The selling price when last purchased.
Object Purchasing.ProductVendor.LastReceiptDate schema/table/column MS_Description Date the product was last received by the vendor.
Object Purchasing.ProductVendor.MinOrderQty schema/table/column MS_Description The maximum quantity that should be ordered.
Object Purchasing.ProductVendor.MaxOrderQty schema/table/column MS_Description The minimum quantity that should be ordered.
Object Purchasing.ProductVendor.OnOrderQty schema/table/column MS_Description The quantity currently on order.
Object Purchasing.ProductVendor.UnitMeasureCode schema/table/column MS_Description The product's unit of measure.
Object Purchasing.ProductVendor.ModifiedDate schema/table/column MS_Description Date and time the record was last updated.
Object Person.BusinessEntityContact schema/table MS_Description Cross-reference table mapping stores, vendors, and employees to people
Object Person.BusinessEntityContact.BusinessEntityID schema/table/column MS_Description Primary key. Foreign key to BusinessEntity.BusinessEntityID.
Object Person.BusinessEntityContact.PersonID schema/table/column MS_Description Primary key. Foreign key to Person.BusinessEntityID.
Object Person.BusinessEntityContact.ContactTypeID schema/table/column MS_Description Primary key. Foreign key to ContactType.ContactTypeID.
Object Person.BusinessEntityContact.rowguid schema/table/column MS_Description ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
Object Person.BusinessEntityContact.ModifiedDate schema/table/column MS_Description Date and time the record was last updated.
Object Sales.FK_PersonCreditCard_Person_BusinessEntityID.FK_PersonCreditCard_Person_BusinessEntityID schema/table/foreign_key_constraint MS_Description Foreign key constraint referencing Person.BusinessEntityID.
Object Production.UnitMeasure schema/table MS_Description Unit of measure lookup table.
Object Production.UnitMeasure.UnitMeasureCode schema/table/column MS_Description Primary key.
Object Production.UnitMeasure.Name schema/table/column MS_Description Unit of measure description.
Object Production.UnitMeasure.ModifiedDate schema/table/column MS_Description Date and time the record was last updated.
Object Purchasing.DF_ProductVendor_ModifiedDate.DF_ProductVendor_ModifiedDate schema/table/default_constraint MS_Description Default constraint value of GETDATE()
Object Person.DF_BusinessEntityContact_rowguid.DF_BusinessEntityContact_rowguid schema/table/default_constraint MS_Description Default constraint value of NEWID()
Object Sales.FK_PersonCreditCard_CreditCard_CreditCardID.FK_PersonCreditCard_CreditCard_CreditCardID schema/table/foreign_key_constraint MS_Description Foreign key constraint referencing CreditCard.CreditCardID.
Object Production.DF_UnitMeasure_ModifiedDate.DF_UnitMeasure_ModifiedDate schema/table/default_constraint MS_Description Default constraint value of GETDATE()
Object Purchasing.CK_ProductVendor_AverageLeadTime.CK_ProductVendor_AverageLeadTime schema/table/check_constraint MS_Description Check constraint [AverageLeadTime] >= (1)
Object Person.DF_BusinessEntityContact_ModifiedDate.DF_BusinessEntityContact_ModifiedDate schema/table/default_constraint MS_Description Default constraint value of GETDATE()
Object Person.FK_PersonPhone_Person_BusinessEntityID.FK_PersonPhone_Person_BusinessEntityID schema/table/foreign_key_constraint MS_Description Foreign key constraint referencing Person.BusinessEntityID.
Object Purchasing.Vendor schema/table MS_Description Companies from whom Adventure Works Cycles purchases parts or other goods.
Object Purchasing.Vendor.BusinessEntityID schema/table/column MS_Description Primary key for Vendor records. Foreign key to BusinessEntity.BusinessEntityID
Object Purchasing.Vendor.AccountNumber schema/table/column MS_Description Vendor account (identification) number.
Object Purchasing.Vendor.Name schema/table/column MS_Description Company name.
Object Purchasing.Vendor.CreditRating schema/table/column MS_Description 1 = Superior, 2 = Excellent, 3 = Above average, 4 = Average, 5 = Below average
Object Purchasing.Vendor.PreferredVendorStatus schema/table/column MS_Description 0 = Do not use if another vendor is available. 1 = Preferred over other vendors supplying the same product.
Object Purchasing.Vendor.ActiveFlag schema/table/column MS_Description 0 = Vendor no longer used. 1 = Vendor is actively used.
Object Purchasing.Vendor.PurchasingWebServiceURL schema/table/column MS_Description Vendor URL.
Object Purchasing.Vendor.ModifiedDate schema/table/column MS_Description Date and time the record was last updated.
Object Purchasing.CK_ProductVendor_StandardPrice.CK_ProductVendor_StandardPrice schema/table/check_constraint MS_Description Check constraint [StandardPrice] > (0.00)
Object Person.ContactType schema/table MS_Description Lookup table containing the types of business entity contacts.
Object Person.ContactType.ContactTypeID schema/table/column MS_Description Primary key for ContactType records.
Object Person.ContactType.Name schema/table/column MS_Description Contact type description.
Object Person.ContactType.ModifiedDate schema/table/column MS_Description Date and time the record was last updated.
Object Person.FK_PersonPhone_PhoneNumberType_PhoneNumberTypeID.FK_PersonPhone_PhoneNumberType_PhoneNumberTypeID schema/table/foreign_key_constraint MS_Description Foreign key constraint referencing PhoneNumberType.PhoneNumberTypeID.
Object Purchasing.DF_Vendor_PreferredVendorStatus.DF_Vendor_PreferredVendorStatus schema/table/default_constraint MS_Description Default constraint value of 1 (TRUE)
Object Purchasing.CK_ProductVendor_LastReceiptCost.CK_ProductVendor_LastReceiptCost schema/table/check_constraint MS_Description Check constraint [LastReceiptCost] > (0.00)
Object Person.DF_ContactType_ModifiedDate.DF_ContactType_ModifiedDate schema/table/default_constraint MS_Description Default constraint value of GETDATE()
Object Production.FK_Product_UnitMeasure_SizeUnitMeasureCode.FK_Product_UnitMeasure_SizeUnitMeasureCode schema/table/foreign_key_constraint MS_Description Foreign key constraint referencing UnitMeasure.UnitMeasureCode.
Object Purchasing.DF_Vendor_ActiveFlag.DF_Vendor_ActiveFlag schema/table/default_constraint MS_Description Default constraint value of 1 (TRUE)
Object Purchasing.CK_ProductVendor_MinOrderQty.CK_ProductVendor_MinOrderQty schema/table/check_constraint MS_Description Check constraint [MinOrderQty] >= (1)
Object Sales.CountryRegionCurrency schema/table MS_Description Cross-reference table mapping ISO currency codes to a country or region.
Object Sales.CountryRegionCurrency.CountryRegionCode schema/table/column MS_Description ISO code for countries and regions. Foreign key to CountryRegion.CountryRegionCode.
Object Sales.CountryRegionCurrency.CurrencyCode schema/table/column MS_Description ISO standard currency code. Foreign key to Currency.CurrencyCode.
Object Sales.CountryRegionCurrency.ModifiedDate schema/table/column MS_Description Date and time the record was last updated.
Object Production.FK_Product_UnitMeasure_WeightUnitMeasureCode.FK_Product_UnitMeasure_WeightUnitMeasureCode schema/table/foreign_key_constraint MS_Description Foreign key constraint referencing UnitMeasure.UnitMeasureCode.
Object Purchasing.DF_Vendor_ModifiedDate.DF_Vendor_ModifiedDate schema/table/default_constraint MS_Description Default constraint value of GETDATE()
Object Purchasing.CK_ProductVendor_MaxOrderQty.CK_ProductVendor_MaxOrderQty schema/table/check_constraint MS_Description Check constraint [MaxOrderQty] >= (1)
Object Sales.DF_CountryRegionCurrency_ModifiedDate.DF_CountryRegionCurrency_ModifiedDate schema/table/default_constraint MS_Description Default constraint value of GETDATE()
Object Production.FK_Product_ProductModel_ProductModelID.FK_Product_ProductModel_ProductModelID schema/table/foreign_key_constraint MS_Description Foreign key constraint referencing ProductModel.ProductModelID.
Object Purchasing.CK_Vendor_CreditRating.CK_Vendor_CreditRating schema/table/check_constraint MS_Description Check constraint [CreditRating] BETWEEN (1) AND (5)
Object Purchasing.CK_ProductVendor_OnOrderQty.CK_ProductVendor_OnOrderQty schema/table/check_constraint MS_Description Check constraint [OnOrderQty] >= (0)
Object Person.CountryRegion schema/table MS_Description Lookup table containing the ISO standard codes for countries and regions.
Object Person.CountryRegion.CountryRegionCode schema/table/column MS_Description ISO standard code for countries and regions.
Object Person.CountryRegion.Name schema/table/column MS_Description Country or region name.
Object Person.CountryRegion.ModifiedDate schema/table/column MS_Description Date and time the record was last updated.
Object Production.FK_Product_ProductSubcategory_ProductSubcategoryID.FK_Product_ProductSubcategory_ProductSubcategoryID schema/table/foreign_key_constraint MS_Description Foreign key constraint referencing ProductSubcategory.ProductSubcategoryID.
Object Production.WorkOrder schema/table MS_Description Manufacturing work orders.
Object Production.WorkOrder.WorkOrderID schema/table/column MS_Description Primary key for WorkOrder records.
Object Production.WorkOrder.ProductID schema/table/column MS_Description Product identification number. Foreign key to Product.ProductID.
Object Production.WorkOrder.OrderQty schema/table/column MS_Description Product quantity to build.
Object Production.WorkOrder.StockedQty schema/table/column MS_Description Quantity built and put in inventory.
Object Production.WorkOrder.ScrappedQty schema/table/column MS_Description Quantity that failed inspection.
Object Production.WorkOrder.StartDate schema/table/column MS_Description Work order start date.
Object Production.WorkOrder.EndDate schema/table/column MS_Description Work order end date.
Object Production.WorkOrder.DueDate schema/table/column MS_Description Work order due date.
Object Production.WorkOrder.ScrapReasonID schema/table/column MS_Description Reason for inspection failure.
Object Production.WorkOrder.ModifiedDate schema/table/column MS_Description Date and time the record was last updated.
Object Purchasing.PurchaseOrderDetail schema/table MS_Description Individual products associated with a specific purchase order. See PurchaseOrderHeader.
Object Purchasing.PurchaseOrderDetail.PurchaseOrderID schema/table/column MS_Description Primary key. Foreign key to PurchaseOrderHeader.PurchaseOrderID.
Object Purchasing.PurchaseOrderDetail.PurchaseOrderDetailID schema/table/column MS_Description Primary key. One line number per purchased product.
Object Purchasing.PurchaseOrderDetail.DueDate schema/table/column MS_Description Date the product is expected to be received.
Object Purchasing.PurchaseOrderDetail.OrderQty schema/table/column MS_Description Quantity ordered.
Object Purchasing.PurchaseOrderDetail.ProductID schema/table/column MS_Description Product identification number. Foreign key to Product.ProductID.
Object Purchasing.PurchaseOrderDetail.UnitPrice schema/table/column MS_Description Vendor's selling price of a single product.
Object Purchasing.PurchaseOrderDetail.LineTotal schema/table/column MS_Description Per product subtotal. Computed as OrderQty * UnitPrice.
Object Purchasing.PurchaseOrderDetail.ReceivedQty schema/table/column MS_Description Quantity actually received from the vendor.
Object Purchasing.PurchaseOrderDetail.RejectedQty schema/table/column MS_Description Quantity rejected during inspection.
Object Purchasing.PurchaseOrderDetail.StockedQty schema/table/column MS_Description Quantity accepted into inventory. Computed as ReceivedQty - RejectedQty.
Object Purchasing.PurchaseOrderDetail.ModifiedDate schema/table/column MS_Description Date and time the record was last updated.
Object Person.DF_CountryRegion_ModifiedDate.DF_CountryRegion_ModifiedDate schema/table/default_constraint MS_Description Default constraint value of GETDATE()
Object Production.FK_ProductCostHistory_Product_ProductID.FK_ProductCostHistory_Product_ProductID schema/table/foreign_key_constraint MS_Description Foreign key constraint referencing Product.ProductID.
Object Production.DF_WorkOrder_ModifiedDate.DF_WorkOrder_ModifiedDate schema/table/default_constraint MS_Description Default constraint value of GETDATE()
Object Purchasing.DF_PurchaseOrderDetail_ModifiedDate.DF_PurchaseOrderDetail_ModifiedDate schema/table/default_constraint MS_Description Default constraint value of GETDATE()
Object Sales.CreditCard schema/table MS_Description Customer credit card information.
Object Sales.CreditCard.CreditCardID schema/table/column MS_Description Primary key for CreditCard records.
Object Sales.CreditCard.CardType schema/table/column MS_Description Credit card name.
Object Sales.CreditCard.CardNumber schema/table/column MS_Description Credit card number.
Object Sales.CreditCard.ExpMonth schema/table/column MS_Description Credit card expiration month.
Object Sales.CreditCard.ExpYear schema/table/column MS_Description Credit card expiration year.
Object Sales.CreditCard.ModifiedDate schema/table/column MS_Description Date and time the record was last updated.
Object Production.FK_ProductDocument_Product_ProductID.FK_ProductDocument_Product_ProductID schema/table/foreign_key_constraint MS_Description Foreign key constraint referencing Product.ProductID.
Object Production.CK_WorkOrder_OrderQty.CK_WorkOrder_OrderQty schema/table/check_constraint MS_Description Check constraint [OrderQty] > (0)
Object Purchasing.CK_PurchaseOrderDetail_OrderQty.CK_PurchaseOrderDetail_OrderQty schema/table/check_constraint MS_Description Check constraint [OrderQty] > (0)
Object Sales.DF_CreditCard_ModifiedDate.DF_CreditCard_ModifiedDate schema/table/default_constraint MS_Description Default constraint value of GETDATE()
Object Production.FK_ProductDocument_Document_DocumentNode.FK_ProductDocument_Document_DocumentNode schema/table/foreign_key_constraint MS_Description Foreign key constraint referencing Document.DocumentNode.
Object Production.CK_WorkOrder_ScrappedQty.CK_WorkOrder_ScrappedQty schema/table/check_constraint MS_Description Check constraint [ScrappedQty] >= (0)
Object Purchasing.CK_PurchaseOrderDetail_UnitPrice.CK_PurchaseOrderDetail_UnitPrice schema/table/check_constraint MS_Description Check constraint [UnitPrice] >= (0.00)
Object Production.Culture schema/table MS_Description Lookup table containing the languages in which some AdventureWorks data is stored.
Object Production.Culture.CultureID schema/table/column MS_Description Primary key for Culture records.
Object Production.Culture.Name schema/table/column MS_Description Culture description.
Object Production.Culture.ModifiedDate schema/table/column MS_Description Date and time the record was last updated.
Object Production.FK_ProductInventory_Location_LocationID.FK_ProductInventory_Location_LocationID schema/table/foreign_key_constraint MS_Description Foreign key constraint referencing Location.LocationID.
Object Production.CK_WorkOrder_EndDate.CK_WorkOrder_EndDate schema/table/check_constraint MS_Description Check constraint [EndDate] >= [StartDate] OR [EndDate] IS NULL
Object Purchasing.CK_PurchaseOrderDetail_ReceivedQty.CK_PurchaseOrderDetail_ReceivedQty schema/table/check_constraint MS_Description Check constraint [ReceivedQty] >= (0.00)
Object Production.DF_Culture_ModifiedDate.DF_Culture_ModifiedDate schema/table/default_constraint MS_Description Default constraint value of GETDATE()
Object Production.FK_ProductInventory_Product_ProductID.FK_ProductInventory_Product_ProductID schema/table/foreign_key_constraint MS_Description Foreign key constraint referencing Product.ProductID.
Object Production.WorkOrderRouting schema/table MS_Description Work order details.
Object Production.WorkOrderRouting.WorkOrderID schema/table/column MS_Description Primary key. Foreign key to WorkOrder.WorkOrderID.
Object Production.WorkOrderRouting.ProductID schema/table/column MS_Description Primary key. Foreign key to Product.ProductID.
Object Production.WorkOrderRouting.OperationSequence schema/table/column MS_Description Primary key. Indicates the manufacturing process sequence.
Object Production.WorkOrderRouting.LocationID schema/table/column MS_Description Manufacturing location where the part is processed. Foreign key to Location.LocationID.
Object Production.WorkOrderRouting.ScheduledStartDate schema/table/column MS_Description Planned manufacturing start date.
Object Production.WorkOrderRouting.ScheduledEndDate schema/table/column MS_Description Planned manufacturing end date.
Object Production.WorkOrderRouting.ActualStartDate schema/table/column MS_Description Actual start date.
Object Production.WorkOrderRouting.ActualEndDate schema/table/column MS_Description Actual end date.
Object Production.WorkOrderRouting.ActualResourceHrs schema/table/column MS_Description Number of manufacturing hours used.
Object Production.WorkOrderRouting.PlannedCost schema/table/column MS_Description Estimated manufacturing cost.
Object Production.WorkOrderRouting.ActualCost schema/table/column MS_Description Actual manufacturing cost.
Object Production.WorkOrderRouting.ModifiedDate schema/table/column MS_Description Date and time the record was last updated.
Object Purchasing.CK_PurchaseOrderDetail_RejectedQty.CK_PurchaseOrderDetail_RejectedQty schema/table/check_constraint MS_Description Check constraint [RejectedQty] >= (0.00)
Object Sales.Currency schema/table MS_Description Lookup table containing standard ISO currencies.
Object Sales.Currency.CurrencyCode schema/table/column MS_Description The ISO code for the Currency.
Object Sales.Currency.Name schema/table/column MS_Description Currency name.
Object Sales.Currency.ModifiedDate schema/table/column MS_Description Date and time the record was last updated.
Object Production.FK_ProductListPriceHistory_Product_ProductID.FK_ProductListPriceHistory_Product_ProductID schema/table/foreign_key_constraint MS_Description Foreign key constraint referencing Product.ProductID.
Object Production.DF_WorkOrderRouting_ModifiedDate.DF_WorkOrderRouting_ModifiedDate schema/table/default_constraint MS_Description Default constraint value of GETDATE()
Object Purchasing.PurchaseOrderHeader schema/table MS_Description General purchase order information. See PurchaseOrderDetail.
Object Purchasing.PurchaseOrderHeader.PurchaseOrderID schema/table/column MS_Description Primary key.
Object Purchasing.PurchaseOrderHeader.RevisionNumber schema/table/column MS_Description Incremental number to track changes to the purchase order over time.
Object Purchasing.PurchaseOrderHeader.Status schema/table/column MS_Description Order current status. 1 = Pending; 2 = Approved; 3 = Rejected; 4 = Complete
Object Purchasing.PurchaseOrderHeader.EmployeeID schema/table/column MS_Description Employee who created the purchase order. Foreign key to Employee.BusinessEntityID.
Object Purchasing.PurchaseOrderHeader.VendorID schema/table/column MS_Description Vendor with whom the purchase order is placed. Foreign key to Vendor.BusinessEntityID.
Object Purchasing.PurchaseOrderHeader.ShipMethodID schema/table/column MS_Description Shipping method. Foreign key to ShipMethod.ShipMethodID.
Object Purchasing.PurchaseOrderHeader.OrderDate schema/table/column MS_Description Purchase order creation date.
Object Purchasing.PurchaseOrderHeader.ShipDate schema/table/column MS_Description Estimated shipment date from the vendor.
Object Purchasing.PurchaseOrderHeader.SubTotal schema/table/column MS_Description Purchase order subtotal. Computed as SUM(PurchaseOrderDetail.LineTotal)for the appropriate PurchaseOrderID.
Object Purchasing.PurchaseOrderHeader.TaxAmt schema/table/column MS_Description Tax amount.
Object Purchasing.PurchaseOrderHeader.Freight schema/table/column MS_Description Shipping cost.
Object Purchasing.PurchaseOrderHeader.TotalDue schema/table/column MS_Description Total due to vendor. Computed as Subtotal + TaxAmt + Freight.
Object Purchasing.PurchaseOrderHeader.ModifiedDate schema/table/column MS_Description Date and time the record was last updated.
Object Sales.DF_Currency_ModifiedDate.DF_Currency_ModifiedDate schema/table/default_constraint MS_Description Default constraint value of GETDATE()
Object Production.FK_ProductModelIllustration_ProductModel_ProductModelID.FK_ProductModelIllustration_ProductModel_ProductModelID schema/table/foreign_key_constraint MS_Description Foreign key constraint referencing ProductModel.ProductModelID.
Object Production.CK_WorkOrderRouting_ScheduledEndDate.CK_WorkOrderRouting_ScheduledEndDate schema/table/check_constraint MS_Description Check constraint [ScheduledEndDate] >= [ScheduledStartDate]
Object Purchasing.DF_PurchaseOrderHeader_RevisionNumber.DF_PurchaseOrderHeader_RevisionNumber schema/table/default_constraint MS_Description Default constraint value of 0
Object Sales.CurrencyRate schema/table MS_Description Currency exchange rates.
Object Sales.CurrencyRate.CurrencyRateID schema/table/column MS_Description Primary key for CurrencyRate records.
Object Sales.CurrencyRate.CurrencyRateDate schema/table/column MS_Description Date and time the exchange rate was obtained.
Object Sales.CurrencyRate.FromCurrencyCode schema/table/column MS_Description Exchange rate was converted from this currency code.
Object Sales.CurrencyRate.ToCurrencyCode schema/table/column MS_Description Exchange rate was converted to this currency code.
Object Sales.CurrencyRate.AverageRate schema/table/column MS_Description Average exchange rate for the day.
Object Sales.CurrencyRate.EndOfDayRate schema/table/column MS_Description Final exchange rate for the day.
Object Sales.CurrencyRate.ModifiedDate schema/table/column MS_Description Date and time the record was last updated.
Object Production.FK_ProductModelIllustration_Illustration_IllustrationID.FK_ProductModelIllustration_Illustration_IllustrationID schema/table/foreign_key_constraint MS_Description Foreign key constraint referencing Illustration.IllustrationID.
Object Production.CK_WorkOrderRouting_ActualEndDate.CK_WorkOrderRouting_ActualEndDate schema/table/check_constraint MS_Description Check constraint [ActualEndDate] >= [ActualStartDate] OR [ActualEndDate] IS NULL OR [ActualStartDate] IS NULL
Object Purchasing.DF_PurchaseOrderHeader_Status.DF_PurchaseOrderHeader_Status schema/table/default_constraint MS_Description Default constraint value of 1
Object Sales.DF_CurrencyRate_ModifiedDate.DF_CurrencyRate_ModifiedDate schema/table/default_constraint MS_Description Default constraint value of GETDATE()
Object Production.FK_ProductModelProductDescriptionCulture_ProductDescription_ProductDescriptionID.FK_ProductModelProductDescriptionCulture_ProductDescription_ProductDescriptionID schema/table/foreign_key_constraint MS_Description Foreign key constraint referencing ProductDescription.ProductDescriptionID.
Object Production.CK_WorkOrderRouting_ActualResourceHrs.CK_WorkOrderRouting_ActualResourceHrs schema/table/check_constraint MS_Description Check constraint [ActualResourceHrs] >= (0.0000)
Object Purchasing.DF_PurchaseOrderHeader_OrderDate.DF_PurchaseOrderHeader_OrderDate schema/table/default_constraint MS_Description Default constraint value of GETDATE()
Object Sales.Customer schema/table MS_Description Current customer information. Also see the Person and Store tables.
Object Sales.Customer.CustomerID schema/table/column MS_Description Primary key.
Object Sales.Customer.PersonID schema/table/column MS_Description Foreign key to Person.BusinessEntityID
Object Sales.Customer.StoreID schema/table/column MS_Description Foreign key to Store.BusinessEntityID
Object Sales.Customer.TerritoryID schema/table/column MS_Description ID of the territory in which the customer is located. Foreign key to SalesTerritory.SalesTerritoryID.
Object Sales.Customer.AccountNumber schema/table/column MS_Description Unique number identifying the customer assigned by the accounting system.
Object Sales.Customer.rowguid schema/table/column MS_Description ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
Object Sales.Customer.ModifiedDate schema/table/column MS_Description Date and time the record was last updated.
Object Production.FK_ProductModelProductDescriptionCulture_Culture_CultureID.FK_ProductModelProductDescriptionCulture_Culture_CultureID schema/table/foreign_key_constraint MS_Description Foreign key constraint referencing Culture.CultureID.
Object Production.CK_WorkOrderRouting_PlannedCost.CK_WorkOrderRouting_PlannedCost schema/table/check_constraint MS_Description Check constraint [PlannedCost] > (0.00)
Object Purchasing.DF_PurchaseOrderHeader_SubTotal.DF_PurchaseOrderHeader_SubTotal schema/table/default_constraint MS_Description Default constraint value of 0.0
Object Sales.DF_Customer_rowguid.DF_Customer_rowguid schema/table/default_constraint MS_Description Default constraint value of NEWID()
Object Production.FK_ProductModelProductDescriptionCulture_ProductModel_ProductModelID.FK_ProductModelProductDescriptionCulture_ProductModel_ProductModelID schema/table/foreign_key_constraint MS_Description Foreign key constraint referencing ProductModel.ProductModelID.
Object Production.CK_WorkOrderRouting_ActualCost.CK_WorkOrderRouting_ActualCost schema/table/check_constraint MS_Description Check constraint [ActualCost] > (0.00)
Object Purchasing.DF_PurchaseOrderHeader_TaxAmt.DF_PurchaseOrderHeader_TaxAmt schema/table/default_constraint MS_Description Default constraint value of 0.0
Object Sales.DF_Customer_ModifiedDate.DF_Customer_ModifiedDate schema/table/default_constraint MS_Description Default constraint value of GETDATE()
Object Production.FK_ProductProductPhoto_Product_ProductID.FK_ProductProductPhoto_Product_ProductID schema/table/foreign_key_constraint MS_Description Foreign key constraint referencing Product.ProductID.
Object Person.PK_Address_AddressID.PK_Address_AddressID schema/table/primary_key_constraint MS_Description Primary key (clustered) constraint
Object Purchasing.DF_PurchaseOrderHeader_Freight.DF_PurchaseOrderHeader_Freight schema/table/default_constraint MS_Description Default constraint value of 0.0
Object HumanResources.Department schema/table MS_Description Lookup table containing the departments within the Adventure Works Cycles company.
Object HumanResources.Department.DepartmentID schema/table/column MS_Description Primary key for Department records.
Object HumanResources.Department.Name schema/table/column MS_Description Name of the department.
Object HumanResources.Department.GroupName schema/table/column MS_Description Name of the group to which the department belongs.
Object HumanResources.Department.ModifiedDate schema/table/column MS_Description Date and time the record was last updated.
Object Production.FK_ProductProductPhoto_ProductPhoto_ProductPhotoID.FK_ProductProductPhoto_ProductPhoto_ProductPhotoID schema/table/foreign_key_constraint MS_Description Foreign key constraint referencing ProductPhoto.ProductPhotoID.
Object Person.PK_AddressType_AddressTypeID.PK_AddressType_AddressTypeID schema/table/primary_key_constraint MS_Description Primary key (clustered) constraint
Object Purchasing.DF_PurchaseOrderHeader_ModifiedDate.DF_PurchaseOrderHeader_ModifiedDate schema/table/default_constraint MS_Description Default constraint value of GETDATE()
Object HumanResources.DF_Department_ModifiedDate.DF_Department_ModifiedDate schema/table/default_constraint MS_Description Default constraint value of GETDATE()
Object Production.FK_ProductReview_Product_ProductID.FK_ProductReview_Product_ProductID schema/table/foreign_key_constraint MS_Description Foreign key constraint referencing Product.ProductID.
Object dbo.PK_AWBuildVersion_SystemInformationID.PK_AWBuildVersion_SystemInformationID schema/table/primary_key_constraint MS_Description Primary key (clustered) constraint
Object Purchasing.CK_PurchaseOrderHeader_Status.CK_PurchaseOrderHeader_Status schema/table/check_constraint MS_Description Check constraint [Status] BETWEEN (1) AND (4)
Object Production.Document schema/table MS_Description Product maintenance documents.
Object Production.Document.DocumentNode schema/table/column MS_Description Primary key for Document records.
Object Production.Document.DocumentLevel schema/table/column MS_Description Depth in the document hierarchy.
Object Production.Document.Title schema/table/column MS_Description Title of the document.
Object Production.Document.Owner schema/table/column MS_Description Employee who controls the document. Foreign key to Employee.BusinessEntityID
Object Production.Document.FolderFlag schema/table/column MS_Description 0 = This is a folder, 1 = This is a document.
Object Production.Document.FileName schema/table/column MS_Description File name of the document
Object Production.Document.FileExtension schema/table/column MS_Description File extension indicating the document type. For example, .doc or .txt.
Object Production.Document.Revision schema/table/column MS_Description Revision number of the document.
Object Production.Document.ChangeNumber schema/table/column MS_Description Engineering change approval number.
Object Production.Document.Status schema/table/column MS_Description 1 = Pending approval, 2 = Approved, 3 = Obsolete
Object Production.Document.DocumentSummary schema/table/column MS_Description Document abstract.
Object Production.Document.Document schema/table/column MS_Description Complete document.
Object Production.Document.rowguid schema/table/column MS_Description ROWGUIDCOL number uniquely identifying the record. Required for FileStream.
Object Production.Document.ModifiedDate schema/table/column MS_Description Date and time the record was last updated.
Object Production.FK_ProductSubcategory_ProductCategory_ProductCategoryID.FK_ProductSubcategory_ProductCategory_ProductCategoryID schema/table/foreign_key_constraint MS_Description Foreign key constraint referencing ProductCategory.ProductCategoryID.
Object Production.PK_BillOfMaterials_BillOfMaterialsID.PK_BillOfMaterials_BillOfMaterialsID schema/table/primary_key_constraint MS_Description Primary key (clustered) constraint
Object Purchasing.CK_PurchaseOrderHeader_ShipDate.CK_PurchaseOrderHeader_ShipDate schema/table/check_constraint MS_Description Check constraint [ShipDate] >= [OrderDate] OR [ShipDate] IS NULL
Object Purchasing.FK_ProductVendor_Product_ProductID.FK_ProductVendor_Product_ProductID schema/table/foreign_key_constraint MS_Description Foreign key constraint referencing Product.ProductID.
Object Person.PK_BusinessEntity_BusinessEntityID.PK_BusinessEntity_BusinessEntityID schema/table/primary_key_constraint MS_Description Primary key (clustered) constraint
Object Purchasing.CK_PurchaseOrderHeader_SubTotal.CK_PurchaseOrderHeader_SubTotal schema/table/check_constraint MS_Description Check constraint [SubTotal] >= (0.00)
Object Purchasing.FK_ProductVendor_UnitMeasure_UnitMeasureCode.FK_ProductVendor_UnitMeasure_UnitMeasureCode schema/table/foreign_key_constraint MS_Description Foreign key constraint referencing UnitMeasure.UnitMeasureCode.
Object Person.PK_BusinessEntityAddress_BusinessEntityID_AddressID_AddressTypeID.PK_BusinessEntityAddress_BusinessEntityID_AddressID_AddressTypeID schema/table/primary_key_constraint MS_Description Primary key (clustered) constraint
Object Purchasing.CK_PurchaseOrderHeader_TaxAmt.CK_PurchaseOrderHeader_TaxAmt schema/table/check_constraint MS_Description Check constraint [TaxAmt] >= (0.00)
Object Production.DF_Document_ChangeNumber.DF_Document_ChangeNumber schema/table/default_constraint MS_Description Default constraint value of 0
Object Purchasing.FK_ProductVendor_Vendor_BusinessEntityID.FK_ProductVendor_Vendor_BusinessEntityID schema/table/foreign_key_constraint MS_Description Foreign key constraint referencing Vendor.BusinessEntityID.
Object Person.PK_BusinessEntityContact_BusinessEntityID_PersonID_ContactTypeID.PK_BusinessEntityContact_BusinessEntityID_PersonID_ContactTypeID schema/table/primary_key_constraint MS_Description Primary key (clustered) constraint
Object Purchasing.CK_PurchaseOrderHeader_Freight.CK_PurchaseOrderHeader_Freight schema/table/check_constraint MS_Description Check constraint [Freight] >= (0.00)
Object Production.DF_Document_rowguid.DF_Document_rowguid schema/table/default_constraint MS_Description Default constraint value of NEWID()
Object Purchasing.FK_PurchaseOrderDetail_Product_ProductID.FK_PurchaseOrderDetail_Product_ProductID schema/table/foreign_key_constraint MS_Description Foreign key constraint referencing Product.ProductID.
Object Person.PK_ContactType_ContactTypeID.PK_ContactType_ContactTypeID schema/table/primary_key_constraint MS_Description Primary key (clustered) constraint
Object Sales.SalesOrderDetail schema/table MS_Description Individual products associated with a specific sales order. See SalesOrderHeader.
Object Sales.SalesOrderDetail.SalesOrderID schema/table/column MS_Description Primary key. Foreign key to SalesOrderHeader.SalesOrderID.
Object Sales.SalesOrderDetail.SalesOrderDetailID schema/table/column MS_Description Primary key. One incremental unique number per product sold.
Object Sales.SalesOrderDetail.CarrierTrackingNumber schema/table/column MS_Description Shipment tracking number supplied by the shipper.
Object Sales.SalesOrderDetail.OrderQty schema/table/column MS_Description Quantity ordered per product.
Object Sales.SalesOrderDetail.ProductID schema/table/column MS_Description Product sold to customer. Foreign key to Product.ProductID.
Object Sales.SalesOrderDetail.SpecialOfferID schema/table/column MS_Description Promotional code. Foreign key to SpecialOffer.SpecialOfferID.
Object Sales.SalesOrderDetail.UnitPrice schema/table/column MS_Description Selling price of a single product.
Object Sales.SalesOrderDetail.UnitPriceDiscount schema/table/column MS_Description Discount amount.
Object Sales.SalesOrderDetail.LineTotal schema/table/column MS_Description Per product subtotal. Computed as UnitPrice * (1 - UnitPriceDiscount) * OrderQty.
Object Sales.SalesOrderDetail.rowguid schema/table/column MS_Description ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
Object Sales.SalesOrderDetail.ModifiedDate schema/table/column MS_Description Date and time the record was last updated.
Object Production.DF_Document_ModifiedDate.DF_Document_ModifiedDate schema/table/default_constraint MS_Description Default constraint value of GETDATE()
Object Purchasing.FK_PurchaseOrderDetail_PurchaseOrderHeader_PurchaseOrderID.FK_PurchaseOrderDetail_PurchaseOrderHeader_PurchaseOrderID schema/table/foreign_key_constraint MS_Description Foreign key constraint referencing PurchaseOrderHeader.PurchaseOrderID.
Object Sales.PK_CountryRegionCurrency_CountryRegionCode_CurrencyCode.PK_CountryRegionCurrency_CountryRegionCode_CurrencyCode schema/table/primary_key_constraint MS_Description Primary key (clustered) constraint
Object Sales.DF_SalesOrderDetail_UnitPriceDiscount.DF_SalesOrderDetail_UnitPriceDiscount schema/table/default_constraint MS_Description Default constraint value of 0.0
Object Production.CK_Document_Status.CK_Document_Status schema/table/check_constraint MS_Description Check constraint [Status] BETWEEN (1) AND (3)
Object Purchasing.FK_PurchaseOrderHeader_Employee_EmployeeID.FK_PurchaseOrderHeader_Employee_EmployeeID schema/table/foreign_key_constraint MS_Description Foreign key constraint referencing Employee.EmployeeID.
Object Person.PK_CountryRegion_CountryRegionCode.PK_CountryRegion_CountryRegionCode schema/table/primary_key_constraint MS_Description Primary key (clustered) constraint
Object Sales.DF_SalesOrderDetail_rowguid.DF_SalesOrderDetail_rowguid schema/table/default_constraint MS_Description Default constraint value of NEWID()
Object Person.EmailAddress schema/table MS_Description Where to send a person email.
Object Person.EmailAddress.BusinessEntityID schema/table/column MS_Description Primary key. Person associated with this email address. Foreign key to Person.BusinessEntityID
Object Person.EmailAddress.EmailAddressID schema/table/column MS_Description Primary key. ID of this email address.
Object Person.EmailAddress.EmailAddress schema/table/column MS_Description E-mail address for the person.
Object Person.EmailAddress.rowguid schema/table/column MS_Description ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
Object Person.EmailAddress.ModifiedDate schema/table/column MS_Description Date and time the record was last updated.
Object Purchasing.FK_PurchaseOrderHeader_Vendor_VendorID.FK_PurchaseOrderHeader_Vendor_VendorID schema/table/foreign_key_constraint MS_Description Foreign key constraint referencing Vendor.VendorID.
Object Sales.PK_CreditCard_CreditCardID.PK_CreditCard_CreditCardID schema/table/primary_key_constraint MS_Description Primary key (clustered) constraint
Object Sales.DF_SalesOrderDetail_ModifiedDate.DF_SalesOrderDetail_ModifiedDate schema/table/default_constraint MS_Description Default constraint value of GETDATE()
Object Person.DF_EmailAddress_rowguid.DF_EmailAddress_rowguid schema/table/default_constraint MS_Description Default constraint value of NEWID()
Object Purchasing.FK_PurchaseOrderHeader_ShipMethod_ShipMethodID.FK_PurchaseOrderHeader_ShipMethod_ShipMethodID schema/table/foreign_key_constraint MS_Description Foreign key constraint referencing ShipMethod.ShipMethodID.
Object Production.PK_Culture_CultureID.PK_Culture_CultureID schema/table/primary_key_constraint MS_Description Primary key (clustered) constraint
Object Sales.CK_SalesOrderDetail_OrderQty.CK_SalesOrderDetail_OrderQty schema/table/check_constraint MS_Description Check constraint [OrderQty] > (0)
Object Person.DF_EmailAddress_ModifiedDate.DF_EmailAddress_ModifiedDate schema/table/default_constraint MS_Description Default constraint value of GETDATE()
Object Sales.FK_SalesOrderDetail_SalesOrderHeader_SalesOrderID.FK_SalesOrderDetail_SalesOrderHeader_SalesOrderID schema/table/foreign_key_constraint MS_Description Foreign key constraint referencing SalesOrderHeader.PurchaseOrderID.
Object Sales.PK_Currency_CurrencyCode.PK_Currency_CurrencyCode schema/table/primary_key_constraint MS_Description Primary key (clustered) constraint
Object Sales.CK_SalesOrderDetail_UnitPrice.CK_SalesOrderDetail_UnitPrice schema/table/check_constraint MS_Description Check constraint [UnitPrice] >= (0.00)
Object HumanResources.Employee schema/table MS_Description Employee information such as salary, department, and title.
Object HumanResources.Employee.BusinessEntityID schema/table/column MS_Description Primary key for Employee records. Foreign key to BusinessEntity.BusinessEntityID.
Object HumanResources.Employee.NationalIDNumber schema/table/column MS_Description Unique national identification number such as a social security number.
Object HumanResources.Employee.LoginID schema/table/column MS_Description Network login.
Object HumanResources.Employee.OrganizationNode schema/table/column MS_Description Where the employee is located in corporate hierarchy.
Object HumanResources.Employee.OrganizationLevel schema/table/column MS_Description The depth of the employee in the corporate hierarchy.
Object HumanResources.Employee.JobTitle schema/table/column MS_Description Work title such as Buyer or Sales Representative.
Object HumanResources.Employee.BirthDate schema/table/column MS_Description Date of birth.
Object HumanResources.Employee.MaritalStatus schema/table/column MS_Description M = Married, S = Single
Object HumanResources.Employee.Gender schema/table/column MS_Description M = Male, F = Female
Object HumanResources.Employee.HireDate schema/table/column MS_Description Employee hired on this date.
Object HumanResources.Employee.SalariedFlag schema/table/column MS_Description Job classification. 0 = Hourly, not exempt from collective bargaining. 1 = Salaried, exempt from collective bargaining.
Object HumanResources.Employee.VacationHours schema/table/column MS_Description Number of available vacation hours.
Object HumanResources.Employee.SickLeaveHours schema/table/column MS_Description Number of available sick leave hours.
Object HumanResources.Employee.CurrentFlag schema/table/column MS_Description 0 = Inactive, 1 = Active
Object HumanResources.Employee.rowguid schema/table/column MS_Description ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
Object HumanResources.Employee.ModifiedDate schema/table/column MS_Description Date and time the record was last updated.
Object Sales.FK_SalesOrderDetail_SpecialOfferProduct_SpecialOfferIDProductID.FK_SalesOrderDetail_SpecialOfferProduct_SpecialOfferIDProductID schema/table/foreign_key_constraint MS_Description Foreign key constraint referencing SpecialOfferProduct.SpecialOfferIDProductID.
Object Sales.PK_CurrencyRate_CurrencyRateID.PK_CurrencyRate_CurrencyRateID schema/table/primary_key_constraint MS_Description Primary key (clustered) constraint
Object Sales.CK_SalesOrderDetail_UnitPriceDiscount.CK_SalesOrderDetail_UnitPriceDiscount schema/table/check_constraint MS_Description Check constraint [UnitPriceDiscount] >= (0.00)
Object HumanResources.DF_Employee_SalariedFlag.DF_Employee_SalariedFlag schema/table/default_constraint MS_Description Default constraint value of 1 (TRUE)
Object Sales.FK_SalesOrderHeader_Address_BillToAddressID.FK_SalesOrderHeader_Address_BillToAddressID schema/table/foreign_key_constraint MS_Description Foreign key constraint referencing Address.AddressID.
Object Sales.PK_Customer_CustomerID.PK_Customer_CustomerID schema/table/primary_key_constraint MS_Description Primary key (clustered) constraint
Object Sales.SalesOrderHeader schema/table MS_Description General sales order information.
Object Sales.SalesOrderHeader.SalesOrderID schema/table/column MS_Description Primary key.
Object Sales.SalesOrderHeader.RevisionNumber schema/table/column MS_Description Incremental number to track changes to the sales order over time.
Object Sales.SalesOrderHeader.OrderDate schema/table/column MS_Description Dates the sales order was created.
Object Sales.SalesOrderHeader.DueDate schema/table/column MS_Description Date the order is due to the customer.
Object Sales.SalesOrderHeader.ShipDate schema/table/column MS_Description Date the order was shipped to the customer.
Object Sales.SalesOrderHeader.Status schema/table/column MS_Description Order current status. 1 = In process; 2 = Approved; 3 = Backordered; 4 = Rejected; 5 = Shipped; 6 = Cancelled
Object Sales.SalesOrderHeader.OnlineOrderFlag schema/table/column MS_Description 0 = Order placed by sales person. 1 = Order placed online by customer.
Object Sales.SalesOrderHeader.SalesOrderNumber schema/table/column MS_Description Unique sales order identification number.
Object Sales.SalesOrderHeader.PurchaseOrderNumber schema/table/column MS_Description Customer purchase order number reference.
Object Sales.SalesOrderHeader.AccountNumber schema/table/column MS_Description Financial accounting number reference.
Object Sales.SalesOrderHeader.CustomerID schema/table/column MS_Description Customer identification number. Foreign key to Customer.BusinessEntityID.
Object Sales.SalesOrderHeader.SalesPersonID schema/table/column MS_Description Sales person who created the sales order. Foreign key to SalesPerson.BusinessEntityID.
Object Sales.SalesOrderHeader.TerritoryID schema/table/column MS_Description Territory in which the sale was made. Foreign key to SalesTerritory.SalesTerritoryID.
Object Sales.SalesOrderHeader.BillToAddressID schema/table/column MS_Description Customer billing address. Foreign key to Address.AddressID.
Object Sales.SalesOrderHeader.ShipToAddressID schema/table/column MS_Description Customer shipping address. Foreign key to Address.AddressID.
Object Sales.SalesOrderHeader.ShipMethodID schema/table/column MS_Description Shipping method. Foreign key to ShipMethod.ShipMethodID.
Object Sales.SalesOrderHeader.CreditCardID schema/table/column MS_Description Credit card identification number. Foreign key to CreditCard.CreditCardID.
Object Sales.SalesOrderHeader.CreditCardApprovalCode schema/table/column MS_Description Approval code provided by the credit card company.
Object Sales.SalesOrderHeader.CurrencyRateID schema/table/column MS_Description Currency exchange rate used. Foreign key to CurrencyRate.CurrencyRateID.
Object Sales.SalesOrderHeader.SubTotal schema/table/column MS_Description Sales subtotal. Computed as SUM(SalesOrderDetail.LineTotal)for the appropriate SalesOrderID.
Object Sales.SalesOrderHeader.TaxAmt schema/table/column MS_Description Tax amount.
Object Sales.SalesOrderHeader.Freight schema/table/column MS_Description Shipping cost.
Object Sales.SalesOrderHeader.TotalDue schema/table/column MS_Description Total due from customer. Computed as Subtotal + TaxAmt + Freight.
Object Sales.SalesOrderHeader.Comment schema/table/column MS_Description Sales representative comments.
Object Sales.SalesOrderHeader.rowguid schema/table/column MS_Description ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
Object Sales.SalesOrderHeader.ModifiedDate schema/table/column MS_Description Date and time the record was last updated.
Object HumanResources.DF_Employee_VacationHours.DF_Employee_VacationHours schema/table/default_constraint MS_Description Default constraint value of 0
Object Sales.FK_SalesOrderHeader_Address_ShipToAddressID.FK_SalesOrderHeader_Address_ShipToAddressID schema/table/foreign_key_constraint MS_Description Foreign key constraint referencing Address.AddressID.
Object dbo.PK_DatabaseLog_DatabaseLogID.PK_DatabaseLog_DatabaseLogID schema/table/primary_key_constraint MS_Description Primary key (nonclustered) constraint
Object Sales.DF_SalesOrderHeader_RevisionNumber.DF_SalesOrderHeader_RevisionNumber schema/table/default_constraint MS_Description Default constraint value of 0
Object HumanResources.DF_Employee_SickLeaveHours.DF_Employee_SickLeaveHours schema/table/default_constraint MS_Description Default constraint value of 0
Object Sales.FK_SalesOrderHeader_CreditCard_CreditCardID.FK_SalesOrderHeader_CreditCard_CreditCardID schema/table/foreign_key_constraint MS_Description Foreign key constraint referencing CreditCard.CreditCardID.
Object HumanResources.PK_Department_DepartmentID.PK_Department_DepartmentID schema/table/primary_key_constraint MS_Description Primary key (clustered) constraint
Object Sales.DF_SalesOrderHeader_OrderDate.DF_SalesOrderHeader_OrderDate schema/table/default_constraint MS_Description Default constraint value of GETDATE()
Object HumanResources.DF_Employee_CurrentFlag.DF_Employee_CurrentFlag schema/table/default_constraint MS_Description Default constraint value of 1
Object Sales.FK_SalesOrderHeader_CurrencyRate_CurrencyRateID.FK_SalesOrderHeader_CurrencyRate_CurrencyRateID schema/table/foreign_key_constraint MS_Description Foreign key constraint referencing CurrencyRate.CurrencyRateID.
Object Production.PK_Document_DocumentNode.PK_Document_DocumentNode schema/table/primary_key_constraint MS_Description Primary key (clustered) constraint
Object Sales.DF_SalesOrderHeader_Status.DF_SalesOrderHeader_Status schema/table/default_constraint MS_Description Default constraint value of 1
Object HumanResources.DF_Employee_rowguid.DF_Employee_rowguid schema/table/default_constraint MS_Description Default constraint value of NEWID()
Object Sales.FK_SalesOrderHeader_Customer_CustomerID.FK_SalesOrderHeader_Customer_CustomerID schema/table/foreign_key_constraint MS_Description Foreign key constraint referencing Customer.CustomerID.
Object Person.PK_EmailAddress_BusinessEntityID_EmailAddressID.PK_EmailAddress_BusinessEntityID_EmailAddressID schema/table/primary_key_constraint MS_Description Primary key (clustered) constraint
Object Sales.DF_SalesOrderHeader_OnlineOrderFlag.DF_SalesOrderHeader_OnlineOrderFlag schema/table/default_constraint MS_Description Default constraint value of 1 (TRUE)
Object HumanResources.DF_Employee_ModifiedDate.DF_Employee_ModifiedDate schema/table/default_constraint MS_Description Default constraint value of GETDATE()
Object Sales.FK_SalesOrderHeader_SalesPerson_SalesPersonID.FK_SalesOrderHeader_SalesPerson_SalesPersonID schema/table/foreign_key_constraint MS_Description Foreign key constraint referencing SalesPerson.SalesPersonID.
Object HumanResources.PK_Employee_BusinessEntityID.PK_Employee_BusinessEntityID schema/table/primary_key_constraint MS_Description Primary key (clustered) constraint
Object Sales.DF_SalesOrderHeader_SubTotal.DF_SalesOrderHeader_SubTotal schema/table/default_constraint MS_Description Default constraint value of 0.0
Object HumanResources.CK_Employee_BirthDate.CK_Employee_BirthDate schema/table/check_constraint MS_Description Check constraint [BirthDate] >= '1930-01-01' AND [BirthDate] <= dateadd(year,(-18),GETDATE())
Object Sales.FK_SalesOrderHeader_ShipMethod_ShipMethodID.FK_SalesOrderHeader_ShipMethod_ShipMethodID schema/table/foreign_key_constraint MS_Description Foreign key constraint referencing ShipMethod.ShipMethodID.
Object HumanResources.PK_EmployeeDepartmentHistory_BusinessEntityID_StartDate_DepartmentID.PK_EmployeeDepartmentHistory_BusinessEntityID_StartDate_DepartmentID schema/table/primary_key_constraint MS_Description Primary key (clustered) constraint
Object Sales.DF_SalesOrderHeader_TaxAmt.DF_SalesOrderHeader_TaxAmt schema/table/default_constraint MS_Description Default constraint value of 0.0
Object HumanResources.CK_Employee_MaritalStatus.CK_Employee_MaritalStatus schema/table/check_constraint MS_Description Check constraint [MaritalStatus]='s' OR [MaritalStatus]='m' OR [MaritalStatus]='S' OR [MaritalStatus]='M'
Object Sales.FK_SalesOrderHeader_SalesTerritory_TerritoryID.FK_SalesOrderHeader_SalesTerritory_TerritoryID schema/table/foreign_key_constraint MS_Description Foreign key constraint referencing SalesTerritory.TerritoryID.
Object HumanResources.PK_EmployeePayHistory_BusinessEntityID_RateChangeDate.PK_EmployeePayHistory_BusinessEntityID_RateChangeDate schema/table/primary_key_constraint MS_Description Primary key (clustered) constraint
Object Sales.DF_SalesOrderHeader_Freight.DF_SalesOrderHeader_Freight schema/table/default_constraint MS_Description Default constraint value of 0.0
Object HumanResources.CK_Employee_HireDate.CK_Employee_HireDate schema/table/check_constraint MS_Description Check constraint [HireDate] >= '1996-07-01' AND [HireDate] <= dateadd(day,(1),GETDATE())
Object Sales.FK_SalesOrderHeaderSalesReason_SalesReason_SalesReasonID.FK_SalesOrderHeaderSalesReason_SalesReason_SalesReasonID schema/table/foreign_key_constraint MS_Description Foreign key constraint referencing SalesReason.SalesReasonID.
Object Production.PK_Illustration_IllustrationID.PK_Illustration_IllustrationID schema/table/primary_key_constraint MS_Description Primary key (clustered) constraint
Object Sales.DF_SalesOrderHeader_rowguid.DF_SalesOrderHeader_rowguid schema/table/default_constraint MS_Description Default constraint value of NEWID()
Object HumanResources.CK_Employee_Gender.CK_Employee_Gender schema/table/check_constraint MS_Description Check constraint [Gender]='f' OR [Gender]='m' OR [Gender]='F' OR [Gender]='M'
Object Sales.FK_SalesOrderHeaderSalesReason_SalesOrderHeader_SalesOrderID.FK_SalesOrderHeaderSalesReason_SalesOrderHeader_SalesOrderID schema/table/foreign_key_constraint MS_Description Foreign key constraint referencing SalesOrderHeader.SalesOrderID.
Object HumanResources.PK_JobCandidate_JobCandidateID.PK_JobCandidate_JobCandidateID schema/table/primary_key_constraint MS_Description Primary key (clustered) constraint
Object Sales.DF_SalesOrderHeader_ModifiedDate.DF_SalesOrderHeader_ModifiedDate schema/table/default_constraint MS_Description Default constraint value of GETDATE()
Object HumanResources.CK_Employee_VacationHours.CK_Employee_VacationHours schema/table/check_constraint MS_Description Check constraint [VacationHours] >= (-40) AND [VacationHours] <= (240)
Object Sales.FK_SalesPerson_Employee_BusinessEntityID.FK_SalesPerson_Employee_BusinessEntityID schema/table/foreign_key_constraint MS_Description Foreign key constraint referencing Employee.EmployeeID.
Object Production.PK_Location_LocationID.PK_Location_LocationID schema/table/primary_key_constraint MS_Description Primary key (clustered) constraint
Object Sales.CK_SalesOrderHeader_Status.CK_SalesOrderHeader_Status schema/table/check_constraint MS_Description Check constraint [Status] BETWEEN (0) AND (8)
Object HumanResources.CK_Employee_SickLeaveHours.CK_Employee_SickLeaveHours schema/table/check_constraint MS_Description Check constraint [SickLeaveHours] >= (0) AND [SickLeaveHours] <= (120)
Object Sales.FK_SalesPerson_SalesTerritory_TerritoryID.FK_SalesPerson_SalesTerritory_TerritoryID schema/table/foreign_key_constraint MS_Description Foreign key constraint referencing SalesTerritory.TerritoryID.
Object Person.PK_Password_BusinessEntityID.PK_Password_BusinessEntityID schema/table/primary_key_constraint MS_Description Primary key (clustered) constraint
Object Sales.CK_SalesOrderHeader_DueDate.CK_SalesOrderHeader_DueDate schema/table/check_constraint MS_Description Check constraint [DueDate] >= [OrderDate]
Object HumanResources.EmployeeDepartmentHistory schema/table MS_Description Employee department transfers.
Object HumanResources.EmployeeDepartmentHistory.BusinessEntityID schema/table/column MS_Description Employee identification number. Foreign key to Employee.BusinessEntityID.
Object HumanResources.EmployeeDepartmentHistory.DepartmentID schema/table/column MS_Description Department in which the employee worked including currently. Foreign key to Department.DepartmentID.
Object HumanResources.EmployeeDepartmentHistory.ShiftID schema/table/column MS_Description Identifies which 8-hour shift the employee works. Foreign key to Shift.Shift.ID.
Object HumanResources.EmployeeDepartmentHistory.StartDate schema/table/column MS_Description Date the employee started work in the department.
Object HumanResources.EmployeeDepartmentHistory.EndDate schema/table/column MS_Description Date the employee left the department. NULL = Current department.
Object HumanResources.EmployeeDepartmentHistory.ModifiedDate schema/table/column MS_Description Date and time the record was last updated.
Object Sales.FK_SalesPersonQuotaHistory_SalesPerson_BusinessEntityID.FK_SalesPersonQuotaHistory_SalesPerson_BusinessEntityID schema/table/foreign_key_constraint MS_Description Foreign key constraint referencing SalesPerson.SalesPersonID.
Object Person.PK_Person_BusinessEntityID.PK_Person_BusinessEntityID schema/table/primary_key_constraint MS_Description Primary key (clustered) constraint
Object Sales.CK_SalesOrderHeader_ShipDate.CK_SalesOrderHeader_ShipDate schema/table/check_constraint MS_Description Check constraint [ShipDate] >= [OrderDate] OR [ShipDate] IS NULL
Object HumanResources.DF_EmployeeDepartmentHistory_ModifiedDate.DF_EmployeeDepartmentHistory_ModifiedDate schema/table/default_constraint MS_Description Default constraint value of GETDATE()
Object Sales.FK_SalesTaxRate_StateProvince_StateProvinceID.FK_SalesTaxRate_StateProvince_StateProvinceID schema/table/foreign_key_constraint MS_Description Foreign key constraint referencing StateProvince.StateProvinceID.
Object Sales.PK_PersonCreditCard_BusinessEntityID_CreditCardID.PK_PersonCreditCard_BusinessEntityID_CreditCardID schema/table/primary_key_constraint MS_Description Primary key (clustered) constraint
Object Sales.CK_SalesOrderHeader_SubTotal.CK_SalesOrderHeader_SubTotal schema/table/check_constraint MS_Description Check constraint [SubTotal] >= (0.00)
Object HumanResources.CK_EmployeeDepartmentHistory_EndDate.CK_EmployeeDepartmentHistory_EndDate schema/table/check_constraint MS_Description Check constraint [EndDate] >= [StartDate] OR [EndDate] IS NUL
Object Sales.FK_SalesTerritory_CountryRegion_CountryRegionCode.FK_SalesTerritory_CountryRegion_CountryRegionCode schema/table/foreign_key_constraint MS_Description Foreign key constraint referencing CountryRegion.CountryRegionCode.
Object Person.PK_PersonPhone_BusinessEntityID_PhoneNumber_PhoneNumberTypeID.PK_PersonPhone_BusinessEntityID_PhoneNumber_PhoneNumberTypeID schema/table/primary_key_constraint MS_Description Primary key (clustered) constraint
Object Sales.CK_SalesOrderHeader_TaxAmt.CK_SalesOrderHeader_TaxAmt schema/table/check_constraint MS_Description Check constraint [TaxAmt] >= (0.00)
Object HumanResources.EmployeePayHistory.PK_EmployeePayHistory_BusinessEntityID_RateChangeDate schema/user_table/index MS_Description Clustered index created by a primary key constraint.
Object Sales.SalesOrderHeaderSalesReason.PK_SalesOrderHeaderSalesReason_SalesOrderID_SalesReasonID schema/user_table/index MS_Description Clustered index created by a primary key constraint.
Object Sales.SalesPerson.PK_SalesPerson_BusinessEntityID schema/user_table/index MS_Description Clustered index created by a primary key constraint.
Object Sales.SalesPerson.AK_SalesPerson_rowguid schema/user_table/index MS_Description Unique nonclustered index. Used to support replication samples.
Object Production.Illustration.PK_Illustration_IllustrationID schema/user_table/index MS_Description Clustered index created by a primary key constraint.
Object HumanResources.JobCandidate.PK_JobCandidate_JobCandidateID schema/user_table/index MS_Description Clustered index created by a primary key constraint.
Object HumanResources.JobCandidate.IX_JobCandidate_BusinessEntityID schema/user_table/index MS_Description Nonclustered index.
Object Production.Location.PK_Location_LocationID schema/user_table/index MS_Description Clustered index created by a primary key constraint.
Object Production.Location.AK_Location_Name schema/user_table/index MS_Description Unique nonclustered index.
Object Person.Password.PK_Password_BusinessEntityID schema/user_table/index MS_Description Clustered index created by a primary key constraint.
Object Sales.SalesPersonQuotaHistory.PK_SalesPersonQuotaHistory_BusinessEntityID_QuotaDate schema/user_table/index MS_Description Clustered index created by a primary key constraint.
Object Sales.SalesPersonQuotaHistory.AK_SalesPersonQuotaHistory_rowguid schema/user_table/index MS_Description Unique nonclustered index. Used to support replication samples.
Object Person.Person.PK_Person_BusinessEntityID schema/user_table/index MS_Description Clustered index created by a primary key constraint.
Object Person.Person.AK_Person_rowguid schema/user_table/index MS_Description Unique nonclustered index. Used to support replication samples.
Object Person.Person.PXML_Person_AddContact schema/user_table/index MS_Description Primary XML index.
Object Person.Person.PXML_Person_Demographics schema/user_table/index MS_Description Primary XML index.
Object Person.Person.XMLPATH_Person_Demographics schema/user_table/index MS_Description Secondary XML index for path.
Object Person.Person.XMLPROPERTY_Person_Demographics schema/user_table/index MS_Description Secondary XML index for property.
Object Person.Person.XMLVALUE_Person_Demographics schema/user_table/index MS_Description Secondary XML index for value.
Object Sales.SalesReason.PK_SalesReason_SalesReasonID schema/user_table/index MS_Description Clustered index created by a primary key constraint.
Object Sales.SalesTaxRate.PK_SalesTaxRate_SalesTaxRateID schema/user_table/index MS_Description Clustered index created by a primary key constraint.
Object Sales.SalesTaxRate.AK_SalesTaxRate_StateProvinceID_TaxType schema/user_table/index MS_Description Unique nonclustered index.
Object Sales.SalesTaxRate.AK_SalesTaxRate_rowguid schema/user_table/index MS_Description Unique nonclustered index. Used to support replication samples.
Object Sales.PersonCreditCard.PK_PersonCreditCard_BusinessEntityID_CreditCardID schema/user_table/index MS_Description Clustered index created by a primary key constraint.
Object Person.PersonPhone.PK_PersonPhone_BusinessEntityID_PhoneNumber_PhoneNumberTypeID schema/user_table/index MS_Description Clustered index created by a primary key constraint.
Object Person.PersonPhone.IX_PersonPhone_PhoneNumber schema/user_table/index MS_Description Nonclustered index.
Object Sales.SalesTerritory.PK_SalesTerritory_TerritoryID schema/user_table/index MS_Description Clustered index created by a primary key constraint.
Object Sales.SalesTerritory.AK_SalesTerritory_Name schema/user_table/index MS_Description Unique nonclustered index.
Object Sales.SalesTerritory.AK_SalesTerritory_rowguid schema/user_table/index MS_Description Unique nonclustered index. Used to support replication samples.
Object Person.PhoneNumberType.PK_PhoneNumberType_PhoneNumberTypeID schema/user_table/index MS_Description Clustered index created by a primary key constraint.
Object Production.Product.PK_Product_ProductID schema/user_table/index MS_Description Clustered index created by a primary key constraint.
Object Production.Product.AK_Product_ProductNumber schema/user_table/index MS_Description Unique nonclustered index.
Object Production.Product.AK_Product_Name schema/user_table/index MS_Description Unique nonclustered index.
Object Production.Product.AK_Product_rowguid schema/user_table/index MS_Description Unique nonclustered index. Used to support replication samples.
Object Production.vProductAndDescription.IX_vProductAndDescription schema/view/index MS_Description Clustered index on the view vProductAndDescription.
Object Sales.SalesTerritoryHistory.PK_SalesTerritoryHistory_BusinessEntityID_StartDate_TerritoryID schema/user_table/index MS_Description Clustered index created by a primary key constraint.
Object Sales.SalesTerritoryHistory.AK_SalesTerritoryHistory_rowguid schema/user_table/index MS_Description Unique nonclustered index. Used to support replication samples.
Object Person.vStateProvinceCountryRegion.IX_vStateProvinceCountryRegion schema/view/index MS_Description Clustered index on the view vStateProvinceCountryRegion.
Object Production.ScrapReason.PK_ScrapReason_ScrapReasonID schema/user_table/index MS_Description Clustered index created by a primary key constraint.
Object Production.ScrapReason.AK_ScrapReason_Name schema/user_table/index MS_Description Unique nonclustered index.
Object HumanResources.Shift.PK_Shift_ShiftID schema/user_table/index MS_Description Clustered index created by a primary key constraint.
Object HumanResources.Shift.AK_Shift_Name schema/user_table/index MS_Description Unique nonclustered index.
Object HumanResources.Shift.AK_Shift_StartTime_EndTime schema/user_table/index MS_Description Unique nonclustered index.
Object Production.ProductCategory.PK_ProductCategory_ProductCategoryID schema/user_table/index MS_Description Clustered index created by a primary key constraint.
Object Production.ProductCategory.AK_ProductCategory_Name schema/user_table/index MS_Description Unique nonclustered index.
Object Production.ProductCategory.AK_ProductCategory_rowguid schema/user_table/index MS_Description Unique nonclustered index. Used to support replication samples.
Object Purchasing.ShipMethod.PK_ShipMethod_ShipMethodID schema/user_table/index MS_Description Clustered index created by a primary key constraint.
Object Purchasing.ShipMethod.AK_ShipMethod_Name schema/user_table/index MS_Description Unique nonclustered index.
Object Purchasing.ShipMethod.AK_ShipMethod_rowguid schema/user_table/index MS_Description Unique nonclustered index. Used to support replication samples.
Object Production.ProductCostHistory.PK_ProductCostHistory_ProductID_StartDate schema/user_table/index MS_Description Clustered index created by a primary key constraint.
Object Production.ProductDescription.PK_ProductDescription_ProductDescriptionID schema/user_table/index MS_Description Clustered index created by a primary key constraint.
Object Production.ProductDescription.AK_ProductDescription_rowguid schema/user_table/index MS_Description Unique nonclustered index. Used to support replication samples.
Object Sales.ShoppingCartItem.PK_ShoppingCartItem_ShoppingCartItemID schema/user_table/index MS_Description Clustered index created by a primary key constraint.
Object Sales.ShoppingCartItem.IX_ShoppingCartItem_ShoppingCartID_ProductID schema/user_table/index MS_Description Nonclustered index.
Object Production.ProductDocument.PK_ProductDocument_ProductID_DocumentNode schema/user_table/index MS_Description Clustered index created by a primary key constraint.
Object dbo.DatabaseLog.PK_DatabaseLog_DatabaseLogID schema/user_table/index MS_Description Nonclustered index created by a primary key constraint.
Object Production.ProductInventory.PK_ProductInventory_ProductID_LocationID schema/user_table/index MS_Description Clustered index created by a primary key constraint.
Object Sales.SpecialOffer.PK_SpecialOffer_SpecialOfferID schema/user_table/index MS_Description Clustered index created by a primary key constraint.
Object Sales.SpecialOffer.AK_SpecialOffer_rowguid schema/user_table/index MS_Description Unique nonclustered index. Used to support replication samples.
Object dbo.ErrorLog.PK_ErrorLog_ErrorLogID schema/user_table/index MS_Description Clustered index created by a primary key constraint.
Object Production.ProductListPriceHistory.PK_ProductListPriceHistory_ProductID_StartDate schema/user_table/index MS_Description Clustered index created by a primary key constraint.
Object Person.Address.PK_Address_AddressID schema/user_table/index MS_Description Clustered index created by a primary key constraint.
Object Person.Address.AK_Address_rowguid schema/user_table/index MS_Description Unique nonclustered index. Used to support replication samples.
Object Person.Address.IX_Address_AddressLine1_AddressLine2_City_StateProvinceID_PostalCode schema/user_table/index MS_Description Nonclustered index.
Object Person.Address.IX_Address_StateProvinceID schema/user_table/index MS_Description Nonclustered index.
Object Sales.SpecialOfferProduct.PK_SpecialOfferProduct_SpecialOfferID_ProductID schema/user_table/index MS_Description Clustered index created by a primary key constraint.
Object Sales.SpecialOfferProduct.AK_SpecialOfferProduct_rowguid schema/user_table/index MS_Description Unique nonclustered index. Used to support replication samples.
Object Sales.SpecialOfferProduct.IX_SpecialOfferProduct_ProductID schema/user_table/index MS_Description Nonclustered index.
Object Production.ProductModel.PK_ProductModel_ProductModelID schema/user_table/index MS_Description Clustered index created by a primary key constraint.
Object Production.ProductModel.AK_ProductModel_Name schema/user_table/index MS_Description Unique nonclustered index.
Object Production.ProductModel.AK_ProductModel_rowguid schema/user_table/index MS_Description Unique nonclustered index. Used to support replication samples.
Object Production.ProductModel.PXML_ProductModel_CatalogDescription schema/user_table/index MS_Description Primary XML index.
Object Production.ProductModel.PXML_ProductModel_Instructions schema/user_table/index MS_Description Primary XML index.
Object Person.AddressType.PK_AddressType_AddressTypeID schema/user_table/index MS_Description Clustered index created by a primary key constraint.
Object Person.AddressType.AK_AddressType_rowguid schema/user_table/index MS_Description Unique nonclustered index. Used to support replication samples.
Object Person.AddressType.AK_AddressType_Name schema/user_table/index MS_Description Unique nonclustered index.
Object Person.StateProvince.PK_StateProvince_StateProvinceID schema/user_table/index MS_Description Clustered index created by a primary key constraint.
Object Person.StateProvince.AK_StateProvince_Name schema/user_table/index MS_Description Unique nonclustered index.
Object Person.StateProvince.AK_StateProvince_StateProvinceCode_CountryRegionCode schema/user_table/index MS_Description Unique nonclustered index.
Object Person.StateProvince.AK_StateProvince_rowguid schema/user_table/index MS_Description Unique nonclustered index. Used to support replication samples.
Object Production.ProductModelIllustration.PK_ProductModelIllustration_ProductModelID_IllustrationID schema/user_table/index MS_Description Clustered index created by a primary key constraint.
Object dbo.AWBuildVersion.PK_AWBuildVersion_SystemInformationID schema/user_table/index MS_Description Clustered index created by a primary key constraint.
Object Production.ProductModelProductDescriptionCulture.PK_ProductModelProductDescriptionCulture_ProductModelID_ProductDescriptionID_CultureID schema/user_table/index MS_Description Clustered index created by a primary key constraint.
Object Production.BillOfMaterials.AK_BillOfMaterials_ProductAssemblyID_ComponentID_StartDate schema/user_table/index MS_Description Clustered index.
Object Production.BillOfMaterials.PK_BillOfMaterials_BillOfMaterialsID schema/user_table/index MS_Description Nonclustered index created by a primary key constraint.
Object Production.BillOfMaterials.IX_BillOfMaterials_UnitMeasureCode schema/user_table/index MS_Description Nonclustered index.
Object Sales.Store.PK_Store_BusinessEntityID schema/user_table/index MS_Description Clustered index created by a primary key constraint.
Object Sales.Store.AK_Store_rowguid schema/user_table/index MS_Description Unique nonclustered index. Used to support replication samples.
Object Sales.Store.IX_Store_SalesPersonID schema/user_table/index MS_Description Nonclustered index.
Object Sales.Store.PXML_Store_Demographics schema/user_table/index MS_Description Primary XML index.
Object Production.ProductPhoto.PK_ProductPhoto_ProductPhotoID schema/user_table/index MS_Description Clustered index created by a primary key constraint.
Object Production.ProductProductPhoto.PK_ProductProductPhoto_ProductID_ProductPhotoID schema/user_table/index MS_Description Nonclustered index created by a primary key constraint.
Object Production.TransactionHistory.PK_TransactionHistory_TransactionID schema/user_table/index MS_Description Clustered index created by a primary key constraint.
Object Production.TransactionHistory.IX_TransactionHistory_ProductID schema/user_table/index MS_Description Nonclustered index.
Object Production.TransactionHistory.IX_TransactionHistory_ReferenceOrderID_ReferenceOrderLineID schema/user_table/index MS_Description Nonclustered index.
Object Production.ProductReview.PK_ProductReview_ProductReviewID schema/user_table/index MS_Description Clustered index created by a primary key constraint.
Object Production.ProductReview.IX_ProductReview_ProductID_Name schema/user_table/index MS_Description Nonclustered index.
Object Person.BusinessEntity.PK_BusinessEntity_BusinessEntityID schema/user_table/index MS_Description Clustered index created by a primary key constraint.
Object Person.BusinessEntity.AK_BusinessEntity_rowguid schema/user_table/index MS_Description Unique nonclustered index. Used to support replication samples.
Object Production.TransactionHistoryArchive.PK_TransactionHistoryArchive_TransactionID schema/user_table/index MS_Description Clustered index created by a primary key constraint.
Object Production.TransactionHistoryArchive.IX_TransactionHistoryArchive_ProductID schema/user_table/index MS_Description Nonclustered index.
Object Production.TransactionHistoryArchive.IX_TransactionHistoryArchive_ReferenceOrderID_ReferenceOrderLineID schema/user_table/index MS_Description Nonclustered index.
Object Production.ProductSubcategory.PK_ProductSubcategory_ProductSubcategoryID schema/user_table/index MS_Description Clustered index created by a primary key constraint.
Object Production.ProductSubcategory.AK_ProductSubcategory_Name schema/user_table/index MS_Description Unique nonclustered index.
Object Production.ProductSubcategory.AK_ProductSubcategory_rowguid schema/user_table/index MS_Description Unique nonclustered index. Used to support replication samples.
Object Person.BusinessEntityAddress.PK_BusinessEntityAddress_BusinessEntityID_AddressID_AddressTypeID schema/user_table/index MS_Description Clustered index created by a primary key constraint.
Object Person.BusinessEntityAddress.AK_BusinessEntityAddress_rowguid schema/user_table/index MS_Description Unique nonclustered index. Used to support replication samples.
Object Person.BusinessEntityAddress.IX_BusinessEntityAddress_AddressID schema/user_table/index MS_Description Nonclustered index.
Object Person.BusinessEntityAddress.IX_BusinessEntityAddress_AddressTypeID schema/user_table/index MS_Description Nonclustered index.
Object Purchasing.ProductVendor.PK_ProductVendor_ProductID_BusinessEntityID schema/user_table/index MS_Description Clustered index created by a primary key constraint.
Object Purchasing.ProductVendor.IX_ProductVendor_UnitMeasureCode schema/user_table/index MS_Description Nonclustered index.
Object Purchasing.ProductVendor.IX_ProductVendor_BusinessEntityID schema/user_table/index MS_Description Nonclustered index.
Object Person.BusinessEntityContact.PK_BusinessEntityContact_BusinessEntityID_PersonID_ContactTypeID schema/user_table/index MS_Description Clustered index created by a primary key constraint.
Object Person.BusinessEntityContact.AK_BusinessEntityContact_rowguid schema/user_table/index MS_Description Unique nonclustered index. Used to support replication samples.
Object Person.BusinessEntityContact.IX_BusinessEntityContact_PersonID schema/user_table/index MS_Description Nonclustered index.
Object Person.BusinessEntityContact.IX_BusinessEntityContact_ContactTypeID schema/user_table/index MS_Description Nonclustered index.
Object Production.UnitMeasure.PK_UnitMeasure_UnitMeasureCode schema/user_table/index MS_Description Clustered index created by a primary key constraint.
Object Production.UnitMeasure.AK_UnitMeasure_Name schema/user_table/index MS_Description Unique nonclustered index.
Object Purchasing.Vendor.PK_Vendor_BusinessEntityID schema/user_table/index MS_Description Clustered index created by a primary key constraint.
Object Purchasing.Vendor.AK_Vendor_AccountNumber schema/user_table/index MS_Description Unique nonclustered index.
Object Person.ContactType.PK_ContactType_ContactTypeID schema/user_table/index MS_Description Clustered index created by a primary key constraint.
Object Person.ContactType.AK_ContactType_Name schema/user_table/index MS_Description Unique nonclustered index.
Object Sales.CountryRegionCurrency.PK_CountryRegionCurrency_CountryRegionCode_CurrencyCode schema/user_table/index MS_Description Clustered index created by a primary key constraint.
Object Sales.CountryRegionCurrency.IX_CountryRegionCurrency_CurrencyCode schema/user_table/index MS_Description Nonclustered index.
Object Person.CountryRegion.PK_CountryRegion_CountryRegionCode schema/user_table/index MS_Description Clustered index created by a primary key constraint.
Object Person.CountryRegion.AK_CountryRegion_Name schema/user_table/index MS_Description Unique nonclustered index.
Object Production.WorkOrder.PK_WorkOrder_WorkOrderID schema/user_table/index MS_Description Clustered index created by a primary key constraint.
Object Production.WorkOrder.IX_WorkOrder_ScrapReasonID schema/user_table/index MS_Description Nonclustered index.
Object Production.WorkOrder.IX_WorkOrder_ProductID schema/user_table/index MS_Description Nonclustered index.
Object Purchasing.PurchaseOrderDetail.PK_PurchaseOrderDetail_PurchaseOrderID_PurchaseOrderDetailID schema/user_table/index MS_Description Clustered index created by a primary key constraint.
Object Purchasing.PurchaseOrderDetail.IX_PurchaseOrderDetail_ProductID schema/user_table/index MS_Description Nonclustered index.
Object Sales.CreditCard.PK_CreditCard_CreditCardID schema/user_table/index MS_Description Clustered index created by a primary key constraint.
Object Sales.CreditCard.AK_CreditCard_CardNumber schema/user_table/index MS_Description Unique nonclustered index.
Object Production.Culture.PK_Culture_CultureID schema/user_table/index MS_Description Clustered index created by a primary key constraint.
Object Production.Culture.AK_Culture_Name schema/user_table/index MS_Description Unique nonclustered index.
Object Production.WorkOrderRouting.PK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequence schema/user_table/index MS_Description Clustered index created by a primary key constraint.
Object Production.WorkOrderRouting.IX_WorkOrderRouting_ProductID schema/user_table/index MS_Description Nonclustered index.
Object Sales.Currency.PK_Currency_CurrencyCode schema/user_table/index MS_Description Clustered index created by a primary key constraint.
Object Sales.Currency.AK_Currency_Name schema/user_table/index MS_Description Unique nonclustered index.
Object Purchasing.PurchaseOrderHeader.PK_PurchaseOrderHeader_PurchaseOrderID schema/user_table/index MS_Description Clustered index created by a primary key constraint.
Object Purchasing.PurchaseOrderHeader.IX_PurchaseOrderHeader_VendorID schema/user_table/index MS_Description Nonclustered index.
Object Purchasing.PurchaseOrderHeader.IX_PurchaseOrderHeader_EmployeeID schema/user_table/index MS_Description Nonclustered index.
Object Sales.CurrencyRate.PK_CurrencyRate_CurrencyRateID schema/user_table/index MS_Description Clustered index created by a primary key constraint.
Object Sales.CurrencyRate.AK_CurrencyRate_CurrencyRateDate_FromCurrencyCode_ToCurrencyCode schema/user_table/index MS_Description Unique nonclustered index.
Object Sales.Customer.PK_Customer_CustomerID schema/user_table/index MS_Description Clustered index created by a primary key constraint.
Object Sales.Customer.AK_Customer_rowguid schema/user_table/index MS_Description Unique nonclustered index. Used to support replication samples.
Object Sales.Customer.AK_Customer_AccountNumber schema/user_table/index MS_Description Unique nonclustered index.
Object Sales.Customer.IX_Customer_TerritoryID schema/user_table/index MS_Description Nonclustered index.
Object HumanResources.Department.PK_Department_DepartmentID schema/user_table/index MS_Description Clustered index created by a primary key constraint.
Object HumanResources.Department.AK_Department_Name schema/user_table/index MS_Description Unique nonclustered index.
Object Production.Document.PK_Document_DocumentNode schema/user_table/index MS_Description Clustered index created by a primary key constraint.
Object Production.Document.AK_Document_DocumentLevel_DocumentNode schema/user_table/index MS_Description Unique nonclustered index.
Object Production.Document.AK_Document_rowguid schema/user_table/index MS_Description Unique nonclustered index. Used to support FileStream.
Object Production.Document.IX_Document_FileName_Revision schema/user_table/index MS_Description Unique nonclustered index.
Object Sales.SalesOrderDetail.PK_SalesOrderDetail_SalesOrderID_SalesOrderDetailID schema/user_table/index MS_Description Clustered index created by a primary key constraint.
Object Sales.SalesOrderDetail.AK_SalesOrderDetail_rowguid schema/user_table/index MS_Description Unique nonclustered index. Used to support replication samples.
Object Sales.SalesOrderDetail.IX_SalesOrderDetail_ProductID schema/user_table/index MS_Description Nonclustered index.
Object Person.EmailAddress.PK_EmailAddress_BusinessEntityID_EmailAddressID schema/user_table/index MS_Description Clustered index created by a primary key constraint.
Object Person.EmailAddress.IX_EmailAddress_EmailAddress schema/user_table/index MS_Description Nonclustered index.
Object HumanResources.Employee.PK_Employee_BusinessEntityID schema/user_table/index MS_Description Clustered index created by a primary key constraint.
Object HumanResources.Employee.IX_Employee_OrganizationNode schema/user_table/index MS_Description Unique nonclustered index.
Object HumanResources.Employee.IX_Employee_OrganizationLevel_OrganizationNode schema/user_table/index MS_Description Unique nonclustered index.
Object HumanResources.Employee.AK_Employee_LoginID schema/user_table/index MS_Description Unique nonclustered index.
Object HumanResources.Employee.AK_Employee_NationalIDNumber schema/user_table/index MS_Description Unique nonclustered index.
Object HumanResources.Employee.AK_Employee_rowguid schema/user_table/index MS_Description Unique nonclustered index. Used to support replication samples.
Object Sales.SalesOrderHeader.PK_SalesOrderHeader_SalesOrderID schema/user_table/index MS_Description Clustered index created by a primary key constraint.
Object Sales.SalesOrderHeader.AK_SalesOrderHeader_rowguid schema/user_table/index MS_Description Unique nonclustered index. Used to support replication samples.
Object Sales.SalesOrderHeader.AK_SalesOrderHeader_SalesOrderNumber schema/user_table/index MS_Description Unique nonclustered index.
Object Sales.SalesOrderHeader.IX_SalesOrderHeader_CustomerID schema/user_table/index MS_Description Nonclustered index.
Object Sales.SalesOrderHeader.IX_SalesOrderHeader_SalesPersonID schema/user_table/index MS_Description Nonclustered index.
Object HumanResources.EmployeeDepartmentHistory.PK_EmployeeDepartmentHistory_BusinessEntityID_StartDate_DepartmentID schema/user_table/index MS_Description Clustered index created by a primary key constraint.
Object HumanResources.EmployeeDepartmentHistory.IX_EmployeeDepartmentHistory_DepartmentID schema/user_table/index MS_Description Nonclustered index.
Object HumanResources.EmployeeDepartmentHistory.IX_EmployeeDepartmentHistory_ShiftID schema/user_table/index MS_Description Nonclustered index.
Object dbo.ufnGetContactInformation.@PersonID schema/sql_table_valued_function/parameter MS_Description Input parameter for the table value function ufnGetContactInformation. Enter a valid PersonID from the Person.Contact table.
Object dbo.ufnGetProductDealerPrice.@OrderDate schema/sql_scalar_function/parameter MS_Description Input parameter for the scalar function ufnGetProductDealerPrice. Enter a valid order date.
Object dbo.ufnGetProductDealerPrice.@ProductID schema/sql_scalar_function/parameter MS_Description Input parameter for the scalar function ufnGetProductDealerPrice. Enter a valid ProductID from the Production.Product table.
Object dbo.ufnGetProductListPrice.@OrderDate schema/sql_scalar_function/parameter MS_Description Input parameter for the scalar function ufnGetProductListPrice. Enter a valid order date.
Object dbo.ufnGetProductListPrice.@ProductID schema/sql_scalar_function/parameter MS_Description Input parameter for the scalar function ufnGetProductListPrice. Enter a valid ProductID from the Production.Product table.
Object dbo.ufnGetProductStandardCost.@OrderDate schema/sql_scalar_function/parameter MS_Description Input parameter for the scalar function ufnGetProductStandardCost. Enter a valid order date.
Object dbo.ufnGetProductStandardCost.@ProductID schema/sql_scalar_function/parameter MS_Description Input parameter for the scalar function ufnGetProductStandardCost. Enter a valid ProductID from the Production.Product table.
Object dbo.ufnGetStock.@ProductID schema/sql_scalar_function/parameter MS_Description Input parameter for the scalar function ufnGetStock. Enter a valid ProductID from the Production.ProductInventory table.
Object dbo.ufnGetDocumentStatusText.@Status schema/sql_scalar_function/parameter MS_Description Input parameter for the scalar function ufnGetDocumentStatusText. Enter a valid integer.
Object dbo.ufnGetPurchaseOrderStatusText.@Status schema/sql_scalar_function/parameter MS_Description Input parameter for the scalar function ufnGetPurchaseOrdertStatusText. Enter a valid integer.
Object dbo.ufnGetSalesOrderStatusText.@Status schema/sql_scalar_function/parameter MS_Description Input parameter for the scalar function ufnGetSalesOrderStatusText. Enter a valid integer.
Object dbo.uspGetBillOfMaterials.@CheckDate schema/sql_stored_procedure/parameter MS_Description Input parameter for the stored procedure uspGetBillOfMaterials used to eliminate components not used after that date. Enter a valid date.
Object dbo.uspGetBillOfMaterials.@StartProductID schema/sql_stored_procedure/parameter MS_Description Input parameter for the stored procedure uspGetBillOfMaterials. Enter a valid ProductID from the Production.Product table.
Object dbo.uspGetEmployeeManagers.@BusinessEntityID schema/sql_stored_procedure/parameter MS_Description Input parameter for the stored procedure uspGetEmployeeManagers. Enter a valid BusinessEntityID from the HumanResources.Employee table.
Object dbo.uspGetManagerEmployees.@BusinessEntityID schema/sql_stored_procedure/parameter MS_Description Input parameter for the stored procedure uspGetManagerEmployees. Enter a valid BusinessEntityID of the manager from the HumanResources.Employee table.
Object dbo.uspGetWhereUsedProductID.@CheckDate schema/sql_stored_procedure/parameter MS_Description Input parameter for the stored procedure uspGetWhereUsedProductID used to eliminate components not used after that date. Enter a valid date.
Object dbo.uspGetWhereUsedProductID.@StartProductID schema/sql_stored_procedure/parameter MS_Description Input parameter for the stored procedure uspGetWhereUsedProductID. Enter a valid ProductID from the Production.Product table.
Object HumanResources.uspUpdateEmployeeHireInfo.@BusinessEntityID schema/sql_stored_procedure/parameter MS_Description Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter a valid BusinessEntityID from the Employee table.
Object HumanResources.uspUpdateEmployeeHireInfo.@CurrentFlag schema/sql_stored_procedure/parameter MS_Description Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter the current flag for the employee.
Object HumanResources.uspUpdateEmployeeHireInfo.@HireDate schema/sql_stored_procedure/parameter MS_Description Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter a hire date for the employee.
Object HumanResources.uspUpdateEmployeeHireInfo.@JobTitle schema/sql_stored_procedure/parameter MS_Description Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter a title for the employee.
Object HumanResources.uspUpdateEmployeeHireInfo.@PayFrequency schema/sql_stored_procedure/parameter MS_Description Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter the pay frequency for the employee.
Object HumanResources.uspUpdateEmployeeHireInfo.@Rate schema/sql_stored_procedure/parameter MS_Description Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter the new rate for the employee.
Object HumanResources.uspUpdateEmployeeHireInfo.@RateChangeDate schema/sql_stored_procedure/parameter MS_Description Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter the date the rate changed for the employee.
Object HumanResources.uspUpdateEmployeeLogin.@BusinessEntityID schema/sql_stored_procedure/parameter MS_Description Input parameter for the stored procedure uspUpdateEmployeeLogin. Enter a valid EmployeeID from the Employee table.
Object HumanResources.uspUpdateEmployeeLogin.@CurrentFlag schema/sql_stored_procedure/parameter MS_Description Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter the current flag for the employee.
Object HumanResources.uspUpdateEmployeeLogin.@HireDate schema/sql_stored_procedure/parameter MS_Description Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter a hire date for the employee.
Object HumanResources.uspUpdateEmployeeLogin.@JobTitle schema/sql_stored_procedure/parameter MS_Description Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter a title for the employee.
Object HumanResources.uspUpdateEmployeeLogin.@LoginID schema/sql_stored_procedure/parameter MS_Description Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter a valid login for the employee.
Object HumanResources.uspUpdateEmployeeLogin.@OrganizationNode schema/sql_stored_procedure/parameter MS_Description Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter a valid ManagerID for the employee.
Object HumanResources.uspUpdateEmployeePersonalInfo.@BirthDate schema/sql_stored_procedure/parameter MS_Description Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter a birth date for the employee.
Object HumanResources.uspUpdateEmployeePersonalInfo.@BusinessEntityID schema/sql_stored_procedure/parameter MS_Description Input parameter for the stored procedure uspUpdateEmployeePersonalInfo. Enter a valid BusinessEntityID from the HumanResources.Employee table.
Object HumanResources.uspUpdateEmployeePersonalInfo.@Gender schema/sql_stored_procedure/parameter MS_Description Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter a gender for the employee.
Object HumanResources.uspUpdateEmployeePersonalInfo.@MaritalStatus schema/sql_stored_procedure/parameter MS_Description Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter a marital status for the employee.
Object HumanResources.uspUpdateEmployeePersonalInfo.@NationalIDNumber schema/sql_stored_procedure/parameter MS_Description Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter a national ID for the employee.
Object dbo.uspLogError.@ErrorLogID schema/sql_stored_procedure/parameter MS_Description Output parameter for the stored procedure uspLogError. Contains the ErrorLogID value corresponding to the row inserted by uspLogError in the ErrorLog table.
Object dbo.ufnLeadingZeros.@Value schema/sql_scalar_function/parameter MS_Description Input parameter for the scalar function ufnLeadingZeros. Enter a valid integer.
Object HumanResources schema MS_Description Contains objects related to employees and departments.
Object Person schema MS_Description Contains objects related to names and addresses of customers, vendors, and employees
Object Production schema MS_Description Contains objects related to products, inventory, and manufacturing.
Object Purchasing schema MS_Description Contains objects related to vendors and purchase orders.
Object Sales schema MS_Description Contains objects related to customers, sales orders, and sales territories.
Database CommonDBServer1 DataBase MS_Description AdventureWorks 2016 Sample OLTP Database
Object Person.AdditionalContactInfoSchemaCollection schema/xml_Schema_collection MS_Description Collection of XML schemas for the AdditionalContactInfo column in the Person.Contact table.
Object Person.IndividualSurveySchemaCollection schema/xml_Schema_collection MS_Description Collection of XML schemas for the Demographics column in the Person.Person table.
Object HumanResources.HRResumeSchemaCollection schema/xml_Schema_collection MS_Description Collection of XML schemas for the Resume column in the HumanResources.JobCandidate table.
Object Production.ProductDescriptionSchemaCollection schema/xml_Schema_collection MS_Description Collection of XML schemas for the CatalogDescription column in the Production.ProductModel table.
Object Production.ManuInstructionsSchemaCollection schema/xml_Schema_collection MS_Description Collection of XML schemas for the Instructions column in the Production.ProductModel table.
Object Sales.StoreSurveySchemaCollection schema/xml_Schema_collection MS_Description Collection of XML schemas for the Demographics column in the Sales.Store table.
Object PRIMARY dataspace MS_Description Primary filegroup for the AdventureWorks 2016 sample database.

Incomplete/Incorrect Documentation

DBName Issue ObjectDesc ObjectCount ObjectName
AdventureWorks2017 Purpose Missing [Purpose] Database 1 AdventureWorks2017
AdventureWorks2017 Purpose Missing [Purpose] SQL_SCALAR_FUNCTION 10 dbo.ufnGetAccountingEndDate, dbo.ufnGetAccountingStartDate, dbo.ufnGetDocumentStatusText, dbo.ufnGetProductDealerPrice, dbo.ufnGetProductListPrice, dbo.ufnGetProductStandardCost, dbo.ufnGetPurchaseOrderStatusText, dbo.ufnGetSalesOrderStatusText, dbo.ufnGetStock, dbo.ufnLeadingZeros
AdventureWorks2017 Purpose Missing [Purpose] SQL_STORED_PROCEDURE 9 dbo.uspGetEmployeeManagers, dbo.uspGetManagerEmployees, dbo.uspGetWhereUsedProductID, dbo.uspLogError, dbo.uspPrintError, dbo.uspSearchCandidateResumes, HumanResources.uspUpdateEmployeeHireInfo, HumanResources.uspUpdateEmployeeLogin, HumanResources.uspUpdateEmployeePersonalInfo
AdventureWorks2017 Purpose Missing [Purpose] SQL_TABLE_VALUED_FUNCTION 1 dbo.ufnGetContactInformation
AdventureWorks2017 Purpose Missing [Purpose] SQL_TRIGGER 11 HumanResources.dEmployee, HumanResources.trg_Employee, Person.iuPerson, Production.iWorkOrder, Production.uWorkOrder, Purchasing.dVendor, Purchasing.iPurchaseOrderDetail, Purchasing.uPurchaseOrderDetail, Purchasing.uPurchaseOrderHeader, Sales.iduSalesOrderDetail, Sales.uSalesOrderHeader
AdventureWorks2017 Purpose Missing [Purpose] VIEW 20 HumanResources.vEmployee, HumanResources.vEmployeeDepartment, HumanResources.vEmployeeDepartmentHistory, HumanResources.vJobCandidate, HumanResources.vJobCandidateEducation, HumanResources.vJobCandidateEmployment, Person.vAdditionalContactInfo, Person.vStateProvinceCountryRegion, Production.vProductAndDescription, Production.vProductModelCatalogDescription, Production.vProductModelInstructions, Purchasing.vVendorWithAddresses, Purchasing.vVendorWithContacts, Sales.vIndividualCustomer, Sales.vPersonDemographics, Sales.vSalesPerson, Sales.vSalesPersonSalesByFiscalYears, Sales.vStoreWithAddresses, Sales.vStoreWithContacts, Sales.vStoreWithDemographics
AdventureWorks2017 Process Mapping Missing [ProcessMapping] Database 1 AdventureWorks2017
AdventureWorks2017 Process Mapping Missing [ProcessMapping] SQL_SCALAR_FUNCTION 10 dbo.ufnGetAccountingEndDate, dbo.ufnGetAccountingStartDate, dbo.ufnGetDocumentStatusText, dbo.ufnGetProductDealerPrice, dbo.ufnGetProductListPrice, dbo.ufnGetProductStandardCost, dbo.ufnGetPurchaseOrderStatusText, dbo.ufnGetSalesOrderStatusText, dbo.ufnGetStock, dbo.ufnLeadingZeros
AdventureWorks2017 Process Mapping Missing [ProcessMapping] SQL_STORED_PROCEDURE 11 dbo.Usp_MyStoredProc, dbo.uspGetBillOfMaterials, dbo.uspGetEmployeeManagers, dbo.uspGetManagerEmployees, dbo.uspGetWhereUsedProductID, dbo.uspLogError, dbo.uspPrintError, dbo.uspSearchCandidateResumes, HumanResources.uspUpdateEmployeeHireInfo, HumanResources.uspUpdateEmployeeLogin, HumanResources.uspUpdateEmployeePersonalInfo
AdventureWorks2017 Process Mapping Missing [ProcessMapping] SQL_TABLE_VALUED_FUNCTION 1 dbo.ufnGetContactInformation
AdventureWorks2017 Process Mapping Missing [ProcessMapping] SQL_TRIGGER 11 HumanResources.dEmployee, HumanResources.trg_Employee, Person.iuPerson, Production.iWorkOrder, Production.uWorkOrder, Purchasing.dVendor, Purchasing.iPurchaseOrderDetail, Purchasing.uPurchaseOrderDetail, Purchasing.uPurchaseOrderHeader, Sales.iduSalesOrderDetail, Sales.uSalesOrderHeader
AdventureWorks2017 Process Mapping Missing [ProcessMapping] VIEW 20 HumanResources.vEmployee, HumanResources.vEmployeeDepartment, HumanResources.vEmployeeDepartmentHistory, HumanResources.vJobCandidate, HumanResources.vJobCandidateEducation, HumanResources.vJobCandidateEmployment, Person.vAdditionalContactInfo, Person.vStateProvinceCountryRegion, Production.vProductAndDescription, Production.vProductModelCatalogDescription, Production.vProductModelInstructions, Purchasing.vVendorWithAddresses, Purchasing.vVendorWithContacts, Sales.vIndividualCustomer, Sales.vPersonDemographics, Sales.vSalesPerson, Sales.vSalesPersonSalesByFiscalYears, Sales.vStoreWithAddresses, Sales.vStoreWithContacts, Sales.vStoreWithDemographics
AdventureWorks2017 Last Modified By Missing [LastModifiedBy] SQL_SCALAR_FUNCTION 10 dbo.ufnGetAccountingEndDate, dbo.ufnGetAccountingStartDate, dbo.ufnGetDocumentStatusText, dbo.ufnGetProductDealerPrice, dbo.ufnGetProductListPrice, dbo.ufnGetProductStandardCost, dbo.ufnGetPurchaseOrderStatusText, dbo.ufnGetSalesOrderStatusText, dbo.ufnGetStock, dbo.ufnLeadingZeros
AdventureWorks2017 Last Modified By Missing [LastModifiedBy] SQL_STORED_PROCEDURE 11 dbo.Usp_MyStoredProc, dbo.uspGetBillOfMaterials, dbo.uspGetEmployeeManagers, dbo.uspGetManagerEmployees, dbo.uspGetWhereUsedProductID, dbo.uspLogError, dbo.uspPrintError, dbo.uspSearchCandidateResumes, HumanResources.uspUpdateEmployeeHireInfo, HumanResources.uspUpdateEmployeeLogin, HumanResources.uspUpdateEmployeePersonalInfo
AdventureWorks2017 Last Modified By Missing [LastModifiedBy] SQL_TABLE_VALUED_FUNCTION 1 dbo.ufnGetContactInformation
AdventureWorks2017 Last Modified By Missing [LastModifiedBy] SQL_TRIGGER 11 HumanResources.dEmployee, HumanResources.trg_Employee, Person.iuPerson, Production.iWorkOrder, Production.uWorkOrder, Purchasing.dVendor, Purchasing.iPurchaseOrderDetail, Purchasing.uPurchaseOrderDetail, Purchasing.uPurchaseOrderHeader, Sales.iduSalesOrderDetail, Sales.uSalesOrderHeader
AdventureWorks2017 Last Modified By Missing [LastModifiedBy] VIEW 20 HumanResources.vEmployee, HumanResources.vEmployeeDepartment, HumanResources.vEmployeeDepartmentHistory, HumanResources.vJobCandidate, HumanResources.vJobCandidateEducation, HumanResources.vJobCandidateEmployment, Person.vAdditionalContactInfo, Person.vStateProvinceCountryRegion, Production.vProductAndDescription, Production.vProductModelCatalogDescription, Production.vProductModelInstructions, Purchasing.vVendorWithAddresses, Purchasing.vVendorWithContacts, Sales.vIndividualCustomer, Sales.vPersonDemographics, Sales.vSalesPerson, Sales.vSalesPersonSalesByFiscalYears, Sales.vStoreWithAddresses, Sales.vStoreWithContacts, Sales.vStoreWithDemographics

Process List Maintained By User

[D]: Database, [I] : Interface , [O]: Object