Snyk

Explore the interactive ERD

Table & Field Reference

group_organization

Column	Type	Keys
`group_id`	Unknown	PK
`id`	Unknown	PKFK
`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	PKFK
`project_id`	Unknown	PKFK
`tags`	Unknown

project_environment

Column	Type	Keys
`index`	Unknown	PK
`organization_id`	Unknown	PKFK
`project_id`	Unknown	PKFK
`environment`	Unknown

project_business_criticality

Column	Type	Keys
`index`	Unknown	PK
`organization_id`	Unknown	PKFK
`project_id`	Unknown	PKFK
`business_criticality`	Unknown

project_life_cycle

Column	Type	Keys
`index`	Unknown	PK
`organization_id`	Unknown	PKFK
`project_id`	Unknown	PKFK
`lifecycle`	Unknown

project_ignored_dependency

Column	Type	Keys
`index`	Unknown	PK
`organization_id`	Unknown	PKFK
`project_id`	Unknown	PKFK
`ignored_dependency`	Unknown

project_pull_request_assignee

Column	Type	Keys
`index`	Unknown	PK
`organization_id`	Unknown	PKFK
`project_id`	Unknown	PKFK
`pull_request_assignee`	Unknown

project

Column	Type	Keys
`id`	Unknown	PK
`organization_id`	Unknown	PKFK
`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	PKFK
`email`	Unknown
`name`	Unknown
`role`	Unknown
`username`	Unknown

jira_issue

Column	Type	Keys
`id`	Unknown	PK
`organization_id`	Unknown	PKFK
`project_id`	Unknown	PKFK
`key`	Unknown

issue_class

Column	Type	Keys
`id`	Unknown	PK
`issue_id`	Unknown	PKFK
`organization_id`	Unknown	PKFK
`source`	Unknown
`type`	Unknown

issue_coordinate_remedy

Column	Type	Keys
`index`	Unknown	PK
`issue_coordinate_index`	Unknown	PKFK
`issue_id`	Unknown	PKFK
`organization_id`	Unknown	PKFK
`correlation_id`	Unknown
`description`	Unknown
`schema_version`	Unknown
`type`	Unknown

issue_coordinate_representation

Column	Type	Keys
`index`	Unknown	PK
`issue_coordinate_index`	Unknown	PKFK
`issue_id`	Unknown	PKFK
`organization_id`	Unknown	PKFK
`package_name`	Unknown
`package_version`	Unknown

issue_coordinate

Column	Type	Keys
`index`	Unknown	PK
`issue_id`	Unknown	PKFK
`organization_id`	Unknown	PKFK
`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	PKFK
`organization_id`	Unknown	PKFK
`source`	Unknown
`type`	Unknown
`updated_at`	Unknown

issue_risk_factor

Column	Type	Keys
`index`	Unknown	PK
`issue_id`	Unknown	PKFK
`organization_id`	Unknown	PKFK
`name`	Unknown
`updated_at`	Unknown
`value`	Unknown

issue_test_execution

Column	Type	Keys
`id`	Unknown	PK
`issue_id`	Unknown	PKFK
`organization_id`	Unknown	PKFK
`type`	Unknown

issue

Column	Type	Keys
`id`	Unknown	PK
`organization_id`	Unknown	PKFK
`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	PKFK
`organization_id`	Unknown	PKFK
`license`	Unknown
`title`	Unknown

dependency_with_issue

Column	Type	Keys
`index`	Unknown	PK
`dependency_id`	Unknown	PKFK
`organization_id`	Unknown	PKFK
`dependencies_with_issue`	Unknown

dependency_project

Column	Type	Keys
`id`	Unknown	PK
`dependency_id`	Unknown	PKFK
`organization_id`	Unknown	PKFK
`name`	Unknown

dependency_copyright

Column	Type	Keys
`index`	Unknown	PK
`dependency_id`	Unknown	PKFK
`organization_id`	Unknown	PKFK
`copyright`	Unknown

dependency

Column	Type	Keys
`id`	Unknown	PK
`organization_id`	Unknown	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`aggregated_issue_id`	Unknown	PKFK
`format`	Unknown
`level`	Unknown

aggregated_issue_exploit_detail

Column	Type	Keys
`index`	Unknown	PK
`aggregated_issue_id`	Unknown	PKFK
`sources`	Json

aggregated_issue_patch

Column	Type	Keys
`id`	Unknown	PK
`aggregated_issue_id`	Unknown	PKFK
`comments`	Json
`modification_time`	Instant
`urls`	Json
`version`	Unknown

aggregated_issue_priority_factor

Column	Type	Keys
`index`	Unknown	PK
`aggregated_issue_id`	Unknown	PKFK
`description`	Unknown
`name`	Unknown

aggregated_issue_introduced_through

Column	Type	Keys
`index`	Unknown	PK
`aggregated_issue_id`	Unknown	PKFK
`data`	Unknown
`kind`	Unknown

aggregated_issue_ignore_reason

Column	Type	Keys
`index`	Unknown	PK
`aggregated_issue_id`	Unknown	PKFK
`expires`	Unknown
`reason`	Unknown
`source`	Unknown

aggregated_issue_pkg_info

Column	Type	Keys
`index`	Unknown	PK
`aggregated_issue_id`	Unknown	PKFK
`pkg_info`	Unknown	FK

aggregated_issue

Column	Type	Keys
`id`	Unknown	PK
`organization_id`	Unknown	PKFK
`project_id`	Unknown	PKFK
`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	PKFK
`created_at`	Unknown
`display_name`	Unknown
`integration_id`	Unknown
`integration_type`	Unknown
`is_private`	Unknown
`url`	Unknown

license_dependency

Column	Type	Keys
`id`	Unknown	PKFK
`license_id`	Unknown	PKFK
`organization_id`	Unknown	PKFK
`package_manager`	Unknown

license_project

Column	Type	Keys
`id`	Unknown	PK
`license_id`	Unknown	PKFK
`organization_id`	Unknown	PKFK
`name`	Unknown

license

Column	Type	Keys
`id`	Unknown	PK
`organization_id`	Unknown	PKFK
`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	PKFK
`email`	Unknown
`group_role`	Unknown
`name`	Unknown
`username`	Unknown