Table of contents
NorthWind

• Tables
  • Categories
  • Customers
  • Employees
  • Order Details
  • Orders
  • Products
  • Shippers
  • Suppliers
• Queries
  • CrossTab
  • Customers union All
  • EmployeesList
  • Orders_CalculatedField
  • Query1
• Forms
  • Calculator
  • Categories
  • Customers_NewRec
  • Customers_Sync_Orders
  • Employees_FillAuto
  • Employees_Sync_Orders
  • Orders_2Combos
  • Orders_Browse
  • Orders_CalculatedField
  • Orders_CalculatedField_Grid
  • Orders_Details_Sync_Cust-Prod-Emp
  • Orders_Tabbed
  • Products_FastSearch
  • Products_FastSelect
  • Products_ListBoxFilter
  • Products_Sync_Orders
  • Products_ZoomImage
• Dialogs
  • dlgCalc
• Modules
  • _Constants
  • _Init
  • Browse
  • CalculatedField
  • Calculator
  • ComboBox
  • CrossTab
  • Dictionary
  • Export
  • FastSearch
  • FastSelect
  • FillAuto
  • HowTo
  • Images
  • ListBox
  • NewRec
  • OutputTo
  • Records
  • Snippets
  • Synchro
  • Tabbed
  • Test
  • Tiptext
  • Zoom
• Index

List of fields by table

Table name	Field name	Field type	Primary key	% not Null	Average	Most positive	Oldest date	Newest date	Longest string
Categories	CategoryID	BIGINT	✔	100
	CategoryName	VARCHAR		100					14
	Description	VARCHAR		100					58
	Picture	BINARY		100
Customers	Address	VARCHAR		100					46
	City	VARCHAR		100					15
	CompanyName	VARCHAR		100					36
	ContactName	VARCHAR		100					23
	ContactTitle	VARCHAR		100					30
	Country	VARCHAR		100					11
	CustomerID	VARCHAR	✔	100					5
	Fax	VARCHAR		76					17
	Phone	VARCHAR		100					17
	PostalCode	VARCHAR		99					9
	Region	VARCHAR		34					13
Employees	Address	VARCHAR		100					30
	BirthDate	TIMESTAMP		100			19/02/1952	02/07/1969
	City	VARCHAR		100					8
	Country	VARCHAR		100					3
	EmployeeID	BIGINT	✔	100
	Extension	INTEGER		100		5467
	FirstName	VARCHAR		100					8
	HireDate	TIMESTAMP		100			01/04/1992	15/11/1994
	HomePhone	VARCHAR		100					14
	LastName	VARCHAR		100					9
	Notes	VARCHAR		100					423
	Photo	VARCHAR		100					10
	PostalCode	VARCHAR		100					7
	Region	VARCHAR		56					2
	ReportsTo	INTEGER		89		5
	Title	VARCHAR		100					24
	TitleOfCourtesy	VARCHAR		100					4
Order Details	Discount	FLOAT		100	5,61670542022607E-02	0,25
	OrderID	INTEGER	✔	100		11077
	ProductID	INTEGER	✔	100		77
	Quantity	SMALLINT		100		130
	UnitPrice	NUMERIC		100	26	263
Orders	CustomerID	VARCHAR		100					5
	EmployeeID	INTEGER		100		9
	Freight	NUMERIC		100	78	1008
	OrderDate	TIMESTAMP		100			04/07/1996	06/05/1998
	OrderID	BIGINT	✔	100
	RequiredDate	TIMESTAMP		100			24/07/1996	11/06/1998
	ShipAddress	VARCHAR		100					46
	ShipCity	VARCHAR		100					15
	ShipCountry	VARCHAR		100					11
	ShipName	VARCHAR		100					34
	ShippedDate	TIMESTAMP		97			10/07/1996	06/05/1998
	ShipPostalCode	VARCHAR		98					9
	ShipRegion	VARCHAR		39					13
	ShipVia	INTEGER		100		3
Products	CategoryID	INTEGER		100		8
	Discontinued	BOOLEAN		100
	Picture	LONGVARBINARY		6
	ProductID	BIGINT	✔	100
	ProductName	VARCHAR		100					32
	QuantityPerUnit	VARCHAR		100					20
	ReorderLevel	SMALLINT		100		30
	SupplierID	INTEGER		100		29
	UnitPrice	NUMERIC		100	29	263
	UnitsInStock	SMALLINT		100		125
	UnitsOnOrder	SMALLINT		100		100
Shippers	CompanyName	VARCHAR		100					16
	Phone	VARCHAR		100					14
	ShipperID	BIGINT	✔	100
Suppliers	Address	VARCHAR		100					46
	City	VARCHAR		100					13
	CompanyName	VARCHAR		100					38
	ContactName	VARCHAR		100					27
	ContactTitle	VARCHAR		100					28
	Country	VARCHAR		100					11
	Fax	VARCHAR		45					15
	HomePage	VARCHAR		10					94
	Phone	VARCHAR		100					15
	PostalCode	VARCHAR		100					8
	Region	VARCHAR		31					8
	SupplierID	BIGINT	✔	100