Tables [dbo].[ca_link_configured_service]
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_configured_service: named_config_uuid\own_resource_uuidForeign Keys $ca_li_r0000034100000000: [dbo].[ca_named_configuration].named_config_uuidnamed_config_uuidbinary(16)16
No
Cluster Primary Key XPKca_link_configured_service: named_config_uuid\own_resource_uuidForeign Keys $ca_li_r0000034a00000000: [dbo].[ca_owned_resource].own_resource_uuidown_resource_uuidbinary(16)16
No
last_update_dateint4
Yes
version_numberint4
Yes
((0))
Indexes Indexes
NameColumnsUnique
Cluster Primary Key XPKca_link_configured_service: named_config_uuid\own_resource_uuidXPKca_link_configured_servicenamed_config_uuid, own_resource_uuid
Yes
Foreign Keys Foreign Keys
NameColumns
$ca_li_r0000034100000000named_config_uuid->[dbo].[ca_named_configuration].[named_config_uuid]
$ca_li_r0000034a00000000own_resource_uuid->[dbo].[ca_owned_resource].[own_resource_uuid]
Permissions
TypeActionOwning Principal
GrantDeleteca_itrm_group
GrantInsertca_itrm_group
GrantSelectca_itrm_group
GrantUpdateca_itrm_group
GrantSelectregadmin
GrantSelectupmuser_group
GrantSelectca_itrm_group_ams
SQL Script
CREATE TABLE [dbo].[ca_link_configured_service]
(
[named_config_uuid] [binary] (16) NOT NULL,
[own_resource_uuid] [binary] (16) NOT NULL,
[last_update_date] [int] NULL,
[version_number] [int] NULL CONSTRAINT [DF__ca_link_c__versi__6BCEF5F8] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ca_link_configured_service] ADD CONSTRAINT [XPKca_link_configured_service] PRIMARY KEY CLUSTERED ([named_config_uuid], [own_resource_uuid]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ca_link_configured_service] ADD CONSTRAINT [$ca_li_r0000034100000000] FOREIGN KEY ([named_config_uuid]) REFERENCES [dbo].[ca_named_configuration] ([named_config_uuid])
GO
ALTER TABLE [dbo].[ca_link_configured_service] ADD CONSTRAINT [$ca_li_r0000034a00000000] FOREIGN KEY ([own_resource_uuid]) REFERENCES [dbo].[ca_owned_resource] ([own_resource_uuid])
GO
GRANT SELECT ON  [dbo].[ca_link_configured_service] TO [ca_itrm_group]
GRANT INSERT ON  [dbo].[ca_link_configured_service] TO [ca_itrm_group]
GRANT DELETE ON  [dbo].[ca_link_configured_service] TO [ca_itrm_group]
GRANT UPDATE ON  [dbo].[ca_link_configured_service] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[ca_link_configured_service] TO [ca_itrm_group_ams]
GRANT SELECT ON  [dbo].[ca_link_configured_service] TO [regadmin]
GRANT SELECT ON  [dbo].[ca_link_configured_service] TO [upmuser_group]
GO
Uses