Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Info
iconfalse

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 & DescriptionRelevant areas of Herzum Approval user interfaces

Table: AO_D195E9_CONFIG

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

Expand
titleColumns
ColumnTypeDescription 
IDint(11) AI PKThe unique Config Identifier (Primary Key)
USER_AWTvarchar(255)The user used to perform the automatic workflow transitioning
HIDE_MENUtinyint(1)

Admissible values for this field are:

  • '1' : Permissions→ Approval Menu → Custom Setting is checked
  • '0' : PermissionsApproval Menu All is checked (Default)
CUSTOM_DEFINE_APPROVALtinyint(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_CUSTOMtinyint(1)

Admissible values for this field are:

  • '1' : RecipientsApproval Reply option is currently set to Custom Settings

  • '0' : RecipientsApproval Reply option is currently set to Assignee and approvers (Default)
USER_COND_RULEvarchar(255)The user used to evaluate the JQL queries maintained on the Conditional Rules
LABEL_REQUEST_NOTIFYlongtextThe text replacing the 'Request Notify' label
TAB_HISTORY_ENABLEDtinyint(1)

Admissible values for this field are:

  • '1' : Approval History Tab enabled
  • '0' : Approval History Tab disabled (Default)
LABEL_REQUEST_APPROVALSlongtextThe text replacing the Request Approvals label
LOCK_ACTION_ENABLEDtinyint(1)

Admissible values for this field are:

  • '1' : Lock reversing approval actions enabled
  • '0' : Lock reversing approval actions disabled (Default)
USER_APPROVER_BULKlongtextIt maintains the SuperUsers enabled to bulk approve any approval request instead of any user.
LABEL_APPROVAL_NAMElongtextThe text replacing the Approval label into the Approvals Web panel on the issue view screen
LABEL_ACTION_APPROVALlongtextThe text replacing the Action label into the Approvals Web panel on the issue view screen
LABEL_REQUEST_APPROVALlongtextThe text replacing the Request Approval label into the Approvals Web panel on the issue view screen
LABEL_DETAILlongtextThe text replacing the Detail label into the Approvals Web panel on the issue view screen
TAB_COMM_DISABLEDtinyint(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_NACvarchar(255)The user used to add the comment notifying any approval request on the Jira Comment tab
HIDE_HACTION_AUNOTIFYtinyint(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_NOTIFYtinyint(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_NOTIFYtinyint(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_APPROVEDtinyint(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_PENDINGtinyint(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_REJECTEDtinyint(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_PANELtinyint(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_NOTIFYtinyint(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_AUTRANStinyint(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_COMMENTtinyint(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_NOTIFtinyint(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_PACTIONtinyint(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_PDETAILtinyint(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_NAMEtinyint(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_APPROVALtinyint(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_AWTtinyint(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_ClongtextThe text replacing the default label Approver Comment showed on the Approval History tab
VIEW_WORKFLOWtinyint(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_COMMENTvarchar(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_NACtinyint(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_COMMENTlongtextThe text replacing the default label Approval Comment showed into the Approval Web Panel onthe issue view screen
LABEL_HISTORY_ACTIONlongtextThe text replacing the default label Action showed on the Approval History tab
LABEL_HISTORY_APPROVALlongtextThe text replacing the default label Approval Comment showed on the Approval History tab
LABEL_HISTORY_DESTINATION_SlongtextThe text replacing the default label Approval showed on the Approval History tab
LABEL_HISTORY_SOURCE_SlongtextThe text replacing the default label Source Status showed on the Approval History tab
LABEL_HISTORY_TRANSlongtextThe text replacing the default label Transition showed on the Approval History tab
 HISTORY_GROUP_BYlongtext

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_ACTIONtinyint(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_APPROVALtinyint(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_Ctinyint(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_Stinyint(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_Stinyint(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_TRANStinyint(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_PACOMMENTtinyint(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_TITLESvarchar(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_FILTERvarchar(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_BUTTONvarchar(255) This option allows to customize the text on the Abstain button on the Approval Request email.
LABEL_APPROVAL_BUTTONvarchar(255) This option allows to customize the text on the Approve button on the Approval Request email.
LABEL_RESET_BUTTONvarchar(255) This option allows to customize the text on the Reset button on the Approval Request email.
LABEL_REJECT_BUTTONvarchar(255) This option allows to customize the text on the Reject button on the Approval Request email.
FROM_EMAILvarchar(255)The alternative email address used to notify the Approval Request via email (Optional).
APPROVAL_TAGvarchar(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_PERMtinyint(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_FILTERvarchar(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).
Expand
titleIndexes 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.

Expand
titleColumns
ColumnTypeDescription 
IDint(11) AI PKThe unique Config properties Identifier (Primary Key)
DESCRIPTIONlongtext

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
PROPERTYvarchar(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
VALUElongtext

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
Expand
titleIndexes and Foreign Key

PRIMARY KEY (`ID`)

KEY `index_ao_d195e9_con103901570` (`PROPERTY`)

Herzum Approval > Global Configuration

Herzum Approval > E-Mail
  • 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
titleIndexes 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 > Permissionspanel.

Expand
titleColumns
ColumnTypeDescription 
IDint(11) AI PK The Unique Approval Projects Identifier (Primary Key)
PROJECT_IDbigint(20) The Unique Project Identifier
REQUESTER_TYPEtinyint(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
titleIndexes 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.

Expand
titleColumns
ColumnTypeDescription 
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)
DESCRIPTIONvarchar(255)The Approval Description
GROUPSvarchar(255)The selected Group for the approval
IDint(11) AI PKThe Unique Approval Identifier (Primary Key)
NAMEvarchar(255)Approval name
PROJECT_LEAD_ENABLEDtinyint(1)    

Admissible values for this field are:

  • '1' : project lead approval is enabled
  • '0' : project lead approval is disabled
REPORTER_ENABLEDtinyint(1)

Admissible values for this field are:

  • '1' : reporter approval is enabled
  • '0' : reporter approval is disabled
ROLESvarchar(255)The selected Project Role for the approval
USERSvarchar(255)The selected User for the approval
USER_PICKERvarchar(255)

The selected user picker custom field for the approval where

the approval expects the approbation of all selected users.

USER_PICKER_ANYvarchar(255)

The selected user picker custom field for the approval where

each user selected on the chosen user picker custom field can approve

GROUP_PICKERvarchar(255) The selected group picker custom field for the approval
OPERATORvarchar(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_ASSIGNEEtinyint(1)

Admissible values for this field are:

  • '1' : NOT is checked for Assignee
  • '0' : NOT is unchecked for Assignee
NOT_GROUP_PICKERtinyint(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_GROUPStinyint(1)

Admissible values for this field are:

  • '1' : NOT is checked for Groups
  • '0' : NOT is unchecked for Groups
NOT_USER_PICKERtinyint(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_LEADtinyint(1)

Admissible values for this field are:

  • '1' : NOT is checked for Project Lead
  • '0' : NOT is unchecked for Project Lead
NOT_REPORTERtinyint(1)

Admissible values for this field are:

  • '1' : NOT is checked for Reporter
  • '0' : NOT is unchecked for Reporter
NOT_USERStinyint(1)

Admissible values for this field are:

  • '1' : NOT is checked for Users
  • '0' : NOT is unchecked for Users
NOT_ROLEStinyint(1)

Admissible values for this field are:

  • '1' : NOT is checked for Project Roles
  • '0' : NOT is unchecked for Project Roles
NOT_USER_PICKER_ANYtinyint(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)
SAtinyint(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_EXPRlongtextExpressions 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_EXPRlongtextExpressions 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
titleIndexes 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.

Expand
titleColumns
ColumnTypeDescription 
APPROVAL_ID int(11) 

The Approval identifier

APPROVAL_STATUSvarchar(255)

Admissible values for this field are:

  • 'APPROVED'
  • 'PENDING'
  • 'REJECTED'
  • Null
APPROVER_USERvarchar(255) The Last user changing approval status
AREA_COND_RULE_IDint(11) The unique Conditional Rule identifier  associated to the Approval request Email Automation Service 
DATEvarchar(255) Date of the last approval status update
HAS_CONFIG_FOR_SINGLE_ISSUEvarchar(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_STATUSvarchar(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_DATEvarchar(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_IDvarchar(255)The configured source issue status identifier
TRANSITION_IDvarchar(255)The approval transition identifier
TRANSITION_NAMEvarchar(255)The transition name configured with the Approval
TYPEvarchar(255)

Admissible values for this field are:

  • 'SINGLE ISSUE'
  • 'WORKFLOW
AWTtinyint(1)

Admissible values for this field are:

  • 1 (to allow the automatic workflow transitioning)
  • 0
AWTADtinyint(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)
ARNtinyint(1)

Admissible values for this field are:

  • 1 (to allow the automatic email notification)
  • 0
CUSTOM_APPROVERvarchar(255)User or group selected on the picker custom field
DEFINE_CUSTOM_APPROVERtinyint(1)

Admissible values for this field are:

  • 1 (the issue has been configured to have as approval a custom fielda custom field)
  • 0
ERROR_TRANSITtinyint(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_TRANSITtinyint(1)_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)
MRAdouble

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_IDint(11)The Unique Identifier of the Conditional Rule
COMMENT_NOTIFICATION_DATEvarchar(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_DATEvarchar(255)Data-time the approval starts to appear on the issue view screen
TRANSITION_ON_REJECTINGvarchar 255The reject transition identifier
SORT_SA  int(11)An integer identifying the approval sequence
SAtinyint(1)

Admissible values for this field are:

  • 1, the Sequential Approval is enabled
  • 0, the Sequential Approval is disabled (Default)
SAADtinyint(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_IDint(11) 

The Unique Identifier of the Approval Reply email template

MAIL_TEMPLATE_REQUEST_IDint(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_TIMEbigint(20)The time interval between the approval notification date and the time for the automated new notification to succeed
AREA_SERVICE_NAMEvarchar(255)The associated Approval Email Notification Automation service
AREA_ELAPSED_TIMEbigint(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
AREA_DATE_PICKERvarchar(255)The selected data field (Due Date or Data picker custom field) associated to the Approval Email Notification Automation configuration
SUPER_APPROVERS_EXPRtext(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
to the Approval Email Notification Automation configuration
SUPER_APPROVERS_EXPRtext (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
titleIndexes 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.

Expand
titleColumns
ColumnTypeDescription 
APPROVAL_IDint(11) 

The Approval identifier

APPROVAL_MAPPING_IDint(11)The Approval Mapping identifier
IDint(11) AI PKThe unique Approval_mapping_rel identifierint(11) AI PKThe unique Approval_mapping_rel identifier
SORT_SA int(11)An integer identifying the approval sequenceSORT_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
titleIndexes 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.

Expand
titleColumns
ColumnTypeDescription 
CONFIG_ID  int(11) 


DESTINATION_STATUS_IDvarchar(255)The destination status identifier
ID int(11) AI PKThe unique Approval Mapping identifier
ISSUE_TYPE_IDvarchar(255)The issue type identifier
PROJECT_ID bigint(20)The project identifier
SOURCE_STATUS_IDvarchar(255)The source status identifier
TRANSITION_IDvarchar(255)The approval transition identifier
TRANSITION_ON_REJECTINGvarchar(255)The transition on reject identifier
AWTtinyint(1)

Admissible values for this field are:

  • 1 (to allow the automatic workflow transitioning on approving)
  • 0
AWTRtinyint(1)

Admissible values for this field are:

  • 1 (to allow the automatic workflow transitioning on rejecting)
  • 0
AWTADtinyint(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)
ARNtinyint(1)

Admissible values for this field are:

  • 1 (to allow the automatic email notification)
  • 0
MRAdouble

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

MRRdouble

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_IDint(11)The Unique Identifier of the Conditional Rule
IS_LOCKEDtinyint(1)

Admissible values for this field are:

  • 1 (the app is still restoring consistence of approvals)
  • 0
IS_DRAFTtinyint(1)

Admissible values for this field are:

  • 1 (the mapping has not be saved jet)
  • 0
IS_DELETEtinyint(1)

Admissible values for this field are:

  • 1 (the required approvals have been removed and the mapping has not be saved jet)
  • 0
LOCKED_DATEvarchar(255)Data/Hours the mapping has been locked
IS_NOT_SINGLEtinyint(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
NACtinyint(1)

Admissible values for this field are:

  • -1 -> NAC is set to Enabled
  • 0 -> MRA -> is set to Disable
RACtinyint(1)

Admissible values for this field are:

  • 1, the Approval Comment is required
  • 0 , the Approval Comment is not required(Default)
RACAvarchar(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
SAtinyint(1)

Admissible values for this field are:

  • 1, the Sequential Approval is enabled
  • 0, the Sequential Approval is disabled (Default)
SAADtinyint(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_IDint(11) 

The Unique Identifier of the Approval Reply email template

MAIL_TEMPLATE_REQUEST_IDint(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_PICKERvarchar(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_IDint(11)The Notification Scheme identifier 
SUPER_APPROVERS_EXPRtext (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
titleIndexes 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
titleColumns
ColumnTypeDescription 
DEFINERvarchar(255) 

Approval Definer value

IDint(11) AI PK The unique approval definers identifier
ISSUE_TYPE_IDvarchar(255) The issue type identifier
PROJECT_IDbigint(20) The project identifier
TYPEvarchar(255)

Admissible values for this field are:

  • Users
  • Groups
  • Roles
  • Reporter
  • Assignee
  • Project Lead
Expand
titleIndexes 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
titleColumns
ColumnTypeDescription 
IDint(11) AI PK The unique approval recipients identifier
RECIPIENTvarchar(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>
TYPEvarchar(255)

Admissible values for this field are:

  • NEVER
  • APPROVER
  • PROJECTLEAD
  • ASSIGNEE
  • REPORTER
  • GROUP
  • ROLE
  • USER
  • REPLY_USER_PICKER
EVENTSvarchar(255)

Admissible values for this field are:

  • NEVER (Only case of Type= Never)
  • DefaultEvent
  • Complete Approval
  • Rejected



Expand
titleIndexes 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
titleColumns
ColumnTypeDescription 
IDint(11) AI PK The unique SCHEME_DETAIL identifier
NTF_SCHEME_IDint(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_EXPRESSIONlongtextthe Expression identifying the users to notify
CUSTOM_MAIL_TEMPLATE_ID int(11)The email template identifier
Expand
titleIndexes 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
titleColumns
ColumnTypeDescription 
IDint(11) AI PK The unique email reply notification scheme identifier
NAMEvarchar(255)The email reply notification scheme name
DESCRIPTIONvarchar(255)The email reply notification scheme description
Expand
titleIndexes 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
titleColumns
ColumnTypeDescription 

CUSTOM_TEMPLATE_NAME

varchar(255) 

The name of the template

IDint(11) AI PK The unique template identifier
PROJECT_IDbigint(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_IDint(11)The Unique Identifier of the Conditional Rule that, when it returns true, set the email priority to High
CONDITION_ENABLING_TEMPLATE_IDint(11)The Unique Identifier of the Conditional Rule that enables the Email template,
HIDE_CREATEDtinyint(1)

Admissible values for this field are:

  • 1 (the issue creation date is hidden)
  • 0 (the issue creation date is shown)
HIDE_ISSUE_TYPEtinyint(1)

Admissible values for this field are:

  • 1 (the issue type is hidden)
  • 0 (the issue type is shown)
HIDE_PRIORITYtinyint(1)

Admissible values for this field are:

  • 1 (the issue priority is hidden)
  • 0 (the issue priority is shown)
CUSTOM_APPROVAL_INSTRUCTlongtext

Admissible values for this field are:

  • Null (Default Instructions)
  • Text (Customized Instructions)
HIDE_APPROVAL_INSTRUCTtinyint(1)

Admissible values for this field are:

  • 1 (the Approval instructions are hidden)
  • 0 (the Approval instructions are shown)
HIDE_ASSIGNEEtinyint(1)

Admissible values for this field are:

  • 1 (the issue assignee is hide)
  • 0 (the issue assignee date is shown)
HIDE_WORKFLOW_TRANStinyint(1)

Admissible values for this field are:

  • 1 (the issue workflow transition is hidden)
  • 0 (the issue workflow transition is shown)
HIDE_PROJECTtinyint(1)

Admissible values for this field are:

  • 1 (the issue project is hidden)
  • 0 (the issue project is shown)
HIDE_REPORTERtinyint(1)

Admissible values for this field are:

  • 1 (the issue reporter is hidden)
  • 0 (the issue reporter is shown)
HIDE_DESCRIPTIONtinyint(1)

Admissible values for this field are:

  • 1 (the issue description is hidden)
  • 0 (the issue description is shown)
IS_EMAIL_TEMPLATE_DEFAULTtinyint(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_REPLYtinyint(1)

Admissible values for this field are:

  • 1 (Approval Reply template )
  • 0 (Approval Request template)
FOOTERlongtextThe text to show on the email footer
HEADERlongtextThe text to show on the email header
ICON_IDint(11)The unique identifier of the image to appear on the left of the email header. 
SUBJECTlongtextThe email subject
HIDE_LOGOtinyint(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_COMMENTtinyint(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
TYPEint(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_SECTIONlongtextAn optional text appended displayed in the email body.
COMMENT_ENABLEDtinyint(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_BUTTONtinyint(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_AUTHtinyint(1)

Admissible values for this field are:

  • 1 (the option to require approver authentication is turned OnOn)
  • 0 (Default)
REQUIRE_AUTH_SPEC tinyint(1)

Admissible values for this field are:

1 (username/password authentication)
0 (password authentication Default)

BUTTON_TEXTSvarchar(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_SUBTASKStinyint(1)

Admissible values for this field are:

  • 1 (the option to display SUBTASKS is turned On)
  • 0 (Default)
SUBTASKS_FIELDSlongtext

A text listing the fields to display into the approval email.

E.g. {"fields":["customfield_10107","versions"]}

Expand
titleIndexes 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
titleColumns
ColumnTypeDescription 

CUSTOM_MAIL_TEMPLATE_ID

int(11)

The Template identifier

FIELD_ID varchar(255) The field identifier
IDint(11) AI PK The unique fields_template identifier
SEQUENCEint(11)The order that will be followed to list the fields on the email
SHOW_EMPTYtinyint(1)

Admissible values for this field are:

1 (the option to display Empty values is turned On)
0 (Default)

Expand
titleIndexes 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
titleColumns
ColumnTypeDescription 

CONDITIONAL_NAME

varchar(255) 

The Conditional Rule name

CONDITIONAL_RULElongtext

The Conditional Rule expression

IDint(11) AI PK 

The Unique Identifier of the Conditional Rule

USER_EVALUATORvarchar(255)The user considered in order to evaluate the condition
Expand
titleIndexes 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
titleColumns
ColumnTypeDescription 
ACTIONvarchar(255)

Admissible values for this field are:

  • Approved
  • Pending
  • Rejected
  • Automatic transitioning
  • Automatic notification
  • Single notification
  • Approvals Notification
  • Abstained
APPROVAL_NAMEvarchar(255)Approval denomination
DATEvarchar(255)Action's Data/Hours
DESTINATION_STATUSvarchar(255)The workflow destination status
EXECUTORvarchar(255)The user having performed the action (if applicable)
EXECUTOR_KEYvarchar(255)The userkey of the user having performed the action (if applicable)
IDint(11) AI PK The Unique Identifier of the Approval History
ISSUE_IDbigint(20)The issue Identifier
SOURCE_STATUSvarchar(255)The workflow source status
TRANSITION_NAMEvarchar(255)The workflow transition
APPROVAL_DETAILlongtextA 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_DATEvarchar(255)Data-time the approval was submitted
DELEGATOR_KEYvarchar(255)The userkey od the delegated user that performed the approval action
Expand
titleIndexes 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
titleColumns
ColumnTypeDescription 
REQUESTERvarchar(255) 

Approval Requester value

IDint(11) AI PK The unique approval definers identifier
ISSUE_TYPE_IDvarchar(255) The issue type identifier
PROJECT_IDbigint(20) The project identifier
TYPEvarchar(255)

Admissible values for this field are:

  • Users
  • Groups
  • Roles
  • Reporter
  • Assignee
  • Project Lead
Expand
titleIndexes 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
titleColumns
ColumnTypeDescription 
APPROVAL_MAPPING_ID int(11)

The Approval Mapping identifier

CONDITIONAL_RULE_IDint(11)The Conditional Rule identifier
IDint(11) AI PK The unique approval definers identifier
ISSUE_IDbigint(20)The issue identifier
MRAdoubleThe minimum required replies
ORDERint(11)

The order of evaluation

SOURCE_STATUS_ID varchar(255)The workflow source status identifier
TRANSITION_IDvarchar(255)The workflow transition identifier
TYPEvarchar(255)

Admissible values for this field are:

  • CMRA (Minimum Required approbations based on conditions)
  • CMRR (Minimum Required rejections based on conditions)
Expand
titleIndexes 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
titleColumns
ColumnTypeDescription 

DESTINATION_STATUS_ID bigint(20)

bigint(20)

The workflow destination status identifier

EXECUTION_TIMEbigint(20)Execution time expressed in milliseconds
ID int(11) AI PKint(11) AI PK The unique record identifier
ISSUE_IDbigint(20)The issue identifier
FORCE_REFRESHtinyint(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_DISPATCHEDtinyint(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
titleIndexes 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
titleColumns
ColumnTypeDescription
ICON_ENCODEDlongtextBase64 encode Image
IDint(11) AI PKThe unique icon identifier
IMG_FORMATvarchar(255)

Admissible values for this field are:

  • Nul for image type Default
  • gif, png, jpeg, jpg, bmp, wbmp for image type Upload
NAMEvarchar(255)The file name (e.g. Logo.png)
TYPEvarchar(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
titleIndexes 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
titleColumns
ColumnTypeDescription
IDint(11) AI PKThe unique icon identifier
RECIPIENTvarchar(255)

The selected recipients of the email notification or

the unique identifier of the selected User Picker.

TYPEvarchar(255)

Admissible values for this field are:

  • Users
  • Groups
  • Roles
  • Reporter
  • Assignee
  • Project Lead
  • USER_PICKER
Expand
titleIndexes 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
titleColumns
ColumnTypeDescription
IDint(11) AI PKThe unique icon identifier
ITEMvarchar(255) The selected users or groups
TYPEvarchar(255)

Admissible values for this field are:

  • Users
  • Groups
Expand
titleIndexes 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
titleColumns
ColumnTypeDescription
DELEGATED_KEYvarchar(255)The delegated user key
DELEGATOR_KEYvarchar(255)The delegator user key
END_DATEvarchar(255)The delegation end date
IDint(11) AI PK                                      The unique delegation identifier
ISSUE_TYPE_IDvarchar(255)The issue type identifier
PROJECT_IDbigint(20)The project identifier
START_DATEvarchar(255)The delegation start date
Expand
titleIndexes 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
titleColumns
ColumnTypeDescription
IDint(11) AI PK                                      The unique approval sequence identifier
APPROVAL_IDint(11)The approval identifier
SEQUENCEint(11)The approval sequence
USER_KEYvarchar(255)The user identifier
Expand
titleIndexes 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

Info
iconfalse

Table of Contents

Feel free to reach out to us with any questions!

We'd love to hear it.