Versions Compared

Old Version 23

changes.mady.by.user Antonella Capalbo

Saved on

compared with

New Version 24

changes.mady.by.user Antonella Capalbo

Saved on

Key

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

When you install the Herzum Quick Linker add-on  app into your JIRA Jira instance, the following tables are created in your JIRA Jira database.

Table of Contents
:

The image below shows the HAP Entity Relationship Diagram. 


The descriptions of the fields for each of the Herzum Quick Linker tables are 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 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 Jira instance and Destination URL isn't
  • 'Destinatin' if Destination URL is the Current JIRA Jira instance and Source URL isn't.

SOURCE_SERVER_ID varchar(255) 

Server Identifier of the source JIRA Jira instance

DESTINATION_SERVER_ID varchar(255) Server Identifier of the remote JIRA Jira instance

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 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 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 Jira Link' if selected Link Type is JIRA 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 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
SYSTEM_USER_CREDENTIALS tyniint(1)

Admissible values for this field are:

  • '1' If Allow issue creation/linking via partnership credentials is set to False (Default)
  • '0' If Allow issue creation/linking via partnership credentials is set to True
SCHEMA_PATTERN_REL_ID int(11) Identifier of the Scheme/Pattern association.
LINK_ACTIONS varchar(255)

Admissible values for this field are:

  • 'CreateLinkingPlusLinkExisting' the Create&Linking button and Link Existing button are all two displayed (Default)
  • 'CreateLinking' the Create&Linking button is displayed exclusively
  • 'LinkExisting'' the Link Existing button is displayed exclusively

...

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).
JIRAJira_LINK_TYPE varchar(255) The  Identifier of the JIRA 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.  
RANK_DIN_S int(11) Maintain the issue ranking source side
RANK_SIN_S int(11) Maintain the issue ranking target side
IS_JIRAJira_LINK tinyint(1) 

Admissible values for this field are:

  • '1' if the link isJIRA Jira link type
  • '0' if the link isQuick link type or Both
LINK_VERSUS_OUT_IN tinyint(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_CONFIG

The Table holds Global Configuration data

ColumnDescription
ID int(11) PK 
STATUS varchar(255) 

QL_LABEL varchar(255) 

Text displayed as label of the Herzum Quick links web panel
QA_LABEL varchar(255) Text displayed as label of the Herzum Quick actions web panel

Table: AO_3F6548_TOKEN_INFO

System Table maintaining temporary data for sync management

ColumnDescription
ID int(11) AI PK The Unique Token Identifier (Primary Key)
ISSUE bigint(20) The Issue Identifier of the issue receiving the token.
TOKEN varchar(255) The Token identifier. It is obtained concatenating the strings “SERVER_ID” and ”TOKEN_INFO.ID
UPDATED_FIELD_LIST varchar(255)List of synced fields associated to the token.
CREATION_TIME bigint(20)Creation time that token is stored, in milliseconds.

ATTACHMENT_SYNC_LIST longtext

List of synced attachments associated to the token.

Table: AO_3F6548_SCHEME_PATTERN_REL 

The Table holds the associations between Schemes and Mapping Patterns

ColumnDescription
ID int(11) AI PK         The Unique Mapping Pattern/Scheme association Identifier (Primary Key)              
MAPPING_PATTERN_ID int(11)The Mapping Pattern Identifier 
MAPPING_SCHEME_ID int(11)The Mapping Scheme Identifier 

Table: AO_3F6548_PROJECT_SCHEME_REL  

The Table holds the associations between Schemes and Projects

ColumnDescription
ID int(11) AI PK         The Unique Mapping Scheme/Project association Identifier (Primary Key)
MAPPING_SCHEME_ID int(11)The Mapping Scheme Identifier
PROJECT_ID bigint(20)The Project Identifier

Table: AO_3F6548_MAPPING_SCHEME   

The Table holds the Mapping Schemes

ColumnDescription
ID int(11) AI PK         The Unique Mapping Scheme Identifier (Primary Key)

SCHEME_DENOMINATION varchar(255)

The Mapping Scheme denomination

Table: AO_3F6548_MAPPING_PATTERN    

The Table holds the Mapping Patterns

ColumnDescription

HQL_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 Jira Link' if selected Link Type is JIRA Jira Link.
ID int(11) AI PK The Unique Mapping Pattern Identifier (Primary Key)
ISSUE_LINK_TYPE bigint(20)Identifier of the JIRA Jira issue Link.
LABEL varchar(255)The Button label.
LINK_VERSUS_OUT_IN tinyint(1)

Admissible values for this field are:

  • '1' if selected Link versus is Outward/Inward (Default)
  • '0' if selected Link versus is Inward/Outward
PARTNERSHIP_ID int(11)The Partnership Identifier.
SOURCE_ISSUE_TYPE varchar(255)The "from" Issue Type Identifier.
SYSTEM_USER_CREDENTIAL tinyint(1)

Admissible values for this field are:

  • '1' If Allow issue creation/linking via partnership credentials is set to False (Default)
  • '0' If Allow issue creation/linking via partnership credentials is set to True
TARGET_ISSUE_TYPE varchar(255)The "to" Issue Type Identifier.
LINK_ACTIONS varchar(255)

Admissible values for this field are:

  • 'CreateLinkingPlusLinkExisting' the Create&Linking button and Link Existing button are all two displayed (Default)
  • 'CreateLinking' the Create&Linking button is displayed exclusively
  • 'LinkExisting'' the Link Existing button is displayed exclusively
 SYNCH_RESTRICTION_VISIBILITY

Admissible values for this field are:

  • '0' if  Synch Restriction Visibility is set to False (Default )
  • '1' if Synch Restriction Visibility is set to True

...