Generated using SQL Data Dictionary demo version.


Table Production.ProductProductPhoto (504 rows)


Cross-reference table mapping products and product photos.


  Column Data Type Identity Nullable Default
PK, FK ProductID int
Product identification number. Foreign key to Product.ProductID.
PK, FK ProductPhotoID int
Product photo identification number. Foreign key to ProductPhoto.ProductPhotoID.
Primary Flag(bit) 0
0 = Photo is not the principal image. 1 = Photo is the principal image.
ModifiedDate datetime getdate()
Date and time the record was last updated.

Indexes:


References: