iVend Database Database : RtlManagementConsole Table

Creation Date

4/13/2015 12:00 PM

File Group

PRIMARY

Text File Group

System Object

Published for Replication

Rows

3

Data Space Used

8.00 KB

Index Space Used

8.00 KB

Column Name

Description

Datatype

Length

Allow Nulls

Default

Formula

InformationKey

Value is the system generated Primary Key of the table.

VarWChar

50

SiteId

Site id for which this information is applied to. Prefix have to be unique for each site for each Source type

VarWChar

50

MachineId

Machine ID where the Management Console is registered

VarWChar

200

HardwareId

Value is the Hardware Id of the machine to which this Management Consoole is attached. Management Console can be attached and run at a single machine only

VarWChar

200

IsActive

Value is true if the Registered Management Console is Active

Boolean

1

((1))

RegistrationDate

Specifies the Date on which the Management Console is Registered

DBTimeStamp

4

CurrentVersion

Refers to the Current Version of the Management console at Store with the Hardware id

VarWChar

50

IsAddOnUpdated

Value is True if the AddOn has been updated

Boolean

1

((0))

Id

Value is the ID of the Management Console

VarWChar

100

Description

Value is the description of the Management Console

VarWChar

100

HasLicense

Value is true if the User is assigned a license

Boolean

1

((0))

PatchVersion

Stores updated patch version on management console.

Numeric

9 (20,5)

((0))

Index

Description

Primary

Unique

PK_RtlManagementConsoleInfo

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[RtlManagementConsole](

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

[SiteId] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[MachineId] [nvarchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[HardwareId] [nvarchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[IsActive] [bit] NULL,

[RegistrationDate] [datetime] NULL,

[CurrentVersion] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[IsAddOnUpdated] [bit] NULL,

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

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

[HasLicense] [bit] NOT NULL,

[PatchVersion] [decimal](20, 5) NOT NULL,

CONSTRAINT [PK_RtlManagementConsoleInfo] PRIMARY KEY CLUSTERED

(

[InformationKey] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]

ALTER TABLE [dbo].[RtlManagementConsole] ADD CONSTRAINT [DF_RtlManagementConsoleInfo_IsActive] DEFAULT ((1)) FOR [IsActive]

ALTER TABLE [dbo].[RtlManagementConsole] ADD CONSTRAINT [DF_RtlManagementConsole_IsAddOnUpdated] DEFAULT ((0)) FOR [IsAddOnUpdated]

ALTER TABLE [dbo].[RtlManagementConsole] ADD CONSTRAINT [DF_RtlManagementConsole_HasLicense] DEFAULT ((0)) FOR [HasLicense]

ALTER TABLE [dbo].[RtlManagementConsole] ADD CONSTRAINT [DF__RtlManage__Patch__46E85563] DEFAULT ((0)) FOR [PatchVersion]