← All tables and views
AdventureWorks OLTP table
Production.ProductProductPhoto
Cross-reference table mapping products and product photos.
504rows
4 columns
Schema from the provider contract| Column | Type | Nullable | Key | References |
|---|---|---|---|---|
ProductID | INTEGER | no | PK 1/2 | Production.Product.ProductID |
ProductPhotoID | INTEGER | no | PK 2/2 | Production.ProductPhoto.ProductPhotoID |
Primary | INTEGER | no | — | — |
ModifiedDate | TEXT | no | — | — |
Keys and unique indexes
Physical SQLite metadataPrimary key is declared above.
No additional full-column unique key was found.
1 unique index inspected
sqlite_autoindex_Production.ProductProductPhoto_1ProductID + ProductPhotoIDData preview
Sample records
| ProductID | ProductPhotoID | Primary | ModifiedDate |
|---|---|---|---|
| 1 | 1 | 1 | 2019-03-31 00:00:00.000 |
| 2 | 1 | 1 | 2019-03-31 00:00:00.000 |
| 3 | 1 | 1 | 2019-03-31 00:00:00.000 |
| 4 | 1 | 1 | 2019-03-31 00:00:00.000 |
| 316 | 1 | 1 | 2019-03-31 00:00:00.000 |
| 317 | 1 | 1 | 2019-03-31 00:00:00.000 |
| 318 | 1 | 1 | 2019-03-31 00:00:00.000 |
| 319 | 1 | 1 | 2019-03-31 00:00:00.000 |
Interactive explorer