# Prisma Cloud schema ERD

Table and field reference for the Fivetran Prisma Cloud connector.

## Table & Field Reference

### host_binary

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| host_id | Unknown | PK, FK |
| cve_count | Unknown |  |
| file_mode | Unknown |  |
| md_5 | Unknown |  |
| missing_pkg | Unknown |  |
| name | Unknown |  |
| path | Unknown |  |
| services | Unknown |  |
| version | Unknown |  |

### host_startup_binary

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| host_id | Unknown | PK, FK |
| altered | Unknown |  |
| cve_count | Unknown |  |
| deps | Json |  |
| file_mode | Unknown |  |
| function_layer | Unknown |  |
| md_5 | Unknown |  |
| missing_pkg | Unknown |  |
| name | Unknown |  |
| path | Unknown |  |
| pkg_root_dir | Unknown |  |
| services | Json |  |
| version | Unknown |  |

### host_package_pkgs

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| host_package_host_id | Unknown | PK, FK |
| host_package_index | Unknown | PK, FK |
| binary_idx | Json |  |
| binary_pkgs | Json |  |
| cve_count | Unknown |  |
| layer_time | Unknown |  |
| license | Unknown |  |
| name | Unknown |  |
| origin_package_name | Unknown |  |
| purl | Unknown |  |
| version | Unknown |  |

### host_package

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| host_id | Unknown | PK, FK |
| pkgs_type | Unknown |  |

### host_file

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| host_id | Unknown | PK, FK |
| md_5 | Unknown |  |
| path | Unknown |  |
| sha_1 | Unknown |  |
| sha_256 | Unknown |  |

### host_application

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| host_id | Unknown | PK, FK |
| installed_from_package | Unknown |  |
| known_vulnerabilities | Unknown |  |
| layer_time | Unknown |  |
| name | Unknown |  |
| origin_package_name | Unknown |  |
| path | Unknown |  |
| service | Unknown |  |
| version | Unknown |  |

### host_found_secret

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| host_id | Unknown | PK, FK |
| location_in_file | Unknown |  |
| modified_time | Unknown |  |
| path | Unknown |  |
| secret_id | Unknown |  |
| snippet | Unknown |  |
| type | Json |  |

### host_history_vulnerability_exploit

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| host_history_index | Unknown | PK, FK |
| host_history_vulnerability_index | Unknown | PK, FK |
| host_id | Unknown | PK, FK |
| kind | Json |  |
| link | Unknown |  |
| source | Json |  |

### host_history_vulnerability_tag_info

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| host_history_index | Unknown | PK, FK |
| host_history_vulnerability_index | Unknown | PK, FK |
| host_id | Unknown | PK, FK |
| color | Unknown |  |
| comment | Unknown |  |
| name | Unknown |  |

### host_history_vulnerability

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| host_history_index | Unknown | PK, FK |
| host_id | Unknown | PK, FK |
| applicable_rule | Unknown |  |
| binary_pkgs | Json |  |
| cause | Unknown |  |
| cri | Unknown |  |
| cve | Unknown |  |
| cvss | Unknown |  |
| description | Unknown |  |
| discovered | Unknown |  |
| exploit | Json |  |
| fix_date | Unknown |  |
| function_layer | Unknown |  |
| layer_time | Unknown |  |
| link | Unknown |  |
| package_name | Unknown |  |
| package_type | Json |  |
| package_version | Unknown |  |
| published | Unknown |  |
| risk_factor | Json |  |
| secret_id | Unknown |  |
| secret_location_in_file | Unknown |  |
| secret_modified_time | Unknown |  |
| secret_path | Unknown |  |
| secret_snippet | Unknown |  |
| secret_type | Json |  |
| severity | Unknown |  |
| status | Unknown |  |
| templates | Json |  |
| text | Unknown |  |
| title | Unknown |  |
| twistlock | Unknown |  |
| type | Unknown |  |
| vec_str | Unknown |  |
| violation_id | Unknown |  |
| wildfire_malware_md_5 | Unknown |  |
| wildfire_malware_path | Unknown |  |
| wildfire_malware_verdict | Unknown |  |

### host_history

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| host_id | Unknown | PK, FK |
| base_layer | Unknown |  |
| created | Unknown |  |
| empty_layer | Unknown |  |
| id | Unknown |  |
| instruction | Unknown |  |
| size_bytes | Unknown |  |
| tags | Json |  |

### host_compliance_issue_exploit

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| host_compliance_issue_index | Unknown | PK, FK |
| host_id | Unknown | PK, FK |
| kind | Json |  |
| link | Unknown |  |
| source | Json |  |

### host_compliance_issue_vulnerability_tag_info

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| host_compliance_issue_index | Unknown | PK, FK |
| host_id | Unknown | PK, FK |
| color | Unknown |  |
| comment | Unknown |  |
| name | Unknown |  |

### host_compliance_issue

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| host_id | Unknown | PK, FK |
| cause | Unknown |  |
| cri | Unknown |  |
| cve | Unknown |  |
| cvss | Unknown |  |
| description | Unknown |  |
| discovered | Unknown |  |
| exploit | Json |  |
| fix_date | Unknown |  |
| function_layer | Unknown |  |
| layer_time | Unknown |  |
| link | Unknown |  |
| package_name | Unknown |  |
| package_type | Json |  |
| package_version | Unknown |  |
| published | Unknown |  |
| risk_factor | Json |  |
| secret_id | Unknown |  |
| secret_location_in_file | Unknown |  |
| secret_modified_time | Unknown |  |
| secret_path | Unknown |  |
| secret_snippet | Unknown |  |
| secret_type | Json |  |
| severity | Unknown |  |
| status | Unknown |  |
| templates | Unknown |  |
| text | Unknown |  |
| title | Unknown |  |
| twistlock | Unknown |  |
| type | Unknown |  |
| vec_str | Unknown |  |
| violation_id | Unknown |  |
| wildfire_malware_md_5 | Unknown |  |
| wildfire_malware_path | Unknown |  |
| wildfire_malware_verdict | Unknown |  |

### host_all_compliance_exploit

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| host_all_compliance_index | Unknown | PK, FK |
| host_id | Unknown | PK, FK |
| kind | Json |  |
| link | Unknown |  |
| source | Json |  |

### host_all_compliance_vulnerability_tag_info

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| host_all_compliance_index | Unknown | PK, FK |
| host_id | Unknown | PK, FK |
| color | Unknown |  |
| comment | Unknown |  |
| name | Unknown |  |

### host_all_compliance

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| host_id | Unknown | PK, FK |
| applicable_rules | Json |  |
| binary_pkgs | Json |  |
| block | Unknown |  |
| cause | Unknown |  |
| cri | Unknown |  |
| custom | Unknown |  |
| cve | Unknown |  |
| cvss | Unknown |  |
| description | Unknown |  |
| discovered | Unknown |  |
| exploit | Json |  |
| fix_date | Unknown |  |
| fix_link | Unknown |  |
| function_layer | Unknown |  |
| grace_period_days | Unknown |  |
| layer_time | Unknown |  |
| link | Unknown |  |
| package_name | Unknown |  |
| package_type | Json |  |
| package_version | Unknown |  |
| published | Unknown |  |
| risk_factors | Json |  |
| secret_id | Unknown |  |
| secret_location_in_file | Unknown |  |
| secret_modified_time | Unknown |  |
| secret_path | Unknown |  |
| secret_snippet | Unknown |  |
| secret_type | Json |  |
| severity | Unknown |  |
| status | Unknown |  |
| templates | Json |  |
| text | Unknown |  |
| title | Unknown |  |
| twistlock | Unknown |  |
| type | Json |  |
| vec_str | Unknown |  |
| violation_id | Unknown |  |
| wildfire_malware_md_5 | Unknown |  |
| wildfire_malware_path | Unknown |  |
| wildfire_malware_verdict | Unknown |  |

### host_vulnerability_exploit

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| host_id | Unknown | PK, FK |
| host_vulnerability_index | Unknown | PK, FK |
| kind | Json |  |
| link | Unknown |  |
| source | Json |  |

### host_vulnerability_tag_info

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| host_id | Unknown | PK, FK |
| host_vulnerability_index | Unknown | PK, FK |
| color | Unknown |  |
| comment | Unknown |  |
| name | Unknown |  |

### host_vulnerability

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| host_id | Unknown | PK, FK |
| applicable_rule | Json |  |
| binary_pkgs | Json |  |
| cause | Unknown |  |
| cri | Unknown |  |
| cve | Unknown |  |
| cvss | Unknown |  |
| description | Unknown |  |
| discovered | Unknown |  |
| exploit | Json |  |
| fix_date | Unknown |  |
| function_layer | Unknown |  |
| layer_time | Unknown |  |
| link | Unknown |  |
| package_name | Unknown |  |
| package_type | Json |  |
| package_version | Unknown |  |
| published | Unknown |  |
| risk_factor | Json |  |
| secret_id | Unknown |  |
| secret_location_in_file | Unknown |  |
| secret_modified_time | Unknown |  |
| secret_path | Unknown |  |
| secret_snippet | Unknown |  |
| secret_type | Json |  |
| severity | Unknown |  |
| status | Unknown |  |
| templates | Json |  |
| text | Unknown |  |
| title | Unknown |  |
| twistlock | Unknown |  |
| type | Json |  |
| vec_str | Unknown |  |
| violation_id | Unknown |  |
| wildfire_malware_md_5 | Unknown |  |
| wildfire_malware_path | Unknown |  |
| wildfire_malware_verdict | Unknown |  |

### host_tag

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| host_id | Unknown | PK, FK |
| digest | Unknown |  |
| id | Unknown |  |
| registry | Unknown |  |
| repo | Unknown |  |
| tags | Unknown |  |

### host_device

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| host_id | Unknown | PK, FK |
| ip | Unknown |  |
| name | Unknown |  |

### host_instance

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| host_id | Unknown | PK, FK |
| host | Unknown |  |
| image | Unknown |  |
| modified | Unknown |  |
| registry | Unknown |  |
| repo | Unknown |  |
| tags | Unknown |  |

### host

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| agentless | Unknown |  |
| ais_uuid | Unknown |  |
| all_compliance_enabled | Unknown |  |
| app_embedded | Unknown |  |
| base_image | Unknown |  |
| cloud_metadata_account_id | Unknown |  |
| cloud_metadata_image | Unknown |  |
| cloud_metadata_name | Unknown |  |
| cloud_metadata_provider | Json |  |
| cloud_metadata_region | Unknown |  |
| cloud_metadata_resource_id | Unknown |  |
| cluster_type | Unknown |  |
| collections | Json |  |
| compliance_distribution_critical | Unknown |  |
| compliance_distribution_high | Unknown |  |
| compliance_distribution_low | Unknown |  |
| compliance_distribution_medium | Unknown |  |
| compliance_distribution_total | Unknown |  |
| compliance_issues_count | Unknown |  |
| compliance_risk_score | Unknown |  |
| compressed | Unknown |  |
| creation_time | Unknown |  |
| csa | Unknown |  |
| distro | Unknown |  |
| ecs_cluster_name | Unknown |  |
| err | Unknown |  |
| err_code | Unknown |  |
| firewall_protection_enabled | Unknown |  |
| firewall_protection_out_of_band_mode | Json |  |
| firewall_protection_supported | Unknown |  |
| first_scan_time | Unknown |  |
| host_runtime_enabled | Unknown |  |
| hostname | Unknown |  |
| hosts | Json |  |
| image_created | Unknown |  |
| installed_products_has_package_manager | Unknown |  |
| installed_products_os_distro | Unknown |  |
| is_arm_64 | Unknown |  |
| k_8_s_cluster_addr | Unknown |  |
| labels | Json |  |
| malware_analyzed_time | Unknown |  |
| missing_distro_vuln_coverage | Unknown |  |
| os_distro | Unknown |  |
| os_distro_release | Unknown |  |
| os_distro_version | Unknown |  |
| package_manager | Unknown |  |
| pull_duration | Unknown |  |
| push_time | Unknown |  |
| red_hat_non_rpm_image | Unknown |  |
| registry_namespace | Unknown |  |
| registry_type | Unknown |  |
| repo | Unknown |  |
| repo_digest | Unknown |  |
| repo_digests | Json |  |
| repo_id | Unknown |  |
| repo_registry | Unknown |  |
| repo_tag | Unknown |  |
| risk_factor | Json |  |
| scan_build_date | Unknown |  |
| scan_duration | Unknown |  |
| scan_id | Unknown |  |
| scan_time | Instant |  |
| scan_version | Unknown |  |
| secret_scan_metrics_failed_scans | Unknown |  |
| secret_scan_metrics_found_secrets | Unknown |  |
| secret_scan_metrics_scan_time | Unknown |  |
| secret_scan_metrics_scan_timeout | Unknown |  |
| secret_scan_metrics_scanned_file_size | Unknown |  |
| secret_scan_metrics_scanned_files | Unknown |  |
| secret_scan_metrics_total_bytes | Unknown |  |
| secret_scan_metrics_total_files | Unknown |  |
| secret_scan_metrics_total_time | Unknown |  |
| secret_scan_metrics_types_count | Json |  |
| secrets | Json |  |
| stopped | Unknown |  |
| top_layer | Unknown |  |
| trust_status | Unknown |  |
| twistlock_image | Unknown |  |
| type | Unknown |  |
| vulnerabilities_count | Unknown |  |
| vulnerability_distribution_critical | Unknown |  |
| vulnerability_distribution_high | Unknown |  |
| vulnerability_distribution_low | Unknown |  |
| vulnerability_distribution_medium | Unknown |  |
| vulnerability_distribution_total | Unknown |  |
| vulnerability_risk_score | Unknown |  |
| wild_fire_usage_bytes | Unknown |  |
| wild_fire_usage_queries | Unknown |  |
| wild_fire_usage_uploads | Unknown |  |

### image_binary

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| image_id | Unknown | PK, FK |
| cve_count | Unknown |  |
| file_mode | Unknown |  |
| md_5 | Unknown |  |
| missing_pkg | Unknown |  |
| name | Unknown |  |
| path | Unknown |  |
| version | Unknown |  |

### image_startup_binary

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| image_id | Unknown | PK, FK |
| cve_count | Unknown |  |
| file_mode | Unknown |  |
| md_5 | Unknown |  |
| name | Unknown |  |
| path | Unknown |  |

### image_package_pkgs

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| image_id | Unknown | PK, FK |
| image_package_index | Unknown | PK, FK |
| binary_idx | Json |  |
| binary_pkgs | Json |  |
| cve_count | Unknown |  |
| layer_time | Unknown |  |
| license | Unknown |  |
| name | Unknown |  |
| origin_package_name | Unknown |  |
| purl | Unknown |  |
| version | Unknown |  |

### image_package

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| image_id | Unknown | PK, FK |
| pkgs_type | Unknown |  |

### image_file

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| image_id | Unknown | PK, FK |
| md_5 | Unknown |  |
| path | Unknown |  |
| sha_1 | Unknown |  |
| sha_256 | Unknown |  |

### image_application

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| image_id | Unknown | PK, FK |
| installed_from_package | Unknown |  |
| known_vulnerabilities | Unknown |  |
| layer_time | Unknown |  |
| name | Unknown |  |
| origin_package_name | Unknown |  |
| path | Unknown |  |
| version | Unknown |  |

### image_found_secret

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| image_id | Unknown | PK, FK |
| location_in_file | Unknown |  |
| modified_time | Unknown |  |
| path | Unknown |  |
| secret_id | Unknown |  |
| snippet | Unknown |  |
| type | Json |  |

### image_history_vulnerability_exploit

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| image_history_index | Unknown | PK, FK |
| image_history_vulnerability_index | Unknown | PK, FK |
| image_id | Unknown | PK, FK |
| kind | Json |  |
| link | Unknown |  |
| source | Json |  |

### image_history_vulnerability_tag_info

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| image_history_index | Unknown | PK, FK |
| image_history_vulnerability_index | Unknown | PK, FK |
| image_id | Unknown | PK, FK |
| color | Unknown |  |
| comment | Unknown |  |
| name | Unknown |  |

### image_history_vulnerability

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| image_history_index | Unknown | PK, FK |
| image_id | Unknown | PK, FK |
| applicable_rule | Unknown |  |
| binary_pkgs | Json |  |
| cause | Unknown |  |
| cri | Unknown |  |
| cve | Unknown |  |
| cvss | Unknown |  |
| description | Unknown |  |
| discovered | Unknown |  |
| exploit | Json |  |
| fix_date | Unknown |  |
| function_layer | Unknown |  |
| layer_time | Unknown |  |
| link | Unknown |  |
| package_name | Unknown |  |
| package_type | Json |  |
| package_version | Unknown |  |
| published | Unknown |  |
| risk_factor | Json |  |
| secret_id | Unknown |  |
| secret_location_in_file | Unknown |  |
| secret_modified_time | Unknown |  |
| secret_path | Unknown |  |
| secret_snippet | Unknown |  |
| secret_type | Json |  |
| severity | Unknown |  |
| status | Unknown |  |
| templates | Json |  |
| text | Unknown |  |
| title | Unknown |  |
| twistlock | Unknown |  |
| type | Json |  |
| vec_str | Unknown |  |
| violation_id | Unknown |  |
| wildfire_malware_md_5 | Unknown |  |
| wildfire_malware_path | Unknown |  |
| wildfire_malware_verdict | Unknown |  |

### image_history

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| image_id | Unknown | PK, FK |
| created | Unknown |  |
| empty_layer | Unknown |  |
| id | Unknown |  |
| instruction | Unknown |  |

### image_compliance_issue_exploit

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| image_compliance_issue_index | Unknown | PK, FK |
| image_id | Unknown | PK, FK |
| kind | Json |  |
| link | Unknown |  |
| source | Json |  |

### image_compliance_issue_vulnerability_tag_info

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| image_compliance_issue_index | Unknown | PK, FK |
| image_id | Unknown | PK, FK |
| color | Unknown |  |
| comment | Unknown |  |
| name | Unknown |  |

### image_compliance_issue

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| image_id | Unknown | PK, FK |
| cause | Unknown |  |
| cri | Unknown |  |
| cve | Unknown |  |
| cvss | Unknown |  |
| description | Unknown |  |
| discovered | Unknown |  |
| exploit | Json |  |
| fix_date | Unknown |  |
| function_layer | Unknown |  |
| layer_time | Unknown |  |
| link | Unknown |  |
| package_name | Unknown |  |
| package_type | Json |  |
| package_version | Unknown |  |
| published | Unknown |  |
| risk_factors | Json |  |
| secret_id | Unknown |  |
| secret_location_in_file | Unknown |  |
| secret_modified_time | Unknown |  |
| secret_path | Unknown |  |
| secret_snippet | Unknown |  |
| secret_type | Json |  |
| severity | Unknown |  |
| status | Unknown |  |
| templates | Json |  |
| text | Unknown |  |
| title | Unknown |  |
| twistlock | Unknown |  |
| type | Json |  |
| vec_str | Unknown |  |
| violation_id | Unknown |  |
| wildfire_malware_md_5 | Unknown |  |
| wildfire_malware_path | Unknown |  |
| wildfire_malware_verdict | Unknown |  |

### image_all_compliance_exploit

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| image_all_compliance_index | Unknown | PK, FK |
| image_id | Unknown | PK, FK |
| kind | Json |  |
| link | Unknown |  |
| source | Json |  |

### image_all_compliance_vulnerability_tag_info

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| image_all_compliance_index | Unknown | PK, FK |
| image_id | Unknown | PK, FK |
| color | Unknown |  |
| comment | Unknown |  |
| name | Unknown |  |

### image_all_compliance

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| image_id | Unknown | PK, FK |
| applicable_rules | Json |  |
| binary_pkgs | Json |  |
| block | Unknown |  |
| cause | Unknown |  |
| cri | Unknown |  |
| custom | Unknown |  |
| cve | Unknown |  |
| cvss | Unknown |  |
| description | Unknown |  |
| discovered | Unknown |  |
| exploit | Json |  |
| fix_date | Unknown |  |
| fix_link | Unknown |  |
| function_layer | Unknown |  |
| grace_period_days | Unknown |  |
| layer_time | Unknown |  |
| link | Unknown |  |
| package_name | Unknown |  |
| package_type | Json |  |
| package_version | Unknown |  |
| published | Unknown |  |
| risk_factors | Json |  |
| secret_id | Unknown |  |
| secret_location_in_file | Unknown |  |
| secret_modified_time | Unknown |  |
| secret_path | Unknown |  |
| secret_snippet | Unknown |  |
| secret_type | Json |  |
| severity | Unknown |  |
| status | Unknown |  |
| templates | Json |  |
| text | Unknown |  |
| title | Unknown |  |
| twistlock | Unknown |  |
| type | Json |  |
| vec_str | Unknown |  |
| violation_id | Unknown |  |
| wildfire_malware_md_5 | Unknown |  |
| wildfire_malware_path | Unknown |  |
| wildfire_malware_verdict | Unknown |  |

### image_vulnerability_exploit

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| image_id | Unknown | PK, FK |
| image_vulnerability_index | Unknown | PK, FK |
| kind | Json |  |
| link | Unknown |  |
| source | Json |  |

### image_vulnerability_tag_info

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| image_id | Unknown | PK, FK |
| image_vulnerability_index | Unknown | PK, FK |
| color | Unknown |  |
| comment | Unknown |  |
| name | Unknown |  |

### image_vulnerability

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| image_id | Unknown | PK, FK |
| applicable_rule | Unknown |  |
| binary_pkgs | Json |  |
| cause | Unknown |  |
| cri | Unknown |  |
| cve | Unknown |  |
| cvss | Unknown |  |
| description | Unknown |  |
| discovered | Unknown |  |
| exploit | Json |  |
| fix_date | Unknown |  |
| function_layer | Unknown |  |
| layer_time | Unknown |  |
| link | Unknown |  |
| package_name | Unknown |  |
| package_type | Json |  |
| package_version | Unknown |  |
| published | Unknown |  |
| risk_factors | Json |  |
| secret_id | Unknown |  |
| secret_location_in_file | Unknown |  |
| secret_modified_time | Unknown |  |
| secret_path | Unknown |  |
| secret_snippet | Unknown |  |
| secret_type | Json |  |
| severity | Unknown |  |
| status | Unknown |  |
| templates | Json |  |
| text | Unknown |  |
| title | Unknown |  |
| twistlock | Unknown |  |
| type | Json |  |
| vec_str | Unknown |  |
| violation_id | Unknown |  |
| wildfire_malware_md_5 | Unknown |  |
| wildfire_malware_path | Unknown |  |
| wildfire_malware_verdict | Unknown |  |

### image_tag

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| image_id | Unknown | PK, FK |
| registry | Unknown |  |
| repo | Unknown |  |
| tags | Unknown |  |

### image_instance

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| image_id | Unknown | PK, FK |
| host | Unknown |  |
| image | Unknown |  |
| modified | Unknown |  |
| registry | Unknown |  |
| repo | Unknown |  |
| tags | Unknown |  |

### image

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| hostname | Unknown | FK |
| agentless | Unknown |  |
| ais_uuid | Unknown |  |
| app_embedded | Unknown |  |
| base_image | Unknown |  |
| cloud_metadata_account_id | Unknown |  |
| cloud_metadata_image | Unknown |  |
| cloud_metadata_name | Unknown |  |
| cloud_metadata_provider | Json |  |
| cloud_metadata_region | Unknown |  |
| cloud_metadata_resource_id | Unknown |  |
| cluster_type | Unknown |  |
| clusters | Json |  |
| collections | Json |  |
| compliance_distribution_critical | Unknown |  |
| compliance_distribution_high | Unknown |  |
| compliance_distribution_low | Unknown |  |
| compliance_distribution_medium | Unknown |  |
| compliance_distribution_total | Unknown |  |
| compliance_issues_count | Unknown |  |
| compliance_risk_score | Unknown |  |
| compressed | Unknown |  |
| creation_time | Unknown |  |
| csa | Unknown |  |
| distro | Unknown |  |
| ecs_cluster_name | Unknown |  |
| err | Unknown |  |
| err_code | Unknown |  |
| firewall_protection_enabled | Unknown |  |
| firewall_protection_out_of_band_mode | Json |  |
| firewall_protection_supported | Unknown |  |
| first_scan_time | Unknown |  |
| host_runtime_enabled | Unknown |  |
| hosts | Json |  |
| image_created | Unknown |  |
| image_entry_point | Json |  |
| installed_products_crio | Unknown |  |
| installed_products_has_package_manager | Unknown |  |
| installed_products_os_distro | Unknown |  |
| is_arm_64 | Unknown |  |
| k_8_s_cluster_addr | Unknown |  |
| layers | Json |  |
| malware_analyzed_time | Unknown |  |
| missing_distro_vuln_coverage | Unknown |  |
| namespaces | Json |  |
| os_distro | Unknown |  |
| os_distro_release | Unknown |  |
| os_distro_version | Unknown |  |
| package_manager | Unknown |  |
| pull_duration | Unknown |  |
| push_time | Unknown |  |
| red_hat_non_rpm_image | Unknown |  |
| registry_namespace | Unknown |  |
| registry_type | Unknown |  |
| repo | Unknown |  |
| repo_digests | Json |  |
| repo_registry | Unknown |  |
| repo_tag | Unknown |  |
| risk_factors | Json |  |
| scan_build_date | Unknown |  |
| scan_duration | Unknown |  |
| scan_id | Unknown |  |
| scan_time | Instant |  |
| scan_version | Unknown |  |
| secret_scan_metrics_failed_scans | Unknown |  |
| secret_scan_metrics_found_secrets | Unknown |  |
| secret_scan_metrics_scan_time | Unknown |  |
| secret_scan_metrics_scan_timeout | Unknown |  |
| secret_scan_metrics_scanned_file_size | Unknown |  |
| secret_scan_metrics_scanned_files | Unknown |  |
| secret_scan_metrics_total_bytes | Unknown |  |
| secret_scan_metrics_total_iles | Unknown |  |
| secret_scan_metrics_total_time | Unknown |  |
| secret_scan_metrics_types_count | Json |  |
| secrets | Json |  |
| stopped | Unknown |  |
| top_layer | Unknown |  |
| trust_status | Unknown |  |
| twistlock_image | Unknown |  |
| type | Unknown |  |
| vulnerabilities_count | Unknown |  |
| vulnerability_distribution_critical | Unknown |  |
| vulnerability_distribution_high | Unknown |  |
| vulnerability_distribution_low | Unknown |  |
| vulnerability_distribution_medium | Unknown |  |
| vulnerability_distribution_total | Unknown |  |
| vulnerability_risk_score | Unknown |  |
| wild_fire_usage_bytes | Unknown |  |
| wild_fire_usage_queries | Unknown |  |
| wild_fire_usage_uploads | Unknown |  |

### container_all_compliance_exploit

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| container_all_compliance_index | Unknown | PK, FK |
| container_id | Unknown | PK, FK |
| kind | Json |  |
| link | Unknown |  |
| source | Json |  |

### container_all_compliance_vulnerability_tag_info

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| container_all_compliance_index | Unknown | PK, FK |
| container_id | Unknown | PK, FK |
| color | Unknown |  |
| comment | Unknown |  |
| name | Unknown |  |

### container_all_compliance

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| container_id | Unknown | PK, FK |
| applicable_rules | Json |  |
| binary_pkgs | Json |  |
| block | Unknown |  |
| cause | Unknown |  |
| cri | Unknown |  |
| custom | Unknown |  |
| cve | Unknown |  |
| cvss | Unknown |  |
| description | Unknown |  |
| discovered | Unknown |  |
| exploit | Json |  |
| fix_date | Unknown |  |
| fix_link | Unknown |  |
| function_layer | Unknown |  |
| grace_period_days | Unknown |  |
| layer_time | Unknown |  |
| link | Unknown |  |
| package_name | Unknown |  |
| package_type | Json |  |
| package_version | Unknown |  |
| published | Unknown |  |
| risk_factor | Json |  |
| secret_id | Unknown |  |
| secret_location_in_file | Unknown |  |
| secret_modified_time | Unknown |  |
| secret_path | Unknown |  |
| secret_snippet | Unknown |  |
| secret_type | Json |  |
| severity | Unknown |  |
| status | Unknown |  |
| templates | Json |  |
| text | Unknown |  |
| title | Unknown |  |
| twistlock | Unknown |  |
| type | Json |  |
| vec_str | Unknown |  |
| violation_id | Unknown |  |
| wildfire_malware_md_5 | Unknown |  |
| wildfire_malware_path | Unknown |  |
| wildfire_malware_verdict | Unknown |  |

### container_info_compliance_issue

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| container_id | Unknown | PK, FK |
| block | Unknown |  |
| cause | Unknown |  |
| cri | Unknown |  |
| custom | Unknown |  |
| cve | Unknown |  |
| cvss | Unknown |  |
| description | Unknown |  |
| discovered | Unknown |  |
| fix_date | Unknown |  |
| fix_link | Unknown |  |
| function_layer | Unknown |  |
| grace_period_days | Unknown |  |
| layer_time | Unknown |  |
| link | Unknown |  |
| package_name | Unknown |  |
| package_version | Unknown |  |
| published | Unknown |  |
| risk_factors | Json |  |
| secret_id | Unknown |  |
| secret_location_in_file | Unknown |  |
| secret_modified_time | Unknown |  |
| secret_path | Unknown |  |
| secret_snippet | Unknown |  |
| severity | Unknown |  |
| status | Unknown |  |
| templates | Json |  |
| text | Unknown |  |
| title | Unknown |  |
| twistlock | Unknown |  |
| vec_str | Unknown |  |
| violation_id | Unknown |  |
| wildfire_malware_md_5 | Unknown |  |
| wildfire_malware_path | Unknown |  |
| wildfire_malware_verdict | Unknown |  |

### container_info_network_port

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| container_id | Unknown | PK, FK |
| container | Unknown |  |
| host | Unknown |  |
| host_ip | Unknown |  |
| listening | Unknown |  |
| nat | Unknown |  |

### container_process

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| container_id | Unknown | PK, FK |
| name | Unknown |  |

### container

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| hostname | Unknown | FK |
| image_id | Unknown | FK |
| agent_less | Unknown |  |
| agent_less_scan_id | Unknown |  |
| ais | Unknown |  |
| cloud_metadata_account_id | Unknown |  |
| cloud_metadata_image | Unknown |  |
| cloud_metadata_name | Unknown |  |
| cloud_metadata_provider | Json |  |
| cloud_metadata_region | Unknown |  |
| cloud_metadata_resource_id | Unknown |  |
| collections | Json |  |
| compliance_distribution_critical | Unknown |  |
| compliance_distribution_high | Unknown |  |
| compliance_distribution_low | Unknown |  |
| compliance_distribution_medium | Unknown |  |
| compliance_distribution_total | Unknown |  |
| csa | Unknown |  |
| firewall_protection_enabled | Unknown |  |
| firewall_protection_out_of_band_mode | Json |  |
| firewall_protection_ports | Json |  |
| firewall_protection_supported | Unknown |  |
| firewall_protection_tls_ports | Json |  |
| info_all_compliance_enabled | Unknown |  |
| info_app | Unknown |  |
| info_cluster | Unknown |  |
| info_cluster_type | Unknown |  |
| info_compliance_issues_count | Unknown |  |
| info_compliance_risk_score | Unknown |  |
| info_image | Unknown |  |
| info_image_name | Unknown |  |
| info_infra | Unknown |  |
| info_labels | Json |  |
| info_name | Unknown |  |
| info_namespace | Unknown |  |
| info_profile_id | Unknown |  |
| info_size_byte | Unknown |  |
| info_start_time | Unknown |  |
| installed_products_agentless | Unknown |  |
| installed_products_apache | Unknown |  |
| installed_products_aws_cloud | Unknown |  |
| installed_products_cluster_type | Unknown |  |
| installed_products_crio | Unknown |  |
| installed_products_docker | Unknown |  |
| installed_products_docker_enterprise | Unknown |  |
| installed_products_has_package_manager | Unknown |  |
| installed_products_k_8_s_api_server | Unknown |  |
| installed_products_k_8_s_controller_manager | Unknown |  |
| installed_products_k_8_s_etcd | Unknown |  |
| installed_products_k_8_s_federation_api_server | Unknown |  |
| installed_products_k_8_s_federation_controller_manager | Unknown |  |
| installed_products_k_8_s_kubelet | Unknown |  |
| installed_products_k_8_s_proxy | Unknown |  |
| installed_products_k_8_s_scheduler | Unknown |  |
| installed_products_kubernetes | Unknown |  |
| installed_products_managed_cluster_version | Unknown |  |
| installed_products_openshift | Unknown |  |
| installed_products_openshift_version | Unknown |  |
| installed_products_os_distro | Unknown |  |
| installed_products_serverless | Unknown |  |
| installed_products_swarm_manager | Unknown |  |
| installed_products_swarm_node | Unknown |  |
| runtime_enabled | Unknown |  |
| scan_time | Instant |  |

## Relationships

- host_binary(host_id) → host(id)
- host_startup_binary(host_id) → host(id)
- host_package_pkgs(host_package_host_id) → host_package(host_id)
- host_package_pkgs(host_package_index) → host_package(index)
- host_package(host_id) → host(id)
- host_file(host_id) → host(id)
- host_application(host_id) → host(id)
- host_found_secret(host_id) → host(id)
- host_history_vulnerability_exploit(host_history_vulnerability_index) → host_history_vulnerability(index)
- host_history_vulnerability_exploit(host_history_index) → host_history_vulnerability(host_history_index)
- host_history_vulnerability_exploit(host_id) → host_history_vulnerability(host_id)
- host_history_vulnerability_tag_info(host_history_vulnerability_index) → host_history_vulnerability(index)
- host_history_vulnerability_tag_info(host_history_index) → host_history_vulnerability(host_history_index)
- host_history_vulnerability_tag_info(host_id) → host_history_vulnerability(host_id)
- host_history_vulnerability(host_history_index) → host_history(index)
- host_history_vulnerability(host_id) → host_history(host_id)
- host_history(host_id) → host(id)
- host_compliance_issue_exploit(host_compliance_issue_index) → host_compliance_issue(index)
- host_compliance_issue_exploit(host_id) → host_compliance_issue(host_id)
- host_compliance_issue_vulnerability_tag_info(host_compliance_issue_index) → host_compliance_issue(index)
- host_compliance_issue_vulnerability_tag_info(host_id) → host_compliance_issue(host_id)
- host_compliance_issue(host_id) → host(id)
- host_all_compliance_exploit(host_all_compliance_index) → host_all_compliance(index)
- host_all_compliance_exploit(host_id) → host_all_compliance(host_id)
- host_all_compliance_vulnerability_tag_info(host_all_compliance_index) → host_all_compliance(index)
- host_all_compliance_vulnerability_tag_info(host_id) → host_all_compliance(host_id)
- host_all_compliance(host_id) → host(id)
- host_vulnerability_exploit(host_vulnerability_index) → host_vulnerability(index)
- host_vulnerability_exploit(host_id) → host_vulnerability(host_id)
- host_vulnerability_tag_info(host_vulnerability_index) → host_vulnerability(index)
- host_vulnerability_tag_info(host_id) → host_vulnerability(host_id)
- host_vulnerability(host_id) → host(id)
- host_tag(host_id) → host(id)
- host_device(host_id) → host(id)
- host_instance(host_id) → host(id)
- image_binary(image_id) → image(id)
- image_startup_binary(image_id) → image(id)
- image_package_pkgs(image_package_index) → image_package(index)
- image_package_pkgs(image_id) → image_package(image_id)
- image_package(image_id) → image(id)
- image_file(image_id) → image(id)
- image_application(image_id) → image(id)
- image_found_secret(image_id) → image(id)
- image_history_vulnerability_exploit(image_history_vulnerability_index) → image_history_vulnerability(index)
- image_history_vulnerability_exploit(image_history_index) → image_history_vulnerability(image_history_index)
- image_history_vulnerability_exploit(image_id) → image_history_vulnerability(image_id)
- image_history_vulnerability_tag_info(image_history_vulnerability_index) → image_history_vulnerability(index)
- image_history_vulnerability_tag_info(image_history_index) → image_history_vulnerability(image_history_index)
- image_history_vulnerability_tag_info(image_id) → image_history_vulnerability(image_id)
- image_history_vulnerability(image_history_index) → image_history(index)
- image_history_vulnerability(image_id) → image_history(image_id)
- image_history(image_id) → image(id)
- image_compliance_issue_exploit(image_compliance_issue_index) → image_compliance_issue(index)
- image_compliance_issue_exploit(image_id) → image_compliance_issue(image_id)
- image_compliance_issue_vulnerability_tag_info(image_compliance_issue_index) → image_compliance_issue(index)
- image_compliance_issue_vulnerability_tag_info(image_id) → image_compliance_issue(image_id)
- image_compliance_issue(image_id) → image(id)
- image_all_compliance_exploit(image_all_compliance_index) → image_all_compliance(index)
- image_all_compliance_exploit(image_id) → image_all_compliance(image_id)
- image_all_compliance_vulnerability_tag_info(image_all_compliance_index) → image_all_compliance(index)
- image_all_compliance_vulnerability_tag_info(image_id) → image_all_compliance(image_id)
- image_all_compliance(image_id) → image(id)
- image_vulnerability_exploit(image_vulnerability_index) → image_vulnerability(index)
- image_vulnerability_exploit(image_id) → image_vulnerability(image_id)
- image_vulnerability_tag_info(image_vulnerability_index) → image_vulnerability(index)
- image_vulnerability_tag_info(image_id) → image_vulnerability(image_id)
- image_vulnerability(image_id) → image(id)
- image_tag(image_id) → image(id)
- image_instance(image_id) → image(id)
- image(hostname) → host(id)
- container_all_compliance_exploit(container_all_compliance_index) → container_all_compliance(index)
- container_all_compliance_exploit(container_id) → container_all_compliance(container_id)
- container_all_compliance_vulnerability_tag_info(container_all_compliance_index) → container_all_compliance(index)
- container_all_compliance_vulnerability_tag_info(container_id) → container_all_compliance(container_id)
- container_all_compliance(container_id) → container(id)
- container_info_compliance_issue(container_id) → container(id)
- container_info_network_port(container_id) → container(id)
- container_process(container_id) → container(id)
- container(hostname) → host(id)
- container(image_id) → image(id)