Fivetran documentation

Search the docs

/

SonarQube

Explore the interactive ERD

Table & Field Reference

project_analyse_event

Column	Type	Keys
`key`	String	PK
`project_analyse_key`	String	PKFK
`category`	String
`description`	String
`name`	String

project_analyse

Column	Type	Keys
`key`	String	PK
`project_key`	String	PKFK
`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	PKFK
`default_value`	String
`description`	String
`html_desc`	String
`type`	String

rule_tag

Column	Type	Keys
`tags`	String	PK
`rule_key`	String	PKFK

rule_sys_tag

Column	Type	Keys
`sys_tag`	String	PK
`rule_key`	String	PKFK

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	PKFK
`metric_key`	String	PKFK
`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	PKFK
`name`	String
`type`	String
`url`	String

issue_comment

Column	Type	Keys
`key`	String	PK
`issue_key`	String	PKFK
`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	PKFK
`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	PKFK

issue

Column	Type	Keys
`key`	String	PK
`project`	String	PKFK
`rule`	String	PKFK
`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	PKFK
`users_login`	String	PKFK

user_scm_account

Column	Type	Keys
`scm_account`	Unknown	PK
`users_login`	String	PKFK

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	PKFK

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	PKFK
`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	PKFK
`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	PKFK
`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