iVend Database Database : CfgAlertSchedule Table

Creation Date

9/18/2015 10:05 AM

File Group

PRIMARY

Text File Group

System Object

Published for Replication

Rows

0

Data Space Used

0.00 KB

Index Space Used

0.00 KB

Column Name

Description

Datatype

Length

Allow Nulls

Default

Formula

AlertScheduleKey

Primary Key for the table.

VarWChar

50

AlertNotificationKey

Reference Key for Alert Notification. See CfgAlertNotification

VarWChar

50

Recurrence

Defines how the the Schedule will be executed repeatedly. 0 - NoRepeat, 1 - Minute, 2 - Hourly, 3 - Daily, 4 - Weekly, 5 - Weekdays, 6 - Monthly, 7 - Yearly, 8 - ForEvery

Integer

4

IntervalType

Type of Interval when Recurrence is 8 - ForEvery. 0 -None, 1 - Minutes, 2 - Hours, 3 - Days, 4 - Weeks, 5 - Months

Integer

4

Interval

Interval value with Interval Type

Integer

4

EndType

When the schedule will stop the execution if the schedule. 0 - NoEnd , 1 - AfterRepeatingSpecifiedTimes, 2 - EndDate

Integer

4

RepeatTimes

When EndType is 1 - AfterRepeatingSpecifiedTimes. How many times the schedule will be executed

Integer

4

EndDate

Value is the End date when the Schedule for the Query will end

DBTimeStamp

4

EndTime

value is the End time when the Schedule for the Query will end

DBTimeStamp

4

CreatedBy

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

VarWChar

50

Created

Date of creation of this record

DBTimeStamp

4

ModifiedBy

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

VarWChar

50

Modified

Date of last modification of this record

DBTimeStamp

4

IsDeleted

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

Boolean

1

((0))

StartDate

Value is the Start Date, from which the Query will start processing

DBTimeStamp

4

StartTime

Value is the Start Time, from which the Query will start processing

DBTimeStamp

4

OnSunday

Stores the On sunday for Schedule

Boolean

1

OnMonday

Stores the On monday for Schedule

Boolean

1

OnTuesday

Stores the On tuesday for Schedule

Boolean

1

OnWednesday

Stores the On wednesday for Schedule

Boolean

1

OnThursday

Stores the On thursday for Schedule

Boolean

1

OnFriday

Stores the On friday for Schedule

Boolean

1

OnSaturday

Stores the On saturday for Schedule

Boolean

1

Index

Description

Primary

Unique

PK_cfgAlertSchedule

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[CfgAlertSchedule](

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

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

[Recurrence] [int] NULL,

[IntervalType] [int] NULL,

[Interval] [int] NULL,

[EndType] [int] NULL,

[RepeatTimes] [int] NULL,

[EndDate] [datetime] NULL,

[EndTime] [datetime] NULL,

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

[Created] [datetime] NULL,

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

[Modified] [datetime] NULL,

[IsDeleted] [bit] NOT NULL,

[StartDate] [datetime] NULL,

[StartTime] [datetime] NULL,

[OnSunday] [bit] NULL,

[OnMonday] [bit] NULL,

[OnTuesday] [bit] NULL,

[OnWednesday] [bit] NULL,

[OnThursday] [bit] NULL,

[OnFriday] [bit] NULL,

[OnSaturday] [bit] NULL,

CONSTRAINT [PK_cfgAlertSchedule] PRIMARY KEY CLUSTERED

(

[AlertScheduleKey] 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].[CfgAlertSchedule] ADD CONSTRAINT [DF_cfgAlertSchedule_IsDeleted] DEFAULT ((0)) FOR [IsDeleted]