# SonarQube schema ERD

Table and field reference for the Fivetran SonarQube connector.

## Table & Field Reference

### project_analyse_event

| Column | Type | Keys |
| --- | --- | --- |
| key | String | PK |
| project_analyse_key | String | PK, FK |
| category | String |  |
| description | String |  |
| name | String |  |

### project_analyse

| Column | Type | Keys |
| --- | --- | --- |
| key | String | PK |
| project_key | String | PK, FK |
| build_string | String |  |
| date | Instant |  |
| manual_new_code_period_baseline | Boolean |  |
| project_version | String |  |
| revision | String |  |

### rule_param

| Column | Type | Keys |
| --- | --- | --- |
| key | String | PK |
| rule_key | String | PK, FK |
| default_value | String |  |
| description | String |  |
| html_desc | String |  |
| type | String |  |

### rule_tag

| Column | Type | Keys |
| --- | --- | --- |
| tags | String | PK |
| rule_key | String | PK, FK |

### rule_sys_tag

| Column | Type | Keys |
| --- | --- | --- |
| sys_tag | String | PK |
| rule_key | String | PK, FK |

### rule

| Column | Type | Keys |
| --- | --- | --- |
| key | String | PK |
| created_at | Instant |  |
| gap_description | String |  |
| html_desc | String |  |
| html_note | String |  |
| is_external | Boolean |  |
| is_template | Boolean |  |
| lang | String |  |
| lang_name | String |  |
| name | String |  |
| repo | String |  |
| scope | String |  |
| severity | String |  |
| status | String |  |
| type | String |  |
| updated_at | Instant |  |

### project

| Column | Type | Keys |
| --- | --- | --- |
| key | String | PK |
| last_analysis_date | Instant |  |
| name | String |  |
| qualifier | String |  |
| revision | String |  |
| visibility | String |  |

### measures_component

| Column | Type | Keys |
| --- | --- | --- |
| component_key | String | PK, FK |
| metric_key | String | PK, FK |
| best_value | Unknown |  |
| period_best_value | Unknown |  |
| period_index | Unknown |  |
| period_value | Unknown |  |
| value | Unknown |  |

### project_link

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| project_key | String | PK, FK |
| name | String |  |
| type | String |  |
| url | String |  |

### issue_comment

| Column | Type | Keys |
| --- | --- | --- |
| key | String | PK |
| issue_key | String | PK, FK |
| login | String | FK |
| created_at | Instant |  |
| html_text | String |  |
| markdown | String |  |
| updatable | Boolean |  |

### issue_flow_location

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| issue_key | String | PK, FK |
| component | String |  |
| end_line | Int |  |
| end_offset | Int |  |
| msg | String |  |
| start_line | Int |  |
| start_offset | Int |  |

### issue_tag

| Column | Type | Keys |
| --- | --- | --- |
| tags | String | PK |
| issue_key | String | PK, FK |

### issue

| Column | Type | Keys |
| --- | --- | --- |
| key | String | PK |
| project | String | PK, FK |
| rule | String | PK, FK |
| author | String |  |
| component | String |  |
| creation_date | Instant |  |
| debt | String |  |
| effort | String |  |
| end_line | Int |  |
| end_offset | Int |  |
| hash | String |  |
| line | Int |  |
| message | String |  |
| resolution | String |  |
| scope | String |  |
| severity | String |  |
| start_line | Int |  |
| start_offset | Int |  |
| status | String |  |
| type | String |  |
| update_date | Instant |  |

### groups

| Column | Type | Keys |
| --- | --- | --- |
| name | String | PK |
| defaults | Boolean |  |
| description | String |  |
| managed | Unknown |  |
| members_count | Int |  |

### user_group

| Column | Type | Keys |
| --- | --- | --- |
| group_name | Unknown | PK, FK |
| users_login | String | PK, FK |

### user_scm_account

| Column | Type | Keys |
| --- | --- | --- |
| scm_account | Unknown | PK |
| users_login | String | PK, FK |

### users

| Column | Type | Keys |
| --- | --- | --- |
| login | String | PK |
| active | Boolean |  |
| avatar | Unknown |  |
| email | Unknown |  |
| external_identity | String |  |
| external_provider | String |  |
| last_connection_date | Instant |  |
| local | Boolean |  |
| managed | Unknown |  |
| name | String |  |
| sonar_lint_last_connection_date | Unknown |  |
| tokens_count | Int |  |

### component_tag

| Column | Type | Keys |
| --- | --- | --- |
| tags | String | PK |
| component_key | String | PK, FK |

### component

| Column | Type | Keys |
| --- | --- | --- |
| key | String | PK |
| project | String | FK |
| analysis_date | Instant |  |
| leak_period_date | Instant |  |
| name | String |  |
| qualifier | String |  |
| version | String |  |
| visibility | String |  |

### metric

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| key | String | PK |
| custom | Boolean |  |
| description | String |  |
| direction | Int |  |
| domain | String |  |
| hidden | Boolean |  |
| name | String |  |
| qualitative | Boolean |  |
| type | String |  |

### project_branch

| Column | Type | Keys |
| --- | --- | --- |
| name | String | PK |
| project_key | String | PK, FK |
| analysis_date | Instant |  |
| excluded_from_purge | Boolean |  |
| is_main | Boolean |  |
| quality_gate_status | String |  |
| type | String |  |

### project_pull_request

| Column | Type | Keys |
| --- | --- | --- |
| key | String | PK |
| project_key | String | PK, FK |
| analysis_date | Instant |  |
| base | String |  |
| branch | String |  |
| bugs | Int |  |
| code_smells | Int |  |
| quality_gate_status | String |  |
| target | String |  |
| title | String |  |
| url | String |  |
| vulnerabilities | Int |  |

### measures_component_tree

| Column | Type | Keys |
| --- | --- | --- |
| key | Unknown | PK |
| metric_key | String | PK, FK |
| base_component_key | String | FK |
| best_value | Unknown |  |
| name | Unknown |  |
| path | Unknown |  |
| period_best_value | Unknown |  |
| period_index | Unknown |  |
| period_value | Unknown |  |
| qualifier | Unknown |  |
| value | Unknown |  |

## Relationships

- project_analyse_event(project_analyse_key) → project_analyse(key)
- project_analyse(project_key) → project(key)
- rule_param(rule_key) → rule(key)
- rule_tag(rule_key) → rule(key)
- rule_sys_tag(rule_key) → rule(key)
- measures_component(metric_key) → metric(key)
- measures_component(component_key) → component(key)
- project_link(project_key) → project(key)
- issue_comment(login) → users(login)
- issue_comment(issue_key) → issue(key)
- issue_flow_location(issue_key) → issue(key)
- issue_tag(issue_key) → issue(key)
- issue(rule) → rule(key)
- issue(project) → project(key)
- user_group(group_name) → groups(name)
- user_group(users_login) → users(login)
- user_scm_account(users_login) → users(login)
- component_tag(component_key) → component(key)
- component(project) → project(key)
- project_branch(project_key) → project(key)
- project_pull_request(project_key) → project(key)
- measures_component_tree(metric_key) → metric(key)
- measures_component_tree(base_component_key) → component(key)