CREATE TABLE [dbo].[asset_vulnerability]
(
[asset_vulnerability_rec_id] [binary] (16) NOT NULL,
[vuln_id] [binary] (16) NOT NULL,
[note] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[status_changed_by] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[status_change_date] [int] NULL,
[locked_by] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[locked_date] [int] NULL,
[aggr_asset_detect_prof_st] [binary] (16) NOT NULL,
[auto_status] [tinyint] 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,
[dis_hw_uuid] [binary] (16) NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[asset_vulnerability] ADD CONSTRAINT [XPKasset_vulnerability] PRIMARY KEY CLUSTERED ([asset_vulnerability_rec_id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [xif1asset_vulnerability] ON [dbo].[asset_vulnerability] ([dis_hw_uuid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [xif2asset_vulnerability] ON [dbo].[asset_vulnerability] ([vuln_id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[asset_vulnerability] ADD CONSTRAINT [$asset_r00001cc800000000] FOREIGN KEY ([dis_hw_uuid]) REFERENCES [dbo].[ca_discovered_hardware] ([dis_hw_uuid])
GO
ALTER TABLE [dbo].[asset_vulnerability] ADD CONSTRAINT [$asset_r00001cd100000000] FOREIGN KEY ([vuln_id]) REFERENCES [dbo].[vulnerability] ([vuln_id])
GO