Database Examples/Northwind/Suppliers
< Database Examples < Northwind
Fields
| Field Name | Field Type | Length | Index | Constraint | Default |
|---|---|---|---|---|---|
| SupplierID | Integer | Primary Key | Not Null | ||
| SupplierName | Text | 50 | Yes | Not Null | |
| ContactName | Text | 50 | Yes | ||
| Address | Text | 50 | |||
| City | Text | 20 | Yes | ||
| PostalCode | Text | 10 | Yes | ||
| Country | Text | 15 | Yes | ||
| Phone | Text | 15 |
Data
| SupplierID | SupplierName | ContactName | Address | City | PostalCode | Country | Phone |
|---|---|---|---|---|---|---|---|
| 1 | Exotic Liquid | Charlotte Cooper | 49 Gilbert St. | Londona | EC1 4SD | UK | (171) 555-2222 |
| 2 | New Orleans Cajun Delights | Shelley Burke | P.O. Box 78934 | New Orleans | 70117 | USA | (100) 555-4822 |
| 3 | Grandma Kelly's Homestead | Regina Murphy | 707 Oxford Rd. | Ann Arbor | 48104 | USA | (313) 555-5735 |
| 4 | Tokyo Traders | Yoshi Nagase | 9-8 Sekimai Musashino-shi | Tokyo | 100 | Japan | (03) 3555-5011 |
| 5 | Cooperativa de Quesos 'Las Cabras' | Antonio del Valle Saavedra | Calle del Rosal 4 | Oviedo | 33007 | Spain | (98) 598 76 54 |
| 6 | Mayumi's | Mayumi Ohno | 92 Setsuko Chuo-ku | Osaka | 545 | Japan | (06) 431-7877 |
| 7 | Pavlova, Ltd. | Ian Devling | 74 Rose St. Moonie Ponds | Melbourne | 3058 | Australia | (03) 444-2343 |
| 8 | Specialty Biscuits, Ltd. | Peter Wilson | 29 King's Way | Manchester | M14 GSD | UK | (161) 555-4448 |
| 9 | PB Knäckebröd AB | Lars Peterson | Kaloadagatan 13 | Göteborg | S-345 67 | Sweden | 031-987 65 43 |
| 10 | Refrescos Americanas LTDA | Carlos Diaz | Av. das Americanas 12.890 | São Paulo | 5442 | Brazil | (11) 555 4640 |
| 11 | Heli Süßwaren GmbH & Co. KG | Petra Winkler | Tiergartenstraße 5 | Berlin | 10785 | Germany | (010) 9984510 |
| 12 | Plutzer Lebensmittelgroßmärkte AG | Martin Bein | Bogenallee 51 | Frankfurt | 60439 | Germany | (069) 992755 |
| 13 | Nord-Ost-Fisch Handelsgesellschaft mbH | Sven Petersen | Frahmredder 112a | Cuxhaven | 27478 | Germany | (04721) 8713 |
| 14 | Formaggi Fortini s.r.l. | Elio Rossi | Viale Dante, 75 | Ravenna | 48100 | Italy | (0544) 60323 |
| 15 | Norske Meierier | Beate Vileid | Hatlevegen 5 | Sandvika | 1320 | Norway | (0)2-953010 |
| 16 | Bigfoot Breweries | Cheryl Saylor | 3400 - 8th Avenue Suite 210 | Bend | 97101 | USA | (503) 555-9931 |
| 17 | Svensk Sjöföda AB | Michael Björn | Brovallavägen 231 | Stockholm | S-123 45 | Sweden | 08-123 45 67 |
| 18 | Aux joyeux ecclésiastiques | Guylène Nodier | 203, Rue des Francs-Bourgeois | Paris | 75004 | France | (1) 03.83.00.68 |
| 19 | New England Seafood Cannery | Robb Merchant | Order Processing Dept. 2100 Paul Revere Blvd. | Boston | 02134 | USA | (617) 555-3267 |
| 20 | Leka Trading | Chandra Leka | 471 Serangoon Loop, Suite #402 | Singapore | 0512 | Singapore | 555-8787 |
| 21 | Lyngbysild | Niels Petersen | Lyngbysild Fiskebakken 10 | Lyngby | 2800 | Denmark | 43844108 |
| 22 | Zaanse Snoepfabriek | Dirk Luchte | Verkoop Rijnweg 22 | Zaandam | 9999 ZZ | Netherlands | (12345) 1212 |
| 23 | Karkki Oy | Anne Heikkonen | Valtakatu 12 | Lappeenranta | 53120 | Finland | (953) 10956 |
| 24 | G'day, Mate | Wendy Mackenzie | 170 Prince Edward Parade Hunter's Hill | Sydney | 2042 | Australia | (02) 555-5914 |
| 25 | Ma Maison | Jean-Guy Lauzon | 2960 Rue St. Laurent | Montréal | H1J 1C3 | Canada | (514) 555-9022 |
| 26 | Pasta Buttini s.r.l. | Giovanni Giudici | Via dei Gelsomini, 153 | Salerno | 84100 | Italy | (089) 6547665 |
| 27 | Escargots Nouveaux | Marie Delamare | 22, rue H. Voiron | Montceau | 71300 | France | 85.57.00.07 |
| 28 | Gai pâturage | Eliane Noz | Bat. B 3, rue des Alpes | Annecy | 74000 | France | 38.76.98.06 |
| 29 | Forêts d'érables | Chantal Goulet | 148 rue Chasseur | Ste-Hyacinthe | J2S 7S8 | Canada | (514) 555-2955 |