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

swReviews Table

The swReviews table stores the information for the individual review.  There will be one entry per review.

 
 
Column Name
Description
Datatype
Length
Allow Nulls
Primary key
uid
A unique identifier assigned to each record in the table.
int
4
No
 
CustomerID
uid of Customers table for user who wrote the review.
int
4
Yes
 
ProductID
uid of the product the review is about.
int
4
Yes
 
DateSubmitted
Date the review written or last modified.
nvarchar
50
Yes
 
Rating
Rating of the review.
tinyint
1
Yes
 
Title
The title of the review.
nvarchar
100
Yes
 
RecFriend
Whether or not the reviewer recommends the product to friends.
bit
1
Yes
 
Review
The text of the review.
ntext
1073741823
Yes
 
NickName
The users nickname.
nvarchar
50
Yes
 
Location
The users location.
nvarchar
50
Yes
 
AveHelpful
The average review helpful score.
decimal
5,2
Yes
 
PositiveHelpful
The total number of positive helpful entries.
int
4
Yes
 
TotalHelpful
The total number of helpful entries.
int
4
Yes
 
Status
The status of the review. 0=not approved   1=approved
tinyint
1
Yes
 
Featured
Whether or not the review is featured.  0=No  1=Yes
bit
1
Yes
 
ReviewLength
The total number of characters of the review.
int
4
Yes



 See Also: swReviewHelpful, swProductReviewInfo, swReviewEMailLog


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