[dbo].[g_contact]

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	0
Created	11:07:15 AM Wednesday, March 07, 2007
Last Modified	9:08:51 PM Friday, December 05, 2008

Property

Value

Collation

SQL_Latin1_General_CP1_CI_AS

Row Count

Created

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

Last Modified

9:08:51 PM Friday, December 05, 2008

	Name	Data Type	Max Length (Bytes)
	id	int	4
	del	int	4
	last_mod_dt	int	4
	last_mod_by	binary(16)	16
$Indexes g_contact_x1: middle_name\last_name\first_name\remote_sys_id\remote_id$ $Indexes g_contact_x2: userid\remote_sys_id\remote_id$	remote_sys_id	int	4
$Indexes g_contact_x1: middle_name\last_name\first_name\remote_sys_id\remote_id$ $Indexes g_contact_x2: userid\remote_sys_id\remote_id$	remote_id	binary(16)	16
$Indexes g_contact_x0: last_name\first_name\middle_name$ $Indexes g_contact_x1: middle_name\last_name\first_name\remote_sys_id\remote_id$	last_name	nvarchar(100)	200
$Indexes g_contact_x0: last_name\first_name\middle_name$ $Indexes g_contact_x1: middle_name\last_name\first_name\remote_sys_id\remote_id$	first_name	nvarchar(100)	200
$Indexes g_contact_x0: last_name\first_name\middle_name$ $Indexes g_contact_x1: middle_name\last_name\first_name\remote_sys_id\remote_id$	middle_name	nvarchar(100)	200
$Indexes g_contact_x2: userid\remote_sys_id\remote_id$	userid	nvarchar(100)	200
	contact_num	nvarchar(30)	60
	pri_phone_number	nvarchar(32)	64
	email_address	nvarchar(120)	240
	org_id	binary(16)	16
	loc_id	binary(16)	16
	remote_tenant	binary(16)	16

Name

Data Type

Max Length (Bytes)

Allow Nulls

int

del

int

last_mod_dt

int

last_mod_by

binary(16)

$Indexes g_contact_x1: middle_name\last_name\first_name\remote_sys_id\remote_id$ $Indexes g_contact_x2: userid\remote_sys_id\remote_id$

remote_sys_id

int

$Indexes g_contact_x1: middle_name\last_name\first_name\remote_sys_id\remote_id$ $Indexes g_contact_x2: userid\remote_sys_id\remote_id$

remote_id

binary(16)

$Indexes g_contact_x0: last_name\first_name\middle_name$ $Indexes g_contact_x1: middle_name\last_name\first_name\remote_sys_id\remote_id$

last_name

nvarchar(100)

200

$Indexes g_contact_x0: last_name\first_name\middle_name$ $Indexes g_contact_x1: middle_name\last_name\first_name\remote_sys_id\remote_id$

first_name

nvarchar(100)

200

$Indexes g_contact_x0: last_name\first_name\middle_name$ $Indexes g_contact_x1: middle_name\last_name\first_name\remote_sys_id\remote_id$

middle_name

nvarchar(100)

200

$Indexes g_contact_x2: userid\remote_sys_id\remote_id$

userid

nvarchar(100)

200

contact_num

nvarchar(30)

pri_phone_number

nvarchar(32)

email_address

nvarchar(120)

240

org_id

binary(16)

loc_id

binary(16)

remote_tenant

binary(16)

	Name	Columns	Unique
	XPKg_contact	id
	g_contact_x1	middle_name, last_name, first_name, remote_sys_id, remote_id
	g_contact_x0	last_name, first_name, middle_name
	g_contact_x2	userid, remote_sys_id, remote_id
	g_contact_x3	pri_phone_number
	g_contact_x4	email_address
	g_contact_x5	contact_num
	g_contact_x6	remote_tenant

Name

Columns

Unique

XPKg_contact

g_contact_x1

middle_name, last_name, first_name, remote_sys_id, remote_id

g_contact_x0

last_name, first_name, middle_name

g_contact_x2

userid, remote_sys_id, remote_id

g_contact_x3

pri_phone_number

g_contact_x4

email_address

g_contact_x5

contact_num

g_contact_x6

remote_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

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].[g_contact]
(
[id] [int] NOT NULL,
[del] [int] NOT NULL,
[last_mod_dt] [int] NULL,
[last_mod_by] [binary] (16) NULL,
[remote_sys_id] [int] NOT NULL,
[remote_id] [binary] (16) NOT NULL,
[last_name] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[first_name] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[middle_name] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[userid] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[contact_num] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[pri_phone_number] [nvarchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[email_address] [nvarchar] (120) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[org_id] [binary] (16) NULL,
[loc_id] [binary] (16) NULL,
[remote_tenant] [binary] (16) NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[g_contact] ADD CONSTRAINT [XPKg_contact] PRIMARY KEY CLUSTERED ([id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [g_contact_x5] ON [dbo].[g_contact] ([contact_num]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [g_contact_x4] ON [dbo].[g_contact] ([email_address]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [g_contact_x0] ON [dbo].[g_contact] ([last_name], [first_name], [middle_name]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [g_contact_x1] ON [dbo].[g_contact] ([remote_sys_id], [remote_id]) INCLUDE ([first_name], [last_name], [middle_name]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [g_contact_x3] ON [dbo].[g_contact] ([pri_phone_number]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [g_contact_x6] ON [dbo].[g_contact] ([remote_tenant]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [g_contact_x2] ON [dbo].[g_contact] ([userid], [remote_sys_id], [remote_id]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[g_contact] TO [service_desk_admin_group]
GRANT INSERT ON  [dbo].[g_contact] TO [service_desk_admin_group]
GRANT DELETE ON  [dbo].[g_contact] TO [service_desk_admin_group]
GRANT UPDATE ON  [dbo].[g_contact] TO [service_desk_admin_group]
GRANT SELECT ON  [dbo].[g_contact] TO [service_desk_ro_group]
GO