Production.ProductProductPhoto - AdventureWorks

AdventureWorks

- AdventureWorks

Documentation	AdventureWorks
Schema	Production
Name	ProductProductPhoto
Module	Products

Cross-reference table mapping products and product photos.

Columns

		Key	Name	Data type	Null	Attributes	References	Description
	1		ProductID	int			Production.Product	Product identification number. Foreign key to Product.ProductID.
Product identification number. Foreign key to Product.ProductID. References: Production.Product
	2		ProductPhotoID	int			Production.ProductPhoto	Product photo identification number. Foreign key to ProductPhoto.ProductPhotoID.
Product photo identification number. Foreign key to ProductPhoto.ProductPhotoID. References: Production.ProductPhoto
	3		Primary	bit		Default: 0		0 = Photo is not the principal image. 1 = Photo is the principal image.
0 = Photo is not the principal image. 1 = Photo is the principal image. Default: 0
	4		ModifiedDate	datetime		Default: getdate()		Date and time the record was last updated.
Date and time the record was last updated. Default: getdate()

Relations

Foreign table		Primary table	Join	Title / Name / Description
Production.ProductProductPhoto		Production.Product	Production.ProductProductPhoto.ProductID = Production.Product.ProductID	FK_ProductProductPhoto_Product_ProductID Foreign key constraint referencing Product.ProductID.
Production.ProductProductPhoto.ProductID = Production.Product.ProductID Name: FK_ProductProductPhoto_Product_ProductID Foreign key constraint referencing Product.ProductID.
Production.ProductProductPhoto		Production.ProductPhoto	Production.ProductProductPhoto.ProductPhotoID = Production.ProductPhoto.ProductPhotoID	FK_ProductProductPhoto_ProductPhoto_ProductPhotoID Foreign key constraint referencing ProductPhoto.ProductPhotoID.
Production.ProductProductPhoto.ProductPhotoID = Production.ProductPhoto.ProductPhotoID Name: FK_ProductProductPhoto_ProductPhoto_ProductPhotoID Foreign key constraint referencing ProductPhoto.ProductPhotoID.

Unique keys

	Key name	Columns	Description
	PK_ProductProductPhoto_ProductID_ProductPhotoID	ProductID, ProductPhotoID	Primary key (clustered) constraint
Primary key (clustered) constraint

Uses

Name
Production.ProductProductPhoto
Production.Product
Production.ProductPhoto

Exported: 2019-02-04 23:13, Last imported: 2018-03-07 11:56