table icon 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 true
Quoted Identifier true
Lock Escalation TABLE
Lock On Bulk Load false
Lob Data Space
Filestream Data Space ID
Has Unchecked Assembly Data false
Text In Row Limit (bytes) Option not set
Large Value Types Out Of Row false
FullText Change Tracking On false
Tracked By Cdc false
Published false
Schema Published false
Replicated false
Replication Filter false
Merge Published false
Sync Tran Subscribed false
MS Shipped false
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 false false false
2 ProductDescriptionID int false false false
3 CultureID nchar(6) false false false
4 ModifiedDate datetime false false false

Identity Columns

No identity columns defined.

Primary Key Constraints

Name Is System Named Extended Property Name Extended Property Value
PK_ProductModelProductDescriptionCulture_ProductModelID_ProductDescriptionID_CultureID false 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()) false 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 true true false false false

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

NameUpdatedRowsRows SampledStepsDensityAverage Key LengthString IndexFilter ExpressionUnfiltered Rows
PK_ProductModelProductDescriptionCulture_ProductModelID_ProductDescriptionID_CultureID Aug 8 2010 5:22PM 762 762 64 0.1666667 20 false 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

NameUpdatedRowsRows SampledStepsDensityAverage Key LengthString IndexFilter ExpressionUnfiltered Rows
_WA_Sys_00000003_0E6E26BF Aug 8 2010 5:23PM 762 762 6 0 12 true 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

NameUpdatedRowsRows SampledStepsDensityAverage Key LengthString IndexFilter ExpressionUnfiltered Rows
_WA_Sys_00000002_0E6E26BF Aug 8 2010 5:23PM 762 762 188 1 4 false 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]

Objects on which [ProductModelProductDescriptionCulture] depends

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