Welcome Guest, you are in: <root> • Login

Page History: Production ProductModelIllustration (table)

Compare Page Revisions

4 3 2 1 0 Current 4 3 2 1 0

« Older Revision - Back to Page History - Newer Revision »

Page Revision: 2010/02/11 09:06

wikibot ¶

Table	Production.ProductModelIllustration
Description	Cross-reference table mapping product models and illustrations.

Columns ¶

Column	Data Type	Nullable	Default	Description
ProductModelID	int	not null		Primary key. Foreign key to ProductModel.ProductModelID.
IllustrationID	int	not null		Primary key. Foreign key to Illustration.IllustrationID.
ModifiedDate	datetime	not null	(getdate())	Date and time the record was last updated.

Primary Key ¶

Primary Key	Columns
PK_ProductModelIllustration_ProductModelID_IllustrationID	ProductModelID, IllustrationID

Foreign Keys ¶

Relation	Column	Referenced Column
Production.Illustration	IllustrationID	IllustrationID
Production.ProductModel	ProductModelID	ProductModelID

References ¶

Dependency Type	Object Type	Referenced Object
Schema	Schema	Production