Difference between revisions of "Production.ProductProductPhoto (table)"

From dbscript Online Help
Jump to: navigation, search
(New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | Production.ProductProductPhoto |- |} {| border="1" cellpadding="5" cellspaci...)
 
Line 45: Line 45:
 
| (getdate())
 
| (getdate())
 
|  
 
|  
 +
|
 +
|}
 +
 +
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Relation
 +
| '''Column
 +
| '''Referenced Column
 +
 +
|-
 +
| [[Production.Product_(table)|Production.Product]]
 +
| ProductID
 +
| ProductID
 +
|-
 +
| [[Production.ProductPhoto_(table)|Production.ProductPhoto]]
 +
| ProductPhotoID
 +
| ProductPhotoID
 +
|}
 +
 +
== automatically generated ==
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|-
 +
| '''Table
 +
| Production.ProductProductPhoto
 +
|-
 +
 +
| '''Description
 +
| Cross-reference table mapping products and product photos.
 +
|-
 +
 +
|}
 +
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Column
 +
| '''Data Type
 +
| '''Nullable
 +
| '''Default
 +
| '''Description
 +
| '''PK / Index
 +
 +
|-
 +
| ProductID
 +
| int
 +
| not null
 +
|
 +
| Product identification number. Foreign key to Product.ProductID.
 +
| PK_ProductProductPhoto_ProductID_ProductPhotoID
 +
|-
 +
| ProductPhotoID
 +
| int
 +
| not null
 +
|
 +
| Product photo identification number. Foreign key to ProductPhoto.ProductPhotoID.
 +
| PK_ProductProductPhoto_ProductID_ProductPhotoID
 +
|-
 +
| Primary
 +
| Flag
 +
| not null
 +
| (0)
 +
| 0 = Photo is not the principal image. 1 = Photo is the principal image.
 +
|
 +
|-
 +
| ModifiedDate
 +
| datetime
 +
| not null
 +
| (GETDATE())
 +
| Date and time the record was last updated.
 
|  
 
|  
 
|}
 
|}

Revision as of 23:27, 26 November 2009

wikibot

Table Production.ProductProductPhoto


Column Data Type Nullable Default PK Index
ProductID int not null PK_ProductProductPhoto_ProductID_ProductPhotoID
ProductPhotoID int not null PK_ProductProductPhoto_ProductID_ProductPhotoID
Primary dbo.Flag not null ((0))
ModifiedDate datetime not null (getdate())


Relation Column Referenced Column
Production.Product ProductID ProductID
Production.ProductPhoto ProductPhotoID ProductPhotoID

automatically generated

Table Production.ProductProductPhoto
Description Cross-reference table mapping products and product photos.


Column Data Type Nullable Default Description PK / Index
ProductID int not null Product identification number. Foreign key to Product.ProductID. PK_ProductProductPhoto_ProductID_ProductPhotoID
ProductPhotoID int not null Product photo identification number. Foreign key to ProductPhoto.ProductPhotoID. PK_ProductProductPhoto_ProductID_ProductPhotoID
Primary Flag not null (0) 0 = Photo is not the principal image. 1 = Photo is the principal image.
ModifiedDate datetime not null (GETDATE()) Date and time the record was last updated.


Relation Column Referenced Column
Production.Product ProductID ProductID
Production.ProductPhoto ProductPhotoID ProductPhotoID
Retrieved from "http://dbshelp.devio.at/index.php?title=Production.ProductProductPhoto_(table)&oldid=1110"