Contains the article rating information by user
Data model
Fields
| Field | Type | Description |
|---|---|---|
| fl_date_rating_created* | DATETIME | Grade creation date |
| fl_int_rating* | INT | Value of the article’s rating by the user, values allowed 1 to 5 with 5 being the highest rating |
| fl_str_rating_comment | NVARCHAR (510) | User feedback comment for the article |
| version* | INT | Version of the article to which the rating belongs |
Primary Key
| PK_ASS_RATING |
|---|
| fl_int_solution_id, fl_int_user_id, version |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| fl_int_solution_id* | dbo.ASS_ARTICLE_DW_LAST | id | FK01_ASS_RATING |