admin_group_permission_tbl 
Column name: 	Description: 
admin_group_id 	ID of the admin group (-> admin_group_tbl) 
security_token 	Rights of the user 

Table description: 

Contains the individual rights of the admin group. The groups are defined in the admin_group_tbl.
 


admin_group_tbl 
Column name: 	Description: 
admin_group_id 	ID of the admin group. 
company_id 	References company_tbl 
description 	Description of the admin group 
shortname 	Name of the admin group 

Table description: 

Contains client specific admin groups. The rights of the groups are registered in the admin_group_permission_tbl.
 


admin_permission_tbl 
Column name: 	Description: 
admin_id 	ID of the admins (Admin_tbl). 
security_token 	Name of the token. 

Table description: 

Contains the rights of the admins.
 


admin_tbl 
Column name: 	Description: 
admin_id 	Consecutive number. Sequence: admin_tbl_seq 
admin_country 	Home country of the admin (eg. 'de', 'us'). 
admin_lang 	Language of the admins (eg. 'de', 'us'). 
admin_timezone 	Timezone of the admins. 
creation_date 	Date of the entry. 
layout_id 	User defined layout of the admin (emm_layout_tbl). 
pwdchange 	Last change of passwort. 
username 	User name 
timestamp 	Date of the last entry or last change. 
pwd_hash	Password as MD5-Hash
fullname 	Name shown in the OpenEMM frontend 
admin_lang_variant 	Variation of the timezone (eg. de_at) 
admin_group_id 	ID of the admin group(-> admin_group_tbl) 
company_id 	References company_tbl 

Table description: 

Contains the individual user of the OpenEMM.
 



bounce_tbl 
Column name: 	Description: 
bounce_id 	Consecutive number 
company_id 	References company_tbl 
customer_id 	recipient of mail 
detail 		Normalized bounce code, five possible values 
dsn 		Code reported by the mail system or pseudo code 499 for soft bounces, resp. 599 for hard bounces 
mailing_id 	The mailing that generated the bounce 
change_date 	Date of the last entry or last change.

Table description: 

This table contains all soft and hard bounces unfiltered. The hard bounces are registered in the correspondending binding table. The soft bounces are worked off once per night and entered into another table to be further processed.
 


campaign_tbl 
Column name: 	Description: 
campaign_id 	ID of the campaign 
company_id 	References company_tbl 
description 	Description of the campaign 
shortname 	Name of the campaign 

Table description: 

Contains the campaign information
 


company_tbl 
Column name: 	Description: 
company_id 	Unique ID 
creation_date 	Date of the entry. 
creator_company_id 	ID of that account, out of which this account was generated. 
description 	Description of the client. 
notification_email 	Email address that receives a note for every export. 
rdir_domain 	Domain for the Rdir links 
shortname 	Name of the client. 
status 		Status of the client. Possible values are "active", "inactive". 
timestamp 	Date of the last entry, resp. last change. 
xor_key 	Key for link encryption. 
mailloop_domain 	FQ Domainname used for the mailloop

Table description: 

Contains basic settings for the OpenEMM.
 



component_tbl 
Column name: 	Description: 
component_id 	Consecutive number, sequence: COMPONENT_TBL_SEQ 
company_id 	References company_tbl 
comptype 	Type of the component: 0: Parsable text 1: Embedded binary (e.g. pictures) 
target_id 	Reference to dyn_target_tbl, if this component has a selection. 
mtype 		MIME type of the component. 
mailing_id 	Reference to mailing_tbl. 
emmblock 	The content of the component as text 
compname 	Name of this component. Reserverd names are starting with "agn" (e.g. agnText, agnHtml). 
binblock	The content of the component as binary


Table description: 

All elements of a mailing are stored here, each element in a separate record.
 


cust_ban_tbl
Column name: 	Description:
company_id 	References company_tbl
email 		Email-Address of the Receipient

Table descrition:

Contains Adresses which must excluded from mailings



customer_1_binding_tbl 
Column name: 	Description: 
mailinglist_id 	ID of the mailing list(-> mailinglist_tbl) 
mediatype 	Media type: 0 = Email, 1 = SMS 
creation_date 	Date of the entry 
user_status 	Status of the recipients on the mailing list: 1 = active, 2 = bounced, 3 = Opt-out by admin, 4 = Opt-out by user  
user_type 	Type of the recipient: A = admin recipient, T = test recipient, W = normal recipient 
user_remark 	Notes of the binding. 
exit_mailing_id 	ID of the mailing the recipient has bounced off (-> mailing_tbl) 
customer_id 	ID of the recipient (-> customer_1_tbl ) 
change_date 	Date of the last entry or last change.

Table description: 

Assignment of the recipients of the customer_1_tbl to the mailing lists.
 


customer_1_tbl 
Column name: 	Description: 
customer_id 	ID of the recipient. Generated out of the sequence customer_1_tbl_seq. 
email 		Email address of the recipient. 
firstname 	first name of the recipient 
gender 		Gender of the recipient: 0 = male, 1 = female, 2 = unknown 
lastname 	last name of the recipient 
mailtype 	Mail type of the recipient: 0 = plain text, 1 = HTML, 2 = inline HTML 
title 		Academic title of the recipient 
creation_date 	Date of the entry.
change_date 	Date of the last change.
datasource_id 	Source for this Entry. Is only written on insert. References datasource_description_tbl

Table description: 

Contains all master data of a recipient. The assignment to a mailing list happens in the Customer_1_binding_tbl.
 


customer_1_tbl_seq
Column name: 	Description:
customer_id 	Unique Id for the receipients

Table descrition:

Table is used for generating an unique id for receipients in customer_1_tbl.



customer_field_tbl 
Column name: 	Description: 
admin_id 	References admin_tbl. 
col_name 	Name of the column in customer_1_tbl. 
company_id 	References company_tbl. 
default_value 	Value for the given column, if no other value is supplied. 
description 	Description of the column. 
mode_edit 	Set to 1 if the column is editable. 
mode_insert 	Set to 1 if the column is insertable. 
shortname 	A descriptive name for the column. This name is for display in the frontend. 

Table description: 

This table holds information about the user-created columns in customer_1_tbl. The combination of company_id and col_name is the unique identification of the described column.
 


customer_import_errors_tbl 
Column name: 	Description: 
count 		The number of errors that occured during import for this type of error. 
error_id 	The id of the error. There is one id for each type of error, that can occure. 
id 		References customer_import_status_tbl. 

Table description: 

A table that holds the information about the errors, that occured during an import. The errors are uniquely defined by id and error_id.
 



customer_import_status_tbl 
Column name: 	Description: 
admin_id 	References admin_tbl. 
charset 	The character set that was used during the import. 
company_id 	References company_tbl. 
datasource_id 	References datasource_description_tbl. 
delimiter 	The delimiter that was used during import. 
double_check 	The doublecheck value that was used during import. 
field_separator 	The separator that was used during import. 
id 		The id of the import status. 
ignore_null 	This saves the behaviour for null values that was used during import. 
inserted 	The number of records that were inserted. 
keycolumn 	The name of the column that was used as the key. 
mode 		The mode for the import (add, add/update, update, opt-out, bounced, delete) that was used during import. 
records_before 	The number of recipient records before the import. 
updated 	The number of records that were updated. 

Table description: 

This table holds information about the state of an import. There is one record for every import that has been started. The record will be updated until the import finished. After the import the record is kept for informational purposes.

 


datasource_description_tbl 
Column name: 	Description: 
datasource_id 	Consecutive number, sequence: DATASOURCE_DESCRIPTION_TBL_SEQ 
change_date 	Date of last change. 
description 	Description of the source (eg. file name or URL of the logout interface) 
company_id 	References company_tbl 
sourcegroup_id 	ID of the group (sourcegroup_tbl). 
creation_date 	Date of the entry.

Table description: 

Source of an address. By importing a address file via frontend a new datasource_id is generated and is entered in the corresponding customer_1_tbl for new recipient. The file name is registered in the datasource_description_tbl.
 



dyn_content_tbl 
Column name: 	Description: 
company_id 	References company_tbl 
dyn_content 	Content (text) of the content block 
dyn_content_id 	Consecutive number, sequence: DYN_CONTENT_TBL_SEQ 
dyn_name_id 	belonging text module name -> DYN_NAME_TBL  
dyn_order 	Order of the evaluation of the content within the text module 
target_id 	Target group of the content -> DYN_TARGET_TBL 

Table description: 

Contains different text varieties for the text modules.

 


dyn_name_tbl 
Column name: 	Description: 
company_id 	References company_tbl 
dyn_name 	Text module name, as it is found in the [agnDYN name="XXX"]-Tag 
dyn_name_id 	Consecutive number,sequence: dyn_name_tbl_seq 
mailing_id 	ID of the mailings (mailing_tbl). 

Table description: 

Contains all text module names, which were found. Content itsself is saved in dyn_content_tbl
 



dyn_target_tbl 
Column name: 	Description: 
company_id 	References company_tbl 
target_description 	Descriptive text of the target group. 
target_id 	Consecutive number, sequence: DYN_TARGET_TBL_SEQ 
target_representation 	serialized Java class with target group definition 
target_shortname 	Short name 
target_sql 	SQL clause, which is used for the interrogation of the target group in which the "where" statement is integrated. 

Table description: 

Contains all target group information
 



emm_layout_tbl 
Column name: 	Description: 
base_url 	URL of the tmage tablets. 
company_id 	References company_tbl 
footer_url 	relative URL to file footer.jsp 
header_url 	relative URL to file header.jsp 
highlight_color 	HTML colorcode 
layout_id 	Consecutive number, sequence: emm_layout_tbl_seq 
normal_color 	HTML colorcode 

Table description: 

Contains the URLs for userspecific OpenEMM layouts.
 



export_predef_tbl 
Column name: 	Description: 
charset 	Character set of the export 
column_names 	List of column names for export
company_id 	References company_tbl 
deleted 	flag if definition is active or deleted (1 = deleted) 
delimiter_char 	Separator of the CSV file 
description 	Description 
mailinglists 	Mailing lists to export 
mailinglist_id 	Reference to mailinglist_tbl. 
separator_char 	delimeter character for CSV file 
shortname 	Name of the template 
target_id 	ID of the target group (-> dyn_target_tbl) 
user_status 	Recipient's statistics to export 
user_type 	Type of recipients to export (W = World, A = Admin, T = Test)
id 		Uniqe id for the entrys

Table description: 

Contains templates for the export of recipients.
 



maildrop_status_tbl 
Column name: 	Description: 
blocksize 	The maximum number of recipients per generated data block. 
company_id 	References company_tbl 
genchange 	Everytime time the genstatus is changed the date of the last change will be saved here. 
gendate 	This is the time, where the generation of the mailing starts 
genstatus 	This is the description of the actual status of the generation of the mailing: 0 = the generation is planned for a later point in time, not yet exercised 1 = the generation can now be exercised, it will only start, if this field has that value 2 = Generation of mailing is in grogress 3 = Generation of mailing has been finished 
mailing_id 	ID of the mailing (mailing_tbl). 
senddate 	Sending time of the mailing. 
status_field 	Kind of mailing. A: Admin T: Test W: World 1x E: Event-Mailing, activated, 1x C: Event-Mailing, already sent out R: Rule based Mailing, 1x 
status_id 	Consecutive number, sequence: MAILDROP_STATUS_TBL_SEQ 
step 		Sets the timespan in minutes, that has to elapse between the sending of two blocks. 

Table description: 

Whenever a mailing is sent, a new entry will be generated for this table. This information is used by the backend to generate the mailing.
 



mailing_account_tbl 
Column name: 	Description: 
blocknr 	Number of the XML block, that let to this entry. 
company_id 	References company_tbl 
maildrop_id 	References maildrop_status-id from maildrop-status_tbl 
mailing_account_id 	consecutive number, sequence: MAILING_ACCOUNT_TBL_SEQ 
mailing_id 	ID of the mailing (mailing_tbl). 
mailtype 	Mail type of the entry (0 = plain text, 1 = HTML, 2 = inline HTML). 
no_of_bytes 	Size of all mails together in Byte. 
no_of_mailings 	Number of sent mails. 
status_field 	Type of the mailing (A = Admin-Mailing, T = Test-Mailing, W = World-Mailing). 
change_date 	Date of last change.

Table description: 

While sending a mailing, for every sent block an entry with the number, size and type of the block will be generated.
 


mailing_backend_log_tbl 
Column name: 	Description: 
creation_date 	Date of the entry. 
current_mails 	Current number of the latest generated mails. 
mailing_id 	ID of the mailing (mailing_tbl). 
change_date 	Date of last change
total_mails 	Number of all generated mails. 
status_id 	References maildrop_status_id from maildrop_status_tbl

Table description: 

During the generation of a mailing, in this table will be saved for how many mails the data has been written yet.
 



mailing_mt_tbl 
Column name: 	Description: 
mailing_id 	ID of the mailing (-> mailing_tbl) 
mediatype 	Media type 
param 		Configuration data for this media entry (e.g. sender of the mail) 

Table description: 

Here the possible mediatype (i.e. Email) of a mailing is saved with the necessary configurational parameter.
 



mailing_status_tbl 
Column name: 	Description: 
mailing_id 	ID of the mailing (mailing_tbl). 
status_text 	Status of the mailing (shown via the OpenEMM frontend during the sending of an mailing). 

Table description: 

Contains the status of a mailing (eg. successfully sent mails).
 



mailing_tbl 
Column name: 	Description: 
campaign_id 	Campaign, the mailing belongs to, or 0 for no campaign 
company_id 	References company_tbl 
creation_date 	Day, when the mailing was applied. 
deleted 	if != 0 the mailing gets deleted and will not be shown in the OpenEMM anymore 
description 	Description of the mailing for internal purposes. 
is_template 	Defines, if the mailing is a template, since templates are also saved in mailing tables. 
mailinglist_id 	ID of the mailing list, to which the mailing gets sent. 
mailing_id 	Consecutive ID, sequence out of mailing_tbl_seq 
mailing_type 	0= standard mailing, 1=rule based, 2=event based 
mailtemplate_id 	ID of the template or 0 
needs_target 	if 1, the mailing needs to be assigned to a target group 
shortname 	Name of the mailing for internal purposes 
target_expression 	List with the chosen target groups for the sending, separated with "|" resp. "&" 
change_date 	Date of last change.

Table description: 

Contains the main information on OpenEMM mailings.
 



mailinglist_tbl 
Column name: 	Description: 
mailinglist_id 	Consecutive number, sequence: MAILINGLIST_TBL_SEQ. 
company_id 	References company_tbl 
shortname 	Name of the mailing list 
description 	Description of the mailing list. 

Table description: 

Contains all information of a mailing list.
 



mailloop_tbl 
Column name: 	Description: 
ar_enable 	If not 0, the autoresponder is activated. 
ar_html 	Text of the autoresponder for the HTML part of the mail (optional) 
ar_sender 	The sender of an autoresponder mail 
ar_subject 	The subject of the autoresponder mail, if the field is empty, the original subject staring with a "Re: " is used 
ar_text 	The text of the autoresponder in the text part of the mail. 
change_date 	Date of last change 
company_id 	References company_tbl 
description 	Description of the mail loop (optional) 
forward 	Email address for the pipe of all unfiltered mails. 
forward_enable 	If not 0, the pipe of unfiltered mails is activated. 
rid 		Unique ID for this data, also used for the generation of mail addresses for the mail loop. 
shortname 	Short discription of the mail loop. 

Table description: 

Contains information on the mail loop. A mail loop is constructed usually like ext_@.
 



mailtrack_tbl 
Column name: 	Description: 
company_id 	References company_tbl 
customer_id 	ID of the recipient (-> customer_1_tbl) 
mailing_id 	ID of the mailing (-> mailing_tbl) 
mailtrack_id 	Consecutive number 
status_id 	90 = Softbounce, 100 = Hardbounce 
change_date 	Date of last change.

Table description: 

Contains the hard and soft bounces for every mailing.
 


onepixel_log_tbl
column name: 	Description:
company_id 	References company_tbl
mailing_id 	References mailing_tbl
customer_id 	References customer_1_tbl
open_count 	Increase every time the receipient open the mail
change_date 	Date of entry or last change.
ip_adr 		IP-Address of the Receipient

Table description:

Contains one row for every receipient that opened an mailing



rdir_action_tbl 
Column name: 	Description: 
action_id 	consecutive action ID out of RDIR_ACTION_TBL_SEQ 
action_type 	States for which parts actions may be used: 0 = only links, 1 = only forms, 2 = both 
company_id 	References company_tbl 
description 	Internal description 
operations 	serialized Java class with action code 
shortname 	Internal short name 

Table description: 

Contains activities that run closed loop marketing activities (changes of profile of a reciepient), event based mailings and forms.
 


rdir_log_tbl
Column name: 	Description:
company_id 	References company_tbl
customer_id 	Reference to customer_1_tbl
mailing_id 	Reference to mailing_tbl
ip_adr 		IP-Address of the Receipient
change_date 	Date of entry or last change.
url_id 		References rdir_url_tbl

Table description:

Contains one Row for every linkclick on an measured link.




rdir_url_tbl 
Column name: 	Description: 
url_id 		Consecutive number, sequence: rdir_url_tbl_seq. 
action_id 	Reference to rdir_action_tbl->action_id, exercised when the recipient clicks on a link 
company_id 	References company_tbl 
full_url 	Genuine URL 
mailing_id 	ID of the mailing. (mailing_tbl). 
relevance 	Relevance for the statistics (0 = counted, 1 = not counted for gross click rate 2 = not counted at all) 
shortname 	Short name of the link to be shown in the OpenEMM 
measure_type 	Defines for which mailtypes this link is measurable

Table description: 

Contains all links in a mailing that are measurable.
 



rulebased_sent_tbl 
Column name: 	Description: 
lastsent 	Point of time of the last sending of the mailing 
mailing_id 	The mailing ID of the rule based mailing 

Table description: 

This table stores the date when rule based mailing got sent out for the last time. This should prevent that by changing the time of the sending of a rule based mailing it gets sent more than once a day.
 



tag_tbl 
Column name: 	Description: 
company_id 	References company_tbl 
description 	Description of the tags. 
selectvalue 	This will be implemented into the SQL request and provides the value of this tag 
tagname 	The unique name of the day. 
tag_id 		Consecutive number, sequence: TAG_TBL_SEQ 
change_date 	Date of last change.
type 		do not temper with this content 

Table description: 

This table offers dynamic tags, that are used in the mailing by [tagName ..]
 



timestamp_tbl 
Column name: 	Description: 
cur 		Timestamp at the moment 
description 	purpose of the timestamp in use 
prev 		Previous timestamp (optional to be used by the application) 
temp 		Temporary timestamp (optional) 
timestamp_id 	Unique identification of the entry 

Table description: 

This table is used to save point of time for external scripts.
 


title_tbl 
Column name: 	Description: 
company_id 	do not change 
description 	A description of the addresses. 
gender 		The gender, to which this entry is attached 
title 		Salutation 
title_id 	Consecutive number, sequence: TITLE_TBL_SEQ 

Table description: 

Contains client specific salutation
 



title_gender_tbl 
Column name: 	Description: 
gender 		GenderID, 0 = male, 1 = female, 2 = unknown 
title 		User defined salutation 
title_id 	ID used in title tag 

Table description: 

Contains client specific salutation
 



userform_tbl 
Column name: 	Description: 
company_id 	References company_tbl 
description 	Description (internal for OpenEMM user) 
endaction_id 	Action-ID 
error_template 	Page that is processed in case of an error (startaction_id resulted in an error code). Content is always evaluated with velocity as a script language, before sent to a browser. 
formname 	Name of the form, for download of the form from outside. Should contain no special character, space, etc. 
form_id 	Form iD, for internal purpose only 
startaction_id 	Action ID (rdir_action_tbl), exercised during the start of the form processing 
success_template 	Page that is processed in case of success (startaction_id resulted in no error code) Content is always evaluated with velocity as a script language, before sent to a browser. 

Table description: 

Form system for subscription, unsubscription, change of subscription etc.
 



softbounce_email_tbl
Column name: 	Description:
mailtrack_id 	Consecutive unique number
customer_id 	Reference to customer_1_tbl
mailing_id 	Reference to mailing_tbl
company_id 	Reference to company_tbl
change_date 	Date of last change.
status_id 	Bouncetype 90 = Softbounce
bnccnt		Count of Softbounces

Table description:

List of all Softbounces. Then defined Level of bnccnt is reached, the receipient is marked as hardbounce in customer_1_binding_tbl



bounce_collect_tbl
Field name: 	Description:
mailtrack_id 	Consecutive unique number
customer_id 	Reference to customer_1_tbl 
mailing_id 	Reference to mailing_tbl.
company_id 	References company_tbl.
change_date 	Date of last change
status_id 	Type of bounce, at the moment 90 as softbounce only

Table description:

All appearing bounces get collected here, to get handed over to the current soft-bounce processing