ScrewTurn Wiki

Navigation

Main Page

Quick Search

Advanced Search »

PoweredBy

PoweredBy

Discuss (0)View Page Code History

Production.ProductDocument_(table)

Modified: 2011/08/27 10:14 by wikibot - Uncategorized

» Sales.Individual_(table) » Person.AddressType_(table) » Production.ProductDocument_(table)

wikibot

Table	Production.ProductDocument
Description	Cross-reference table mapping products to related product documents.

Columns

Column	Data Type	Nullable	Default	Description
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	not null	(getdate())	Date and time the record was last updated.

Primary Key

Primary Key	Columns
PK_ProductDocument_ProductID_DocumentID	ProductID, DocumentID

Foreign Keys

Relation	Column	Referenced Column
Production.Document	DocumentID	DocumentID
Production.Product	ProductID	ProductID

References

Dependency Type	Object Type	Referenced Object
Schema	Schema	Production

automatically generated

Table	Production.ProductDocument
Description	Cross-reference table mapping products to related product documents.

Column	Data Type	Nullable	Default	Description / PK / Index
ProductID	int	not null		Product identification number. Foreign key to Product.ProductID. PK_ProductDocument_ProductID_DocumentID
DocumentID	int	not null		Document identification number. Foreign key to Document.DocumentID. PK_ProductDocument_ProductID_DocumentID
ModifiedDate	datetime	not null	(GETDATE())	Date and time the record was last updated.

Relation	Column	Referenced Column
Production.Document	DocumentID	DocumentID
Production.Product	ProductID	ProductID

Dependency Type	Object Type	Referenced Object
Schema	Schema	Production

ScrewTurn Wiki version 2.0.36. Some of the icons created by FamFamFam.