Production.ProductDocument Table

Information

Name	ProductDocument
Schema	Production
Row Count	0
Data Size
Index Size
Reserved Size
Unused Size
Created	29.3.2010. 21:58:18
Modified	29.3.2010. 21:58:54

Extended Properties

Name	Type	Property Name	Value
ProductDocument	TABLE	MS_Description	Cross-reference table mapping products to related product documents.

Columns

Name	Data Type	References	Default
ProductID	int	Production.Product.ProductID
DocumentID	int	Production.Document.DocumentID
ModifiedDate	datetime		(getdate())

Indexes

Name	Type	Primary	Unique	Columns
PK_ProductDocument_ProductID_DocumentID	Clustered			ProductID, DocumentID

Foreign Key Constraints

Name	Type	Referenced Table
FK_ProductDocument_Document_DocumentID	Foreign key	Production.Document
FK_ProductDocument_Product_ProductID	Foreign key	Production.Product

SQL Script

CREATE TABLE [Production].[ProductDocument] (
    [ProductID] int NOT NULL,
    [DocumentID] int NOT NULL,
    [ModifiedDate] datetime NOT NULL DEFAULT (getdate())
);