Production ProductProductPhoto (table)

wikibot

TableProduction.ProductProductPhoto
DescriptionCross-reference table mapping products and product photos.

Columns

ColumnData TypeNullableDefaultDescription
ProductIDintnot null Product identification number. Foreign key to Product.ProductID.
ProductPhotoIDintnot null Product photo identification number. Foreign key to ProductPhoto.ProductPhotoID.
Primarydbo.Flagnot null((0))0 = Photo is not the principal image. 1 = Photo is the principal image.
ModifiedDatedatetimenot null(getdate())Date and time the record was last updated.

Primary Key

Primary KeyColumns
PK_ProductProductPhoto_ProductID_ProductPhotoIDProductID, ProductPhotoID

Foreign Keys

RelationColumnReferenced Column
Production.ProductProductIDProductID
Production.ProductPhotoProductPhotoIDProductPhotoID

References

Dependency TypeObject TypeReferenced Object
Data TypeTypedbo.Flag
SchemaSchemaProduction