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 | 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.
|