Customer Reviews Add-on by Stokes Web Development
swProductReviewInfo Table
 Previous Top Next

swProductReviewInfo Table

The swProductReviewInfo table stores the average review data for each product.  There will be one entry for each product that has at least one review.

  
 
Column Name
Description
Datatype
Length
Allow Nulls
Primary key
uid
A unique identifier assigned to each record in the table.
int
4
No
 
ProductID
uid of the product.
int
4
Yes
 
AveRating
Average rating for that product.
decimal
2,1
Yes
 
TotalRatings
Total number of reviews for that product.
int
4
Yes
 
Star1Count
Total number of 1 Star ratings.
int
4
Yes
 
Star1Percent
Percentage of ratings that are 1 Star.
tinyint
1
Yes
 
Star2Count
Total number of 2 Star ratings.
int
4
Yes
 
Star2Percent
Percentage of ratings that are 2 Star.
tinyint
1
Yes
 
Star3Count
Total number of 3 Star ratings.
int
4
Yes
 
Star3Percent
Percentage of ratings that are 3 Star.
tinyint
1
Yes
 
Star4Count
Total number of 4 Star ratings.
int
4
Yes
 
Star4Percent
Percentage of ratings that are 4 Star.
tinyint
1
Yes
 
Star5Count
Total number of 5 Star ratings.
int
4
Yes
 
Star5Percent
Percentage of ratings that are 5 Star.
tinyint
1
Yes
 
RecFriendPercent
Percentage of users that recommend this product to friends.
tinyint
1
Yes



 See Also: swReviews, swReviewHelpful, swReviewEMailLog


Copyright © 2008 by Stokes Web Development.  All Rights Reserved.