Properties

Owner:	Production
Creation Date:	04/26/2006
Located On:	PRIMARY
Data Size KB:	2240
Index Size KB:	16
Rows:	101
Description:	Product images.

Columns

		Name	Data Type	Length	NULL	Default	IsIdentity	IsGUID	Description
		ProductPhotoID	int	4					Primary key for ProductPhoto records.
		ThumbNailPhoto	varbinary	-1					Small image of the product.
		ThumbnailPhotoFileName	nvarchar	50					Small image file name.
		LargePhoto	varbinary	-1					Large image of the product.
		LargePhotoFileName	nvarchar	50					Large image file name.
		ModifiedDate	datetime	8		(getdate())			Date and time the record was last updated.

Total: 6 column(s)

Identity column

	Name	Seed	Increment	Not for replication
	ProductPhotoID	1	1

Indexes

	Index	Primary	Unique	Description
	PK_ProductPhoto_ProductPhotoID			Primary key (clustered) constraint

Total: 1 index(es)

Referencing Tables

	Table	Foreign Key	Primary Key or Unique Constraint
	Production.ProductProductPhoto	FK_ProductProductPhoto_ProductPhoto_ProductPhotoID	PK_ProductPhoto_ProductPhotoID

Total: 1 table(s)

Objects that depend on [Production].[ProductPhoto]

	Object Name	Owner	Object Type	Dep Level
	ProductProductPhoto	Production	Table	1

Total: 1 object(s)

SQL

CREATE TABLE [ProductPhoto] (
    [ProductPhotoID] [int] IDENTITY (1, 1) NOT NULL ,
    [ThumbNailPhoto] [varbinary] (-1) NULL ,
    [ThumbnailPhotoFileName] [nvarchar] (50) COLLATE Latin1_General_CS_AS NULL ,
    [LargePhoto] [varbinary] (-1) NULL ,
    [LargePhotoFileName] [nvarchar] (50) COLLATE Latin1_General_CS_AS NULL ,
    [ModifiedDate] [datetime] NOT NULL CONSTRAINT [DF_ProductPhoto_ModifiedDate] DEFAULT (getdate()),
    CONSTRAINT [PK_ProductPhoto_ProductPhotoID] PRIMARY KEY  CLUSTERED
    (
        [ProductPhotoID]
    )  ON [PRIMARY]
) ON [PRIMARY]
GO

See Also

List of tables