[dbo].[CMSWFPROCESSDATA]

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	0
Created	11:13:51 AM Wednesday, March 07, 2007
Last Modified	11:13:52 AM Wednesday, March 07, 2007

Property

Value

Collation

SQL_Latin1_General_CP1_CI_AS

Row Count

Created

11:13:51 AM Wednesday, March 07, 2007

Last Modified

11:13:52 AM Wednesday, March 07, 2007

	Name	Data Type	Max Length (Bytes)
	UECHECKEDOUT	int	4
	UECHECKEDOUTTIME	datetime	8
$Cluster Primary Key UE107d798c7f7: UEDBID\UEPORINSTANCEID$	UEDBID	int	4
	UEMODTIME	datetime	8
	UENUMEMPTYREQUIRED	int	4
$Cluster Primary Key UE107d798c7f7: UEDBID\UEPORINSTANCEID$	UEPORINSTANCEID	nvarchar(255)	510
	UEPUBSTAGE	int	4
	UEPUBTIME	datetime	8
	UEACTV	varchar(8000)	8000
	UEATTR	varchar(8000)	8000
	UEDESC	nvarchar(1000)	2000
	UENAME	nvarchar(255)	510
	UEOWNER	int	4
	UEPROCDEF	varchar(255)	255
	UESTATE	bit	1
	UESUBJECT	nvarchar(255)	510

Name

Data Type

Max Length (Bytes)

Allow Nulls

UECHECKEDOUT

int

UECHECKEDOUTTIME

datetime

$Cluster Primary Key UE107d798c7f7: UEDBID\UEPORINSTANCEID$

UEDBID

int

UEMODTIME

datetime

UENUMEMPTYREQUIRED

int

$Cluster Primary Key UE107d798c7f7: UEDBID\UEPORINSTANCEID$

UEPORINSTANCEID

nvarchar(255)

510

UEPUBSTAGE

int

UEPUBTIME

datetime

UEACTV

varchar(8000)

8000

UEATTR

varchar(8000)

8000

UEDESC

nvarchar(1000)

2000

UENAME

nvarchar(255)

510

UEOWNER

int

UEPROCDEF

varchar(255)

255

UESTATE

bit

UESUBJECT

nvarchar(255)

510

	Name	Columns	Unique
$Cluster Primary Key UE107d798c7f7: UEDBID\UEPORINSTANCEID$	UE107d798c7f7	UEDBID, UEPORINSTANCEID

Name

Columns

Unique

$Cluster Primary Key UE107d798c7f7: UEDBID\UEPORINSTANCEID$

UE107d798c7f7

UEDBID, UEPORINSTANCEID

Type	Action	Owning Principal
Grant	Delete	portaldba_group
Grant	Insert	portaldba_group
Grant	Select	portaldba_group
Grant	Update	portaldba_group

Type

Action

Owning Principal

Grant

Delete

portaldba_group

Grant

Insert

portaldba_group

Grant

Select

portaldba_group

Grant

Update

portaldba_group

SQL Script

CREATE TABLE [dbo].[CMSWFPROCESSDATA]
(
[UECHECKEDOUT] [int] NULL,
[UECHECKEDOUTTIME] [datetime] NULL,
[UEDBID] [int] NOT NULL,
[UEMODTIME] [datetime] NULL,
[UENUMEMPTYREQUIRED] [int] NULL,
[UEPORINSTANCEID] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[UEPUBSTAGE] [int] NULL,
[UEPUBTIME] [datetime] NULL,
[UEACTV] [varchar] (8000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEATTR] [varchar] (8000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEDESC] [nvarchar] (1000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UENAME] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEOWNER] [int] NULL,
[UEPROCDEF] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UESTATE] [bit] NULL,
[UESUBJECT] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[CMSWFPROCESSDATA] ADD CONSTRAINT [UE107d798c7f7] PRIMARY KEY CLUSTERED ([UEDBID], [UEPORINSTANCEID]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[CMSWFPROCESSDATA] TO [portaldba_group]
GRANT INSERT ON  [dbo].[CMSWFPROCESSDATA] TO [portaldba_group]
GRANT DELETE ON  [dbo].[CMSWFPROCESSDATA] TO [portaldba_group]
GRANT UPDATE ON  [dbo].[CMSWFPROCESSDATA] TO [portaldba_group]
GO