CREATE TABLE [dbo].[software_vulnerability]
(
[vuln_id] [binary] (16) NOT NULL,
[is_remotely_exploitable] [tinyint] NOT NULL,
[is_locally_exploitable] [tinyint] NOT NULL,
[discovery_date] [int] NOT NULL,
[discovered_by] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[impact_rating] [smallint] NOT NULL,
[popularity_rating] [smallint] NOT NULL,
[simplicity_rating] [smallint] NOT NULL,
[root_cause_id] [binary] (16) NULL,
[published_date] [int] NULL,
[creation_user] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[creation_date] [int] NOT NULL,
[last_update_user] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[last_update_date] [int] NOT NULL,
[version_number] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[software_vulnerability] ADD CONSTRAINT [XPKsoftware_vulnerability] PRIMARY KEY CLUSTERED ([vuln_id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[software_vulnerability] ADD CONSTRAINT [$softw_r00001c1600000000] FOREIGN KEY ([vuln_id]) REFERENCES [dbo].[vulnerability] ([vuln_id]) ON DELETE CASCADE ON UPDATE CASCADE
GO
ALTER TABLE [dbo].[software_vulnerability] ADD CONSTRAINT [$softw_r00001c1f00000000] FOREIGN KEY ([root_cause_id]) REFERENCES [dbo].[root_cause] ([root_cause_id])
GO