CREATE TABLE [dbo].[arg_reconcile_rule]
(
[task_uuid] [binary] (16) NOT NULL,
[rule_id] [smallint] NOT NULL,
[own_resource_field_name] [smallint] NULL,
[discovery_field_name] [smallint] NULL,
[translation_list_id] [int] NULL,
[operator_type_indicator] [smallint] 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__6D6238AF] DEFAULT ('0'),
[tenant] [binary] (16) NULL,
[trim_own_left] [int] NOT NULL CONSTRAINT [DF__ARG_RECON__TRIM___522F1F86] DEFAULT ('0'),
[trim_own_right] [int] NOT NULL CONSTRAINT [DF__ARG_RECON__TRIM___532343BF] DEFAULT ('0'),
[trim_disc_right] [int] NOT NULL CONSTRAINT [DF__ARG_RECON__TRIM___541767F8] DEFAULT ('0'),
[trim_disc_left] [int] NOT NULL CONSTRAINT [DF__ARG_RECON__TRIM___550B8C31] DEFAULT ('0')
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[arg_reconcile_rule] ADD CONSTRAINT [XPKarg_reconcile_rule] PRIMARY KEY CLUSTERED ([task_uuid], [rule_id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[arg_reconcile_rule] ADD CONSTRAINT [FK_ARG_RECONCILE_RULE_TENANT] FOREIGN KEY ([tenant]) REFERENCES [dbo].[ca_tenant] ([id])
GO
ALTER TABLE [dbo].[arg_reconcile_rule] ADD CONSTRAINT [RRLDJOIN01] FOREIGN KEY ([translation_list_id]) REFERENCES [dbo].[arg_listdef] ([ldid])
GO
ALTER TABLE [dbo].[arg_reconcile_rule] ADD CONSTRAINT [RRRTJOIN01] FOREIGN KEY ([task_uuid]) REFERENCES [dbo].[arg_reconcile_task] ([task_uuid])
GO
ALTER TABLE [dbo].[arg_reconcile_rule] ADD CONSTRAINT [RRSLJOIN01] FOREIGN KEY ([discovery_field_name]) REFERENCES [dbo].[arg_sl_dis_match_fields] ([id])
GO
ALTER TABLE [dbo].[arg_reconcile_rule] ADD CONSTRAINT [RRSLJOIN02] FOREIGN KEY ([own_resource_field_name]) REFERENCES [dbo].[arg_sl_own_match_fields] ([id])
GO
GRANT SELECT ON  [dbo].[arg_reconcile_rule] TO [swcmadmin]
GRANT INSERT ON  [dbo].[arg_reconcile_rule] TO [swcmadmin]
GRANT DELETE ON  [dbo].[arg_reconcile_rule] TO [swcmadmin]
GRANT UPDATE ON  [dbo].[arg_reconcile_rule] TO [swcmadmin]
GO