Database model

The information about the version hierarchy is stored in the following database tables:

AO_27DE84_FOLDER - contains information about the hierarchy folders

Column	Type	Description

Column	Type	Description
ID	Int, primary key	folder id
NAME	String, not null	folder name
DESCRIPTION	String	folder description
PROJECT_ID	Long, not null	Jira project reference of a folder

AO_27DE84_HIERARCHY_ITEM - contains the details of hierarchy items which represent references to Jira project versions and folders

Column		Description

Column		Description
ID	Int, primary key	hierarchy item id
PARENT_ID	Int, ID foreign key	reference to the parent item, null for top-level hierarchy items
REF_ID	Long, not null	the Jira project version or folder ID
REF_TYPE_ID	Int, not null	hierarchy item type: 1 - version, 2 - folder
SEQUENCE	Int, not null	the sequence of an item in the list of sibling items that have the same parent item
PROJECT_ID	Long, not null	Jira project reference of an item

folder1 (id: 1)
- version1 (id: 10000)
- version2 (id: 10001)
  - folder2 (id: 2)
    - version3 (id: 10002)
version1 (id: 10000)
- version4 (id: 10003)

ID	NAME	DESCRIPTION	PROJECT_ID

ID	NAME	DESCRIPTION	PROJECT_ID
1	folder1	null	10000
2	folder2	null	10000

ID	PARENT_ID	REF_ID	REF_TYPE_ID	SEQUENCE	PROJECT_ID

ID	PARENT_ID	REF_ID	REF_TYPE_ID	SEQUENCE	PROJECT_ID
1	null	1	2	1	10000
2	1	10000	1	1	10000
3	1	10001	1	2	10000
4	3	1	2	1	10000
5	4	10002	1	1	10000
6	null	10000	1	1	10000
7	6	10003	1	1	10000