iVend Database Database : ProPromotionApplicabilityMaster Table

Creation Date

4/13/2015 12:00 PM

File Group

PRIMARY

Text File Group

System Object

Published for Replication

Rows

14

Data Space Used

8.00 KB

Index Space Used

24.00 KB

Column Name

Description

Datatype

Length

Allow Nulls

Default

Formula

PromotionApplicabilityKey

Primary Key

VarWChar

50

SourceType

Stores the value for the Promotion Applicability Valid Values are BonusBuys = 0 Coupon = 1

Integer

4

SourceKey

Refers to the source key of the chosen promotion applicability

VarWChar

50

Sunday

Value is True if the promotion is applicable on Sunday

Boolean

1

SundayStartTime

Stores the start time for the promotion on Sunday

DBTimeStamp

4

SundayEndTime

Stores the End time for the promotion on Sunday

DBTimeStamp

4

Monday

Value is True if the promotion is applicable on Monday

Boolean

1

MondayStartTime

Stores the start time for the promotion on Monday

DBTimeStamp

4

MondayEndTime

Stores the End time for the promotion on Monday

DBTimeStamp

4

Tuesday

Value is True if the promotion is applicable on Tuesday

Boolean

1

TuesdayStartTime

Stores the start time for the promotion on Tuesday

DBTimeStamp

4

TuesdayEndTime

Stores the End time for the promotion on Tuesday

DBTimeStamp

4

Wednesday

Value is True if the promotion is applicable on Wednesday

Boolean

1

WednesdayStartTime

Stores the start time for the promotion on Wednesday

DBTimeStamp

4

WednesdayEndTime

Stores the End time for the promotion on Wednesday

DBTimeStamp

4

Thrusday

Value is True if the promotion is applicable on Thursday

Boolean

1

ThrusdayStartTime

Stores the start time for the promotion on Thursday

DBTimeStamp

4

ThrusdayEndTime

Stores the End time for the promotion on Thursday

DBTimeStamp

4

Friday

Value is True if the promotion is applicable on Friday

Boolean

1

FridayStartTime

Stores the start time for the promotion on Friday

DBTimeStamp

4

FridayEndTime

Stores the End time for the promotion on Friday

DBTimeStamp

4

Saturday

Value is True if the promotion is applicable on Saturday

Boolean

1

SaturdayStartTime

Stores the start time for the promotion on Saturday

DBTimeStamp

4

SaturdayEndTime

Stores the End time for the promotion on Saturday

DBTimeStamp

4

Index

Description

Primary

Unique

IX_ProPromotionApplicabilityMaster

PK_ProPromotionApplicabilityMaster

Database Object

Object Type

Description

Dep Level

GetValidPromotionsForProduct

Stored Procedure

1

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[ProPromotionApplicabilityMaster](

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

[SourceType] [int] NULL,

[SourceKey] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT 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_ProPromotionApplicabilityMaster] PRIMARY KEY CLUSTERED

(

[PromotionApplicabilityKey] ASC

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

) ON [PRIMARY]