[dbo].[prob

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	139
Created	11:07:26 AM Wednesday, March 07, 2007
Last Modified	4:36:06 PM Wednesday, March 24, 2010

	Name	Data Type	Max Length (Bytes)
	id	int	4
$Indexes prob_ctg_x2: persid\sym\owning_contract\tenant$ $Indexes prob_ctg_x1: sym\owning_contract\persid$	persid	nvarchar(30)	60
	del	int	4
$Indexes prob_ctg_x2: persid\sym\owning_contract\tenant$ $Indexes prob_ctg_x1: sym\owning_contract\persid$	sym	nvarchar(1000)	2000
	last_mod_dt	int	4
	last_mod_by	binary(16)	16
	description	nvarchar(500)	1000
	organization	binary(16)	16
	assignee	binary(16)	16
	group_id	binary(16)	16
	tcode	int	4
	service_type	nvarchar(30)	60
	survey	int	4
	schedule	int	4
	auto_assign	int	4
$Indexes prob_ctg_x2: persid\sym\owning_contract\tenant$ $Indexes prob_ctg_x1: sym\owning_contract\persid$	owning_contract	int	4
	cr_flag	int	4
	in_flag	int	4
	pr_flag	int	4
	suggest_knowledge	int	4
$Indexes prob_ctg_x2: persid\sym\owning_contract\tenant$	tenant	binary(16)	16
	cawf_defid	nvarchar(40)	80
	zcl_proj_id	nvarchar(100)	200
	zcl_task_id	nvarchar(100)	200
	ss_sym	nvarchar(128)	256
	ss_include	int	4
	assignable_ci_attr	nvarchar(60)	120
	category_urgency	int	4
	caextwf_start_id	int	4
	flow_flag	int	4
	sap_prop	int	4

	Name	Columns	Unique
	XPKprob_ctg	id
	prob_ctg_x1	sym, owning_contract, persid
	prob_ctg_x2	persid, sym, owning_contract, tenant
	prob_ctg_x3	tenant

Type	Action	Owning Principal
Grant	Delete	service_desk_admin_group
Grant	Insert	service_desk_admin_group
Grant	Select	service_desk_admin_group
Grant	Update	service_desk_admin_group
Grant	Select	service_desk_ro_group

SQL Script

CREATE TABLE [dbo].[prob_ctg]
(
[id] [int] NOT NULL,
[persid] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[del] [int] NOT NULL,
[sym] [nvarchar] (1000) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[last_mod_dt] [int] NULL,
[last_mod_by] [binary] (16) NULL,
[description] [nvarchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[organization] [binary] (16) NULL,
[assignee] [binary] (16) NULL,
[group_id] [binary] (16) NULL,
[tcode] [int] NULL,
[service_type] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[survey] [int] NULL,
[schedule] [int] NULL,
[auto_assign] [int] NULL,
[owning_contract] [int] NULL,
[cr_flag] [int] NULL,
[in_flag] [int] NULL,
[pr_flag] [int] NULL,
[suggest_knowledge] [int] NULL,
[tenant] [binary] (16) NULL,
[cawf_defid] [nvarchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[zcl_proj_id] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[zcl_task_id] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ss_sym] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ss_include] [int] NULL,
[assignable_ci_attr] [nvarchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[category_urgency] [int] NULL,
[caextwf_start_id] [int] NULL,
[flow_flag] [int] NULL,
[sap_prop] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[prob_ctg] ADD CONSTRAINT [XPKprob_ctg] PRIMARY KEY CLUSTERED ([id]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [prob_ctg_x2] ON [dbo].[prob_ctg] ([sym], [owning_contract], [tenant]) INCLUDE ([persid]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [prob_ctg_x1] ON [dbo].[prob_ctg] ([persid]) INCLUDE ([owning_contract], [sym]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [prob_ctg_x3] ON [dbo].[prob_ctg] ([tenant]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[prob_ctg] TO [service_desk_admin_group]
GRANT INSERT ON  [dbo].[prob_ctg] TO [service_desk_admin_group]
GRANT DELETE ON  [dbo].[prob_ctg] TO [service_desk_admin_group]
GRANT UPDATE ON  [dbo].[prob_ctg] TO [service_desk_admin_group]
GRANT SELECT ON  [dbo].[prob_ctg] TO [service_desk_ro_group]
GO