Database reference - AdventureWorks2008

AdventureWorks2008 -  tables -  [Production].[ProductModelProductDescriptionCulture]

Description

Cross-reference table mapping product descriptions and the language the description is written in. 

Table properties

namevalue
name[Production].[ProductModelProductDescriptionCulture]
createdMar 19 2009 9:09PM
modifiedMar 19 2009 9:10PM 
ansi nullson 
quoted identifieron 
row count762
Size of data32 kb
Size of indexes16 kb
Maximum size of a single row40 bytes

Columns

columndatatypelengthbytesdefaultnullsPKFKUQcomputedcomment
ProductModelIDint104 no  composite PK  ProductModel.ProductModelID      no  Primary key. Foreign key to ProductModel.ProductModelID. 
ProductDescriptionIDint104 no  composite PK  ProductDescription.ProductDescriptionID      no  Primary key. Foreign key to ProductDescription.ProductDescriptionID. 
CultureIDnchar(6)624 no  composite PK  Culture.CultureID      no  Culture identification number. Foreign key to Culture.CultureID. 
ModifiedDatedatetime238(getdate())no      no  Date and time the record was last updated. 

Indexes

namedescriptioncolumncomment
PK_ProductModelProductDescriptionCulture_ProductModelID_ProductDescriptionID_CultureIDclustered, unique, primary key located on PRIMARYProductModelID, ProductDescriptionID, CultureIDClustered index created by a primary key constraint. 

References

name
Culture
ProductDescription
ProductModel

Foreign key graph

CultureProductDescriptionProductModelProductModelProductDescriptionCulture

Foreign keys

namecolumnsforeign columnstypecomment
FK_ProductModelProductDescriptionCulture_ProductModel_ProductModelIDProductModelIDProductModel.ProductModelID   Foreign key constraint referencing ProductModel.ProductModelID. 
FK_ProductModelProductDescriptionCulture_ProductDescription_ProductDescriptionIDProductDescriptionIDProductDescription.ProductDescriptionID   Foreign key constraint referencing ProductDescription.ProductDescriptionID. 
FK_ProductModelProductDescriptionCulture_Culture_CultureIDCultureIDCulture.CultureID   Foreign key constraint referencing Culture.CultureID. 

Defaults

default namecolumncomment
DF_ProductModelProductDescriptionCulture_ModifiedDateModifiedDateDefault constraint value of GETDATE() 

Dependency graph

DF_ProductModelProductDescriptionCulture_ModifiedD...ProductModelProductDescriptionCulturePK_ProductModelProductDescriptionCulture_ProductMo...Product Catalog 2008Product Catalog 2008;2vProductAndDescription

Objects that depend on [Production].[ProductModelProductDescriptionCulture]

nameobject typedatabaseserverlevel
Product Catalog 2008Reportreportserver_katmaiSPRING1
Product Catalog 2008;2Reportreportserver_katmaiSPRING1
vProductAndDescriptionviewAdventureWorks2008SPRING\KATMAI1

Sample rows

ProductModelIDProductDescriptionIDCultureIDModifiedDate
1  1199  en   6/1/2003 12:00:00 AM 
1  1467  ar   6/1/2003 12:00:00 AM 
1  1589  fr   6/1/2003 12:00:00 AM 
1  1712  th   6/1/2003 12:00:00 AM 
1  1838  he   6/1/2003 12:00:00 AM 
1  1965  zh-cht  6/1/2003 12:00:00 AM 
2  1210  en   6/1/2003 12:00:00 AM 
2  1476  ar   6/1/2003 12:00:00 AM 
2  1598  fr   6/1/2003 12:00:00 AM 
2  1721  th   6/1/2003 12:00:00 AM 

Code

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,
 CONSTRAINT [PK_ProductModelProductDescriptionCulture_ProductModelID_ProductDescriptionID_CultureID] PRIMARY KEY CLUSTERED 
(
    [ProductModelID] ASC,
    [ProductDescriptionID] ASC,
    [CultureID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

ALTER TABLE [Production].[ProductModelProductDescriptionCulture]  WITH CHECK ADD  CONSTRAINT [FK_ProductModelProductDescriptionCulture_Culture_CultureID] FOREIGN KEY([CultureID])
REFERENCES [Production].[Culture] ([CultureID])
ALTER TABLE [Production].[ProductModelProductDescriptionCulture] CHECK CONSTRAINT [FK_ProductModelProductDescriptionCulture_Culture_CultureID]
ALTER TABLE [Production].[ProductModelProductDescriptionCulture]  WITH CHECK ADD  CONSTRAINT [FK_ProductModelProductDescriptionCulture_ProductDescription_ProductDescriptionID] FOREIGN KEY([ProductDescriptionID])
REFERENCES [Production].[ProductDescription] ([ProductDescriptionID])
ALTER TABLE [Production].[ProductModelProductDescriptionCulture] CHECK CONSTRAINT [FK_ProductModelProductDescriptionCulture_ProductDescription_ProductDescriptionID]
ALTER TABLE [Production].[ProductModelProductDescriptionCulture]  WITH CHECK ADD  CONSTRAINT [FK_ProductModelProductDescriptionCulture_ProductModel_ProductModelID] FOREIGN KEY([ProductModelID])
REFERENCES [Production].[ProductModel] ([ProductModelID])
ALTER TABLE [Production].[ProductModelProductDescriptionCulture] CHECK CONSTRAINT [FK_ProductModelProductDescriptionCulture_ProductModel_ProductModelID]
ALTER TABLE [Production].[ProductModelProductDescriptionCulture] ADD  CONSTRAINT [DF_ProductModelProductDescriptionCulture_ModifiedDate]  DEFAULT (getdate()) FOR [ModifiedDate]



Documentation generated by SqlSpec