|
Key
|
ID
|
Name
|
Data Type
|
Size(Precision,Scale)
|
Nulls
|
Default
|
|
|
CustomerID
|
nchar
|
5
|
|
|
| |
The primary key for each customer.
|
|
|
CompanyName
|
nvarchar
|
40
|
|
|
| |
The name of the company.
|
|
|
ContactName
|
nvarchar
|
30
|
|
|
| |
The company's contact name.
|
|
|
ContactTitle
|
nvarchar
|
30
|
|
|
| |
The company's contact title.
|
|
|
Address
|
nvarchar
|
60
|
|
|
| |
The company's street address.
|
|
|
City
|
nvarchar
|
15
|
|
|
| |
The company's city.
|
|
|
Region
|
nvarchar
|
15
|
|
|
| |
The company's region.
|
|
|
PostalCode
|
nvarchar
|
10
|
|
|
| |
The company's postal code.
|
|
|
Country
|
nvarchar
|
15
|
|
|
| |
The company's country.
|
|
|
Phone
|
nvarchar
|
24
|
|
|
| |
The company's phone number.
|
|
|
Fax
|
nvarchar
|
24
|
|
|
| |
The company's fax number.
|