Owner: Production 
Creation Date: 04/26/2006 
Located On: PRIMARY 
Data Size KB: 32 
Index Size KB: 16 
Rows: 762 
Description: Cross-reference table mapping product descriptions and the language the description is written in. 


Name Data Type Length NULL Default IsIdentity IsGUID Description
    ProductModelID  int          Primary key. Foreign key to ProductModel.ProductModelID. 
    ProductDescriptionID  int          Primary key. Foreign key to ProductDescription.ProductDescriptionID. 
    CultureID  nchar          Culture identification number. Foreign key to Culture.CultureID. 
    ModifiedDate  datetime    (getdate())      Date and time the record was last updated. 
Total: 4 column(s)


Index Primary Unique Description
  PK_ProductModelProductDescriptionCulture_ProductModelID_ProductDescriptionID_CultureID      Primary key (clustered) constraint 
Total: 1 index(es)

Referenced Tables

Table Foreign Key Primary Key or Unique Constraint
  Production.Culture  FK_ProductModelProductDescriptionCulture_Culture_CultureID  PK_Culture_CultureID 
  Production.ProductDescription  FK_ProductModelProductDescriptionCulture_ProductDescription_ProductDescriptionID  PK_ProductDescription_ProductDescriptionID 
  Production.ProductModel  FK_ProductModelProductDescriptionCulture_ProductModel_ProductModelID  PK_ProductModel_ProductModelID 
Total: 3 table(s)

Objects that [Production].[ProductModelProductDescriptionCulture] depends on

Object Name Owner Object Type Dep Level
  Name  dbo  User Defined type 
  Culture  Production  Table 
  ProductDescription  Production  Table 
  ProductModel  Production  Table 
Total: 4 object(s)

Objects that depend on [Production].[ProductModelProductDescriptionCulture]

Object Name Owner Object Type Dep Level
  vProductAndDescription  Production  View 
Total: 1 object(s)


CREATE TABLE [ProductModelProductDescriptionCulture] (
    [ProductModelID] [int] NOT NULL ,
    [ProductDescriptionID] [int] NOT NULL ,
    [CultureID] [nchar] (6) COLLATE Latin1_General_CS_AS NOT NULL ,
    [ModifiedDate] [datetime] NOT NULL CONSTRAINT [DF_ProductModelProductDescriptionCulture_ModifiedDate] DEFAULT (getdate()),
    CONSTRAINT [PK_ProductModelProductDescriptionCulture_ProductModelID_ProductDescriptionID_CultureID] PRIMARY KEY  CLUSTERED
    )  ON [PRIMARY] ,
    CONSTRAINT [FK_ProductModelProductDescriptionCulture_Culture_CultureID] FOREIGN KEY
    ) REFERENCES [Culture] (
    CONSTRAINT [FK_ProductModelProductDescriptionCulture_ProductDescription_ProductDescriptionID] FOREIGN KEY
    ) REFERENCES [ProductDescription] (
    CONSTRAINT [FK_ProductModelProductDescriptionCulture_ProductModel_ProductModelID] FOREIGN KEY
    ) REFERENCES [ProductModel] (

See Also

List of tables