Broadleaf Microservices
  • v1.0.0-latest-prod

Rating And Review Services Data Model

Data Diagram

The following data shows the key tables used by the Rating and Review Services

Rating Data Model

Rating Summary

BLC_RATING_SUMMARY

Field Description

ID

The ID of this rating summary

PARENT_SUMMARY_ID

If this is a variant, this points to the RatingSummary for the parent product

RATING_TARGET_TYPE

The rating target type, such as PRODUCT or VARIANT. See RatingTargetType.

RATING_TARGET_ID

The id of the rating target. For example the product or variant ID.

PARENT_TARGET_ID

If the target type is a Variant, this would be the parent product’s ID

NO_OF_RATINGS

The total number of ratings for this target. This includes both approved and pending ratings.

NO_OF_APPRVD_RATINGS

The total number of approved ratings for this target.

RATING_TOTAL

The total numerical value of all approved ratings for this summary.

ATTRIBUTES

Map to capture any additional data

Rating Detail

BLC_RATING_DETAIL

Field Description

ID

The ID of this RatingDetail.

RATING

The numerical rating.

CUSTOMER_ID

The database ID of the user who authored this rating.

CUSTOMER_NAME

The name of the customer that created the rating.

INITIAL_REVIEW_DATE

The initial rating date.

EDITED_DATE

If edited, the date this review was edited.

REVIEW_TITLE

The title of this review.

ORIGINAL_REVIEW

The original review. This is what is displayed on the review page.

EDITED_REVIEW

If edited, the text of the edited review.

REVIEW_STATUS

The status of this review, e.g. APPROVED, REJECTED. See RatingDetailStatus.

APPRV_RJCT_USER

The admin who approved or rejected this rating.

APPRV_RJCT_DATE

The date that this review was approved or rejected.

RATING_SUMMARY_ID

Soft reference to the rating summary for the reviewed item.

REJECT_REASON

The reason for review rejection.

VERIFIED_PRCHSE

Indicates if this review is from a verified purchase.

ATTRIBUTES

Map to capture any additional data.