CREATE TABLE [dbo].[ca_discovery_batch]
(
[ca_batch_id_uid] [binary] (16) NOT NULL,
[process_name] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[start_datetime] [int] NULL,
[end_datetime] [int] NULL,
[batch_id] [nvarchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[input_file_name] [nvarchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[tenant] [binary] (16) NULL,
[discovery_tool] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[total_count] [int] NULL CONSTRAINT [DF__ca_discov__total__5BE2A6F2] DEFAULT ('0'),
[success_count] [int] NULL CONSTRAINT [DF__ca_discov__succe__5CD6CB2B] DEFAULT ('0'),
[failure_count] [int] NULL CONSTRAINT [DF__ca_discov__failu__5DCAEF64] DEFAULT ('0'),
[processing_error_count] [int] NULL CONSTRAINT [DF__ca_discov__proce__5EBF139D] DEFAULT ('0'),
[matched_by_label] [int] NULL CONSTRAINT [DF__ca_discov__match__5FB337D6] DEFAULT ('0'),
[matched_by_serial_number] [int] NULL CONSTRAINT [DF__ca_discov__match__60A75C0F] DEFAULT ('0'),
[matched_by_asset_tag] [int] NULL CONSTRAINT [DF__ca_discov__match__619B8048] DEFAULT ('0'),
[matched_by_host_name] [int] NULL CONSTRAINT [DF__ca_discov__match__628FA481] DEFAULT ('0'),
[matched_by_dns_name] [int] NULL CONSTRAINT [DF__ca_discov__match__6383C8BA] DEFAULT ('0'),
[matched_by_mac_address] [int] NULL CONSTRAINT [DF__ca_discov__match__6477ECF3] DEFAULT ('0'),
[change_count] [int] NULL CONSTRAINT [DF__ca_discov__chang__293E51A3] DEFAULT ('0')
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[ca_discovery_batch] ADD CONSTRAINT [pk_ca_discovery_batch] PRIMARY KEY CLUSTERED ([ca_batch_id_uid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [CA_DISCOVERY_BATCH_IDX01] ON [dbo].[ca_discovery_batch] ([process_name], [batch_id]) ON [PRIMARY]
GO