Properties

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.

Columns

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

Total: 4 column(s)

Indexes

	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	1
	Culture	Production	Table	2
	ProductDescription	Production	Table	2
	ProductModel	Production	Table	2

Total: 4 object(s)

Objects that depend on [Production].[ProductModelProductDescriptionCulture]

	Object Name	Owner	Object Type	Dep Level
	vProductAndDescription	Production	View	1

Total: 1 object(s)

SQL

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
    (
        [ProductModelID],
        [ProductDescriptionID],
        [CultureID]
    )  ON [PRIMARY] ,
    CONSTRAINT [FK_ProductModelProductDescriptionCulture_Culture_CultureID] FOREIGN KEY
    (
        [CultureID]
    ) REFERENCES [Culture] (
        [CultureID]
    ),
    CONSTRAINT [FK_ProductModelProductDescriptionCulture_ProductDescription_ProductDescriptionID] FOREIGN KEY
    (
        [ProductDescriptionID]
    ) REFERENCES [ProductDescription] (
        [ProductDescriptionID]
    ),
    CONSTRAINT [FK_ProductModelProductDescriptionCulture_ProductModel_ProductModelID] FOREIGN KEY
    (
        [ProductModelID]
    ) REFERENCES [ProductModel] (
        [ProductModelID]
    )
) ON [PRIMARY]
GO

See Also

List of tables