MARIProject Database Structure

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

Field Table(Germ.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

MARISysConnections.CompanyID (WHERE ConnectionType=6)
ListOrder ListOrder

INT

Active Active

SMALLINT (0=false,-1=true)

MethodID Method

INT

Email eMail

NVARCHAR (255)

TextID TextID

INT Index

MARIClassNotificationText.TextID
AttachmentMethod AttachmentMethod

INT

EventOptionFlag EventOptionFlag

INT

CreateDate Erstanlage

Datetime

CreateUser ErstanlageID

NVARCHAR (4)

MARIUser.CreateUser (WHERE BenutzerTyp=1)
ChangeDate Aenderung

Datetime

ChangeUser AenderungID

NVARCHAR (4)

MARIUser.ChangeUser (WHERE BenutzerTyp=1)
UpdateStamp UpdateStamp

INT


Linked by

Table Description
MARIReminder System: Reminder


Back to table description

Database Version 80
© by MARINGO Computers GmbH, Cologne Germany