| Field Name | Type and Size |
|---|---|
| ProductModelID | int identity 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 |