| Physical name | Suppliers | |
| Logical name | Suppliers | |
| Attributes | 12 | |
| Description | ||
| PK | Physical name | Datatype | FK Ref. |
| SupplierID | INT | |
| CompanyName | NVARCHAR (40) | ||
| ContactName | NVARCHAR (30) | ||
| ContactTitle | NVARCHAR (30) | ||
| Address | NVARCHAR (60) | ||
| City | NVARCHAR (15) | ||
| Region | NVARCHAR (15) | ||
| PostalCode | NVARCHAR (10) | ||
| Country | NVARCHAR (15) | ||
| Phone | NVARCHAR (24) | ||
| Fax | NVARCHAR (24) | ||
| HomePage | NTEXT |
| Indexes | |||
| CompanyName | CompanyName | ASC | |
| PostalCode | PostalCode | ASC | |
| xPostalCodeCity | PostalCode | ASC | |
| City | ASC | ||
| xpkSupplierID | UNIQUE | SupplierID | ASC |
| References | Referenced by |
| Product [FK_Products_Suppliers] |