CREATE TABLE [dbo].[arg_reconcile_data]
(
[task_uuid] [binary] (16) NOT NULL,
[reconcile_data_id] [int] NOT NULL,
[reconcile_data_type] [smallint] NULL,
[own_resource_uuid] [binary] (16) NULL,
[discovery_asset_name] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[discovery_operating_sys] [nvarchar] (127) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[discovery_capacity] [float] NULL,
[discovery_capacity_unit] [int] NULL,
[creation_user] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[creation_date] [int] NULL,
[last_update_user] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[last_update_date] [int] NULL,
[version_number] [int] NULL CONSTRAINT [DF__arg_recon__versi__64CCF2AE] DEFAULT ('0'),
[dis_hw_uuid] [binary] (16) NULL,
[discovery_last_run_date] [int] NULL,
[discovery_processor_count] [int] NULL,
[discovery_processor_speed] [float] NULL,
[discovery_processor_speed_unit] [int] NULL,
[discovery_processor_type] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[discovery_total_disk_space] [float] NULL,
[discovery_total_disk_space_unt] [int] NULL,
[discovery_total_memory] [float] NULL,
[discovery_total_memory_unit] [int] NULL,
[tenant] [binary] (16) NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[arg_reconcile_data] ADD CONSTRAINT [XPKarg_reconcile_data] PRIMARY KEY CLUSTERED ([task_uuid], [reconcile_data_id]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [arg_reconcile_data_idx_01] ON [dbo].[arg_reconcile_data] ([task_uuid], [reconcile_data_type], [own_resource_uuid], [dis_hw_uuid]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[arg_reconcile_data] ADD CONSTRAINT [FK_ARG_RECONCILE_DATA_TENANT] FOREIGN KEY ([tenant]) REFERENCES [dbo].[ca_tenant] ([id])
GO
ALTER TABLE [dbo].[arg_reconcile_data] ADD CONSTRAINT [RDATJOIN01] FOREIGN KEY ([own_resource_uuid]) REFERENCES [dbo].[ca_owned_resource] ([own_resource_uuid])
GO
ALTER TABLE [dbo].[arg_reconcile_data] ADD CONSTRAINT [RDCUJOIN01] FOREIGN KEY ([discovery_capacity_unit]) REFERENCES [dbo].[ca_capacity_unit] ([id])
GO
ALTER TABLE [dbo].[arg_reconcile_data] ADD CONSTRAINT [RDCUJOIN02] FOREIGN KEY ([discovery_processor_speed_unit]) REFERENCES [dbo].[ca_capacity_unit] ([id])
GO
ALTER TABLE [dbo].[arg_reconcile_data] ADD CONSTRAINT [RDCUJOIN03] FOREIGN KEY ([discovery_total_disk_space_unt]) REFERENCES [dbo].[ca_capacity_unit] ([id])
GO
ALTER TABLE [dbo].[arg_reconcile_data] ADD CONSTRAINT [RDCUJOIN04] FOREIGN KEY ([discovery_total_memory_unit]) REFERENCES [dbo].[ca_capacity_unit] ([id])
GO
ALTER TABLE [dbo].[arg_reconcile_data] ADD CONSTRAINT [RDRTJOIN01] FOREIGN KEY ([task_uuid]) REFERENCES [dbo].[arg_reconcile_task] ([task_uuid])
GO
GRANT SELECT ON  [dbo].[arg_reconcile_data] TO [swcmadmin]
GRANT INSERT ON  [dbo].[arg_reconcile_data] TO [swcmadmin]
GRANT DELETE ON  [dbo].[arg_reconcile_data] TO [swcmadmin]
GRANT UPDATE ON  [dbo].[arg_reconcile_data] TO [swcmadmin]
GO