Production.ProductProductPhoto (table)

wikibot

Table

Production.ProductProductPhoto

Column	Data Type	Nullable	Default	PK	Index
ProductID	int	not null		PK_ProductProductPhoto_ProductID_ProductPhotoID
ProductPhotoID	int	not null		PK_ProductProductPhoto_ProductID_ProductPhotoID
Primary	dbo.Flag	not null	((0))
ModifiedDate	datetime	not null	(getdate())

Relation	Column	Referenced Column
Production.Product	ProductID	ProductID
Production.ProductPhoto	ProductPhotoID	ProductPhotoID

automatically generated

Table	Production.ProductProductPhoto
Description	Cross-reference table mapping products and product photos.

Column	Data Type	Nullable	Default	Description	PK / Index
ProductID	int	not null		Product identification number. Foreign key to Product.ProductID.	PK_ProductProductPhoto_ProductID_ProductPhotoID
ProductPhotoID	int	not null		Product photo identification number. Foreign key to ProductPhoto.ProductPhotoID.	PK_ProductProductPhoto_ProductID_ProductPhotoID
Primary	Flag	not null	(0)	0 = Photo is not the principal image. 1 = Photo is the principal image.
ModifiedDate	datetime	not null	(GETDATE())	Date and time the record was last updated.

Relation	Column	Referenced Column
Production.Product	ProductID	ProductID
Production.ProductPhoto	ProductPhotoID	ProductPhotoID