Database model
- Vasyl Krokha
The information about the version hierarchy is stored in the following database tables:
Folder table
AO_27DE84_FOLDER - contains information about the hierarchy folders
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 |
Hierarchy item table
AO_27DE84_HIERARCHY_ITEM - contains the details of hierarchy items which represent references to Jira project versions and folders
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 |
Example data
Project
id: 10000
name: Test
key: TEST
Hierarchy
folder1 (id: 1)
version1 (id: 10000)
version2 (id: 10001)
folder2 (id: 2)
version3 (id: 10002)
version1 (id: 10000)
version4 (id: 10003)
AO_27DE84_FOLDER
ID | NAME | DESCRIPTION | PROJECT_ID |
|---|---|---|---|
1 | folder1 | null | 10000 |
2 | folder2 | null | 10000 |
AO_27DE84_HIERARCHY_ITEM
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 |