# Snyk schema ERD

Table and field reference for the Fivetran Snyk connector.

## Table & Field Reference

### group_organization

| Column | Type | Keys |
| --- | --- | --- |
| group_id | Unknown | PK |
| id | Unknown | PK, FK |
| created_at | Unknown |  |
| url | Unknown |  |

### group_role

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| organization_group_id | Unknown | PK |
| created_at | Unknown |  |
| description | Unknown |  |
| markdown_parsed | Unknown |  |
| modified_at | Unknown |  |
| public_id | Unknown |  |

### project_tag

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| organization_id | Unknown | PK, FK |
| project_id | Unknown | PK, FK |
| tags | Unknown |  |

### project_environment

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| organization_id | Unknown | PK, FK |
| project_id | Unknown | PK, FK |
| environment | Unknown |  |

### project_business_criticality

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| organization_id | Unknown | PK, FK |
| project_id | Unknown | PK, FK |
| business_criticality | Unknown |  |

### project_life_cycle

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| organization_id | Unknown | PK, FK |
| project_id | Unknown | PK, FK |
| lifecycle | Unknown |  |

### project_ignored_dependency

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| organization_id | Unknown | PK, FK |
| project_id | Unknown | PK, FK |
| ignored_dependency | Unknown |  |

### project_pull_request_assignee

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| organization_id | Unknown | PK, FK |
| project_id | Unknown | PK, FK |
| pull_request_assignee | Unknown |  |

### project

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| organization_id | Unknown | PK, FK |
| target_id | Unknown | FK |
| build_args_root_workspace | Unknown |  |
| cli_monitored_at | Unknown |  |
| created | Unknown |  |
| importer_id | Unknown |  |
| latest_dependency_total | Unknown |  |
| latest_dependency_total_updated_at | Unknown |  |
| meta_latest_issue_counts_critical | Unknown |  |
| meta_latest_issue_counts_high | Unknown |  |
| meta_latest_issue_counts_low | Unknown |  |
| meta_latest_issue_counts_medium | Unknown |  |
| meta_latest_issue_counts_updated_at | Unknown |  |
| name | Unknown |  |
| origin | Unknown |  |
| owner_id | Unknown |  |
| read_only | Unknown |  |
| setting_auto_dependency_upgrade_is_enabled | Unknown |  |
| setting_auto_dependency_upgrade_is_major_upgrade_enabled | Unknown |  |
| setting_auto_dependency_upgrade_limit | Unknown |  |
| setting_auto_dependency_upgrade_minimum_age | Unknown |  |
| setting_auto_remediation_pr_is_backlog_prs_enabled | Unknown |  |
| setting_auto_remediation_pr_is_fresh_prs_enabled | Unknown |  |
| setting_auto_remediation_pr_is_patch_remediation_enabled | Unknown |  |
| setting_manual_remediation_pr_is_patch_remediation_enabled | Unknown |  |
| setting_pull_request_assignment_is_enabled | Unknown |  |
| setting_pull_request_assignment_type | Unknown |  |
| setting_pull_request_fail_only_for_issues_with_fix | Unknown |  |
| setting_pull_request_policy | Unknown |  |
| setting_pull_request_severity_threshold | Unknown |  |
| setting_recurring_test_frequency | Unknown |  |
| status | Unknown |  |
| target_file | Unknown |  |
| target_reference | Unknown |  |
| target_runtime | Unknown |  |
| type | Unknown |  |

### member

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| organization_id | Unknown | PK, FK |
| email | Unknown |  |
| name | Unknown |  |
| role | Unknown |  |
| username | Unknown |  |

### jira_issue

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| organization_id | Unknown | PK, FK |
| project_id | Unknown | PK, FK |
| key | Unknown |  |

### issue_class

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| issue_id | Unknown | PK, FK |
| organization_id | Unknown | PK, FK |
| source | Unknown |  |
| type | Unknown |  |

### issue_coordinate_remedy

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| issue_coordinate_index | Unknown | PK, FK |
| issue_id | Unknown | PK, FK |
| organization_id | Unknown | PK, FK |
| correlation_id | Unknown |  |
| description | Unknown |  |
| schema_version | Unknown |  |
| type | Unknown |  |

### issue_coordinate_representation

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| issue_coordinate_index | Unknown | PK, FK |
| issue_id | Unknown | PK, FK |
| organization_id | Unknown | PK, FK |
| package_name | Unknown |  |
| package_version | Unknown |  |

### issue_coordinate

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| issue_id | Unknown | PK, FK |
| organization_id | Unknown | PK, FK |
| is_fixable_manually | Unknown |  |
| is_fixable_snyk | Unknown |  |
| is_fixable_upstream | Unknown |  |
| is_patchable | Unknown |  |
| is_pinnable | Unknown |  |
| is_upgradeable | Unknown |  |
| reachability | Unknown |  |

### issue_problem

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| issue_id | Unknown | PK, FK |
| organization_id | Unknown | PK, FK |
| source | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |

### issue_risk_factor

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| issue_id | Unknown | PK, FK |
| organization_id | Unknown | PK, FK |
| name | Unknown |  |
| updated_at | Unknown |  |
| value | Unknown |  |

### issue_test_execution

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| issue_id | Unknown | PK, FK |
| organization_id | Unknown | PK, FK |
| type | Unknown |  |

### issue

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| organization_id | Unknown | PK, FK |
| scan_item_id | Unknown | FK |
| created_at | Unknown |  |
| description | Unknown |  |
| effective_severity_level | Unknown |  |
| ignore_id | Unknown |  |
| ignored | Unknown |  |
| key | Unknown |  |
| resolution_details | Unknown |  |
| resolution_resolved_at | Unknown |  |
| resolution_type | Unknown |  |
| risk_score_model | Unknown |  |
| risk_score_value | Unknown |  |
| status | Unknown |  |
| title | Unknown |  |
| tool | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |

### dependency_license

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| dependency_id | Unknown | PK, FK |
| organization_id | Unknown | PK, FK |
| license | Unknown |  |
| title | Unknown |  |

### dependency_with_issue

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| dependency_id | Unknown | PK, FK |
| organization_id | Unknown | PK, FK |
| dependencies_with_issue | Unknown |  |

### dependency_project

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| dependency_id | Unknown | PK, FK |
| organization_id | Unknown | PK, FK |
| name | Unknown |  |

### dependency_copyright

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| dependency_id | Unknown | PK, FK |
| organization_id | Unknown | PK, FK |
| copyright | Unknown |  |

### dependency

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| organization_id | Unknown | PK, FK |
| deprecated_version | Json |  |
| first_published_date | Unknown |  |
| is_deprecated | Unknown |  |
| issues_critical | Unknown |  |
| issues_high | Unknown |  |
| issues_low | Unknown |  |
| issues_medium | Unknown |  |
| latest_version | Unknown |  |
| latest_version_published_date | Unknown |  |
| name | Unknown |  |
| type | Unknown |  |
| version | Unknown |  |

### collection

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| organization_id | Unknown | PK, FK |
| created_by_id | Unknown | FK |
| is_generated | Unknown |  |
| issues_critical_count | Unknown |  |
| issues_high_count | Unknown |  |
| issues_low_count | Unknown |  |
| issues_medium_count | Unknown |  |
| name | Unknown |  |
| projects_count | Unknown |  |

### aggregated_issue_severity

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| aggregated_issue_id | Unknown | PK, FK |
| assigner | Unknown |  |
| base_score | Unknown |  |
| cvss_version | Unknown |  |
| modification_time | Instant |  |
| severity | Unknown |  |
| vector | Unknown |  |

### aggregated_issue_exploit_detail_maturity_level

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| aggregated_issue_exploit_detail_index | Unknown | PK, FK |
| aggregated_issue_id | Unknown | PK, FK |
| format | Unknown |  |
| level | Unknown |  |

### aggregated_issue_exploit_detail

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| aggregated_issue_id | Unknown | PK, FK |
| sources | Json |  |

### aggregated_issue_patch

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| aggregated_issue_id | Unknown | PK, FK |
| comments | Json |  |
| modification_time | Instant |  |
| urls | Json |  |
| version | Unknown |  |

### aggregated_issue_priority_factor

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| aggregated_issue_id | Unknown | PK, FK |
| description | Unknown |  |
| name | Unknown |  |

### aggregated_issue_introduced_through

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| aggregated_issue_id | Unknown | PK, FK |
| data | Unknown |  |
| kind | Unknown |  |

### aggregated_issue_ignore_reason

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| aggregated_issue_id | Unknown | PK, FK |
| expires | Unknown |  |
| reason | Unknown |  |
| source | Unknown |  |

### aggregated_issue_pkg_info

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| aggregated_issue_id | Unknown | PK, FK |
| pkg_info | Unknown | FK |

### aggregated_issue

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| organization_id | Unknown | PK, FK |
| project_id | Unknown | PK, FK |
| credit | Json |  |
| cve | Json |  |
| cvss_score | Unknown |  |
| cwe | Json |  |
| disclosure_time | Unknown |  |
| exploit_maturity | Unknown |  |
| fix_info_fixed_in | Json |  |
| fix_info_is_fixable | Unknown |  |
| fix_info_is_partially_fixable | Unknown |  |
| fix_info_is_patchable | Unknown |  |
| fix_info_is_pinnable | Unknown |  |
| fix_info_is_upgradable | Unknown |  |
| ghsa | Json |  |
| is_ignored | Unknown |  |
| is_malicious_package | Unknown |  |
| is_patched | Unknown |  |
| issue_data_description | Unknown |  |
| issue_type | Unknown |  |
| languages | Unknown |  |
| links_path | Unknown |  |
| nearest_fixed_in_version | Unknown |  |
| original_severity | Unknown |  |
| osvdb | Json |  |
| path | Unknown |  |
| pkg_name | Unknown |  |
| pkg_versions | Json |  |
| priority_score | Unknown |  |
| publication_time | Unknown |  |
| semver_unaffected | Unknown |  |
| semver_vulnerable | Json |  |
| severity | Unknown |  |
| title | Unknown |  |
| url | Unknown |  |
| violated_policy_public_id | Unknown |  |

### target

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| organization_id | Unknown | PK, FK |
| created_at | Unknown |  |
| display_name | Unknown |  |
| integration_id | Unknown |  |
| integration_type | Unknown |  |
| is_private | Unknown |  |
| url | Unknown |  |

### license_dependency

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| license_id | Unknown | PK, FK |
| organization_id | Unknown | PK, FK |
| package_manager | Unknown |  |

### license_project

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| license_id | Unknown | PK, FK |
| organization_id | Unknown | PK, FK |
| name | Unknown |  |

### license

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| organization_id | Unknown | PK, FK |
| instruction | Unknown |  |
| severity | Unknown |  |

### organization

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| access_requests_enabled | Unknown |  |
| created_at | Unknown |  |
| group_id | Unknown |  |
| is_personal | Unknown |  |
| member_role_id | Unknown |  |
| member_role_name | Unknown |  |
| member_role_type | Unknown |  |
| name | Unknown |  |
| slug | Unknown |  |
| updated_at | Unknown |  |

### group_tag

| Column | Type | Keys |
| --- | --- | --- |
| key | Unknown | PK |
| organization_group_id | Unknown | PK |
| value | Unknown | PK |

### group_member

| Column | Type | Keys |
| --- | --- | --- |
| group_id | Unknown | PK |
| id | Unknown | PK, FK |
| email | Unknown |  |
| group_role | Unknown |  |
| name | Unknown |  |
| username | Unknown |  |

## Relationships

- group_organization(id) → organization(id)
- project_tag(project_id) → project(id)
- project_tag(organization_id) → project(organization_id)
- project_environment(project_id) → project(id)
- project_environment(organization_id) → project(organization_id)
- project_business_criticality(project_id) → project(id)
- project_business_criticality(organization_id) → project(organization_id)
- project_life_cycle(project_id) → project(id)
- project_life_cycle(organization_id) → project(organization_id)
- project_ignored_dependency(project_id) → project(id)
- project_ignored_dependency(organization_id) → project(organization_id)
- project_pull_request_assignee(project_id) → project(id)
- project_pull_request_assignee(organization_id) → project(organization_id)
- project(target_id) → target(id)
- project(organization_id) → organization(id)
- member(organization_id) → organization(id)
- jira_issue(organization_id) → project(organization_id)
- jira_issue(project_id) → project(id)
- issue_class(issue_id) → issue(id)
- issue_class(organization_id) → issue(organization_id)
- issue_coordinate_remedy(issue_coordinate_index) → issue_coordinate(index)
- issue_coordinate_remedy(issue_id) → issue_coordinate(issue_id)
- issue_coordinate_remedy(organization_id) → issue_coordinate(organization_id)
- issue_coordinate_representation(issue_coordinate_index) → issue_coordinate(index)
- issue_coordinate_representation(issue_id) → issue_coordinate(issue_id)
- issue_coordinate_representation(organization_id) → issue_coordinate(organization_id)
- issue_coordinate(issue_id) → issue(id)
- issue_coordinate(organization_id) → issue(organization_id)
- issue_problem(issue_id) → issue(id)
- issue_problem(organization_id) → issue(organization_id)
- issue_risk_factor(issue_id) → issue(id)
- issue_risk_factor(organization_id) → issue(organization_id)
- issue_test_execution(issue_id) → issue(id)
- issue_test_execution(organization_id) → issue(organization_id)
- issue(scan_item_id) → project(id)
- issue(organization_id) → organization(id)
- dependency_license(dependency_id) → dependency(id)
- dependency_license(organization_id) → dependency(organization_id)
- dependency_with_issue(dependency_id) → dependency(id)
- dependency_with_issue(organization_id) → dependency(organization_id)
- dependency_project(dependency_id) → dependency(id)
- dependency_project(organization_id) → dependency(organization_id)
- dependency_copyright(dependency_id) → dependency(id)
- dependency_copyright(organization_id) → dependency(organization_id)
- dependency(organization_id) → organization(id)
- collection(created_by_id) → member(id)
- collection(organization_id) → organization(id)
- aggregated_issue_severity(aggregated_issue_id) → aggregated_issue(id)
- aggregated_issue_exploit_detail_maturity_level(aggregated_issue_exploit_detail_index) → aggregated_issue_exploit_detail(index)
- aggregated_issue_exploit_detail_maturity_level(aggregated_issue_id) → aggregated_issue(id)
- aggregated_issue_exploit_detail(aggregated_issue_id) → aggregated_issue(id)
- aggregated_issue_patch(aggregated_issue_id) → aggregated_issue(id)
- aggregated_issue_priority_factor(aggregated_issue_id) → aggregated_issue(id)
- aggregated_issue_introduced_through(aggregated_issue_id) → aggregated_issue(id)
- aggregated_issue_ignore_reason(aggregated_issue_id) → aggregated_issue(id)
- aggregated_issue_pkg_info(pkg_info) → dependency_with_issue(dependencies_with_issue)
- aggregated_issue_pkg_info(aggregated_issue_id) → aggregated_issue(id)
- aggregated_issue(organization_id) → project(organization_id)
- aggregated_issue(project_id) → project(id)
- target(organization_id) → organization(id)
- license_dependency(id) → dependency(id)
- license_dependency(license_id) → license(id)
- license_dependency(organization_id) → license(organization_id)
- license_project(license_id) → license(id)
- license_project(organization_id) → license(organization_id)
- license(organization_id) → organization(id)
- group_member(id) → member(id)