Tables [dbo].[ca_link_named_config_doc]
Properties
PropertyValue
Row Count0
Created10:23:59 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_named_config_doc: doc_uuid\named_config_uuidForeign Keys $ca_li_r000003a200000000: [dbo].[ca_document].doc_uuiddoc_uuidbinary(16)16
No
Cluster Primary Key XPKca_link_named_config_doc: doc_uuid\named_config_uuidForeign Keys $ca_li_r0000039800000000: [dbo].[ca_named_configuration].named_config_uuidnamed_config_uuidbinary(16)16
No
last_update_dateint4
Yes
version_numberint4
Yes
('0')
Indexes Indexes
NameColumnsUnique
Cluster Primary Key XPKca_link_named_config_doc: doc_uuid\named_config_uuidXPKca_link_named_config_docdoc_uuid, named_config_uuid
Yes
Foreign Keys Foreign Keys
NameColumns
$ca_li_r0000039800000000named_config_uuid->[dbo].[ca_named_configuration].[named_config_uuid]
$ca_li_r000003a200000000doc_uuid->[dbo].[ca_document].[doc_uuid]
Permissions
TypeActionOwning Principal
GrantDeleteca_itrm_group
GrantInsertca_itrm_group
GrantDeleteucmadmin
GrantInsertucmadmin
GrantDeleteuniadmin
GrantInsertuniadmin
GrantSelectregadmin
GrantSelectca_itrm_group
GrantUpdateca_itrm_group
GrantSelectca_itrm_group_ams
GrantSelectucmadmin
GrantUpdateucmadmin
GrantSelectucmuser
GrantSelectuniadmin
GrantUpdateuniadmin
GrantSelectuniuser
GrantSelectupmuser_group
SQL Script
CREATE TABLE [dbo].[ca_link_named_config_doc]
(
[doc_uuid] [binary] (16) NOT NULL,
[named_config_uuid] [binary] (16) NOT NULL,
[last_update_date] [int] NULL,
[version_number] [int] NULL CONSTRAINT [DF__ca_link_n__versi__0682EC34] DEFAULT ('0')
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[ca_link_named_config_doc] ADD CONSTRAINT [XPKca_link_named_config_doc] PRIMARY KEY CLUSTERED ([doc_uuid], [named_config_uuid]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ca_link_named_config_doc] ADD CONSTRAINT [$ca_li_r0000039800000000] FOREIGN KEY ([named_config_uuid]) REFERENCES [dbo].[ca_named_configuration] ([named_config_uuid])
GO
ALTER TABLE [dbo].[ca_link_named_config_doc] ADD CONSTRAINT [$ca_li_r000003a200000000] FOREIGN KEY ([doc_uuid]) REFERENCES [dbo].[ca_document] ([doc_uuid])
GO
GRANT SELECT ON  [dbo].[ca_link_named_config_doc] TO [ca_itrm_group]
GRANT INSERT ON  [dbo].[ca_link_named_config_doc] TO [ca_itrm_group]
GRANT DELETE ON  [dbo].[ca_link_named_config_doc] TO [ca_itrm_group]
GRANT UPDATE ON  [dbo].[ca_link_named_config_doc] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[ca_link_named_config_doc] TO [ca_itrm_group_ams]
GRANT SELECT ON  [dbo].[ca_link_named_config_doc] TO [regadmin]
GRANT SELECT ON  [dbo].[ca_link_named_config_doc] TO [ucmadmin]
GRANT INSERT ON  [dbo].[ca_link_named_config_doc] TO [ucmadmin]
GRANT DELETE ON  [dbo].[ca_link_named_config_doc] TO [ucmadmin]
GRANT UPDATE ON  [dbo].[ca_link_named_config_doc] TO [ucmadmin]
GRANT SELECT ON  [dbo].[ca_link_named_config_doc] TO [ucmuser]
GRANT SELECT ON  [dbo].[ca_link_named_config_doc] TO [uniadmin]
GRANT INSERT ON  [dbo].[ca_link_named_config_doc] TO [uniadmin]
GRANT DELETE ON  [dbo].[ca_link_named_config_doc] TO [uniadmin]
GRANT UPDATE ON  [dbo].[ca_link_named_config_doc] TO [uniadmin]
GRANT SELECT ON  [dbo].[ca_link_named_config_doc] TO [uniuser]
GRANT SELECT ON  [dbo].[ca_link_named_config_doc] TO [upmuser_group]
GO
Uses