Editing Production.ProductReview (table)
Warning: You are not logged in. Your IP address will be publicly visible if you make any edits. If you log in or create an account, your edits will be attributed to your username, along with other benefits.
The edit can be undone.
Please check the comparison below to verify that this is what you want to do, and then save the changes below to finish undoing the edit.
Latest revision | Your text | ||
Line 164: | Line 164: | ||
| not null | | not null | ||
| | | | ||
− | | Primary key for ProductReview records. | + | | Primary key for ProductReview records.PK_ProductReview_ProductReviewID |
|- valign="top" | |- valign="top" | ||
| ProductID | | ProductID | ||
Line 170: | Line 170: | ||
| not null | | not null | ||
| | | | ||
− | | Product identification number. Foreign key to Product.ProductID. | + | | Product identification number. Foreign key to Product.ProductID.IX_ProductReview_ProductID_Name |
|- valign="top" | |- valign="top" | ||
| ReviewerName | | ReviewerName | ||
Line 176: | Line 176: | ||
| not null | | not null | ||
| | | | ||
− | | Name of the reviewer. | + | | Name of the reviewer.IX_ProductReview_ProductID_Name |
|- valign="top" | |- valign="top" | ||
| ReviewDate | | ReviewDate | ||
Line 182: | Line 182: | ||
| not null | | not null | ||
| (GETDATE()) | | (GETDATE()) | ||
− | | Date review was submitted. | + | | Date review was submitted. |
|- valign="top" | |- valign="top" | ||
| EmailAddress | | EmailAddress | ||
Line 188: | Line 188: | ||
| not null | | not null | ||
| | | | ||
− | | Reviewer's e-mail address. | + | | Reviewer's e-mail address. |
|- valign="top" | |- valign="top" | ||
| Rating | | Rating | ||
Line 194: | Line 194: | ||
| not null | | not null | ||
| | | | ||
− | | Product rating given by the reviewer. Scale is 1 to 5 with 5 as the highest rating. | + | | Product rating given by the reviewer. Scale is 1 to 5 with 5 as the highest rating. |
|- valign="top" | |- valign="top" | ||
| Comments | | Comments | ||
Line 200: | Line 200: | ||
| not null | | not null | ||
| | | | ||
− | | Reviewer's | + | | Reviewer's commentsIX_ProductReview_ProductID_Name |
|- valign="top" | |- valign="top" | ||
| ModifiedDate | | ModifiedDate | ||
Line 206: | Line 206: | ||
| not null | | not null | ||
| (GETDATE()) | | (GETDATE()) | ||
− | | Date and time the record was last updated. | + | | Date and time the record was last updated. |
|} | |} | ||