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__1FF04C4B] DEFAULT ('0'),
[success_count] [int] NULL CONSTRAINT [DF__ca_discov__succe__20E47084] DEFAULT ('0'),
[failure_count] [int] NULL CONSTRAINT [DF__ca_discov__failu__21D894BD] DEFAULT ('0'),
[processing_error_count] [int] NULL CONSTRAINT [DF__ca_discov__proce__22CCB8F6] DEFAULT ('0'),
[matched_by_label] [int] NULL CONSTRAINT [DF__ca_discov__match__23C0DD2F] DEFAULT ('0'),
[matched_by_serial_number] [int] NULL CONSTRAINT [DF__ca_discov__match__24B50168] DEFAULT ('0'),
[matched_by_asset_tag] [int] NULL CONSTRAINT [DF__ca_discov__match__25A925A1] DEFAULT ('0'),
[matched_by_host_name] [int] NULL CONSTRAINT [DF__ca_discov__match__269D49DA] DEFAULT ('0'),
[matched_by_dns_name] [int] NULL CONSTRAINT [DF__ca_discov__match__27916E13] DEFAULT ('0'),
[matched_by_mac_address] [int] NULL CONSTRAINT [DF__ca_discov__match__2885924C] 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