Production.ProductPhoto Table

Description

Product images.

Properties

Creation Date	27/10/2017 14:33
File Group	PRIMARY
Text File Group	PRIMARY
System Object
Published for Replication
Rows	101
Data Space Used	2,280.00 KB
Index Space Used	16.00 KB

Columns

Column Name	Description	Datatype	Length	Default
ProductPhotoID	Primary key for ProductPhoto records.	Integer	4
ThumbNailPhoto	Small image of the product.	LongVarBinary	16
ThumbnailPhotoFileName	Small image file name.	VarWChar	50
LargePhoto	Large image of the product.	LongVarBinary	16
LargePhotoFileName	Large image file name.	VarWChar	50
ModifiedDate	Date and time the record was last updated.	DBTimeStamp	4	(getdate())

Indexes

Index	Description	Primary	Unique
PK_ProductPhoto_ProductPhotoID	Primary key (clustered) constraint

Relationships

Relationship	Description
FK_ProductProductPhoto_ProductPhoto_ProductPhotoID	Foreign key constraint referencing ProductPhoto.ProductPhotoID.

Objects that depend on Production.ProductPhoto

	Database Object	Object Type	Description	Dep Level
	Production.ProductProductPhoto	Table	Cross-reference table mapping products and product photos.	1

SQL

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [Production].[ProductPhoto](
    [ProductPhotoID] [int] IDENTITY(1,1) NOT NULL,
    [ThumbNailPhoto] [varbinary](max) NULL,
    [ThumbnailPhotoFileName] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LargePhoto] [varbinary](max) NULL,
    [LargePhotoFileName] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ModifiedDate] [datetime] NOT NULL,
 CONSTRAINT [PK_ProductPhoto_ProductPhotoID] PRIMARY KEY CLUSTERED 
(
    [ProductPhotoID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

ALTER TABLE [Production].[ProductPhoto] ADD  CONSTRAINT [DF_ProductPhoto_ModifiedDate]  DEFAULT (getdate()) FOR [ModifiedDate]

Related Objects