Production.ProductProductPhoto

Columns

• //

  ${escapify(column.description)}
  ProductID
  [int] NOT NULL
• //

  ${escapify(column.description)}
  ProductPhotoID
  [int] NOT NULL
• //

  ${escapify(column.description)}
  Primary
  [Flag] NOT NULL DEFAULT ((0))

  //

  USER-DEFINED DATA TYPE

  [bit] NOT NULL
• //

  ${escapify(column.description)}
  ModifiedDate
  [datetime] NOT NULL DEFAULT (getdate())

Indexes

• //

  Nonclustered index created by a primary key constraint.
  PK_ProductProductPhoto_ProductID_ProductPhotoID
  UNIQUE NONCLUSTERED
  ProductID , ProductPhotoID

Foreign Keys

• //

  Foreign key constraint referencing Product.ProductID.
  FK_ProductProductPhoto_Product_ProductID
  Production.Product
  ProductID ⥱ ProductID
• //

  Foreign key constraint referencing ProductPhoto.ProductPhotoID.
  FK_ProductProductPhoto_ProductPhoto_ProductPhotoID
  Production.ProductPhoto
  ProductPhotoID ⥱ ProductPhotoID

Sample Data