The following is an outline and description of the database tables created during the installation of Herzum Approval app into your Jira instance.

Herzum Approval Entity Relationship Diagram

The diagram below provides a visual overview of the Herzum Approval tables and the relations between them.

Tables Overview

This section is the overview of all the tables created during the Herzum Approval installation. It is followed by information on each table relevant areas of Herzum Approval user interface.

Table Name & Description

Relevant areas of Herzum Approval user interfaces

Table: AO_D195E9_CONFIG

The Table holds the values chosen for the options available on different administration screens.

Columns

Column	Type	Description
ID	int(11) AI PK	The unique Config Identifier (Primary Key)
USER_AWT	varchar(255)	The user used to perform the automatic workflow transitioning
HIDE_MENU	tinyint(1)	Admissible values for this field are: '1' : *Permissions→ Approval Menu →* Custom Setting is checked '0' : *Permissions→ Approval Menu →* All is checked (Default)
CUSTOM_DEFINE_APPROVAL	tinyint(1)	Admissible values for this field are: '1' : Permissions→ Define custom approval rules for single issues → *Enable the Issue Approval button on* option is currently set to Only Selected Projects '0' : Permissions→ Define custom approval rules for single issues → *Enable the Issue Approval button on* option is currently set to All Projects(Default)
NOTIFICATION_RECIPIENT_CUSTOM	tinyint(1)	Admissible values for this field are: '1' : *Recipients→* Approval Reply option is currently set to Custom Settings '0' : *Recipients→* Approval Reply option is currently set to Assignee and approvers (Default)
USER_COND_RULE	varchar(255)	The user used to evaluate the JQL queries maintained on the Conditional Rules
LABEL_REQUEST_NOTIFY	longtext	The text replacing the 'Request Notify' label
TAB_HISTORY_ENABLED	tinyint(1)	Admissible values for this field are: '1' : Approval History Tab enabled '0' : Approval History Tab disabled (Default)
LABEL_REQUEST_APPROVALS	longtext	The text replacing the Request Approvals label
LOCK_ACTION_ENABLED	tinyint(1)	Admissible values for this field are: '1' : Lock reversing approval actions enabled '0' : Lock reversing approval actions disabled (Default)
USER_APPROVER_BULK	longtext	It maintains the SuperUsers enabled to bulk approve any approval request instead of any user.
LABEL_APPROVAL_NAME	longtext	The text replacing the Approval label into the Approvals Web panel on the issue view screen
LABEL_ACTION_APPROVAL	longtext	The text replacing the Action label into the Approvals Web panel on the issue view screen
LABEL_REQUEST_APPROVAL	longtext	The text replacing the Request Approval label into the Approvals Web panel on the issue view screen
LABEL_DETAIL	longtext	The text replacing the Detail label into the Approvals Web panel on the issue view screen
TAB_COMM_DISABLED	tinyint(1)	Admissible values for this field are: '1' : log any approval change status on the *Jira Comment* tab (Default) '0' : do not log the approval changes status on the *Jira Comment* tab
USER_NOTIFY_NAC	varchar(255)	The user used to add the comment notifying any approval request on the *Jira Comment* tab
HIDE_HACTION_AUNOTIFY	tinyint(1)	Admissible values for this field are: '1' : hide the Automatic Notification event from the Approval History '0' : show the Automatic Notification event on the Approval History(Default)
HIDE_HACTION_SING_NOTIFY	tinyint(1)	Admissible values for this field are: '1' : hide the Single Notification event from the Approval History '0' : show the Single Notification event on the Approval History(Default)
HIDE_HACTION_REPLY_NOTIFY	tinyint(1)	Admissible values for this field are: '1' : hide the Reply Notification event from the Approval History '0' : show the Reply Notification event on the Approval History(Default)
HIDE_HACTION_APPROVED	tinyint(1)	Admissible values for this field are: '1' : hide the Approved event from the Approval History '0' : show the Approved event on the Approval History(Default)
HIDE_HACTION_PENDING	tinyint(1)	Admissible values for this field are: '1' : hide the Pending event from the Approval History '0' : show the Pending event on the Approval History(Default)
HIDE_HACTION_REJECTED	tinyint(1)	Admissible values for this field are: '1' : hide the Rejected event from the Approval History '0' : show the Rejected event on the Approval History(Default)
EXPANED_APP_PANEL	tinyint(1)	Admissible values for this field are: '1' : hide the Automatic Notification event from the Approval History '0' : show the Automatic Notification event on the Approval History(Default)
HIDE_HACTION_APP_NOTIFY	tinyint(1)	Admissible values for this field are: '1' : hide the Massive Notification event from the Approval History '0' : show the Massive Notification event on the Approval History(Default)
HIDE_HACTION_AUTRANS	tinyint(1)	Admissible values for this field are: '1' : hide the Automatic transition event from the Approval History '0' : show the Automatic transition event on the Approval History(Default)
HIDE_HACTION_COMMENT	tinyint(1)	Admissible values for this field are: '1' : hide the Action Comment event from the Approval History '0' : show the Action Comment event on the Approval History(Default)
HIDE_PREQUEST_NOTIF	tinyint(1)	Admissible values for this field are: '1' : hide the Request Notification column from the Approvals Web panel on the issue view screen '0' : show the Request Notification column from the Approvals Web panel on the issue view screen (Default)
HIDE_PACTION	tinyint(1)	Admissible values for this field are: '1' : hide the Action column from the Approvals Web panel on the issue view screen '0' : show the Action column from the Approvals Web panel on the issue view screen (Default)
HIDE_PDETAIL	tinyint(1)	Admissible values for this field are: '1' : hide Detail column from the Approvals Web panel on the issue view screen '0' : show the Detail column from the Approvals Web panel on the issue view screen (Default)
HIDE_PAPP_NAME	tinyint(1)	Admissible values for this field are: '1' : hide Approval Name column from the Approvals Web panel on the issue view screen '0' : show the Approval Name column from the Approvals Web panel on the issue view screen (Default)
CUSTOM_REQUESTER_APPROVAL	tinyint(1)	Admissible values for this field are: '1' : *Permissions→ Approval Request → Enabled Approvals Request button on* option is currently set to to Only Selected Projects '0' : *Permissions→ Approval Request→ Enabled Approvals Request button on* option is currently set to to All (Default)
HIDE_HACTION_ABSTAINED	tinyint(1)	Admissible values for this field are: '1' : hide the Abstain events from the Approval History tab '0' : show the Abstain events from the Approval History tab(Default)
ABSTAIN_ACTION_ENABLED	tinyint(1)	Admissible values for this field are: '1' : show the Abstain action from the Approvals Web panel on the issue view screen '0' : hide the Abstain action from the Approvals Web panel on the issue view screen (Default)
LARGE_BUTTONS	varchar(255)	Admissible values for this field are: None All Only selected users
USER_LARGE_BUTTONS	varchar(255)	A list of users enabled to display large action buttons.
AWT_CMRA	tinyint(1)	Admissible values for this field are: '1' : Enable automatic workflow transition based on AWT/MRA/CMRA option is currently set to ON '0' : Enable automatic workflow transition based on AWT/MRA/CMRA option is currently set to OFF (Default)
RESPONSIVE_AWT	tinyint(1)	Admissible values for this field are: '1' : Responsive Automatic Transition is currently set to ON '0' : Forced Automatic Transition is currently set to ON (Default)
LABEL_HISTORY_APPROVER_C	longtext	The text replacing the default label Approver Comment showed on the Approval History tab
VIEW_WORKFLOW	tinyint(1)	Admissible values for this field are: '1' : View Approval Flow is currently set to Enabled '0' : View Approval Flow is currently set to Disabled (Default)
CUSTOM_COMMENT	varchar(255)	The text replacing the default Comment logged on the Jira Comment Tab when an approval switch to the approved, rejected, abstained or pending status
ENABLED_NAC	tinyint(1)	Admissible values for this field are: '1' : Notify Approval via comment(NAC) is currently set to Enabled '0' : Notify Approval via comment(NAC) is currently set to Disabled (Default)
LABEL_APP_COMMENT	longtext	The text replacing the default label Approval Comment showed into the Approval Web Panel on the issue view screen
LABEL_HISTORY_ACTION	longtext	The text replacing the default label *Action* showed on the Approval History tab
LABEL_HISTORY_APPROVAL	longtext	The text replacing the default label Approval Comment showed on the Approval History tab
LABEL_HISTORY_DESTINATION_S	longtext	The text replacing the default label Approval showed on the Approval History tab
LABEL_HISTORY_SOURCE_S	longtext	The text replacing the default label Source Status showed on the Approval History tab
LABEL_HISTORY_TRANS	longtext	The text replacing the default label Transition showed on the Approval History tab
HISTORY_GROUP_BY	longtext	Identify the field used to reorder data showed on the Approval History tab Admissible values for this field are: Action Source Status Transition Destination Status Source Status & Execution Date None (Default)
HIDE_HISTORY_ACTION	tinyint(1)	Maintain the Approval History - Show/Hide Columns - Action setting managed via the Global Configuration administration screen. Admissible values for this field are: '1' : Hide data '0' : Show data (Default)
HIDE_HISTORY_APPROVAL	tinyint(1)	Maintain the Approval History - Show/Hide Columns - Approval setting managed via the Global Configuration administration screen. Admissible values for this field are: '1' : Hide data '0' : Show data (Default)
HIDE_HISTORY_APPROVER_C	tinyint(1)	Maintain the Approval History - Show/Hide Columns - Approver Comment setting managed via the Global Configuration administration screen. Admissible values for this field are: '1' : Hide data '0' : Show data (Default)
HIDE_HISTORY_DESTINATION_S	tinyint(1)	Maintain the Approval History - Show/Hide Columns - Destination Status setting managed via the Global Configuration administration screen. Admissible values for this field are: '1' : Hide data '0' : Show data (Default)
HIDE_HISTORY_SOURCE_S	tinyint(1)	Maintain the Approval History - Show/Hide Columns - Source Status setting managed via the Global Configuration administration screen. Admissible values for this field are: '1' : Hide data '0' : Show data (Default)
HIDE_HISTORY_TRANS	tinyint(1)	Maintain the Approval History - Show/Hide Columns - Transition setting managed via the Global Configuration administration screen. Admissible values for this field are: '1' : Hide data '0' : Show data (Default)
HIDE_PACOMMENT	tinyint(1)	Maintain the Other customizations - Show/Hide Columns - Approval Comment setting managed via the Global Configuration administration screen. Admissible values for this field are: '1' : Hide data '0' : Show data (Default)
HISTORY_COLUMN_TITLES	varchar(255)	This option allows to customize where column titles display in Approval History tab. Admissible values for this field are: 'Repeat the column titles for each line' : Repeat column titles for each record in the Approval History tab (Default) 'Display column titles on the top' : Display column titles only once on the top of Approval History tab
HISTORY_EXPAND_ROWS	tinyint(1)	This option allows to expand or collapse data detail when loading the Approval History tab. Admissible values for this field are: 'Expand' : Expand data detail in Approval History tab (Default) 'Collapse' : Collapse data detail in Approval History tab
HISTORY_FILTER	varchar(255)	This option allows to filter the rows displayed in the *Approval History* tab. Admissible values for this field are: 'None' : Display all the Approval History records (Default) 'Make visible only the final decision of approval for Approval/User/Transition' : Filter the Approval History records displaying only the final decision of approval for Approval/User/Transition
LABEL_ABSTAIN_BUTTON	varchar(255)	This option allows to customize the text on the Abstain button on the Approval Request email.
LABEL_APPROVAL_BUTTON	varchar(255)	This option allows to customize the text on the Approve button on the Approval Request email.
LABEL_RESET_BUTTON	varchar(255)	This option allows to customize the text on the Reset button on the Approval Request email.
LABEL_REJECT_BUTTON	varchar(255)	This option allows to customize the text on the Reject button on the Approval Request email.
FROM_EMAIL	varchar(255)	The alternative email address used to notify the Approval Request via email (Optional).
APPROVAL_TAG	varchar(255)	An optional string (mag length 5 characters) specifying the tag used on approval reply processed by the email handler. Default is '@'.
APP_COND_WF_UPDATABLE	tinyint(1)	Admissible values for this field are: 0, the option to allow this app to add and delete the Approval Conditions on the Workflow is NO 1, the option to allow this app to add and delete the Approval Conditions on the Workflow is YES (Default)
AUTO_GRANT_PERM	tinyint(1)	Admissible values for this field are: 0, the option to allow this app to grant browsing permissions, on all Jira Projects, to the USER_COND_RULE user is Off 1, the option to allow this app to grant browsing permissions, on all Jira Projects, to the USER_COND_RULE user is On (Default)
APP_PANEL_FILTER	varchar(255)	Admissible values for this field are: Only My Approvals, when the web panel loads the Only My Approvals filtering option is checked All, when the web panel loads the Only My Approvals filtering option is unchecked (Default).

Indexes and Foreign Key

PRIMARY KEY (`ID`)

Herzum Approval > Global Configuration

Herzum Approval > Conditional Rule Administration > Main Settings

Herzum Approval > Approval Mapping Administration > Global Settings > Automatic Workflow Transition( AWT)

Herzum Approval > Approval Mapping Administration > Global Settings > Notify Approvals via Comment (AWT)

Herzum Approval > Permissions

Herzum Approval > Recipients

Herzum Approval > E-Mail Templates

Table: AO_D195E9_CONFIG_PROPERTIES

The Table holds the values chosen for the options available on the Global Configuration screen.

Columns

Column	Type	Description
ID	int(11) AI PK	The unique Config properties Identifier (Primary Key)
DESCRIPTION	longtext	The property description. Admissible values for this field are: Approval expression superuser Warning case of missing Mandatory Approval Comment Dispatch Issue Commented event Show only for awt history column Approval Reject Action Enabled Approval Hide Percentage Approval Sleep Time Automatic Request Notification Approval Actions Authentication
PROPERTY	varchar(255)	Admissible values for this field are: APP_EXPR_SU MAIL_MISS_COM DISPATCH_COMMENT SHOW_FOR_AWT REJECT_ACTION_ENABLED HIDE_PERCENTAGE SLEEP_TIME_ARN ACTIONS_AUTHENTICATION REV_ACT_USERS ACTIONS_BAR ACTIONS_AUTHENTICATION_SPEC
VALUE	longtext	Case of property APP_EXPR_SU, admissible values for this field are: Null; No user has been selected to populate user-picker custom fields Username of the chosen super-user that will be used by the app to populate any user-picker custom field associated to an Approval Expression Case of property MAIL_MISS_COM, admissible values for this field are: Null; No custom text text displayed on the new approval email sent case of wrong approval response. Case of property DISPATCH_COMMENT, admissible values for this field are: Null; the 'Issue Commented' event won't be dispatched following an automatic Add Comment action Text identifying when the 'Issue Commented' event will be dispatched following an automatic Add Comment action perfomed by the app ARL, Approval Response logged via Jira Comment ARSL, Approval Responses Summary logged via Jira Comment on linked Issues ARSC, Approval Responses Summary logged via Jira Comment on current Issue Case of property SHOW_FOR_AWT , admissible value for this field is a Sequence of digit (0,1) indicating if the History Fields (Source Status, Transition, Destination Status) will display only when the logged event is an Automatic Transition Case of property REJECT_ACTION_ENABLED admissible values for this field are: false (default), the approver can reject true, the approver has not the capability to reject Case of property HIDE_PERCENTAGE admissible values for this field are: false (default), the Approvals Web Panel shows the percentage bar true, the Approvals Web Panel doesn't show the percentage bar Case of property SLEEP_TIME_ARN admissible values for this field are: 4000 (default), the sleep time in delayed job autoRequestApprovalNotification is 4000 ms (4 sec) any value equal or greater then 4000ms and less or equal then 99999999 Case of property ACTIONS_AUTHENTICATION admissible values for this field are: false (default), when an user click the action buttons, no authentication is required true, when an user click the action buttons, a screen requiring to authenticate appears. Case of property REV_ACT_USERS admissible values for this field are: Null; No user is enabled to reverse the approval action list of usernames separated by coma Case of property ACTIONS_BAR admissible values for this field are: false (default), the capability to respond to an Approval Request on the command-bar of the issue view is disabled true, the capability to respond to an Approval Request on the command-bar of the issue view is enabled Case of property ACTIONS_AUTHENTICATION_SPEC admissible values for this field are: password(default), in order to provide an approval response, the user must insert the password username/password, in order to provide an approval response, the user must insert the username and the password

Indexes and Foreign Key

PRIMARY KEY (`ID`)

KEY `index_ao_d195e9_con103901570` (`PROPERTY`)

Herzum Approval > Global Configuration

Herzum Approval > E-Mail template administration

Table: AO_D195E9_APPROVAL_PROJECTS

The Table holds the projects selected in the Herzum Approval > Permissions panel.

Columns

Column	Type	Description
ID	int(11) AI PK	The Unique Approval Projects Identifier (Primary Key)
PROJECT_ID	bigint(20)	The Unique Project Identifier
REQUESTER_TYPE	tinyint(1)	Admissible values for this field are: '1' : the issues belonging to the selected project display the buttons allowing to send the emails notifying the approval requests '0' : the issues belonging to the selected project display display the Define Approval button

Indexes and Foreign Key

PRIMARY KEY (`ID`),
KEY `index_ao_d195e9_app1426102280` (`PROJECT_ID`)

Herzum Approval > Permissions > Approval Request > Selected Projects

Herzum Approval > Permissions > Define Custom Approval Rules for single issues > Selected Projects

Table: AO_D195E9_APPROVAL

The Table holds the Approvals information.

Columns

Column	Type	Description
ASSIGNEE_ENABLED	tinyint(1)	Admissible values for this field are: '1' : assignee approval is enabled '0' : assignee approval is disabled
CONFIG_ID	int(11)	The Unique Approval Identifier (Primary Key)
DESCRIPTION	varchar(255)	The Approval Description
GROUPS	varchar(255)	The selected Group for the approval
ID	int(11) AI PK	The Unique Approval Identifier (Primary Key)
NAME	varchar(255)	Approval name
PROJECT_LEAD_ENABLED	tinyint(1)	Admissible values for this field are: '1' : project lead approval is enabled '0' : project lead approval is disabled
REPORTER_ENABLED	tinyint(1)	Admissible values for this field are: '1' : reporter approval is enabled '0' : reporter approval is disabled
ROLES	varchar(255)	The selected Project Role for the approval
USERS	varchar(255)	The selected User for the approval
USER_PICKER	varchar(255)	The selected user picker custom field for the approval where the approval expects the approbation of all selected users.
USER_PICKER_ANY	varchar(255)	The selected user picker custom field for the approval where each user selected on the chosen user picker custom field can approve
GROUP_PICKER	varchar(255)	The selected group picker custom field for the approval
OPERATOR	varchar(255)	Admissible values for this field are: 'AND' : the approval must validate all the approval properties 'OR' : the approval must validate at least one of the approval properties
NOT_ASSIGNEE	tinyint(1)	Admissible values for this field are: '1' : NOT is checked for Assignee '0' : NOT is unchecked for Assignee
NOT_GROUP_PICKER	tinyint(1)	Admissible values for this field are: '1' : NOT is checked for Group Picker custom field '0' : NOT is unchecked for Group Picker custom field
NOT_GROUPS	tinyint(1)	Admissible values for this field are: '1' : NOT is checked for Groups '0' : NOT is unchecked for Groups
NOT_USER_PICKER	tinyint(1)	Admissible values for this field are: '1' : NOT is checked for User Picker custom field '0' : NOT is unchecked for User Picker custom field
NOT_LEAD	tinyint(1)	Admissible values for this field are: '1' : NOT is checked for Project Lead '0' : NOT is unchecked for Project Lead
NOT_REPORTER	tinyint(1)	Admissible values for this field are: '1' : NOT is checked for Reporter '0' : NOT is unchecked for Reporter
NOT_USERS	tinyint(1)	Admissible values for this field are: '1' : NOT is checked for Users '0' : NOT is unchecked for Users
NOT_ROLES	tinyint(1)	Admissible values for this field are: '1' : NOT is checked for Project Roles '0' : NOT is unchecked for Project Roles
NOT_USER_PICKER_ANY	tinyint(1)	Admissible values for this field are: '1' : NOT is checked for User Picker custom field ANY '0' : NOT is unchecked for User Picker custom field ANY
CONDITIONAL_RULE_ID	int(11)	The Unique Identifier of the Conditional Rule
SHOW_TYPE	int(11)	Admissible values for this field are: '1' : Approval History displays Approval name '2 : Approval History displays Approval Detail '0' : Approval History displays Approval name and Approval Detail (Default)
SA	tinyint(1)	Admissible values for this field are: '1' : the approval can be approved independently by any sequential order '0' : if an Approval Mapping requires the Sequential Approval, the approval must be approved in sequential order
USER_PICKER_ALL_EXPR	longtext	Expressions that identify users that will be filled on the user picker custom field associated with the property User Picker Field All in order to enable them to approve and users that will be removed by the user picker in order to exclude them.
USER_PICKER_ANY_EXPR	longtext	Expressions that identify users that will be filled on the user picker custom field associated with the property User Picker Field Any in order to enable them to approve and users that will be removed by the user picker in order to exclude them.

Indexes and Foreign Key

PRIMARY KEY (`ID`),
KEY `index_ao_d195e9_app1404561190` (`CONFIG_ID`),
KEY `index_ao_d195e9_app951185319` (`CONDITIONAL_RULE_ID`),
KEY `index_ao_d195e9_approval_name` (`NAME`),
CONSTRAINT `fk_ao_d195e9_approval_conditional_rule_id` FOREIGN KEY (`CONDITIONAL_RULE_ID`) REFERENCES `AO_D195E9_CONDITIONAL_RULE` (`ID`),
CONSTRAINT `fk_ao_d195e9_approval_config_id` FOREIGN KEY (`CONFIG_ID`) REFERENCES `AO_D195E9_CONFIG` (`ID`)

Herzum Approval > Approval Administration

Table: AO_D195E9_ISSUE_APPROVAL

The Table holds the active approvals on each issues and the Approval Configurations for single issues.

Columns

Column	Type	Description
APPROVAL_ID	int(11)	The Approval identifier
APPROVAL_STATUS	varchar(255)	Admissible values for this field are: 'APPROVED' 'PENDING' 'REJECTED' Null
APPROVER_USER	varchar(255)	The Last user changing approval status
AREA_COND_RULE_ID	int(11)	The unique Conditional Rule identifier associated to the Approval request Email Automation Service
DATE	varchar(255)	Date of the last approval status update
HAS_CONFIG_FOR_SINGLE_ISSUE	varchar(255)	Admissible values for this field are: 'TRUE' : The approval has been configured for the specific issue null
ID	int(11) AI PK	The Unique Identifier of the Issue Approval(Primary Key).
ISSUE_ID	bigint(20)	The issue identifier
ISSUE_STATUS	varchar(255)	The issue status identifier (Case of single issue approval, maintain the id of the status of the issue at the moment it is saved)
NOTIFICATION_DATE	varchar(255)	Admissible values for this field are: data-time the approval request has been sent Not Sent, if the approval request has not been sent yet Null, if the approval request was created before of this field was managed (versions earlier than 2.8).
SOURCE_STATUS_ID	varchar(255)	The configured source issue status identifier
TRANSITION_ID	varchar(255)	The approval transition identifier
TRANSITION_NAME	varchar(255)	The transition name configured with the Approval
TYPE	varchar(255)	Admissible values for this field are: 'SINGLE ISSUE' 'WORKFLOW
AWT	tinyint(1)	Admissible values for this field are: 1 (to allow the automatic workflow transitioning) 0
AWTAD	tinyint(1)	Admissible values for this field are: 1 (to allow collecting all approval responses befor to run the automatic workflow transition on approbation/rejection based on minimum required approbations/rejections when applicable 0 (Default)
ARN	tinyint(1)	Admissible values for this field are: 1 (to allow the automatic email notification) 0
CUSTOM_APPROVER	varchar(255)	User or group selected on the picker custom field
DEFINE_CUSTOM_APPROVER	tinyint(1)	Admissible values for this field are: 1 (the issue has been configured to have as approval a custom field) 0
ERROR_TRANSIT	tinyint(1)	Admissible values for this field are: 1 (the issue has not been automatically transitioned due to conditions and validators haven't been validated) 0
"ERROR_TRANSIT_TYPE"	integer	Admissible values for this field are: 1 (the issue has not been automatically transitioned due to conditions and validators haven't been validated on the workflow transition on approbation) 0 (default)
MRA	double	Admissible values for this field are: -1 -> MRA is set to All 0 -> MRA -> is set to None decimal -> MRA is set to percentage integer -> MRA is set to fixed number MRA=Minimum Required approbations unconditioned
MRR	double	Admissible values for this field are: -1 -> MRR is set to All 0 -> MRR -> is set to None decimal -> MRR is set to percentage integer -> MRR is set to fixed number MRR=Minimum Required rejections unconditioned
CONDITIONAL_RULE_ID	int(11)	The Unique Identifier of the Conditional Rule
COMMENT_NOTIFICATION_DATE	varchar(255)	Admissible values for this field are: data-time the approval request has been notified via comment Null, if the approval request was created before of this field was managed (versions earlier than 2.11).
RAC	tinyint(1)	Admissible values for this field are: 1, the Approval Comment is required 0, the Approval Comment is not required(Default)
SUBMITTED_DATE	varchar(255)	Data-time the approval starts to appear on the issue view screen
TRANSITION_ON_REJECTING	varchar 255	The reject transition identifier
SORT_SA	int(11)	An integer identifying the approval sequence
SA	tinyint(1)	Admissible values for this field are: 1, the Sequential Approval is enabled 0, the Sequential Approval is disabled (Default)
SAAD	tinyint(1)	Admissible values for this field are: 1, case of the Sequential Approval is enabled, the subsequent approval is unlocked for approval independently by the type of reply 0, , case of the Sequential Approval is enabled, the subsequent approval is unlocked for approval only if the previous approval gets an approbation(Default)
MAIL_TEMPLATE_REPLY_ID	int(11)	The Unique Identifier of the Approval Reply email template
MAIL_TEMPLATE_REQUEST_ID	int(11)	The Unique Identifier of the Approval Request email template
DA_SERVICE_NAME	varchar(255)	The associated Approval Action Automation service
DA_ELAPSED_TIME	bigint(20)	The time interval between the approval submit date and the time for the automated action to succeed
DA_DECISION	varchar(255)	The selected Automatic decision. Admissible values for this field are: Null if any Approval Action Automation service has been selected Approve Reject Abstain.
DA_USER_KEY	varchar(255)	The User used by the app to perform the approval action on behalf of the effective approver.
AREA_ELAPSED_TIME	bigint(20)	The time interval between the approval notification date and the time for the automated new notification to succeed
AREA_SERVICE_NAME	varchar(255)	The associated Approval Email Notification Automation service
AREA_ELAPSED_TIME	bigint(20)	The time interval between the approval notification date and the time for the automated new notification to succeed
AREA_COND_RULE_ID	int(11)	The Conditional Rule identifier associated to the Approval request Email Automation Service
ABSTAIN_ACTION_STATUS	bigint(20)	Admissible values for this field are: 2, the Abstain setting is turned OFF 1, the Abstain setting is turned ON 0, the considered Abstain setting is the Global Abstain setting (Default)
NTF_SCHEME_ID	int(11)	The notification Scheme identifier
AREA_DATE_PICKER	varchar(255)	The selected data field (Due Date or Data picker custom field) associated to the Approval Email Notification Automation configuration
SUPER_APPROVERS_EXPR	text (unlimited length)	The Expression identifying the users enabled to provide the approval response on behalf of the effective approvers for the approvals requested on the specific Issue
IS_OPTIONAL_APPROVAL	tinyint(1) NOT NULL DEFAULT '0',	The Boolean identifying if the Approval is optional or mandatory. Admissible values for this field are: 1, the Approval is Mandatory 0, the Approval is Optional (Default)

Indexes and Foreign Key

PRIMARY KEY (`ID`),
KEY `index_ao_d195e9_iss997056032` (`MAIL_TEMPLATE_REQUEST_ID`),
KEY `index_ao_d195e9_iss1660920037` (`MAIL_TEMPLATE_REPLY_ID`),
KEY `index_ao_d195e9_iss1027844871` (`ISSUE_ID`),
FOREIGN KEY (`MAIL_TEMPLATE_REPLY_ID`) REFERENCES `AO_D195E9_CUSTOM_MAIL_TEMPLATE` (`ID`),
FOREIGN KEY (`MAIL_TEMPLATE_REQUEST_ID`) REFERENCES `AO_D195E9_CUSTOM_MAIL_TEMPLATE` (`ID`)
FOREIGN KEY (`NTF_SCHEME_ID`) REFERENCES `AO_D195E9_NTF_SCHEME` (`ID`),

Jira issue View screen > Issue Approval

Table: AO_D195E9_APPROVAL_MAPPING_REL

The Table holds the association between Approvals and Approvals Mappings.

Columns

Column	Type	Description
APPROVAL_ID	int(11)	The Approval identifier
APPROVAL_MAPPING_ID	int(11)	The Approval Mapping identifier
ID	int(11) AI PK	The unique Approval_mapping_rel identifier
SORT_SA	int(11)	An integer identifying the approval sequence
IS_OPTIONAL_APPROVAL	tinyint(1) NOT NULL DEFAULT '0',	The Boolean identifying if the Approval is optional or mandatory. Admissible values for this field are: 1, the Approval is Mandatory 0, the Approval is Optional (Default)

Indexes and Foreign Key

PRIMARY KEY (`ID`),
KEY `index_ao_d195e9_app356536994` (`APPROVAL_ID`),
KEY `index_ao_d195e9_app115487565` (`APPROVAL_MAPPING_ID`),
CONSTRAINT `fk_ao_d195e9_approval_mapping_rel_approval_id` FOREIGN KEY (`APPROVAL_ID`) REFERENCES `AO_D195E9_APPROVAL` (`ID`),
CONSTRAINT `fk_ao_d195e9_approval_mapping_rel_approval_mapping_id` FOREIGN KEY (`APPROVAL_MAPPING_ID`) REFERENCES `AO_D195E9_APPROVAL_MAPPING` (`ID`)

Herzum Approval > Approval Mapping Administration

Table: AO_D195E9_APPROVAL_MAPPING

The Table holds Approval Mappings information.

Columns

Column	Type	Description
CONFIG_ID	int(11)
DESTINATION_STATUS_ID	varchar(255)	The destination status identifier
ID	int(11) AI PK	The unique Approval Mapping identifier
ISSUE_TYPE_ID	varchar(255)	The issue type identifier
PROJECT_ID	bigint(20)	The project identifier
SOURCE_STATUS_ID	varchar(255)	The source status identifier
TRANSITION_ID	varchar(255)	The approval transition identifier
TRANSITION_ON_REJECTING	varchar(255)	The transition on reject identifier
AWT	tinyint(1)	Admissible values for this field are: 1 (to allow the automatic workflow transitioning on approving) 0
AWTR	tinyint(1)	Admissible values for this field are: 1 (to allow the automatic workflow transitioning on rejecting) 0
AWTAD	tinyint(1)	Admissible values for this field are: 1 (to allow collecting all approval responses befor to run the automatic workflow transition on approbation/rejection based on minimum required approbations/rejections when applicable 0 (Default)
ARN	tinyint(1)	Admissible values for this field are: 1 (to allow the automatic email notification) 0
MRA	double	Admissible values for this field are: -1 -> MRA is set to All 0 -> MRA -> is set to None decimal -> MRA is set to percentage integer -> MRA is set to fixed number MRA=Minimum Required approbations unconditioned
MRR	double	Admissible values for this field are: -1 -> MRR is set to All 0 -> MRR -> is set to None decimal -> MRR is set to percentage integer -> MRR is set to fixed number MRR=Minimum Required rejections unconditioned
CONDITIONAL_RULE_ID	int(11)	The Unique Identifier of the Conditional Rule
IS_LOCKED	tinyint(1)	Admissible values for this field are: 1 (the app is still restoring consistence of approvals) 0
IS_DRAFT	tinyint(1)	Admissible values for this field are: 1 (the mapping has not be saved jet) 0
IS_DELETE	tinyint(1)	Admissible values for this field are: 1 (the required approvals have been removed and the mapping has not be saved jet) 0
LOCKED_DATE	varchar(255)	Data/Hours the mapping has been locked
IS_NOT_SINGLE	tinyint(1)	Admissible values for this field are: 1 (the mapping has not be saved jet and the Approval Mapping Configuration screen is still open) 0
NAC	tinyint(1)	Admissible values for this field are: -1 -> NAC is set to Enabled 0 -> MRA -> is set to Disable
RAC	tinyint(1)	Admissible values for this field are: 1, the Approval Comment is required 0 , the Approval Comment is not required(Default)
RACA	varchar(255)	Indicates if the approval comment is required on Approbation, on Rejection, on Abstention,on Reset via the following convention: it is an ordered sequence of 4 digits (one for each type of possible approval action). Each digit can assume the value 0 (if the Approval Comment is not required) or 1 (if the Approval Comment is required). The first digit maintains the setting applied for Approval comment on Approbation. The second digit maintains the setting applied for Approval comment on Rejection. The third digit maintains the setting applied for Approval comment on Abstention. The fourth digit maintains the setting applied for Approval comment on Reset. The field assumes the value Null in the following cases: The approval comment is required either way, if Rac=1 The approval comment is not required, if Rac=0
SA	tinyint(1)	Admissible values for this field are: 1, the Sequential Approval is enabled 0, the Sequential Approval is disabled (Default)
SAAD	tinyint(1)	Admissible values for this field are: 1, case of the Sequential Approval is enabled, the subsequent approval is unlocked for approval independently by the type of reply 0, , case of the Sequential Approval is enabled, the subsequent approval is unlocked for approval only if the previous approval gets an approbation(Default)
MAIL_TEMPLATE_REPLY_ID	int(11)	The Unique Identifier of the Approval Reply email template
MAIL_TEMPLATE_REQUEST_ID	int(11)	The Unique Identifier of the Approval Request email template
DA_SERVICE_NAME	varchar(255)	The associated Approval Action Automation service
DA_ELAPSED_TIME	bigint(20)	The time interval between the approval submit date and the time for the automated action to succeed
DA_DECISION	varchar(255)	The selected Automatic decision. Admissible values for this field are: Null if any Approval Action Automation service has been selected Approve Reject Abstain.
DA_USER_KEY	varchar(255)	The User used by the app to perform the approval action on behalf of the effective approver.
ABSTAIN_ACTION_STATUS	bigint(20)	Admissible values for this field are: 2, the Abstain setting is turned OFF 1, the Abstain setting is turned ON 0, the considered Abstain setting is the Global Abstain setting (Default)
AREA_DATE_PICKER	varchar(255)	The selected data field (Due Date or Data picker custom field) associated to the Approval Email Notification Automation configuration.
AREA_COND_RULE_ID	int(11)	The Conditional Rule identifier associated to the Approval request Email Automation Service
NTF_SCHEME_ID	int(11)	The Notification Scheme identifier
SUPER_APPROVERS_EXPR	text (unlimited)	The Expression identifying the users enabled to provide the approval response on behalf of the effective approvers for the approvals requested on the specific Mapping

Indexes and Foreign Key

KEY `index_ao_d195e9_app310593943` (`MAIL_TEMPLATE_REQUEST_ID`),
KEY `index_ao_d195e9_app129321564` (`MAIL_TEMPLATE_REPLY_ID`),
KEY `index_ao_d195e9_app527712425` (`CONFIG_ID`),
KEY `index_ao_d195e9_app672374960` (`PROJECT_ID`),
FOREIGN KEY (`CONFIG_ID`) REFERENCES `AO_D195E9_CONFIG` (`ID`),
FOREIGN KEY (`MAIL_TEMPLATE_REPLY_ID`) REFERENCES `AO_D195E9_CUSTOM_MAIL_TEMPLATE` (`ID`),FOREIGN KEY (`MAIL_TEMPLATE_REQUEST_ID`) REFERENCES `AO_D195E9_CUSTOM_MAIL_TEMPLATE` (`ID`)

FOREIGN KEY (`NTF_SCHEME_ID`) REFERENCES `AO_D195E9_NTF_SCHEME` (`ID`),

Herzum Approval > Approval Mapping Administration

Table: AO_D195E9_APPROVAL_DEFINERS

The Table holds the permission to set-up the Approval Configuration for Single Issues.

Columns

Column	Type	Description
DEFINER	varchar(255)	Approval Definer value
ID	int(11) AI PK	The unique approval definers identifier
ISSUE_TYPE_ID	varchar(255)	The issue type identifier
PROJECT_ID	bigint(20)	The project identifier
TYPE	varchar(255)	Admissible values for this field are: Users Groups Roles Reporter Assignee Project Lead

Indexes and Foreign Key

PRIMARY KEY (`ID`),
KEY `index_ao_d195e9_app226303494` (`PROJECT_ID`)

Herzum Approval > Permissions > Define Custom Approval Rules for single issues > Add Permissions

Table: AO_D195E9_APPROVAL_RECIPIENTS

The Table holds the Recipients set-up with respect to the Approval Reply notified via email.

Columns

Column	Type	Description
ID	int(11) AI PK	The unique approval recipients identifier
RECIPIENT	varchar(255)	Admissible values for this field are: when type=NEVER NEVER when type=APPROVER Complete Approval Rejected when type=PROJECTLEAD PROJECTLEAD when type=ASSIGNEE ASSIGNEE when type=REPORTER REPORTER when type=GROUP one Jira Group when type=ROLE one Jira Project Role when type=USER one Jira Username when Type=REPLY_USER_PICKER customfield_<Custom field Id>
TYPE	varchar(255)	Admissible values for this field are: NEVER APPROVER PROJECTLEAD ASSIGNEE REPORTER GROUP ROLE USER REPLY_USER_PICKER
EVENTS	varchar(255)	Admissible values for this field are: NEVER (Only case of Type= Never) DefaultEvent Complete Approval Rejected

Indexes and Foreign Key

PRIMARY KEY (`ID`)

Herzum Approval > Recipients > Approval Reply

Table: AO_D195E9_NTF_SCHEME_DETAIL

The Table holds the expressions identifying the users to notify and the template to apply by event for each custom email reply notification scheme.

Columns

Column	Type	Description
ID	int(11) AI PK	The unique SCHEME_DETAIL identifier
NTF_SCHEME_ID	int(11)	The email reply notification scheme identifier
EVENT_TYPE_ID	int(11)	The Event identifier. Admissible values for this field are: 1, case of Every Approbation 2, case of Every Rejection 3, case of Every Abstantion 4, case of Full Approbation 5, case of Automatic Workflow transition on Approbation 6, case of Automatic Workflow transition on Rejection
NOTIFY_EXPRESSION	longtext	the Expression identifying the users to notify
CUSTOM_MAIL_TEMPLATE_ID	int(11)	The email template identifier

Indexes and Foreign Key

PRIMARY KEY (`ID`)

FOREIGN KEY (`NTF_SCHEME_ID`) REFERENCES `AO_D195E9_CONFIG` (`AO_D195E9_NTF_SCHEME`),

Herzum Approval > Recipients > Approval Reply

Table: AO_D195E9_NTF_SCHEME

The Table holds custom email reply notification schemes registry.

Columns

Column	Type	Description
ID	int(11) AI PK	The unique email reply notification scheme identifier
NAME	varchar(255)	The email reply notification scheme name
DESCRIPTION	varchar(255)	The email reply notification scheme description

Indexes and Foreign Key

PRIMARY KEY (`ID`)

Herzum Approval > Recipients > Approval Reply

Table: AO_D195E9_CUSTOM_MAIL_TEMPLATE

The Table holds custom email templates header information.

Columns

Column	Type	Description
CUSTOM_TEMPLATE_NAME	varchar(255)	The name of the template
ID	int(11) AI PK	The unique template identifier
PROJECT_ID	bigint(20)	The project identifier. It is Null for the customized Default Template, when configured and for the Email template reused across different Mappings and Issue Approval Definitions.
CONDITIONAL_RULE_ID	int(11)	The Unique Identifier of the Conditional Rule that, when it returns true, set the email priority to High
CONDITION_ENABLING_TEMPLATE_ID	int(11)	The Unique Identifier of the Conditional Rule that enables the Email template,
HIDE_CREATED	tinyint(1)	Admissible values for this field are: 1 (the issue creation date is hidden) 0 (the issue creation date is shown)
HIDE_ISSUE_TYPE	tinyint(1)	Admissible values for this field are: 1 (the issue type is hidden) 0 (the issue type is shown)
HIDE_PRIORITY	tinyint(1)	Admissible values for this field are: 1 (the issue priority is hidden) 0 (the issue priority is shown)
CUSTOM_APPROVAL_INSTRUCT	longtext	Admissible values for this field are: Null (Default Instructions) Text (Customized Instructions)
HIDE_APPROVAL_INSTRUCT	tinyint(1)	Admissible values for this field are: 1 (the Approval instructions are hidden) 0 (the Approval instructions are shown)
HIDE_ASSIGNEE	tinyint(1)	Admissible values for this field are: 1 (the issue assignee is hide) 0 (the issue assignee date is shown)
HIDE_WORKFLOW_TRANS	tinyint(1)	Admissible values for this field are: 1 (the issue workflow transition is hidden) 0 (the issue workflow transition is shown)
HIDE_PROJECT	tinyint(1)	Admissible values for this field are: 1 (the issue project is hidden) 0 (the issue project is shown)
HIDE_REPORTER	tinyint(1)	Admissible values for this field are: 1 (the issue reporter is hidden) 0 (the issue reporter is shown)
HIDE_DESCRIPTION	tinyint(1)	Admissible values for this field are: 1 (the issue description is hidden) 0 (the issue description is shown)
IS_EMAIL_TEMPLATE_DEFAULT	tinyint(1)	Admissible values for this field are: 1 (the template is the customized default template ) 0 (the template is a Project's template or a Mapping template)
IS_EMAIL_TEMPLATE_REPLY	tinyint(1)	Admissible values for this field are: 1 (Approval Reply template ) 0 (Approval Request template)
FOOTER	longtext	The text to show on the email footer
HEADER	longtext	The text to show on the email header
ICON_ID	int(11)	The unique identifier of the image to appear on the left of the email header.
SUBJECT	longtext	The email subject
HIDE_LOGO	tinyint(1)	Admissible values for this field are: 1 (the email doesn't show any image) 0 (the email shows the selected image on the left of the email header )
HIDE_APPROVAL_COMMENT	tinyint(1)	Admissible values for this field are: 1 (the approval comment shows up on the email advising an approval change status) 0 (the approval comment doesn't show up on the email advising an approval change status), Default
HIDE_COMMENT	tinyint(1)	Admissible values for this field are: 1 (the issue comments show up on the email notifying an approval request) 0 (the issue comments don't show up on the email notifying an approval request), Default
HIDE_APPROVAL_BUTTON	tinyint(1)	Admissible values for this field are: 1 ("Approve", "Reject", "Abstain" and "Reset" buttons let users respond to approval request directly from the email) 0 (Approval buttons don't appear in the email), Default
TYPE	int(11)	Admissible values for this field are: 1 ("Approve", "Reject", "Abstain" and "Reset" buttons let users respond to approval request directly from the email) 0 (Approval buttons don't appear in the email), Default
BODY_SECTION	longtext	An optional text appended displayed in the email body.
COMMENT_ENABLED	tinyint(1)	Admissible values for this field are: 1 (on clicking the "Approve", "Reject", "Abstain" and "Reset" buttons, the screen allowing to insert an approval comment shows up), Default 0 (on clicking the "Approve", "Reject", "Abstain" and "Reset" buttons, the screen allowing to insert an approval comment doesn't appear)
IS_BOTTOM_BODY_SECTION	tinyint(1)	Admissible values for this field are: 1 (the BODY_SECTION text displays on the bottom), Default 0 (the BODY_SECTION text displays on the top)
IS_BOTTOM_BUTTON	tinyint(1)	Admissible values for this field are: 1 (the Approval Buttons text display on the bottom), Default 0 (the Approval Buttons text display on the top)
REQUIRE_AUTH	tinyint(1)	Admissible values for this field are: 1 (the option to require approver authentication is turned On) 0 (Default)
REQUIRE_AUTH_SPEC	tinyint(1)	Admissible values for this field are: 1 (username/password authentication) 0 (password authentication Default)
BUTTON_TEXTS	varchar(255)	Admissible values for this field are: Null (Default) A string reporting any applied text setting, if any. E.g {"approveBtnTxt":"Approve button Text", "Reject button Text": "2","Abstain button Text":"3", "resetBtnTxt":"Reset button Text"}
SHOW_LINKED_ISSUES	tinyint(1)	Admissible values for this field are: 1 (the option to display linked issues is turned On) 0 (Default)
SHOW_SUBTASKS	tinyint(1)	Admissible values for this field are: 1 (the option to display SUBTASKS is turned On) 0 (Default)
SUBTASKS_FIELDS	longtext	A text listing the fields to display into the approval email. E.g. {"fields":["customfield_10107","versions"]}

Indexes and Foreign Key

PRIMARY KEY (`ID`),
KEY `index_ao_d195e9_cus1061972428` (`ICON_ID`),

KEY `index_ao_d195e9_cus1997617038` (`PROJECT_ID`),

CONSTRAINT `fk_ao_d195e9_custom_mail_template_icon_id` FOREIGN KEY (`ICON_ID`) REFERENCES `AO_D195E9_ICON` (`ID`)

Herzum Approval > E-Mail Templates

Table: AO_D195E9_FIELDS_TEMPLATE

The Table holds custom email templates rows information.

Columns

Column	Type	Description
CUSTOM_MAIL_TEMPLATE_ID	int(11)	The Template identifier
FIELD_ID	varchar(255)	The field identifier
ID	int(11) AI PK	The unique fields_template identifier
SEQUENCE	int(11)	The order that will be followed to list the fields on the email
SHOW_EMPTY	tinyint(1)	Admissible values for this field are: 1 (the option to display Empty values is turned On) 0 (Default)

Indexes and Foreign Key

PRIMARY KEY (`ID`),
KEY `index_ao_d195e9_fie859585961` (`CUSTOM_MAIL_TEMPLATE_ID`),
CONSTRAINT `fk_ao_d195e9_fields_template_custom_mail_template_id` FOREIGN KEY (`CUSTOM_MAIL_TEMPLATE_ID`) REFERENCES `AO_D195E9_CUSTOM_MAIL_TEMPLATE` (`ID`)

Herzum Approval > E-Mail Templates

Table: AO_D195E9_CONDITIONAL_RULE

The Table holds Conditional Rules information

Columns

Column	Type	Description
CONDITIONAL_NAME	varchar(255)	The Conditional Rule name
CONDITIONAL_RULE	longtext	The Conditional Rule expression
ID	int(11) AI PK	The Unique Identifier of the Conditional Rule
USER_EVALUATOR	varchar(255)	The user considered in order to evaluate the condition

Indexes and Foreign Key

PRIMARY KEY (`ID`)

Herzum Approval > Conditional Rules

Table: AO_D195E9_APPROVAL_HISTORY

The Table holds the history of approval events including approval notification, approval status changes and automatic issue transitioning.

Columns

Column	Type	Description
ACTION	varchar(255)	Admissible values for this field are: Approved Pending Rejected Automatic transitioning Automatic notification Single notification Approvals Notification Abstained
APPROVAL_NAME	varchar(255)	Approval denomination
DATE	varchar(255)	Action's Data/Hours
DESTINATION_STATUS	varchar(255)	The workflow destination status
EXECUTOR	varchar(255)	The user having performed the action (if applicable)
EXECUTOR_KEY	varchar(255)	The userkey of the user having performed the action (if applicable)
ID	int(11) AI PK	The Unique Identifier of the Approval History
ISSUE_ID	bigint(20)	The issue Identifier
SOURCE_STATUS	varchar(255)	The workflow source status
TRANSITION_NAME	varchar(255)	The workflow transition
APPROVAL_DETAIL	longtext	A text detailing the Approval configuration
APPROVAL COMMENT	longtext (Mysql) Clob (Oracle)	The Approver comment on approving/rejecting an approval request (starting from v.3.9) COMMENT in version 3.8 backward.
SUBMITTED_DATE	varchar(255)	Data-time the approval was submitted
DELEGATOR_KEY	varchar(255)	The userkey od the delegated user that performed the approval action

Indexes and Foreign Key

PRIMARY KEY (`ID`),
KEY `index_ao_d195e9_app195568214` (`ISSUE_ID`)

Table: AO_D195E9_APPROVAL_REQUESTERS

The Table holds the permission to notify an approval request.

Columns

Column	Type	Description
REQUESTER	varchar(255)	Approval Requester value
ID	int(11) AI PK	The unique approval definers identifier
ISSUE_TYPE_ID	varchar(255)	The issue type identifier
PROJECT_ID	bigint(20)	The project identifier
TYPE	varchar(255)	Admissible values for this field are: Users Groups Roles Reporter Assignee Project Lead

Indexes and Foreign Key

PRIMARY KEY (`ID`),
KEY `index_ao_d195e9_app171366549` (`PROJECT_ID`)

Herzum Approval > Permissions > Approval Request > Add Permissions

Table: AO_D195E9_APPROVAL_MRA

The Table holds the Minimum Required Approvals based on conditions information.

Columns

Column	Type	Description
APPROVAL_MAPPING_ID	int(11)	The Approval Mapping identifier
CONDITIONAL_RULE_ID	int(11)	The Conditional Rule identifier
ID	int(11) AI PK	The unique approval definers identifier
ISSUE_ID	bigint(20)	The issue identifier
MRA	double	The minimum required replies
ORDER	int(11)	The order of evaluation
SOURCE_STATUS_ID	varchar(255)	The workflow source status identifier
TRANSITION_ID	varchar(255)	The workflow transition identifier
TYPE	varchar(255)	Admissible values for this field are: CMRA (Minimum Required approbations based on conditions) CMRR (Minimum Required rejections based on conditions)

Indexes and Foreign Key

PRIMARY KEY (`ID`),
KEY `index_ao_d195e9_app1150741095` (`APPROVAL_MAPPING_ID`),
KEY `index_ao_d195e9_app845186334` (`ISSUE_ID`),
CONSTRAINT `fk_ao_d195e9_approval_mra_approval_mapping_id` FOREIGN KEY (`APPROVAL_MAPPING_ID`) REFERENCES `AO_D195E9_APPROVAL_MAPPING` (`ID`)

Herzum Approval > Approval Mapping Administration

Table: AO_D195E9_AUTO_TRANSITION

The Table holds information allowing

to force issue refreshing when the app automatically transition an issue
to avoid loops caused by a recursive automatic transition setup.

Columns

Column	Type	Description
DESTINATION_STATUS_ID bigint(20)	bigint(20)	The workflow destination status identifier
EXECUTION_TIME	bigint(20)	Execution time expressed in milliseconds
ID int(11) AI PK	int(11) AI PK	The unique record identifier
ISSUE_ID	bigint(20)	The issue identifier
FORCE_REFRESH	tinyint(1)	The Boolean discriminating if the refresh task must be performed. Admissible Values: 1 The refresh task must be performed 0 The Refresh task must not be performed
TRANSITION_EVENT_DISPATCHED	tinyint(1)	The Boolean discriminating automatic transition tasks. Admissible Values: 1 Tuple created to avoid a possible loop 0 Tuple created to allow refreshing when the app automatically transition an issue

Indexes and Foreign Key

PRIMARY KEY (`ID`),
KEY `index_ao_d195e9_aut671748473` (`ISSUE_ID`)

Table: AO_D195E9_ICON

The Table holds the images to appear on the Approval Request and Approval Replay emails.

Columns

Column	Type	Description
ICON_ENCODED	longtext	Base64 encode Image
ID	int(11) AI PK	The unique icon identifier
IMG_FORMAT	varchar(255)	Admissible values for this field are: Nul for image type Default gif, png, jpeg, jpg, bmp, wbmp for image type Upload
NAME	varchar(255)	The file name (e.g. Logo.png)
TYPE	varchar(255)	Admissible values for this field are: Default for images uploaded by default on installing the app Upload for images uploaded via the Approval E-Mail Templates Administration > Upload Icon user interface

Indexes and Foreign Key

PRIMARY KEY (`ID`)

Herzum Approval > E-Mail Templates

Table: AO_D195E9_APPROVAL_NOT_NOTIFY

The Table holds the users to exclude when the automatic and the massive Approval Request email notification run.

Columns

Column

Type

Description

int(11) AI PK

The unique icon identifier

RECIPIENT

varchar(255)

The selected recipients of the email notification or

the unique identifier of the selected User Picker.

TYPE

varchar(255)

Admissible values for this field are:

Users
Groups
Roles
Reporter
Assignee
Project Lead
USER_PICKER

Indexes and Foreign Key

PRIMARY KEY (`ID`)

Herzum Approval > Recipients > Approval Request

Table: AO_D195E9_APPROVAL_MENU_PERM

The Table holds the users allowed to view the Approval button on the application header bar.

Columns

Column

Type

Description

int(11) AI PK

The unique icon identifier

ITEM

varchar(255)

The selected users or groups

TYPE

varchar(255)

Admissible values for this field are:

Users
Groups

Indexes and Foreign Key

PRIMARY KEY (`ID`)

Herzum Approval > Permissions >Approval Menu

Table: AO_D195E9_APPROVAL_DELEGATED

The Table holds the information regarding the delegation of approval authority.

Columns

Column	Type	Description
DELEGATED_KEY	varchar(255)	The delegated user key
DELEGATOR_KEY	varchar(255)	The delegator user key
END_DATE	varchar(255)	The delegation end date
ID	int(11) AI PK	The unique delegation identifier
ISSUE_TYPE_ID	varchar(255)	The issue type identifier
PROJECT_ID	bigint(20)	The project identifier
START_DATE	varchar(255)	The delegation start date

Indexes and Foreign Key

PRIMARY KEY (`ID`),
KEY `index_ao_d195e9_app1258048991` (`PROJECT_ID`)

Jira menu bar >Approval item > Manage delegated approvers

Table: AO_D195E9_APPROVAL_SEQUENCE

The Table holds the information regarding the sequential order of the approvals for the users selected in an user picker custom field _All

Columns

Column	Type	Description
ID	int(11) AI PK	The unique approval sequence identifier
APPROVAL_ID	int(11)	The approval identifier
SEQUENCE	int(11)	The approval sequence
USER_KEY	varchar(255)	The user identifier

Indexes and Foreign Key

PRIMARY KEY (`ID`),
KEY `index_ao_d195e9_app1006437833` (`APPROVAL_ID`),
CONSTRAINT `fk_ao_d195e9_approval_sequence_approval_id` FOREIGN KEY (`APPROVAL_ID`) REFERENCES `AO_D195E9_APPROVAL` (`ID`)

Herzum Approval > Approval Administration >Sequential Approvals

In this section

Feel free to reach out to us with any questions!

We'd love to hear it.