AdventureWorks
| Table Name: | Production.ProductPhoto |
| Description: | Product images. |
| Primary Keys: | ProductPhotoID |
| Field | Type | Defaults | Nulls? | Comments |
|---|---|---|---|---|
| ProductPhotoID | int - Identity | None | No | Primary key for ProductPhoto records. |
| ThumbNailPhoto | varbinary (MAX) | None | Yes | Small image of the product. |
| ThumbnailPhotoFileName | nvarchar (50) | None | Yes | Small image file name. |
| LargePhoto | varbinary (MAX) | None | Yes | Large image of the product. |
| LargePhotoFileName | nvarchar (50) | None | Yes | Large image file name. |
| ModifiedDate | datetime | (getdate()) | No | Date and time the record was last updated. |
| Index | Clustered? | Unique? | Fields |
|---|---|---|---|
| PK_ProductPhoto_ProductPhotoID | Yes | Yes | ProductPhotoID |
| Primary Key as Foreign Key Constraint | Affected Table | Affected Field |
|---|---|---|
| FK_ProductProductPhoto_ProductPhoto_ProductPhotoID | Production.ProductProductPhoto | ProductPhotoID |