Page Comparison

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
Column	Description
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:

CONSTRAINT "AO_3F6548_

MAPPING

The Table holds Mapping configuration data

ColumnDescriptionCONFIG_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.

PARTNERSHIP_pkey" PRIMARY KEY ("ID"),
CONSTRAINT fk_ao_3f6548_partnership_config_id FOREIGN KEY ("CONFIG_ID") REFERENCES "AO_3F6548_CONFIG"("ID"),
CONSTRAINT fk_ao_3f6548_partnership_icon_id FOREIGN KEY ("ICON_ID") REFERENCES "AO_3F6548_ICON"("ID")

Table: AO_3F6548_MAPPING

The Table holds Mapping configuration data

Column

Description

CONFIG_ID int(11)

Not used. This field supports migration from older versions.

FIELDS

CUSTOM_FIELD_MAPPING 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)


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: '

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_

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

Partnership Identifier.REMOTE_MAPPING_ID int(11) The Remote Mapping Identifier.SOURCE_ISSUE_TYPE

Unique Mapping Identifier (Primary Key).
LABEL varchar(255)	The Button label.
LINK varchar(255)

The "from" Issue Type Identifier

Identifier of the Jira issue Link.

SOURCE

LINK_

PROJECT

TYPE varchar(255

)The "from" JIRA Project Identifier.LINK_VERSUS_OUT_IN tyniint(1

)	Admissible values for this field are: '

1

Both' if selected Link

versus is Outward/Inward (Default)

Type is both
'

0SCHEMA_PATTERN_REL_ID

Quick Link' 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

Link Type is Quick Link
'Jira Link' if selected Link Type is Jira Link.

PARTNERSHIP_ID int(11)

Identifier of the Scheme/Pattern association.LINK_ACTIONS

The Partnership Identifier.
REMOTE_MAPPING_ID int(11)	The Remote Mapping Identifier.
SOURCE_ISSUE_TYPE 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

Table: AO_3F6548_FIELDS_MAPPING

The Table holds Mapping configuration data for issues field sync

ColumnDescriptionDESTINATION_FIELD_ID varchar(255) 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)

	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
SYSTEM_USER_CREDENTIALS tyniint(1)	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.

'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:

'

Comment' or 'Attachment

CreateLinkingPlusLinkExisting'

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) 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' or Null if Sync on create is set to False
'1'if Sync on create is set to True (this setting is not allowed for Assigee and Reporter)

NULL_ON_MISALIGNMENT tinyint(1)

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)

MAPPING_PATTERN_ID int(11) The Mapping Pattern Identifier.SOURCE_CF_TYPE

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
WORKFLOW_STATUS varchar(255)	A list of Workflow Status Ids separated by comma or no value.
ALLOWS_TO_NOTIFY tyniint(1)	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.

'1', if the notification of the linked issue Resolution is enabled '0', if the notification of the linked issue Resolution is disabled(Default)
ALLOWS_TO_NOTIFY_COMMENT varchar(255)	An optional text that will be added as comment when the linked issue changes its Resolution.
CONSTRAINT "AO_3F6548_MAPPING_pkey" PRIMARY KEY ("ID"), CONSTRAINT fk_ao_3f6548_mapping_config_id FOREIGN KEY ("CONFIG_ID") REFERENCES "AO_3F6548_CONFIG"("ID"), CONSTRAINT fk_ao_3f6548_mapping_partnership_id FOREIGN KEY ("PARTNERSHIP_ID") REFERENCES "AO_3F6548_PARTNERSHIP"("ID")

DESTINATION_CF_TYPE varchar

Table: AO_3F6548_FIELDS_MAPPING

The Table holds Mapping configuration data for issues field sync

Column

Description

DESTINATION_FIELD_ID varchar(255)

Admissible values for this field are:

'select' if the source field is a Select list (single choice) or a Radio button
'multiSelect' if the source field is a Select list (multiple choice) or a Check box.
Null for all other settings.

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: '

select' if the target field is a Select list (single choice) or a Radio button

'multiSelect' if the target field is a Select list (multiple choice) or a Check box.

Null for all other settings.

SYNCH_AUTOR tinyint(1)

Table: AO_3F6548_ISSUES_LINK

The Table holds Issue Link data

ColumnDescriptionDESTINATION_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)

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:

'0' if Synch Comment Author is set to False (Default )
'1' if Synch Comment Author is set to True

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:

INTERNAL

0 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 sideRANK_SIN_S int(11) Maintain the issue ranking target sideIS_JIRA_LINK tinyint(1) Admissible values for

field mapping isn't enabled
1 when the field mapping is enabled.

SYNCH_ON_CREATE tinyint(1)

Admissible values for this field are:

'0' or Null if Sync on create is set to False
'1'if Sync on create is set to True (this setting is not allowed for Assigee and Reporter)

NULL_ON_MISALIGNMENT tinyint(1)

Admissible values for this field are:

'

1LINK_VERSUS_OUT_IN tinyint(1

0' if

the link isJIRA link type'0' if the link isQuick link type or Both

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

MAPPING_PATTERN_ID int(11)

The Mapping Pattern Identifier.

SOURCE_CF_TYPE varchar(255)

Admissible values for this field are:

'

1

select' if

selected Link versus is Outward/Inward (Default)

'0' if selected Link versus is Inward/Outward

Table: AO_3F6548_ICON

The Table holds Partnership icon

ColumnDescriptionICON_ENCODED longtext The encoded icon uploaded by the user.
The value is Null for all icons loaded by default.ID int(11) AI PK The Unique Icon Identifier (Primary Key).IMG_FORMAT varchar(255) The file format of the icon loaded by the user.
The value is Null for all icons loaded by default.NAME varchar(255) The file name.TYPE varchar(255)

the source field is a Select list (single choice) or a Radio button 'multiSelect' if the source field is a Select list (multiple choice) or a Check box. Null for all other settings.
DESTINATION_CF_TYPE varchar(255)	Admissible values for this field are: 'select' if the target field is a Select list (single choice) or a Radio button 'multiSelect' if the target field is a Select list (multiple choice) or a Check box. Null for all other settings.
SYNCH_AUTOR tinyint(1)	Admissible values for this field are: '0' if Synch Comment Author is set to False (Default ) '1' if Synch Comment Author is set to True
SYNCH_RESTRICTION_VISIBILITY	Admissible values for this field are:

JPEG
GIF
PNG

Table: AO_3F6548_CONFIG The Table holds Global Configuration data
Column	Description
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

'0' if Synch Restriction Visibility is set to False (Default ) '1' if Synch Restriction Visibility is set to True
CONSTRAINT "AO_3F6548_FIELDS_MAPPING_pkey" PRIMARY KEY ("ID"), CONSTRAINT fk_ao_3f6548_fields_mapping_mapping_id FOREIGN KEY ("MAPPING_ID") REFERENCES "AO_3F6548_MAPPING"("ID"), CONSTRAINT fk_ao_3f6548_fields_mapping_mapping_pattern_id FOREIGN KEY ("MAPPING_PATTERN_ID") REFERENCES "AO_3F6548_MAPPING_PATTERN"("ID")

Table: AO_3F6548_ISSUES_LINK The Table holds Issue Link data
Column	Description
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.
RANK_DIN_S int(11)	Maintain the issue ranking source side
RANK_SIN_S int(11)	Maintain the issue ranking target side
IS_Jira_LINK tinyint(1)	Admissible values for this field are: '1' if the link isJira 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
CONSTRAINT "AO_3F6548_ISSUES_LINK_pkey" PRIMARY KEY ("ID"), CONSTRAINT fk_ao_3f6548_issues_link_mapping_id FOREIGN KEY ("MAPPING_ID") REFERENCES "AO_3F6548_MAPPING"("ID")

Table: AO_3F6548_ICON The Table holds Partnership icon
Column	Description
ICON_ENCODED longtext	The encoded icon uploaded by the user. The value is Null for all icons loaded by default.
ID int(11) AI PK	The Unique Icon Identifier (Primary Key).
IMG_FORMAT varchar(255)	The file format of the icon loaded by the user. The value is Null for all icons loaded by default.
NAME varchar(255)	The file name.
TYPE varchar(255)	Admissible values for this field are: JPEG GIF PNG
CONSTRAINT "AO_3F6548_ICON_pkey" PRIMARY KEY ("ID")

Table: AO_3F6548_CONFIG The Table holds Global Configuration data
Column	Description
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
CONSTRAINT "AO_3F6548_CONFIG_pkey" PRIMARY KEY ("ID")

Table: AO_3F6548_TOKEN_INFO System Table maintaining temporary data for sync management
Column	Description
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.
CONSTRAINT "AO_3F6548_TOKEN_INFO_pkey" PRIMARY KEY ("ID")

Table: AO_3F6548_SCHEME_PATTERN_REL The Table holds the associations between Schemes and Mapping Patterns
Column	Description
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
CONSTRAINT "AO_3F6548_SCHEME_PATTERN_REL_pkey" PRIMARY KEY ("ID"), CONSTRAINT fk_ao_3f6548_scheme_pattern_rel_mapping_pattern_id FOREIGN KEY ("MAPPING_PATTERN_ID") REFERENCES "AO_3F6548_MAPPING_PATTERN"("ID"), CONSTRAINT fk_ao_3f6548_scheme_pattern_rel_mapping_scheme_id FOREIGN KEY ("MAPPING_SCHEME_ID") REFERENCES "AO_3F6548_MAPPING_SCHEME"("ID") )

Table: AO_3F6548_PROJECT_SCHEME_REL

The Table holds the associations between Schemes and Projects

Column

Description

ID int(11) AI PK

The Unique

Token

Table: AO_3F6548_SCHEME_PATTERN_REL

The Table holds the associations between Schemes and Mapping Patterns

ColumnDescriptionID 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

Mapping Scheme/Project association 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.IDUPDATED_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.

MAPPING_SCHEME_ID int(11)	The Mapping Scheme Identifier
PROJECT_ID bigint(20)	The Project Identifier
CONSTRAINT "AO_3F6548_PROJECT_SCHEME_REL_pkey" PRIMARY KEY ("ID"), CONSTRAINT fk_ao_3f6548_project_scheme_rel_mapping_scheme_id FOREIGN KEY ("MAPPING_SCHEME_ID") REFERENCES "AO_3F6548_MAPPING_SCHEME"("ID")

Table: AO_3F6548_

PROJECT

MAPPING_

SCHEME_REL

SCHEME

The Table holds the

associations between

Mapping Schemes

and Projects


Column	Description
ID int(11) AI PK	The Unique Mapping Scheme

/Project association

Identifier (Primary Key)

MAPPING_

SCHEME_

ID int

DENOMINATION varchar(

11

255)	The Mapping Scheme

IdentifierPROJECT_ID bigint(20)The Project Identifier

denomination
CONSTRAINT "AO_3F6548_MAPPING_SCHEME_pkey" PRIMARY KEY ("ID")

Table: AO_3F6548_

MAPPING_SCHEME

The Table holds the Mapping Schemes

ColumnDescription

MAPPING_PATTERN

The Table holds the Mapping Patterns

Column

Description

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 Link' if selected Link Type is Jira Link.

ID int(11) AI

PK

PK	The Unique Mapping

Scheme Identifier (Primary Key)SCHEME_DENOMINATION

Pattern Identifier (Primary Key)
ISSUE_LINK_TYPE bigint(20)	Identifier of the Jira issue Link.
LABEL varchar(255)	The

Mapping Scheme denomination

Table: AO_3F6548_MAPPING_PATTERN

The Table holds the Mapping Patterns

ColumnDescriptionHQL_LINK_TYPE varchar(255

Button label.
LINK_VERSUS_OUT_IN tinyint(1)	Admissible values for this

field are:

'Both' if selected Link Type is both

'Quick Link

field are:

'1' if selected Link

Type is Quick Link

versus is Outward/Inward (Default)
'

JIRA Link

0' if selected Link

Type is JIRA Link.

versus is Inward/Outward

PARTNERSHIP_ID int(11)

AI PK

The

Unique Mapping Pattern Identifier (Primary Key)ISSUE_LINK_TYPE bigint(20)Identifier of the JIRA issue Link.LABEL

Partnership Identifier.
SOURCE_ISSUE_TYPE varchar(255)	The

Button label

"from" Issue Type Identifier.

LINK

SYSTEM_

VERSUS

USER_

OUT_IN

CREDENTIAL tinyint(1)

Admissible values for this field are:

'1'

if selected Link versus is Outward/Inward

If Allow issue creation/linking via partnership credentials is set to False (Default)
'0'

if selected Link versus is Inward/OutwardPARTNERSHIP_ID int(11)The Partnership Identifier.SOURCE_ISSUE_TYPE varchar(255)The "from" Issue Type Identifier.SYSTEM_USER_CREDENTIAL tinyint(1)

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: '

1' If Allow issue creation/linking via partnership credentials

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

0' If Allow issue creation/linking via partnership credentials

1' if Synch Restriction Visibility 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


CONSTRAINT "AO_3F6548_MAPPING_PATTERN_pkey" PRIMARY KEY ("ID"), CONSTRAINT fk_ao_3f6548_mapping_pattern_partnership_id FOREIGN KEY ("PARTNERSHIP_ID") REFERENCES "AO_3F6548_PARTNERSHIP"("ID") )

Table: AO_3F6548_PERMISSIONS The Table holds Permissions
Column	Description
ENTITY varchar(255)	Admissible values for this field are: Quick Links Quick Actions
ID int(11) AI PK	The Unique Permission Identifier (Primary Key)
ISSUE_TYPE_ID varchar(255)	The issue type Identifier
PROJECT_ID bigint(20)	The project Identifier
TYPE varchar(255)	Admissible values for this field are: Users Groups Roles Reporter Assignee Project Lead Denied
VALUE varchar(255)	Admissible values for this field are: an user username a Group name a Project Role Reporter Assignee Project Lead All
CONSTRAINT "AO_3F6548_PERMISSIONS_pkey" PRIMARY KEY ("ID")

Versions Compared

Old Version 21

New Version Current

Key

Table: AO_3F6548_PARTNERSHIP

Table: AO_3F6548_MAPPING

Table: AO_3F6548_FIELDS_MAPPING

Table: AO_3F6548_FIELDS_MAPPING

Table: AO_3F6548_ISSUES_LINK

Table: AO_3F6548_ICON

Table: AO_3F6548_CONFIG

Table: AO_3F6548_TOKEN_INFO

Table: AO_3F6548_ISSUES_LINK

Table: AO_3F6548_ICON

Table: AO_3F6548_CONFIG

Table: AO_3F6548_TOKEN_INFO

Table: AO_3F6548_SCHEME_PATTERN_REL

Table: AO_3F6548_PROJECT_SCHEME_REL

Table: AO_3F6548_SCHEME_PATTERN_REL

Table: AO_3F6548_

MAPPING_

SCHEME

Table: AO_3F6548_

MAPPING_PATTERN

Table: AO_3F6548_MAPPING_PATTERN

Table: AO_3F6548_PERMISSIONS