Production.ProductPhoto - AdventureWorks

AdventureWorks

- AdventureWorks

Documentation	AdventureWorks
Schema	Production
Name	ProductPhoto
Module	Products

Product images.

Columns

		Key	Name	Data type	Null	Attributes	References	Description
	1		ProductPhotoID	int		Identity		Primary key for ProductPhoto records.
Primary key for ProductPhoto records. Identity
	2		ThumbNailPhoto	varbinary(MAX)				Small image of the product.
Small image of the product.
	3		ThumbnailPhotoFileName	nvarchar(50)				Small image file name.
Small image file name.
	4		LargePhoto	varbinary(MAX)				Large image of the product.
Large image of the product.
	5		LargePhotoFileName	nvarchar(50)				Large image file name.
Large image file name.
	6		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.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_ProductPhoto_ProductPhotoID	ProductPhotoID	Primary key (clustered) constraint
Primary key (clustered) constraint

Used by

Name
Production.ProductPhoto
Production.ProductProductPhoto

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