Production.ProductModelIllustration

Table: 'Production.ProductModelIllustration'

3 fields. 24 bytes.

Cross-reference table mapping product models and illustrations.

Field Name	Data Type	Size	Original Type	Default	Nullable	Description	Check
ProductModelID	int				Not null	Primary key. Foreign key to ProductModel.ProductModelID.
IllustrationID	int				Not null	Primary key. Foreign key to Illustration.IllustrationID.
ModifiedDate	datetime			getdate()	Not null	Date and time the record was last updated.

Extended Properties

The object has no extended properties.

Primary key for table 'Production.ProductModelIllustration'

Primary Key Name	Field Names
PK_ProductModelIllustration_ProductModelID_IllustrationID	ProductModelID, IllustrationID

Foreign keys for table 'Production.ProductModelIllustration', 2 items

Foreign	Primary	Key Name
ProductModelIllustration.IllustrationID	Illustration.IllustrationID	FK_ProductModelIllustration_Illustration_IllustrationID
ProductModelIllustration.ProductModelID	ProductModel.ProductModelID	FK_ProductModelIllustration_ProductModel_ProductModelID

Indexes for table 'Production.ProductModelIllustration', 1 item

Index Name	Description	Clustered	Unique	Fields
PK_ProductModelIllustration_ProductModelID_IllustrationID	Clustered index created by a primary key constraint.	Yes	Yes	ProductModelID, IllustrationID

Triggers for table 'Production.ProductModelIllustration', 1 item

Name	Description	Type	Enabled
uProductModelIllustration	AFTER UPDATE trigger setting the ModifiedDate column in the ProductModelIllustration table to the current date.	after Update	Yes

Dependencies for table 'Production.ProductModelIllustration', 1 item

Object Name	Type	Field Name
Production.uProductModelIllustration	trigger	N/A