CREATE TABLE [dbo].[hardware_software_dvy_jb_file]
(
[hardware_software_dvy_jb_file_id] [binary] (16) NOT NULL,
[status] [binary] (16) NOT NULL,
[asset_software_delivery_job_id] [binary] (16) NOT NULL,
[software_delivery_job_file_id] [binary] (16) NOT NULL,
[schedule_date] [int] 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].[hardware_software_dvy_jb_file] ADD CONSTRAINT [XPKhardware_software_dvy_jb_file] PRIMARY KEY CLUSTERED ([hardware_software_dvy_jb_file_id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [xif1hard_soft_delivery_job_file] ON [dbo].[hardware_software_dvy_jb_file] ([asset_software_delivery_job_id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [xif2hard_soft_delivery_job_file] ON [dbo].[hardware_software_dvy_jb_file] ([software_delivery_job_file_id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[hardware_software_dvy_jb_file] ADD CONSTRAINT [$hardw_r00001d1a00000000] FOREIGN KEY ([software_delivery_job_file_id]) REFERENCES [dbo].[software_delivery_job_file] ([software_delivery_job_file_id])
GO
ALTER TABLE [dbo].[hardware_software_dvy_jb_file] ADD CONSTRAINT [$hardw_r00001d2300000000] FOREIGN KEY ([asset_software_delivery_job_id]) REFERENCES [dbo].[asset_software_delivery_job] ([asset_software_delivery_job_id])
GO