Tables [dbo].[FMAInstallerSettings]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created1:20:02 AM Thursday, March 21, 2019
Last Modified1:20:24 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentity
Cluster Primary Key PK_FMAInstallerSettings_ID: IDIDint4
False
1 - 1
Typesmallint2
False
CreateContactIDint4
True
CreateAccountIDint4
True
CreateDatedatetime8
False
TemplateNamenvarchar(256)512
True
AuthenticationGUIDuniqueidentifier16
True
EmailSettingsXMLxmlmax
False
InstallTypesmallint2
False
WebAuditSettingsXMLxmlmax
True
GlobalProxyXMLxmlmax
True
GlobalBusinessHoursXMLxmlmax
True
GlobalSubnetsXMLxmlmax
True
GlobalExcludedIPsXMLxmlmax
True
IsDefaultbit1
False
Timestampbigint8
False
Foreign Keys FK_FMAInstallerSettings_InstanceID_AccountOnsiteInstance_ID: [dbo].[AccountOnsiteInstance].InstanceIDInstanceIDint4
True
KeyNameKey ColumnsUnique
Cluster Primary Key PK_FMAInstallerSettings_ID: IDPK_FMAInstallerSettings_IDID
True
NameUpdateDeleteColumns
FK_FMAInstallerSettings_InstanceID_AccountOnsiteInstance_IDCascadeCascadeInstanceID->[dbo].[AccountOnsiteInstance].[ID]
CREATE TABLE [dbo].[FMAInstallerSettings]
(
[ID] [int] NOT NULL IDENTITY(1, 1),
[Type] [smallint] NOT NULL,
[CreateContactID] [int] NULL,
[CreateAccountID] [int] NULL,
[CreateDate] [datetime] NOT NULL,
[TemplateName] [nvarchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AuthenticationGUID] [uniqueidentifier] NULL,
[EmailSettingsXML] [xml] NOT NULL,
[InstallType] [smallint] NOT NULL,
[WebAuditSettingsXML] [xml] NULL,
[GlobalProxyXML] [xml] NULL,
[GlobalBusinessHoursXML] [xml] NULL,
[GlobalSubnetsXML] [xml] NULL,
[GlobalExcludedIPsXML] [xml] NULL,
[IsDefault] [bit] NOT NULL,
[Timestamp] [bigint] NOT NULL,
[InstanceID] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[FMAInstallerSettings] ADD CONSTRAINT [PK_FMAInstallerSettings_ID] PRIMARY KEY CLUSTERED  ([ID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[FMAInstallerSettings] ADD CONSTRAINT [FK_FMAInstallerSettings_InstanceID_AccountOnsiteInstance_ID] FOREIGN KEY ([InstanceID]) REFERENCES [dbo].[AccountOnsiteInstance] ([ID]) ON DELETE CASCADE ON UPDATE CASCADE
GO