Production.ProductModelIllustration Table

Information

Name	ProductModelIllustration
Schema	Production
Row Count	0
Data Size
Index Size
Reserved Size
Unused Size
Created	29.3.2010. 21:58:18
Modified	29.3.2010. 21:58:54

Extended Properties

Name	Type	Property Name	Value
ProductModelIllustration	TABLE	MS_Description	Cross-reference table mapping product models and illustrations.

Columns

Name	Data Type	References	Default
ProductModelID	int	Production.ProductModel.ProductModelID
IllustrationID	int	Production.Illustration.IllustrationID
ModifiedDate	datetime		(getdate())

Indexes

Name	Type	Primary	Unique	Columns
PK_ProductModelIllustration_ProductModelID_IllustrationID	Clustered			ProductModelID, IllustrationID

Foreign Key Constraints

Name	Type	Referenced Table
FK_ProductModelIllustration_Illustration_IllustrationID	Foreign key	Production.Illustration
FK_ProductModelIllustration_ProductModel_ProductModelID	Foreign key	Production.ProductModel

SQL Script

CREATE TABLE [Production].[ProductModelIllustration] (
    [ProductModelID] int NOT NULL,
    [IllustrationID] int NOT NULL,
    [ModifiedDate] datetime NOT NULL DEFAULT (getdate())
);