Versions Compared

Old Version 1

changes.mady.by.user Antonella Capalbo

Saved on

compared with

New Version 2

changes.mady.by.user Antonella Capalbo

Saved on

Key

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

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 database schema he ERD for HQL 34. 

 

The descriptions of the fields for each of the Herzum Quick Linker tables are presented detailed below.

Table: AO_3F6548_PARTNERSHIP

The Table holds Partnership configuration data

ColumnDescription
CONFIG_ID int(11) Not used. This field supports migration from older versions.
CONSISTENCY varchar(255) 

Admissible values for this field are:

  • 'Enabled' if Destination URL is reachable and login is successful
  • 'Disabled_Invalid_User' if login isn't successful.
CONSISTENCY_DESTINATION tinyint(1) 

Admissible values for this field are:

  • '1' if login on Destination URL is successful
  • '0' if login on Destination URL is not successful.
CONSISTENCY_SOURCE tinyint(1) 

Admissible values for this field are:

  • '1' if if login on Source URL is successful
  • '0' if if login on Source URL is not successful.
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:

  • 'Local' if Source and Destination URL are the same 
  • 'Source' if Source URL is the Current JIRA instance and Destination URL isn't
  • 'Destinatin' if Destination URL is the Current JIRA instance and Source URL isn't.

SYNCH_ON_CREATE tinyint(1) Image Removed

Admissible values for this field are:

  • '0' if Sync on create is set to False
  • '1'if Sync on create is set to True (Not allowed for Assigee and Reporter)
  • Null if Sync on create is not set (only Comments and Attachment).

 

Table: AO_3F6548_MAPPING

The Table holds Mapping configuration data

ColumnDescription
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:
'0' if Quick Action Button/Post Function isn't flagged
'1' if Quick Action Button/Post Function is flagged.

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:

  • 'Both' if selected Link Type is both
  • 'Quick Link' if selected Link Type is Quick Link
  • 'JIRA Link' if selected Link Type is JIRA Link.
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:

  • '1' if selected Link versus is Outward/Inward (Default)
  • '0' if selected Link versus is Inward/Outward

Table: AO_3F6548_FIELDS_MAPPING

The Table holds Mapping configuration data for issues field sync

ColumnDescription
DESTINATION_FIELD_ID varchar(255) 

Admissible values for this field are:

  • null when the destination field is a comment or an attachment
  • the description of the destination field when the field isn't a custom field or a Comment or an Attachment
  • the string 'customfield_ ' & destination custom field id when the destination field is a custom field.
DESTINATION_FIELD_NAME varchar(255) The Destination field description.
ID int(11) AI PK The Unique Field Mapping Identifier (Primary Key).
MAPPING_ID int(11) The Mapping Identifier.
SOURCE_FIELD_ID varchar(255) 

Admissible values for this field are:

  • 'Comment' or 'Attachment' when the source field is a comment or an attachment
  • the description of the source field when the field isn't a custom field or a Comment or an Attachment
  • the string 'customfield_ ' & source custom field id when the source field is a custom field.
SOURCE_FIELD_NAME varchar(255)

The Source field description.

SYNC_DIRECTION varchar(255) 

Admissible values for this field are:

  • SOURCE when sync direction is from source to target
  • DESTINATION when sync direction is from target to source
  • BOTH when sync direction works in both direction depending by the most recent update.
SYNC_ENABLED tinyint(1)

When a new mapping is defined two field mappings for comments and attachments are automatically created having SYNC_ENABLED=0.

Admissible values for this field are:

  • 0 when the field mapping isn't enabled
  • 1 when the field mapping is enabled.
SYNCH_ON_CREATE tinyint(1) 

Admissible values for this field are:

  • '0' if Sync on create is set to False
  • '1'if Sync on create is set to True (Not allowed for Assigee and Reporter)
  • Null if Sync on create is not set (only Comments and Attachment).
NULL_ON_MISALIGNMENT

Admissible values for this field are:

  • '0' if Null on misalignment is set to Leave current value
  • '1'if Null on misalignment  is set to Null (Default for older configuration)

The Table holds Issue Link data

ColumnDescription
DESTINATION_ISSUE_ID bigint(20) The Identifier of the destination Issue.  
ID int(11) AI PK The Unique Issue Link Identifier (Primary Key).
JIRA_LINK_TYPE varchar(255) The  Identifier of the JIRA Link Type.
LINK_TYPE varchar(255) Admissible values for this field are:
INTERNAL when the target instance is the current instance
REMOTE when the target instance is a remote instance.
MAPPING_ID int(11) The Mapping Identifier.
SOURCE_ISSUE_ID bigint(20)The Identifier of the source Issue.  

...