ScrewTurn Wiki

Edit

wikibot

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

Edit

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.

Edit

Primary Key

Primary KeyColumns
PK_ProductProductPhoto_ProductID_ProductPhotoIDProductID, ProductPhotoID

Edit

Foreign Keys

RelationColumnReferenced Column
Production.ProductProductIDProductID
Production.ProductPhotoProductPhotoIDProductPhotoID

Edit

References

Dependency TypeObject TypeReferenced Object
Data TypeTypedbo.Flag
SchemaSchemaProduction

Edit

automatically generated

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

ColumnData TypeNullableDefaultDescription / PK / Index
ProductIDintnot null Product identification number. Foreign key to Product.ProductID.
PK_ProductProductPhoto_ProductID_ProductPhotoID
ProductPhotoIDintnot null Product photo identification number. Foreign key to ProductPhoto.ProductPhotoID.
PK_ProductProductPhoto_ProductID_ProductPhotoID
PrimaryFlagnot 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.



RelationColumnReferenced Column
Production.ProductProductIDProductID
Production.ProductPhotoProductPhotoIDProductPhotoID

Dependency TypeObject TypeReferenced Object
Data TypeTypedbo.Flag
SchemaSchemaProduction

ScrewTurn Wiki version 2.0.36. Some of the icons created by FamFamFam.