Owner: Production 
Creation Date: 04/26/2006 
Located On: PRIMARY 
Data Size KB:
Index Size KB:
Description: Cross-reference table mapping product models and illustrations. 


Name Data Type Length NULL Default IsIdentity IsGUID Description
    ProductModelID  int          Primary key. Foreign key to ProductModel.ProductModelID. 
    IllustrationID  int          Primary key. Foreign key to Illustration.IllustrationID. 
    ModifiedDate  datetime    (getdate())      Date and time the record was last updated. 
Total: 3 column(s)


Index Primary Unique Description
  PK_ProductModelIllustration_ProductModelID_IllustrationID      Primary key (clustered) constraint 
Total: 1 index(es)

Referenced Tables

Table Foreign Key Primary Key or Unique Constraint
  Production.Illustration  FK_ProductModelIllustration_Illustration_IllustrationID  PK_Illustration_IllustrationID 
  Production.ProductModel  FK_ProductModelIllustration_ProductModel_ProductModelID  PK_ProductModel_ProductModelID 
Total: 2 table(s)

Objects that [Production].[ProductModelIllustration] depends on

Object Name Owner Object Type Dep Level
  Name  dbo  User Defined type 
  Illustration  Production  Table 
  ProductModel  Production  Table 
Total: 3 object(s)


CREATE TABLE [ProductModelIllustration] (
    [ProductModelID] [int] NOT NULL ,
    [IllustrationID] [int] NOT NULL ,
    [ModifiedDate] [datetime] NOT NULL CONSTRAINT [DF_ProductModelIllustration_ModifiedDate] DEFAULT (getdate()),
    CONSTRAINT [PK_ProductModelIllustration_ProductModelID_IllustrationID] PRIMARY KEY  CLUSTERED
    )  ON [PRIMARY] ,
    CONSTRAINT [FK_ProductModelIllustration_Illustration_IllustrationID] FOREIGN KEY
    ) REFERENCES [Illustration] (
    CONSTRAINT [FK_ProductModelIllustration_ProductModel_ProductModelID] FOREIGN KEY
    ) REFERENCES [ProductModel] (

See Also

List of tables