Jump to content

Database Examples/Northwind/Suppliers

From Wikiversity

Fields

[edit | edit source]
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
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