MARIProject Database Structure

Table Name:MPServiceJob
View Name:MARIServiceJobs
Group:Group: ServiceJob
Description:MARIService: Service Job header
ClassID: 133. See Overview of ClassIDs by table.

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

INT Primary

ServiceType ServiceType

INT Index

ServiceName ServiceName

NVARCHAR (50)

ServicePriority ServicePriority

INT Index

NotificationMode NotificationMode

INT

NotificationEMail1 NotificationEMail1

NVARCHAR (200)

NotificationEMail2 NotificationEMail2

NVARCHAR (200)

NotificationTextID NotificationTextID

INT

MPSysClassNotificationText.NotifTextID
NotificationText2ID NotificationText2ID

INT Index

MPSysClassNotificationText.NotifTextID
LogLevel LogLevel

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)
Memo Memo

NTEXT

OptionMemo OptionMemo

NTEXT

UpdateStamp UpdateStamp

INT


Linked by

Table Description
MPServiceJobParameter MARIService: Service Job settings
MPServiceJobSchedule MARIService: Service Job timing
MPServiceJournal MARIService: Service Job log header


Back to table description

Database Version 80
© by MARINGO Computers GmbH, Cologne Germany