Properties

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

Columns

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

Total: 3 column(s)

Indexes

	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	1
	Illustration	Production	Table	2
	ProductModel	Production	Table	2

Total: 3 object(s)

SQL

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
    (
        [ProductModelID],
        [IllustrationID]
    )  ON [PRIMARY] ,
    CONSTRAINT [FK_ProductModelIllustration_Illustration_IllustrationID] FOREIGN KEY
    (
        [IllustrationID]
    ) REFERENCES [Illustration] (
        [IllustrationID]
    ),
    CONSTRAINT [FK_ProductModelIllustration_ProductModel_ProductModelID] FOREIGN KEY
    (
        [ProductModelID]
    ) REFERENCES [ProductModel] (
        [ProductModelID]
    )
) ON [PRIMARY]
GO

See Also

List of tables