MARIProject Database Structure

View Name:MARITenantActions
Based on table:MPTenantActions
Group:Group: TenantEnvironments
Description:Action table to store (CreateUser, ChangeUser) Actions in the master database. To be consumed via web service or MARIService
ClassID: 650. See Overview of ClassIDs by table.

Field Table(Germ.field)/Type Description Related
TenantActionID TenantActionID

INT Primary

TenantID TenantID

INT Index

MARITenantTenants.TenantID
TenantUserID TenantUserID

INT Index

MARITenantUsers.TenantUserID
TenantUserDBLinkID TenantUserDBLinkID

INT Index

MARITenantUsersDBLink.TenantUserDBLinkID
ActionType ActionType

INT

ActionStatus ActionStatus

INT

ActionDescription ActionDescription

NVARCHAR (255)

ActionProdedure ActionProdedure

NVARCHAR (255)

ActionParameter ActionParameter

NTEXT

JSCN Content of the Action
CreateDate CreateDate

Datetime

CreateUser CreateUser

NVARCHAR (100)

MARIUser.CreateUser (WHERE BenutzerTyp=1)
CreateClient CreateClient

NVARCHAR (100)

ActionTransmitDate ActionTransmitDate

Datetime

ActionTransmitStatus ActionTransmitStatus

INT

ActionTransmitMethod ActionTransmitMethod

INT

ActionProcessingDate ActionProcessingDate

Datetime

ActionProcessingUser ActionProcessingUser

NVARCHAR (100)

Name of the remote user
ActionProcessingClient ActionProcessingClient

NVARCHAR (100)

Name of the remote machine
ActionProcessingResult ActionProcessingResult

INT

ActionProcessingMsg ActionProcessingMsg

NTEXT

JSON Content of the result

Linked by

Table Description
MARITenantUsersDBLink Management of MARIProject/SBO client installation licenses, rights


Back to table description

Database Version 80
© by MARINGO Computers GmbH, Cologne Germany