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