Product Spotlight Database Object
To implement the MyGolfGear.NET product spotlight feature, we added three new database objects. Specifically, we added a new table called FeaturedItems. Additionally, we added the two new stored procedures spInsertFeaturedItem and spGetFeaturedItems.
The FeaturedItems Table
The new MyGolfGear table named FeaturedItems was added. This simple table has only four columns: FeatureID, ProductID, StartDate, and EndDate. Table 7.1 describes the fields and types used in this table.
Some sites rotate their spotlight features based on page views. We chose to rotate the MyGolfGear.NET product spotlights based on the date.
|Field Name||Data Type||Description|
|FeatureID||int||An identity ...|