iVend Database Database : LoyPlanApplicability Table

Creation Date

4/13/2015 12:00 PM

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

PlanApplicabilityKey

Primary Key

VarWChar

50

PlanKey

Reference Key of Plan. See also Plan.

VarWChar

50

Sunday

Value is true if plan is applicable on Sunday

Boolean

1

SundayStartTime

Specify the start time

DBTimeStamp

4

SundayEndTime

Specify the end time

DBTimeStamp

4

Monday

Value is true if plan is applicable on Monday

Boolean

1

MondayStartTime

Specify the start time

DBTimeStamp

4

MondayEndTime

Specify the end time

DBTimeStamp

4

Tuesday

Value is true if plan is applicable on Tuesday

Boolean

1

TuesdayStartTime

Specify the start time

DBTimeStamp

4

TuesdayEndTime

Specify the end time

DBTimeStamp

4

Wednesday

Value is true if plan is applicable on Wednesday

Boolean

1

WednesdayStartTime

Specify the start time

DBTimeStamp

4

WednesdayEndTime

Specify the end time

DBTimeStamp

4

Thrusday

Value is true if plan is applicable on Thrusday

Boolean

1

ThrusdayStartTime

Specify the start time

DBTimeStamp

4

ThrusdayEndTime

Specify the end time

DBTimeStamp

4

Friday

Value is true if plan is applicable on Friday

Boolean

1

FridayStartTime

Specify the start time

DBTimeStamp

4

FridayEndTime

Specify the end time

DBTimeStamp

4

Saturday

Value is true if plan is applicable on Saturday

Boolean

1

SaturdayStartTime

Specify the start time

DBTimeStamp

4

SaturdayEndTime

Specify the end time

DBTimeStamp

4

Index

Description

Primary

Unique

PK_LoyPlanApplicability

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[LoyPlanApplicability](

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

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

[Sunday] [bit] NOT NULL,

[SundayStartTime] [datetime] NULL,

[SundayEndTime] [datetime] NULL,

[Monday] [bit] NOT NULL,

[MondayStartTime] [datetime] NULL,

[MondayEndTime] [datetime] NULL,

[Tuesday] [bit] NOT NULL,

[TuesdayStartTime] [datetime] NULL,

[TuesdayEndTime] [datetime] NULL,

[Wednesday] [bit] NOT NULL,

[WednesdayStartTime] [datetime] NULL,

[WednesdayEndTime] [datetime] NULL,

[Thrusday] [bit] NOT NULL,

[ThrusdayStartTime] [datetime] NULL,

[ThrusdayEndTime] [datetime] NULL,

[Friday] [bit] NOT NULL,

[FridayStartTime] [datetime] NULL,

[FridayEndTime] [datetime] NULL,

[Saturday] [bit] NOT NULL,

[SaturdayStartTime] [datetime] NULL,

[SaturdayEndTime] [datetime] NULL,

CONSTRAINT [PK_LoyPlanApplicability] PRIMARY KEY CLUSTERED

(

[PlanApplicabilityKey] ASC

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

) ON [PRIMARY]