ProductProductPhoto Table (AdventureWorks)
Is a cross-reference table that maps products and product photos.
ProductProductPhoto Table Definition
The ProductProductPhoto is contained in the Production schema.
| Column | Data type | Nullability | Description |
|---|---|---|---|
ProductID |
int |
Not null |
Product identification number. Foreign key to Product.ProductID. |
ProductPhotoID |
int |
Not null |
Product photo identification number. Foreign key to ProductPhoto.ProductPhotoID. |
Primary |
Flag (user-defined type) bit |
Not null |
0 = Photo is not the principal image. 1 = Photo is the principal image. |
ModifiedDate |
datetime |
Not null |
Date and time the row was last updated. |
See Also
Reference
Product Table (AdventureWorks)
ProductPhoto Table (AdventureWorks)
Other Resources
AdventureWorks Data Dictionary