[dbo].[si_cnt_org

Property	Value
Collation	SQL_Latin1_General_CP1_CS_AS
Row Count	0
Created	11:07:31 AM Wednesday, March 07, 2007
Last Modified	6:29:07 PM Tuesday, May 05, 2009

	Name	Data Type	Max Length (Bytes)
$Cluster Primary Key $si_cn_u000014ef00000000: org_uuid\cnt_uuid\data_source$ $Indexes ix_si_cnt_org_rel_1: rel_org_name\rel_org_location\org_uuid$	org_uuid	binary(16)	16
$Cluster Primary Key $si_cn_u000014ef00000000: org_uuid\cnt_uuid\data_source$	cnt_uuid	binary(16)	16
	contact_name	nvarchar(100)	200
$Indexes ix_si_cnt_org_rel_1: rel_org_name\rel_org_location\org_uuid$	rel_org_name	nvarchar(100)	200
$Indexes ix_si_cnt_org_rel_1: rel_org_name\rel_org_location\org_uuid$	rel_org_location	nvarchar(100)	200
$Cluster Primary Key $si_cn_u000014ef00000000: org_uuid\cnt_uuid\data_source$	data_source	varchar(256)	256

	Name	Columns
$Cluster Primary Key $si_cn_u000014ef00000000: org_uuid\cnt_uuid\data_source$	$si_cn_u000014ef00000000	org_uuid, cnt_uuid, data_source
	baseidx_si_cnt_org_rel	cnt_uuid
	ix_si_cnt_org_rel_1	rel_org_name, rel_org_location, org_uuid
	xif2si_cnt_org_rel	org_uuid

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

SQL Script

CREATE TABLE [dbo].[si_cnt_org_rel]
(
[org_uuid] [binary] (16) NOT NULL,
[cnt_uuid] [binary] (16) NOT NULL,
[contact_name] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[rel_org_name] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[rel_org_location] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[data_source] [varchar] (256) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[si_cnt_org_rel] ADD CONSTRAINT [$si_cn_u000014ef00000000] PRIMARY KEY CLUSTERED ([org_uuid], [cnt_uuid], [data_source]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [baseidx_si_cnt_org_rel] ON [dbo].[si_cnt_org_rel] ([cnt_uuid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [xif2si_cnt_org_rel] ON [dbo].[si_cnt_org_rel] ([org_uuid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ix_si_cnt_org_rel_1] ON [dbo].[si_cnt_org_rel] ([rel_org_name], [rel_org_location], [org_uuid]) ON [PRIMARY]
GO
GRANT REFERENCES ON  [dbo].[si_cnt_org_rel] TO [aiadmin]
GRANT SELECT ON  [dbo].[si_cnt_org_rel] TO [aiadmin]
GRANT INSERT ON  [dbo].[si_cnt_org_rel] TO [aiadmin]
GRANT DELETE ON  [dbo].[si_cnt_org_rel] TO [aiadmin]
GRANT UPDATE ON  [dbo].[si_cnt_org_rel] TO [aiadmin]
GRANT SELECT ON  [dbo].[si_cnt_org_rel] TO [aipublic]
GRANT REFERENCES ON  [dbo].[si_cnt_org_rel] TO [aiuser]
GRANT SELECT ON  [dbo].[si_cnt_org_rel] TO [aiuser]
GRANT INSERT ON  [dbo].[si_cnt_org_rel] TO [aiuser]
GRANT DELETE ON  [dbo].[si_cnt_org_rel] TO [aiuser]
GRANT UPDATE ON  [dbo].[si_cnt_org_rel] TO [aiuser]
GRANT SELECT ON  [dbo].[si_cnt_org_rel] TO [siadmins]
GRANT INSERT ON  [dbo].[si_cnt_org_rel] TO [siadmins]
GRANT DELETE ON  [dbo].[si_cnt_org_rel] TO [siadmins]
GRANT UPDATE ON  [dbo].[si_cnt_org_rel] TO [siadmins]
GO