• lsrep17 Documentation
    • Tables [Production].[ProductPhoto]
    expanded
    MS_Description
    Product images.
    expanded
    Properties
    PropertyValue
    CollationSQL_Latin1_General_CP1_CI_AS
    Row Count (~)101
    Created13:14:19 14 marca 2012
    Last Modified13:14:54 14 marca 2012
    expanded
    Columns
    KeyNameData TypeMax Length (Bytes)Allow NullsIdentityDefaultDescription
    Cluster Primary Key PK_ProductPhoto_ProductPhotoID: ProductPhotoIDProductPhotoIDint4
    False
    		1 - 1Primary key for ProductPhoto records.
    ThumbNailPhotovarbinary(max)max
    True
    		Small image of the product.
    ThumbnailPhotoFileNamenvarchar(50)100
    True
    		Small image file name.
    LargePhotovarbinary(max)max
    True
    		Large image of the product.
    LargePhotoFileNamenvarchar(50)100
    True
    		Large image file name.
    ModifiedDatedatetime8
    False
    		(getdate())Date and time the record was last updated.
    expanded
    Indexes
    KeyNameKey ColumnsUniqueDescription
    Cluster Primary Key PK_ProductPhoto_ProductPhotoID: ProductPhotoIDPK_ProductPhoto_ProductPhotoIDProductPhotoID
    True
    		Primary key (clustered) constraint
    expanded
    SQL Script
    CREATE TABLE [Production].[ProductPhoto]
    (
    [ProductPhotoID] [int] NOT NULL IDENTITY(1, 1),
    [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 [DF_ProductPhoto_ModifiedDate] DEFAULT (getdate())
    ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
    GO
    ALTER TABLE [Production].[ProductPhoto] ADD CONSTRAINT [PK_ProductPhoto_ProductPhotoID] PRIMARY KEY CLUSTERED  ([ProductPhotoID]) ON [PRIMARY]
    GO
    EXEC sp_addextendedproperty N'MS_Description', N'Product images.', 'SCHEMA', N'Production', 'TABLE', N'ProductPhoto', NULL, NULL
    GO
    EXEC sp_addextendedproperty N'MS_Description', N'Large image of the product.', 'SCHEMA', N'Production', 'TABLE', N'ProductPhoto', 'COLUMN', N'LargePhoto'
    GO
    EXEC sp_addextendedproperty N'MS_Description', N'Large image file name.', 'SCHEMA', N'Production', 'TABLE', N'ProductPhoto', 'COLUMN', N'LargePhotoFileName'
    GO
    EXEC sp_addextendedproperty N'MS_Description', N'Date and time the record was last updated.', 'SCHEMA', N'Production', 'TABLE', N'ProductPhoto', 'COLUMN', N'ModifiedDate'
    GO
    EXEC sp_addextendedproperty N'MS_Description', N'Primary key for ProductPhoto records.', 'SCHEMA', N'Production', 'TABLE', N'ProductPhoto', 'COLUMN', N'ProductPhotoID'
    GO
    EXEC sp_addextendedproperty N'MS_Description', N'Small image of the product.', 'SCHEMA', N'Production', 'TABLE', N'ProductPhoto', 'COLUMN', N'ThumbNailPhoto'
    GO
    EXEC sp_addextendedproperty N'MS_Description', N'Small image file name.', 'SCHEMA', N'Production', 'TABLE', N'ProductPhoto', 'COLUMN', N'ThumbnailPhotoFileName'
    GO
    EXEC sp_addextendedproperty N'MS_Description', N'Default constraint value of GETDATE()', 'SCHEMA', N'Production', 'TABLE', N'ProductPhoto', 'CONSTRAINT', N'DF_ProductPhoto_ModifiedDate'
    GO
    EXEC sp_addextendedproperty N'MS_Description', N'Primary key (clustered) constraint', 'SCHEMA', N'Production', 'TABLE', N'ProductPhoto', 'CONSTRAINT', N'PK_ProductPhoto_ProductPhotoID'
    GO
    EXEC sp_addextendedproperty N'MS_Description', N'Clustered index created by a primary key constraint.', 'SCHEMA', N'Production', 'TABLE', N'ProductPhoto', 'INDEX', N'PK_ProductPhoto_ProductPhotoID'
    GO
    expanded
    Uses
    expanded
    Used By