Tables [dbo].[ActionHandlerSettings]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created1:20:01 AM Thursday, March 21, 2019
Last Modified1:20:11 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentityDefault
Cluster Primary Key PK_ActionHandlerSettings_ID: IDIDint4
False
1 - 1
Foreign Keys FK_ActionHandlerSettings_DealerID_Account_AccountID: [dbo].[Account].DealerIDDealerIDint4
False
Foreign Keys FK_ActionHandlerSettings_ActionDefID_ActionDef_ID: [dbo].[ActionDef].ActionDefIDActionDefIDint4
True
ActionResultTypesmallint2
False
AlertFrequencyTypesmallint2
True
((0))
ActionContactTypesmallint2
True
DealerPrimaryContactTypesmallint2
True
AlternateDealerUserContactIDint4
True
AlternateDealerUserContactNamenvarchar(100)200
True
AlternateDealerUserContactEmailnvarchar(100)200
True
AlternateAccountContactIDint4
True
AlternateAccountContactNamenvarchar(100)200
True
AlternateAccountContactEmailnvarchar(100)200
True
CustomRecipientnvarchar(1024)2048
True
ERPSyncTypesmallint2
True
ServiceUrlvarchar(1024)1024
True
ReqAuthenticationbit1
True
UserNamenvarchar(100)200
True
Passwordnvarchar(100)200
True
XmlDataxmlmax
True
Foreign Keys FK_ActionHandlerSettings_BaseSettingsID_ActionHandlerSettings_ID: [dbo].[ActionHandlerSettings].BaseSettingsIDBaseSettingsIDint4
True
SMSServiceProvidernvarchar(100)200
True
SMSServiceAccountnvarchar(100)200
True
CustomEmailTemplateNamenvarchar(256)512
True
KeyNameKey ColumnsUnique
Cluster Primary Key PK_ActionHandlerSettings_ID: IDPK_ActionHandlerSettings_IDID
True
NameDeleteColumns
FK_ActionHandlerSettings_ActionDefID_ActionDef_IDCascadeActionDefID->[dbo].[ActionDef].[ID]
FK_ActionHandlerSettings_BaseSettingsID_ActionHandlerSettings_IDBaseSettingsID->[dbo].[ActionHandlerSettings].[ID]
FK_ActionHandlerSettings_DealerID_Account_AccountIDDealerID->[dbo].[Account].[AccountID]
CREATE TABLE [dbo].[ActionHandlerSettings]
(
[ID] [int] NOT NULL IDENTITY(1, 1),
[DealerID] [int] NOT NULL,
[ActionDefID] [int] NULL,
[ActionResultType] [smallint] NOT NULL,
[AlertFrequencyType] [smallint] NULL CONSTRAINT [DF_ActionHandlerSettings_AlertFrequencyType] DEFAULT ((0)),
[ActionContactType] [smallint] NULL,
[DealerPrimaryContactType] [smallint] NULL,
[AlternateDealerUserContactID] [int] NULL,
[AlternateDealerUserContactName] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AlternateDealerUserContactEmail] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AlternateAccountContactID] [int] NULL,
[AlternateAccountContactName] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AlternateAccountContactEmail] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CustomRecipient] [nvarchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ERPSyncType] [smallint] NULL,
[ServiceUrl] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ReqAuthentication] [bit] NULL,
[UserName] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Password] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[XmlData] [xml] NULL,
[BaseSettingsID] [int] NULL,
[SMSServiceProvider] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SMSServiceAccount] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CustomEmailTemplateName] [nvarchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ActionHandlerSettings] ADD CONSTRAINT [PK_ActionHandlerSettings_ID] PRIMARY KEY CLUSTERED  ([ID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ActionHandlerSettings] ADD CONSTRAINT [FK_ActionHandlerSettings_ActionDefID_ActionDef_ID] FOREIGN KEY ([ActionDefID]) REFERENCES [dbo].[ActionDef] ([ID]) ON DELETE CASCADE
GO
ALTER TABLE [dbo].[ActionHandlerSettings] ADD CONSTRAINT [FK_ActionHandlerSettings_BaseSettingsID_ActionHandlerSettings_ID] FOREIGN KEY ([BaseSettingsID]) REFERENCES [dbo].[ActionHandlerSettings] ([ID])
GO
ALTER TABLE [dbo].[ActionHandlerSettings] ADD CONSTRAINT [FK_ActionHandlerSettings_DealerID_Account_AccountID] FOREIGN KEY ([DealerID]) REFERENCES [dbo].[Account] ([AccountID])
GO