# Table: ProductModelProductDescriptionCulture

## Properties

Property | Value
--- | ---
Name | ProductModelProductDescriptionCulture
ID | 242099903
Owner | dbo
Schema | Production
Filegroup | PRIMARY
Data Size (KB) | 32 KB
Index Size (KB) | 16 KB
Rows | 762
Unused (KB) | 0 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:45 PM
Create Date | 8/8/2010 5:21:51 PM

## Extended Properties

Name | Value
--- | ---
MS_Description | Cross-reference table mapping product descriptions and the language the description is written in.

## Columns

Column ID | Column Name | Datatype | Nullable | Is Sparse | Is Column Set
--- | --- | --- | --- | --- | ---
1 | ProductModelID | int |  |  |
2 | ProductDescriptionID | int |  |  |
3 | CultureID | nchar(6) |  |  |
4 | ModifiedDate | datetime |  |  |

## Identity Columns

No identity columns defined.

## Primary Key Constraints

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

## Primary Key Columns

Name
ProductModelID
ProductDescriptionID
CultureID

## Foreign Keys

Name | Referenced Object | Update Action | Delete Action
--- | --- | --- | ---
FK_ProductModelProductDescriptionCulture_ProductDescription_ProductDescriptionID | Production.ProductDescription | No action | No action
FK_ProductModelProductDescriptionCulture_Culture_CultureID | Production.Culture | No action | No action
FK_ProductModelProductDescriptionCulture_ProductModel_ProductModelID | Production.ProductModel | 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_ProductModelProductDescriptionCulture_ModifiedDate | ModifiedDate | (getdate()) |  | MS_Description | Default constraint value of GETDATE()

## Indexes

Name | Index Type | Primary Key | Unique | Unique Constraint | Ignore Duplicate Key | Disabled
--- | --- | --- | --- | --- | --- | ---
PK_ProductModelProductDescriptionCulture_ProductModelID_ProductDescriptionID_CultureID | CLUSTERED |  |  |  |  |

## 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_ProductModelProductDescriptionCulture_ProductModelID_ProductDescriptionID_CultureID | Aug 8 2010 5:22PM | 762 | 762 | 64 | 0.1666667 | 20 |  |  | 762

### Detailed Statistics Density

All Density | Average Length | Columns
--- | --- | ---
0.007874016 | 4 | ProductModelID
0.001312336 | 8 | ProductModelID, ProductDescriptionID
0.001312336 | 20 | ProductModelID, ProductDescriptionID, CultureID

### Detailed Statistics Histogram

Range High Key | Range Rows | Estimated Rows | Distinct Range Rows | Avg Range Rows
--- | --- | --- | --- | ---
1 | 0 | 6 | 0 | 1
3 | 6 | 6 | 1 | 6
5 | 6 | 6 | 1 | 6
7 | 6 | 6 | 1 | 6
9 | 6 | 6 | 1 | 6
11 | 6 | 6 | 1 | 6
13 | 6 | 6 | 1 | 6
15 | 6 | 6 | 1 | 6
17 | 6 | 6 | 1 | 6
19 | 6 | 6 | 1 | 6
21 | 6 | 6 | 1 | 6
23 | 6 | 6 | 1 | 6
25 | 6 | 6 | 1 | 6
27 | 6 | 6 | 1 | 6
29 | 6 | 6 | 1 | 6
31 | 6 | 6 | 1 | 6
33 | 6 | 6 | 1 | 6
35 | 6 | 6 | 1 | 6
37 | 6 | 6 | 1 | 6
39 | 6 | 6 | 1 | 6
41 | 6 | 6 | 1 | 6
43 | 6 | 6 | 1 | 6
45 | 6 | 6 | 1 | 6
47 | 6 | 6 | 1 | 6
49 | 6 | 6 | 1 | 6
51 | 6 | 6 | 1 | 6
53 | 6 | 6 | 1 | 6
55 | 6 | 6 | 1 | 6
57 | 6 | 6 | 1 | 6
59 | 6 | 6 | 1 | 6
61 | 6 | 6 | 1 | 6
63 | 6 | 6 | 1 | 6
65 | 6 | 6 | 1 | 6
67 | 6 | 6 | 1 | 6
69 | 6 | 6 | 1 | 6
71 | 6 | 6 | 1 | 6
73 | 6 | 6 | 1 | 6
75 | 6 | 6 | 1 | 6
77 | 6 | 6 | 1 | 6
79 | 6 | 6 | 1 | 6
81 | 6 | 6 | 1 | 6
83 | 6 | 6 | 1 | 6
85 | 6 | 6 | 1 | 6
87 | 6 | 6 | 1 | 6
89 | 6 | 6 | 1 | 6
91 | 6 | 6 | 1 | 6
93 | 6 | 6 | 1 | 6
95 | 6 | 6 | 1 | 6
97 | 6 | 6 | 1 | 6
99 | 6 | 6 | 1 | 6
101 | 6 | 6 | 1 | 6
103 | 6 | 6 | 1 | 6
105 | 6 | 6 | 1 | 6
107 | 6 | 6 | 1 | 6
109 | 6 | 6 | 1 | 6
111 | 6 | 6 | 1 | 6
113 | 6 | 6 | 1 | 6
115 | 6 | 6 | 1 | 6
117 | 6 | 6 | 1 | 6
119 | 6 | 6 | 1 | 6
121 | 6 | 6 | 1 | 6
123 | 6 | 6 | 1 | 6
125 | 6 | 6 | 1 | 6
127 | 6 | 6 | 1 | 6

### Detailed Statistics General

Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows
--- | --- | --- | --- | --- | --- | --- | --- | --- | ---
_WA_Sys_00000003_0E6E26BF | Aug 8 2010 5:23PM | 762 | 762 | 6 | 0 | 12 |  |  | 762

### Detailed Statistics Density

All Density | Average Length | Columns
--- | --- | ---
0.1666667 | 12 | CultureID

### Detailed Statistics Histogram

Range High Key | Range Rows | Estimated Rows | Distinct Range Rows | Avg Range Rows
--- | --- | --- | --- | ---
ar | 0 | 127 | 0 | 1
en | 0 | 127 | 0 | 1
fr | 0 | 127 | 0 | 1
he | 0 | 127 | 0 | 1
th | 0 | 127 | 0 | 1
zh-cht | 0 | 127 | 0 | 1

### Detailed Statistics General

Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows
--- | --- | --- | --- | --- | --- | --- | --- | --- | ---
_WA_Sys_00000002_0E6E26BF | Aug 8 2010 5:23PM | 762 | 762 | 188 | 1 | 4 |  |  | 762

### Detailed Statistics Density

All Density | Average Length | Columns
--- | --- | ---
0.001312336 | 4 | ProductDescriptionID

### Detailed Statistics Histogram

Range High Key | Range Rows | Estimated Rows | Distinct Range Rows | Avg Range Rows
--- | --- | --- | --- | ---
3 | 0 | 1 | 0 | 1
8 | 2 | 1 | 2 | 1
168 | 3 | 1 | 3 | 1
320 | 3 | 1 | 3 | 1
376 | 3 | 1 | 3 | 1
554 | 3 | 1 | 3 | 1
619 | 3 | 1 | 3 | 1
633 | 3 | 1 | 3 | 1
642 | 3 | 1 | 3 | 1
686 | 3 | 1 | 3 | 1
690 | 3 | 1 | 3 | 1
700 | 5 | 1 | 5 | 1
704 | 3 | 1 | 3 | 1
847 | 3 | 1 | 3 | 1
851 | 3 | 1 | 3 | 1
853 | 1 | 1 | 1 | 1
868 | 3 | 1 | 3 | 1
872 | 3 | 1 | 3 | 1
887 | 3 | 1 | 3 | 1
891 | 3 | 1 | 3 | 1
904 | 3 | 1 | 3 | 1
908 | 3 | 1 | 3 | 1
914 | 3 | 1 | 3 | 1
1146 | 3 | 1 | 3 | 1
1186 | 3 | 1 | 3 | 1
1195 | 7 | 1 | 7 | 1
1197 | 1 | 1 | 1 | 1
1202 | 3 | 1 | 3 | 1
1205 | 1 | 1 | 1 | 1
1214 | 7 | 1 | 7 | 1
1361 | 3 | 1 | 3 | 1
1365 | 3 | 1 | 3 | 1
1369 | 3 | 1 | 3 | 1
1373 | 3 | 1 | 3 | 1
1377 | 3 | 1 | 3 | 1
1381 | 3 | 1 | 3 | 1
1385 | 3 | 1 | 3 | 1
1389 | 3 | 1 | 3 | 1
1391 | 1 | 1 | 1 | 1
1395 | 3 | 1 | 3 | 1
1399 | 3 | 1 | 3 | 1
1401 | 1 | 1 | 1 | 1
1405 | 3 | 1 | 3 | 1
1409 | 3 | 1 | 3 | 1
1413 | 3 | 1 | 3 | 1
1417 | 3 | 1 | 3 | 1
1421 | 3 | 1 | 3 | 1
1425 | 3 | 1 | 3 | 1
1430 | 3 | 1 | 3 | 1
1432 | 1 | 1 | 1 | 1
1436 | 3 | 1 | 3 | 1
1440 | 3 | 1 | 3 | 1
1444 | 3 | 1 | 3 | 1
1448 | 3 | 1 | 3 | 1
1452 | 3 | 1 | 3 | 1
1456 | 3 | 1 | 3 | 1
1460 | 3 | 1 | 3 | 1
1464 | 3 | 1 | 3 | 1
1468 | 3 | 1 | 3 | 1
1472 | 3 | 1 | 3 | 1
1476 | 3 | 1 | 3 | 1
1480 | 3 | 1 | 3 | 1
1482 | 1 | 1 | 1 | 1
1491 | 7 | 1 | 7 | 1
1495 | 3 | 1 | 3 | 1
1499 | 3 | 1 | 3 | 1
1503 | 3 | 1 | 3 | 1
1505 | 1 | 1 | 1 | 1
1509 | 3 | 1 | 3 | 1
1513 | 3 | 1 | 3 | 1
1515 | 1 | 1 | 1 | 1
1519 | 3 | 1 | 3 | 1
1523 | 3 | 1 | 3 | 1
1527 | 3 | 1 | 3 | 1
1531 | 3 | 1 | 3 | 1
1535 | 3 | 1 | 3 | 1
1539 | 3 | 1 | 3 | 1
1543 | 3 | 1 | 3 | 1
1545 | 1 | 1 | 1 | 1
1549 | 3 | 1 | 3 | 1
1553 | 3 | 1 | 3 | 1
1557 | 3 | 1 | 3 | 1
1559 | 1 | 1 | 1 | 1
1563 | 3 | 1 | 3 | 1
1567 | 3 | 1 | 3 | 1
1569 | 1 | 1 | 1 | 1
1573 | 3 | 1 | 3 | 1
1577 | 3 | 1 | 3 | 1
1581 | 3 | 1 | 3 | 1
1585 | 3 | 1 | 3 | 1
1589 | 3 | 1 | 3 | 1
1591 | 1 | 1 | 1 | 1
1595 | 3 | 1 | 3 | 1
1599 | 3 | 1 | 3 | 1
1603 | 3 | 1 | 3 | 1
1607 | 3 | 1 | 3 | 1
1611 | 3 | 1 | 3 | 1
1615 | 3 | 1 | 3 | 1
1619 | 3 | 1 | 3 | 1
1621 | 1 | 1 | 1 | 1
1625 | 3 | 1 | 3 | 1
1627 | 1 | 1 | 1 | 1
1631 | 3 | 1 | 3 | 1
1635 | 3 | 1 | 3 | 1
1640 | 4 | 1 | 4 | 1
1644 | 3 | 1 | 3 | 1
1648 | 3 | 1 | 3 | 1
1652 | 3 | 1 | 3 | 1
1656 | 3 | 1 | 3 | 1
1660 | 3 | 1 | 3 | 1
1664 | 3 | 1 | 3 | 1
1668 | 3 | 1 | 3 | 1
1672 | 3 | 1 | 3 | 1
1676 | 3 | 1 | 3 | 1
1680 | 3 | 1 | 3 | 1
1684 | 3 | 1 | 3 | 1
1688 | 3 | 1 | 3 | 1
1692 | 3 | 1 | 3 | 1
1696 | 3 | 1 | 3 | 1
1700 | 3 | 1 | 3 | 1
1704 | 3 | 1 | 3 | 1
1708 | 3 | 1 | 3 | 1
1712 | 3 | 1 | 3 | 1
1716 | 3 | 1 | 3 | 1
1720 | 3 | 1 | 3 | 1
1724 | 3 | 1 | 3 | 1
1728 | 3 | 1 | 3 | 1
1732 | 3 | 1 | 3 | 1
1736 | 3 | 1 | 3 | 1
1740 | 3 | 1 | 3 | 1
1744 | 3 | 1 | 3 | 1
1753 | 7 | 1 | 7 | 1
1757 | 3 | 1 | 3 | 1
1761 | 3 | 1 | 3 | 1
1766 | 3 | 1 | 3 | 1
1775 | 7 | 1 | 7 | 1
1779 | 3 | 1 | 3 | 1
1783 | 3 | 1 | 3 | 1
1787 | 3 | 1 | 3 | 1
1791 | 3 | 1 | 3 | 1
1795 | 3 | 1 | 3 | 1
1804 | 7 | 1 | 7 | 1
1808 | 3 | 1 | 3 | 1
1812 | 3 | 1 | 3 | 1
1816 | 3 | 1 | 3 | 1
1820 | 3 | 1 | 3 | 1
1824 | 3 | 1 | 3 | 1
1828 | 3 | 1 | 3 | 1
1832 | 3 | 1 | 3 | 1
1836 | 3 | 1 | 3 | 1
1840 | 3 | 1 | 3 | 1
1844 | 3 | 1 | 3 | 1
1848 | 3 | 1 | 3 | 1
1857 | 7 | 1 | 7 | 1
1861 | 3 | 1 | 3 | 1
1865 | 3 | 1 | 3 | 1
1869 | 3 | 1 | 3 | 1
1873 | 3 | 1 | 3 | 1
1877 | 3 | 1 | 3 | 1
1886 | 7 | 1 | 7 | 1
1890 | 3 | 1 | 3 | 1
1894 | 3 | 1 | 3 | 1
1898 | 3 | 1 | 3 | 1
1907 | 7 | 1 | 7 | 1
1911 | 3 | 1 | 3 | 1
1915 | 3 | 1 | 3 | 1
1924 | 7 | 1 | 7 | 1
1928 | 3 | 1 | 3 | 1
1932 | 3 | 1 | 3 | 1
1936 | 3 | 1 | 3 | 1
1940 | 3 | 1 | 3 | 1
1944 | 3 | 1 | 3 | 1
1948 | 3 | 1 | 3 | 1
1952 | 3 | 1 | 3 | 1
1956 | 3 | 1 | 3 | 1
1960 | 3 | 1 | 3 | 1
1969 | 7 | 1 | 7 | 1
1973 | 3 | 1 | 3 | 1
1977 | 3 | 1 | 3 | 1
1981 | 3 | 1 | 3 | 1
1985 | 3 | 1 | 3 | 1
1989 | 3 | 1 | 3 | 1
1993 | 3 | 1 | 3 | 1
1997 | 3 | 1 | 3 | 1
2001 | 3 | 1 | 3 | 1
2005 | 3 | 1 | 3 | 1
2009 | 3 | 1 | 3 | 1
2010 | 0 | 1 | 0 | 1

## Objects that depend on [ProductModelProductDescriptionCulture]

- Production.ProductModelProductDescriptionCulture
  - Production.vProductAndDescription

## Objects on which [ProductModelProductDescriptionCulture] depends

- Production.ProductModelProductDescriptionCulture
  - Production.ProductModel
    - Production.ManuInstructionsSchemaCollection
    - dbo.Name
    - Production.ProductDescriptionSchemaCollection
  - Production.Culture
  - Production.ProductDescription

## SQL

Script
SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [Production].[ProductModelProductDescriptionCulture]( [ProductModelID] [int] NOT NULL, [ProductDescriptionID] [int] NOT NULL, [CultureID] [nchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [ModifiedDate] [datetime] NOT NULL ) ON [PRIMARY] EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Primary key. Foreign key to ProductModel.ProductModelID.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'ProductModelProductDescriptionCulture', @level2type=N'COLUMN',@level2name=N'ProductModelID' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Primary key. Foreign key to ProductDescription.ProductDescriptionID.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'ProductModelProductDescriptionCulture', @level2type=N'COLUMN',@level2name=N'ProductDescriptionID' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Culture identification number. Foreign key to Culture.CultureID.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'ProductModelProductDescriptionCulture', @level2type=N'COLUMN',@level2name=N'CultureID' 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'ProductModelProductDescriptionCulture', @level2type=N'COLUMN',@level2name=N'ModifiedDate' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Cross-reference table mapping product descriptions and the language the description is written in.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'ProductModelProductDescriptionCulture'

#### See also

List of Tables