[dbo].[si_ci

Property	Value
Collation	SQL_Latin1_General_CP1_CS_AS
Row Count	898
Created	11:07:30 AM Wednesday, March 07, 2007
Last Modified	5:09:45 AM Tuesday, December 01, 2009

	Name	Data Type	Max Length (Bytes)
$Cluster Primary Key $si_ci_u000014e700000000: ci_uuid\data_source$	ci_uuid	binary(16)	16
$Indexes IX_si_ci_prop_1: parent_uuid\vendor_name$	parent_uuid	binary(16)	16
$Indexes IX_si_ci_prop_3: ci_family\vendor_name$ $Indexes IX_si_ci_prop_1: parent_uuid\vendor_name$	vendor_name	nvarchar(100)	200
	manufacturer_name	nvarchar(100)	200
$Indexes IX_si_ci_prop_2: uam_dom_id\uam_uid$	uam_dom_id	int	4
$Indexes IX_si_ci_prop_2: uam_dom_id\uam_uid$	uam_uid	int	4
	ci_name	nvarchar(100)	200
	ci_class	nvarchar(100)	200
$Indexes IX_si_ci_prop_3: ci_family\vendor_name$	ci_family	nvarchar(100)	200
	active	int	4
$Cluster Primary Key $si_ci_u000014e700000000: ci_uuid\data_source$	data_source	varchar(256)	256
	arg_cost	money	8
	arg_payment	money	8
	arg_expired_doc	int	4

	Name	Columns
$Cluster Primary Key $si_ci_u000014e700000000: ci_uuid\data_source$	$si_ci_u000014e700000000	ci_uuid, data_source
	baseidx_si_ci_prop	ci_uuid
	IX_si_ci_prop_1	parent_uuid, vendor_name
	IX_si_ci_prop_2	uam_dom_id, uam_uid
	IX_si_ci_prop_3	ci_family, vendor_name

Type	Action	Owning Principal
Grant	Insert	aiuser
Grant	Delete	aiadmin
Grant	Insert	aiadmin
Grant	Delete	siadmins
Grant	Insert	siadmins
Grant	Delete	aiuser
Grant	Select	aiadmin
Grant	Update	aiadmin
Grant	Select	aipublic
Grant	Select	siadmins
Grant	Update	siadmins
Grant	Select	aiuser
Grant	Update	aiuser

SQL Script

CREATE TABLE [dbo].[si_ci_prop]
(
[ci_uuid] [binary] (16) NOT NULL,
[parent_uuid] [binary] (16) NULL,
[vendor_name] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[manufacturer_name] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[uam_dom_id] [int] NULL,
[uam_uid] [int] NULL,
[ci_name] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[ci_class] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[ci_family] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[active] [int] NULL,
[data_source] [varchar] (256) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[arg_cost] [money] NULL,
[arg_payment] [money] NULL,
[arg_expired_doc] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[si_ci_prop] ADD CONSTRAINT [$si_ci_u000014e700000000] PRIMARY KEY CLUSTERED ([ci_uuid], [data_source]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_si_ci_prop_3] ON [dbo].[si_ci_prop] ([ci_family], [vendor_name]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [baseidx_si_ci_prop] ON [dbo].[si_ci_prop] ([ci_uuid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_si_ci_prop_1] ON [dbo].[si_ci_prop] ([parent_uuid], [vendor_name]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_si_ci_prop_2] ON [dbo].[si_ci_prop] ([uam_dom_id], [uam_uid]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[si_ci_prop] TO [aiadmin]
GRANT INSERT ON  [dbo].[si_ci_prop] TO [aiadmin]
GRANT DELETE ON  [dbo].[si_ci_prop] TO [aiadmin]
GRANT UPDATE ON  [dbo].[si_ci_prop] TO [aiadmin]
GRANT SELECT ON  [dbo].[si_ci_prop] TO [aipublic]
GRANT SELECT ON  [dbo].[si_ci_prop] TO [aiuser]
GRANT INSERT ON  [dbo].[si_ci_prop] TO [aiuser]
GRANT DELETE ON  [dbo].[si_ci_prop] TO [aiuser]
GRANT UPDATE ON  [dbo].[si_ci_prop] TO [aiuser]
GRANT SELECT ON  [dbo].[si_ci_prop] TO [siadmins]
GRANT INSERT ON  [dbo].[si_ci_prop] TO [siadmins]
GRANT DELETE ON  [dbo].[si_ci_prop] TO [siadmins]
GRANT UPDATE ON  [dbo].[si_ci_prop] TO [siadmins]
GO