Welcome Guest, you are in: Login

devio dbscript ScrewTurn Wiki

RSS RSS

Navigation





Search the wiki
»

PoweredBy

Page History: Production ProductProductPhoto (table)

Compare Page Revisions



« Older Revision - Back to Page History - Newer Revision »


Page Revision: 2010/01/09 18:03


wikibot

TableProduction.ProductProductPhoto
DescriptionCross-reference table mapping products and product photos.

ColumnData TypeNullableDefaultDescription / PK / Index
ProductIDintnot null Product identification number. Foreign key to Product.ProductID.
PK_ProductProductPhoto_ProductID_ProductPhotoID
ProductPhotoIDintnot null Product photo identification number. Foreign key to ProductPhoto.ProductPhotoID.
PK_ProductProductPhoto_ProductID_ProductPhotoID
Primarydbo.Flagnot null((0))0 = Photo is not the principal image. 1 = Photo is the principal image.
ModifiedDatedatetimenot null(getdate())Date and time the record was last updated.



RelationColumnReferenced Column
Production.ProductProductIDProductID
Production.ProductPhotoProductPhotoIDProductPhotoID

Dependency TypeObject TypeReferenced Object
Data TypeTypedbo.Flag

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