Suppliers (Created 8/6/2000 1:34:06 AM)
Description: This table contains all of the suppliers.
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.