Object type: Table

Cross-reference table mapping product models and illustrations.

Columns 

Name	Data type	Nullable	Description
ProductModelID	int	No	Primary key. Foreign key to ProductModel.ProductModelID.
IllustrationID	int	No	Primary key. Foreign key to Illustration.IllustrationID.
ModifiedDate	datetime	No	Default value: GETDATE() Date and time the record was last updated.

Constraints 

Name	Type	Columns	Description
DF_ProductModelIllustration_ModifiedDate	DEFAULT	ModifiedDate	Value: GETDATE() Default constraint value of GETDATE()
PK_ProductModelIllustration_ProductModelID_IllustrationID	PRIMARY KEY	ProductModelID IllustrationID	Clustered index created by a primary key constraint.
FK_ProductModelIllustration_ProductModel_ProductModelID	FOREIGN KEY	ProductModelID	Reference table: Production.ProductModel Foreign key constraint referencing ProductModel.ProductModelID.
FK_ProductModelIllustration_Illustration_IllustrationID	FOREIGN KEY	IllustrationID	Reference table: Production.Illustration Foreign key constraint referencing Illustration.IllustrationID.

Triggers 

Name	Description
Production.uProductModelIllustration	AFTER UPDATE trigger setting the ModifiedDate column in the ProductModelIllustration table to the current date.

Modified by 

Name	Description
Production.uProductModelIllustration	AFTER UPDATE trigger setting the ModifiedDate column in the ProductModelIllustration table to the current date.

Applies to

Tables | User

The AdventureWorks database sample was developed by Microsoft Corporation, copyright 2005. SQL Server is a trademark of Microsoft Corporation