CREATE TABLE [dbo].[applied_remediation]
(
[applied_remediation_rec_id] [binary] (16) NOT NULL,
[asset_detection_profile_rec_id] [binary] (16) NOT NULL,
[remediation_profile_id] [binary] (16) NOT NULL,
[applied_remed_status_id] [binary] (16) NOT NULL,
[task_status_date] [int] NOT NULL,
[status_changed_by] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[software_delivery_job_id] [binary] (16) NULL,
[note] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[creation_user] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[creation_date] [int] NULL,
[last_update_user] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[last_update_date] [int] NULL,
[version_number] [int] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[applied_remediation] ADD CONSTRAINT [XPKapplied_remediation] PRIMARY KEY CLUSTERED ([applied_remediation_rec_id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[applied_remediation] ADD CONSTRAINT [$appli_r00001b7700000000] FOREIGN KEY ([applied_remed_status_id]) REFERENCES [dbo].[applied_remediation_status] ([applied_remed_status_id])
GO
ALTER TABLE [dbo].[applied_remediation] ADD CONSTRAINT [$appli_r00001b8100000000] FOREIGN KEY ([asset_detection_profile_rec_id]) REFERENCES [dbo].[asset_detection_profile] ([asset_detection_profile_rec_id])
GO
ALTER TABLE [dbo].[applied_remediation] ADD CONSTRAINT [$appli_r00001b8b00000000] FOREIGN KEY ([remediation_profile_id]) REFERENCES [dbo].[remediation_profile] ([remed_profile_id])
GO