MARIProject Database Structure

Table Name:MPSysClassNotification
View Name:MARISysClassNotification
Group:
Description:Event Management: Definition of used events by master data dimension

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

INT Primary

ClassID
Event Event

INT Primary

SubEvent SubEvent

INT Primary

Audience Audience

INT Primary

CompanyID CompanyID

SMALLINT Primary

MPSysConnections.CompanyID (WHERE ConnectionType=6)
ListOrder ListOrder

INT

Active Active

SMALLINT (0=false,-1=true)

Method MethodID

INT

eMail Email

NVARCHAR (255)

TextID TextID

INT Index

MPSysClassNotificationText.NotifTextID
AttachmentMethod AttachmentMethod

INT

EventOptionFlag EventOptionFlag

INT

Erstanlage CreateDate

Datetime

ErstanlageID CreateUser

NVARCHAR (4)

MPBenutzer.Benutzer (WHERE BenutzerTyp=1)
Aenderung ChangeDate

Datetime

AenderungID ChangeUser

NVARCHAR (4)

MPBenutzer.Benutzer (WHERE BenutzerTyp=1)
UpdateStamp UpdateStamp

INT


Linked by

Table Description
MPWiedervorlagen System: Reminder


Back to table description

Database Version 80
© by MARINGO Computers GmbH, Cologne Germany