Page History

Info

icon	false

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.

In this section

Info

icon	false

Table of Contents

Feel free to reach out to us with any questions!

We'd love to hear it.

Button Hyperlink

title	Submit your question
type	primary
url	https://chicago.herzum.com/jira/plugins/servlet/desk/portal/44
target	true

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 and User interfaces to manage themIndexes

Description, Indexes and Foreign Key	User interfaces	Table Fields

Table Name:

AO_D195E9_CONFIG

Description:

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

User interfaces:

CONSTRAINT "AO_D195E9_CONFIG_pkey" 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

PRIMARY KEY (`ID`)true@trueAlltruetrue{"} & [Approval Name] & {"} & [Can Approve Detail]& {: } & [Action]&{ by }&[Approver]&{ on }&[Date]falsefalsetruetruetruefalsefalsefalsefalsefalsefalsefalsefalsefalsefalsefalsefalsefalsefalsefalsefalsefalsefalsefalsefalsefalsefalseRepeattrueNoneThe unique Config Identifier (Primary Key)NonefalsefalsetruefalsetrueSanitized by Herzum UtilitySanitized by Herzum UtilitySanitized by Herzum Utilitytrue

Expand

title	Columns

ABSTAIN_ACTION_ENABLED bitAPPROVAL_TAG nvarchar 255APP_COND_WF_UPDATABLE bitAPP_PANEL_FILTER nvarchar 255AUTO_GRANT_PERM bitAWT_CMRA bitCUSTOM_COMMENT nvarchar 255CUSTOM_DEFINE_APPROVAL bitCUSTOM_REQUESTER_APPROVAL bitDELEGATION_ENABLED bitENABLED_NAC bitEXPANED_APP_PANEL bitFROM_EMAIL nvarchar 255HIDE_HACTION_ABSTAINED bitHIDE_HACTION_APPROVED bitHIDE_HACTION_APP_NOTIFY bitHIDE_HACTION_AUNOTIFY bitHIDE_HACTION_AUTRANS bitHIDE_HACTION_COMMENT bitHIDE_HACTION_PENDING bitHIDE_HACTION_REJECTED bitHIDE_HACTION_REPLY_NOTIFY bitHIDE_HACTION_SING_NOTIFY bitHIDE_HISTORY_ACTION bitHIDE_HISTORY_APPROVAL bitHIDE_HISTORY_APPROVER_C bitHIDE_HISTORY_DESTINATION_S bitHIDE_HISTORY_SOURCE_S bitHIDE_HISTORY_TRANS bitHIDE_MENU bitHIDE_PACOMMENT bitHIDE_PACTION bitHIDE_PAPP_NAME bitHIDE_PDETAIL bitHIDE_PREQUEST_NOTIF bitHISTORY_COLUMN_TITLES nvarchar 255HISTORY_EXPAND_ROWS bitHISTORY_FILTER nvarchar 255HISTORY_GROUP_BY nvarchar -1ID intLABEL_ABSTAIN_BUTTON nvarchar 255LABEL_ACTION_APPROVAL nvarchar -1LABEL_APPROVAL_BUTTON nvarchar 255LABEL_APPROVAL_NAME nvarchar -1LABEL_APP_COMMENT nvarchar -1LABEL_DETAIL nvarchar -1LABEL_HISTORY_ACTION nvarchar -1LABEL_HISTORY_APPROVAL nvarchar -1LABEL_HISTORY_APPROVER_C nvarchar -1LABEL_HISTORY_DESTINATION_S nvarchar -1LABEL_HISTORY_SOURCE_S nvarchar -1LABEL_HISTORY_TRANS nvarchar -1LABEL_REJECT_BUTTON nvarchar 255LABEL_REQUEST_APPROVAL nvarchar -1LABEL_REQUEST_APPROVALS nvarchar -1LABEL_REQUEST_NOTIFY nvarchar -1LABEL_RESET_BUTTON nvarchar 255LARGE_BUTTONS nvarchar 255LOCK_ACTION_ENABLED bitNOTIFICATION_RECIPIENT_CUSTOM bitRESPONSIVE_AWT bitTAB_COMM_DISABLED bitTAB_HISTORY_ENABLED bitUSER_APPROVER_BULK nvarchar -1USER_AWT nvarchar 255USER_COND_RULE nvarchar 255USER_LARGE_BUTTONS nvarchar 255USER_NOTIFY_NAC nvarchar 255VIEW_WORKFLOW bit

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* optionis currently set to Only Selected Projects '0' : Permissions→ Define custom approval rules for single issues → Enable the Issue Approval button on** optionis 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 Approvedevent 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 Pendingevent 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* optionis 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 onthe 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).

Table:

AO_D195E9_CONFIG_PROPERTIES

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

PRIMARY KEY (`ID`)

KEY `index_ao_d195e9_con103901570` (`PROPERTY`)

Herzum Approval > Global Configuration

Herzum Approval > E-Mail template administration

Expand

title	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

Expand

title	Indexes and Foreign Key

AO_D195E9_APPROVAL_PROJECTS

The Table holds the projects selected in the Herzum Approval > Permissionspanel.

PRIMARY KEY (`ID`),
KEY `index_ao_d195e9_

con103901570`

app1426102280` (

`PROPERTY`

`PROJECT_ID`)

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 > Permissionspanel.

Permissions > Approval Request > Selected Projects

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

Expand

title	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

Expand

title	Indexes and Foreign Key

Table: AO_D195E9_APPROVAL

The Table holds the Approvals information.

PRIMARY KEY (`ID`),
KEY `index_ao_d195e9_

app1426102280`

app1404561190` (

`PROJECT

`CONFIG_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.

titleIndexes and Foreign Key

,
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

Expand

title	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.

Expand

Table: AO_D195E9_ISSUE_APPROVAL

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

PRIMARY KEY (`ID`),
KEY `index_ao_d195e9_

app1404561190`

iss997056032` (

`CONFIG

`MAIL_TEMPLATE_REQUEST_ID`),
KEY `index_ao_d195e9_

app951185319`

iss1660920037` (

`CONDITIONAL

`MAIL_

RULE

TEMPLATE_REPLY_ID`),
KEY `index_ao_d195e9_

approval_name` (`NAME`

iss1027844871` (`ISSUE_ID`),

CONSTRAINT `fk_ao_d195e9_approval_conditional_rule_id` FOREIGN KEY (`CONDITIONAL_RULE_

FOREIGN KEY (`MAIL_TEMPLATE_REPLY_ID`) REFERENCES `AO_D195E9_CUSTOM_MAIL_TEMPLATE` (`ID`),
FOREIGN KEY (`MAIL_TEMPLATE_REQUEST_ID`) REFERENCES `AO_D195E9_

CONDITIONAL

CUSTOM_

RULE`

MAIL_TEMPLATE` (`ID`)

,

CONSTRAINT `fk_ao_d195e9_approval_config_id`

FOREIGN KEY (

`CONFIG

`NTF_SCHEME_ID`) REFERENCES `AO_D195E9_

CONFIG`

NTF_SCHEME` (`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.

,

Jira issue View screen > Issue Approval

Expand

title	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
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_IDint(11)The notification Scheme identifier

NAC	tinyint(1)	Admissible values for this field are: 1, the Approval request notification by comment is enabled 0, the Approval request notification by comment is disabled (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
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)

expand

RACA

titleIndexes and Foreign Key

nvarchar 255
REPLY_NOTIFICATION_SCHEMA_ID	int(11)	The reply notification Scheme identifier
SHOW_APPROVAL_STATUS_JSD	tinyint(1)	Admissible values for this field are: 1, the Approval Status shows on Customer Portal is enabled 0, the Approval Status shows on Customer Portal:is disabled (Default)
SHOW_APPROVAL_BUTTONS_JSD	tinyint(1)	Admissible values for this field are: 1, the Approval Buttons shows on Customer Portal is enabled 0, the Approval Buttons shows on Customer Portal is disabled (Default)

Table: AO_D195E9_APPROVAL_MAPPING_REL

The Table holds the association between Approvals and Approvals Mappings.

PRIMARY KEY (`ID`),
KEY `index_ao_d195e9_

iss997056032`

app356536994` (

`MAIL

`APPROVAL_

TEMPLATE_REQUEST_

ID`),
KEY `index_ao_d195e9_

iss1660920037`

app115487565` (

`MAIL

`APPROVAL_

TEMPLATE

MAPPING_

REPLY_

ID`),

KEY `index

CONSTRAINT `fk_ao_d195e9_

iss1027844871` (`ISSUE_ID`),

approval_mapping_rel_approval_id` FOREIGN KEY (

`MAIL

`APPROVAL_

TEMPLATE_REPLY_

ID`) REFERENCES `AO_D195E9_

CUSTOM_MAIL_TEMPLATE`

APPROVAL` (`ID`),

FOREIGN KEY (`MAIL_TEMPLATE_REQUEST_ID`) REFERENCES `AO_D195E9_CUSTOM_MAIL_TEMPLATE` (`ID`)
FOREIGN KEY (`NTF_SCHEME

CONSTRAINT `fk_ao_d195e9_approval_mapping_rel_approval_mapping_id` FOREIGN KEY (`APPROVAL_MAPPING_ID`) REFERENCES `AO_D195E9_

NTF

APPROVAL_

SCHEME`

MAPPING` (`ID`)

,Jira issue View screen > Issue Approval

Table: AO_D195E9_APPROVAL_MAPPING_REL

The Table holds the association between Approvals and Approvals Mappings.

Herzum Approval > Approval Mapping Administration

Herzum Approval > Approval Mapping Administration

Expand

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

Expand

title	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`)

Table: AO_D195E9_APPROVAL_MAPPING

The Table holds Approval Mappings information.

Expand

title	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

Expand

title	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.

Expand

title	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

Expand

title	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.

Expand

title	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

Expand

title	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.

Expand

title	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

Expand

title	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.

Expand

title	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

Expand

title	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.

Expand

title	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"]}

Expand

title	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.

Expand

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

Expand

title	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

Expand

title	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

Expand

title	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.

Expand

title	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

Expand

title	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.

Expand

title	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

Expand

title	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 theMinimum Required Approvals based on conditions information.

Expand

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

Expand

title	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.

Expand

title	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

Expand

title	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.

Expand

title	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

Expand

title	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.

Expand

title	Columns

Column

Type

Description

ID

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

Expand

title	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.

Expand

title	Columns

Column

Type

Description

ID

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

Expand

title	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.

Expand

title	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

Expand

title	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

Expand

title	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

Expand

title	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

Table: AO_D195E9_LANGUAGE_PACK

The Table holds the language packs master data.

Expand

title	Columns

Field		DESCRIPTION
ID	int(18)	The unique language translation Identifier (Primary Key)
"LOCALE"	varchar(255)	Admissible values for this field are: Null, the language translation is not associated to any Locale Any locale available on the Jira instance <language-code><COUNTRY-CODE> e.g. `fr_CH`
NAME	varchar(255)	Language Pack name
DESCRIPTION	varchar(255)	Language Pack description
MODIFIED_DATE	timestamp	Last modified Data and Hours
MODIFIED_USER	varchar(255)	Last user modifying translations
ENABLED	tinyint(1)	Admissible values for this field are: '1' : the language translations is enabled '0' : the language translations is not enabled

Expand

title	Indexes and Foreign Key

PRIMARY KEY (`ID`)

Table: AO_D195E9_LANG_PACK_KEY_VAL

The Table holds the properties translations per Language Pack.

Expand

title	Columns

Field		DESCRIPTION
ID	int(18)	The unique LANGUAGE_PACK_PROPERTIES_VALUES Identifier (Primary Key)
LANGUAGE_PACK_ID	int(18)	Language Pack Identifier
PROPERTY_KEY	int(18)	The property key
VALUE	varchar(max)	The property key value for the specified Language Pack

Expand

title	Indexes and Foreign Key

PRIMARY KEY (`ID`)

CONSTRAINT "AO_D195E9_LANG_PACK_KEY_VAL_pkey" PRIMARY KEY ("ID"),
CONSTRAINT fk_ao_d195e9_lang_pack_key_val_language_pack_id FOREIGN KEY ("LANGUAGE_PACK_ID") REFERENCES "AO_D195E9_LANGUAGE_PACK"("ID")

Herzum Approval > Language Packs Administration

Page tree

Versions Compared

Old Version 4

New Version 5

Key

Herzum Approval Entity Relationship Diagram

Tables Overview