# Table: ProductProductPhoto

## Properties

Property | Value
--- | ---
Name | ProductProductPhoto
ID | 306100131
Owner | dbo
Schema | Production
Filegroup | PRIMARY
Data Size (KB) | 16 KB
Index Size (KB) | 40 KB
Rows | 504
Unused (KB) | 48 KB
ANSI Null On |
Quoted Identifier |
Lock Escalation | TABLE
Lock On Bulk Load |
Lob Data Space |
Filestream Data Space ID |
Has Unchecked Assembly Data |
Text In Row Limit (bytes) | Option not set
Large Value Types Out Of Row |
FullText Change Tracking On |
Tracked By Cdc |
Published |
Schema Published |
Replicated |
Replication Filter |
Merge Published |
Sync Tran Subscribed |
MS Shipped |
Modify Date | 8/8/2010 5:23:40 PM
Create Date | 8/8/2010 5:21:51 PM

## Extended Properties

Name | Value
--- | ---
MS_Description | Cross-reference table mapping products and product photos.

## Columns

Column ID | Column Name | Datatype | Nullable | Is Sparse | Is Column Set
--- | --- | --- | --- | --- | ---
1 | ProductID | int |  |  |
2 | ProductPhotoID | int |  |  |
3 | Primary | Flag |  |  |
4 | ModifiedDate | datetime |  |  |

## Identity Columns

No identity columns defined.

## Primary Key Constraints

Name | Is System Named | Extended Property Name | Extended Property Value
--- | --- | --- | ---
PK_ProductProductPhoto_ProductID_ProductPhotoID |  | MS_Description | Primary key (clustered) constraint

## Primary Key Columns

Name
ProductID
ProductPhotoID

## Foreign Keys

Name | Referenced Object | Update Action | Delete Action
--- | --- | --- | ---
FK_ProductProductPhoto_Product_ProductID | Production.Product | No action | No action
FK_ProductProductPhoto_ProductPhoto_ProductPhotoID | Production.ProductPhoto | No action | No action

## Column Level Check Constraints

No column constraints defined.

## Table Level Check Constraints

No table constraints defined.

## Default Constraints

Name | Column | Definition | Is System Named | Extended Property Name | Extended Property Value
--- | --- | --- | --- | --- | ---
DF_ProductProductPhoto_Primary | Primary | ((0)) |  | MS_Description | Default constraint value of 0 (FALSE)
DF_ProductProductPhoto_ModifiedDate | ModifiedDate | (getdate()) |  | MS_Description | Default constraint value of GETDATE()

## Indexes

Name | Index Type | Primary Key | Unique | Unique Constraint | Ignore Duplicate Key | Disabled
--- | --- | --- | --- | --- | --- | ---
PK_ProductProductPhoto_ProductID_ProductPhotoID | NONCLUSTERED |  |  |  |  |

## FullText Indexes

No fulltext indexes defined.

## Referencing Tables

No referencing tables defined.

## Object Level Permissions

No object level permissions defined.

## Column Level Permissions

No explicit column permissions granted to this object

## Statistics

### Detailed Statistics General

Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows
--- | --- | --- | --- | --- | --- | --- | --- | --- | ---
PK_ProductProductPhoto_ProductID_ProductPhotoID | Aug 8 2010 5:22PM | 504 | 504 | 200 | 1 | 8 |  |  | 504

### Detailed Statistics Density

All Density | Average Length | Columns
--- | --- | ---
0.001984127 | 4 | ProductID
0.001984127 | 8 | ProductID, ProductPhotoID

### Detailed Statistics Histogram

Range High Key | Range Rows | Estimated Rows | Distinct Range Rows | Avg Range Rows
--- | --- | --- | --- | ---
1 | 0 | 1 | 0 | 1
4 | 2 | 1 | 2 | 1
317 | 1 | 1 | 1 | 1
319 | 1 | 1 | 1 | 1
321 | 1 | 1 | 1 | 1
323 | 1 | 1 | 1 | 1
325 | 1 | 1 | 1 | 1
327 | 1 | 1 | 1 | 1
331 | 3 | 1 | 3 | 1
341 | 1 | 1 | 1 | 1
343 | 1 | 1 | 1 | 1
345 | 1 | 1 | 1 | 1
347 | 1 | 1 | 1 | 1
349 | 1 | 1 | 1 | 1
351 | 1 | 1 | 1 | 1
357 | 3 | 1 | 3 | 1
361 | 3 | 1 | 3 | 1
363 | 1 | 1 | 1 | 1
365 | 1 | 1 | 1 | 1
367 | 1 | 1 | 1 | 1
369 | 1 | 1 | 1 | 1
371 | 1 | 1 | 1 | 1
373 | 1 | 1 | 1 | 1
375 | 1 | 1 | 1 | 1
377 | 1 | 1 | 1 | 1
379 | 1 | 1 | 1 | 1
381 | 1 | 1 | 1 | 1
383 | 1 | 1 | 1 | 1
385 | 1 | 1 | 1 | 1
389 | 3 | 1 | 3 | 1
393 | 3 | 1 | 3 | 1
397 | 3 | 1 | 3 | 1
399 | 1 | 1 | 1 | 1
401 | 1 | 1 | 1 | 1
403 | 1 | 1 | 1 | 1
405 | 1 | 1 | 1 | 1
407 | 1 | 1 | 1 | 1
409 | 1 | 1 | 1 | 1
411 | 1 | 1 | 1 | 1
413 | 1 | 1 | 1 | 1
415 | 1 | 1 | 1 | 1
417 | 1 | 1 | 1 | 1
419 | 1 | 1 | 1 | 1
421 | 1 | 1 | 1 | 1
423 | 1 | 1 | 1 | 1
425 | 1 | 1 | 1 | 1
427 | 1 | 1 | 1 | 1
429 | 1 | 1 | 1 | 1
431 | 1 | 1 | 1 | 1
433 | 1 | 1 | 1 | 1
435 | 1 | 1 | 1 | 1
437 | 1 | 1 | 1 | 1
439 | 1 | 1 | 1 | 1
441 | 1 | 1 | 1 | 1
443 | 1 | 1 | 1 | 1
445 | 1 | 1 | 1 | 1
449 | 3 | 1 | 3 | 1
453 | 3 | 1 | 3 | 1
457 | 3 | 1 | 3 | 1
461 | 3 | 1 | 3 | 1
465 | 3 | 1 | 3 | 1
467 | 1 | 1 | 1 | 1
469 | 1 | 1 | 1 | 1
473 | 3 | 1 | 3 | 1
475 | 1 | 1 | 1 | 1
479 | 3 | 1 | 3 | 1
481 | 1 | 1 | 1 | 1
483 | 1 | 1 | 1 | 1
485 | 1 | 1 | 1 | 1
487 | 1 | 1 | 1 | 1
489 | 1 | 1 | 1 | 1
491 | 1 | 1 | 1 | 1
493 | 1 | 1 | 1 | 1
495 | 1 | 1 | 1 | 1
497 | 1 | 1 | 1 | 1
505 | 1 | 1 | 1 | 1
507 | 1 | 1 | 1 | 1
509 | 1 | 1 | 1 | 1
511 | 1 | 1 | 1 | 1
513 | 1 | 1 | 1 | 1
515 | 1 | 1 | 1 | 1
519 | 3 | 1 | 3 | 1
521 | 1 | 1 | 1 | 1
523 | 1 | 1 | 1 | 1
525 | 1 | 1 | 1 | 1
529 | 3 | 1 | 3 | 1
533 | 3 | 1 | 3 | 1
680 | 3 | 1 | 3 | 1
707 | 1 | 1 | 1 | 1
709 | 1 | 1 | 1 | 1
713 | 3 | 1 | 3 | 1
717 | 3 | 1 | 3 | 1
721 | 3 | 1 | 3 | 1
725 | 3 | 1 | 3 | 1
729 | 3 | 1 | 3 | 1
731 | 1 | 1 | 1 | 1
733 | 1 | 1 | 1 | 1
737 | 3 | 1 | 3 | 1
739 | 1 | 1 | 1 | 1
743 | 3 | 1 | 3 | 1
745 | 1 | 1 | 1 | 1
747 | 1 | 1 | 1 | 1
749 | 1 | 1 | 1 | 1
751 | 1 | 1 | 1 | 1
753 | 1 | 1 | 1 | 1
755 | 1 | 1 | 1 | 1
759 | 3 | 1 | 3 | 1
761 | 1 | 1 | 1 | 1
763 | 1 | 1 | 1 | 1
765 | 1 | 1 | 1 | 1
767 | 1 | 1 | 1 | 1
769 | 1 | 1 | 1 | 1
771 | 1 | 1 | 1 | 1
773 | 1 | 1 | 1 | 1
775 | 1 | 1 | 1 | 1
777 | 1 | 1 | 1 | 1
779 | 1 | 1 | 1 | 1
781 | 1 | 1 | 1 | 1
783 | 1 | 1 | 1 | 1
785 | 1 | 1 | 1 | 1
787 | 1 | 1 | 1 | 1
789 | 1 | 1 | 1 | 1
791 | 1 | 1 | 1 | 1
793 | 1 | 1 | 1 | 1
795 | 1 | 1 | 1 | 1
797 | 1 | 1 | 1 | 1
799 | 1 | 1 | 1 | 1
801 | 1 | 1 | 1 | 1
803 | 1 | 1 | 1 | 1
805 | 1 | 1 | 1 | 1
807 | 1 | 1 | 1 | 1
809 | 1 | 1 | 1 | 1
811 | 1 | 1 | 1 | 1
813 | 1 | 1 | 1 | 1
815 | 1 | 1 | 1 | 1
817 | 1 | 1 | 1 | 1
819 | 1 | 1 | 1 | 1
823 | 3 | 1 | 3 | 1
825 | 1 | 1 | 1 | 1
827 | 1 | 1 | 1 | 1
829 | 1 | 1 | 1 | 1
831 | 1 | 1 | 1 | 1
833 | 1 | 1 | 1 | 1
835 | 1 | 1 | 1 | 1
837 | 1 | 1 | 1 | 1
841 | 3 | 1 | 3 | 1
843 | 1 | 1 | 1 | 1
845 | 1 | 1 | 1 | 1
847 | 1 | 1 | 1 | 1
849 | 1 | 1 | 1 | 1
851 | 1 | 1 | 1 | 1
853 | 1 | 1 | 1 | 1
855 | 1 | 1 | 1 | 1
857 | 1 | 1 | 1 | 1
859 | 1 | 1 | 1 | 1
861 | 1 | 1 | 1 | 1
863 | 1 | 1 | 1 | 1
865 | 1 | 1 | 1 | 1
867 | 1 | 1 | 1 | 1
869 | 1 | 1 | 1 | 1
871 | 1 | 1 | 1 | 1
873 | 1 | 1 | 1 | 1
875 | 1 | 1 | 1 | 1
877 | 1 | 1 | 1 | 1
879 | 1 | 1 | 1 | 1
881 | 1 | 1 | 1 | 1
883 | 1 | 1 | 1 | 1
885 | 1 | 1 | 1 | 1
887 | 1 | 1 | 1 | 1
889 | 1 | 1 | 1 | 1
891 | 1 | 1 | 1 | 1
893 | 1 | 1 | 1 | 1
896 | 2 | 1 | 2 | 1
900 | 3 | 1 | 3 | 1
904 | 3 | 1 | 3 | 1
908 | 3 | 1 | 3 | 1
912 | 3 | 1 | 3 | 1
916 | 3 | 1 | 3 | 1
920 | 3 | 1 | 3 | 1
924 | 3 | 1 | 3 | 1
928 | 3 | 1 | 3 | 1
932 | 3 | 1 | 3 | 1
936 | 3 | 1 | 3 | 1
940 | 3 | 1 | 3 | 1
944 | 3 | 1 | 3 | 1
948 | 3 | 1 | 3 | 1
952 | 3 | 1 | 3 | 1
956 | 3 | 1 | 3 | 1
960 | 3 | 1 | 3 | 1
964 | 3 | 1 | 3 | 1
968 | 3 | 1 | 3 | 1
972 | 3 | 1 | 3 | 1
976 | 3 | 1 | 3 | 1
980 | 3 | 1 | 3 | 1
984 | 3 | 1 | 3 | 1
988 | 3 | 1 | 3 | 1
992 | 3 | 1 | 3 | 1
996 | 3 | 1 | 3 | 1
998 | 1 | 1 | 1 | 1
999 | 0 | 1 | 0 | 1

### Detailed Statistics General

Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows
--- | --- | --- | --- | --- | --- | --- | --- | --- | ---
_WA_Sys_00000002_123EB7A3 | Aug 8 2010 5:23PM | 504 | 504 | 36 | 0.4615385 | 4 |  |  | 504

### Detailed Statistics Density

All Density | Average Length | Columns
--- | --- | ---
0.02380952 | 4 | ProductPhotoID

### Detailed Statistics Histogram

Range High Key | Range Rows | Estimated Rows | Distinct Range Rows | Avg Range Rows
--- | --- | --- | --- | ---
1 | 0 | 346 | 0 | 1
78 | 0 | 7 | 0 | 1
80 | 0 | 4 | 0 | 1
84 | 0 | 3 | 0 | 1
87 | 0 | 13 | 0 | 1
99 | 0 | 9 | 0 | 1
102 | 0 | 4 | 0 | 1
111 | 0 | 5 | 0 | 1
113 | 0 | 4 | 0 | 1
118 | 0 | 10 | 0 | 1
126 | 0 | 11 | 0 | 1
128 | 0 | 4 | 0 | 1
131 | 0 | 5 | 0 | 1
135 | 0 | 4 | 0 | 1
137 | 0 | 1 | 0 | 1
138 | 0 | 3 | 0 | 1
139 | 0 | 5 | 0 | 1
143 | 5 | 5 | 1 | 5
145 | 0 | 1 | 0 | 1
146 | 0 | 1 | 0 | 1
147 | 0 | 3 | 0 | 1
149 | 0 | 1 | 0 | 1
150 | 0 | 1 | 0 | 1
153 | 0 | 1 | 0 | 1
155 | 1 | 1 | 1 | 1
157 | 1 | 1 | 1 | 1
159 | 1 | 1 | 1 | 1
160 | 0 | 15 | 0 | 1
162 | 0 | 4 | 0 | 1
165 | 0 | 4 | 0 | 1
167 | 1 | 1 | 1 | 1
172 | 0 | 1 | 0 | 1
173 | 0 | 1 | 0 | 1
175 | 0 | 3 | 0 | 1
177 | 4 | 4 | 1 | 4
179 | 0 | 4 | 0 | 1

## Objects that depend on [ProductProductPhoto]

- Production.ProductProductPhoto

## Objects on which [ProductProductPhoto] depends

- Production.ProductProductPhoto
  - Production.Product
    - Production.ProductSubcategory
      - Production.ProductCategory
        - dbo.Name
    - Production.UnitMeasure
    - Production.ProductModel
      - Production.ProductDescriptionSchemaCollection
      - Production.ManuInstructionsSchemaCollection
    - dbo.Flag
  - Production.ProductPhoto

## SQL

Script
SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [Production].[ProductProductPhoto]( [ProductID] [int] NOT NULL, [ProductPhotoID] [int] NOT NULL, [Primary] [dbo].[Flag] NOT NULL, [ModifiedDate] [datetime] NOT NULL ) ON [PRIMARY] EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Product identification number. Foreign key to Product.ProductID.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'ProductProductPhoto', @level2type=N'COLUMN',@level2name=N'ProductID' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Product photo identification number. Foreign key to ProductPhoto.ProductPhotoID.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'ProductProductPhoto', @level2type=N'COLUMN',@level2name=N'ProductPhotoID' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'0 = Photo is not the principal image. 1 = Photo is the principal image.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'ProductProductPhoto', @level2type=N'COLUMN',@level2name=N'Primary' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Date and time the record was last updated.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'ProductProductPhoto', @level2type=N'COLUMN',@level2name=N'ModifiedDate' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Cross-reference table mapping products and product photos.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'ProductProductPhoto'

#### See also

List of Tables