ict.ken.be

Delivering solid user friendly software solutions since the dawn of time.

Messagent System Tables

Categories: Messagent

This list should be used as a guideline and is not reflecting the newest versions of Messagent.

  • ACTIONQUEUE 

This table serves as the outqueue for the email channel. Every record contains the definition for one email to be send.

  •   ACTIONQUEUE_SMTPINFO

This table contains additional information for every failed ACTIONQUEUE record.

  •   ACTIONQUEUE_STATES

Lookup table containing the different actionqueue states

  • ACTIONRESULT

Internally used by Mailagent

  • API_EVENTLOG

Table with logging for Automation API events

  • CAMPAIGN_MAILS

Express: Link between Campaign and Email

  • CAMPAIGN_STATES

Deprecated, different campaign states

  • CAMPAIGNS

Table containing all campaign definitions

  • CAMPAIGNTRIGGERFLAGS

Table containing the triggers that can launch a ‘triggered’ campaign.

  • CHANNELAGENTINSTANCES

Contains instances of channelagent that are currently running. Filled by the channelagent at startup, allows the user to select one of the specific instances

  • CHANNELBATCH

Table that contains the different data batches, delivered to external channel.

  • CHANNELCAMPAIGNS

Link between channel and campaigns

  • CHANNELINQUEUE

Queue that stores incoming events on a Messagent channelAgent. Every record represents one incoming event.

  • CHANNELMODPARAMS

Parameters required by custom channel modules. Custom modules automatically enter their parameters inside this table at registration.

  • CHANNELMODS

Installed channel modules

  • CHANNELOUTQUEUE

Queue that stores outgoing events, every record represent one outbound channel event.

  • CHANNELPARAMS

Parameters defined by the user for a certain channel

  • CHANNELS

Channel definitions

  • COMMONXML

Deprecated, contained global xml information

  • DATASPACES

Defintion of dataspaces.

  • EXPORT_FILES

Overview of files generated by the export module

  • EXPORT_IDS

Overview of id’s of records that are linked to a certain export file. Used for differential exports and for tracking.

  • EXPORT_JOBLOGS

Deprecated

  • EXPORT_JOBS

Deprecated

  • EXPORT_LOGS

Deprecated

  • EXPORTS

Defintion of Exports

  • FIELDS

Table containing additional information about Fields in the lists (multiselect, options,..)

  • FLAGS

Storage for all platform interactions.

  • GATE_LOGS

Logging for external API Gate calls.

  • GATES

Defintion of gates (API)

  • INCIDENTS

Table tracking all online 1:1 that occurred, when a 1:1 operation fails within the platform this table will contain an incident record with all relevant information.

  • LABELS

Table containing labels (text replacements used in emails)

  • LANGUAGES

Lookup table containing all used languages

  • LISTLINKS

Table describing the relation in between lists

  • LISTS

Table describing all lists

  • MAIL_ARTICLES

Table describing what articles are used in a certain email (Automation)

  • MAILS

Table containing all emails / pages

  • MAILTREE

Table containing the different tree structures

  • MODULES

Table containing the current state of all backoffice modules. Every backoffice modules registeres at a configurable interval in this table.

  • NAMESPACES

Lookup table used to categorize labels

  • OP_EVENTS

Table tracking user actions within the Messagent tools.

  • OP_GROUPS

Table containing all groups defined in the system

  • OP_RIGHTS

Table containing the rights users have on the different assets

  • OP_USERS

Table containing all (business) users

  • OPTIONLISTS

Table containing all optionlists. An optionlist is a definition of key/values that can be used to translate fields values.

  • OPTIONS

Table containing the key values pair for the optionlists when they are stored within the messagent database model.

  • PROBES

Table containing custom sensors

  • REPORTCACHE

Caching table contains aggregated reporting information per campaign. Generated and maintained by the reporting

  • REPORTCACHEDEF

Caching table contains aggregated reporting information per campaign. Generated and maintained by the reporting

  • SEGMENTIDIMPORTS

Overview of all imports that occurred on a static segment

  • SEGMENTIDS

Overview of all ids that are linked to a static segment

  • SEGMENTS

Defintion of both static as dynamic segments

  • SETTINGS

Table containing system wide configuration options

  • SHAREDVARS

Table containing values for Shared Variables, used in campaign flows.

  • SURVEY_DEPLOYS

Table containing deployment of surveys.

  • SURVEY_INCIDENTS

Table containing incidents created by 1:1 actions within surveys

  • SURVEY_STYLES

Table containing styles that are used witin surveys

  • SURVEYS

Table containing all survey definitions

  • WEBFOLDERS

Table containing the definition of webfolders.