MARIProject Database Structure

Table Name:MPNewsletterConnector
View Name:MARINewsletterConnector
Group:Group: NewsletterMaster
Description:Store special email server connections

Field View(engl.field)/Type Description Related
NewsletterConnectorID NewsletterConnectorID

INT Primary

ConnectorName ConnectorName

NVARCHAR (100)

ConnectorMethod ConnectorMethod

INT

EMailFrom EMailFrom

NVARCHAR (255)

EMailTo EMailTo

NVARCHAR (255)

EMailReplyTo EMailReplyTo

NVARCHAR (255)

SMTPServer SMTPServer

NVARCHAR (255)

SMTPUser SMTPUser

NVARCHAR (255)

SMTPPWD SMTPPWD

NTEXT

SMTPAuth SMTPAuth

NVARCHAR (255)

SMTPAuthMode SMTPAuthMode

INT

SMTPEnconding SMTPEnconding

INT

BCCCCMode BCCCCMode

INT

InternalMailsRealSender InternalMailsRealSender

INT

EWSVersion EWSVersion

INT

EWSMailDomain EWSMailDomain

NVARCHAR (255)

EWSURL EWSURL

NVARCHAR (255)

EWSUser EWSUser

NVARCHAR (255)

EWSPWD EWSPWD

NTEXT

EWSImpersonation EWSImpersonation

INT

OAuth2_ClientID OAuth2_ClientID

NTEXT

OAuth2_TenantID OAuth2_TenantID

NTEXT

OAuth2_ClientSecret OAuth2_ClientSecret

NTEXT

OAuth2_Activate OAuth2_Activate

INT

OAuth2_MFA_Activated OAuth2_MFA_Activated

INT

ConnectorSettings ConnectorSettings

NTEXT

CreateDate CreateDate

Datetime

CreateUser CreateUser

NVARCHAR (4)

MPBenutzer.Benutzer (WHERE BenutzerTyp=1)
ChangeDate ChangeDate

Datetime

ChangeUser ChangeUser

NVARCHAR (4)

MPBenutzer.Benutzer (WHERE BenutzerTyp=1)
Memo Memo

NTEXT

InActive InActive

SMALLINT (0=false,-1=true)

UpdateStamp UpdateStamp

INT Index


Linked by

Table Description
MPNewsletterMaster Newsletter Design Template


Back to table description

Database Version 80
© by MARINGO Computers GmbH, Cologne Germany