ScrewTurn Wiki
Navigation
Main Page
Random Page
Create a new Page
All Pages
Categories
Administration
File Management
Login/Logout
Language Selection
Your Profile
Create Account
Quick Search
Advanced Search »
Discuss (0)
View Page Code
History
Production.ProductModelIllustration_(table)
Print
RSS
Modified: 2011/08/27 10:14 by
wikibot
-
Uncategorized
»
ddlDatabaseTriggerLog_(database trigger)
»
Production.ProductModelIllustration_(table)
[X]
»
ddlDatabaseTriggerLog_(database trigger)
»
Production.ProductModelIllustration_(table)
Edit
wikibot
Table
Production.ProductModelIllustration
Description
Cross-reference table mapping product models and illustrations.
Edit
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.
Edit
Primary Key
Primary Key
Columns
PK_ProductModelIllustration_ProductModelID_IllustrationID
ProductModelID, IllustrationID
Edit
Foreign Keys
Relation
Column
Referenced Column
Production.Illustration
IllustrationID
IllustrationID
Production.ProductModel
ProductModelID
ProductModelID
Edit
References
Dependency Type
Object Type
Referenced Object
Schema
Schema
Production
Edit
automatically generated
Table
Production.ProductModelIllustration
Description
Cross-reference table mapping product models and illustrations.
Column
Data Type
Nullable
Default
Description / PK / Index
ProductModelID
int
not null
Primary key. Foreign key to ProductModel.ProductModelID.
PK_ProductModelIllustration_ProductModelID_IllustrationID
IllustrationID
int
not null
Primary key. Foreign key to Illustration.IllustrationID.
PK_ProductModelIllustration_ProductModelID_IllustrationID
ModifiedDate
datetime
not null
(GETDATE())
Date and time the record was last updated.
Relation
Column
Referenced Column
Production.Illustration
IllustrationID
IllustrationID
Production.ProductModel
ProductModelID
ProductModelID
Dependency Type
Object Type
Referenced Object
Schema
Schema
Production
ScrewTurn Wiki version 2.0.36. Some of the icons created by
FamFamFam
.