Northwind Schema Report (data statistics)

Table of Contents

Summary

PropertyValue
Report created31-Oct-2005 21:21
DBMS and versionMicrosoft SQL Server [ 08.00.0760 ]
ServerTOSHIBA2
Database nameNorthwind
User/Login 
Schema/Owner 
Driver and versionSQLSRV32.DLL [ 03.85.1117 ]

Table 'dbo.Categories'

Property NameProperty Value
Records10
Fields4
Record size (bytes) w/o BLOBs34

Field statistics for 'CategoryID' int identity

Field propertyProperty value
Minimum value319
Maximum value328
Average value323
Values variance9.1666666666666661
Unique values10

Field statistics for 'CategoryName' nvarchar(15)

Field propertyProperty value
Minimum value1k
Maximum valuexh
Unique values10

Field statistics for 'Description' ntext

Field propertyProperty value
Minimum valueBLOB
Maximum valueBLOB
Average valueBLOB

Field statistics for 'Picture' image

Field propertyProperty value
Minimum valueBLOB
Maximum valueBLOB
Average valueBLOB

Table 'dbo.CustomerCustomerDemo'

Property NameProperty Value
Records10
Fields2
Record size (bytes) w/o BLOBs30

Field statistics for 'CustomerID' nchar(5)

Field propertyProperty value
Minimum value1jKd9
Maximum valuejoeML
Unique values9

Field statistics for 'CustomerTypeID' nchar(10)

Field propertyProperty value
Minimum value57n0hTmWV1
Maximum valuetjVcRkL25e
Unique values5

Table 'dbo.CustomerDemographics'

Property NameProperty Value
Records10
Fields2
Record size (bytes) w/o BLOBs20

Field statistics for 'CustomerTypeID' nchar(10)

Field propertyProperty value
Minimum value0WpRYdd1ek
Maximum valuetjVcRkL25e
Unique values10

Field statistics for 'CustomerDesc' ntext

Field propertyProperty value
Minimum valueBLOB
Maximum valueBLOB
Average valueBLOB

Table 'dbo.Customers'

Property NameProperty Value
Records10
Fields11
Record size (bytes) w/o BLOBs536

Field statistics for 'CustomerID' nchar(5)

Field propertyProperty value
Minimum value1jKd9
Maximum valuejoeML
Unique values10

Field statistics for 'CompanyName' nvarchar(40)

Field propertyProperty value
Minimum valueMike F. Hummer
Maximum valuesSKT3jaegQhgXh2S9cagLpvxbwi
Unique values10

Field statistics for 'ContactName' nvarchar(30)

Field propertyProperty value
Minimum value5
Maximum valuezxmctovfTpgpb0OOqW
Unique values9

Field statistics for 'ContactTitle' nvarchar(30)

Field propertyProperty value
Minimum value4hu
Maximum valuepllwrZlXbPpU
Unique values9

Field statistics for 'Address' nvarchar(60)

Field propertyProperty value
Minimum value3370 Yzvb Nv
Maximum value884 Ityzx Nef
Unique values9

Field statistics for 'City' nvarchar(15)

Field propertyProperty value
Minimum valueCarson City
Maximum valueSanta Fe
Unique values8

Field statistics for 'Region' nvarchar(15)

Field propertyProperty value
Minimum valueEast
Maximum valueWest
Unique values4

Field statistics for 'PostalCode' nvarchar(10)

Field propertyProperty value
Minimum value01203
Maximum value74607
Unique values9

Field statistics for 'Country' nvarchar(15)

Field propertyProperty value
Minimum valueBahrain
Maximum valueTaiwan
Unique values9

Field statistics for 'Phone' nvarchar(24)

Field propertyProperty value
Minimum value(000) 157-3761
Maximum value(977) 459-7135
Unique values9

Field statistics for 'Fax' nvarchar(24)

Field propertyProperty value
Minimum value(108) 094-3136
Maximum value(953) 597-3375
Unique values8

Table 'dbo.EmployeeTerritories'

Property NameProperty Value
Records10
Fields2
Record size (bytes) w/o BLOBs44

Field statistics for 'EmployeeID' int

Field propertyProperty value
Minimum value220
Maximum value229
Average value224
Values variance8.7111111111136985
Unique values7

Field statistics for 'TerritoryID' nvarchar(20)

Field propertyProperty value
Maximum valueia32iw3dUa
Unique values7

Table 'dbo.Employees'

Property NameProperty Value
Records10
Fields18
Record size (bytes) w/o BLOBs1006

Field statistics for 'EmployeeID' int identity

Field propertyProperty value
Minimum value220
Maximum value229
Average value224
Values variance9.1666666666666661
Unique values10

Field statistics for 'LastName' nvarchar(20)

Field propertyProperty value
Minimum valueBedolla
Maximum valueNaifeh
Unique values10

Field statistics for 'FirstName' nvarchar(10)

Field propertyProperty value
Minimum valueArnoldo
Maximum valueSid
Unique values9

Field statistics for 'Title' nvarchar(30)

Field propertyProperty value
Minimum valueVTudjPX
Maximum valuevnM0RsgVeaZmifa4LihaWVLVccuyed
Unique values9

Field statistics for 'TitleOfCourtesy' nvarchar(25)

Field propertyProperty value
Minimum value35Qbe
Maximum valueoWla4ohw
Unique values8

Field statistics for 'BirthDate' datetime

Field propertyProperty value
Minimum value1957-04-09 01:35:35.000
Maximum value2003-04-26 15:51:22.000
Unique values9

Field statistics for 'HireDate' datetime

Field propertyProperty value
Minimum value1952-05-07 01:06:00.000
Maximum value1998-07-03 17:44:42.000
Unique values9

Field statistics for 'Address' nvarchar(60)

Field propertyProperty value
Minimum value1 Sy Llsrf
Maximum value9 Yyy Ddsml
Unique values7

Field statistics for 'City' nvarchar(15)

Field propertyProperty value
Minimum value
Maximum valueSaint Paul
Unique values9

Field statistics for 'Region' nvarchar(15)

Field propertyProperty value
Minimum valueEast
Maximum valueWest
Unique values4

Field statistics for 'PostalCode' nvarchar(10)

Field propertyProperty value
Minimum value09382
Maximum value97415
Unique values8

Field statistics for 'Country' nvarchar(15)

Field propertyProperty value
Minimum valueAustralia
Maximum valueUnited States
Unique values9

Field statistics for 'HomePhone' nvarchar(24)

Field propertyProperty value
Minimum value(197) 099-8287
Maximum value(852) 545-9717
Unique values10

Field statistics for 'Extension' nvarchar(4)

Field propertyProperty value
Minimum value1673
Maximum value8397
Unique values8

Field statistics for 'Photo' image

Field propertyProperty value
Minimum valueBLOB
Maximum valueBLOB
Average valueBLOB

Field statistics for 'Notes' ntext

Field propertyProperty value
Minimum valueBLOB
Maximum valueBLOB
Average valueBLOB

Field statistics for 'ReportsTo' int

Field propertyProperty value
Minimum value220
Maximum value223
Average value221
Values variance0.8392857142857143
Unique values4

Field statistics for 'PhotoPath' nvarchar(255)

Field propertyProperty value
Minimum value0PjhirlMNpLciPPRlSKOigyTXjU9jaVY5L1fVo1iud4a071gU7wUh1R...
Maximum valuek8d7W3WnnK24qu3ZYsbitS0M4caypqc7w2YVjcsXd0PQYapdt1oLvrx...
Unique values7

Table 'dbo."Order Details"'

Property NameProperty Value
Records9
Fields5
Record size (bytes) w/o BLOBs35

Field statistics for 'OrderID' int

Field propertyProperty value
Minimum value11388
Maximum value11397
Average value11392
Values variance14.361111104488373
Unique values6

Field statistics for 'ProductID' int

Field propertyProperty value
Minimum value389
Maximum value396
Average value393
Values variance7.8611111111240461
Unique values5

Field statistics for 'UnitPrice' money(19.4)

Field propertyProperty value
Minimum value15824.7667
Maximum value104951.1013
Average value66109.8958
Values variance1243464577.5918379
Unique values9

Field statistics for 'Quantity' smallint

Field propertyProperty value
Minimum value2029
Maximum value24892
Average value15113
Values variance57175593.861111104
Unique values9

Field statistics for 'Discount' real

Field propertyProperty value
Minimum value0.0
Maximum value1.0
Average value0.33333333333333331
Values variance0.25
Unique values2

Table 'dbo.Orders'

Property NameProperty Value
Records10
Fields14
Record size (bytes) w/o BLOBs401

Field statistics for 'OrderID' int identity

Field propertyProperty value
Minimum value11388
Maximum value11397
Average value11392
Values variance9.1666666666666661
Unique values10

Field statistics for 'CustomerID' nchar(5)

Field propertyProperty value
Minimum value1jKd9
Maximum valuejoeML
Unique values7

Field statistics for 'EmployeeID' int

Field propertyProperty value
Minimum value221
Maximum value227
Average value223
Values variance5.0
Unique values6

Field statistics for 'OrderDate' datetime

Field propertyProperty value
Minimum value1953-12-21 19:39:16.000
Maximum value1996-12-06 20:00:18.000
Unique values10

Field statistics for 'RequiredDate' datetime

Field propertyProperty value
Minimum value1950-05-26 00:19:27.000
Maximum value2004-03-20 21:17:22.000
Unique values10

Field statistics for 'ShippedDate' datetime

Field propertyProperty value
Minimum value1965-02-05 22:53:29.000
Maximum value1991-08-07 08:06:29.000
Unique values9

Field statistics for 'ShipVia' int

Field propertyProperty value
Minimum value314
Maximum value322
Average value316
Values variance6.5535714285714288
Unique values5

Field statistics for 'Freight' money(19.4)

Field propertyProperty value
Minimum value5621.9914
Maximum value86760.4228
Average value64088.3739
Values variance550754699.62946892
Unique values9

Field statistics for 'ShipName' nvarchar(40)

Field propertyProperty value
Minimum valueK25kXaL4xizzjX0g8
Maximum valuemiPs0sLNn
Unique values10

Field statistics for 'ShipAddress' nvarchar(60)

Field propertyProperty value
Minimum value3104 Jkz Kftz
Maximum value90 Ou Wwp
Unique values9

Field statistics for 'ShipCity' nvarchar(15)

Field propertyProperty value
Minimum valueAustin
Maximum valueJackson
Unique values3

Field statistics for 'ShipRegion' nvarchar(15)

Field propertyProperty value
Minimum valueEast
Maximum valueWest
Unique values4

Field statistics for 'ShipPostalCode' nvarchar(10)

Field propertyProperty value
Minimum value07394
Maximum value95978
Unique values9

Field statistics for 'ShipCountry' nvarchar(15)

Field propertyProperty value
Minimum valueAzerbaijan
Maximum valueZambia
Unique values8

Table 'dbo.Products'

Property NameProperty Value
Records10
Fields10
Record size (bytes) w/o BLOBs160

Field statistics for 'ProductID' int identity

Field propertyProperty value
Minimum value388
Maximum value397
Average value392
Values variance9.1666666666666661
Unique values10

Field statistics for 'ProductName' nvarchar(40)

Field propertyProperty value
Maximum valuevqrew533p1fiU4065ugRiZx6
Unique values10

Field statistics for 'SupplierID' int

Field propertyProperty value
Minimum value361
Maximum value369
Average value365
Values variance7.4444444444379769
Unique values7

Field statistics for 'CategoryID' int

Field propertyProperty value
Minimum value320
Maximum value328
Average value324
Values variance11.111111111109494
Unique values5

Field statistics for 'QuantityPerUnit' nvarchar(20)

Field propertyProperty value
Minimum value55La
Maximum valuemfUdUds4bLav
Unique values9

Field statistics for 'UnitPrice' money(19.4)

Field propertyProperty value
Minimum value1931.3970
Maximum value103620.7314
Average value57218.0711
Values variance1072464097.1415939
Unique values10

Field statistics for 'UnitsInStock' smallint

Field propertyProperty value
Minimum value4555
Maximum value32516
Average value16581
Values variance91905991.600000009
Unique values10

Field statistics for 'UnitsOnOrder' smallint

Field propertyProperty value
Minimum value4468
Maximum value28669
Average value18520
Values variance101042974.33333333
Unique values7

Field statistics for 'ReorderLevel' smallint

Field propertyProperty value
Minimum value1518
Maximum value30763
Average value14034
Values variance115231767.2
Unique values6

Field statistics for 'Discontinued' bit

Field propertyProperty value
Unique values2

Table 'dbo.Region'

Property NameProperty Value
Records10
Fields2
Record size (bytes) w/o BLOBs104

Field statistics for 'RegionID' int

Field propertyProperty value
Minimum value6292793
Maximum value997433353
Values variance1.1032740190049837E+17
Unique values10

Field statistics for 'RegionDescription' nchar(50)

Field propertyProperty value
Minimum valueEast
Maximum valueWest
Unique values4

Table 'dbo.Shippers'

Property NameProperty Value
Records10
Fields3
Record size (bytes) w/o BLOBs132

Field statistics for 'ShipperID' int identity

Field propertyProperty value
Minimum value314
Maximum value323
Average value318
Values variance9.1666666666666661
Unique values10

Field statistics for 'CompanyName' nvarchar(40)

Field propertyProperty value
Minimum value0fc9ejvUih3a0gWnOPZvkuV0wq59
Maximum valueweh
Unique values10

Field statistics for 'Phone' nvarchar(24)

Field propertyProperty value
Minimum value(123) 065-9122
Maximum value(897) 205-7368
Unique values9

Table 'dbo.Suppliers'

Property NameProperty Value
Records10
Fields12
Record size (bytes) w/o BLOBs530

Field statistics for 'SupplierID' int identity

Field propertyProperty value
Minimum value360
Maximum value369
Average value364
Values variance9.1666666666666661
Unique values10

Field statistics for 'CompanyName' nvarchar(40)

Field propertyProperty value
Minimum value0ivNYbcs6oW
Maximum valuet5v1ojbP
Unique values10

Field statistics for 'ContactName' nvarchar(30)

Field propertyProperty value
Maximum valuexoi5yL
Unique values8

Field statistics for 'ContactTitle' nvarchar(30)

Field propertyProperty value
Maximum valuevM6Onxr
Unique values8

Field statistics for 'Address' nvarchar(60)

Field propertyProperty value
Minimum value0 Xlr Jsblogv
Maximum value8 Fmkf Xa
Unique values10

Field statistics for 'City' nvarchar(15)

Field propertyProperty value
Minimum value
Maximum valueTallahassee
Unique values8

Field statistics for 'Region' nvarchar(15)

Field propertyProperty value
Minimum valueEast
Maximum valueWest
Unique values4

Field statistics for 'PostalCode' nvarchar(10)

Field propertyProperty value
Minimum value04708
Maximum value86381
Unique values9

Field statistics for 'Country' nvarchar(15)

Field propertyProperty value
Minimum valueBelgium
Maximum valueYugoslavia
Unique values10

Field statistics for 'Phone' nvarchar(24)

Field propertyProperty value
Minimum value(174) 363-9493
Maximum value(842) 919-5596
Unique values9

Field statistics for 'Fax' nvarchar(24)

Field propertyProperty value
Minimum value(215) 598-8480
Maximum value(871) 773-6252
Unique values9

Field statistics for 'HomePage' ntext

Field propertyProperty value
Minimum valueBLOB
Maximum valueBLOB
Average valueBLOB

Table 'dbo.Territories'

Property NameProperty Value
Records10
Fields3
Record size (bytes) w/o BLOBs144

Field statistics for 'TerritoryID' nvarchar(20)

Field propertyProperty value
Maximum valueia32iw3dUa
Unique values10

Field statistics for 'TerritoryDescription' nchar(50)

Field propertyProperty value
Minimum value9ZThXn5sri54duXx6bV9igzjxeefar7R200SxZi1XjKsXhXrYg
Maximum valueo02tzpgXWd43dSUa6QgRx9lgMY3fcn9jj4ijsSMhV3gVkd0c8o
Unique values10

Field statistics for 'RegionID' int

Field propertyProperty value
Minimum value6292793
Maximum value940079918
Values variance1.0707818461126576E+17
Unique values7