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

From dbscript Online Help
Jump to: navigation, search
 
(7 intermediate revisions by the same user not shown)
Line 2: Line 2:
  
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
−
|-
+
|- valign="top"
 
| '''Table
 
| '''Table
 
| Production.ProductProductPhoto
 
| Production.ProductProductPhoto
−
|-
+
|- valign="top"
 +
| '''Description
 +
| Cross-reference table mapping products and product photos.
 
|}
 
|}
  
−
 
+
=== Columns ===
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|- style="background:silver"
 
|- style="background:silver"
Line 15: Line 17:
 
| '''Nullable
 
| '''Nullable
 
| '''Default
 
| '''Default
−
| '''PK
+
| '''Description
−
| '''Index
+
 
−
+
|- valign="top"
−
|-
 
 
| ProductID
 
| ProductID
 
| int
 
| int
 
| not null
 
| not null
 
|  
 
|  
−
| PK_ProductProductPhoto_ProductID_ProductPhotoID
+
| Product identification number. Foreign key to Product.ProductID.
−
|
+
|- valign="top"
−
|-
 
 
| ProductPhotoID
 
| ProductPhotoID
 
| int
 
| int
 
| not null
 
| not null
 
|  
 
|  
−
| PK_ProductProductPhoto_ProductID_ProductPhotoID
+
| Product photo identification number. Foreign key to ProductPhoto.ProductPhotoID.
−
|
+
|- valign="top"
−
|-
 
 
| Primary
 
| Primary
 
| dbo.Flag
 
| dbo.Flag
 
| not null
 
| not null
 
| ((0))
 
| ((0))
−
|  
+
| 0 = Photo is not the principal image. 1 = Photo is the principal image.
−
|
+
|- valign="top"
−
|-
 
 
| ModifiedDate
 
| ModifiedDate
 
| datetime
 
| datetime
 
| not null
 
| not null
 
| (getdate())
 
| (getdate())
−
|  
+
| Date and time the record was last updated.
−
|
 
 
|}
 
|}
  
 +
=== Primary Key ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Primary Key
 +
| '''Columns
 +
|- valign="top"
 +
| PK_ProductProductPhoto_ProductID_ProductPhotoID
 +
| ProductID, ProductPhotoID
 +
|}
  
−
 
+
=== Foreign Keys ===
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|- style="background:silver"
 
|- style="background:silver"
Line 55: Line 61:
 
| '''Column
 
| '''Column
 
| '''Referenced Column
 
| '''Referenced Column
−
+
 
−
|-
+
|- valign="top"
 
| [[Production.Product_(table)|Production.Product]]
 
| [[Production.Product_(table)|Production.Product]]
 
| ProductID
 
| ProductID
 
| ProductID
 
| ProductID
−
|-
+
|- valign="top"
 
| [[Production.ProductPhoto_(table)|Production.ProductPhoto]]
 
| [[Production.ProductPhoto_(table)|Production.ProductPhoto]]
 
| ProductPhotoID
 
| ProductPhotoID
 
| ProductPhotoID
 
| ProductPhotoID
 
|}
 
|}
 +
 +
=== References ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Dependency Type
 +
| '''Object Type
 +
| '''Referenced Object
 +
 +
|- valign="top"
 +
| Data Type
 +
| Type
 +
| [[dbo.Flag_(type)|dbo.Flag]]
 +
 +
|- valign="top"
 +
| Schema
 +
| Schema
 +
| [[Production_(schema)|Production]]
 +
 +
|}
 +
 +
 
== automatically generated ==
 
== automatically generated ==
  
Line 71: Line 98:
 
| '''Table
 
| '''Table
 
| Production.ProductProductPhoto
 
| Production.ProductProductPhoto
−
|-
+
|- valign="top"
−
 
 
 
| '''Description
 
| '''Description
 
| Cross-reference table mapping products and product photos.
 
| Cross-reference table mapping products and product photos.
 
|-
 
|-
−
 
 
|}
 
|}
  
Line 93: Line 118:
 
| not null
 
| not null
 
|  
 
|  
−
| Product identification number. Foreign key to Product.ProductID.PK_ProductProductPhoto_ProductID_ProductPhotoID
+
| Product identification number. Foreign key to Product.ProductID.<br />PK_ProductProductPhoto_ProductID_ProductPhotoID
 
|- valign="top"
 
|- valign="top"
 
| ProductPhotoID
 
| ProductPhotoID
Line 99: Line 124:
 
| not null
 
| not null
 
|  
 
|  
−
| Product photo identification number. Foreign key to ProductPhoto.ProductPhotoID.PK_ProductProductPhoto_ProductID_ProductPhotoID
+
| Product photo identification number. Foreign key to ProductPhoto.ProductPhotoID.<br />PK_ProductProductPhoto_ProductID_ProductPhotoID
 
|- valign="top"
 
|- valign="top"
 
| Primary
 
| Primary
Line 105: Line 130:
 
| not null
 
| not null
 
| (0)
 
| (0)
−
| 0 = Photo is not the principal image. 1 = Photo is the principal image.
+
| 0 = Photo is not the principal image. 1 = Photo is the principal image.<br />
 
|- valign="top"
 
|- valign="top"
 
| ModifiedDate
 
| ModifiedDate
Line 111: Line 136:
 
| not null
 
| not null
 
| (GETDATE())
 
| (GETDATE())
−
| Date and time the record was last updated.
+
| Date and time the record was last updated.<br />
 
|}
 
|}
  
Line 135: Line 160:
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|- style="background:silver"
 
|- style="background:silver"
 +
| '''Dependency Type
 +
| '''Object Type
 
| '''Referenced Object
 
| '''Referenced Object
−
| '''Object Type
+
 
−
| '''Dependency Type
 
−
 
 
|-
 
|-
 +
| Data Type
 +
| Type
 
| [[dbo.Flag_(type)|dbo.Flag]]
 
| [[dbo.Flag_(type)|dbo.Flag]]
−
| Type
+
 
−
| Data Type
+
|-
 +
| Schema
 +
| Schema
 +
| [[Production_(schema)|Production]]
 +
 
 
|}
 
|}

Latest revision as of 00:16, 24 June 2010

wikibot[edit]

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

Columns[edit]

Column Data Type Nullable Default Description
ProductID int not null Product identification number. Foreign key to Product.ProductID.
ProductPhotoID int not null Product photo identification number. Foreign key to ProductPhoto.ProductPhotoID.
Primary dbo.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.

Primary Key[edit]

Primary Key Columns
PK_ProductProductPhoto_ProductID_ProductPhotoID ProductID, ProductPhotoID

Foreign Keys[edit]

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

References[edit]

Dependency Type Object Type Referenced Object
Data Type Type dbo.Flag
Schema Schema Production


automatically generated[edit]

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


Dependency Type Object Type Referenced Object
Data Type Type dbo.Flag
Schema Schema Production
Retrieved from "http://dbshelp.devio.at/index.php?title=Production.ProductProductPhoto_(table)&oldid=2639"