| name | value |
|---|---|
| name | Suppliers |
| created | 9/13/1995 10:51:42 AM |
| modified | 8/16/2008 9:43:29 PM |
| row count | 29 |
| column | datatype | length | default | nulls | PK | FK | UQ | comment |
|---|---|---|---|---|---|---|---|---|
| SupplierID | long | 4 | yes | yes | Products.SupplierID | Number automatically assigned to new supplier. | ||
| CompanyName | text | 40 | no | |||||
| ContactName | text | 30 | yes | |||||
| ContactTitle | text | 30 | yes | |||||
| Address | text | 60 | yes | Street or post-office box. | ||||
| City | text | 15 | yes | |||||
| Region | text | 15 | yes | State or province. | ||||
| PostalCode | text | 10 | yes | |||||
| Country | text | 15 | yes | |||||
| Phone | text | 24 | yes | Phone number includes country code or area code. | ||||
| Fax | text | 24 | yes | Phone number includes country code or area code. | ||||
| HomePage | memo | 0 | yes | Supplier's home page on World Wide Web. |
| name | description | column | comment |
|---|---|---|---|
| CompanyName | non-clustered, non-unique index on Suppliers | CompanyName | |
| PostalCode | non-clustered, non-unique index on Suppliers | PostalCode | |
| PrimaryKey | non-clustered, unique primary key on Suppliers | SupplierID |
| name |
|---|
| Products |
| name | columns | foreign columns | type | comment |
|---|---|---|---|---|
| SuppliersProducts | SupplierID | Products.SupplierID |
| name | object type | level |
|---|---|---|
| ~sq_cProducts~sq_cSupplierID | view | 1 |
| ~sq_fSuppliers | view | 1 |
| Customers and Suppliers by City | view | 1 |
| SupplierID | CompanyName | ContactName | ContactTitle | Address | City | Region | PostalCode | Country | Phone | Fax | HomePage |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Exotic Liquids | Charlotte Cooper | Purchasing Manager | 49 Gilbert St. | London | NULL | EC1 4SD | UK | (171) 555-2222 | NULL | NULL |
| 2 | New Orleans Cajun Delights | Shelley Burke | Order Administrator | P.O. Box 78934 | New Orleans | LA | 70117 | USA | (100) 555-4822 | NULL | #CAJUN.HTM# |
| 3 | Grandma Kelly's Homestead | Regina Murphy | Sales Representative | 707 Oxford Rd. | Ann Arbor | MI | 48104 | USA | (313) 555-5735 | (313) 555-3349 | NULL |
| 4 | Tokyo Traders | Yoshi Nagase | Marketing Manager | 9-8 Sekimai Musashino-shi | Tokyo | NULL | 100 | Japan | (03) 3555-5011 | NULL | NULL |
| 5 | Cooperativa de Quesos 'Las Cabras' | Antonio del Valle Saavedra | Export Administrator | Calle del Rosal 4 | Oviedo | Asturias | 33007 | Spain | (98) 598 76 54 | NULL | NULL |
| 6 | Mayumi's | Mayumi Ohno | Marketing Representative | 92 Setsuko Chuo-ku | Osaka | NULL | 545 | Japan | (06) 431-7877 | NULL | Mayumi's (on the World Wide Web)#http://www.microsoft.com/accessdev/sampleapps/mayumi.htm# |
| 7 | Pavlova, Ltd. | Ian Devling | Marketing Manager | 74 Rose St. Moonie Ponds | Melbourne | Victoria | 3058 | Australia | (03) 444-2343 | (03) 444-6588 | NULL |
| 8 | Specialty Biscuits, Ltd. | Peter Wilson | Sales Representative | 29 King's Way | Manchester | NULL | M14 GSD | UK | (161) 555-4448 | NULL | NULL |
| 9 | PB Knäckebröd AB | Lars Peterson | Sales Agent | Kaloadagatan 13 | Göteborg | NULL | S-345 67 | Sweden | 031-987 65 43 | 031-987 65 91 | NULL |
| 10 | Refrescos Americanas LTDA | Carlos Diaz | Marketing Manager | Av. das Americanas 12.890 | São Paulo | NULL | 5442 | Brazil | (11) 555 4640 | NULL | NULL |