[dbo].[si_org

Property	Value
Collation	SQL_Latin1_General_CP1_CS_AS
Row Count	18
Created	11:07:31 AM Wednesday, March 07, 2007
Last Modified	5:05:17 AM Tuesday, December 01, 2009

	Name	Data Type	Max Length (Bytes)
$Cluster Primary Key $si_or_u000014e500000000: org_uuid\data_source$ $Indexes IX_si_org_prop_3: name\org_uuid\manager$ $Indexes IX_si_org_prop_2: parent_org_uuid\org_uuid$ $Indexes IX_si_org_prop_1: primary_contact_name\location\org_uuid$	org_uuid	binary(16)	16
	active	int	4
$Indexes IX_si_org_prop_2: parent_org_uuid\org_uuid$	parent_org_uuid	binary(16)	16
$Indexes IX_si_org_prop_1: primary_contact_name\location\org_uuid$	location	nvarchar(100)	200
	company	nvarchar(100)	200
	cost_center	nvarchar(100)	200
$Indexes IX_si_org_prop_3: name\org_uuid\manager$	name	nvarchar(100)	200
$Indexes IX_si_org_prop_1: primary_contact_name\location\org_uuid$	primary_contact_name	nvarchar(100)	200
	contact_org	nvarchar(100)	200
	contact_loc	nvarchar(100)	200
$Indexes IX_si_org_prop_3: name\org_uuid\manager$	manager	binary(16)	16
$Cluster Primary Key $si_or_u000014e500000000: org_uuid\data_source$	data_source	varchar(256)	256

	Name	Columns
$Cluster Primary Key $si_or_u000014e500000000: org_uuid\data_source$	$si_or_u000014e500000000	org_uuid, data_source
	baseidx_si_org_prop	org_uuid
	IX_si_org_prop_1	primary_contact_name, location, org_uuid
	IX_si_org_prop_2	parent_org_uuid, org_uuid
	IX_si_org_prop_3	name, org_uuid, manager

Type	Action	Owning Principal
Grant	Delete	aiadmin
Grant	Insert	aiadmin
Grant	Delete	siadmins
Grant	Insert	siadmins
Grant	Delete	aiuser
Grant	Insert	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_org_prop]
(
[org_uuid] [binary] (16) NOT NULL,
[active] [int] NULL,
[parent_org_uuid] [binary] (16) NULL,
[location] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[company] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[cost_center] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[name] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[primary_contact_name] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[contact_org] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[contact_loc] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[manager] [binary] (16) NULL,
[data_source] [varchar] (256) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[si_org_prop] ADD CONSTRAINT [$si_or_u000014e500000000] PRIMARY KEY CLUSTERED ([org_uuid], [data_source]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_si_org_prop_3] ON [dbo].[si_org_prop] ([name], [org_uuid], [manager]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [baseidx_si_org_prop] ON [dbo].[si_org_prop] ([org_uuid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_si_org_prop_2] ON [dbo].[si_org_prop] ([parent_org_uuid], [org_uuid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_si_org_prop_1] ON [dbo].[si_org_prop] ([primary_contact_name], [location], [org_uuid]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[si_org_prop] TO [aiadmin]
GRANT INSERT ON  [dbo].[si_org_prop] TO [aiadmin]
GRANT DELETE ON  [dbo].[si_org_prop] TO [aiadmin]
GRANT UPDATE ON  [dbo].[si_org_prop] TO [aiadmin]
GRANT SELECT ON  [dbo].[si_org_prop] TO [aipublic]
GRANT SELECT ON  [dbo].[si_org_prop] TO [aiuser]
GRANT INSERT ON  [dbo].[si_org_prop] TO [aiuser]
GRANT DELETE ON  [dbo].[si_org_prop] TO [aiuser]
GRANT UPDATE ON  [dbo].[si_org_prop] TO [aiuser]
GRANT SELECT ON  [dbo].[si_org_prop] TO [siadmins]
GRANT INSERT ON  [dbo].[si_org_prop] TO [siadmins]
GRANT DELETE ON  [dbo].[si_org_prop] TO [siadmins]
GRANT UPDATE ON  [dbo].[si_org_prop] TO [siadmins]
GO