General Database Report

PropertyValue
DTM Database Content Analyzer 1.03.01
DatabaseSQL Server Native Client 11.0: .///AdventureWorks [AdventureWorks]
Analyzed tables70
Total data size, bytes 69 892 712
Report created07-Sep-2015 15:46

Table of Content

dbo.AWBuildVersion
dbo.DatabaseLog
HumanResources.Department
HumanResources.Employee
HumanResources.EmployeeAddress
HumanResources.EmployeeDepartmentHistory
HumanResources.EmployeePayHistory
HumanResources.JobCandidate
HumanResources.Shift
Person.Address
Person.AddressType
Person.Contact
Person.ContactType
Person.CountryRegion
Person.StateProvince
Production.BillOfMaterials
Production.Culture
Production.Document
Production.Illustration
Production.Location
Production.Product
Production.ProductCategory
Production.ProductCostHistory
Production.ProductDescription
Production.ProductDocument
Production.ProductInventory
Production.ProductListPriceHistory
Production.ProductModel
Production.ProductModelIllustration
Production.ProductModelProductDescriptionCulture
Production.ProductPhoto
Production.ProductProductPhoto
Production.ProductReview
Production.ProductSubcategory
Production.ScrapReason
Production.TransactionHistory
Production.TransactionHistoryArchive
Production.UnitMeasure
Production.WorkOrder
Production.WorkOrderRouting
Purchasing.ProductVendor
Purchasing.PurchaseOrderDetail
Purchasing.PurchaseOrderHeader
Purchasing.ShipMethod
Purchasing.Vendor
Purchasing.VendorAddress
Purchasing.VendorContact
Sales.ContactCreditCard
Sales.CountryRegionCurrency
Sales.CreditCard
Sales.Currency
Sales.CurrencyRate
Sales.Customer
Sales.CustomerAddress
Sales.Individual
Sales.SalesOrderDetail
Sales.SalesOrderHeader
Sales.SalesOrderHeaderSalesReason
Sales.SalesPerson
Sales.SalesPersonQuotaHistory
Sales.SalesReason
Sales.SalesTaxRate
Sales.SalesTerritory
Sales.SalesTerritoryHistory
Sales.ShoppingCartItem
Sales.SpecialOffer
Sales.SpecialOfferProduct
Sales.Store
Sales.StoreContact

Table: dbo.AWBuildVersion

PropertyValue
Table descriptionCurrent version number of the AdventureWorks sample database.
Analyzed columns4
Data rows 1
Data size, bytes 46 or 0.00 % of database size
Table has fixed row size, bytes 46
Column Statistics for 'dbo.AWBuildVersion' table
ColumnPropertyValue
SystemInformationIDData type and presentation sizetinyint identity, 3
 Data length, bytes1
 Actual data size, bytes 1 or 2.17 % of table size
 Minimum value 1
 Average value 1.00
 Maximum value 1
ColumnPropertyValue
Database VersionData type and presentation sizenvarchar, 25
 Data length, bytes50
 Actual data size, bytes 13 or 28.26 % of table size
 Minimum value length13
 Maximum value length13
ColumnPropertyValue
VersionDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes 16 or 34.78 % of table size
 Minimum value2006-04-26
 Average value2006-04-26
 Maximum value2006-04-26
ColumnPropertyValue
ModifiedDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes 16 or 34.78 % of table size
 Minimum value2006-04-26
 Average value2006-04-26
 Maximum value2006-04-26

Table: dbo.DatabaseLog

PropertyValue
Table descriptionAudit table tracking all DDL changes made to the AdventureWorks database. Data is captured by the database trigger ddlDatabaseTriggerLog.
Analyzed columns8
Data rows389
Data size, bytes211 519 or 0.30 % of database size
Average row size, bytes543.75
Minimum row size, bytes 80
Maximum row size, bytes 6 848
Column Statistics for 'dbo.DatabaseLog' table
ColumnPropertyValue
DatabaseLogIDData type and presentation sizeint identity, 10
 Data length, bytes4
 Actual data size, bytes 1 556 or 0.74 % of table size
 Minimum value 1
 Average value195.00
 Maximum value389
ColumnPropertyValue
PostTimeData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes 6 224 or 2.94 % of table size
 Minimum value2006-04-26
 Average value2006-04-26
 Maximum value2006-04-26
ColumnPropertyValue
DatabaseUserData type and presentation sizesysname, 128
 Data length, bytes256
 Actual data size, bytes 1 167 or 0.55 % of table size
 Minimum value length3
 Maximum value length3
ColumnPropertyValue
EventData type and presentation sizesysname, 128
 Data length, bytes256
 Actual data size, bytes 4 995 or 2.36 % of table size
 Minimum value length11
 Maximum value length28
ColumnPropertyValue
SchemaData type and presentation sizesysname, 128
 Data length, bytes256
 Actual data size, bytes 3 081 or 1.46 % of table size
 Minimum value length3
 Maximum value length14
ColumnPropertyValue
ObjectData type and presentation sizesysname, 128
 Data length, bytes256
 NULL values5 or 1.29 %
 Actual data size, bytes 7 681 or 3.63 % of table size
 Minimum value length4
 Maximum value length68
ColumnPropertyValue
TSQLData type and presentation sizenvarchar, 128
 Data length, bytes0
 Actual data size, bytes186 815 or 88.32 % of table size
 Minimum value length13
 Maximum value length6759
ColumnPropertyValue
XmlEventData type and presentation sizexml, 128
 Data length, bytes0
 Actual data size, bytes0 or 0.00 % of table size

Table: HumanResources.Department

PropertyValue
Table descriptionLookup table containing the departments within the Adventure Works Cycles company.
Analyzed columns4
Data rows 16
Data size, bytes908 or 0.00 % of database size
Average row size, bytes 56.75
Minimum row size, bytes 41
Maximum row size, bytes 80
Column Statistics for 'HumanResources.Department' table
ColumnPropertyValue
DepartmentIDData type and presentation sizesmallint identity, 5
 Data length, bytes2
 Actual data size, bytes 32 or 3.52 % of table size
 Minimum value 1
 Average value 8.50
 Maximum value 16
ColumnPropertyValue
NameData type and presentation sizeName, 50
 Data length, bytes100
 Actual data size, bytes230 or 25.33 % of table size
 Minimum value length5
 Maximum value length26
ColumnPropertyValue
GroupNameData type and presentation sizeName, 50
 Data length, bytes100
 Actual data size, bytes390 or 42.95 % of table size
 Minimum value length13
 Maximum value length36
ColumnPropertyValue
ModifiedDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes256 or 28.19 % of table size
 Minimum value1998-06-01
 Average value1998-06-01
 Maximum value1998-06-01

Table: HumanResources.Employee

PropertyValue
Table descriptionEmployee information such as salary, department, and title.
Analyzed columns16
Data rows290
Data size, bytes 41 213 or 0.06 % of database size
Average row size, bytes142.11
Minimum row size, bytes119
Maximum row size, bytes157
Column Statistics for 'HumanResources.Employee' table
ColumnPropertyValue
EmployeeIDData type and presentation sizeint identity, 10
 Data length, bytes4
 Actual data size, bytes 1 160 or 2.81 % of table size
 Minimum value 1
 Average value145.50
 Maximum value290
ColumnPropertyValue
NationalIDNumberData type and presentation sizenvarchar, 15
 Data length, bytes30
 Actual data size, bytes 2 561 or 6.21 % of table size
 Minimum value length5
 Maximum value length9
ColumnPropertyValue
ContactIDData type and presentation sizeint, 10
 Data length, bytes4
 Actual data size, bytes 1 160 or 2.81 % of table size
 Minimum value 1 001
 Average value 1 145.50
 Maximum value 1 290
ColumnPropertyValue
LoginIDData type and presentation sizenvarchar, 256
 Data length, bytes512
 Actual data size, bytes 6 492 or 15.75 % of table size
 Minimum value length19
 Maximum value length28
ColumnPropertyValue
ManagerIDData type and presentation sizeint, 10
 Data length, bytes4
 NULL values1 or 0.34 %
 Actual data size, bytes 1 156 or 2.80 % of table size
 Minimum value 3
 Average value107.83
 Maximum value288
ColumnPropertyValue
TitleData type and presentation sizenvarchar, 50
 Data length, bytes100
 Actual data size, bytes 7 224 or 17.53 % of table size
 Minimum value length5
 Maximum value length40
ColumnPropertyValue
BirthDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes 4 640 or 11.26 % of table size
 Minimum value1941-11-17
 Average value1968-07-05
 Maximum value1981-07-01
ColumnPropertyValue
MaritalStatusData type and presentation sizenchar, 1
 Data length, bytes2
 Actual data size, bytes580 or 1.41 % of table size
ColumnPropertyValue
GenderData type and presentation sizenchar, 1
 Data length, bytes2
 Actual data size, bytes580 or 1.41 % of table size
ColumnPropertyValue
HireDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes 4 640 or 11.26 % of table size
 Minimum value1996-08-00
 Average value1999-06-20
 Maximum value2003-07-01
ColumnPropertyValue
SalariedFlagData type and presentation sizeFlag, 1
 Data length, bytes1
 Actual data size, bytes290 or 0.70 % of table size
ColumnPropertyValue
VacationHoursData type and presentation sizesmallint, 5
 Data length, bytes2
 Actual data size, bytes580 or 1.41 % of table size
 Minimum value0
 Average value 50.61
 Maximum value 99
ColumnPropertyValue
SickLeaveHoursData type and presentation sizesmallint, 5
 Data length, bytes2
 Actual data size, bytes580 or 1.41 % of table size
 Minimum value 20
 Average value 45.30
 Maximum value 80
ColumnPropertyValue
CurrentFlagData type and presentation sizeFlag, 1
 Data length, bytes1
 Actual data size, bytes290 or 0.70 % of table size
ColumnPropertyValue
rowguidData type and presentation sizeuniqueidentifier, 36
 Data length, bytes16
 Actual data size, bytes 4 640 or 11.26 % of table size
ColumnPropertyValue
ModifiedDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes 4 640 or 11.26 % of table size
 Minimum value2004-08-00
 Average value2004-08-01
 Maximum value2005-01-26

Table: HumanResources.EmployeeAddress

PropertyValue
Table descriptionCross-reference table mapping employees to their address(es).
Analyzed columns4
Data rows290
Data size, bytes 11 600 or 0.02 % of database size
Table has fixed row size, bytes 40
Column Statistics for 'HumanResources.EmployeeAddress' table
ColumnPropertyValue
EmployeeIDData type and presentation sizeint, 10
 Data length, bytes4
 Actual data size, bytes 1 160 or 10.00 % of table size
 Minimum value 1
 Average value145.50
 Maximum value290
ColumnPropertyValue
AddressIDData type and presentation sizeint, 10
 Data length, bytes4
 Actual data size, bytes 1 160 or 10.00 % of table size
 Minimum value 1
 Average value 2 127.76
 Maximum value 32 521
ColumnPropertyValue
rowguidData type and presentation sizeuniqueidentifier, 36
 Data length, bytes16
 Actual data size, bytes 4 640 or 40.00 % of table size
ColumnPropertyValue
ModifiedDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes 4 640 or 40.00 % of table size
 Minimum value2004-10-13
 Average value2004-10-13
 Maximum value2004-10-13

Table: HumanResources.EmployeeDepartmentHistory

PropertyValue
Table descriptionEmployee department transfers.
Analyzed columns6
Data rows296
Data size, bytes 11 640 or 0.02 % of database size
Average row size, bytes 39.32
Minimum row size, bytes 39
Maximum row size, bytes 55
Column Statistics for 'HumanResources.EmployeeDepartmentHistory' table
ColumnPropertyValue
EmployeeIDData type and presentation sizeint, 10
 Data length, bytes4
 Actual data size, bytes 1 184 or 10.17 % of table size
 Minimum value 1
 Average value145.23
 Maximum value290
ColumnPropertyValue
DepartmentIDData type and presentation sizesmallint, 5
 Data length, bytes2
 Actual data size, bytes592 or 5.09 % of table size
 Minimum value 1
 Average value 7.26
 Maximum value 16
ColumnPropertyValue
ShiftIDData type and presentation sizetinyint, 3
 Data length, bytes1
 Actual data size, bytes296 or 2.54 % of table size
 Minimum value 1
 Average value 1.56
 Maximum value 3
ColumnPropertyValue
StartDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes 4 736 or 40.69 % of table size
 Minimum value1996-08-00
 Average value1999-07-06
 Maximum value2003-12-16
ColumnPropertyValue
EndDateData type and presentation sizedatetime, 23
 Data length, bytes16
 NULL values290 or 97.97 %
 Actual data size, bytes 96 or 0.82 % of table size
 Minimum value1999-08-15
 Average value2001-09-06
 Maximum value2003-12-15
ColumnPropertyValue
ModifiedDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes 4 736 or 40.69 % of table size
 Minimum value1996-07-30
 Average value1999-07-21
 Maximum value2003-12-15

Table: HumanResources.EmployeePayHistory

PropertyValue
Table descriptionEmployee pay history.
Analyzed columns5
Data rows316
Data size, bytes 18 328 or 0.03 % of database size
Table has fixed row size, bytes 58
Column Statistics for 'HumanResources.EmployeePayHistory' table
ColumnPropertyValue
EmployeeIDData type and presentation sizeint, 10
 Data length, bytes4
 Actual data size, bytes 1 264 or 6.90 % of table size
 Minimum value 1
 Average value143.38
 Maximum value290
ColumnPropertyValue
RateChangeDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes 5 056 or 27.59 % of table size
 Minimum value1996-08-00
 Average value1999-09-14
 Maximum value2003-08-15
ColumnPropertyValue
RateData type and presentation sizemoney, 19
 Data length, bytes21
 Actual data size, bytes 6 636 or 36.21 % of table size
 Minimum value 6.50
 Average value 6 636 or 36.21 % of table size
 Maximum value125.50
ColumnPropertyValue
PayFrequencyData type and presentation sizetinyint, 3
 Data length, bytes1
 Actual data size, bytes316 or 1.72 % of table size
 Minimum value 1
 Average value 1.43
 Maximum value 2
ColumnPropertyValue
ModifiedDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes 5 056 or 27.59 % of table size
 Minimum value1997-12-22
 Average value2004-03-02
 Maximum value2004-08-00

Table: HumanResources.JobCandidate

PropertyValue
Table descriptionResumes submitted to Human Resources by job applicants.
Analyzed columns4
Data rows 13
Data size, bytes268 or 0.00 % of database size
Average row size, bytes 20.61
Minimum row size, bytes 20
Maximum row size, bytes 24
Column Statistics for 'HumanResources.JobCandidate' table
ColumnPropertyValue
JobCandidateIDData type and presentation sizeint identity, 10
 Data length, bytes4
 Actual data size, bytes 52 or 19.40 % of table size
 Minimum value 1
 Average value 7.00
 Maximum value 13
ColumnPropertyValue
EmployeeIDData type and presentation sizeint, 10
 Data length, bytes4
 NULL values11 or 84.62 %
 Actual data size, bytes 8 or 2.99 % of table size
 Minimum value 41
 Average value 23.76
 Maximum value268
ColumnPropertyValue
ResumeData type and presentation sizexml, 128
 Data length, bytes0
 Actual data size, bytes0 or 0.00 % of table size
ColumnPropertyValue
ModifiedDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes208 or 77.61 % of table size
 Minimum value1997-07-24
 Average value1998-07-24
 Maximum value2004-01-23

Table: HumanResources.Shift

PropertyValue
Table descriptionWork shift lookup table.
Analyzed columns5
Data rows 3
Data size, bytes162 or 0.00 % of database size
Average row size, bytes 54.00
Minimum row size, bytes 52
Maximum row size, bytes 56
Column Statistics for 'HumanResources.Shift' table
ColumnPropertyValue
ShiftIDData type and presentation sizetinyint identity, 3
 Data length, bytes1
 Actual data size, bytes 3 or 1.85 % of table size
 Minimum value 1
 Average value 2.00
 Maximum value 3
ColumnPropertyValue
NameData type and presentation sizeName, 50
 Data length, bytes100
 Actual data size, bytes 15 or 9.26 % of table size
 Minimum value length3
 Maximum value length7
ColumnPropertyValue
StartTimeData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes 48 or 29.63 % of table size
 Minimum value1901-01-01
 Average value1901-01-01
 Maximum value1901-01-01
ColumnPropertyValue
EndTimeData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes 48 or 29.63 % of table size
 Minimum value1901-01-01
 Average value1901-01-01
 Maximum value1901-01-01
ColumnPropertyValue
ModifiedDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes 48 or 29.63 % of table size
 Minimum value1998-06-01
 Average value1998-06-01
 Maximum value1998-06-01

Table: Person.Address

PropertyValue
Table descriptionStreet address information for customers, employees, and vendors.
Analyzed columns8
Data rows 19 614
Data size, bytes 1 398 756 or 2.00 % of database size
Average row size, bytes 71.31
Minimum row size, bytes 57
Maximum row size, bytes102
Column Statistics for 'Person.Address' table
ColumnPropertyValue
AddressIDData type and presentation sizeint identity, 10
 Data length, bytes4
 Actual data size, bytes 78 456 or 5.61 % of table size
 Minimum value 1
 Average value 19 516.28
 Maximum value 32 521
ColumnPropertyValue
AddressLine1Data type and presentation sizenvarchar, 60
 Data length, bytes120
 Actual data size, bytes342 670 or 24.50 % of table size
 Minimum value length5
 Maximum value length39
ColumnPropertyValue
AddressLine2Data type and presentation sizenvarchar, 60
 Data length, bytes120
 NULL values19252 or 98.15 %
 Actual data size, bytes 2 880 or 0.21 % of table size
 Minimum value length1
 Maximum value length28
ColumnPropertyValue
CityData type and presentation sizenvarchar, 30
 Data length, bytes60
 Actual data size, bytes172 148 or 12.31 % of table size
 Minimum value length3
 Maximum value length21
ColumnPropertyValue
StateProvinceIDData type and presentation sizeint, 10
 Data length, bytes4
 Actual data size, bytes 78 456 or 5.61 % of table size
 Minimum value 1
 Average value 49.28
 Maximum value181
ColumnPropertyValue
PostalCodeData type and presentation sizenvarchar, 15
 Data length, bytes30
 Actual data size, bytes 96 498 or 6.90 % of table size
 Minimum value length2
 Maximum value length10
ColumnPropertyValue
rowguidData type and presentation sizeuniqueidentifier, 36
 Data length, bytes16
 Actual data size, bytes313 824 or 22.44 % of table size
ColumnPropertyValue
ModifiedDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes313 824 or 22.44 % of table size
 Minimum value1996-07-24
 Average value2003-07-23
 Maximum value2004-08-00

Table: Person.AddressType

PropertyValue
Table descriptionTypes of addresses stored in the Address table.
Analyzed columns4
Data rows 6
Data size, bytes260 or 0.00 % of database size
Average row size, bytes 43.33
Minimum row size, bytes 40
Maximum row size, bytes 47
Column Statistics for 'Person.AddressType' table
ColumnPropertyValue
AddressTypeIDData type and presentation sizeint identity, 10
 Data length, bytes4
 Actual data size, bytes 24 or 9.23 % of table size
 Minimum value 1
 Average value 3.50
 Maximum value 6
ColumnPropertyValue
NameData type and presentation sizeName, 50
 Data length, bytes100
 Actual data size, bytes 44 or 16.92 % of table size
 Minimum value length4
 Maximum value length11
ColumnPropertyValue
rowguidData type and presentation sizeuniqueidentifier, 36
 Data length, bytes16
 Actual data size, bytes 96 or 36.92 % of table size
ColumnPropertyValue
ModifiedDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes 96 or 36.92 % of table size
 Minimum value1998-06-01
 Average value1998-06-01
 Maximum value1998-06-01

Table: Person.Contact

PropertyValue
Table descriptionNames of each employee, customer contact, and vendor contact.
Analyzed columns15
Data rows 19 972
Data size, bytes 2 957 444 or 4.23 % of database size
Average row size, bytes148.07
Minimum row size, bytes134
Maximum row size, bytes181
Column Statistics for 'Person.Contact' table
ColumnPropertyValue
ContactIDData type and presentation sizeint identity, 10
 Data length, bytes4
 Actual data size, bytes 79 888 or 2.70 % of table size
 Minimum value 1
 Average value 9 991.25
 Maximum value 19 977
ColumnPropertyValue
NameStyleData type and presentation sizeNameStyle, 1
 Data length, bytes1
 Actual data size, bytes 19 972 or 0.68 % of table size
ColumnPropertyValue
TitleData type and presentation sizenvarchar, 8
 Data length, bytes16
 NULL values18963 or 94.95 %
 Actual data size, bytes 3 031 or 0.10 % of table size
 Minimum value length2
 Maximum value length4
ColumnPropertyValue
FirstNameData type and presentation sizeName, 50
 Data length, bytes100
 Actual data size, bytes117 910 or 3.99 % of table size
 Minimum value length2
 Maximum value length24
ColumnPropertyValue
MiddleNameData type and presentation sizeName, 50
 Data length, bytes100
 NULL values8499 or 42.55 %
 Actual data size, bytes 12 175 or 0.41 % of table size
 Minimum value length1
 Maximum value length16
ColumnPropertyValue
LastNameData type and presentation sizeName, 50
 Data length, bytes100
 Actual data size, bytes111 969 or 3.79 % of table size
 Minimum value length2
 Maximum value length22
ColumnPropertyValue
SuffixData type and presentation sizenvarchar, 10
 Data length, bytes20
 NULL values19919 or 99.73 %
 Actual data size, bytes150 or 0.01 % of table size
 Minimum value length2
 Maximum value length3
ColumnPropertyValue
EmailAddressData type and presentation sizenvarchar, 50
 Data length, bytes100
 Actual data size, bytes550 840 or 18.63 % of table size
 Minimum value length22
 Maximum value length43
ColumnPropertyValue
EmailPromotionData type and presentation sizeint, 10
 Data length, bytes4
 Actual data size, bytes 79 888 or 2.70 % of table size
 Minimum value0
 Average value0.63
 Maximum value 2
ColumnPropertyValue
PhoneData type and presentation sizePhone, 25
 Data length, bytes50
 Actual data size, bytes303 973 or 10.28 % of table size
 Minimum value length12
 Maximum value length19
ColumnPropertyValue
PasswordHashData type and presentation sizevarchar, 128
 Data length, bytes128
 Actual data size, bytes878 768 or 29.71 % of table size
 Minimum value length44
 Maximum value length44
ColumnPropertyValue
PasswordSaltData type and presentation sizevarchar, 10
 Data length, bytes10
 Actual data size, bytes159 776 or 5.40 % of table size
 Minimum value length8
 Maximum value length8
ColumnPropertyValue
AdditionalContactInfoData type and presentation sizexml, 128
 Data length, bytes0
 NULL values19962 or 99.95 %
 Actual data size, bytes0 or 0.00 % of table size
ColumnPropertyValue
rowguidData type and presentation sizeuniqueidentifier, 36
 Data length, bytes16
 Actual data size, bytes319 552 or 10.81 % of table size
ColumnPropertyValue
ModifiedDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes319 552 or 10.81 % of table size
 Minimum value1996-07-24
 Average value2003-06-18
 Maximum value2005-05-16

Table: Person.ContactType

PropertyValue
Table descriptionLookup table containing the types of contacts stored in Contact.
Analyzed columns3
Data rows 20
Data size, bytes795 or 0.00 % of database size
Average row size, bytes 39.75
Minimum row size, bytes 25
Maximum row size, bytes 51
Column Statistics for 'Person.ContactType' table
ColumnPropertyValue
ContactTypeIDData type and presentation sizeint identity, 10
 Data length, bytes4
 Actual data size, bytes 80 or 10.06 % of table size
 Minimum value 1
 Average value 10.50
 Maximum value 20
ColumnPropertyValue
NameData type and presentation sizeName, 50
 Data length, bytes100
 Actual data size, bytes395 or 49.69 % of table size
 Minimum value length5
 Maximum value length31
ColumnPropertyValue
ModifiedDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes320 or 40.25 % of table size
 Minimum value1998-06-01
 Average value1998-06-01
 Maximum value1998-06-01

Table: Person.CountryRegion

PropertyValue
Table descriptionLookup table containing the ISO standard codes for countries and regions.
Analyzed columns3
Data rows238
Data size, bytes 6 679 or 0.01 % of database size
Average row size, bytes 28.06
Minimum row size, bytes 22
Maximum row size, bytes 62
Column Statistics for 'Person.CountryRegion' table
ColumnPropertyValue
CountryRegionCodeData type and presentation sizenvarchar, 3
 Data length, bytes6
 Actual data size, bytes476 or 7.13 % of table size
 Minimum value length2
 Maximum value length2
ColumnPropertyValue
NameData type and presentation sizeName, 50
 Data length, bytes100
 Actual data size, bytes 2 395 or 35.86 % of table size
 Minimum value length4
 Maximum value length44
ColumnPropertyValue
ModifiedDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes 3 808 or 57.01 % of table size
 Minimum value1998-06-01
 Average value1998-06-01
 Maximum value1998-06-01

Table: Person.StateProvince

PropertyValue
Table descriptionState and province lookup table.
Analyzed columns8
Data rows181
Data size, bytes 10 576 or 0.02 % of database size
Average row size, bytes 58.43
Minimum row size, bytes 52
Maximum row size, bytes 73
Column Statistics for 'Person.StateProvince' table
ColumnPropertyValue
StateProvinceIDData type and presentation sizeint identity, 10
 Data length, bytes4
 Actual data size, bytes724 or 6.85 % of table size
 Minimum value 1
 Average value 91.00
 Maximum value181
ColumnPropertyValue
StateProvinceCodeData type and presentation sizenchar, 3
 Data length, bytes6
 Actual data size, bytes 1 086 or 10.27 % of table size
ColumnPropertyValue
CountryRegionCodeData type and presentation sizenvarchar, 3
 Data length, bytes6
 Actual data size, bytes362 or 3.42 % of table size
 Minimum value length2
 Maximum value length2
ColumnPropertyValue
IsOnlyStateProvinceFlagData type and presentation sizeFlag, 1
 Data length, bytes1
 Actual data size, bytes181 or 1.71 % of table size
ColumnPropertyValue
NameData type and presentation sizeName, 50
 Data length, bytes100
 Actual data size, bytes 1 707 or 16.14 % of table size
 Minimum value length3
 Maximum value length24
ColumnPropertyValue
TerritoryIDData type and presentation sizeint, 10
 Data length, bytes4
 Actual data size, bytes724 or 6.85 % of table size
 Minimum value 1
 Average value 5.83
 Maximum value 10
ColumnPropertyValue
rowguidData type and presentation sizeuniqueidentifier, 36
 Data length, bytes16
 Actual data size, bytes 2 896 or 27.38 % of table size
ColumnPropertyValue
ModifiedDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes 2 896 or 27.38 % of table size
 Minimum value1998-06-01
 Average value2001-01-23
 Maximum value2004-03-11

Table: Production.BillOfMaterials

PropertyValue
Table descriptionItems required to make bicycles and bicycle subassemblies. It identifies the heirarchical relationship between a parent product and its components.
Analyzed columns9
Data rows 2 679
Data size, bytes168 870 or 0.24 % of database size
Average row size, bytes 63.03
Minimum row size, bytes 58
Maximum row size, bytes 78
Column Statistics for 'Production.BillOfMaterials' table
ColumnPropertyValue
BillOfMaterialsIDData type and presentation sizeint identity, 10
 Data length, bytes4
 Actual data size, bytes 10 716 or 6.35 % of table size
 Minimum value 1
 Average value 1 760.27
 Maximum value 3 482
ColumnPropertyValue
ProductAssemblyIDData type and presentation sizeint, 10
 Data length, bytes4
 NULL values103 or 3.84 %
 Actual data size, bytes 10 304 or 6.10 % of table size
 Minimum value 3
 Average value805.47
 Maximum value999
ColumnPropertyValue
ComponentIDData type and presentation sizeint, 10
 Data length, bytes4
 Actual data size, bytes 10 716 or 6.35 % of table size
 Minimum value 1
 Average value701.77
 Maximum value999
ColumnPropertyValue
StartDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes 42 864 or 25.38 % of table size
 Minimum value2000-04-04
 Average value2000-08-13
 Maximum value2001-01-23
ColumnPropertyValue
EndDateData type and presentation sizedatetime, 23
 Data length, bytes16
 NULL values2480 or 92.57 %
 Actual data size, bytes 3 184 or 1.89 % of table size
 Minimum value2000-06-03
 Average value2000-09-09
 Maximum value2000-12-15
ColumnPropertyValue
UnitMeasureCodeData type and presentation sizenchar, 3
 Data length, bytes6
 Actual data size, bytes 16 074 or 9.52 % of table size
ColumnPropertyValue
BOMLevelData type and presentation sizesmallint, 5
 Data length, bytes2
 Actual data size, bytes 5 358 or 3.17 % of table size
 Minimum value 1
 Average value 1.35
 Maximum value 4
ColumnPropertyValue
PerAssemblyQtyData type and presentation sizedecimal, 8
 Data length, bytes10
 Actual data size, bytes 26 790 or 15.86 % of table size
 Minimum value 1.00
 Average value 26 790 or 15.86 % of table size
 Maximum value 41.00
ColumnPropertyValue
ModifiedDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes 42 864 or 25.38 % of table size
 Minimum value2000-03-21
 Average value2000-08-05
 Maximum value2001-01-09

Table: Production.Culture

PropertyValue
Table descriptionLookup table containing the languages in which some AdventureWorks data is stored.
Analyzed columns3
Data rows 8
Data size, bytes305 or 0.00 % of database size
Average row size, bytes 38.12
Minimum row size, bytes 32
Maximum row size, bytes 66
Column Statistics for 'Production.Culture' table
ColumnPropertyValue
CultureIDData type and presentation sizenchar, 6
 Data length, bytes12
 Actual data size, bytes 96 or 31.48 % of table size
ColumnPropertyValue
NameData type and presentation sizeName, 50
 Data length, bytes100
 Actual data size, bytes 81 or 26.56 % of table size
 Minimum value length4
 Maximum value length38
ColumnPropertyValue
ModifiedDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes128 or 41.97 % of table size
 Minimum value1998-06-01
 Average value1998-06-01
 Maximum value1998-06-01

Table: Production.Document

PropertyValue
Table descriptionProduct maintenance documents.
Analyzed columns10
Data rows 9
Data size, bytes291 203 or 0.42 % of database size
Average row size, bytes 32 355.88
Minimum row size, bytes 23 138
Maximum row size, bytes 47 136
Column Statistics for 'Production.Document' table
ColumnPropertyValue
DocumentIDData type and presentation sizeint identity, 10
 Data length, bytes4
 Actual data size, bytes 36 or 0.01 % of table size
 Minimum value 1
 Average value 5.00
 Maximum value 9
ColumnPropertyValue
TitleData type and presentation sizenvarchar, 50
 Data length, bytes100
 Actual data size, bytes239 or 0.08 % of table size
 Minimum value length13
 Maximum value length48
ColumnPropertyValue
FileNameData type and presentation sizenvarchar, 400
 Data length, bytes800
 Actual data size, bytes 1 427 or 0.49 % of table size
 Minimum value length145
 Maximum value length180
ColumnPropertyValue
FileExtensionData type and presentation sizenvarchar, 8
 Data length, bytes16
 Actual data size, bytes 36 or 0.01 % of table size
 Minimum value length4
 Maximum value length4
ColumnPropertyValue
RevisionData type and presentation sizenchar, 5
 Data length, bytes10
 Actual data size, bytes 90 or 0.03 % of table size
ColumnPropertyValue
ChangeNumberData type and presentation sizeint, 10
 Data length, bytes4
 Actual data size, bytes 36 or 0.01 % of table size
 Minimum value 8
 Average value 51.33
 Maximum value288
ColumnPropertyValue
StatusData type and presentation sizetinyint, 3
 Data length, bytes1
 Actual data size, bytes 9 or 0.00 % of table size
 Minimum value 1
 Average value 1.88
 Maximum value 3
ColumnPropertyValue
DocumentSummaryData type and presentation sizenvarchar, 128
 Data length, bytes0
 NULL values4 or 44.44 %
 Actual data size, bytes 1 442 or 0.50 % of table size
 Minimum value length206
 Maximum value length393
ColumnPropertyValue
DocumentData type and presentation sizevarbinary, 128
 Data length, bytes0
 Actual data size, bytes287 744 or 98.81 % of table size
ColumnPropertyValue
ModifiedDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes144 or 0.05 % of table size
 Minimum value1998-05-02
 Average value2002-06-26
 Maximum value2003-07-01

Table: Production.Illustration

PropertyValue
Table descriptionBicycle assembly diagrams.
Analyzed columns3
Data rows 5
Data size, bytes100 or 0.00 % of database size
Table has fixed row size, bytes 20
Column Statistics for 'Production.Illustration' table
ColumnPropertyValue
IllustrationIDData type and presentation sizeint identity, 10
 Data length, bytes4
 Actual data size, bytes 20 or 20.00 % of table size
 Minimum value 3
 Average value 5.00
 Maximum value 7
ColumnPropertyValue
DiagramData type and presentation sizexml, 128
 Data length, bytes0
 Actual data size, bytes0 or 0.00 % of table size
ColumnPropertyValue
ModifiedDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes 80 or 80.00 % of table size
 Minimum value2004-02-10
 Average value2004-02-10
 Maximum value2004-02-10

Table: Production.Location

PropertyValue
Table descriptionProduct inventory and manufacturing locations.
Analyzed columns5
Data rows 14
Data size, bytes754 or 0.00 % of database size
Average row size, bytes 53.85
Minimum row size, bytes 45
Maximum row size, bytes 62
Column Statistics for 'Production.Location' table
ColumnPropertyValue
LocationIDData type and presentation sizesmallint identity, 5
 Data length, bytes2
 Actual data size, bytes 28 or 3.71 % of table size
 Minimum value 1
 Average value 20.21
 Maximum value 60
ColumnPropertyValue
NameData type and presentation sizeName, 50
 Data length, bytes100
 Actual data size, bytes194 or 25.73 % of table size
 Minimum value length5
 Maximum value length22
ColumnPropertyValue
CostRateData type and presentation sizesmallmoney, 10
 Data length, bytes12
 Actual data size, bytes168 or 22.28 % of table size
 Minimum value 12.25
 Average value168 or 22.28 % of table size
 Maximum value 25.00
ColumnPropertyValue
AvailabilityData type and presentation sizedecimal, 8
 Data length, bytes10
 Actual data size, bytes140 or 18.57 % of table size
 Minimum value 80.00
 Average value140 or 18.57 % of table size
 Maximum value120.00
ColumnPropertyValue
ModifiedDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes224 or 29.71 % of table size
 Minimum value1998-06-01
 Average value1998-06-01
 Maximum value1998-06-01

Table: Production.Product

PropertyValue
Table descriptionProducts sold or used in the manfacturing of sold products.
Analyzed columns25
Data rows504
Data size, bytes 78 729 or 0.11 % of database size
Average row size, bytes156.20
Minimum row size, bytes115
Maximum row size, bytes210
Column Statistics for 'Production.Product' table
ColumnPropertyValue
ProductIDData type and presentation sizeint identity, 10
 Data length, bytes4
 Actual data size, bytes 2 016 or 2.56 % of table size
 Minimum value 1
 Average value673.03
 Maximum value999
ColumnPropertyValue
NameData type and presentation sizeName, 50
 Data length, bytes100
 Actual data size, bytes 9 278 or 11.78 % of table size
 Minimum value length4
 Maximum value length32
ColumnPropertyValue
ProductNumberData type and presentation sizenvarchar, 25
 Data length, bytes50
 Actual data size, bytes 4 131 or 5.25 % of table size
 Minimum value length7
 Maximum value length10
ColumnPropertyValue
MakeFlagData type and presentation sizeFlag, 1
 Data length, bytes1
 Actual data size, bytes504 or 0.64 % of table size
ColumnPropertyValue
FinishedGoodsFlagData type and presentation sizeFlag, 1
 Data length, bytes1
 Actual data size, bytes504 or 0.64 % of table size
ColumnPropertyValue
ColorData type and presentation sizenvarchar, 15
 Data length, bytes30
 NULL values248 or 49.21 %
 Actual data size, bytes 1 305 or 1.66 % of table size
 Minimum value length3
 Maximum value length12
ColumnPropertyValue
SafetyStockLevelData type and presentation sizesmallint, 5
 Data length, bytes2
 Actual data size, bytes 1 008 or 1.28 % of table size
 Minimum value 4
 Average value535.15
 Maximum value 1 000
ColumnPropertyValue
ReorderPointData type and presentation sizesmallint, 5
 Data length, bytes2
 Actual data size, bytes 1 008 or 1.28 % of table size
 Minimum value 3
 Average value401.36
 Maximum value750
ColumnPropertyValue
StandardCostData type and presentation sizemoney, 19
 Data length, bytes21
 Actual data size, bytes 10 584 or 13.44 % of table size
 Minimum value0.00
 Average value 10 584 or 13.44 % of table size
 Maximum value 2 171.29
ColumnPropertyValue
ListPriceData type and presentation sizemoney, 19
 Data length, bytes21
 Actual data size, bytes 10 584 or 13.44 % of table size
 Minimum value0.00
 Average value 10 584 or 13.44 % of table size
 Maximum value 3 578.26
ColumnPropertyValue
SizeData type and presentation sizenvarchar, 5
 Data length, bytes10
 NULL values293 or 58.13 %
 Actual data size, bytes391 or 0.50 % of table size
 Minimum value length1
 Maximum value length2
ColumnPropertyValue
SizeUnitMeasureCodeData type and presentation sizenchar, 3
 Data length, bytes6
 NULL values328 or 65.08 %
 Actual data size, bytes 1 056 or 1.34 % of table size
ColumnPropertyValue
WeightUnitMeasureCodeData type and presentation sizenchar, 3
 Data length, bytes6
 NULL values299 or 59.33 %
 Actual data size, bytes 1 230 or 1.56 % of table size
ColumnPropertyValue
WeightData type and presentation sizedecimal, 8
 Data length, bytes10
 NULL values299 or 59.33 %
 Actual data size, bytes 2 050 or 2.60 % of table size
 Minimum value 2.12
 Average value 2 050 or 2.60 % of table size
 Maximum value 1 050.00
ColumnPropertyValue
DaysToManufactureData type and presentation sizeint, 10
 Data length, bytes4
 Actual data size, bytes 2 016 or 2.56 % of table size
 Minimum value0
 Average value 1.10
 Maximum value 4
ColumnPropertyValue
ProductLineData type and presentation sizenchar, 2
 Data length, bytes4
 NULL values226 or 44.84 %
 Actual data size, bytes 1 112 or 1.41 % of table size
ColumnPropertyValue
ClassData type and presentation sizenchar, 2
 Data length, bytes4
 NULL values257 or 50.99 %
 Actual data size, bytes988 or 1.25 % of table size
ColumnPropertyValue
StyleData type and presentation sizenchar, 2
 Data length, bytes4
 NULL values293 or 58.13 %
 Actual data size, bytes844 or 1.07 % of table size
ColumnPropertyValue
ProductSubcategoryIDData type and presentation sizeint, 10
 Data length, bytes4
 NULL values209 or 41.47 %
 Actual data size, bytes 1 180 or 1.50 % of table size
 Minimum value 1
 Average value 7.19
 Maximum value 37
ColumnPropertyValue
ProductModelIDData type and presentation sizeint, 10
 Data length, bytes4
 NULL values209 or 41.47 %
 Actual data size, bytes 1 180 or 1.50 % of table size
 Minimum value 1
 Average value 21.91
 Maximum value128
ColumnPropertyValue
SellStartDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes 8 064 or 10.24 % of table size
 Minimum value1998-06-01
 Average value2000-12-00
 Maximum value2003-07-01
ColumnPropertyValue
SellEndDateData type and presentation sizedatetime, 23
 Data length, bytes16
 NULL values406 or 80.56 %
 Actual data size, bytes 1 568 or 1.99 % of table size
 Minimum value2002-07-00
 Average value2003-03-13
 Maximum value2003-07-00
ColumnPropertyValue
DiscontinuedDateData type and presentation sizedatetime, 23
 Data length, bytes16
 NULL values504 or 100.00 %
 Actual data size, bytes0 or 0.00 % of table size
 Minimum value1901-01-00
 Maximum value1901-01-00
ColumnPropertyValue
rowguidData type and presentation sizeuniqueidentifier, 36
 Data length, bytes16
 Actual data size, bytes 8 064 or 10.24 % of table size
ColumnPropertyValue
ModifiedDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes 8 064 or 10.24 % of table size
 Minimum value2004-03-11
 Average value2004-03-11
 Maximum value2004-03-11

Table: Production.ProductCategory

PropertyValue
Table descriptionHigh-level product categorization.
Analyzed columns4
Data rows 4
Data size, bytes178 or 0.00 % of database size
Average row size, bytes 44.50
Minimum row size, bytes 41
Maximum row size, bytes 47
Column Statistics for 'Production.ProductCategory' table
ColumnPropertyValue
ProductCategoryIDData type and presentation sizeint identity, 10
 Data length, bytes4
 Actual data size, bytes 16 or 8.99 % of table size
 Minimum value 1
 Average value 2.50
 Maximum value 4
ColumnPropertyValue
NameData type and presentation sizeName, 50
 Data length, bytes100
 Actual data size, bytes 34 or 19.10 % of table size
 Minimum value length5
 Maximum value length11
ColumnPropertyValue
rowguidData type and presentation sizeuniqueidentifier, 36
 Data length, bytes16
 Actual data size, bytes 64 or 35.96 % of table size
ColumnPropertyValue
ModifiedDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes 64 or 35.96 % of table size
 Minimum value1998-06-01
 Average value1998-06-01
 Maximum value1998-06-01

Table: Production.ProductCostHistory

PropertyValue
Table descriptionChanges in the cost of a product over time.
Analyzed columns5
Data rows395
Data size, bytes 25 715 or 0.04 % of database size
Average row size, bytes 65.10
Minimum row size, bytes 57
Maximum row size, bytes 73
Column Statistics for 'Production.ProductCostHistory' table
ColumnPropertyValue
ProductIDData type and presentation sizeint, 10
 Data length, bytes4
 Actual data size, bytes 1 580 or 6.14 % of table size
 Minimum value707
 Average value828.72
 Maximum value999
ColumnPropertyValue
StartDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes 6 320 or 24.58 % of table size
 Minimum value2001-07-01
 Average value2002-10-22
 Maximum value2003-07-01
ColumnPropertyValue
EndDateData type and presentation sizedatetime, 23
 Data length, bytes16
 NULL values195 or 49.37 %
 Actual data size, bytes 3 200 or 12.44 % of table size
 Minimum value2002-07-00
 Average value2003-02-18
 Maximum value2003-07-00
ColumnPropertyValue
StandardCostData type and presentation sizemoney, 19
 Data length, bytes21
 Actual data size, bytes 8 295 or 32.26 % of table size
 Minimum value0.85
 Average value 8 295 or 32.26 % of table size
 Maximum value 2 171.29
ColumnPropertyValue
ModifiedDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes 6 320 or 24.58 % of table size
 Minimum value2002-07-00
 Average value2003-04-18
 Maximum value2003-07-00

Table: Production.ProductDescription

PropertyValue
Table descriptionProduct descriptions in several languages.
Analyzed columns4
Data rows762
Data size, bytes 79 678 or 0.11 % of database size
Average row size, bytes104.56
Minimum row size, bytes 39
Maximum row size, bytes305
Column Statistics for 'Production.ProductDescription' table
ColumnPropertyValue
ProductDescriptionIDData type and presentation sizeint identity, 10
 Data length, bytes4
 Actual data size, bytes 3 048 or 3.83 % of table size
 Minimum value 3
 Average value 1 542.58
 Maximum value 2 010
ColumnPropertyValue
DescriptionData type and presentation sizenvarchar, 400
 Data length, bytes800
 Actual data size, bytes 52 246 or 65.57 % of table size
 Minimum value length3
 Maximum value length269
ColumnPropertyValue
rowguidData type and presentation sizeuniqueidentifier, 36
 Data length, bytes16
 Actual data size, bytes 12 192 or 15.30 % of table size
ColumnPropertyValue
ModifiedDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes 12 192 or 15.30 % of table size
 Minimum value2003-06-01
 Average value2003-07-17
 Maximum value2004-03-11

Table: Production.ProductDocument

PropertyValue
Table descriptionCross-reference table mapping products to related product documents.
Analyzed columns3
Data rows 32
Data size, bytes768 or 0.00 % of database size
Table has fixed row size, bytes 24
Column Statistics for 'Production.ProductDocument' table
ColumnPropertyValue
ProductIDData type and presentation sizeint, 10
 Data length, bytes4
 Actual data size, bytes128 or 16.67 % of table size
 Minimum value317
 Average value740.06
 Maximum value999
ColumnPropertyValue
DocumentIDData type and presentation sizeint, 10
 Data length, bytes4
 Actual data size, bytes128 or 16.67 % of table size
 Minimum value 1
 Average value 4.21
 Maximum value 8
ColumnPropertyValue
ModifiedDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes512 or 66.67 % of table size
 Minimum value2004-01-30
 Average value2004-01-30
 Maximum value2004-01-30

Table: Production.ProductInventory

PropertyValue
Table descriptionProduct inventory information.
Analyzed columns7
Data rows 1 069
Data size, bytes 45 478 or 0.07 % of database size
Average row size, bytes 42.54
Minimum row size, bytes 42
Maximum row size, bytes 44
Column Statistics for 'Production.ProductInventory' table
ColumnPropertyValue
ProductIDData type and presentation sizeint, 10
 Data length, bytes4
 Actual data size, bytes 4 276 or 9.40 % of table size
 Minimum value 1
 Average value611.96
 Maximum value999
ColumnPropertyValue
LocationIDData type and presentation sizesmallint, 5
 Data length, bytes2
 Actual data size, bytes 2 138 or 4.70 % of table size
 Minimum value 1
 Average value 23.68
 Maximum value 60
ColumnPropertyValue
ShelfData type and presentation sizenvarchar, 10
 Data length, bytes20
 Actual data size, bytes 1 649 or 3.63 % of table size
 Minimum value length1
 Maximum value length3
ColumnPropertyValue
BinData type and presentation sizetinyint, 3
 Data length, bytes1
 Actual data size, bytes 1 069 or 2.35 % of table size
 Minimum value0
 Average value 8.89
 Maximum value 61
ColumnPropertyValue
QuantityData type and presentation sizesmallint, 5
 Data length, bytes2
 Actual data size, bytes 2 138 or 4.70 % of table size
 Minimum value0
 Average value314.28
 Maximum value924
ColumnPropertyValue
rowguidData type and presentation sizeuniqueidentifier, 36
 Data length, bytes16
 Actual data size, bytes 17 104 or 37.61 % of table size
ColumnPropertyValue
ModifiedDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes 17 104 or 37.61 % of table size
 Minimum value1998-05-02
 Average value2003-06-27
 Maximum value2004-09-12

Table: Production.ProductListPriceHistory

PropertyValue
Table descriptionChanges in the list price of a product over time.
Analyzed columns5
Data rows395
Data size, bytes 25 715 or 0.04 % of database size
Average row size, bytes 65.10
Minimum row size, bytes 57
Maximum row size, bytes 73
Column Statistics for 'Production.ProductListPriceHistory' table
ColumnPropertyValue
ProductIDData type and presentation sizeint, 10
 Data length, bytes4
 Actual data size, bytes 1 580 or 6.14 % of table size
 Minimum value707
 Average value828.72
 Maximum value999
ColumnPropertyValue
StartDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes 6 320 or 24.58 % of table size
 Minimum value2001-07-01
 Average value2002-10-22
 Maximum value2003-07-01
ColumnPropertyValue
EndDateData type and presentation sizedatetime, 23
 Data length, bytes16
 NULL values195 or 49.37 %
 Actual data size, bytes 3 200 or 12.44 % of table size
 Minimum value2002-07-00
 Average value2003-02-18
 Maximum value2003-07-00
ColumnPropertyValue
ListPriceData type and presentation sizemoney, 19
 Data length, bytes21
 Actual data size, bytes 8 295 or 32.26 % of table size
 Minimum value 2.29
 Average value 8 295 or 32.26 % of table size
 Maximum value 3 578.26
ColumnPropertyValue
ModifiedDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes 6 320 or 24.58 % of table size
 Minimum value2002-07-00
 Average value2003-04-14
 Maximum value2003-07-00

Table: Production.ProductModel

PropertyValue
Table descriptionProduct model classification.
Analyzed columns6
Data rows128
Data size, bytes 6 645 or 0.01 % of database size
Average row size, bytes 51.91
Minimum row size, bytes 41
Maximum row size, bytes 63
Column Statistics for 'Production.ProductModel' table
ColumnPropertyValue
ProductModelIDData type and presentation sizeint identity, 10
 Data length, bytes4
 Actual data size, bytes512 or 7.71 % of table size
 Minimum value 1
 Average value 64.50
 Maximum value128
ColumnPropertyValue
NameData type and presentation sizeName, 50
 Data length, bytes100
 Actual data size, bytes 2 037 or 30.65 % of table size
 Minimum value length5
 Maximum value length27
ColumnPropertyValue
CatalogDescriptionData type and presentation sizexml, 128
 Data length, bytes0
 NULL values122 or 95.31 %
 Actual data size, bytes0 or 0.00 % of table size
ColumnPropertyValue
InstructionsData type and presentation sizexml, 128
 Data length, bytes0
 NULL values119 or 92.97 %
 Actual data size, bytes0 or 0.00 % of table size
ColumnPropertyValue
rowguidData type and presentation sizeuniqueidentifier, 36
 Data length, bytes16
 Actual data size, bytes 2 048 or 30.82 % of table size
ColumnPropertyValue
ModifiedDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes 2 048 or 30.82 % of table size
 Minimum value1998-05-02
 Average value2002-12-15
 Maximum value2005-05-16

Table: Production.ProductModelIllustration

PropertyValue
Table descriptionCross-reference table mapping product models and illustrations.
Analyzed columns3
Data rows 7
Data size, bytes168 or 0.00 % of database size
Table has fixed row size, bytes 24
Column Statistics for 'Production.ProductModelIllustration' table
ColumnPropertyValue
ProductModelIDData type and presentation sizeint, 10
 Data length, bytes4
 Actual data size, bytes 28 or 16.67 % of table size
 Minimum value 7
 Average value 39.14
 Maximum value 67
ColumnPropertyValue
IllustrationIDData type and presentation sizeint, 10
 Data length, bytes4
 Actual data size, bytes 28 or 16.67 % of table size
 Minimum value 3
 Average value 4.28
 Maximum value 6
ColumnPropertyValue
ModifiedDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes112 or 66.67 % of table size
 Minimum value2004-02-10
 Average value2004-02-10
 Maximum value2004-02-10

Table: Production.ProductModelProductDescriptionCulture

PropertyValue
Table descriptionCross-reference table mapping product descriptions and the language the description is written in.
Analyzed columns4
Data rows762
Data size, bytes 27 432 or 0.04 % of database size
Table has fixed row size, bytes 36
Column Statistics for 'Production.ProductModelProductDescriptionCulture' table
ColumnPropertyValue
ProductModelIDData type and presentation sizeint, 10
 Data length, bytes4
 Actual data size, bytes 3 048 or 11.11 % of table size
 Minimum value 1
 Average value 64.00
 Maximum value127
ColumnPropertyValue
ProductDescriptionIDData type and presentation sizeint, 10
 Data length, bytes4
 Actual data size, bytes 3 048 or 11.11 % of table size
 Minimum value 3
 Average value 1 542.58
 Maximum value 2 010
ColumnPropertyValue
CultureIDData type and presentation sizenchar, 6
 Data length, bytes12
 Actual data size, bytes 9 144 or 33.33 % of table size
ColumnPropertyValue
ModifiedDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes 12 192 or 44.44 % of table size
 Minimum value2003-06-01
 Average value2003-06-01
 Maximum value2003-06-01

Table: Production.ProductPhoto

PropertyValue
Table descriptionProduct images.
Analyzed columns6
Data rows101
Data size, bytes 2 013 474 or 2.88 % of database size
Average row size, bytes 19 935.38
Minimum row size, bytes 2 826
Maximum row size, bytes 35 318
Column Statistics for 'Production.ProductPhoto' table
ColumnPropertyValue
ProductPhotoIDData type and presentation sizeint identity, 10
 Data length, bytes4
 Actual data size, bytes404 or 0.02 % of table size
 Minimum value 1
 Average value125.77
 Maximum value181
ColumnPropertyValue
ThumbNailPhotoData type and presentation sizevarbinary, 128
 Data length, bytes0
 Actual data size, bytes329 917 or 16.39 % of table size
ColumnPropertyValue
ThumbnailPhotoFileNameData type and presentation sizenvarchar, 50
 Data length, bytes100
 Actual data size, bytes 2 409 or 0.12 % of table size
 Minimum value length14
 Maximum value length35
ColumnPropertyValue
LargePhotoData type and presentation sizevarbinary, 128
 Data length, bytes0
 Actual data size, bytes 1 676 719 or 83.27 % of table size
ColumnPropertyValue
LargePhotoFileNameData type and presentation sizenvarchar, 50
 Data length, bytes100
 Actual data size, bytes 2 409 or 0.12 % of table size
 Minimum value length14
 Maximum value length35
ColumnPropertyValue
ModifiedDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes 1 616 or 0.08 % of table size
 Minimum value1998-05-02
 Average value2002-07-21
 Maximum value2003-06-01

Table: Production.ProductProductPhoto

PropertyValue
Table descriptionCross-reference table mapping products and product photos.
Analyzed columns4
Data rows504
Data size, bytes 12 600 or 0.02 % of database size
Table has fixed row size, bytes 25
Column Statistics for 'Production.ProductProductPhoto' table
ColumnPropertyValue
ProductIDData type and presentation sizeint, 10
 Data length, bytes4
 Actual data size, bytes 2 016 or 16.00 % of table size
 Minimum value 1
 Average value673.03
 Maximum value999
ColumnPropertyValue
ProductPhotoIDData type and presentation sizeint, 10
 Data length, bytes4
 Actual data size, bytes 2 016 or 16.00 % of table size
 Minimum value 1
 Average value 41.67
 Maximum value179
ColumnPropertyValue
PrimaryData type and presentation sizeFlag, 1
 Data length, bytes1
 Actual data size, bytes504 or 4.00 % of table size
ColumnPropertyValue
ModifiedDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes 8 064 or 64.00 % of table size
 Minimum value1998-05-02
 Average value2000-11-00
 Maximum value2003-06-01

Table: Production.ProductReview

PropertyValue
Table descriptionCustomer reviews of products they have purchased.
Analyzed columns8
Data rows 4
Data size, bytes 5 225 or 0.01 % of database size
Average row size, bytes 1 306.25
Minimum row size, bytes324
Maximum row size, bytes 3 890
Column Statistics for 'Production.ProductReview' table
ColumnPropertyValue
ProductReviewIDData type and presentation sizeint identity, 10
 Data length, bytes4
 Actual data size, bytes 16 or 0.31 % of table size
 Minimum value 1
 Average value 2.50
 Maximum value 4
ColumnPropertyValue
ProductIDData type and presentation sizeint, 10
 Data length, bytes4
 Actual data size, bytes 16 or 0.31 % of table size
 Minimum value709
 Average value845.25
 Maximum value937
ColumnPropertyValue
ReviewerNameData type and presentation sizeName, 50
 Data length, bytes100
 Actual data size, bytes 31 or 0.59 % of table size
 Minimum value length4
 Maximum value length12
ColumnPropertyValue
ReviewDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes 64 or 1.22 % of table size
 Minimum value2003-10-20
 Average value2003-12-02
 Maximum value2003-12-17
ColumnPropertyValue
EmailAddressData type and presentation sizenvarchar, 50
 Data length, bytes100
 Actual data size, bytes 97 or 1.86 % of table size
 Minimum value length21
 Maximum value length32
ColumnPropertyValue
RatingData type and presentation sizeint, 10
 Data length, bytes4
 Actual data size, bytes 16 or 0.31 % of table size
 Minimum value 2
 Average value 4.00
 Maximum value 5
ColumnPropertyValue
CommentsData type and presentation sizenvarchar, 3850
 Data length, bytes7700
 Actual data size, bytes 4 921 or 94.18 % of table size
 Minimum value length254
 Maximum value length3812
ColumnPropertyValue
ModifiedDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes 64 or 1.22 % of table size
 Minimum value2003-10-20
 Average value2003-12-02
 Maximum value2003-12-17

Table: Production.ProductSubcategory

PropertyValue
Table descriptionProduct subcategories. See ProductCategory table.
Analyzed columns5
Data rows 37
Data size, bytes 1 809 or 0.00 % of database size
Average row size, bytes 48.89
Minimum row size, bytes 44
Maximum row size, bytes 57
Column Statistics for 'Production.ProductSubcategory' table
ColumnPropertyValue
ProductSubcategoryIDData type and presentation sizeint identity, 10
 Data length, bytes4
 Actual data size, bytes148 or 8.18 % of table size
 Minimum value 1
 Average value 19.00
 Maximum value 37
ColumnPropertyValue
ProductCategoryIDData type and presentation sizeint, 10
 Data length, bytes4
 Actual data size, bytes148 or 8.18 % of table size
 Minimum value 1
 Average value 2.78
 Maximum value 4
ColumnPropertyValue
NameData type and presentation sizeName, 50
 Data length, bytes100
 Actual data size, bytes329 or 18.19 % of table size
 Minimum value length4
 Maximum value length17
ColumnPropertyValue
rowguidData type and presentation sizeuniqueidentifier, 36
 Data length, bytes16
 Actual data size, bytes592 or 32.73 % of table size
ColumnPropertyValue
ModifiedDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes592 or 32.73 % of table size
 Minimum value1998-06-01
 Average value1998-06-01
 Maximum value1998-06-01

Table: Production.ScrapReason

PropertyValue
Table descriptionManufacturing failure reasons lookup table.
Analyzed columns3
Data rows 16
Data size, bytes629 or 0.00 % of database size
Average row size, bytes 39.31
Minimum row size, bytes 32
Maximum row size, bytes 49
Column Statistics for 'Production.ScrapReason' table
ColumnPropertyValue
ScrapReasonIDData type and presentation sizesmallint identity, 5
 Data length, bytes2
 Actual data size, bytes 32 or 5.09 % of table size
 Minimum value 1
 Average value 8.50
 Maximum value 16
ColumnPropertyValue
NameData type and presentation sizeName, 50
 Data length, bytes100
 Actual data size, bytes341 or 54.21 % of table size
 Minimum value length14
 Maximum value length31
ColumnPropertyValue
ModifiedDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes256 or 40.70 % of table size
 Minimum value1998-06-01
 Average value1998-06-01
 Maximum value1998-06-01

Table: Production.TransactionHistory

PropertyValue
Table descriptionRecord of each purchase order, sales order, or work order transaction year to date.
Analyzed columns9
Data rows113 443
Data size, bytes 8 508 225 or 12.17 % of database size
Table has fixed row size, bytes 75
Column Statistics for 'Production.TransactionHistory' table
ColumnPropertyValue
TransactionIDData type and presentation sizeint identity, 10
 Data length, bytes4
 Actual data size, bytes453 772 or 5.33 % of table size
 Minimum value100 000
 Average value156 721.00
 Maximum value213 442
ColumnPropertyValue
ProductIDData type and presentation sizeint, 10
 Data length, bytes4
 Actual data size, bytes453 772 or 5.33 % of table size
 Minimum value 1
 Average value813.31
 Maximum value999
ColumnPropertyValue
ReferenceOrderIDData type and presentation sizeint, 10
 Data length, bytes4
 Actual data size, bytes453 772 or 5.33 % of table size
 Minimum value417
 Average value 57 587.75
 Maximum value 75 123
ColumnPropertyValue
ReferenceOrderLineIDData type and presentation sizeint, 10
 Data length, bytes4
 Actual data size, bytes453 772 or 5.33 % of table size
 Minimum value0
 Average value 4.67
 Maximum value 71
ColumnPropertyValue
TransactionDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes 1 815 088 or 21.33 % of table size
 Minimum value2003-09-01
 Average value2004-02-07
 Maximum value2004-09-03
ColumnPropertyValue
TransactionTypeData type and presentation sizenchar, 1
 Data length, bytes2
 Actual data size, bytes226 886 or 2.67 % of table size
ColumnPropertyValue
QuantityData type and presentation sizeint, 10
 Data length, bytes4
 Actual data size, bytes453 772 or 5.33 % of table size
 Minimum value 1
 Average value 35.05
 Maximum value 39 270
ColumnPropertyValue
ActualCostData type and presentation sizemoney, 19
 Data length, bytes21
 Actual data size, bytes 2 382 303 or 28.00 % of table size
 Minimum value0.00
 Average value 2 382 303 or 28.00 % of table size
 Maximum value 2 443.34
ColumnPropertyValue
ModifiedDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes 1 815 088 or 21.33 % of table size
 Minimum value2003-09-01
 Average value2004-02-07
 Maximum value2004-09-03

Table: Production.TransactionHistoryArchive

PropertyValue
Table descriptionTransactions for previous years.
Analyzed columns9
Data rows 89 253
Data size, bytes 6 693 975 or 9.58 % of database size
Table has fixed row size, bytes 75
Column Statistics for 'Production.TransactionHistoryArchive' table
ColumnPropertyValue
TransactionIDData type and presentation sizeint, 10
 Data length, bytes4
 Actual data size, bytes357 012 or 5.33 % of table size
 Minimum value 1
 Average value 44 627.00
 Maximum value 89 253
ColumnPropertyValue
ProductIDData type and presentation sizeint, 10
 Data length, bytes4
 Actual data size, bytes357 012 or 5.33 % of table size
 Minimum value 1
 Average value734.88
 Maximum value999
ColumnPropertyValue
ReferenceOrderIDData type and presentation sizeint, 10
 Data length, bytes4
 Actual data size, bytes357 012 or 5.33 % of table size
 Minimum value 1
 Average value 35 121.18
 Maximum value 53 449
ColumnPropertyValue
ReferenceOrderLineIDData type and presentation sizeint, 10
 Data length, bytes4
 Actual data size, bytes357 012 or 5.33 % of table size
 Minimum value0
 Average value 6.77
 Maximum value 72
ColumnPropertyValue
TransactionDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes 1 428 048 or 21.33 % of table size
 Minimum value2001-05-17
 Average value2002-10-17
 Maximum value2003-09-00
ColumnPropertyValue
TransactionTypeData type and presentation sizenchar, 1
 Data length, bytes2
 Actual data size, bytes178 506 or 2.67 % of table size
ColumnPropertyValue
QuantityData type and presentation sizeint, 10
 Data length, bytes4
 Actual data size, bytes357 012 or 5.33 % of table size
 Minimum value 1
 Average value 34.26
 Maximum value 39 570
ColumnPropertyValue
ActualCostData type and presentation sizemoney, 19
 Data length, bytes21
 Actual data size, bytes 1 874 313 or 28.00 % of table size
 Minimum value0.00
 Average value 1 874 313 or 28.00 % of table size
 Maximum value 3 578.26
ColumnPropertyValue
ModifiedDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes 1 428 048 or 21.33 % of table size
 Minimum value2001-05-17
 Average value2002-10-17
 Maximum value2003-09-00

Table: Production.UnitMeasure

PropertyValue
Table descriptionUnit of measure lookup table.
Analyzed columns3
Data rows 38
Data size, bytes 1 158 or 0.00 % of database size
Average row size, bytes 30.47
Minimum row size, bytes 26
Maximum row size, bytes 42
Column Statistics for 'Production.UnitMeasure' table
ColumnPropertyValue
UnitMeasureCodeData type and presentation sizenchar, 3
 Data length, bytes6
 Actual data size, bytes228 or 19.69 % of table size
ColumnPropertyValue
NameData type and presentation sizeName, 50
 Data length, bytes100
 Actual data size, bytes322 or 27.81 % of table size
 Minimum value length4
 Maximum value length20
ColumnPropertyValue
ModifiedDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes608 or 52.50 % of table size
 Minimum value1998-06-01
 Average value1998-06-01
 Maximum value1998-06-01

Table: Production.WorkOrder

PropertyValue
Table descriptionManufacturing work orders.
Analyzed columns10
Data rows 72 591
Data size, bytes 5 953 920 or 8.52 % of database size
Average row size, bytes 82.02
Minimum row size, bytes 82
Maximum row size, bytes 84
Column Statistics for 'Production.WorkOrder' table
ColumnPropertyValue
WorkOrderIDData type and presentation sizeint identity, 10
 Data length, bytes4
 Actual data size, bytes290 364 or 4.88 % of table size
 Minimum value 1
 Average value 36 296.00
 Maximum value 72 591
ColumnPropertyValue
ProductIDData type and presentation sizeint, 10
 Data length, bytes4
 Actual data size, bytes290 364 or 4.88 % of table size
 Minimum value 3
 Average value704.32
 Maximum value999
ColumnPropertyValue
OrderQtyData type and presentation sizeint, 10
 Data length, bytes4
 Actual data size, bytes290 364 or 4.88 % of table size
 Minimum value 1
 Average value 62.09
 Maximum value 39 570
ColumnPropertyValue
StockedQtyData type and presentation sizeint, 10
 Data length, bytes4
 Actual data size, bytes290 364 or 4.88 % of table size
 Minimum value 1
 Average value 61.95
 Maximum value 39 570
ColumnPropertyValue
ScrappedQtyData type and presentation sizesmallint, 5
 Data length, bytes2
 Actual data size, bytes145 182 or 2.44 % of table size
 Minimum value0
 Average value0.14
 Maximum value673
ColumnPropertyValue
StartDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes 1 161 456 or 19.51 % of table size
 Minimum value2001-07-04
 Average value2003-04-19
 Maximum value2004-07-03
ColumnPropertyValue
EndDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes 1 161 456 or 19.51 % of table size
 Minimum value2001-07-14
 Average value2003-05-02
 Maximum value2004-07-18
ColumnPropertyValue
DueDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes 1 161 456 or 19.51 % of table size
 Minimum value2001-07-15
 Average value2003-05-00
 Maximum value2004-07-14
ColumnPropertyValue
ScrapReasonIDData type and presentation sizesmallint, 5
 Data length, bytes2
 NULL values71862 or 99.00 %
 Actual data size, bytes 1 458 or 0.02 % of table size
 Minimum value 1
 Average value0.08
 Maximum value 16
ColumnPropertyValue
ModifiedDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes 1 161 456 or 19.51 % of table size
 Minimum value2001-07-14
 Average value2003-05-02
 Maximum value2004-07-18

Table: Production.WorkOrderRouting

PropertyValue
Table descriptionWork order details.
Analyzed columns12
Data rows 67 131
Data size, bytes 9 733 995 or 13.93 % of database size
Table has fixed row size, bytes145
Column Statistics for 'Production.WorkOrderRouting' table
ColumnPropertyValue
WorkOrderIDData type and presentation sizeint, 10
 Data length, bytes4
 Actual data size, bytes268 524 or 2.76 % of table size
 Minimum value 13
 Average value 38 394.30
 Maximum value 72 587
ColumnPropertyValue
ProductIDData type and presentation sizeint, 10
 Data length, bytes4
 Actual data size, bytes268 524 or 2.76 % of table size
 Minimum value514
 Average value798.92
 Maximum value999
ColumnPropertyValue
OperationSequenceData type and presentation sizesmallint, 5
 Data length, bytes2
 Actual data size, bytes134 262 or 1.38 % of table size
 Minimum value 1
 Average value 5.10
 Maximum value 7
ColumnPropertyValue
LocationIDData type and presentation sizesmallint, 5
 Data length, bytes2
 Actual data size, bytes134 262 or 1.38 % of table size
 Minimum value 10
 Average value 43.80
 Maximum value 60
ColumnPropertyValue
ScheduledStartDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes 1 074 096 or 11.03 % of table size
 Minimum value2001-07-04
 Average value2003-05-22
 Maximum value2004-07-03
ColumnPropertyValue
ScheduledEndDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes 1 074 096 or 11.03 % of table size
 Minimum value2001-07-15
 Average value2003-06-02
 Maximum value2004-07-14
ColumnPropertyValue
ActualStartDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes 1 074 096 or 11.03 % of table size
 Minimum value2001-07-04
 Average value2003-05-26
 Maximum value2004-07-18
ColumnPropertyValue
ActualEndDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes 1 074 096 or 11.03 % of table size
 Minimum value2001-07-16
 Average value2003-06-07
 Maximum value2004-07-29
ColumnPropertyValue
ActualResourceHrsData type and presentation sizedecimal, 9
 Data length, bytes11
 Actual data size, bytes738 441 or 7.59 % of table size
 Minimum value 1.00
 Average value738 441 or 7.59 % of table size
 Maximum value 4.09
ColumnPropertyValue
PlannedCostData type and presentation sizemoney, 19
 Data length, bytes21
 Actual data size, bytes 1 409 751 or 14.48 % of table size
 Minimum value 14.50
 Average value 1 409 751 or 14.48 % of table size
 Maximum value 92.25
ColumnPropertyValue
ActualCostData type and presentation sizemoney, 19
 Data length, bytes21
 Actual data size, bytes 1 409 751 or 14.48 % of table size
 Minimum value 14.50
 Average value 1 409 751 or 14.48 % of table size
 Maximum value 92.25
ColumnPropertyValue
ModifiedDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes 1 074 096 or 11.03 % of table size
 Minimum value2001-07-16
 Average value2003-06-07
 Maximum value2004-07-29

Table: Purchasing.ProductVendor

PropertyValue
Table descriptionCross-reference table mapping vendors with the products they supply.
Analyzed columns11
Data rows460
Data size, bytes 46 620 or 0.07 % of database size
Average row size, bytes101.34
Minimum row size, bytes100
Maximum row size, bytes104
Column Statistics for 'Purchasing.ProductVendor' table
ColumnPropertyValue
ProductIDData type and presentation sizeint, 10
 Data length, bytes4
 Actual data size, bytes 1 840 or 3.95 % of table size
 Minimum value 1
 Average value517.24
 Maximum value952
ColumnPropertyValue
VendorIDData type and presentation sizeint, 10
 Data length, bytes4
 Actual data size, bytes 1 840 or 3.95 % of table size
 Minimum value 1
 Average value 51.35
 Maximum value104
ColumnPropertyValue
AverageLeadTimeData type and presentation sizeint, 10
 Data length, bytes4
 Actual data size, bytes 1 840 or 3.95 % of table size
 Minimum value 10
 Average value 19.44
 Maximum value120
ColumnPropertyValue
StandardPriceData type and presentation sizemoney, 19
 Data length, bytes21
 Actual data size, bytes 9 660 or 20.72 % of table size
 Minimum value0.20
 Average value 9 660 or 20.72 % of table size
 Maximum value 78.89
ColumnPropertyValue
LastReceiptCostData type and presentation sizemoney, 19
 Data length, bytes21
 Actual data size, bytes 9 660 or 20.72 % of table size
 Minimum value0.21
 Average value 9 660 or 20.72 % of table size
 Maximum value 82.83
ColumnPropertyValue
LastReceiptDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes 7 360 or 15.79 % of table size
 Minimum value2001-08-22
 Average value2002-01-10
 Maximum value2004-11-22
ColumnPropertyValue
MinOrderQtyData type and presentation sizeint, 10
 Data length, bytes4
 Actual data size, bytes 1 840 or 3.95 % of table size
 Minimum value 1
 Average value145.90
 Maximum value 5 000
ColumnPropertyValue
MaxOrderQtyData type and presentation sizeint, 10
 Data length, bytes4
 Actual data size, bytes 1 840 or 3.95 % of table size
 Minimum value 5
 Average value776.46
 Maximum value 15 000
ColumnPropertyValue
OnOrderQtyData type and presentation sizeint, 10
 Data length, bytes4
 NULL values305 or 66.30 %
 Actual data size, bytes620 or 1.33 % of table size
 Minimum value 3
 Average value222.63
 Maximum value 8 000
ColumnPropertyValue
UnitMeasureCodeData type and presentation sizenchar, 3
 Data length, bytes6
 Actual data size, bytes 2 760 or 5.92 % of table size
ColumnPropertyValue
ModifiedDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes 7 360 or 15.79 % of table size
 Minimum value2001-08-22
 Average value2002-03-07
 Maximum value2005-09-12

Table: Purchasing.PurchaseOrderDetail

PropertyValue
Table descriptionIndividual products associated with a specific purchase order. See PurchaseOrderHeader.
Analyzed columns11
Data rows 8 845
Data size, bytes 1 052 555 or 1.51 % of database size
Table has fixed row size, bytes119
Column Statistics for 'Purchasing.PurchaseOrderDetail' table
ColumnPropertyValue
PurchaseOrderIDData type and presentation sizeint, 10
 Data length, bytes4
 Actual data size, bytes 35 380 or 3.36 % of table size
 Minimum value 1
 Average value 1 992.32
 Maximum value 4 012
ColumnPropertyValue
PurchaseOrderDetailIDData type and presentation sizeint identity, 10
 Data length, bytes4
 Actual data size, bytes 35 380 or 3.36 % of table size
 Minimum value 1
 Average value 4 423.00
 Maximum value 8 845
ColumnPropertyValue
DueDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes141 520 or 13.45 % of table size
 Minimum value2001-06-00
 Average value2004-02-07
 Maximum value2004-11-22
ColumnPropertyValue
OrderQtyData type and presentation sizesmallint, 5
 Data length, bytes2
 Actual data size, bytes 17 690 or 1.68 % of table size
 Minimum value 3
 Average value265.53
 Maximum value 8 000
ColumnPropertyValue
ProductIDData type and presentation sizeint, 10
 Data length, bytes4
 Actual data size, bytes 35 380 or 3.36 % of table size
 Minimum value 1
 Average value527.50
 Maximum value952
ColumnPropertyValue
UnitPriceData type and presentation sizemoney, 19
 Data length, bytes21
 Actual data size, bytes185 745 or 17.65 % of table size
 Minimum value0.21
 Average value185 745 or 17.65 % of table size
 Maximum value 82.83
ColumnPropertyValue
LineTotalData type and presentation sizemoney, 19
 Data length, bytes21
 Actual data size, bytes185 745 or 17.65 % of table size
 Minimum value 37.07
 Average value185 745 or 17.65 % of table size
 Maximum value249 420.00
ColumnPropertyValue
ReceivedQtyData type and presentation sizedecimal, 8
 Data length, bytes10
 Actual data size, bytes 88 450 or 8.40 % of table size
 Minimum value 2.00
 Average value 88 450 or 8.40 % of table size
 Maximum value 8 000.00
ColumnPropertyValue
RejectedQtyData type and presentation sizedecimal, 8
 Data length, bytes10
 Actual data size, bytes 88 450 or 8.40 % of table size
 Minimum value0.00
 Average value 88 450 or 8.40 % of table size
 Maximum value 1 250.00
ColumnPropertyValue
StockedQtyData type and presentation sizedecimal, 9
 Data length, bytes11
 Actual data size, bytes 97 295 or 9.24 % of table size
 Minimum value0.00
 Average value 97 295 or 9.24 % of table size
 Maximum value 8 000.00
ColumnPropertyValue
ModifiedDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes141 520 or 13.45 % of table size
 Minimum value2001-05-24
 Average value2004-02-03
 Maximum value2005-09-12

Table: Purchasing.PurchaseOrderHeader

PropertyValue
Table descriptionGeneral purchase order information. See PurchaseOrderDetail.
Analyzed columns13
Data rows 4 012
Data size, bytes601 800 or 0.86 % of database size
Table has fixed row size, bytes150
Column Statistics for 'Purchasing.PurchaseOrderHeader' table
ColumnPropertyValue
PurchaseOrderIDData type and presentation sizeint identity, 10
 Data length, bytes4
 Actual data size, bytes 16 048 or 2.67 % of table size
 Minimum value 1
 Average value 2 006.50
 Maximum value 4 012
ColumnPropertyValue
RevisionNumberData type and presentation sizetinyint, 3
 Data length, bytes1
 Actual data size, bytes 4 012 or 0.67 % of table size
 Minimum value0
 Average value0.08
 Maximum value 16
ColumnPropertyValue
StatusData type and presentation sizetinyint, 3
 Data length, bytes1
 Actual data size, bytes 4 012 or 0.67 % of table size
 Minimum value 1
 Average value 3.80
 Maximum value 4
ColumnPropertyValue
EmployeeIDData type and presentation sizeint, 10
 Data length, bytes4
 Actual data size, bytes 16 048 or 2.67 % of table size
 Minimum value164
 Average value236.58
 Maximum value274
ColumnPropertyValue
VendorIDData type and presentation sizeint, 10
 Data length, bytes4
 Actual data size, bytes 16 048 or 2.67 % of table size
 Minimum value 1
 Average value 51.45
 Maximum value104
ColumnPropertyValue
ShipMethodIDData type and presentation sizeint, 10
 Data length, bytes4
 Actual data size, bytes 16 048 or 2.67 % of table size
 Minimum value 1
 Average value 3.57
 Maximum value 5
ColumnPropertyValue
OrderDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes 64 192 or 10.67 % of table size
 Minimum value2001-05-17
 Average value2004-01-28
 Maximum value2004-10-23
ColumnPropertyValue
ShipDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes 64 192 or 10.67 % of table size
 Minimum value2001-05-26
 Average value2004-02-06
 Maximum value2004-11-17
ColumnPropertyValue
SubTotalData type and presentation sizemoney, 19
 Data length, bytes21
 Actual data size, bytes 84 252 or 14.00 % of table size
 Minimum value 37.07
 Average value 84 252 or 14.00 % of table size
 Maximum value997 680.00
ColumnPropertyValue
TaxAmtData type and presentation sizemoney, 19
 Data length, bytes21
 Actual data size, bytes 84 252 or 14.00 % of table size
 Minimum value 2.96
 Average value 84 252 or 14.00 % of table size
 Maximum value 79 814.39
ColumnPropertyValue
FreightData type and presentation sizemoney, 19
 Data length, bytes21
 Actual data size, bytes 84 252 or 14.00 % of table size
 Minimum value0.92
 Average value 84 252 or 14.00 % of table size
 Maximum value 19 953.59
ColumnPropertyValue
TotalDueData type and presentation sizemoney, 19
 Data length, bytes21
 Actual data size, bytes 84 252 or 14.00 % of table size
 Minimum value 40.96
 Average value 84 252 or 14.00 % of table size
 Maximum value 1 097 448.00
ColumnPropertyValue
ModifiedDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes 64 192 or 10.67 % of table size
 Minimum value2001-05-26
 Average value2004-02-07
 Maximum value2005-09-12

Table: Purchasing.ShipMethod

PropertyValue
Table descriptionShipping company lookup table.
Analyzed columns6
Data rows 5
Data size, bytes470 or 0.00 % of database size
Average row size, bytes 94.00
Minimum row size, bytes 90
Maximum row size, bytes 96
Column Statistics for 'Purchasing.ShipMethod' table
ColumnPropertyValue
ShipMethodIDData type and presentation sizeint identity, 10
 Data length, bytes4
 Actual data size, bytes 20 or 4.26 % of table size
 Minimum value 1
 Average value 3.00
 Maximum value 5
ColumnPropertyValue
NameData type and presentation sizeName, 50
 Data length, bytes100
 Actual data size, bytes 80 or 17.02 % of table size
 Minimum value length12
 Maximum value length18
ColumnPropertyValue
ShipBaseData type and presentation sizemoney, 19
 Data length, bytes21
 Actual data size, bytes105 or 22.34 % of table size
 Minimum value 3.95
 Average value105 or 22.34 % of table size
 Maximum value 29.94
ColumnPropertyValue
ShipRateData type and presentation sizemoney, 19
 Data length, bytes21
 Actual data size, bytes105 or 22.34 % of table size
 Minimum value0.99
 Average value105 or 22.34 % of table size
 Maximum value 2.99
ColumnPropertyValue
rowguidData type and presentation sizeuniqueidentifier, 36
 Data length, bytes16
 Actual data size, bytes 80 or 17.02 % of table size
ColumnPropertyValue
ModifiedDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes 80 or 17.02 % of table size
 Minimum value1998-06-01
 Average value1998-06-01
 Maximum value1998-06-01

Table: Purchasing.Vendor

PropertyValue
Table descriptionCompanies from whom Adventure Works Cycles purchases parts or other goods.
Analyzed columns8
Data rows104
Data size, bytes 5 601 or 0.01 % of database size
Average row size, bytes 53.85
Minimum row size, bytes 37
Maximum row size, bytes 81
Column Statistics for 'Purchasing.Vendor' table
ColumnPropertyValue
VendorIDData type and presentation sizeint identity, 10
 Data length, bytes4
 Actual data size, bytes416 or 7.43 % of table size
 Minimum value 1
 Average value 52.50
 Maximum value104
ColumnPropertyValue
AccountNumberData type and presentation sizeAccountNumber, 15
 Data length, bytes30
 Actual data size, bytes 1 169 or 20.87 % of table size
 Minimum value length9
 Maximum value length12
ColumnPropertyValue
NameData type and presentation sizeName, 50
 Data length, bytes100
 Actual data size, bytes 1 915 or 34.19 % of table size
 Minimum value length5
 Maximum value length33
ColumnPropertyValue
CreditRatingData type and presentation sizetinyint, 3
 Data length, bytes1
 Actual data size, bytes104 or 1.86 % of table size
 Minimum value 1
 Average value 1.35
 Maximum value 5
ColumnPropertyValue
PreferredVendorStatusData type and presentation sizeFlag, 1
 Data length, bytes1
 Actual data size, bytes104 or 1.86 % of table size
ColumnPropertyValue
ActiveFlagData type and presentation sizeFlag, 1
 Data length, bytes1
 Actual data size, bytes104 or 1.86 % of table size
ColumnPropertyValue
PurchasingWebServiceURLData type and presentation sizenvarchar, 1024
 Data length, bytes2048
 NULL values98 or 94.23 %
 Actual data size, bytes125 or 2.23 % of table size
 Minimum value length15
 Maximum value length27
ColumnPropertyValue
ModifiedDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes 1 664 or 29.71 % of table size
 Minimum value2001-05-26
 Average value2002-01-28
 Maximum value2002-03-21

Table: Purchasing.VendorAddress

PropertyValue
Table descriptionCross-reference mapping vendors and addresses.
Analyzed columns4
Data rows104
Data size, bytes 2 912 or 0.00 % of database size
Table has fixed row size, bytes 28
Column Statistics for 'Purchasing.VendorAddress' table
ColumnPropertyValue
VendorIDData type and presentation sizeint, 10
 Data length, bytes4
 Actual data size, bytes416 or 14.29 % of table size
 Minimum value 1
 Average value 52.50
 Maximum value104
ColumnPropertyValue
AddressIDData type and presentation sizeint, 10
 Data length, bytes4
 Actual data size, bytes416 or 14.29 % of table size
 Minimum value301
 Average value352.50
 Maximum value404
ColumnPropertyValue
AddressTypeIDData type and presentation sizeint, 10
 Data length, bytes4
 Actual data size, bytes416 or 14.29 % of table size
 Minimum value 3
 Average value 3.00
 Maximum value 3
ColumnPropertyValue
ModifiedDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes 1 664 or 57.14 % of table size
 Minimum value2001-05-26
 Average value2002-01-28
 Maximum value2002-03-21

Table: Purchasing.VendorContact

PropertyValue
Table descriptionCross-reference table mapping vendors and their employees.
Analyzed columns4
Data rows156
Data size, bytes 4 368 or 0.01 % of database size
Table has fixed row size, bytes 28
Column Statistics for 'Purchasing.VendorContact' table
ColumnPropertyValue
VendorIDData type and presentation sizeint, 10
 Data length, bytes4
 Actual data size, bytes624 or 14.29 % of table size
 Minimum value 1
 Average value 51.94
 Maximum value104
ColumnPropertyValue
ContactIDData type and presentation sizeint, 10
 Data length, bytes4
 Actual data size, bytes624 or 14.29 % of table size
 Minimum value601
 Average value758.08
 Maximum value995
ColumnPropertyValue
ContactTypeIDData type and presentation sizeint, 10
 Data length, bytes4
 Actual data size, bytes624 or 14.29 % of table size
 Minimum value 2
 Average value 16.06
 Maximum value 19
ColumnPropertyValue
ModifiedDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes 2 496 or 57.14 % of table size
 Minimum value2001-05-26
 Average value2002-01-18
 Maximum value2002-03-21

Table: Sales.ContactCreditCard

PropertyValue
Table descriptionCross-reference table mapping customers in the Contact table to their credit card information in the CreditCard table.
Analyzed columns3
Data rows 19 118
Data size, bytes458 832 or 0.66 % of database size
Table has fixed row size, bytes 24
Column Statistics for 'Sales.ContactCreditCard' table
ColumnPropertyValue
ContactIDData type and presentation sizeint, 10
 Data length, bytes4
 Actual data size, bytes 76 472 or 16.67 % of table size
 Minimum value 2
 Average value 10 388.61
 Maximum value 19 977
ColumnPropertyValue
CreditCardIDData type and presentation sizeint, 10
 Data length, bytes4
 Actual data size, bytes 76 472 or 16.67 % of table size
 Minimum value 1
 Average value 9 567.66
 Maximum value 19 237
ColumnPropertyValue
ModifiedDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes305 888 or 66.67 % of table size
 Minimum value2001-07-01
 Average value2003-08-07
 Maximum value2004-08-00

Table: Sales.CountryRegionCurrency

PropertyValue
Table descriptionCross-reference table mapping ISO currency codes to a country or region.
Analyzed columns3
Data rows109
Data size, bytes 2 616 or 0.00 % of database size
Table has fixed row size, bytes 24
Column Statistics for 'Sales.CountryRegionCurrency' table
ColumnPropertyValue
CountryRegionCodeData type and presentation sizenvarchar, 3
 Data length, bytes6
 Actual data size, bytes218 or 8.33 % of table size
 Minimum value length2
 Maximum value length2
ColumnPropertyValue
CurrencyCodeData type and presentation sizenchar, 3
 Data length, bytes6
 Actual data size, bytes654 or 25.00 % of table size
ColumnPropertyValue
ModifiedDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes 1 744 or 66.67 % of table size
 Minimum value1998-06-01
 Average value2003-08-30
 Maximum value2004-03-11

Table: Sales.CreditCard

PropertyValue
Table descriptionCustomer credit card information.
Analyzed columns6
Data rows 19 118
Data size, bytes904 077 or 1.29 % of database size
Average row size, bytes 47.28
Minimum row size, bytes 42
Maximum row size, bytes 50
Column Statistics for 'Sales.CreditCard' table
ColumnPropertyValue
CreditCardIDData type and presentation sizeint identity, 10
 Data length, bytes4
 Actual data size, bytes 76 472 or 8.46 % of table size
 Minimum value 1
 Average value 9 567.66
 Maximum value 19 237
ColumnPropertyValue
CardTypeData type and presentation sizenvarchar, 50
 Data length, bytes100
 Actual data size, bytes196 711 or 21.76 % of table size
 Minimum value length5
 Maximum value length13
ColumnPropertyValue
CardNumberData type and presentation sizenvarchar, 25
 Data length, bytes50
 Actual data size, bytes267 652 or 29.61 % of table size
 Minimum value length14
 Maximum value length14
ColumnPropertyValue
ExpMonthData type and presentation sizetinyint, 3
 Data length, bytes1
 Actual data size, bytes 19 118 or 2.11 % of table size
 Minimum value 1
 Average value 6.52
 Maximum value 12
ColumnPropertyValue
ExpYearData type and presentation sizesmallint, 5
 Data length, bytes2
 Actual data size, bytes 38 236 or 4.23 % of table size
 Minimum value 2 005
 Average value 2 006.50
 Maximum value 2 008
ColumnPropertyValue
ModifiedDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes305 888 or 33.83 % of table size
 Minimum value1996-07-24
 Average value2003-06-22
 Maximum value2004-08-00

Table: Sales.Currency

PropertyValue
Table descriptionLookup table containing standard ISO currencies.
Analyzed columns3
Data rows105
Data size, bytes 3 577 or 0.01 % of database size
Average row size, bytes 34.06
Minimum row size, bytes 25
Maximum row size, bytes 51
Column Statistics for 'Sales.Currency' table
ColumnPropertyValue
CurrencyCodeData type and presentation sizenchar, 3
 Data length, bytes6
 Actual data size, bytes630 or 17.61 % of table size
ColumnPropertyValue
NameData type and presentation sizeName, 50
 Data length, bytes100
 Actual data size, bytes 1 267 or 35.42 % of table size
 Minimum value length3
 Maximum value length29
ColumnPropertyValue
ModifiedDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes 1 680 or 46.97 % of table size
 Minimum value1998-06-01
 Average value1998-06-01
 Maximum value1998-06-01

Table: Sales.CurrencyRate

PropertyValue
Table descriptionCurrency exchange rates.
Analyzed columns7
Data rows 13 532
Data size, bytes 1 217 880 or 1.74 % of database size
Table has fixed row size, bytes 90
Column Statistics for 'Sales.CurrencyRate' table
ColumnPropertyValue
CurrencyRateIDData type and presentation sizeint identity, 10
 Data length, bytes4
 Actual data size, bytes 54 128 or 4.44 % of table size
 Minimum value 1
 Average value 6 766.50
 Maximum value 13 532
ColumnPropertyValue
CurrencyRateDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes216 512 or 17.78 % of table size
 Minimum value2001-07-01
 Average value2002-12-18
 Maximum value2004-07-01
ColumnPropertyValue
FromCurrencyCodeData type and presentation sizenchar, 3
 Data length, bytes6
 Actual data size, bytes 81 192 or 6.67 % of table size
ColumnPropertyValue
ToCurrencyCodeData type and presentation sizenchar, 3
 Data length, bytes6
 Actual data size, bytes 81 192 or 6.67 % of table size
ColumnPropertyValue
AverageRateData type and presentation sizemoney, 19
 Data length, bytes21
 Actual data size, bytes284 172 or 23.33 % of table size
 Minimum value0.60
 Average value284 172 or 23.33 % of table size
 Maximum value 1 500.00
ColumnPropertyValue
EndOfDayRateData type and presentation sizemoney, 19
 Data length, bytes21
 Actual data size, bytes284 172 or 23.33 % of table size
 Minimum value0.60
 Average value284 172 or 23.33 % of table size
 Maximum value 1 499.95
ColumnPropertyValue
ModifiedDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes216 512 or 17.78 % of table size
 Minimum value2001-07-01
 Average value2003-01-19
 Maximum value2004-07-01

Table: Sales.Customer

PropertyValue
Table descriptionCurrent customer information. Also see the Individual and Store tables.
Analyzed columns6
Data rows 19 185
Data size, bytes997 620 or 1.43 % of database size
Table has fixed row size, bytes 52
Column Statistics for 'Sales.Customer' table
ColumnPropertyValue
CustomerIDData type and presentation sizeint identity, 10
 Data length, bytes4
 Actual data size, bytes 76 740 or 7.69 % of table size
 Minimum value 1
 Average value 19 514.72
 Maximum value 29 483
ColumnPropertyValue
TerritoryIDData type and presentation sizeint, 10
 Data length, bytes4
 Actual data size, bytes 76 740 or 7.69 % of table size
 Minimum value 1
 Average value 5.85
 Maximum value 10
ColumnPropertyValue
AccountNumberData type and presentation sizevarchar, 10
 Data length, bytes10
 Actual data size, bytes191 850 or 19.23 % of table size
 Minimum value length10
 Maximum value length10
ColumnPropertyValue
CustomerTypeData type and presentation sizenchar, 1
 Data length, bytes2
 Actual data size, bytes 38 370 or 3.85 % of table size
ColumnPropertyValue
rowguidData type and presentation sizeuniqueidentifier, 36
 Data length, bytes16
 Actual data size, bytes306 960 or 30.77 % of table size
ColumnPropertyValue
ModifiedDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes306 960 or 30.77 % of table size
 Minimum value2004-10-13
 Average value2004-10-13
 Maximum value2004-10-13

Table: Sales.CustomerAddress

PropertyValue
Table descriptionCross-reference table mapping customers to their address(es).
Analyzed columns5
Data rows 19 220
Data size, bytes845 680 or 1.21 % of database size
Table has fixed row size, bytes 44
Column Statistics for 'Sales.CustomerAddress' table
ColumnPropertyValue
CustomerIDData type and presentation sizeint, 10
 Data length, bytes4
 Actual data size, bytes 76 880 or 9.09 % of table size
 Minimum value 1
 Average value 19 502.35
 Maximum value 29 483
ColumnPropertyValue
AddressIDData type and presentation sizeint, 10
 Data length, bytes4
 Actual data size, bytes 76 880 or 9.09 % of table size
 Minimum value 9
 Average value 19 882.34
 Maximum value 29 883
ColumnPropertyValue
AddressTypeIDData type and presentation sizeint, 10
 Data length, bytes4
 Actual data size, bytes 76 880 or 9.09 % of table size
 Minimum value 2
 Average value 2.04
 Maximum value 5
ColumnPropertyValue
rowguidData type and presentation sizeuniqueidentifier, 36
 Data length, bytes16
 Actual data size, bytes307 520 or 36.36 % of table size
ColumnPropertyValue
ModifiedDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes307 520 or 36.36 % of table size
 Minimum value2001-07-01
 Average value2003-08-05
 Maximum value2004-08-00

Table: Sales.Individual

PropertyValue
Table descriptionDemographic data about customers that purchase Adventure Works products online.
Analyzed columns4
Data rows 18 484
Data size, bytes443 616 or 0.63 % of database size
Table has fixed row size, bytes 24
Column Statistics for 'Sales.Individual' table
ColumnPropertyValue
CustomerIDData type and presentation sizeint, 10
 Data length, bytes4
 Actual data size, bytes 73 936 or 16.67 % of table size
 Minimum value 11 000
 Average value 20 241.50
 Maximum value 29 483
ColumnPropertyValue
ContactIDData type and presentation sizeint, 10
 Data length, bytes4
 Actual data size, bytes 73 936 or 16.67 % of table size
 Minimum value705
 Average value 10 731.82
 Maximum value 19 977
ColumnPropertyValue
DemographicsData type and presentation sizexml, 128
 Data length, bytes0
 Actual data size, bytes0 or 0.00 % of table size
ColumnPropertyValue
ModifiedDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes295 744 or 66.67 % of table size
 Minimum value2004-10-19
 Average value2004-10-19
 Maximum value2004-10-19

Table: Sales.SalesOrderDetail

PropertyValue
Table descriptionIndividual products associated with a specific sales order. See SalesOrderHeader.
Analyzed columns11
Data rows121 317
Data size, bytes 16 744 872 or 23.96 % of database size
Average row size, bytes138.02
Minimum row size, bytes132
Maximum row size, bytes144
Column Statistics for 'Sales.SalesOrderDetail' table
ColumnPropertyValue
SalesOrderIDData type and presentation sizeint, 10
 Data length, bytes4
 Actual data size, bytes485 268 or 2.90 % of table size
 Minimum value 43 659
 Average value 57 827.36
 Maximum value 75 123
ColumnPropertyValue
SalesOrderDetailIDData type and presentation sizeint identity, 10
 Data length, bytes4
 Actual data size, bytes485 268 or 2.90 % of table size
 Minimum value 1
 Average value 60 659.00
 Maximum value121 317
ColumnPropertyValue
CarrierTrackingNumberData type and presentation sizenvarchar, 25
 Data length, bytes50
 NULL values60398 or 49.79 %
 Actual data size, bytes731 028 or 4.37 % of table size
 Minimum value length12
 Maximum value length12
ColumnPropertyValue
OrderQtyData type and presentation sizesmallint, 5
 Data length, bytes2
 Actual data size, bytes242 634 or 1.45 % of table size
 Minimum value 1
 Average value 2.26
 Maximum value 44
ColumnPropertyValue
ProductIDData type and presentation sizeint, 10
 Data length, bytes4
 Actual data size, bytes485 268 or 2.90 % of table size
 Minimum value707
 Average value841.68
 Maximum value999
ColumnPropertyValue
SpecialOfferIDData type and presentation sizeint, 10
 Data length, bytes4
 Actual data size, bytes485 268 or 2.90 % of table size
 Minimum value 1
 Average value 1.16
 Maximum value 16
ColumnPropertyValue
UnitPriceData type and presentation sizemoney, 19
 Data length, bytes21
 Actual data size, bytes 2 547 657 or 15.21 % of table size
 Minimum value 1.32
 Average value 2 547 657 or 15.21 % of table size
 Maximum value 3 578.26
ColumnPropertyValue
UnitPriceDiscountData type and presentation sizemoney, 19
 Data length, bytes21
 Actual data size, bytes 2 547 657 or 15.21 % of table size
 Minimum value0.00
 Average value 2 547 657 or 15.21 % of table size
 Maximum value0.40
ColumnPropertyValue
LineTotalData type and presentation sizenumeric, 38
 Data length, bytes40
 Actual data size, bytes 4 852 680 or 28.98 % of table size
 Minimum value 1.37
 Average value 4 852 680 or 28.98 % of table size
 Maximum value 27 893.61
ColumnPropertyValue
rowguidData type and presentation sizeuniqueidentifier, 36
 Data length, bytes16
 Actual data size, bytes 1 941 072 or 11.59 % of table size
ColumnPropertyValue
ModifiedDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes 1 941 072 or 11.59 % of table size
 Minimum value2001-07-01
 Average value2003-08-16
 Maximum value2004-08-00

Table: Sales.SalesOrderHeader

PropertyValue
Table descriptionGeneral sales order information.
Analyzed columns27
Data rows 31 465
Data size, bytes 7 431 047 or 10.63 % of database size
Average row size, bytes236.16
Minimum row size, bytes216
Maximum row size, bytes254
Column Statistics for 'Sales.SalesOrderHeader' table
ColumnPropertyValue
SalesOrderIDData type and presentation sizeint identity, 10
 Data length, bytes4
 Actual data size, bytes125 860 or 1.69 % of table size
 Minimum value 43 659
 Average value 59 391.00
 Maximum value 75 123
ColumnPropertyValue
RevisionNumberData type and presentation sizetinyint, 3
 Data length, bytes1
 Actual data size, bytes 31 465 or 0.42 % of table size
 Minimum value 1
 Average value 1.00
 Maximum value 2
ColumnPropertyValue
OrderDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes503 440 or 6.77 % of table size
 Minimum value2001-07-01
 Average value2003-09-22
 Maximum value2004-08-00
ColumnPropertyValue
DueDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes503 440 or 6.77 % of table size
 Minimum value2001-07-13
 Average value2003-10-04
 Maximum value2004-08-12
ColumnPropertyValue
ShipDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes503 440 or 6.77 % of table size
 Minimum value2001-07-08
 Average value2003-09-29
 Maximum value2004-08-07
ColumnPropertyValue
StatusData type and presentation sizetinyint, 3
 Data length, bytes1
 Actual data size, bytes 31 465 or 0.42 % of table size
 Minimum value 5
 Average value 5.00
 Maximum value 5
ColumnPropertyValue
OnlineOrderFlagData type and presentation sizeFlag, 1
 Data length, bytes1
 Actual data size, bytes 31 465 or 0.42 % of table size
ColumnPropertyValue
SalesOrderNumberData type and presentation sizenvarchar, 25
 Data length, bytes50
 Actual data size, bytes220 255 or 2.96 % of table size
 Minimum value length7
 Maximum value length7
ColumnPropertyValue
PurchaseOrderNumberData type and presentation sizeOrderNumber, 25
 Data length, bytes50
 NULL values27659 or 87.90 %
 Actual data size, bytes 47 436 or 0.64 % of table size
 Minimum value length10
 Maximum value length13
ColumnPropertyValue
AccountNumberData type and presentation sizeAccountNumber, 15
 Data length, bytes30
 Actual data size, bytes440 510 or 5.93 % of table size
 Minimum value length14
 Maximum value length14
ColumnPropertyValue
CustomerIDData type and presentation sizeint, 10
 Data length, bytes4
 Actual data size, bytes125 860 or 1.69 % of table size
 Minimum value 1
 Average value 16 608.13
 Maximum value 29 483
ColumnPropertyValue
ContactIDData type and presentation sizeint, 10
 Data length, bytes4
 Actual data size, bytes125 860 or 1.69 % of table size
 Minimum value 1
 Average value 9 503.66
 Maximum value 19 977
ColumnPropertyValue
SalesPersonIDData type and presentation sizeint, 10
 Data length, bytes4
 NULL values27659 or 87.90 %
 Actual data size, bytes 15 224 or 0.20 % of table size
 Minimum value268
 Average value 33.89
 Maximum value290
ColumnPropertyValue
TerritoryIDData type and presentation sizeint, 10
 Data length, bytes4
 Actual data size, bytes125 860 or 1.69 % of table size
 Minimum value 1
 Average value 6.09
 Maximum value 10
ColumnPropertyValue
BillToAddressIDData type and presentation sizeint, 10
 Data length, bytes4
 Actual data size, bytes125 860 or 1.69 % of table size
 Minimum value405
 Average value 18 263.15
 Maximum value 29 883
ColumnPropertyValue
ShipToAddressIDData type and presentation sizeint, 10
 Data length, bytes4
 Actual data size, bytes125 860 or 1.69 % of table size
 Minimum value 9
 Average value 18 249.19
 Maximum value 29 883
ColumnPropertyValue
ShipMethodIDData type and presentation sizeint, 10
 Data length, bytes4
 Actual data size, bytes125 860 or 1.69 % of table size
 Minimum value 1
 Average value 1.48
 Maximum value 5
ColumnPropertyValue
CreditCardIDData type and presentation sizeint, 10
 Data length, bytes4
 NULL values1131 or 3.59 %
 Actual data size, bytes121 336 or 1.63 % of table size
 Minimum value 1
 Average value 9 336.00
 Maximum value 19 237
ColumnPropertyValue
CreditCardApprovalCodeData type and presentation sizevarchar, 15
 Data length, bytes15
 NULL values1131 or 3.59 %
 Actual data size, bytes394 707 or 5.31 % of table size
 Minimum value length9
 Maximum value length15
ColumnPropertyValue
CurrencyRateIDData type and presentation sizeint, 10
 Data length, bytes4
 NULL values17489 or 55.58 %
 Actual data size, bytes 55 904 or 0.75 % of table size
 Minimum value 2
 Average value 4 082.64
 Maximum value 12 431
ColumnPropertyValue
SubTotalData type and presentation sizemoney, 19
 Data length, bytes21
 Actual data size, bytes660 765 or 8.89 % of table size
 Minimum value 1.37
 Average value660 765 or 8.89 % of table size
 Maximum value224 356.48
ColumnPropertyValue
TaxAmtData type and presentation sizemoney, 19
 Data length, bytes21
 Actual data size, bytes660 765 or 8.89 % of table size
 Minimum value0.10
 Average value660 765 or 8.89 % of table size
 Maximum value 17 948.51
ColumnPropertyValue
FreightData type and presentation sizemoney, 19
 Data length, bytes21
 Actual data size, bytes660 765 or 8.89 % of table size
 Minimum value0.03
 Average value660 765 or 8.89 % of table size
 Maximum value 5 608.91
ColumnPropertyValue
TotalDueData type and presentation sizemoney, 19
 Data length, bytes21
 Actual data size, bytes660 765 or 8.89 % of table size
 Minimum value 1.51
 Average value660 765 or 8.89 % of table size
 Maximum value247 913.91
ColumnPropertyValue
CommentData type and presentation sizenvarchar, 128
 Data length, bytes256
 NULL values31465 or 100.00 %
 Actual data size, bytes0 or 0.00 % of table size
 Minimum value length0
 Maximum value length0
ColumnPropertyValue
rowguidData type and presentation sizeuniqueidentifier, 36
 Data length, bytes16
 Actual data size, bytes503 440 or 6.77 % of table size
ColumnPropertyValue
ModifiedDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes503 440 or 6.77 % of table size
 Minimum value2001-07-08
 Average value2003-09-29
 Maximum value2004-08-07

Table: Sales.SalesOrderHeaderSalesReason

PropertyValue
Table descriptionCross-reference table mapping sales orders to sales reason codes.
Analyzed columns3
Data rows 27 647
Data size, bytes663 528 or 0.95 % of database size
Table has fixed row size, bytes 24
Column Statistics for 'Sales.SalesOrderHeaderSalesReason' table
ColumnPropertyValue
SalesOrderIDData type and presentation sizeint, 10
 Data length, bytes4
 Actual data size, bytes110 588 or 16.67 % of table size
 Minimum value 43 697
 Average value 60 458.86
 Maximum value 75 123
ColumnPropertyValue
SalesReasonIDData type and presentation sizeint, 10
 Data length, bytes4
 Actual data size, bytes110 588 or 16.67 % of table size
 Minimum value 1
 Average value 2.58
 Maximum value 10
ColumnPropertyValue
ModifiedDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes442 352 or 66.67 % of table size
 Minimum value2001-07-01
 Average value2003-10-15
 Maximum value2004-08-00

Table: Sales.SalesPerson

PropertyValue
Table descriptionSales representative current information.
Analyzed columns9
Data rows 17
Data size, bytes 2 237 or 0.00 % of database size
Average row size, bytes131.58
Minimum row size, bytes111
Maximum row size, bytes136
Column Statistics for 'Sales.SalesPerson' table
ColumnPropertyValue
SalesPersonIDData type and presentation sizeint, 10
 Data length, bytes4
 Actual data size, bytes 68 or 3.04 % of table size
 Minimum value268
 Average value281.64
 Maximum value290
ColumnPropertyValue
TerritoryIDData type and presentation sizeint, 10
 Data length, bytes4
 NULL values3 or 17.65 %
 Actual data size, bytes 56 or 2.50 % of table size
 Minimum value 1
 Average value 3.94
 Maximum value 10
ColumnPropertyValue
SalesQuotaData type and presentation sizemoney, 19
 Data length, bytes21
 NULL values3 or 17.65 %
 Actual data size, bytes294 or 13.14 % of table size
 Minimum value250 000.00
 Average value294 or 13.14 % of table size
 Maximum value300 000.00
ColumnPropertyValue
BonusData type and presentation sizemoney, 19
 Data length, bytes21
 Actual data size, bytes357 or 15.96 % of table size
 Minimum value0.00
 Average value357 or 15.96 % of table size
 Maximum value 6 700.00
ColumnPropertyValue
CommissionPctData type and presentation sizesmallmoney, 10
 Data length, bytes12
 Actual data size, bytes204 or 9.12 % of table size
 Minimum value0.00
 Average value204 or 9.12 % of table size
 Maximum value0.02
ColumnPropertyValue
SalesYTDData type and presentation sizemoney, 19
 Data length, bytes21
 Actual data size, bytes357 or 15.96 % of table size
 Minimum value0.00
 Average value357 or 15.96 % of table size
 Maximum value 5 200 475.23
ColumnPropertyValue
SalesLastYearData type and presentation sizemoney, 19
 Data length, bytes21
 Actual data size, bytes357 or 15.96 % of table size
 Minimum value0.00
 Average value357 or 15.96 % of table size
 Maximum value 2 396 539.76
ColumnPropertyValue
rowguidData type and presentation sizeuniqueidentifier, 36
 Data length, bytes16
 Actual data size, bytes272 or 12.16 % of table size
ColumnPropertyValue
ModifiedDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes272 or 12.16 % of table size
 Minimum value2001-01-28
 Average value2002-01-16
 Maximum value2003-06-24

Table: Sales.SalesPersonQuotaHistory

PropertyValue
Table descriptionSales performance tracking.
Analyzed columns5
Data rows163
Data size, bytes 11 899 or 0.02 % of database size
Table has fixed row size, bytes 73
Column Statistics for 'Sales.SalesPersonQuotaHistory' table
ColumnPropertyValue
SalesPersonIDData type and presentation sizeint, 10
 Data length, bytes4
 Actual data size, bytes652 or 5.48 % of table size
 Minimum value268
 Average value280.15
 Maximum value290
ColumnPropertyValue
QuotaDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes 2 608 or 21.92 % of table size
 Minimum value2001-07-01
 Average value2003-01-18
 Maximum value2004-04-01
ColumnPropertyValue
SalesQuotaData type and presentation sizemoney, 19
 Data length, bytes21
 Actual data size, bytes 3 423 or 28.77 % of table size
 Minimum value 1 000.00
 Average value 3 423 or 28.77 % of table size
 Maximum value 1 898 000.00
ColumnPropertyValue
rowguidData type and presentation sizeuniqueidentifier, 36
 Data length, bytes16
 Actual data size, bytes 2 608 or 21.92 % of table size
ColumnPropertyValue
ModifiedDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes 2 608 or 21.92 % of table size
 Minimum value2001-05-17
 Average value2002-12-04
 Maximum value2004-02-16

Table: Sales.SalesReason

PropertyValue
Table descriptionLookup table of customer purchase reasons.
Analyzed columns4
Data rows 10
Data size, bytes385 or 0.00 % of database size
Average row size, bytes 38.50
Minimum row size, bytes 30
Maximum row size, bytes 54
Column Statistics for 'Sales.SalesReason' table
ColumnPropertyValue
SalesReasonIDData type and presentation sizeint identity, 10
 Data length, bytes4
 Actual data size, bytes 40 or 10.39 % of table size
 Minimum value 1
 Average value 5.50
 Maximum value 10
ColumnPropertyValue
NameData type and presentation sizeName, 50
 Data length, bytes100
 Actual data size, bytes115 or 29.87 % of table size
 Minimum value length5
 Maximum value length25
ColumnPropertyValue
ReasonTypeData type and presentation sizeName, 50
 Data length, bytes100
 Actual data size, bytes 70 or 18.18 % of table size
 Minimum value length5
 Maximum value length9
ColumnPropertyValue
ModifiedDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes160 or 41.56 % of table size
 Minimum value1998-06-01
 Average value1998-06-01
 Maximum value1998-06-01

Table: Sales.SalesTaxRate

PropertyValue
Table descriptionTax rate lookup table.
Analyzed columns7
Data rows 29
Data size, bytes 2 108 or 0.00 % of database size
Average row size, bytes 72.68
Minimum row size, bytes 65
Maximum row size, bytes 90
Column Statistics for 'Sales.SalesTaxRate' table
ColumnPropertyValue
SalesTaxRateIDData type and presentation sizeint identity, 10
 Data length, bytes4
 Actual data size, bytes116 or 5.50 % of table size
 Minimum value 1
 Average value 16.10
 Maximum value 31
ColumnPropertyValue
StateProvinceIDData type and presentation sizeint, 10
 Data length, bytes4
 Actual data size, bytes116 or 5.50 % of table size
 Minimum value 1
 Average value 43.82
 Maximum value 84
ColumnPropertyValue
TaxTypeData type and presentation sizetinyint, 3
 Data length, bytes1
 Actual data size, bytes 29 or 1.38 % of table size
 Minimum value 1
 Average value 2.00
 Maximum value 3
ColumnPropertyValue
TaxRateData type and presentation sizesmallmoney, 10
 Data length, bytes12
 Actual data size, bytes348 or 16.51 % of table size
 Minimum value 5.00
 Average value348 or 16.51 % of table size
 Maximum value 19.60
ColumnPropertyValue
NameData type and presentation sizeName, 50
 Data length, bytes100
 Actual data size, bytes571 or 27.09 % of table size
 Minimum value length12
 Maximum value length37
ColumnPropertyValue
rowguidData type and presentation sizeuniqueidentifier, 36
 Data length, bytes16
 Actual data size, bytes464 or 22.01 % of table size
ColumnPropertyValue
ModifiedDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes464 or 22.01 % of table size
 Minimum value1998-06-01
 Average value1998-06-01
 Maximum value1998-06-01

Table: Sales.SalesTerritory

PropertyValue
Table descriptionSales territory lookup table.
Analyzed columns10
Data rows 10
Data size, bytes 1 408 or 0.00 % of database size
Average row size, bytes140.80
Minimum row size, bytes134
Maximum row size, bytes144
Column Statistics for 'Sales.SalesTerritory' table
ColumnPropertyValue
TerritoryIDData type and presentation sizeint identity, 10
 Data length, bytes4
 Actual data size, bytes 40 or 2.84 % of table size
 Minimum value 1
 Average value 5.50
 Maximum value 10
ColumnPropertyValue
NameData type and presentation sizeName, 50
 Data length, bytes100
 Actual data size, bytes 85 or 6.04 % of table size
 Minimum value length6
 Maximum value length14
ColumnPropertyValue
CountryRegionCodeData type and presentation sizenvarchar, 3
 Data length, bytes6
 Actual data size, bytes 20 or 1.42 % of table size
 Minimum value length2
 Maximum value length2
ColumnPropertyValue
GroupData type and presentation sizenvarchar, 50
 Data length, bytes100
 Actual data size, bytes103 or 7.32 % of table size
 Minimum value length6
 Maximum value length13
ColumnPropertyValue
SalesYTDData type and presentation sizemoney, 19
 Data length, bytes21
 Actual data size, bytes210 or 14.91 % of table size
 Minimum value 1 977 474.80
 Average value210 or 14.91 % of table size
 Maximum value 8 351 296.74
ColumnPropertyValue
SalesLastYearData type and presentation sizemoney, 19
 Data length, bytes21
 Actual data size, bytes210 or 14.91 % of table size
 Minimum value 1 307 949.79
 Average value210 or 14.91 % of table size
 Maximum value 5 693 988.86
ColumnPropertyValue
CostYTDData type and presentation sizemoney, 19
 Data length, bytes21
 Actual data size, bytes210 or 14.91 % of table size
 Minimum value0.00
 Average value210 or 14.91 % of table size
 Maximum value0.00
ColumnPropertyValue
CostLastYearData type and presentation sizemoney, 19
 Data length, bytes21
 Actual data size, bytes210 or 14.91 % of table size
 Minimum value0.00
 Average value210 or 14.91 % of table size
 Maximum value0.00
ColumnPropertyValue
rowguidData type and presentation sizeuniqueidentifier, 36
 Data length, bytes16
 Actual data size, bytes160 or 11.36 % of table size
ColumnPropertyValue
ModifiedDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes160 or 11.36 % of table size
 Minimum value1998-06-01
 Average value1998-06-01
 Maximum value1998-06-01

Table: Sales.SalesTerritoryHistory

PropertyValue
Table descriptionSales representative transfers to other sales territories.
Analyzed columns6
Data rows 17
Data size, bytes 1 016 or 0.00 % of database size
Average row size, bytes 59.76
Minimum row size, bytes 56
Maximum row size, bytes 72
Column Statistics for 'Sales.SalesTerritoryHistory' table
ColumnPropertyValue
SalesPersonIDData type and presentation sizeint, 10
 Data length, bytes4
 Actual data size, bytes 68 or 6.69 % of table size
 Minimum value275
 Average value281.29
 Maximum value290
ColumnPropertyValue
TerritoryIDData type and presentation sizeint, 10
 Data length, bytes4
 Actual data size, bytes 68 or 6.69 % of table size
 Minimum value 1
 Average value 4.58
 Maximum value 10
ColumnPropertyValue
StartDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes272 or 26.77 % of table size
 Minimum value2001-07-01
 Average value2002-03-01
 Maximum value2003-07-01
ColumnPropertyValue
EndDateData type and presentation sizedatetime, 23
 Data length, bytes16
 NULL values13 or 76.47 %
 Actual data size, bytes 64 or 6.30 % of table size
 Minimum value2002-07-00
 Average value2002-10-30
 Maximum value2003-01-00
ColumnPropertyValue
rowguidData type and presentation sizeuniqueidentifier, 36
 Data length, bytes16
 Actual data size, bytes272 or 26.77 % of table size
ColumnPropertyValue
ModifiedDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes272 or 26.77 % of table size
 Minimum value2001-06-24
 Average value2002-06-17
 Maximum value2003-06-24

Table: Sales.ShoppingCartItem

PropertyValue
Table descriptionContains online customer orders until the order is submitted or cancelled.
Analyzed columns6
Data rows 3
Data size, bytes147 or 0.00 % of database size
Table has fixed row size, bytes 49
Column Statistics for 'Sales.ShoppingCartItem' table
ColumnPropertyValue
ShoppingCartItemIDData type and presentation sizeint identity, 10
 Data length, bytes4
 Actual data size, bytes 12 or 8.16 % of table size
 Minimum value 2
 Average value 3.66
 Maximum value 5
ColumnPropertyValue
ShoppingCartIDData type and presentation sizenvarchar, 50
 Data length, bytes100
 Actual data size, bytes 15 or 10.20 % of table size
 Minimum value length5
 Maximum value length5
ColumnPropertyValue
QuantityData type and presentation sizeint, 10
 Data length, bytes4
 Actual data size, bytes 12 or 8.16 % of table size
 Minimum value 3
 Average value 4.66
 Maximum value 7
ColumnPropertyValue
ProductIDData type and presentation sizeint, 10
 Data length, bytes4
 Actual data size, bytes 12 or 8.16 % of table size
 Minimum value862
 Average value872.33
 Maximum value881
ColumnPropertyValue
DateCreatedData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes 48 or 32.65 % of table size
 Minimum value2003-12-11
 Average value2003-12-11
 Maximum value2003-12-11
ColumnPropertyValue
ModifiedDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes 48 or 32.65 % of table size
 Minimum value2003-12-11
 Average value2003-12-11
 Maximum value2003-12-11

Table: Sales.SpecialOffer

PropertyValue
Table descriptionSale discounts lookup table.
Analyzed columns11
Data rows 16
Data size, bytes 2 100 or 0.00 % of database size
Average row size, bytes131.25
Minimum row size, bytes117
Maximum row size, bytes146
Column Statistics for 'Sales.SpecialOffer' table
ColumnPropertyValue
SpecialOfferIDData type and presentation sizeint identity, 10
 Data length, bytes4
 Actual data size, bytes 64 or 3.05 % of table size
 Minimum value 1
 Average value 8.50
 Maximum value 16
ColumnPropertyValue
DescriptionData type and presentation sizenvarchar, 255
 Data length, bytes510
 Actual data size, bytes362 or 17.24 % of table size
 Minimum value length11
 Maximum value length34
ColumnPropertyValue
DiscountPctData type and presentation sizesmallmoney, 10
 Data length, bytes12
 Actual data size, bytes192 or 9.14 % of table size
 Minimum value0.02
 Average value192 or 9.14 % of table size
 Maximum value0.50
ColumnPropertyValue
TypeData type and presentation sizenvarchar, 50
 Data length, bytes100
 Actual data size, bytes247 or 11.76 % of table size
 Minimum value length11
 Maximum value length20
ColumnPropertyValue
CategoryData type and presentation sizenvarchar, 50
 Data length, bytes100
 Actual data size, bytes131 or 6.24 % of table size
 Minimum value length8
 Maximum value length11
ColumnPropertyValue
StartDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes256 or 12.19 % of table size
 Minimum value2001-06-01
 Average value2002-08-08
 Maximum value2004-05-01
ColumnPropertyValue
EndDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes256 or 12.19 % of table size
 Minimum value2002-07-00
 Average value2003-11-10
 Maximum value2005-01-00
ColumnPropertyValue
MinQtyData type and presentation sizeint, 10
 Data length, bytes4
 Actual data size, bytes 64 or 3.05 % of table size
 Minimum value0
 Average value 9.56
 Maximum value 61
ColumnPropertyValue
MaxQtyData type and presentation sizeint, 10
 Data length, bytes4
 NULL values12 or 75.00 %
 Actual data size, bytes 16 or 0.76 % of table size
 Minimum value 14
 Average value 8.62
 Maximum value 60
ColumnPropertyValue
rowguidData type and presentation sizeuniqueidentifier, 36
 Data length, bytes16
 Actual data size, bytes256 or 12.19 % of table size
ColumnPropertyValue
ModifiedDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes256 or 12.19 % of table size
 Minimum value2001-05-02
 Average value2002-07-09
 Maximum value2004-04-01

Table: Sales.SpecialOfferProduct

PropertyValue
Table descriptionCross-reference table mapping products to special offer discounts.
Analyzed columns4
Data rows538
Data size, bytes 21 520 or 0.03 % of database size
Table has fixed row size, bytes 40
Column Statistics for 'Sales.SpecialOfferProduct' table
ColumnPropertyValue
SpecialOfferIDData type and presentation sizeint, 10
 Data length, bytes4
 Actual data size, bytes 2 152 or 10.00 % of table size
 Minimum value 1
 Average value 2.71
 Maximum value 16
ColumnPropertyValue
ProductIDData type and presentation sizeint, 10
 Data length, bytes4
 Actual data size, bytes 2 152 or 10.00 % of table size
 Minimum value680
 Average value849.47
 Maximum value999
ColumnPropertyValue
rowguidData type and presentation sizeuniqueidentifier, 36
 Data length, bytes16
 Actual data size, bytes 8 608 or 40.00 % of table size
ColumnPropertyValue
ModifiedDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes 8 608 or 40.00 % of table size
 Minimum value2001-05-02
 Average value2001-07-28
 Maximum value2004-04-01

Table: Sales.Store

PropertyValue
Table descriptionCustomers (resellers) of Adventure Works products.
Analyzed columns6
Data rows701
Data size, bytes 42 147 or 0.06 % of database size
Average row size, bytes 60.12
Minimum row size, bytes 49
Maximum row size, bytes 81
Column Statistics for 'Sales.Store' table
ColumnPropertyValue
CustomerIDData type and presentation sizeint, 10
 Data length, bytes4
 Actual data size, bytes 2 804 or 6.65 % of table size
 Minimum value 1
 Average value351.00
 Maximum value701
ColumnPropertyValue
NameData type and presentation sizeName, 50
 Data length, bytes100
 Actual data size, bytes 14 107 or 33.47 % of table size
 Minimum value length9
 Maximum value length41
ColumnPropertyValue
SalesPersonIDData type and presentation sizeint, 10
 Data length, bytes4
 Actual data size, bytes 2 804 or 6.65 % of table size
 Minimum value275
 Average value280.87
 Maximum value290
ColumnPropertyValue
DemographicsData type and presentation sizexml, 128
 Data length, bytes0
 Actual data size, bytes0 or 0.00 % of table size
ColumnPropertyValue
rowguidData type and presentation sizeuniqueidentifier, 36
 Data length, bytes16
 Actual data size, bytes 11 216 or 26.61 % of table size
ColumnPropertyValue
ModifiedDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes 11 216 or 26.61 % of table size
 Minimum value2004-10-13
 Average value2004-10-13
 Maximum value2004-10-13

Table: Sales.StoreContact

PropertyValue
Table descriptionCross-reference table mapping stores and their employees.
Analyzed columns5
Data rows753
Data size, bytes 33 132 or 0.05 % of database size
Table has fixed row size, bytes 44
Column Statistics for 'Sales.StoreContact' table
ColumnPropertyValue
CustomerIDData type and presentation sizeint, 10
 Data length, bytes4
 Actual data size, bytes 3 012 or 9.09 % of table size
 Minimum value 1
 Average value329.52
 Maximum value701
ColumnPropertyValue
ContactIDData type and presentation sizeint, 10
 Data length, bytes4
 Actual data size, bytes 3 012 or 9.09 % of table size
 Minimum value 1
 Average value415.62
 Maximum value956
ColumnPropertyValue
ContactTypeIDData type and presentation sizeint, 10
 Data length, bytes4
 Actual data size, bytes 3 012 or 9.09 % of table size
 Minimum value 11
 Average value 13.26
 Maximum value 15
ColumnPropertyValue
rowguidData type and presentation sizeuniqueidentifier, 36
 Data length, bytes16
 Actual data size, bytes 12 048 or 36.36 % of table size
ColumnPropertyValue
ModifiedDateData type and presentation sizedatetime, 23
 Data length, bytes16
 Actual data size, bytes 12 048 or 36.36 % of table size
 Minimum value2001-07-01
 Average value2002-08-22
 Maximum value2004-06-01