dbo.DialogRichMail

Mail templates

TableType TUsage CONFIGURATIONRows 67SizeMB 0.088

Table relation graph

Loading table relation graph…

Columns

NameTypeNullableOIM caption/commentaryFlags
UID_DialogRichMailvarchar(38)noMail templatePKUID
UID_DialogParameterSetvarchar(38)yesReport (parameter set)FKUID
Ident_DialogRichMailnvarchar(128)noMail template
XDateInserteddatetime(8)yesCreated on
XDateUpdateddatetime(8)yesModified on
XUserInsertednvarchar(128)yesCreated by
XUserUpdatednvarchar(128)yesModified by
XTouchednchar(2)yesProcessing status
XObjectKeyvarchar(138)noObject key
Sensitivitynvarchar(64)yesSensitivitylimited
Importanceint(4)yesImportancelimited
AllowUnsubscribebit(1)yesCan unsubscribe
MailDesignTypeint(4)yesDesign typelimited
TargetFormatnvarchar(32)noTarget formatlimited
Descriptionnvarchar(512)yesDescription
UID_DialogTableBaseObjectvarchar(38)yesBase objectFKUID
XMarkedForDeletionint(4)yesMarked for deletionbitmask
IsInActivebit(1)yesDisabled
AttachmentFileNamenvarchar(512)yesFile name (report attachment)

Relations

FKFromTo
CPL_RFRL1400ComplianceRule.UID_DialogRichMailNewViolationDialogRichMail.UID_DialogRichMail
POL_RFRL2600QERPolicy.UID_DialogRichMailNewViolationDialogRichMail.UID_DialogRichMail
QBM_RFRL303DialogRichMail.UID_DialogTableBaseObjectDialogTable.UID_DialogTable
QBM_RFRL305DialogRichMailBody.UID_DialogRichMailDialogRichMail.UID_DialogRichMail
QBM_RFRL307DialogMailNoSubscription.UID_DialogRichMailDialogRichMail.UID_DialogRichMail
QBM_RFRL317DialogRichMail.UID_DialogParameterSetDialogParameterSet.UID_DialogParameterSet
QER_RFRL2009PWODecisionMethod.UID_DialogRichMailExpirationDialogRichMail.UID_DialogRichMail
QER_RFRL2010PWODecisionMethod.UID_DialogRichMailAbortDialogRichMail.UID_DialogRichMail
QER_RFRL2011PWODecisionMethod.UID_DialogRichMailGrantDialogRichMail.UID_DialogRichMail
QER_RFRL2012PWODecisionMethod.UID_DialogRichMailNoGrantDialogRichMail.UID_DialogRichMail
QER_RFRL2013PWODecisionStep.UID_DialogRichMailInsertDialogRichMail.UID_DialogRichMail
QER_RFRL2014PWODecisionStep.UID_DialogRichMailReminderDialogRichMail.UID_DialogRichMail
QER_RFRL2015PWODecisionStep.UID_DialogRichMailGrantDialogRichMail.UID_DialogRichMail
QER_RFRL2016PWODecisionStep.UID_DialogRichMailNoGrantDialogRichMail.UID_DialogRichMail
QER_RFRL2017PWODecisionStep.UID_DialogRichMailEscalateDialogRichMail.UID_DialogRichMail
QER_RFRL305QERWorkingStep.UID_DialogRichMailToDelegatDialogRichMail.UID_DialogRichMail
QER_RFRL306QERWorkingStep.UID_DialogRichMailFromDelegatDialogRichMail.UID_DialogRichMail
QER_RFRL307QERWorkingStep.UID_DialogRichMailReminderDialogRichMail.UID_DialogRichMail
QER_RFRL308QERWorkingStep.UID_DialogRichMailEscalateDialogRichMail.UID_DialogRichMail
QER_RFRL309QERWorkingStep.UID_DialogRichMailInsertDialogRichMail.UID_DialogRichMail
QER_RFRL310QERWorkingStep.UID_DialogRichMailNoGrantDialogRichMail.UID_DialogRichMail
QER_RFRL311QERWorkingStep.UID_DialogRichMailGrantDialogRichMail.UID_DialogRichMail
QER_RFRL330PWODecisionMethod.UID_DialogRichMailProlongateDialogRichMail.UID_DialogRichMail
QER_RFRL331PWODecisionMethod.UID_DialogRichMailUnsubscribeDialogRichMail.UID_DialogRichMail
QER_RFRL4149PWODecisionStep.UID_DialogRichMailToDelegatDialogRichMail.UID_DialogRichMail

Triggers

GEN_T236716A15ACF53D35B9117415 SQL_TRIGGER

GEN_T31BD601EABB9F14FD0E7A94AA SQL_TRIGGER

GEN_T50C265D36F206E08DA37BFE9F SQL_TRIGGER

Referenced by / reverse relations

Generated from live DB metadata, FK rows, and exported SQL dependency/source extraction. This is factual linkage evidence, not inferred behavior.

Referencing objectRelationEvidence
dbo.GEN_T1AF1FD942F30912B5AF7846CESQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_T2B14B9477C202C5E94470B3C0SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_T50C265D36F206E08DA37BFE9FSQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_VPWOUseRichmailForSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.QER_VPWOUseRichmailForSQL expression dependencydbo · UID_DialogRichMail · OBJECT_OR_COLUMN
dbo.QER_VPWOUseRichmailForSQL expression dependencydbo · UID_DialogTableBaseObject · OBJECT_OR_COLUMN
ComplianceRuleforeign key references tableCPL_RFRL1400: ComplianceRule.UID_DialogRichMailNewViolation -> DialogRichMail.UID_DialogRichMail
QERPolicyforeign key references tablePOL_RFRL2600: QERPolicy.UID_DialogRichMailNewViolation -> DialogRichMail.UID_DialogRichMail
DialogTablereferenced by foreign key from tableQBM_RFRL303: DialogRichMail.UID_DialogTableBaseObject -> DialogTable.UID_DialogTable
DialogRichMailBodyforeign key references tableQBM_RFRL305: DialogRichMailBody.UID_DialogRichMail -> DialogRichMail.UID_DialogRichMail
DialogMailNoSubscriptionforeign key references tableQBM_RFRL307: DialogMailNoSubscription.UID_DialogRichMail -> DialogRichMail.UID_DialogRichMail
DialogParameterSetreferenced by foreign key from tableQBM_RFRL317: DialogRichMail.UID_DialogParameterSet -> DialogParameterSet.UID_DialogParameterSet
PWODecisionMethodforeign key references tableQER_RFRL2009: PWODecisionMethod.UID_DialogRichMailExpiration -> DialogRichMail.UID_DialogRichMail
PWODecisionMethodforeign key references tableQER_RFRL2010: PWODecisionMethod.UID_DialogRichMailAbort -> DialogRichMail.UID_DialogRichMail
PWODecisionMethodforeign key references tableQER_RFRL2011: PWODecisionMethod.UID_DialogRichMailGrant -> DialogRichMail.UID_DialogRichMail
PWODecisionMethodforeign key references tableQER_RFRL2012: PWODecisionMethod.UID_DialogRichMailNoGrant -> DialogRichMail.UID_DialogRichMail
PWODecisionStepforeign key references tableQER_RFRL2013: PWODecisionStep.UID_DialogRichMailInsert -> DialogRichMail.UID_DialogRichMail
PWODecisionStepforeign key references tableQER_RFRL2014: PWODecisionStep.UID_DialogRichMailReminder -> DialogRichMail.UID_DialogRichMail
PWODecisionStepforeign key references tableQER_RFRL2015: PWODecisionStep.UID_DialogRichMailGrant -> DialogRichMail.UID_DialogRichMail
PWODecisionStepforeign key references tableQER_RFRL2016: PWODecisionStep.UID_DialogRichMailNoGrant -> DialogRichMail.UID_DialogRichMail
PWODecisionStepforeign key references tableQER_RFRL2017: PWODecisionStep.UID_DialogRichMailEscalate -> DialogRichMail.UID_DialogRichMail
QERWorkingStepforeign key references tableQER_RFRL305: QERWorkingStep.UID_DialogRichMailToDelegat -> DialogRichMail.UID_DialogRichMail
QERWorkingStepforeign key references tableQER_RFRL306: QERWorkingStep.UID_DialogRichMailFromDelegat -> DialogRichMail.UID_DialogRichMail
QERWorkingStepforeign key references tableQER_RFRL307: QERWorkingStep.UID_DialogRichMailReminder -> DialogRichMail.UID_DialogRichMail
QERWorkingStepforeign key references tableQER_RFRL308: QERWorkingStep.UID_DialogRichMailEscalate -> DialogRichMail.UID_DialogRichMail
QERWorkingStepforeign key references tableQER_RFRL309: QERWorkingStep.UID_DialogRichMailInsert -> DialogRichMail.UID_DialogRichMail
QERWorkingStepforeign key references tableQER_RFRL310: QERWorkingStep.UID_DialogRichMailNoGrant -> DialogRichMail.UID_DialogRichMail
QERWorkingStepforeign key references tableQER_RFRL311: QERWorkingStep.UID_DialogRichMailGrant -> DialogRichMail.UID_DialogRichMail
PWODecisionMethodforeign key references tableQER_RFRL330: PWODecisionMethod.UID_DialogRichMailProlongate -> DialogRichMail.UID_DialogRichMail
PWODecisionMethodforeign key references tableQER_RFRL331: PWODecisionMethod.UID_DialogRichMailUnsubscribe -> DialogRichMail.UID_DialogRichMail
PWODecisionStepforeign key references tableQER_RFRL4149: PWODecisionStep.UID_DialogRichMailToDelegat -> DialogRichMail.UID_DialogRichMail
cs-common-customizer-vi-common-customizer-dialogrichmail.csdecompiled C# referenceclasses DialogRichMail, _003C_003Ec__DisplayClass1_0; methods MoveNext, SetStateMachine, _003C_CopyAsync_003Eb__1, _CopyAsync; references DialogParameter, DialogParameterSet, DialogRichMail, DialogRichMailBody, DialogRichMailImage; markers reads entity values, saves entities, references DB/Dialog objects
cs-cpl-forms-cpl-forms-formcompliancerulemasterdata.csdecompiled C# referenceclasses FormComplianceRuleMasterData; methods OnInit, InitializeComponent, OnFormLoad, Task_RecalculateRule, Task_RecalculatePerson, Task_RecalculateAll; references AERole, ComplianceGroup, ComplianceRule, Department, DialogRichMail, DialogSchedule; markers reads entity values, writes entity values, references DB/Dialog objects, IT Shop related markers
cs-pol-forms-pol-forms-formqerpolicymasterdata.csdecompiled C# referenceclasses FormQERPolicyMasterData; methods OnInit, InitializeComponent, OnFormSizeChanged, OnFormLoad, OnFormUnload, _DisconnectUIEngineUserSettings; references AERole, DialogDashboardDef, DialogReport, DialogRichMail, DialogSchedule, DialogTable; markers reads entity values, references DB/Dialog objects
cs-qbm-forms-vi-common-forms-frmdialogrichmailstammdaten.csdecompiled C# referenceclasses FrmDialogRichMailStammdaten; methods OnInit, OnDispose, OnDesignChanged, InitializeComponent, OnFormLoad, OnFormSizeChanged; references DialogCountry, DialogCountryHasCulture, DialogParameter, DialogParameterSet, DialogReport, DialogRichMail; markers reads entity values, references DB/Dialog objects
cs-qer-customizer-qer-customizer-pwodecisionmethod.csdecompiled C# referenceclasses PWODecisionMethod, _003C_003Ec__DisplayClass3_0; methods _003C_Check_PWODecisionSubMethod_003Eb__0, MoveNext, SetStateMachine, GetValidityMessages, GetMessages, _Check_PWODecisionSubMethod; references DialogRichMail, OrgType, PWODecisionMethod, PWODecisionSubMethod; markers reads entity values, references DB/Dialog objects