Tables [dbo].[ca_link_contact_user]
Properties
PropertyValue
Row Count0
Created11:08:11 AM Wednesday, March 07, 2007
Last Modified9:08:02 PM Friday, December 05, 2008
Columns
NameData TypeMax Length (Bytes)Allow NullsDefault
Cluster Primary Key XPKca_link_contact_user: contact_uuid\user_uuidForeign Keys $ca_li_r0000035d00000000: [dbo].[ca_discovered_user].user_uuiduser_uuidbinary(16)16
No
Cluster Primary Key XPKca_link_contact_user: contact_uuid\user_uuidForeign Keys $ca_li_r0000035400000000: [dbo].[ca_contact].contact_uuidcontact_uuidbinary(16)16
No
last_update_dateint4
Yes
version_numberint4
Yes
((0))
Indexes Indexes
NameColumnsUnique
Cluster Primary Key XPKca_link_contact_user: contact_uuid\user_uuidXPKca_link_contact_usercontact_uuid, user_uuid
Yes
Foreign Keys Foreign Keys
NameColumns
$ca_li_r0000035400000000contact_uuid->[dbo].[ca_contact].[contact_uuid]
$ca_li_r0000035d00000000user_uuid->[dbo].[ca_discovered_user].[user_uuid]
Permissions
TypeActionOwning Principal
GrantInsertswcmadmin
GrantInsertuapmbatch_group
GrantDeleteuapmadmin
GrantInsertuapmadmin
GrantDeleteuapmbatch
GrantInsertuapmbatch
GrantDeleteswcmadmin
GrantDeleteca_itrm_group
GrantInsertca_itrm_group
GrantDeleteuapmadmin_group
GrantInsertuapmadmin_group
GrantDeleteuapmbatch_group
GrantSelectca_itrm_group
GrantUpdateca_itrm_group
GrantSelectregadmin
GrantSelectuapmadmin_group
GrantUpdateuapmadmin_group
GrantSelectuapmbatch_group
GrantUpdateuapmbatch_group
GrantSelectuapmreporting_group
GrantSelectupmuser_group
GrantSelectca_itrm_group_ams
GrantSelectuapmadmin
GrantUpdateuapmadmin
GrantSelectuapmbatch
GrantUpdateuapmbatch
GrantSelectuapmreporting
GrantSelectswcmadmin
GrantUpdateswcmadmin
SQL Script
CREATE TABLE [dbo].[ca_link_contact_user]
(
[user_uuid] [binary] (16) NOT NULL,
[contact_uuid] [binary] (16) NOT NULL,
[last_update_date] [int] NULL,
[version_number] [int] NULL CONSTRAINT [DF__ca_link_c__versi__6EAB62A3] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ca_link_contact_user] ADD CONSTRAINT [XPKca_link_contact_user] PRIMARY KEY CLUSTERED ([contact_uuid], [user_uuid]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ca_link_contact_user] ADD CONSTRAINT [$ca_li_r0000035400000000] FOREIGN KEY ([contact_uuid]) REFERENCES [dbo].[ca_contact] ([contact_uuid])
GO
ALTER TABLE [dbo].[ca_link_contact_user] ADD CONSTRAINT [$ca_li_r0000035d00000000] FOREIGN KEY ([user_uuid]) REFERENCES [dbo].[ca_discovered_user] ([user_uuid])
GO
GRANT SELECT ON  [dbo].[ca_link_contact_user] TO [ca_itrm_group]
GRANT INSERT ON  [dbo].[ca_link_contact_user] TO [ca_itrm_group]
GRANT DELETE ON  [dbo].[ca_link_contact_user] TO [ca_itrm_group]
GRANT UPDATE ON  [dbo].[ca_link_contact_user] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[ca_link_contact_user] TO [ca_itrm_group_ams]
GRANT SELECT ON  [dbo].[ca_link_contact_user] TO [regadmin]
GRANT SELECT ON  [dbo].[ca_link_contact_user] TO [swcmadmin]
GRANT INSERT ON  [dbo].[ca_link_contact_user] TO [swcmadmin]
GRANT DELETE ON  [dbo].[ca_link_contact_user] TO [swcmadmin]
GRANT UPDATE ON  [dbo].[ca_link_contact_user] TO [swcmadmin]
GRANT SELECT ON  [dbo].[ca_link_contact_user] TO [uapmadmin]
GRANT INSERT ON  [dbo].[ca_link_contact_user] TO [uapmadmin]
GRANT DELETE ON  [dbo].[ca_link_contact_user] TO [uapmadmin]
GRANT UPDATE ON  [dbo].[ca_link_contact_user] TO [uapmadmin]
GRANT SELECT ON  [dbo].[ca_link_contact_user] TO [uapmadmin_group]
GRANT INSERT ON  [dbo].[ca_link_contact_user] TO [uapmadmin_group]
GRANT DELETE ON  [dbo].[ca_link_contact_user] TO [uapmadmin_group]
GRANT UPDATE ON  [dbo].[ca_link_contact_user] TO [uapmadmin_group]
GRANT SELECT ON  [dbo].[ca_link_contact_user] TO [uapmbatch]
GRANT INSERT ON  [dbo].[ca_link_contact_user] TO [uapmbatch]
GRANT DELETE ON  [dbo].[ca_link_contact_user] TO [uapmbatch]
GRANT UPDATE ON  [dbo].[ca_link_contact_user] TO [uapmbatch]
GRANT SELECT ON  [dbo].[ca_link_contact_user] TO [uapmbatch_group]
GRANT INSERT ON  [dbo].[ca_link_contact_user] TO [uapmbatch_group]
GRANT DELETE ON  [dbo].[ca_link_contact_user] TO [uapmbatch_group]
GRANT UPDATE ON  [dbo].[ca_link_contact_user] TO [uapmbatch_group]
GRANT SELECT ON  [dbo].[ca_link_contact_user] TO [uapmreporting]
GRANT SELECT ON  [dbo].[ca_link_contact_user] TO [uapmreporting_group]
GRANT SELECT ON  [dbo].[ca_link_contact_user] TO [upmuser_group]
GO
Uses