Production.ProductReview Table

Information

Name	ProductReview
Schema	Production
Row Count	0
Data Size
Index Size
Reserved Size
Unused Size
Created	29.3.2010. 21:58:18
Modified	29.3.2010. 21:58:54

Extended Properties

Name	Type	Property Name	Value
ProductReview	TABLE	MS_Description	Customer reviews of products they have purchased.

Columns

Name	Data Type	Collation	References	Default
ProductReviewID	int
ProductID	int		Production.Product.ProductID
ReviewerName	nvarchar(50)	SQL_Latin1_General_CP1_CI_AS
ReviewDate	datetime			(getdate())
EmailAddress	nvarchar(50)	SQL_Latin1_General_CP1_CI_AS
Rating	int
Comments	nvarchar(3850)	SQL_Latin1_General_CP1_CI_AS
ModifiedDate	datetime			(getdate())

Indexes

Name	Type	Primary	Unique	Columns
PK_ProductReview_ProductReviewID	Clustered			ProductReviewID
IX_ProductReview_ProductID_Name	NonClustered			ProductID, ReviewerName

Check Constraints

Name	Column	Enabled	Trusted	Expression
CK_ProductReview_Rating	Rating			([Rating]>=(1) AND [Rating]<=(5))

Foreign Key Constraints

Name	Type	Referenced Table
FK_ProductReview_Product_ProductID	Foreign key	Production.Product

SQL Script

CREATE TABLE [Production].[ProductReview] (
    [ProductReviewID] int NOT NULL IDENTITY,
    [ProductID] int NOT NULL,
    [ReviewerName] nvarchar(50) NOT NULL,
    [ReviewDate] datetime NOT NULL DEFAULT (getdate()),
    [EmailAddress] nvarchar(50) NOT NULL,
    [Rating] int NOT NULL,
    [Comments] nvarchar(3850) NULL,
    [ModifiedDate] datetime NOT NULL DEFAULT (getdate())
);
CREATE INDEX [IX_ProductReview_ProductID_Name] on [Production].[ProductReview]([ProductID], [ReviewerName]);