AdventureWorks
| Table Name: | Production.ProductProductPhoto |
| Description: | Cross-reference table mapping products and product photos. |
| Primary Keys: | ProductID ProductPhotoID |
| Field | Type | Defaults | Nulls? | Comments |
|---|---|---|---|---|
| ProductID | int | None | No | Product identification number. Foreign key to Product.ProductID. |
| ProductPhotoID | int | None | No | Product photo identification number. Foreign key to ProductPhoto.ProductPhotoID. |
| Primary | bit | ((0)) | No | 0 = Photo is not the principal image. 1 = Photo is the principal image. |
| ModifiedDate | datetime | (getdate()) | No | Date and time the record was last updated. |
| Index | Clustered? | Unique? | Fields |
|---|---|---|---|
| PK_ProductProductPhoto_ProductID_ProductPhotoID | No | Yes | ProductID ProductPhotoID |
| Internal Foreign Key Constraint | Affected Field | Source Table |
|---|---|---|
| FK_ProductProductPhoto_Product_ProductID | ProductID | Production.Product |
| FK_ProductProductPhoto_ProductPhoto_ProductPhotoID | ProductPhotoID | Production.ProductPhoto |