[dbo].[si_contact

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

Property

Value

Collation

SQL_Latin1_General_CP1_CS_AS

Row Count

374

Created

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

Last Modified

5:05:16 AM Tuesday, December 01, 2009

	Name	Data Type	Max Length (Bytes)
$Cluster Primary Key $si_co_u000014e300000000: contact_uuid\data_source$ $Indexes XAK3si_contact_prop: active\location\type\contact_uuid$ $Indexes XAK4si_contact_prop: active\type\combo_name\contact_uuid$ $Indexes XAK1si_contact_prop: location\combo_name\contact_uuid$ $Indexes XAK5si_contact_prop: uspsd_org_name\combo_name\contact_uuid$ $Indexes XAK2si_contact_prop: uspsd_org_uuid\usi_org_uuid\manager_uuid\contact_uuid$	contact_uuid	binary(16)	16
$Indexes XAK4si_contact_prop: active\type\combo_name\contact_uuid$ $Indexes XAK1si_contact_prop: location\combo_name\contact_uuid$ $Indexes XAK5si_contact_prop: uspsd_org_name\combo_name\contact_uuid$	combo_name	nvarchar(100)	200
$Indexes XAK2si_contact_prop: uspsd_org_uuid\usi_org_uuid\manager_uuid\contact_uuid$	manager_uuid	binary(16)	16
	manager_name	nvarchar(100)	200
$Indexes XAK3si_contact_prop: active\location\type\contact_uuid$ $Indexes XAK4si_contact_prop: active\type\combo_name\contact_uuid$	type	nvarchar(100)	200
$Indexes XAK2si_contact_prop: uspsd_org_uuid\usi_org_uuid\manager_uuid\contact_uuid$	uspsd_org_uuid	binary(16)	16
$Indexes XAK3si_contact_prop: active\location\type\contact_uuid$ $Indexes XAK1si_contact_prop: location\combo_name\contact_uuid$	location	nvarchar(100)	200
$Indexes XAK2si_contact_prop: uspsd_org_uuid\usi_org_uuid\manager_uuid\contact_uuid$	usi_org_uuid	binary(16)	16
$Indexes XAK5si_contact_prop: uspsd_org_name\combo_name\contact_uuid$	uspsd_org_name	nvarchar(100)	200
	uspsd_admin_org	nvarchar(100)	200
$Indexes XAK3si_contact_prop: active\location\type\contact_uuid$ $Indexes XAK4si_contact_prop: active\type\combo_name\contact_uuid$	active	int	4
$Cluster Primary Key $si_co_u000014e300000000: contact_uuid\data_source$	data_source	varchar(256)	256

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Primary Key $si_co_u000014e300000000: contact_uuid\data_source$ $Indexes XAK3si_contact_prop: active\location\type\contact_uuid$ $Indexes XAK4si_contact_prop: active\type\combo_name\contact_uuid$

$Indexes XAK1si_contact_prop: location\combo_name\contact_uuid$ $Indexes XAK5si_contact_prop: uspsd_org_name\combo_name\contact_uuid$ $Indexes XAK2si_contact_prop: uspsd_org_uuid\usi_org_uuid\manager_uuid\contact_uuid$

contact_uuid

binary(16)

$Indexes XAK4si_contact_prop: active\type\combo_name\contact_uuid$ $Indexes XAK1si_contact_prop: location\combo_name\contact_uuid$ $Indexes XAK5si_contact_prop: uspsd_org_name\combo_name\contact_uuid$

combo_name

nvarchar(100)

200

$Indexes XAK2si_contact_prop: uspsd_org_uuid\usi_org_uuid\manager_uuid\contact_uuid$

manager_uuid

binary(16)

manager_name

nvarchar(100)

200

$Indexes XAK3si_contact_prop: active\location\type\contact_uuid$ $Indexes XAK4si_contact_prop: active\type\combo_name\contact_uuid$

type

nvarchar(100)

200

$Indexes XAK2si_contact_prop: uspsd_org_uuid\usi_org_uuid\manager_uuid\contact_uuid$

uspsd_org_uuid

binary(16)

$Indexes XAK3si_contact_prop: active\location\type\contact_uuid$ $Indexes XAK1si_contact_prop: location\combo_name\contact_uuid$

location

nvarchar(100)

200

$Indexes XAK2si_contact_prop: uspsd_org_uuid\usi_org_uuid\manager_uuid\contact_uuid$

usi_org_uuid

binary(16)

$Indexes XAK5si_contact_prop: uspsd_org_name\combo_name\contact_uuid$

uspsd_org_name

nvarchar(100)

200

uspsd_admin_org

nvarchar(100)

200

$Indexes XAK3si_contact_prop: active\location\type\contact_uuid$ $Indexes XAK4si_contact_prop: active\type\combo_name\contact_uuid$

active

int

$Cluster Primary Key $si_co_u000014e300000000: contact_uuid\data_source$

data_source

varchar(256)

256

	Name	Columns
$Cluster Primary Key $si_co_u000014e300000000: contact_uuid\data_source$	$si_co_u000014e300000000	contact_uuid, data_source
	baseidx_si_contact_prop	contact_uuid
	XAK1si_contact_prop	location, combo_name, contact_uuid
	XAK2si_contact_prop	uspsd_org_uuid, usi_org_uuid, manager_uuid, contact_uuid
	XAK3si_contact_prop	active, location, type, contact_uuid
	XAK4si_contact_prop	active, type, combo_name, contact_uuid
	XAK5si_contact_prop	uspsd_org_name, combo_name, contact_uuid

Name

Columns

Unique

$Cluster Primary Key $si_co_u000014e300000000: contact_uuid\data_source$

$si_co_u000014e300000000

contact_uuid, data_source

baseidx_si_contact_prop

contact_uuid

XAK1si_contact_prop

location, combo_name, contact_uuid

XAK2si_contact_prop

uspsd_org_uuid, usi_org_uuid, manager_uuid, contact_uuid

XAK3si_contact_prop

active, location, type, contact_uuid

XAK4si_contact_prop

active, type, combo_name, contact_uuid

XAK5si_contact_prop

uspsd_org_name, combo_name, contact_uuid

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

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_contact_prop]
(
[contact_uuid] [binary] (16) NOT NULL,
[combo_name] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[manager_uuid] [binary] (16) NULL,
[manager_name] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[type] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[uspsd_org_uuid] [binary] (16) NULL,
[location] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[usi_org_uuid] [binary] (16) NULL,
[uspsd_org_name] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[uspsd_admin_org] [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
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[si_contact_prop] ADD CONSTRAINT [$si_co_u000014e300000000] PRIMARY KEY CLUSTERED ([contact_uuid], [data_source]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [XAK3si_contact_prop] ON [dbo].[si_contact_prop] ([active], [location], [type], [contact_uuid]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [XAK4si_contact_prop] ON [dbo].[si_contact_prop] ([active], [type], [combo_name], [contact_uuid]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [baseidx_si_contact_prop] ON [dbo].[si_contact_prop] ([contact_uuid]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [XAK1si_contact_prop] ON [dbo].[si_contact_prop] ([location], [combo_name], [contact_uuid]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [XAK5si_contact_prop] ON [dbo].[si_contact_prop] ([uspsd_org_name], [combo_name], [contact_uuid]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [XAK2si_contact_prop] ON [dbo].[si_contact_prop] ([uspsd_org_uuid], [usi_org_uuid], [manager_uuid], [contact_uuid]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[si_contact_prop] TO [aiadmin]
GRANT INSERT ON  [dbo].[si_contact_prop] TO [aiadmin]
GRANT DELETE ON  [dbo].[si_contact_prop] TO [aiadmin]
GRANT UPDATE ON  [dbo].[si_contact_prop] TO [aiadmin]
GRANT SELECT ON  [dbo].[si_contact_prop] TO [aipublic]
GRANT SELECT ON  [dbo].[si_contact_prop] TO [aiuser]
GRANT INSERT ON  [dbo].[si_contact_prop] TO [aiuser]
GRANT DELETE ON  [dbo].[si_contact_prop] TO [aiuser]
GRANT UPDATE ON  [dbo].[si_contact_prop] TO [aiuser]
GRANT SELECT ON  [dbo].[si_contact_prop] TO [siadmins]
GRANT INSERT ON  [dbo].[si_contact_prop] TO [siadmins]
GRANT DELETE ON  [dbo].[si_contact_prop] TO [siadmins]
GRANT UPDATE ON  [dbo].[si_contact_prop] TO [siadmins]
GO