Herzum Approval Database
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
Feel free to reach out to us with any questions!
We'd love to hear from you.
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, Indexes and Foreign Key | User interfaces | Table Fields |
|---|---|---|
AO_D195E9_CONFIG
The Table holds the values chosen for the options available on different administration screens.
CONSTRAINT "AO_D195E9_CONFIG_pkey" PRIMARY KEY ("ID")
|
| |
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 | |
AO_D195E9_APPROVAL_PROJECTS
The Table holds the projects selected in the Herzum Approval > Permissions panel.
PRIMARY KEY (`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.
PRIMARY KEY (`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.
PRIMARY KEY (`ID`),
| Jira issue View screen > Issue Approval |
|
AO_D195E9_APPROVAL_MAPPING_REL
The Table holds the association between Approvals and Approvals Mappings.
PRIMARY KEY (`ID`),
| Herzum Approval > Approval Mapping Administration |
|
AO_D195E9_APPROVAL_MAPPING
The Table holds Approval Mappings information.
KEY `index_ao_d195e9_app310593943` (`MAIL_TEMPLATE_REQUEST_ID`), FOREIGN KEY (`NTF_SCHEME_ID`) REFERENCES `AO_D195E9_NTF_SCHEME` (`ID`),
| Herzum Approval > Approval Mapping Administration |
|
AO_D195E9_APPROVAL_DEFINERS
The Table holds the permission to set-up the Approval Configuration for Single Issues.
PRIMARY KEY (`ID`),
| Herzum Approval > Permissions > Define Custom Approval Rules for single issues > Add Permissions | |
AO_D195E9_APPROVAL_RECIPIENTS
The Table holds the Recipients set-up with respect to the Approval Reply notified via email.
PRIMARY KEY (`ID`)
| Herzum Approval > Recipients > Approval Reply |
|
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.
PRIMARY KEY (`ID`) FOREIGN KEY (`NTF_SCHEME_ID`) REFERENCES `AO_D195E9_CONFIG` (`AO_D195E9_NTF_SCHEME`),
| Herzum Approval > Recipients > Approval Reply | |
AO_D195E9_NTF_SCHEME
The Table holds custom email reply notification schemes registry.
PRIMARY KEY (`ID`) | Herzum Approval > Recipients > Approval Reply | |
AO_D195E9_CUSTOM_MAIL_TEMPLATE
The Table holds custom email templates header information.
PRIMARY KEY (`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 | |
AO_D195E9_FIELDS_TEMPLATE
The Table holds custom email templates rows information.
PRIMARY KEY (`ID`),
| Herzum Approval > E-Mail Templates | |
AO_D195E9_CONDITIONAL_RULE
The Table holds Conditional Rules information
PRIMARY KEY (`ID`)
| Herzum Approval > Conditional Rules | |
AO_D195E9_APPROVAL_HISTORY
The Table holds the history of approval events including approval notification, approval status changes and automatic issue transitioning.
PRIMARY KEY (`ID`),
|
| |
AO_D195E9_APPROVAL_REQUESTERS
The Table holds the permission to notify an approval request.
PRIMARY KEY (`ID`),
| Herzum Approval > Permissions > Approval Request > Add Permissions | |
AO_D195E9_APPROVAL_MRA
The Table holds the Minimum Required Approvals based on conditions information.
PRIMARY KEY (`ID`),
| Herzum Approval > Approval Mapping Administration | |
AO_D195E9_AUTO_TRANSITION
The Table holds information allowing
PRIMARY KEY (`ID`), |
|
|
AO_D195E9_ICON
The Table holds the images to appear on the Approval Request and Approval Replay emails.
PRIMARY KEY (`ID`)
| Herzum Approval > E-Mail Templates | |
AO_D195E9_APPROVAL_NOT_NOTIFY
The Table holds the users to exclude when the automatic and the massive Approval Request email notification run.
PRIMARY KEY (`ID`)
| Herzum Approval > Recipients > Approval Request | |
AO_D195E9_APPROVAL_MENU_PERM
The Table holds the users allowed to view the Approval button on the application header bar.
PRIMARY KEY (`ID`)
| Herzum Approval > Permissions >Approval Menu | |
AO_D195E9_APPROVAL_DELEGATED
The Table holds the information regarding the delegation of approval authority.
PRIMARY KEY (`ID`),
| Jira menu bar >Approval item > Manage delegated approvers | |
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
PRIMARY KEY (`ID`), | Herzum Approval > Approval Administration >Sequential Approvals | |
Table: AO_D195E9_LANGUAGE_PACK
The Table holds the language packs master data. Table: AO_D195E9_LANG_PACK_KEY_VAL The Table holds the properties translations per Language Pack.
PRIMARY KEY (`ID`) CONSTRAINT "AO_D195E9_LANG_PACK_KEY_VAL_pkey" PRIMARY KEY ("ID"), | Herzum Approval > Language Packs Administration |