ScrewTurn Wiki

Edit

wikibot

TableProduction.ProductModelIllustration
DescriptionCross-reference table mapping product models and illustrations.

Edit

Columns

ColumnData TypeNullableDefaultDescription
ProductModelIDintnot null Primary key. Foreign key to ProductModel.ProductModelID.
IllustrationIDintnot null Primary key. Foreign key to Illustration.IllustrationID.
ModifiedDatedatetimenot null(getdate())Date and time the record was last updated.

Edit

Primary Key

Primary KeyColumns
PK_ProductModelIllustration_ProductModelID_IllustrationIDProductModelID, IllustrationID

Edit

Foreign Keys

RelationColumnReferenced Column
Production.IllustrationIllustrationIDIllustrationID
Production.ProductModelProductModelIDProductModelID

Edit

References

Dependency TypeObject TypeReferenced Object
SchemaSchemaProduction

Edit

automatically generated

TableProduction.ProductModelIllustration
DescriptionCross-reference table mapping product models and illustrations.

ColumnData TypeNullableDefaultDescription / PK / Index
ProductModelIDintnot null Primary key. Foreign key to ProductModel.ProductModelID.
PK_ProductModelIllustration_ProductModelID_IllustrationID
IllustrationIDintnot null Primary key. Foreign key to Illustration.IllustrationID.
PK_ProductModelIllustration_ProductModelID_IllustrationID
ModifiedDatedatetimenot null(GETDATE())Date and time the record was last updated.



RelationColumnReferenced Column
Production.IllustrationIllustrationIDIllustrationID
Production.ProductModelProductModelIDProductModelID

Dependency TypeObject TypeReferenced Object
SchemaSchemaProduction

ScrewTurn Wiki version 2.0.36. Some of the icons created by FamFamFam.