Production.ProductPhoto (table) - Revision history

Bot at 22:16, 23 June 2010

2010-06-23T22:16:52Z

2010-02-02T22:05:28Z

2009-12-28T21:55:01Z

2009-11-30T05:59:44Z

2009-11-30T05:35:06Z

2009-11-30T05:24:03Z

2009-11-26T23:13:12Z

2009-11-26T23:10:36Z

2009-11-26T22:57:49Z

2009-11-26T22:27:01Z

@@ Line 2: / Line 2: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
-|-
+|- valign="top"
 | '''Table
 | Production.ProductPhoto
@@ Line 8: / Line 8: @@
 | '''Description
 | Product images.
 |}
 === Columns ===
@@ Line 20: / Line 18: @@
 | '''Default
 | '''Description
-−
 |- valign="top"
 | ProductPhotoID
@@ Line 64: / Line 62: @@
 | '''Primary Key
 | '''Columns
-|-
+|- valign="top"
 | PK_ProductPhoto_ProductPhotoID
 | ProductPhotoID
@@ Line 75: / Line 73: @@
 | '''Column
 | '''Referencing Column
-−
-|-
+|- valign="top"
 | [[Production.ProductProductPhoto_(table)|Production.ProductProductPhoto]]
 | ProductPhotoID
@@ Line 89: / Line 87: @@
 | '''Referenced Object
-|-
+|- valign="top"
 | Schema
 | Schema

@@ Line 12: / Line 12: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 18: / Line 19: @@
 | '''Nullable
 | '''Default
-| '''Description / PK / Index
+| '''Description
 |- valign="top"
@@ Line 25: / Line 26: @@
 | not null
+|
-| Primary key for ProductPhoto records.<br />PK_ProductPhoto_ProductPhotoID
+| Primary key for ProductPhoto records.
 |- valign="top"
 | ThumbNailPhoto
@@ Line 31: / Line 32: @@
 | null
+|
-| Small image of the product.<br />
+| Small image of the product.
 |- valign="top"
 | ThumbnailPhotoFileName
@@ Line 37: / Line 38: @@
 | null
+|
-| Small image file name.<br />
+| Small image file name.
 |- valign="top"
 | LargePhoto
@@ Line 43: / Line 44: @@
 | null
+|
-| Large image of the product.<br />
+| Large image of the product.
 |- valign="top"
 | LargePhotoFileName
@@ Line 49: / Line 50: @@
 | null
+|
-| Large image file name.<br />
+| Large image file name.
 |- valign="top"
 | ModifiedDate
@@ Line 55: / Line 56: @@
 | not null
 | (getdate())
-| Date and time the record was last updated.<br />
+| Date and time the record was last updated.
 |}
+=== Detail Tables ===
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 72: / Line 82: @@
 |}

@@ Line 5: / Line 5: @@
 | '''Table
 | Production.ProductPhoto
 |-
 |}
@@ Line 15: / Line 18: @@
 | '''Nullable
 | '''Default
-| '''PK
+| '''Description / PK / Index
-|-
+|- valign="top"
 | ProductPhotoID
 | int
 | not null
+|
-| PK_ProductPhoto_ProductPhotoID
+| Primary key for ProductPhoto records.<br />PK_ProductPhoto_ProductPhotoID
+|- valign="top"
 | ThumbNailPhoto
 | varbinary(max)
 | null
+|
+| Small image of the product.<br />
+|- valign="top"
 | ThumbnailPhotoFileName
 | nvarchar(50)
 | null
+|
+| Small image file name.<br />
+|- valign="top"
 | LargePhoto
 | varbinary(max)
 | null
+|
+| Large image of the product.<br />
+|- valign="top"
 | LargePhotoFileName
 | nvarchar(50)
 | null
+|
+| Large image file name.<br />
+|- valign="top"
 | ModifiedDate
 | datetime
 | not null
 | (getdate())
+| Date and time the record was last updated.<br />
 |}
@@ Line 75: / Line 71: @@
 | ProductPhotoID
 |}
 == automatically generated ==

@@ Line 82: / Line 82: @@
 | Production.ProductPhoto
 |- valign="top"
 | '''Description
 | Product images.
 |-
 |}

@@ Line 153: / Line 153: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
 | '''Referenced Object
 |-
 | Schema
 | Schema
 |}