This page details how Herzum Quick Linker impacts you JIRA database.When you install the Herzum Quick Linker add-on into your JIRA instance, the following tables are created in your JIRA database.
:Table of Contents
The image below shows the ERD for HQL 4.he HAP Entity Relationship Diagram.
The descriptions of the fields for each of the Herzum Quick Linker tables are detailed below.
Table: AO_3F6548_PARTNERSHIPThe Table holds Partnership configuration data | |
|---|---|
| Column | Description |
| CONFIG_ID int(11) | Not used. This field supports migration from older versions. |
| CONSISTENCY varchar(255) | Admissible values for this field are:
|
| CONSISTENCY_DESTINATION tinyint(1) | Admissible values for this field are:
|
| CONSISTENCY_SOURCE tinyint(1) | Admissible values for this field are:
|
| DESTINATION_PASSWORD varchar(255) | The Password to login on the Destination URL. |
| DESTINATION_URL varchar(255) | Destination URL. |
| DESTINATION_USERNAME varchar(255) | The User account to login on the Destination URL. |
| ICON_ID int(11) | The Icon Identifier. |
| ID int(11) AI PK | The Unique Partnership Identifier (Primary Key). |
| NAME varchar(255) | Partnership Name. |
| REMOTE_ID int(11) | Partnership Identifier on the Remote JIRA instance. |
| SOURCE_PASSWORD varchar(255) | The Password to login on the Source URL. |
| SOURCE_URL varchar(255) | Source URL. |
| SOURCE_USERNAME varchar(255) | The User account to login on the Source URL. |
| TYPE varchar(255) | Admissible values for this field are:
|
SOURCE_SERVER_ID varchar(255) | Server identifier of the source JIRA instance |
| DESTINATION_SERVER_ID varchar(255) | Server identifier of the remote JIRA instance |
Table: AO_3F6548_MAPPINGThe Table holds Mapping configuration data | |
|---|---|
| Column | Description |
| CONFIG_ID int(11) | Not used. This field supports migration from older versions. |
| CUSTOM_FIELD_MAPPING varchar(255) | Not used. This field supports migration from older versions. |
| DESTINATION_ISSUE_TYPE varchar(255) | The "to" Issue Type Identifier. |
| DESTINATION_PRIORITY varchar(255) | The priority Identifier for issues created by the escalation post function. |
| DESTINATION_PROJECT varchar(255) | The "to" JIRA Project Identifier. |
| POPUP_ENABLED tyniint(1) | Not used. This field supports migration from older versions. |
| FIELDS varchar(255) | Not used. This field supports migration from older versions. |
| HAS_QLFUNCTION tinyint(1) | Admissible values for this field are: |
| ID int(11) AI PK | The Unique Mapping Identifier (Primary Key). |
| LABEL varchar(255) | The Button label. |
| LINK varchar(255) | Identifier of the JIRA issue Link. |
| LINK_TYPE varchar(255) | Admissible values for this field are:
|
| PARTNERSHIP_ID int(11) | The Partnership Identifier. |
| REMOTE_MAPPING_ID int(11) | The Remote Mapping Identifier. |
| SOURCE_ISSUE_TYPE varchar(255) | The "from" Issue Type Identifier. |
| SOURCE_PROJECT varchar(255) | The "from" JIRA Project Identifier. |
| LINK_VERSUS_OUT_IN tyniint(1) | Admissible values for this field are:
|
| SYSTEM_USER_CREDENTIALS tyniint(1) | Admissible values for this field are:
|
...