CREATE TABLE [dbo].[ca_link_config_item_doc]
(
[config_item_uuid] [binary] (16) NOT NULL,
[doc_uuid] [binary] (16) NOT NULL,
[asset_uuid] [binary] (16) NOT NULL,
[last_update_date] [int] NULL,
[version_number] [int] NULL CONSTRAINT [DF__ca_link_c__versi__68F2894D] DEFAULT ('0')
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[ca_link_config_item_doc] ADD CONSTRAINT [XPKca_link_config_item_doc] PRIMARY KEY CLUSTERED ([doc_uuid], [config_item_uuid], [asset_uuid]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ca_link_config_item_doc] ADD CONSTRAINT [$ca_li_r0000032e00000000] FOREIGN KEY ([doc_uuid]) REFERENCES [dbo].[ca_document] ([doc_uuid])
GO
ALTER TABLE [dbo].[ca_link_config_item_doc] ADD CONSTRAINT [$ca_li_r0000033700000000] FOREIGN KEY ([config_item_uuid], [asset_uuid]) REFERENCES [dbo].[ca_config_item] ([config_item_uuid], [asset_uuid])
GO
GRANT SELECT ON  [dbo].[ca_link_config_item_doc] TO [ca_itrm_group]
GRANT INSERT ON  [dbo].[ca_link_config_item_doc] TO [ca_itrm_group]
GRANT DELETE ON  [dbo].[ca_link_config_item_doc] TO [ca_itrm_group]
GRANT UPDATE ON  [dbo].[ca_link_config_item_doc] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[ca_link_config_item_doc] TO [ca_itrm_group_ams]
GRANT SELECT ON  [dbo].[ca_link_config_item_doc] TO [regadmin]
GRANT SELECT ON  [dbo].[ca_link_config_item_doc] TO [upmuser_group]
GO