This page details how Herzum Approval impacts you JIRA database.
When you install the Herzum Approval add-on into your JIRA instance, the following tables are created in your JIRA database.
The image below shows the database schema for HAP 1.X.
The descriptions of the fields for each of the Herzum Approval tables are presented below.
Table: AO_D195E9_CONFIG | ||
|---|---|---|
| Column | Type | Description |
| ID | int(11) AI PK | |
Table: AO_D195E9_APPROVALThe Table holds anagraphic data for Approvals | ||
|---|---|---|
| Column | Type | Description |
| ASSIGNEE_ENABLED | tinyint(1) | Admissible values for this field are:
|
| CONFIG_ID | int(11) | |
| DESCRIPTION | varchar(255) | 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:
|
| REPORTER_ENABLED | tinyint(1) | Admissible values for this field are:
|
| ROLES | varchar(255) | The selected Project Role for the approval |
| USERS | varchar(255) | The selected User for the approval |
Table: AO_D195E9_ISSUE_APPROVALThe Table holds approvals issue status | ||
|---|---|---|
| Column | Type | Description |
| APPROVAL_ID | int(11) | The approval identifier |
| APPROVAL_STATUS | varchar(255) | Admissible values for this field are:
|
| APPROVER_USER | varchar(255) | The Last user changing approval status |
| DATE | varchar(255) | Date of the last approval status update |
| HAS_CONFIG_FOR_SINGLE_ISSUE | varchar(255) | Admissible values for this field are:
|
| ID | int(11) AI PK | The Unique Identifier of the Approval Issue Status(Primary Key). |
| ISSUE_ID | bigint(20) | The issue identifier |
| ISSUE_STATUS | varchar(255) | The issue status identifier |
| NOTIFICATION_DATE | varchar(255) | The Date of the last notification |
| SOURCE_STATUS_ID | varchar(255) | The configured source issue status identifier |
| TRANSITION_ID | varchar(255) | The transition identifier configured with the Approval |
| TRANSITION_NAME | varchar(255) | The transition name configured with the Approval |
| TYPE | varchar(255) | Admissible values for this field are:
|
Table: AO_D195E9_APPROVAL_MAPPING_RELThe Table holds correlation between AO_D195E9_APPROVAL and AO_D195E9_APPROVAL_MAPPING | ||
|---|---|---|
| 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 correlation identifier |
Table: AO_D195E9_APPROVAL_MAPPINGThe Table holds Approval Mappings main configuration | ||
|---|---|---|
| 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 transition identifier |