[dbo].[das_correctiveaction]

Property	Value
Collation	SQL_Latin1_General_CP1_CS_AS
Row Count	0
Created	11:07:10 AM Wednesday, March 07, 2007
Last Modified	11:09:08 AM Wednesday, March 07, 2007

Property

Value

Collation

SQL_Latin1_General_CP1_CS_AS

Row Count

Created

11:07:10 AM Wednesday, March 07, 2007

Last Modified

11:09:08 AM Wednesday, March 07, 2007

	Name	Data Type	Max Length (Bytes)
$Cluster Primary Key das_correctiveactionpkey: actionid\recmndid\anlydefid\policyid$	actionid	decimal(10,0)	9
$Cluster Primary Key das_correctiveactionpkey: actionid\recmndid\anlydefid\policyid$	recmndid	decimal(10,0)	9
$Cluster Primary Key das_correctiveactionpkey: actionid\recmndid\anlydefid\policyid$	anlydefid	decimal(10,0)	9
$Cluster Primary Key das_correctiveactionpkey: actionid\recmndid\anlydefid\policyid$	policyid	decimal(10,0)	9
	productcode	varchar(255)	255
	actiontype	decimal(6,0)	5
	commandline	varchar(2048)	2048
	cookie	decimal(15,0)	9
	cookieversion	varchar(255)	255
	textid	varchar(20)	20
	extendedtextid	varchar(20)	20
	usersignoff	int	4
	usersignoffcommts	varchar(512)	512

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Primary Key das_correctiveactionpkey: actionid\recmndid\anlydefid\policyid$

actionid

decimal(10,0)

$Cluster Primary Key das_correctiveactionpkey: actionid\recmndid\anlydefid\policyid$

recmndid

decimal(10,0)

$Cluster Primary Key das_correctiveactionpkey: actionid\recmndid\anlydefid\policyid$

anlydefid

decimal(10,0)

$Cluster Primary Key das_correctiveactionpkey: actionid\recmndid\anlydefid\policyid$

policyid

decimal(10,0)

productcode

varchar(255)

255

actiontype

decimal(6,0)

commandline

varchar(2048)

2048

decimal(15,0)

cookieversion

varchar(255)

255

textid

varchar(20)

extendedtextid

varchar(20)

usersignoff

int

usersignoffcommts

varchar(512)

512

	Name	Columns	Unique
$Cluster Primary Key das_correctiveactionpkey: actionid\recmndid\anlydefid\policyid$	das_correctiveactionpkey	actionid, recmndid, anlydefid, policyid

Name

Columns

Unique

$Cluster Primary Key das_correctiveactionpkey: actionid\recmndid\anlydefid\policyid$

das_correctiveactionpkey

actionid, recmndid, anlydefid, policyid

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

Type

Action

Owning Principal

Grant

Delete

udmadmin_group

Grant

Insert

udmadmin_group

Grant

Select

udmadmin_group

Grant

Update

udmadmin_group

SQL Script

CREATE TABLE [dbo].[das_correctiveaction]
(
[actionid] [decimal] (10, 0) NOT NULL,
[recmndid] [decimal] (10, 0) NOT NULL,
[anlydefid] [decimal] (10, 0) NOT NULL,
[policyid] [decimal] (10, 0) NOT NULL,
[productcode] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[actiontype] [decimal] (6, 0) NULL,
[commandline] [varchar] (2048) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[cookie] [decimal] (15, 0) NULL,
[cookieversion] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[textid] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[extendedtextid] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[usersignoff] [int] NULL,
[usersignoffcommts] [varchar] (512) COLLATE SQL_Latin1_General_CP1_CS_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[das_correctiveaction] ADD CONSTRAINT [das_correctiveactionpkey] PRIMARY KEY CLUSTERED ([actionid], [recmndid], [anlydefid], [policyid]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[das_correctiveaction] TO [udmadmin_group]
GRANT INSERT ON  [dbo].[das_correctiveaction] TO [udmadmin_group]
GRANT DELETE ON  [dbo].[das_correctiveaction] TO [udmadmin_group]
GRANT UPDATE ON  [dbo].[das_correctiveaction] TO [udmadmin_group]
GO