---
title: "Database model"
canonical: "https://wiki.brokenbuild.net/space/VH/3227189249/Database%20model"
format: markdown
---
> Macro (toc)

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 |