Tables [dbo].[ca_link_contact_user]
Properties
PropertyValue
Row Count0
Created10:23:58 AM Sunday, December 05, 2010
Last Modified10:24:03 AM Sunday, December 05, 2010
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
GrantDeleteca_itrm_group
GrantInsertca_itrm_group
GrantDeleteswcmadmin
GrantInsertswcmadmin
GrantSelectregadmin
GrantSelectca_itrm_group
GrantUpdateca_itrm_group
GrantSelectca_itrm_group_ams
GrantSelectupmuser_group
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 [upmuser_group]
GO
Uses