iVend Database Database : CfgPOSButtonStyle Table

Creation Date

7/20/2016 11:39 AM

File Group

PRIMARY

Text File Group

PRIMARY

System Object

Published for Replication

Rows

17

Data Space Used

8.00 KB

Index Space Used

8.00 KB

Column Name

Description

Datatype

Length

Allow Nulls

Default

Formula

POSButtonStyleKey

System generated Primary key of the table.

VarWChar

50

Id

Refers to the POSButtonStyle code.

VarWChar

20

Description

Refers to the style's description.

VarWChar

100

FontName

Refers to the name of the font to be set for style.

VarWChar

100

FontSize

Refers to the size of the font to be set for style.

Integer

4

FontBold

Flag to check whether Font would be bold or not.

Boolean

1

ForeColor

Refers to the Fore Color to be set for style.

Integer

4

BackColor

Specifies the back color to be set for style.

Integer

4

FontItalic

Flag to check whether Font would be italic or not.

Boolean

1

BackColor2

Specifies the back color2 to be set for style.

Integer

4

GradientMode

Specifies the Gradient Mode to be set for style.

Integer

4

Created

Date of creation of this record

DBTimeStamp

4

Modified

Date of last modification of this record

DBTimeStamp

4

CreatedBy

Reference of user who has created this record. See also Security User

VarWChar

50

ModifiedBy

Reference of user who has modified this record. See also Security User

VarWChar

50

IsDeleted

Value is True if the record has been deleted from the system. Record is always Soft Deleted

Boolean

1

FontUnderline

Flag to check whether Font would be underline or not.

Boolean

1

FontStrikethrough

Flag to check whether Font would be strikethrough or not.

Boolean

1

HasGradient

Flag to check whether Style would have gradient or not.

Boolean

1

Image

Refers to the image to be set for the style.

LongVarBinary

16

ImageLocation

Refers to the location of image.

Integer

4

Index

Description

Primary

Unique

PK__CfgCusto__D43B6ABFC2F6758B

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[CfgPOSButtonStyle](

[POSButtonStyleKey] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

[Id] [nvarchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

[Description] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[FontName] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

[FontSize] [int] NULL,

[FontBold] [bit] NOT NULL,

[ForeColor] [int] NOT NULL,

[BackColor] [int] NOT NULL,

[FontItalic] [bit] NOT NULL,

[BackColor2] [int] NOT NULL,

[GradientMode] [int] NULL,

[Created] [datetime] NOT NULL,

[Modified] [datetime] NOT NULL,

[CreatedBy] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

[ModifiedBy] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

[IsDeleted] [bit] NOT NULL,

[FontUnderline] [bit] NOT NULL,

[FontStrikethrough] [bit] NOT NULL,

[HasGradient] [bit] NOT NULL,

[Image] [image] NULL,

[ImageLocation] [int] NULL,

CONSTRAINT [PK__CfgCusto__D43B6ABFC2F6758B] PRIMARY KEY CLUSTERED

(

[POSButtonStyleKey] 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]