Production.ProductProductPhoto Table

Information

Name	ProductProductPhoto
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
ProductProductPhoto	TABLE	MS_Description	Cross-reference table mapping products and product photos.

Columns

Name	Data Type	References	Default
ProductID	int	Production.Product.ProductID
ProductPhotoID	int	Production.ProductPhoto.ProductPhotoID
Primary	bit		((0))
ModifiedDate	datetime		(getdate())

Indexes

Name	Type	Primary	Unique	Columns
PK_ProductProductPhoto_ProductID_ProductPhotoID	NonClustered			ProductID, ProductPhotoID

Foreign Key Constraints

Name	Type	Referenced Table
FK_ProductProductPhoto_Product_ProductID	Foreign key	Production.Product
FK_ProductProductPhoto_ProductPhoto_ProductPhotoID	Foreign key	Production.ProductPhoto

SQL Script

CREATE TABLE [Production].[ProductProductPhoto] (
    [ProductID] int NOT NULL,
    [ProductPhotoID] int NOT NULL,
    [Primary] bit NOT NULL DEFAULT ((0)),
    [ModifiedDate] datetime NOT NULL DEFAULT (getdate())
);