Production.ProductDocument

Table: 'Production.ProductDocument'

3 fields. 24 bytes.

Cross-reference table mapping products to related product documents.

Field Name	Data Type	Size	Original Type	Default	Nullable	Description	Check
ProductID	int				Not null	Product identification number. Foreign key to Product.ProductID.
DocumentID	int				Not null	Document identification number. Foreign key to Document.DocumentID.
ModifiedDate	datetime			getdate()	Not null	Date and time the record was last updated.

Extended Properties

The object has no extended properties.

Primary key for table 'Production.ProductDocument'

Primary Key Name	Field Names
PK_ProductDocument_ProductID_DocumentID	ProductID, DocumentID

Foreign keys for table 'Production.ProductDocument', 2 items

Foreign	Primary	Key Name
ProductDocument.DocumentID	Document.DocumentID	FK_ProductDocument_Document_DocumentID
ProductDocument.ProductID	Product.ProductID	FK_ProductDocument_Product_ProductID

Indexes for table 'Production.ProductDocument', 1 item

Index Name	Description	Clustered	Unique	Fields
PK_ProductDocument_ProductID_DocumentID	Clustered index created by a primary key constraint.	Yes	Yes	ProductID, DocumentID

Triggers for table 'Production.ProductDocument', 1 item

Name	Description	Type	Enabled
uProductDocument	AFTER UPDATE trigger setting the ModifiedDate column in the ProductDocument table to the current date.	after Update	Yes

Dependencies for table 'Production.ProductDocument', 1 item

Object Name	Type	Field Name
Production.uProductDocument	trigger	N/A