iVend Database Database : RepReplicationTransactionMobile Table

Creation Date

4/13/2015 12:00 PM

File Group

PRIMARY

Text File Group

System Object

Published for Replication

Rows

11

Data Space Used

8.00 KB

Index Space Used

24.00 KB

Column Name

Description

Datatype

Length

Allow Nulls

Default

Formula

ReplicationTransactionMobileKey

Primary Key for the table

BigInt

8

([SequenceNo])

SourceType

Refers to the Object Id of the record to be replicated.

Integer

4

SourceKey

Refers to the Primary Key of the record to be replicated.

VarWChar

50

OperationType

Value is the Operation performed for this replication

SmallInt

2

SequenceNo

Refers to the Last Send Dump Sequence Number that was successfully received from the Sending site.

BigInt

8

ProcessDate

Value is the datetime on which the replication record is processed

DBTimeStamp

4

(getdate())

Index

Description

Primary

Unique

IX_RepReplicationTransactionMobile

PK_RepReplicationTransactionMobile

Database Object

Object Type

Description

Dep Level

DataNotification

Stored Procedure

1

GetMobileReplicationData

Stored Procedure

1

ReplicationMobileMonitor

Stored Procedure

1

Trg_ReplicationTransactionMobile

Trigger

1

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[RepReplicationTransactionMobile](

[ReplicationTransactionMobileKey] AS ([SequenceNo]),

[SourceType] [int] NOT NULL,

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

[OperationType] [smallint] NOT NULL,

[SequenceNo] [bigint] IDENTITY(1,1) NOT NULL,

[ProcessDate] [datetime] NULL,

CONSTRAINT [PK_RepReplicationTransactionMobile] PRIMARY KEY CLUSTERED

(

[SequenceNo] 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].[RepReplicationTransactionMobile] ADD CONSTRAINT [DF_RepReplicationTransactionMobile_ProcessDate] DEFAULT (getdate()) FOR [ProcessDate]