.png)
ProductProductPhoto Table (AdventureWorks)
SQL Server 2005
Is a cross-reference table that maps products and product photos.
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. |
Reference
Product Table (AdventureWorks)ProductPhoto Table (AdventureWorks)
