AdventureWorks
| Table Name: | Production.ProductDocument |
| Description: | Cross-reference table mapping products to related product documents. |
| Primary Keys: | ProductID DocumentID |
| Field | Type | Defaults | Nulls? | Comments |
|---|---|---|---|---|
| ProductID | int | None | No | Product identification number. Foreign key to Product.ProductID. |
| DocumentID | int | None | No | Document identification number. Foreign key to Document.DocumentID. |
| ModifiedDate | datetime | (getdate()) | No | Date and time the record was last updated. |
| Index | Clustered? | Unique? | Fields |
|---|---|---|---|
| PK_ProductDocument_ProductID_DocumentID | Yes | Yes | ProductID DocumentID |
| Internal Foreign Key Constraint | Affected Field | Source Table |
|---|---|---|
| FK_ProductDocument_Document_DocumentID | DocumentID | Production.Document |
| FK_ProductDocument_Product_ProductID | ProductID | Production.Product |