iVend Database Database : RepServiceState 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

StateKey

Not in Use

VarWChar

50

State

Not in Use

Integer

4

TimeStamp

Not in Use

DBTimeStamp

4

(getdate())

Index

Description

Primary

Unique

PK__RepServi__BA21C64E11AA861D

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[RepServiceState](

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

[State] [int] NOT NULL,

[TimeStamp] [datetime] NOT NULL,

CONSTRAINT [PK__RepServi__BA21C64E11AA861D] PRIMARY KEY CLUSTERED

(

[StateKey] 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].[RepServiceState] ADD CONSTRAINT [DF_RepServiceState_TimeStamp] DEFAULT (getdate()) FOR [TimeStamp]