WideWorldImporters
Website.Suppliers
Created: Modified:
Columns
-
SupplierID[int] NOT NULL
-
SupplierName[nvarchar](100) NOT NULL
-
SupplierCategoryName[nvarchar](50) NULL
-
PrimaryContact[nvarchar](50) NULL
-
AlternateContact[nvarchar](50) NULL
-
PhoneNumber[nvarchar](20) NOT NULL
-
FaxNumber[nvarchar](20) NOT NULL
-
WebsiteURL[nvarchar](256) NOT NULL
-
DeliveryMethod[nvarchar](50) NULL
-
CityName[nvarchar](50) NULL
-
DeliveryLocation[geography] NULL
-
SupplierReference[nvarchar](20) NULL
Definition
Sample Data
SupplierID
SupplierName
SupplierCategoryName
PrimaryContact
AlternateContact
PhoneNumber
FaxNumber
WebsiteURL
DeliveryMethod
CityName
DeliveryLocation
SupplierReference
1
A Datum Corporation
Novelty Goods Supplier
Reio Kabin
Oliver Kivi
(847) 555-0100
(847) 555-0101
http://www.adatum.com
Road Freight
Zionsville
[geography]
AA20384
2
Contoso, Ltd.
Novelty Goods Supplier
Hanna Mihhailov
Paulus Lippmaa
(360) 555-0100
(360) 555-0101
http://www.contoso.com
Refrigerated Road Freight
Greenbank
[geography]
B2084020
3
Consolidated Messenger
Courier Services Supplier
Kerstin Parn
Helen Ahven
(415) 555-0100
(415) 555-0101
http://www.consolidatedmessenger.com
NULL
San Francisco
[geography]
209340283
4
Fabrikam, Inc.
Clothing Supplier
Bill Lawson
Helen Moore
(203) 555-0104
(203) 555-0108
http://www.fabrikam.com
Road Freight
Lakeview Heights
[geography]
293092
5
Graphic Design Institute
Novelty Goods Supplier
Penny Buck
Donna Smith
(406) 555-0105
(406) 555-0106
http://www.graphicdesigninstitute.com
Refrigerated Air Freight
Lanagan
[geography]
08803922
6
Humongous Insurance
Insurance Services Supplier
Madelaine Cartier
Annette Talon
(423) 555-0105
(423) 555-0100
http://www.humongousinsurance.com
NULL
Lancing
[geography]
082420938
7
Litware, Inc.
Packaging Supplier
Elias Myllari
Vilma Niva
(209) 555-0108
(209) 555-0104
http://www.litwareinc.com
Courier
Mokelumne Hill
[geography]
BC0280982
8
Lucerne Publishing
Novelty Goods Supplier
Prem Prabhu
Sunita Jadhav
(423) 555-0103
(423) 555-0105
http://www.lucernepublishing.com
Refrigerated Air Freight
Jonesborough
[geography]
JQ082304802
9
Nod Publishers
Novelty Goods Supplier
Marcos Costa
Matheus Oliveira
(252) 555-0100
(252) 555-0101
http://www.nodpublishers.com
Refrigerated Air Freight
Elizabeth City
[geography]
GL08029802
10
Northwind Electric Cars
Toy Supplier
Eliza Soderberg
Sara Karlsson
(201) 555-0105
(201) 555-0104
http://www.northwindelectriccars.com
Air Freight
Crandon Lakes
[geography]
ML0300202
11
Trey Research
Marketing Services Supplier
Donald Jones
Sharon Graham
(605) 555-0103
(605) 555-0101
http://www.treyresearch.net
NULL
Kadoka
[geography]
082304822
12
The Phone Company
Novelty Goods Supplier
Hai Dam
Thanh Dinh
(218) 555-0105
(218) 555-0105
http://www.thephone-company.com
Road Freight
Karlstad
[geography]
237408032
13
Woodgrove Bank
Financial Services Supplier
Hubert Helms
Donald Small
(415) 555-0103
(415) 555-0107
http://www.woodgrovebank.com
NULL
San Francisco
[geography]
028034202