| Column | Data Type | Nullable | Default | Description / PK / Index |
| ProductID | int | not null | | Product identification number. Foreign key to Product.ProductID.
PK_ProductProductPhoto_ProductID_ProductPhotoID |
| ProductPhotoID | int | not null | | Product photo identification number. Foreign key to ProductPhoto.ProductPhotoID.
PK_ProductProductPhoto_ProductID_ProductPhotoID |
| Primary | dbo.Flag | not null | ((0)) | 0 = Photo is not the principal image. 1 = Photo is the principal image.
|
| ModifiedDate | datetime | not null | (getdate()) | Date and time the record was last updated.
|