Production.ProductProductPhoto

Table: 'Production.ProductProductPhoto'

4 fields. 25 bytes.

Cross-reference table mapping products and product photos.

Field Name Data Type Size Original Type Default Nullable Description Check

ProductID int Not null Product identification number. Foreign key to Product.ProductID.

ProductPhotoID int Not null Product photo identification number. Foreign key to ProductPhoto.ProductPhotoID.

Primary Flag bit (0) Not null 0 = Photo is not the principal image. 1 = Photo is the principal image.

ModifiedDate datetime getdate() Not null Date and time the record was last updated.

Field Name	Data Type	Original Type	Default	Nullable	Description
ProductID	int			Not null	Product identification number. Foreign key to Product.ProductID.
ProductPhotoID	int			Not null	Product photo identification number. Foreign key to ProductPhoto.ProductPhotoID.
Primary	Flag	bit	(0)	Not null	0 = Photo is not the principal image. 1 = Photo is the principal image.
ModifiedDate	datetime		getdate()	Not null	Date and time the record was last updated.

Extended Properties

The object has no extended properties.

Primary key for table 'Production.ProductProductPhoto'

Primary Key Name Field Names

PK_ProductProductPhoto_ProductID_ProductPhotoID ProductID, ProductPhotoID

Primary Key Name	Field Names
PK_ProductProductPhoto_ProductID_ProductPhotoID	ProductID, ProductPhotoID

Foreign keys for table 'Production.ProductProductPhoto', 2 items

Foreign Primary Key Name

ProductProductPhoto.ProductID Product.ProductID FK_ProductProductPhoto_Product_ProductID

ProductProductPhoto.ProductPhotoID ProductPhoto.ProductPhotoID FK_ProductProductPhoto_ProductPhoto_ProductPhotoID

Foreign	Primary	Key Name
ProductProductPhoto.ProductID	Product.ProductID	FK_ProductProductPhoto_Product_ProductID
ProductProductPhoto.ProductPhotoID	ProductPhoto.ProductPhotoID	FK_ProductProductPhoto_ProductPhoto_ProductPhotoID

Indexes for table 'Production.ProductProductPhoto', 1 item

Index Name Description Clustered Unique Fields

PK_ProductProductPhoto_ProductID_ProductPhotoID Nonclustered index created by a primary key constraint. No Yes ProductID, ProductPhotoID

Index Name	Description	Clustered	Unique	Fields
PK_ProductProductPhoto_ProductID_ProductPhotoID	Nonclustered index created by a primary key constraint.	No	Yes	ProductID, ProductPhotoID

Triggers for table 'Production.ProductProductPhoto', 1 item

Name Description Type Enabled

uProductProductPhoto AFTER UPDATE trigger setting the ModifiedDate column in the ProductProductPhoto table to the current date. after Update Yes

Name	Description	Type	Enabled
uProductProductPhoto	AFTER UPDATE trigger setting the ModifiedDate column in the ProductProductPhoto table to the current date.	after Update	Yes

Dependencies for table 'Production.ProductProductPhoto', 1 item

Object Name Type Field Name

Production.uProductProductPhoto trigger N/A