CREATE TABLE [dbo].[al_export_def]
(
[export_id] [bigint] NOT NULL,
[name] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[description] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[processor_id] [int] NOT NULL,
[search_id] [bigint] NOT NULL,
[status_id] [int] NULL CONSTRAINT [DF__AL_EXPORT__STATU__4E88ABD4] DEFAULT ('0 '),
[schedule_id] [bigint] NULL,
[role_id] [int] NOT NULL,
[contact_uuid] [binary] (16) NOT NULL,
[contacts_scope] [int] NOT NULL,
[tenant] [binary] (16) NULL,
[folder_name] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[retention_days] [int] NULL,
[last_run_date] [datetime] NULL,
[last_due_run_date] [datetime] 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__AL_EXPORT__VERSI__4F7CD00D] DEFAULT ('0     '),
[never_expires] [int] NULL,
[view_name] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CS_AS NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[al_export_def] ADD CONSTRAINT [pk_al_export_def] PRIMARY KEY CLUSTERED ([export_id]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [al_export_def_idx_01] ON [dbo].[al_export_def] ([name]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[al_export_def] ADD CONSTRAINT [AL_EXPORT_DEF_FK01] FOREIGN KEY ([processor_id]) REFERENCES [dbo].[al_export_processor] ([processor_id])
GO
ALTER TABLE [dbo].[al_export_def] ADD CONSTRAINT [AL_EXPORT_DEF_FK02] FOREIGN KEY ([search_id]) REFERENCES [dbo].[al_search_def] ([search_id])
GO
ALTER TABLE [dbo].[al_export_def] ADD CONSTRAINT [AL_EXPORT_DEF_FK03] FOREIGN KEY ([status_id]) REFERENCES [dbo].[al_export_status] ([status_id])
GO
ALTER TABLE [dbo].[al_export_def] ADD CONSTRAINT [AL_EXPORT_DEF_FK04] FOREIGN KEY ([schedule_id]) REFERENCES [dbo].[al_schedule_def] ([schedule_id])
GO
ALTER TABLE [dbo].[al_export_def] ADD CONSTRAINT [AL_EXPORT_DEF_FK05] FOREIGN KEY ([tenant]) REFERENCES [dbo].[ca_tenant] ([id])
GO
ALTER TABLE [dbo].[al_export_def] ADD CONSTRAINT [AL_EXPORT_DEF_FK06] FOREIGN KEY ([contact_uuid]) REFERENCES [dbo].[ca_contact] ([contact_uuid])
GO
ALTER TABLE [dbo].[al_export_def] ADD CONSTRAINT [AL_EXPORT_DEF_FK07] FOREIGN KEY ([role_id]) REFERENCES [dbo].[al_role_def] ([role_id])
GO