CREATE TABLE [dbo].[al_reconcile_rule_criteria]
(
[task_uuid] [binary] (16) NOT NULL,
[criteria_id] [int] NOT NULL,
[translation_list_id] [int] NOT NULL CONSTRAINT [DF__AL_RECONC__TRANS__40106F4B] DEFAULT ('0 '),
[trim_own_left] [int] NOT NULL CONSTRAINT [DF__AL_RECONC__TRIM___41049384] DEFAULT ('0 '),
[trim_own_right] [int] NOT NULL CONSTRAINT [DF__AL_RECONC__TRIM___41F8B7BD] DEFAULT ('0 '),
[trim_disc_left] [int] NOT NULL CONSTRAINT [DF__AL_RECONC__TRIM___42ECDBF6] DEFAULT ('0 '),
[trim_disc_right] [int] NOT NULL CONSTRAINT [DF__AL_RECONC__TRIM___43E1002F] DEFAULT ('0 '),
[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__AL_RECONC__VERSI__44D52468] DEFAULT ('0')
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[al_reconcile_rule_criteria] ADD CONSTRAINT [xpkal_reconcile_rule_criteria] PRIMARY KEY CLUSTERED ([task_uuid], [criteria_id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[al_reconcile_rule_criteria] ADD CONSTRAINT [AL_RECON_RULE_CRITERIA_FK01] FOREIGN KEY ([criteria_id]) REFERENCES [dbo].[al_criteria_def] ([criteria_id])
GO
ALTER TABLE [dbo].[al_reconcile_rule_criteria] ADD CONSTRAINT [AL_RECON_RULE_CRITERIA_FK02] FOREIGN KEY ([task_uuid]) REFERENCES [dbo].[arg_reconcile_task] ([task_uuid])
GO