
[dbo].[ca_link_logical_asset_class_def]
CREATE TABLE [dbo].[ca_link_logical_asset_class_def]
(
[class_id] [int] NOT NULL,
[logical_asset_uuid] [binary] (16) NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ca_link_logical_asset_class_def] ADD CONSTRAINT [XPKca_link_logical_asset_class_def] PRIMARY KEY CLUSTERED ([class_id], [logical_asset_uuid]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ca_link_logical_asset_class_def] ADD CONSTRAINT [$ca_li_r000002fe00000000] FOREIGN KEY ([class_id]) REFERENCES [dbo].[ca_class_def] ([class_id])
GO
ALTER TABLE [dbo].[ca_link_logical_asset_class_def] ADD CONSTRAINT [$ca_li_r0000030700000000] FOREIGN KEY ([logical_asset_uuid]) REFERENCES [dbo].[ca_logical_asset] ([logical_asset_uuid])
GO
GRANT SELECT ON [dbo].[ca_link_logical_asset_class_def] TO [ca_itrm_group]
GRANT INSERT ON [dbo].[ca_link_logical_asset_class_def] TO [ca_itrm_group]
GRANT DELETE ON [dbo].[ca_link_logical_asset_class_def] TO [ca_itrm_group]
GRANT UPDATE ON [dbo].[ca_link_logical_asset_class_def] TO [ca_itrm_group]
GRANT SELECT ON [dbo].[ca_link_logical_asset_class_def] TO [regadmin]
GRANT SELECT ON [dbo].[ca_link_logical_asset_class_def] TO [swcmadmin]
GRANT INSERT ON [dbo].[ca_link_logical_asset_class_def] TO [swcmadmin]
GRANT DELETE ON [dbo].[ca_link_logical_asset_class_def] TO [swcmadmin]
GRANT UPDATE ON [dbo].[ca_link_logical_asset_class_def] TO [swcmadmin]
GO