CREATE TABLE [dbo].[software_delivery_job]
(
[software_delivery_job_id] [binary] (16) NOT NULL,
[depends_on_software_dlvy_job_id] [binary] (16) NULL,
[test_dis_hw_uuid] [binary] (16) NULL,
[auto_deploy_after_sussful_test] [tinyint] NULL,
[job_status_id] [binary] (16) NULL,
[scheduled_date] [int] NULL,
[scheduled_by] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[test_asset_schedule_date] [int] NULL,
[test_status_id] [binary] (16) NULL,
[submitted_date] [int] NULL,
[submitted_by] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_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]
GO
ALTER TABLE [dbo].[software_delivery_job] ADD CONSTRAINT [XPKsoftware_delivery_job] PRIMARY KEY CLUSTERED ([software_delivery_job_id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [xif4software_delivery_job] ON [dbo].[software_delivery_job] ([depends_on_software_dlvy_job_id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [xif3software_delivery_job] ON [dbo].[software_delivery_job] ([job_status_id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [xif1software_delivery_job] ON [dbo].[software_delivery_job] ([test_dis_hw_uuid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [xif2software_delivery_job] ON [dbo].[software_delivery_job] ([test_status_id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[software_delivery_job] ADD CONSTRAINT [$softw_r00001cec00000000] FOREIGN KEY ([depends_on_software_dlvy_job_id]) REFERENCES [dbo].[software_delivery_job] ([software_delivery_job_id])
GO
ALTER TABLE [dbo].[software_delivery_job] ADD CONSTRAINT [$softw_r00001cf600000000] FOREIGN KEY ([test_dis_hw_uuid]) REFERENCES [dbo].[ca_discovered_hardware] ([dis_hw_uuid])
GO