Adventure Works Database Schema (data statistics)

Summary

Property	Value
Report created	20-May-2011 16:49
DBMS and version	Microsoft SQL Server [ 09.00.1399 ]
Server	DTM-XP
Database name	AdventureWorks
User/Login	sa
Schema/Owner
Driver and version	sqlncli10.dll [ 10.00.4000 ]
DTM Schema Reporter	Version 1.24.23, (C) 2003-2011 DTM soft.

Table 'dbo.AWBuildVersion'

Property Name	Property Value
Records	1
Fields	4
Record size (bytes) w/o BLOBs	83

Field statistics for 'SystemInformationID' tinyint identity

Field property	Property Value
Minimum value	1
Maximum value	1
Average value	1.0
Unique values	1

Field statistics for 'Database Version' nvarchar(25)

Field property	Property Value
Minimum value	9.04.10.13.00
Maximum value	9.04.10.13.00
Unique values	1

Field statistics for 'VersionDate' datetime

Field property	Property Value
Minimum value	2004-10-13 16:43:14.583
Maximum value	2004-10-13 16:43:14.583
Unique values	1

Field statistics for 'ModifiedDate' datetime

Field property	Property Value
Minimum value	2004-10-13 16:43:14.597
Maximum value	2004-10-13 16:43:14.597
Unique values	1

Table 'dbo.DatabaseLog', Audit table tracking all DDL changes made to the AdventureWorks database. Data is captured by the database trigger ddlDatabaseTriggerLog.

Property Name	Property Value
Records	451
Fields	8
Record size (bytes) w/o BLOBs	1044

Field statistics for 'DatabaseLogID' int identity

Field property	Property Value
Minimum value	1
Maximum value	451
Average value	226.0
Values variance	16987.666666666668
Unique values	451

Field statistics for 'PostTime' datetime

Field property	Property Value
Minimum value	2005-10-14 01:58:27.567
Maximum value	2005-10-14 02:00:02.460
Unique values	423

Field statistics for 'DatabaseUser' sysname(128)

Field property	Property Value
Minimum value	dbo
Maximum value	dbo
Unique values	1

Field statistics for 'Event' sysname(128)

Field property	Property Value
Minimum value	ALTER_TABLE
Maximum value	CREATE_XML_SCHEMA_COLLECTION
Unique values	13

Field statistics for 'Schema' sysname(128)

Field property	Property Value
Minimum value	dbo
Maximum value	Sales
Unique values	6

Field statistics for 'Object' sysname(128)

Field property	Property Value
Minimum value	_WA_Sys_00000002_01142BA1
Maximum value	XMLVALUE_Individual_Demographics
Unique values	330

Field statistics for 'TSQL' nvarchar(max)

Field property	Property Value
Minimum value	-- uspLogError logs error information in the ErrorLog...
Maximum value	--ENCRYPTED--
Unique values	413

Field statistics for 'XmlEvent' xml

Field property	Property Value

Table 'dbo.ErrorLog', 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.

Property Name	Property Value
Records	0
Fields	9
Record size (bytes) w/o BLOBs	8544

Table 'HumanResources.Department', Lookup table containing the departments within the Adventure Works Cycles company.

Property Name	Property Value
Records	16
Fields	4
Record size (bytes) w/o BLOBs	218

Field statistics for 'DepartmentID' smallint identity

Field property	Property Value
Minimum value	1
Maximum value	16
Average value	8.5
Values variance	22.666666666666668
Unique values	16

Field statistics for 'Name' Name

Field property	Property Value
Minimum value	Document Control
Maximum value	Tool Design
Unique values	16

Field statistics for 'GroupName' Name

Field property	Property Value
Minimum value	Executive General and Administration
Maximum value	Sales and Marketing
Unique values	6

Field statistics for 'ModifiedDate' datetime

Field property	Property Value
Minimum value	1998-06-01 00:00:00.000
Maximum value	1998-06-01 00:00:00.000
Unique values	1

Table 'HumanResources.Employee', Employee information such as salary, department, and title.

Property Name	Property Value
Records	290
Fields	16
Record size (bytes) w/o BLOBs	728

Field statistics for 'EmployeeID' int identity

Field property	Property Value
Minimum value	1
Maximum value	290
Average value	145.5
Values variance	7032.5
Unique values	290

Field statistics for 'NationalIDNumber' nvarchar(15)

Field property	Property Value
Minimum value	10708100
Maximum value	999440576
Unique values	290

Field statistics for 'ContactID' int

Field property	Property Value
Minimum value	1001
Maximum value	1290
Average value	1145.5
Values variance	7032.5
Unique values	290

Field statistics for 'LoginID' nvarchar(256)

Field property	Property Value
Minimum value	adventure-works\alan0
Maximum value	adventure-works\zheng0
Unique values	290

Field statistics for 'ManagerID' int

Field property	Property Value
Minimum value	3
Maximum value	288
Average value	108.21107266435986
Values variance	7348.6879325259524
Unique values	47

Field statistics for 'Title' nvarchar(50)

Field property	Property Value
Minimum value	Accountant
Maximum value	Vice President of Sales
Unique values	67

Field statistics for 'BirthDate' datetime

Field property	Property Value
Minimum value	1941-11-17 00:00:00.000
Maximum value	1981-07-01 00:00:00.000
Unique values	279

Field statistics for 'MaritalStatus' nchar(1)

Field property	Property Value
Minimum value	M
Maximum value	S
Unique values	2

Field statistics for 'Gender' nchar(1)

Field property	Property Value
Minimum value	F
Maximum value	M
Unique values	2

Field statistics for 'HireDate' datetime

Field property	Property Value
Minimum value	1996-07-31 00:00:00.000
Maximum value	2003-07-01 00:00:00.000
Unique values	164

Field statistics for 'SalariedFlag' Flag

Field property	Property Value
Unique values	2

Field statistics for 'VacationHours' smallint

Field property	Property Value
Minimum value	0
Maximum value	99
Average value	50.613793103448273
Values variance	828.64617587400073
Unique values	100

Field statistics for 'SickLeaveHours' smallint

Field property	Property Value
Minimum value	20
Maximum value	80
Average value	45.306896551724137
Values variance	211.4245197470469
Unique values	51

Field statistics for 'CurrentFlag' Flag

Field property	Property Value
Unique values	1

Field statistics for 'rowguid' uniqueidentifier

Field property	Property Value
Unique values	290

Field statistics for 'ModifiedDate' datetime

Field property	Property Value
Minimum value	2004-07-31 00:00:00.000
Maximum value	2005-01-26 09:17:08.637
Unique values	2

Table 'HumanResources.EmployeeAddress', Cross-reference table mapping employees to their address(es).

Property Name	Property Value
Records	290
Fields	4
Record size (bytes) w/o BLOBs	40

Field statistics for 'EmployeeID' int

Field property	Property Value
Minimum value	1
Maximum value	290
Average value	145.5
Values variance	7032.5
Unique values	290

Field statistics for 'AddressID' int

Field property	Property Value
Minimum value	1
Maximum value	32521
Average value	2127.7689655172412
Values variance	58564846.662701346
Unique values	290

Field statistics for 'rowguid' uniqueidentifier

Field property	Property Value
Unique values	290

Field statistics for 'ModifiedDate' datetime

Field property	Property Value
Minimum value	2004-10-13 11:15:06.967
Maximum value	2004-10-13 11:15:06.967
Unique values	1

Table 'HumanResources.EmployeeDepartmentHistory', Employee department transfers.

Property Name	Property Value
Records	296
Fields	6
Record size (bytes) w/o BLOBs	55

Field statistics for 'EmployeeID' int

Field property	Property Value
Minimum value	1
Maximum value	290
Average value	145.2331081081081
Values variance	7143.5895442052224
Unique values	290

Field statistics for 'DepartmentID' smallint

Field property	Property Value
Minimum value	1
Maximum value	16
Average value	7.2668918918918921
Values variance	7.8641204764086101
Unique values	16

Field statistics for 'ShiftID' tinyint

Field property	Property Value
Minimum value	1
Maximum value	3
Average value	1.5608108108108107
Values variance	0.59967934035730652
Unique values	3

Field statistics for 'StartDate' datetime

Field property	Property Value
Minimum value	1996-07-31 00:00:00.000
Maximum value	2003-12-16 00:00:00.000
Unique values	170

Field statistics for 'EndDate' datetime

Field property	Property Value
Minimum value	1999-08-15 00:00:00.000
Maximum value	2003-12-15 00:00:00.000
Unique values	6

Field statistics for 'ModifiedDate' datetime

Field property	Property Value
Minimum value	1996-07-30 00:00:00.000
Maximum value	2003-12-15 00:00:00.000
Unique values	172

Table 'HumanResources.EmployeePayHistory', Employee pay history.

Property Name	Property Value
Records	316
Fields	5
Record size (bytes) w/o BLOBs	58

Field statistics for 'EmployeeID' int

Field property	Property Value
Minimum value	1
Maximum value	290
Average value	143.38291139240508
Values variance	6999.1449768937118
Unique values	290

Field statistics for 'RateChangeDate' datetime

Field property	Property Value
Minimum value	1996-07-31 00:00:00.000
Maximum value	2003-08-15 00:00:00.000
Unique values	177

Field statistics for 'Rate' money(19,4)

Field property	Property Value
Minimum value	6.5000
Maximum value	125.5000
Average value	17.758804113924025
Values variance	150.71208000014192
Unique values	66

Field statistics for 'PayFrequency' tinyint

Field property	Property Value
Minimum value	1
Maximum value	2
Average value	1.4303797468354431
Values variance	0.24593128390596727
Unique values	2

Field statistics for 'ModifiedDate' datetime

Field property	Property Value
Minimum value	1997-12-22 00:00:00.000
Maximum value	2004-07-31 00:00:00.000
Unique values	26

Table 'HumanResources.JobCandidate', Resumes submitted to Human Resources by job applicants.

Property Name	Property Value
Records	13
Fields	4
Record size (bytes) w/o BLOBs	24

Field statistics for 'JobCandidateID' int identity

Field property	Property Value
Minimum value	1
Maximum value	13
Average value	7.0
Values variance	15.166666666666666
Unique values	13

Field statistics for 'EmployeeID' int

Field property	Property Value
Minimum value	41
Maximum value	268
Average value	154.5
Values variance	25764.5
Unique values	2

Field statistics for 'Resume' xml

Field property	Property Value

Field statistics for 'ModifiedDate' datetime

Field property	Property Value
Minimum value	1997-07-24 00:00:00.000
Maximum value	2004-01-23 18:32:21.313
Unique values	3

Table 'HumanResources.Shift', Work shift lookup table.

Property Name	Property Value
Records	3
Fields	5
Record size (bytes) w/o BLOBs	149

Field statistics for 'ShiftID' tinyint identity

Field property	Property Value
Minimum value	1
Maximum value	3
Average value	2.0
Values variance	1.0
Unique values	3

Field statistics for 'Name' Name

Field property	Property Value
Minimum value	Day
Maximum value	Night
Unique values	3

Field statistics for 'StartTime' datetime

Field property	Property Value
Minimum value	1900-01-01 07:00:00.000
Maximum value	1900-01-01 23:00:00.000
Unique values	3

Field statistics for 'EndTime' datetime

Field property	Property Value
Minimum value	1900-01-01 07:00:00.000
Maximum value	1900-01-01 23:00:00.000
Unique values	3

Field statistics for 'ModifiedDate' datetime

Field property	Property Value
Minimum value	1998-06-01 00:00:00.000
Maximum value	1998-06-01 00:00:00.000
Unique values	1

Table 'Person.Address', Street address information for customers, employees, and vendors.

Property Name	Property Value
Records	19614
Fields	8
Record size (bytes) w/o BLOBs	370

Field statistics for 'AddressID' int identity

Field property	Property Value
Minimum value	1
Maximum value	32521
Average value	19516.281227694504
Values variance	48465217.081157856
Unique values	19614

Field statistics for 'AddressLine1' nvarchar(60)

Field property	Property Value
Minimum value	#500-75 O'Connor Street
Maximum value	Zur Lindung 787
Unique values	13567

Field statistics for 'AddressLine2' nvarchar(60)

Field property	Property Value
Minimum value	# 1
Maximum value	Verkaufsabteilung
Unique values	195

Field statistics for 'City' nvarchar(30)

Field property	Property Value
Minimum value	Abingdon
Maximum value	Zeeland
Unique values	575

Field statistics for 'StateProvinceID' int

Field property	Property Value
Minimum value	1
Maximum value	181
Average value	49.284643621902724
Values variance	2126.0051922020557
Unique values	74

Field statistics for 'PostalCode' nvarchar(15)

Field property	Property Value
Minimum value	01071
Maximum value	YO15
Unique values	661

Field statistics for 'rowguid' uniqueidentifier

Field property	Property Value
Unique values	19614

Field statistics for 'ModifiedDate' datetime

Field property	Property Value
Minimum value	1996-07-24 00:00:00.000
Maximum value	2004-07-31 00:00:00.000
Unique values	1285

Table 'Person.AddressType', Types of addresses stored in the Address table.

Property Name	Property Value
Records	6
Fields	4
Record size (bytes) w/o BLOBs	136

Field statistics for 'AddressTypeID' int identity

Field property	Property Value
Minimum value	1
Maximum value	6
Average value	3.5
Values variance	3.5
Unique values	6

Field statistics for 'Name' Name

Field property	Property Value
Minimum value	Archive
Maximum value	Shipping
Unique values	6

Field statistics for 'rowguid' uniqueidentifier

Field property	Property Value
Unique values	6

Field statistics for 'ModifiedDate' datetime

Field property	Property Value
Minimum value	1998-06-01 00:00:00.000
Maximum value	1998-06-01 00:00:00.000
Unique values	1

Table 'Person.Contact', Names of each employee, customer contact, and vendor contact.

Property Name	Property Value
Records	19972
Fields	15
Record size (bytes) w/o BLOBs	577

Field statistics for 'ContactID' int identity

Field property	Property Value
Minimum value	1
Maximum value	19977
Average value	9991.2509012617666
Values variance	33246458.233625453
Unique values	19972

Field statistics for 'NameStyle' NameStyle

Field property	Property Value
Unique values	1

Field statistics for 'Title' nvarchar(8)

Field property	Property Value
Minimum value	Mr.
Maximum value	Sra.
Unique values	6

Field statistics for 'FirstName' Name

Field property	Property Value
Minimum value	A.
Maximum value	Zoe
Unique values	1018

Field statistics for 'MiddleName' Name

Field property	Property Value
Minimum value	A
Maximum value	Z.
Unique values	70

Field statistics for 'LastName' Name

Field property	Property Value
Minimum value	Abbas
Maximum value	Zwilling
Unique values	1206

Field statistics for 'Suffix' nvarchar(10)

Field property	Property Value
Minimum value	II
Maximum value	Sr.
Unique values	6

Field statistics for 'EmailAddress' nvarchar(50)

Field property	Property Value
Minimum value	a0@adventure-works.com
Maximum value	zoe9@adventure-works.com
Unique values	19972

Field statistics for 'EmailPromotion' int

Field property	Property Value
Minimum value	0
Maximum value	2
Average value	0.63008211496094535
Values variance	0.61063775801569598
Unique values	3

Field statistics for 'Phone' Phone

Field property	Property Value
Minimum value	1 (11) 500 555-0110
Maximum value	999-555-0198
Unique values	9938

Field statistics for 'PasswordHash' varchar(40)

Field property	Property Value
Minimum value	000FD16F9B773CC80B0B5879E8C4212325B6D368
Maximum value	FFFDA023342156A1EDA68BCCF18551C733EDA04C
Unique values	19972

Field statistics for 'PasswordSalt' varchar(10)

Field property	Property Value
Minimum value	++aPd2Q=
Maximum value	ZzZlwYA=
Unique values	19972

Field statistics for 'AdditionalContactInfo' xml

Field property	Property Value

Field statistics for 'rowguid' uniqueidentifier

Field property	Property Value
Unique values	19972

Field statistics for 'ModifiedDate' datetime

Field property	Property Value
Minimum value	1996-07-24 00:00:00.000
Maximum value	2005-05-16 16:33:33.123
Unique values	1290

Table 'Person.ContactType', Lookup table containing the types of contacts stored in Contact.

Property Name	Property Value
Records	20
Fields	3
Record size (bytes) w/o BLOBs	120

Field statistics for 'ContactTypeID' int identity

Field property	Property Value
Minimum value	1
Maximum value	20
Average value	10.5
Values variance	35.0
Unique values	20

Field statistics for 'Name' Name

Field property	Property Value
Minimum value	Accounting Manager
Maximum value	Sales Representative
Unique values	20

Field statistics for 'ModifiedDate' datetime

Field property	Property Value
Minimum value	1998-06-01 00:00:00.000
Maximum value	1998-06-01 00:00:00.000
Unique values	1

Table 'Person.CountryRegion', Lookup table containing the ISO standard codes for countries and regions.

Property Name	Property Value
Records	238
Fields	3
Record size (bytes) w/o BLOBs	122

Field statistics for 'CountryRegionCode' nvarchar(3)

Field property	Property Value
Minimum value	AD
Maximum value	ZW
Unique values	238

Field statistics for 'Name' Name

Field property	Property Value
Minimum value	Afghanistan
Maximum value	Zimbabwe
Unique values	238

Field statistics for 'ModifiedDate' datetime

Field property	Property Value
Minimum value	1998-06-01 00:00:00.000
Maximum value	1998-06-01 00:00:00.000
Unique values	1

Table 'Person.StateProvince', State and province lookup table.

Property Name	Property Value
Records	181
Fields	8
Record size (bytes) w/o BLOBs	153

Field statistics for 'StateProvinceID' int identity

Field property	Property Value
Minimum value	1
Maximum value	181
Average value	91.0
Values variance	2745.1666666666665
Unique values	181

Field statistics for 'StateProvinceCode' nchar(3)

Field property	Property Value
Minimum value	01
Maximum value	YT
Unique values	181

Field statistics for 'CountryRegionCode' nvarchar(3)

Field property	Property Value
Minimum value	AS
Maximum value	VI
Unique values	12

Field statistics for 'IsOnlyStateProvinceFlag' Flag

Field property	Property Value
Unique values	2

Field statistics for 'Name' Name

Field property	Property Value
Minimum value	Ain
Maximum value	Yveline
Unique values	181

Field statistics for 'TerritoryID' int

Field property	Property Value
Minimum value	1
Maximum value	10
Average value	5.8397790055248615
Values variance	4.7130755064456729
Unique values	10

Field statistics for 'rowguid' uniqueidentifier

Field property	Property Value
Unique values	181

Field statistics for 'ModifiedDate' datetime

Field property	Property Value
Minimum value	1998-06-01 00:00:00.000
Maximum value	2004-03-11 10:17:21.587
Unique values	2

Table 'Production.BillOfMaterials', Items required to make bicycles and bicycle subassemblies. It identifies the heirarchical relationship between a parent product and its components.

Property Name	Property Value
Records	2679
Fields	9
Record size (bytes) w/o BLOBs	78

Field statistics for 'BillOfMaterialsID' int identity

Field property	Property Value
Minimum value	1
Maximum value	3482
Average value	1760.2732362821948
Values variance	1093902.4966359376
Unique values	2679

Field statistics for 'ProductAssemblyID' int

Field property	Property Value
Minimum value	3
Maximum value	999
Average value	837.68090062111798
Values variance	12879.170369052608
Unique values	238

Field statistics for 'ComponentID' int

Field property	Property Value
Minimum value	1
Maximum value	999
Average value	701.77118327734229
Values variance	57650.647772721786
Unique values	325

Field statistics for 'StartDate' datetime

Field property	Property Value
Minimum value	2000-04-04 00:00:00.000
Maximum value	2001-01-23 00:00:00.000
Unique values	19

Field statistics for 'EndDate' datetime

Field property	Property Value
Minimum value	2000-06-03 00:00:00.000
Maximum value	2000-12-15 00:00:00.000
Unique values	8

Field statistics for 'UnitMeasureCode' nchar(3)

Field property	Property Value
Minimum value	EA
Maximum value	OZ
Unique values	3

Field statistics for 'BOMLevel' smallint

Field property	Property Value
Minimum value	0
Maximum value	4
Average value	1.3598357596117954
Values variance	0.33947659736154923
Unique values	5

Field statistics for 'PerAssemblyQty' decimal(8,2)

Field property	Property Value
Minimum value	1.00
Maximum value	41.00
Average value	2.0541246733855916
Values variance	20.703193398939167
Unique values	12

Field statistics for 'ModifiedDate' datetime

Field property	Property Value
Minimum value	2000-03-21 00:00:00.000
Maximum value	2001-01-09 00:00:00.000
Unique values	27

Table 'Production.Culture', Lookup table containing the languages in which some AdventureWorks data is stored.

Property Name	Property Value
Records	8
Fields	3
Record size (bytes) w/o BLOBs	128

Field statistics for 'CultureID' nchar(6)

Field property	Property Value
Minimum value
Maximum value	zh-cht
Unique values	8

Field statistics for 'Name' Name

Field property	Property Value
Minimum value	Arabic
Maximum value	Thai
Unique values	8

Field statistics for 'ModifiedDate' datetime

Field property	Property Value
Minimum value	1998-06-01 00:00:00.000
Maximum value	1998-06-01 00:00:00.000
Unique values	1

Table 'Production.Document', Product maintenance documents.

Property Name	Property Value
Records	9
Fields	10
Record size (bytes) w/o BLOBs	951

Field statistics for 'DocumentID' int identity

Field property	Property Value
Minimum value	1
Maximum value	9
Average value	5.0
Values variance	7.5
Unique values	9

Field statistics for 'Title' nvarchar(50)

Field property	Property Value
Minimum value	Crank Arm and Tire Maintenance
Maximum value	Training Wheels 2
Unique values	9

Field statistics for 'FileName' nvarchar(400)

Field property	Property Value
Minimum value	C:\Program Files\Microsoft SQL Server\MSSQL.1\Samples\M...
Maximum value	C:\Program Files\Microsoft SQL Server\MSSQL.1\Samples\M...
Unique values	9

Field statistics for 'FileExtension' nvarchar(8)

Field property	Property Value
Minimum value	.doc
Maximum value	.doc
Unique values	1

Field statistics for 'Revision' nchar(5)

Field property	Property Value
Minimum value	0
Maximum value	8
Unique values	6

Field statistics for 'ChangeNumber' int

Field property	Property Value
Minimum value	0
Maximum value	288
Average value	51.333333333333336
Values variance	8137.0
Unique values	9

Field statistics for 'Status' tinyint

Field property	Property Value
Minimum value	1
Maximum value	3
Average value	1.8888888888888888
Values variance	0.36111111111111072
Unique values	3

Field statistics for 'DocumentSummary' nvarchar(max)

Field property	Property Value
Minimum value	Detailed instructions for replacing pedals with Adventu...
Maximum value	Worn or damaged seats can be easily replaced following ...
Unique values	5

Field statistics for 'ModifiedDate' datetime

Field property	Property Value
Minimum value	1998-05-02 00:00:00.000
Maximum value	2003-07-01 00:00:00.000
Unique values	5

Table 'Production.Illustration', Bicycle assembly diagrams.

Property Name	Property Value
Records	5
Fields	3
Record size (bytes) w/o BLOBs	20

Field statistics for 'IllustrationID' int identity

Field property	Property Value
Minimum value	3
Maximum value	7
Average value	5.0
Values variance	2.5
Unique values	5

Field statistics for 'Diagram' xml

Field property	Property Value

Field statistics for 'ModifiedDate' datetime

Field property	Property Value
Minimum value	2004-02-10 13:06:11.780
Maximum value	2004-02-10 13:06:12.080
Unique values	5

Table 'Production.Location', Product inventory and manufacturing locations.

Property Name	Property Value
Records	14
Fields	5
Record size (bytes) w/o BLOBs	140

Field statistics for 'LocationID' smallint identity

Field property	Property Value
Minimum value	1
Maximum value	60
Average value	20.214285714285715
Values variance	426.48901098901104
Unique values	14

Field statistics for 'Name' Name

Field property	Property Value
Minimum value	Debur and Polish
Maximum value	Tool Crib
Unique values	14

Field statistics for 'CostRate' smallmoney(10,4)

Field property	Property Value
Minimum value	.0000
Maximum value	25.0000
Average value	8.5892857142857135
Values variance	90.832760989010993
Unique values	7

Field statistics for 'Availability' decimal(8,2)

Field property	Property Value
Minimum value	.00
Maximum value	120.00
Average value	54.571428571428569
Values variance	3322.1098901098903
Unique values	5

Field statistics for 'ModifiedDate' datetime

Field property	Property Value
Minimum value	1998-06-01 00:00:00.000
Maximum value	1998-06-01 00:00:00.000
Unique values	1

Table 'Production.Product', Products sold or used in the manfacturing of sold products.

Property Name	Property Value
Records	504
Fields	25
Record size (bytes) w/o BLOBs	368

Field statistics for 'ProductID' int identity

Field property	Property Value
Minimum value	1
Maximum value	999
Average value	673.03968253968253
Values variance	52612.038183596807
Unique values	504

Field statistics for 'Name' Name

Field property	Property Value
Minimum value	Adjustable Race
Maximum value	Women's Tights, S
Unique values	504

Field statistics for 'ProductNumber' nvarchar(25)

Field property	Property Value
Minimum value	AR-5381
Maximum value	WB-H098
Unique values	504

Field statistics for 'MakeFlag' Flag

Field property	Property Value
Unique values	2

Field statistics for 'FinishedGoodsFlag' Flag

Field property	Property Value
Unique values	2

Field statistics for 'Color' nvarchar(15)

Field property	Property Value
Minimum value	Black
Maximum value	Yellow
Unique values	9

Field statistics for 'SafetyStockLevel' smallint

Field property	Property Value
Minimum value	4
Maximum value	1000
Average value	535.15079365079362
Values variance	139960.50206696329
Unique values	6

Field statistics for 'ReorderPoint' smallint

Field property	Property Value
Minimum value	3
Maximum value	750
Average value	401.36309523809524
Values variance	78727.782412666871
Unique values	6

Field statistics for 'StandardCost' money(19,4)

Field property	Property Value
Minimum value	.0000
Maximum value	2171.2942
Average value	258.60296130952383
Values variance	213104.84913476012
Unique values	114

Field statistics for 'ListPrice' money(19,4)

Field property	Property Value
Minimum value	.0000
Maximum value	3578.2700
Average value	438.66624999999937
Values variance	598461.35812596942
Unique values	103

Field statistics for 'Size' nvarchar(5)

Field property	Property Value
Minimum value	38
Maximum value	XL
Unique values	18

Field statistics for 'SizeUnitMeasureCode' nchar(3)

Field property	Property Value
Minimum value	CM
Maximum value	CM
Unique values	1

Field statistics for 'WeightUnitMeasureCode' nchar(3)

Field property	Property Value
Minimum value	G
Maximum value	LB
Unique values	2

Field statistics for 'Weight' decimal(8,2)

Field property	Property Value
Minimum value	2.12
Maximum value	1050.00
Average value	74.069219512195119
Values variance	33184.665869976074
Unique values	127

Field statistics for 'DaysToManufacture' int

Field property	Property Value
Minimum value	0
Maximum value	4
Average value	1.1031746031746033
Values variance	2.2279024267095835
Unique values	4

Field statistics for 'ProductLine' nchar(2)

Field property	Property Value
Minimum value	M
Maximum value	T
Unique values	4

Field statistics for 'Class' nchar(2)

Field property	Property Value
Minimum value	H
Maximum value	M
Unique values	3

Field statistics for 'Style' nchar(2)

Field property	Property Value
Minimum value	M
Maximum value	W
Unique values	3

Field statistics for 'ProductSubcategoryID' int

Field property	Property Value
Minimum value	1
Maximum value	37
Average value	12.294915254237289
Values variance	97.222252968984208
Unique values	37

Field statistics for 'ProductModelID' int

Field property	Property Value
Minimum value	1
Maximum value	128
Average value	37.44406779661017
Values variance	1157.7307044851839
Unique values	119

Field statistics for 'SellStartDate' datetime

Field property	Property Value
Minimum value	1998-06-01 00:00:00.000
Maximum value	2003-07-01 00:00:00.000
Unique values	4

Field statistics for 'SellEndDate' datetime

Field property	Property Value
Minimum value	2002-06-30 00:00:00.000
Maximum value	2003-06-30 00:00:00.000
Unique values	2

Field statistics for 'DiscontinuedDate' datetime

Field property	Property Value
Unique values	0

Field statistics for 'rowguid' uniqueidentifier

Field property	Property Value
Unique values	504

Field statistics for 'ModifiedDate' datetime

Field property	Property Value
Minimum value	2004-03-11 10:01:36.827
Maximum value	2004-03-11 10:03:55.510
Unique values	2

Table 'Production.ProductCategory', High-level product categorization.

Property Name	Property Value
Records	4
Fields	4
Record size (bytes) w/o BLOBs	136

Field statistics for 'ProductCategoryID' int identity

Field property	Property Value
Minimum value	1
Maximum value	4
Average value	2.5
Values variance	1.6666666666666667
Unique values	4

Field statistics for 'Name' Name

Field property	Property Value
Minimum value	Accessories
Maximum value	Components
Unique values	4

Field statistics for 'rowguid' uniqueidentifier

Field property	Property Value
Unique values	4

Field statistics for 'ModifiedDate' datetime

Field property	Property Value
Minimum value	1998-06-01 00:00:00.000
Maximum value	1998-06-01 00:00:00.000
Unique values	1

Table 'Production.ProductCostHistory', Changes in the cost of a product over time.

Property Name	Property Value
Records	395
Fields	5
Record size (bytes) w/o BLOBs	73

Field statistics for 'ProductID' int

Field property	Property Value
Minimum value	707
Maximum value	999
Average value	828.72911392405058
Values variance	7490.2183126646851
Unique values	293

Field statistics for 'StartDate' datetime

Field property	Property Value
Minimum value	2001-07-01 00:00:00.000
Maximum value	2003-07-01 00:00:00.000
Unique values	3

Field statistics for 'EndDate' datetime

Field property	Property Value
Minimum value	2002-06-30 00:00:00.000
Maximum value	2003-06-30 00:00:00.000
Unique values	2

Field statistics for 'StandardCost' money(19,4)

Field property	Property Value
Minimum value	.8565
Maximum value	2171.2942
Average value	434.26582886075965
Values variance	247386.74878503327
Unique values	134

Field statistics for 'ModifiedDate' datetime

Field property	Property Value
Minimum value	2002-06-30 00:00:00.000
Maximum value	2003-06-30 00:00:00.000
Unique values	3

Table 'Production.ProductDescription', Product descriptions in several languages.

Property Name	Property Value
Records	762
Fields	4
Record size (bytes) w/o BLOBs	836

Field statistics for 'ProductDescriptionID' int identity

Field property	Property Value
Minimum value	3
Maximum value	2010
Average value	1542.5826771653544
Values variance	150954.65609899958
Unique values	762

Field statistics for 'Description' nvarchar(400)

Field property	Property Value
Minimum value	10-speed aluminum derailleur with sealed pulley bearing...
Maximum value	??????????????????,????????
Unique values	733

Field statistics for 'rowguid' uniqueidentifier

Field property	Property Value
Unique values	762

Field statistics for 'ModifiedDate' datetime

Field property	Property Value
Minimum value	2003-06-01 00:00:00.000
Maximum value	2004-03-11 10:32:17.973
Unique values	2

Table 'Production.ProductDocument', Cross-reference table mapping products to related product documents.

Property Name	Property Value
Records	32
Fields	3
Record size (bytes) w/o BLOBs	24

Field statistics for 'ProductID' int

Field property	Property Value
Minimum value	317
Maximum value	999
Average value	740.0625
Values variance	60422.447580645159
Unique values	31

Field statistics for 'DocumentID' int

Field property	Property Value
Minimum value	1
Maximum value	8
Average value	4.21875
Values variance	7.789314516129032
Unique values	6

Field statistics for 'ModifiedDate' datetime

Field property	Property Value
Minimum value	2004-01-30 13:51:58.103
Maximum value	2004-01-30 13:51:58.120
Unique values	2

Table 'Production.ProductInventory', Product inventory information.

Property Name	Property Value
Records	1069
Fields	7
Record size (bytes) w/o BLOBs	61

Field statistics for 'ProductID' int

Field property	Property Value
Minimum value	1
Maximum value	999
Average value	611.96258185219835
Values variance	57301.371257747269
Unique values	432

Field statistics for 'LocationID' smallint

Field property	Property Value
Minimum value	1
Maximum value	60
Average value	23.684752104770816
Values variance	553.41831597313455
Unique values	14

Field statistics for 'Shelf' nvarchar(10)

Field property	Property Value
Minimum value	A
Maximum value	Y
Unique values	21

Field statistics for 'Bin' tinyint

Field property	Property Value
Minimum value	0
Maximum value	61
Average value	8.8999064546304965
Values variance	128.21188201371299
Unique values	62

Field statistics for 'Quantity' smallint

Field property	Property Value
Minimum value	0
Maximum value	924
Average value	314.28811973807296
Values variance	36043.235261348942
Unique values	343

Field statistics for 'rowguid' uniqueidentifier

Field property	Property Value
Unique values	1069

Field statistics for 'ModifiedDate' datetime

Field property	Property Value
Minimum value	1998-05-02 00:00:00.000
Maximum value	2004-09-12 00:00:00.000
Unique values	24

Table 'Production.ProductListPriceHistory', Changes in the list price of a product over time.

Property Name	Property Value
Records	395
Fields	5
Record size (bytes) w/o BLOBs	73

Field statistics for 'ProductID' int

Field property	Property Value
Minimum value	707
Maximum value	999
Average value	828.72911392405058
Values variance	7490.2183126646851
Unique values	293

Field statistics for 'StartDate' datetime

Field property	Property Value
Minimum value	2001-07-01 00:00:00.000
Maximum value	2003-07-01 00:00:00.000
Unique values	3

Field statistics for 'EndDate' datetime

Field property	Property Value
Minimum value	2002-06-30 00:00:00.000
Maximum value	2003-06-30 00:00:00.000
Unique values	2

Field statistics for 'ListPrice' money(19,4)

Field property	Property Value
Minimum value	2.2900
Maximum value	3578.2700
Average value	747.66176227848007
Values variance	703431.8663296107
Unique values	120

Field statistics for 'ModifiedDate' datetime

Field property	Property Value
Minimum value	2002-06-30 00:00:00.000
Maximum value	2003-06-30 00:00:00.000
Unique values	3

Table 'Production.ProductModel', Product model classification.

Property Name	Property Value
Records	128
Fields	6
Record size (bytes) w/o BLOBs	136

Field statistics for 'ProductModelID' int identity

Field property	Property Value
Minimum value	1
Maximum value	128
Average value	64.5
Values variance	1376.0
Unique values	128

Field statistics for 'Name' Name

Field property	Property Value
Minimum value	All-Purpose Bike Stand
Maximum value	Women's Tights
Unique values	128

Field statistics for 'CatalogDescription' xml

Field property	Property Value

Field statistics for 'Instructions' xml

Field property	Property Value

Field statistics for 'rowguid' uniqueidentifier

Field property	Property Value
Unique values	128

Field statistics for 'ModifiedDate' datetime

Field property	Property Value
Minimum value	1998-05-02 00:00:00.000
Maximum value	2005-05-16 16:34:29.043
Unique values	10

Table 'Production.ProductModelIllustration', Cross-reference table mapping product models and illustrations.

Property Name	Property Value
Records	7
Fields	3
Record size (bytes) w/o BLOBs	24

Field statistics for 'ProductModelID' int

Field property	Property Value
Minimum value	7
Maximum value	67
Average value	39.142857142857146
Values variance	489.80952380952385
Unique values	5

Field statistics for 'IllustrationID' int

Field property	Property Value
Minimum value	3
Maximum value	6
Average value	4.2857142857142856
Values variance	1.2380952380952361
Unique values	4

Field statistics for 'ModifiedDate' datetime

Field property	Property Value
Minimum value	2004-02-10 14:41:02.167
Maximum value	2004-02-10 14:41:02.200
Unique values	3

Table 'Production.ProductModelProductDescriptionCulture', Cross-reference table mapping product descriptions and the language the description is written in.

Property Name	Property Value
Records	762
Fields	4
Record size (bytes) w/o BLOBs	36

Field statistics for 'ProductModelID' int

Field property	Property Value
Minimum value	1
Maximum value	127
Average value	64.0
Values variance	1345.7660972404731
Unique values	127

Field statistics for 'ProductDescriptionID' int

Field property	Property Value
Minimum value	3
Maximum value	2010
Average value	1542.5826771653544
Values variance	150954.65609899958
Unique values	762

Field statistics for 'CultureID' nchar(6)

Field property	Property Value
Minimum value	ar
Maximum value	zh-cht
Unique values	6

Field statistics for 'ModifiedDate' datetime

Field property	Property Value
Minimum value	2003-06-01 00:00:00.000
Maximum value	2003-06-01 00:00:00.000
Unique values	1

Table 'Production.ProductPhoto', Product images.

Property Name	Property Value
Records	101
Fields	6
Record size (bytes) w/o BLOBs	220

Field statistics for 'ProductPhotoID' int identity

Field property	Property Value
Minimum value	1
Maximum value	181
Average value	125.77227722772277
Values variance	1217.8376237623766
Unique values	101

Field statistics for 'ThumbnailPhotoFileName' nvarchar(50)

Field property	Property Value
Minimum value	awc_jersey_female_small.gif
Maximum value	wheel_small.gif
Unique values	101

Field statistics for 'LargePhotoFileName' nvarchar(50)

Field property	Property Value
Minimum value	awc_jersey_female_large.gif
Maximum value	wheel_large.gif
Unique values	101

Field statistics for 'ModifiedDate' datetime

Field property	Property Value
Minimum value	1998-05-02 00:00:00.000
Maximum value	2003-06-01 00:00:00.000
Unique values	6

Table 'Production.ProductProductPhoto', Cross-reference table mapping products and product photos.

Property Name	Property Value
Records	504
Fields	4
Record size (bytes) w/o BLOBs	25

Field statistics for 'ProductID' int

Field property	Property Value
Minimum value	1
Maximum value	999
Average value	673.03968253968253
Values variance	52612.038183596807
Unique values	504

Field statistics for 'ProductPhotoID' int

Field property	Property Value
Minimum value	1
Maximum value	179
Average value	41.670634920634917
Values variance	3920.583151882357
Unique values	42

Field statistics for 'Primary' Flag

Field property	Property Value
Unique values	1

Field statistics for 'ModifiedDate' datetime

Field property	Property Value
Minimum value	1998-05-02 00:00:00.000
Maximum value	2003-06-01 00:00:00.000
Unique values	4

Table 'Production.ProductReview', Customer reviews of products they have purchased.

Property Name	Property Value
Records	4
Fields	8
Record size (bytes) w/o BLOBs	7944

Field statistics for 'ProductReviewID' int identity

Field property	Property Value
Minimum value	1
Maximum value	4
Average value	2.5
Values variance	1.6666666666666667
Unique values	4

Field statistics for 'ProductID' int

Field property	Property Value
Minimum value	709
Maximum value	937
Average value	845.25
Values variance	12544.25
Unique values	3

Field statistics for 'ReviewerName' Name

Field property	Property Value
Minimum value	David
Maximum value	Laura Norman
Unique values	4

Field statistics for 'ReviewDate' datetime

Field property	Property Value
Minimum value	2003-10-20 00:00:00.000
Maximum value	2003-12-17 00:00:00.000
Unique values	3

Field statistics for 'EmailAddress' nvarchar(50)

Field property	Property Value
Minimum value	david@graphicdesigninstitute.com
Maximum value	laura@treyresearch.net
Unique values	4

Field statistics for 'Rating' int

Field property	Property Value
Minimum value	2
Maximum value	5
Average value	4.0
Values variance	2.0
Unique values	3

Field statistics for 'Comments' nvarchar(3850)

Field property	Property Value
Minimum value	A little on the heavy side, but overall the entry/exit ...
Maximum value	The Road-550-W from Adventure Works Cycles is everythin...
Unique values	4

Field statistics for 'ModifiedDate' datetime

Field property	Property Value
Minimum value	2003-10-20 00:00:00.000
Maximum value	2003-12-17 00:00:00.000
Unique values	3

Table 'Production.ProductSubcategory', Product subcategories. See ProductCategory table.

Property Name	Property Value
Records	37
Fields	5
Record size (bytes) w/o BLOBs	140

Field statistics for 'ProductSubcategoryID' int identity

Field property	Property Value
Minimum value	1
Maximum value	37
Average value	19.0
Values variance	117.16666666666667
Unique values	37

Field statistics for 'ProductCategoryID' int

Field property	Property Value
Minimum value	1
Maximum value	4
Average value	2.7837837837837838
Values variance	1.0075075075075073
Unique values	4

Field statistics for 'Name' Name

Field property	Property Value
Minimum value	Bib-Shorts
Maximum value	Wheels
Unique values	37

Field statistics for 'rowguid' uniqueidentifier

Field property	Property Value
Unique values	37

Field statistics for 'ModifiedDate' datetime

Field property	Property Value
Minimum value	1998-06-01 00:00:00.000
Maximum value	1998-06-01 00:00:00.000
Unique values	1

Table 'Production.ScrapReason', Manufacturing failure reasons lookup table.

Property Name	Property Value
Records	16
Fields	3
Record size (bytes) w/o BLOBs	118

Field statistics for 'ScrapReasonID' smallint identity

Field property	Property Value
Minimum value	1
Maximum value	16
Average value	8.5
Values variance	22.666666666666668
Unique values	16

Field statistics for 'Name' Name

Field property	Property Value
Minimum value	Brake assembly not as ordered
Maximum value	Wheel misaligned
Unique values	16

Field statistics for 'ModifiedDate' datetime

Field property	Property Value
Minimum value	1998-06-01 00:00:00.000
Maximum value	1998-06-01 00:00:00.000
Unique values	1

Table 'Production.TransactionHistory', Record of each purchase order, sales order, or work order transaction year to date.

Property Name	Property Value
Records	113443
Fields	9
Record size (bytes) w/o BLOBs	75

Field statistics for 'TransactionID' int identity

Field property	Property Value
Minimum value	100000
Maximum value	213442
Average value	156721.0
Values variance	1072452307.6666666
Unique values	113443

Field statistics for 'ProductID' int

Field property	Property Value
Minimum value	1
Maximum value	999
Average value	813.31752510071135
Values variance	29559.593108622423
Unique values	441

Field statistics for 'ReferenceOrderID' int

Field property	Property Value
Minimum value	417
Maximum value	75123
Average value	57587.75930643583
Values variance	285365944.52746665
Unique values	37118

Field statistics for 'ReferenceOrderLineID' int

Field property	Property Value
Minimum value	0
Maximum value	71
Average value	4.6712886647920104
Values variance	78.151851644982401
Unique values	72

Field statistics for 'TransactionDate' datetime

Field property	Property Value
Minimum value	2003-09-01 00:00:00.000
Maximum value	2004-09-03 00:00:00.000
Unique values	365

Field statistics for 'TransactionType' nchar(1)

Field property	Property Value
Minimum value	P
Maximum value	W
Unique values	3

Field statistics for 'Quantity' int

Field property	Property Value
Minimum value	1
Maximum value	39270
Average value	35.059095757340693
Values variance	141813.18800640013
Unique values	455

Field statistics for 'ActualCost' money(19,4)

Field property	Property Value
Minimum value	.0000
Maximum value	2443.3500
Average value	240.71411328752288
Values variance	305892.94481861318
Unique values	252

Field statistics for 'ModifiedDate' datetime

Field property	Property Value
Minimum value	2003-09-01 00:00:00.000
Maximum value	2004-09-03 00:00:00.000
Unique values	365

Table 'Production.TransactionHistoryArchive', Transactions for previous years.

Property Name	Property Value
Records	89253
Fields	9
Record size (bytes) w/o BLOBs	75

Field statistics for 'TransactionID' int

Field property	Property Value
Minimum value	1
Maximum value	89253
Average value	44627.0
Values variance	663848938.5
Unique values	89253

Field statistics for 'ProductID' int

Field property	Property Value
Minimum value	1
Maximum value	999
Average value	734.88867601089044
Values variance	30822.924952772395
Unique values	497

Field statistics for 'ReferenceOrderID' int

Field property	Property Value
Minimum value	1
Maximum value	53449
Average value	35121.18044211399
Values variance	273409591.10356051
Unique values	51380

Field statistics for 'ReferenceOrderLineID' int

Field property	Property Value
Minimum value	0
Maximum value	72
Average value	6.7729824207589662
Values variance	131.79021388662906
Unique values	73

Field statistics for 'TransactionDate' datetime

Field property	Property Value
Minimum value	2001-05-17 00:00:00.000
Maximum value	2003-08-31 00:00:00.000
Unique values	794

Field statistics for 'TransactionType' nchar(1)

Field property	Property Value
Minimum value	P
Maximum value	W
Unique values	3

Field statistics for 'Quantity' int

Field property	Property Value
Minimum value	1
Maximum value	39570
Average value	34.260002464903138
Values variance	215740.42294159011
Unique values	640

Field statistics for 'ActualCost' money(19,4)

Field property	Property Value
Minimum value	.0000
Maximum value	3578.2700
Average value	396.62429128334242
Values variance	598596.82295942004
Unique values	293

Field statistics for 'ModifiedDate' datetime

Field property	Property Value
Minimum value	2001-05-17 00:00:00.000
Maximum value	2003-08-31 00:00:00.000
Unique values	794

Table 'Production.UnitMeasure', Unit of measure lookup table.

Property Name	Property Value
Records	38
Fields	3
Record size (bytes) w/o BLOBs	122

Field statistics for 'UnitMeasureCode' nchar(3)

Field property	Property Value
Minimum value	BOX
Maximum value	PT
Unique values	38

Field statistics for 'Name' Name

Field property	Property Value
Minimum value	Bottle
Maximum value	US pound
Unique values	38

Field statistics for 'ModifiedDate' datetime

Field property	Property Value
Minimum value	1998-06-01 00:00:00.000
Maximum value	1998-06-01 00:00:00.000
Unique values	1

Table 'Production.WorkOrder', Manufacturing work orders.

Property Name	Property Value
Records	72591
Fields	10
Record size (bytes) w/o BLOBs	84

Field statistics for 'WorkOrderID' int identity

Field property	Property Value
Minimum value	1
Maximum value	72591
Average value	36296.0
Values variance	439127156.0
Unique values	72591

Field statistics for 'ProductID' int

Field property	Property Value
Minimum value	3
Maximum value	999
Average value	704.32783678417434
Values variance	49655.052653811996
Unique values	238

Field statistics for 'OrderQty' int

Field property	Property Value
Minimum value	1
Maximum value	39570
Average value	62.097518976181618
Values variance	468514.9963447192
Unique values	903

Field statistics for 'StockedQty' int

Field property	Property Value
Minimum value	1
Maximum value	39570
Average value	61.95079279800526
Values variance	466917.14291544113
Unique values	1013

Field statistics for 'ScrappedQty' smallint

Field property	Property Value
Minimum value	0
Maximum value	673
Average value	0.14672617817635794
Values variance	23.10478329627006
Unique values	87

Field statistics for 'StartDate' datetime

Field property	Property Value
Minimum value	2001-07-04 00:00:00.000
Maximum value	2004-07-03 00:00:00.000
Unique values	1093

Field statistics for 'EndDate' datetime

Field property	Property Value
Minimum value	2001-07-14 00:00:00.000
Maximum value	2004-07-18 00:00:00.000
Unique values	1098

Field statistics for 'DueDate' datetime

Field property	Property Value
Minimum value	2001-07-15 00:00:00.000
Maximum value	2004-07-14 00:00:00.000
Unique values	1093

Field statistics for 'ScrapReasonID' smallint

Field property	Property Value
Minimum value	1
Maximum value	16
Average value	8.7242798353909468
Values variance	22.43348935015602
Unique values	16

Field statistics for 'ModifiedDate' datetime

Field property	Property Value
Minimum value	2001-07-14 00:00:00.000
Maximum value	2004-07-18 00:00:00.000
Unique values	1098

Table 'Production.WorkOrderRouting', Work order details.

Property Name	Property Value
Records	67131
Fields	12
Record size (bytes) w/o BLOBs	145

Field statistics for 'WorkOrderID' int

Field property	Property Value
Minimum value	13
Maximum value	72587
Average value	38394.300129597352
Values variance	418473076.70509434
Unique values	42625

Field statistics for 'ProductID' int

Field property	Property Value
Minimum value	514
Maximum value	999
Average value	798.92957054118062
Values variance	17473.10661417431
Unique values	149

Field statistics for 'OperationSequence' smallint

Field property	Property Value
Minimum value	1
Maximum value	7
Average value	5.1099641000431992
Values variance	4.7172090721507676
Unique values	7

Field statistics for 'LocationID' smallint

Field property	Property Value
Minimum value	10
Maximum value	60
Average value	43.800777584126557
Values variance	306.98468046194102
Unique values	7

Field statistics for 'ScheduledStartDate' datetime

Field property	Property Value
Minimum value	2001-07-04 00:00:00.000
Maximum value	2004-07-03 00:00:00.000
Unique values	1093

Field statistics for 'ScheduledEndDate' datetime

Field property	Property Value
Minimum value	2001-07-15 00:00:00.000
Maximum value	2004-07-14 00:00:00.000
Unique values	1093

Field statistics for 'ActualStartDate' datetime

Field property	Property Value
Minimum value	2001-07-04 00:00:00.000
Maximum value	2004-07-18 00:00:00.000
Unique values	671

Field statistics for 'ActualEndDate' datetime

Field property	Property Value
Minimum value	2001-07-16 00:00:00.000
Maximum value	2004-07-29 00:00:00.000
Unique values	714

Field statistics for 'ActualResourceHrs' decimal(9,4)

Field property	Property Value
Minimum value	1.0000
Maximum value	4.1000
Average value	3.4106776303054547
Values variance	0.41320968679442971
Unique values	6

Field statistics for 'PlannedCost' money(19,4)

Field property	Property Value
Minimum value	14.5000
Maximum value	92.2500
Average value	51.957657416096886
Values variance	487.75516186809551
Unique values	7

Field statistics for 'ActualCost' money(19,4)

Field property	Property Value
Minimum value	14.5000
Maximum value	92.2500
Average value	51.957657416096886
Values variance	487.75516186809551
Unique values	7

Field statistics for 'ModifiedDate' datetime

Field property	Property Value
Minimum value	2001-07-16 00:00:00.000
Maximum value	2004-07-29 00:00:00.000
Unique values	714

Table 'Purchasing.ProductVendor', Cross-reference table mapping vendors with the products they supply.

Property Name	Property Value
Records	406
Fields	11
Record size (bytes) w/o BLOBs	104

Field statistics for 'ProductID' int

Field property	Property Value
Minimum value	1
Maximum value	952
Average value	475.04679802955667
Values variance	31989.95582922826
Unique values	211

Field statistics for 'VendorID' int

Field property	Property Value
Minimum value	1
Maximum value	104
Average value	50.820197044334975
Values variance	790.95771452897873
Unique values	79

Field statistics for 'AverageLeadTime' int

Field property	Property Value
Minimum value	15
Maximum value	19
Average value	16.940886699507388
Values variance	2.0853858784893182
Unique values	5

Field statistics for 'StandardPrice' money(19,4)

Field property	Property Value
Minimum value	.2000
Maximum value	78.8900
Average value	36.446748768472858
Values variance	151.64969458858351
Unique values	144

Field statistics for 'LastReceiptCost' money(19,4)

Field property	Property Value
Minimum value	.2100
Maximum value	82.8345
Average value	38.26908620689656
Values variance	167.1937882839064
Unique values	144

Field statistics for 'LastReceiptDate' datetime

Field property	Property Value
Minimum value	2001-08-22 00:00:00.000
Maximum value	2001-09-29 00:00:00.000
Unique values	29

Field statistics for 'MinOrderQty' int

Field property	Property Value
Minimum value	1
Maximum value	500
Average value	28.53448275862069
Values variance	2883.2420178799489
Unique values	4

Field statistics for 'MaxOrderQty' int

Field property	Property Value
Minimum value	5
Maximum value	2000
Average value	262.1305418719212
Values variance	195826.86933649576
Unique values	4

Field statistics for 'OnOrderQty' int

Field property	Property Value
Minimum value	3
Maximum value	300
Average value	98.10891089108911
Values variance	18436.058019801978
Unique values	3

Field statistics for 'UnitMeasureCode' nchar(3)

Field property	Property Value
Minimum value	CAN
Maximum value	PAK
Unique values	7

Field statistics for 'ModifiedDate' datetime

Field property	Property Value
Minimum value	2001-08-22 00:00:00.000
Maximum value	2001-09-29 00:00:00.000
Unique values	29

Table 'Purchasing.PurchaseOrderDetail', Individual products associated with a specific purchase order. See PurchaseOrderHeader.

Property Name	Property Value
Records	8788
Fields	11
Record size (bytes) w/o BLOBs	119

Field statistics for 'PurchaseOrderID' int

Field property	Property Value
Minimum value	1
Maximum value	4000
Average value	1979.2522758306782
Values variance	1334891.1457499128
Unique values	4000

Field statistics for 'PurchaseOrderDetailID' int identity

Field property	Property Value
Minimum value	1
Maximum value	8788
Average value	4394.5
Values variance	6436477.666666667
Unique values	8788

Field statistics for 'DueDate' datetime

Field property	Property Value
Minimum value	2001-05-31 00:00:00.000
Maximum value	2004-09-17 00:00:00.000
Unique values	296

Field statistics for 'OrderQty' smallint

Field property	Property Value
Minimum value	3
Maximum value	1250
Average value	256.30200273099683
Values variance	81819.269657989295
Unique values	5

Field statistics for 'ProductID' int

Field property	Property Value
Minimum value	1
Maximum value	952
Average value	525.50557578516157
Values variance	51700.220408192399
Unique values	211

Field statistics for 'UnitPrice' money(19,4)

Field property	Property Value
Minimum value	.2100
Maximum value	82.8345
Average value	34.829381543013469
Values variance	265.42634998796854
Unique values	146

Field statistics for 'LineTotal' money(19,4)

Field property	Property Value
Minimum value	37.0755
Maximum value	45558.9750
Average value	7012.7054987483662
Values variance	101021793.38931186
Unique values	148

Field statistics for 'ReceivedQty' decimal(8,2)

Field property	Property Value
Minimum value	2.00
Maximum value	1250.00
Average value	253.90691852526172
Values variance	80420.550342477945
Unique values	11

Field statistics for 'RejectedQty' decimal(8,2)

Field property	Property Value
Minimum value	.00
Maximum value	1250.00
Average value	8.2726445152480661
Values variance	3422.3262482919613
Unique values	13

Field statistics for 'StockedQty' decimal(9,2)

Field property	Property Value
Minimum value	.00
Maximum value	1250.00
Average value	245.63427401001366
Values variance	78098.276380638228
Unique values	15

Field statistics for 'ModifiedDate' datetime

Field property	Property Value
Minimum value	2001-05-24 00:00:00.000
Maximum value	2004-09-10 00:00:00.000
Unique values	296

Table 'Purchasing.PurchaseOrderHeader', General purchase order information. See PurchaseOrderDetail.

Property Name	Property Value
Records	4000
Fields	13
Record size (bytes) w/o BLOBs	150

Field statistics for 'PurchaseOrderID' int identity

Field property	Property Value
Minimum value	1
Maximum value	4000
Average value	2000.5
Values variance	1333666.6666666667
Unique values	4000

Field statistics for 'RevisionNumber' tinyint

Field property	Property Value
Minimum value	0
Maximum value	5
Average value	6.6000000000000003E-2
Values variance	0.11367241810452614
Unique values	6

Field statistics for 'Status' tinyint

Field property	Property Value
Minimum value	1
Maximum value	4
Average value	3.8097500000000002
Values variance	0.49167785696424021
Unique values	3

Field statistics for 'EmployeeID' int

Field property	Property Value
Minimum value	164
Maximum value	274
Average value	236.62
Values variance	827.04236059014897
Unique values	12

Field statistics for 'VendorID' int

Field property	Property Value
Minimum value	1
Maximum value	104
Average value	51.496749999999999
Values variance	831.38283514628654
Unique values	79

Field statistics for 'ShipMethodID' int

Field property	Property Value
Minimum value	1
Maximum value	5
Average value	3.5745
Values variance	2.2175041260315078
Unique values	5

Field statistics for 'OrderDate' datetime

Field property	Property Value
Minimum value	2001-05-17 00:00:00.000
Maximum value	2004-09-03 00:00:00.000
Unique values	296

Field statistics for 'ShipDate' datetime

Field property	Property Value
Minimum value	2001-05-26 00:00:00.000
Maximum value	2004-09-12 00:00:00.000
Unique values	296

Field statistics for 'SubTotal' money(19,4)

Field property	Property Value
Minimum value	37.0755
Maximum value	152581.2750
Average value	15406.913980750012
Values variance	443546704.04062027
Unique values	339

Field statistics for 'TaxAmt' money(19,4)

Field property	Property Value
Minimum value	2.9660
Maximum value	12206.5020
Average value	1232.5531151999905
Values variance	2838698.913010933
Unique values	339

Field statistics for 'Freight' money(19,4)

Field property	Property Value
Minimum value	.9269
Maximum value	3814.5319
Average value	385.17286200000001
Values variance	277216.69461488142
Unique values	339

Field statistics for 'TotalDue' money(19,4)

Field property	Property Value
Minimum value	40.9684
Maximum value	168602.3089
Average value	17024.639957949857
Values variance	541581614.6028378
Unique values	339

Field statistics for 'ModifiedDate' datetime

Field property	Property Value
Minimum value	2001-05-26 00:00:00.000
Maximum value	2004-09-12 00:00:00.000
Unique values	296

Table 'Purchasing.ShipMethod', Shipping company lookup table.

Property Name	Property Value
Records	5
Fields	6
Record size (bytes) w/o BLOBs	178

Field statistics for 'ShipMethodID' int identity

Field property	Property Value
Minimum value	1
Maximum value	5
Average value	3.0
Values variance	2.5
Unique values	5

Field statistics for 'Name' Name

Field property	Property Value
Minimum value	CARGO TRANSPORT 5
Maximum value	ZY - EXPRESS
Unique values	5

Field statistics for 'ShipBase' money(19,4)

Field property	Property Value
Minimum value	3.9500
Maximum value	29.9500
Average value	14.957999999999998
Values variance	113.88031999999998
Unique values	5

Field statistics for 'ShipRate' money(19,4)

Field property	Property Value
Minimum value	.9900
Maximum value	2.9900
Average value	1.75
Values variance	0.61300000000000043
Unique values	5

Field statistics for 'rowguid' uniqueidentifier

Field property	Property Value
Unique values	5

Field statistics for 'ModifiedDate' datetime

Field property	Property Value
Minimum value	1998-06-01 00:00:00.000
Maximum value	1998-06-01 00:00:00.000
Unique values	1

Table 'Purchasing.Vendor', Companies from whom Adventure Works Cycles purchases parts or other goods.

Property Name	Property Value
Records	104
Fields	8
Record size (bytes) w/o BLOBs	2201

Field statistics for 'VendorID' int identity

Field property	Property Value
Minimum value	1
Maximum value	104
Average value	52.5
Values variance	910.0
Unique values	104

Field statistics for 'AccountNumber' AccountNumber

Field property	Property Value
Minimum value	ADATUM0001
Maximum value	WOODFIT0001
Unique values	104

Field statistics for 'Name' Name

Field property	Property Value
Minimum value	A. Datum Corporation
Maximum value	Wood Fitness
Unique values	104

Field statistics for 'CreditRating' tinyint

Field property	Property Value
Minimum value	1
Maximum value	5
Average value	1.3557692307692308
Values variance	0.7168595967139656
Unique values	5

Field statistics for 'PreferredVendorStatus' Flag

Field property	Property Value
Unique values	2

Field statistics for 'ActiveFlag' Flag

Field property	Property Value
Unique values	2

Field statistics for 'PurchasingWebServiceURL' nvarchar(1024)

Field property	Property Value
Minimum value	www.adatum.com/
Maximum value	www.wideworldimporters.com/
Unique values	6

Field statistics for 'ModifiedDate' datetime

Field property	Property Value
Minimum value	2001-05-26 00:00:00.000
Maximum value	2002-03-21 00:00:00.000
Unique values	10

Table 'Purchasing.VendorAddress', Cross-reference mapping vendors and addresses.

Property Name	Property Value
Records	104
Fields	4
Record size (bytes) w/o BLOBs	28

Field statistics for 'VendorID' int

Field property	Property Value
Minimum value	1
Maximum value	104
Average value	52.5
Values variance	910.0
Unique values	104

Field statistics for 'AddressID' int

Field property	Property Value
Minimum value	301
Maximum value	404
Average value	352.5
Values variance	910.0
Unique values	104

Field statistics for 'AddressTypeID' int

Field property	Property Value
Minimum value	3
Maximum value	3
Average value	3.0
Values variance	0.0
Unique values	1

Field statistics for 'ModifiedDate' datetime

Field property	Property Value
Minimum value	2001-05-26 00:00:00.000
Maximum value	2002-03-21 00:00:00.000
Unique values	10

Table 'Purchasing.VendorContact', Cross-reference table mapping vendors and their employees.

Property Name	Property Value
Records	156
Fields	4
Record size (bytes) w/o BLOBs	28

Field statistics for 'VendorID' int

Field property	Property Value
Minimum value	1
Maximum value	104
Average value	51.942307692307693
Values variance	905.39665012406931
Unique values	104

Field statistics for 'ContactID' int

Field property	Property Value
Minimum value	601
Maximum value	995
Average value	758.08333333333337
Values variance	23123.134946236591
Unique values	156

Field statistics for 'ContactTypeID' int

Field property	Property Value
Minimum value	2
Maximum value	19
Average value	16.064102564102566
Values variance	26.563606286186946
Unique values	4

Field statistics for 'ModifiedDate' datetime

Field property	Property Value
Minimum value	2001-05-26 00:00:00.000
Maximum value	2002-03-21 00:00:00.000
Unique values	10

Table 'Sales.ContactCreditCard', Cross-reference table mapping customers in the Contact table to their credit card information in the CreditCard table.

Property Name	Property Value
Records	19118
Fields	3
Record size (bytes) w/o BLOBs	24

Field statistics for 'ContactID' int

Field property	Property Value
Minimum value	2
Maximum value	19977
Average value	10388.61272099592
Values variance	31033440.962734029
Unique values	19118

Field statistics for 'CreditCardID' int

Field property	Property Value
Minimum value	1
Maximum value	19237
Average value	9567.6695261010573
Values variance	30601592.639852796
Unique values	19118

Field statistics for 'ModifiedDate' datetime

Field property	Property Value
Minimum value	2001-07-01 00:00:00.000
Maximum value	2004-07-31 00:00:00.000
Unique values	1124

Table 'Sales.CountryRegionCurrency', Cross-reference table mapping ISO currency codes to a country or region.

Property Name	Property Value
Records	109
Fields	3
Record size (bytes) w/o BLOBs	28

Field statistics for 'CountryRegionCode' nvarchar(3)

Field property	Property Value
Minimum value	AE
Maximum value	ZW
Unique values	96

Field statistics for 'CurrencyCode' nchar(3)

Field property	Property Value
Minimum value	AED
Maximum value	ZWD
Unique values	97

Field statistics for 'ModifiedDate' datetime

Field property	Property Value
Minimum value	1998-06-01 00:00:00.000
Maximum value	2004-03-11 10:17:21.510
Unique values	2

Table 'Sales.CreditCard', Customer credit card information.

Property Name	Property Value
Records	19118
Fields	6
Record size (bytes) w/o BLOBs	173

Field statistics for 'CreditCardID' int identity

Field property	Property Value
Minimum value	1
Maximum value	19237
Average value	9567.6695261010573
Values variance	30601592.639852796
Unique values	19118

Field statistics for 'CardType' nvarchar(50)

Field property	Property Value
Minimum value	ColonialVoice
Maximum value	Vista
Unique values	4

Field statistics for 'CardNumber' nvarchar(25)

Field property	Property Value
Minimum value	11111000471254
Maximum value	77779999252881
Unique values	19118

Field statistics for 'ExpMonth' tinyint

Field property	Property Value
Minimum value	1
Maximum value	12
Average value	6.5273041113087142
Values variance	11.941164788088972
Unique values	12

Field statistics for 'ExpYear' smallint

Field property	Property Value
Minimum value	2005
Maximum value	2008
Average value	2006.5001046134532
Values variance	1.2416958616088798
Unique values	4

Field statistics for 'ModifiedDate' datetime

Field property	Property Value
Minimum value	1996-07-24 00:00:00.000
Maximum value	2004-07-31 00:00:00.000
Unique values	1284

Table 'Sales.Currency', Lookup table containing standard ISO currencies.

Property Name	Property Value
Records	105
Fields	3
Record size (bytes) w/o BLOBs	122

Field statistics for 'CurrencyCode' nchar(3)

Field property	Property Value
Minimum value	AED
Maximum value	ZWD
Unique values	105

Field statistics for 'Name' Name

Field property	Property Value
Minimum value	Afghani
Maximum value	Zloty
Unique values	105