Customers Table

Description

Customers' names, addresses, and phone numbers.

Fields

Name	Type	Attributes	Default	Description
CustomerID	nchar(5)			Unique five-character code based on customer name.
CompanyName	nvarchar(40)
ContactName	nvarchar(30)	Nullable
ContactTitle	nvarchar(30)	Nullable
Address	nvarchar(60)	Nullable		Street or post-office box.
City	nvarchar(15)	Nullable
Region	nvarchar(15)	Nullable		State or province.
PostalCode	nvarchar(10)	Nullable
Country	nvarchar(15)	Nullable
Phone	nvarchar(24)	Nullable		Phone number includes country code or area code.
Fax	nvarchar(24)	Nullable		Phone number includes country code or area code.

Indexes

Name	Columns	Unique
City	City	no
CompanyName	CompanyName	no
PostalCode	PostalCode	no
Region	Region	no

Relationships

See Also

Tables | Views | Stored Procedures