AdventureWorks2019
Production.vProductModelCatalogDescription
//
Displays the content from each element in the xml column CatalogDescription for each product in the Production.ProductModel table that has catalog data.
Created: Modified:
Columns
-
ProductModelID[int] IDENTITY (null,null) NOT NULL
-
Name[Name] NOT NULL
-
Summary[nvarchar](MAX) NULL
-
Manufacturer[nvarchar](MAX) NULL
-
Copyright[nvarchar](30) NULL
-
ProductURL[nvarchar](256) NULL
-
WarrantyPeriod[nvarchar](256) NULL
-
WarrantyDescription[nvarchar](256) NULL
-
NoOfYears[nvarchar](256) NULL
-
MaintenanceDescription[nvarchar](256) NULL
-
Wheel[nvarchar](256) NULL
-
Saddle[nvarchar](256) NULL
-
Pedal[nvarchar](256) NULL
-
BikeFrame[nvarchar](MAX) NULL
-
Crankset[nvarchar](256) NULL
-
PictureAngle[nvarchar](256) NULL
-
PictureSize[nvarchar](256) NULL
-
ProductPhotoID[nvarchar](256) NULL
-
Material[nvarchar](256) NULL
-
Color[nvarchar](256) NULL
-
ProductLine[nvarchar](256) NULL
-
Style[nvarchar](256) NULL
-
RiderExperience[nvarchar](1024) NULL
-
rowguid[uniqueidentifier] NOT NULL
-
ModifiedDate[datetime] NOT NULL
Definition
Sample Data
ProductModelID
Name
Summary
Manufacturer
Copyright
ProductURL
WarrantyPeriod
WarrantyDescription
NoOfYears
MaintenanceDescription
Wheel
Saddle
Pedal
BikeFrame
Crankset
PictureAngle
PictureSize
ProductPhotoID
Material
Color
ProductLine
Style
RiderExperience
rowguid
ModifiedDate
19
Mountain-100
Our top-of-the-line competition mountain bike.
Performance-enhancing options include the innovative HL Frame,
super-smooth front suspension, and traction for all terrain.
AdventureWorks
2002
HTTP://www.Adventure-works.com
3 years
parts and labor
10 years
maintenance contract available through your dealer or any AdventureWorks retail store.
High performance wheels.
Anatomic design and made from durable leather for a full-day of riding in comfort.
Top-of-the-line clipless pedals with adjustable tension.
Each frame is hand-crafted in our Bothell facility to the optimum diameter
and wall-thickness required of a premium mountain frame.
The heat-treated welded aluminum frame has a larger diameter tube that absorbs the bumps.
Triple crankset; alumunim crank arm; flawless shifting.
front
small
118
Almuminum Alloy
Available in most colors
Mountain bike
Unisex
Advanced to Professional riders
FCA0665B-B956-489A-A5EC-6F0B4AA14D02
23
Mountain-500
Suitable for any type of riding, on or off-road.
Fits any budget. Smooth-shifting with a comfortable ride.
AdventureWorks
2002
HTTP://www.Adventure-works.com
1 year
parts and labor
3 years
maintenance contact available through dealer
Stable, durable wheels suitable for novice riders.
Made from synthetic leather and features gel padding for increased comfort.
Expanded platform so you can ride in any shoes; great for all-around riding.
Our best value frame utilizing the same, ground-breaking technology as the ML aluminum frame.
Super rigid spindle.
front
small
1
Aluminum Alloy
Available in all colors.
Mountain bike
Unisex
Novice to Intermediate riders
866DBAD3-5999-4329-BEAC-D826D959D9A1
25
Road-150
This bike is ridden by race winners. Developed with the
Adventure Works Cycles professional race team, it has a extremely light
heat-treated aluminum frame, and steering that allows precision control.
AdventureWorks
2002
HTTP://www.Adventure-works.com
4 years
parts and labor
7 years
maintenance contact available through dealer or any Adventure Works Cycles retail store.
Strong wheels with double-walled rims.
Lightweight kevlar racing saddle.
Top-of-the-line clipless pedals with adjustable tension.
Our lightest and best quality aluminum frame made from the newest alloy;
it is welded and heat-treated for strength.
Our innovative design results in maximum comfort and performance.
NULL
front
small
126
Aluminum
Available in all colors.
Road bike
Unisex
Intermediate to Professional riders
94FFB702-0CBC-4E3F-B840-C51F0D11C8F6
28
Road-450
A true multi-sport bike that offers streamlined riding and a revolutionary design.
Aerodynamic design lets you ride with the pros, and the gearing will conquer hilly roads.
AdventureWorks
2002
HTTP://www.Adventure-works.com
1 year
parts and labor
5 years
maintenance contact available through dealer
Aluminum alloy rim with stainless steel spokes; built for speed on our high quality rubber tires.
Comfortable saddle with bump absorping rubber bumpers.
Top-of-the-line clipless pedals with adjustable tension.
aluminum alloy frame
and features a lightweight down-tube milled to the perfect diameter for optimal strength.
NULL
front
small
111
Aluminum Alloy
Available in all colors.
Road bike
Unisex
Novice to Advanced riders
8456BB94-B4DD-4A47-A76B-D0E54AB4285D
34
Touring-1000
Travel in style and comfort. Designed for maximum comfort and safety.
Wide gear range takes on all hills. High-tech aluminum alloy construction provides durability without added weight.
AdventureWorks
2002
HTTP://www.Adventure-works.com
1 year
parts and labor
5 years
maintenance contact available through dealer
Excellent aerodynamic rims guarantee a smooth ride.
Cut-out shell for a more comfortable ride.
A stable pedal for all-day riding.
aluminum alloy frame
and features a lightweight down-tube milled to the perfect diameter for optimal strength.
NULL
front
small
87
Aluminum alloy
Available in most colors.
Touring bike
Unisex
Novice to Advanced riders
52E7F2C1-DBFF-4518-927D-C7D46F9ED32E
35
Touring-2000
The plush custom saddle keeps you riding all day, and there's plenty of space
to add panniers and bike bags to the newly-redesigned carrier.
This bike has great stability when fully-loaded.
AdventureWorks
2002
HTTP://www.Adventure-works.com
1 year
parts and labor
5 years
maintenance contact available through dealer
NULL
New design relieves pressure for long rides.
Top-of-the-line clipless pedals with adjustable tension.
The aluminum frame is custom-shaped for both good looks and strength;
it will withstand the most rigorous challenges of daily riding.
High-strength crank arm.
front
small
87
Aluminum
Available in all colors except metallic.
Touring bike
Men's
Intermediate to Advanced riders
AA10D9E6-E33F-4DA8-ACE1-992FCD6BB171