# Jamf schema ERD

Table and field reference for the Fivetran Jamf connector.

## Table & Field Reference

### device_enrollment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| supervision_identity_id | Unknown | FK |
| admin_id | Unknown |  |
| name | Unknown |  |
| org_address | Unknown |  |
| org_email | Unknown |  |
| org_name | Unknown |  |
| org_phone | Unknown |  |
| server_name | Unknown |  |
| server_uuid | Unknown |  |
| site_id | Unknown |  |
| token_expiration_date | Unknown |  |

### startup_status

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| error | Unknown |  |
| error_code | Unknown |  |
| percentage | Unknown |  |
| setup_assistant_necessary | Unknown |  |
| step | Unknown |  |
| step_code | Unknown |  |
| step_param | Unknown |  |
| warning | Unknown |  |
| warning_code | Unknown |  |
| warning_param | Unknown |  |

### sso_history_object

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| date | Instant |  |
| details | Unknown |  |
| note | Unknown |  |
| username | Unknown |  |

### server_configuration

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| mapping_user_id | Unknown | FK |
| deprecated_consent | Unknown |  |
| enabled | Unknown |  |
| membership_calculation_optimization_enabled | Unknown |  |
| migrated | Unknown |  |
| search_timeout | Unknown |  |
| tenant_id | Unknown |  |
| transitive_directory_membership_enabled | Unknown |  |
| transitive_membership_enabled | Unknown |  |
| transitive_membership_user_field | Unknown |  |

### sso_host

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| sso_id | Unknown | PK, FK |
| host | Unknown |  |

### sso

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| enrollment_sso_for_account_driven_enrollment_enabled | Unknown |  |
| federation_metadata_file | Unknown |  |
| group_attribute_name | Unknown |  |
| group_enrollment_access_enabled | Unknown |  |
| group_enrollment_access_name | Unknown |  |
| group_rdn_key | Unknown |  |
| idp_provider_type | Unknown |  |
| idp_url | Unknown |  |
| management_hint | Unknown |  |
| metadata_file_name | Unknown |  |
| metadata_source | Unknown |  |
| other_provider_type_name | Unknown |  |
| session_timeout | Unknown |  |
| sso_bypass_allowed | Unknown |  |
| sso_enabled | Unknown |  |
| sso_for_enrollment_enabled | Unknown |  |
| sso_for_mac_os_self_service_enabled | Unknown |  |
| token_expiration_disabled | Unknown |  |
| user_attribute_enabled | Unknown |  |
| user_attribute_name | Unknown |  |
| user_mapping | Unknown |  |

### mobile_device_group

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| is_smart_group | Unknown |  |
| name | Unknown |  |

### app_setting

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| app_store_locale | Unknown |  |
| approver_email | Json |  |
| is_enabled | Unknown |  |
| requester_user_group_id | Unknown |  |

### cloud_identity

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| display_name | Unknown |  |
| enabled | Unknown |  |
| provider_name | Unknown |  |

### computer_inventory_capable_user

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| computer_inventory_id | Unknown | PK, FK |
| users | Unknown |  |

### computer_inventory_cache_detail

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| computer_inventory_id | Unknown | PK, FK |
| category_name | Unknown |  |
| disk_space_bytes_used | Unknown |  |

### computer_inventory_alert

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| computer_inventory_id | Unknown | PK, FK |
| cache_bytes_limit | Unknown |  |
| class_name | Unknown |  |
| path_preventing_access | Unknown |  |
| post_date | Unknown |  |
| reserved_volume_bytes | Unknown |  |
| resource | Unknown |  |

### computer_value

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| computer_inventory_extension_index | Unknown | PK, FK |
| computer_inventory_id | Unknown | PK, FK |
| value | Unknown |  |

### computer_option

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| computer_inventory_extension_index | Unknown | PK, FK |
| computer_inventory_id | Unknown | PK, FK |
| option | Unknown |  |

### computer_inventory_extension

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| computer_inventory_id | Unknown | PK, FK |
| data_type | Unknown |  |
| definition_id | Unknown |  |
| description | Unknown |  |
| enabled | Unknown |  |
| input_type | Unknown |  |
| multi_value | Unknown |  |
| name | Unknown |  |

### computer_inventory_parent_local_network

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| computer_inventory_id | Unknown | PK, FK |
| computer_inventory_parent_id | Unknown | PK, FK |
| speed | Unknown |  |
| wired | Unknown |  |

### computer_inventory_parent

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| computer_inventory_id | Unknown | PK, FK |
| address | Unknown |  |
| alert_addresses | Json |  |
| alert_class_name | Unknown |  |
| alert_content_caching_parent_alert_id | Unknown |  |
| alert_post_date | Unknown |  |
| detail_ac_power | Unknown |  |
| detail_cache_size_bytes | Unknown |  |
| detail_capability_content_caching_parent_capabilities_id | Unknown |  |
| detail_capability_imports | Unknown |  |
| detail_capability_name_space | Unknown |  |
| detail_capability_personal_content | Unknown |  |
| detail_capability_prioritization | Unknown |  |
| detail_capability_query_parameter | Unknown |  |
| detail_capability_shared_content | Unknown |  |
| detail_content_caching_parent_details_id | Unknown |  |
| detail_portable | Unknown |  |
| guid | Unknown |  |
| healthy | Unknown |  |
| port | Unknown |  |
| version | Unknown |  |

### computer_inventory_software_update

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| computer_inventory_id | Unknown | PK, FK |
| name | Unknown |  |
| package_name | Unknown |  |
| version | Unknown |  |

### computer_inventory_attachment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| computer_inventory_id | Unknown | PK, FK |
| file_type | Unknown |  |
| name | Unknown |  |
| size_byte | Unknown |  |

### computer_inventory_ibeacon

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

### computer_inventory_licensed_software

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| computer_inventory_id | Unknown | PK, FK |
| name | Unknown |  |

### computer_inventory_font

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| computer_inventory_id | Unknown | PK, FK |
| name | Unknown |  |
| path | Unknown |  |
| version | Unknown |  |

### computer_inventory_plugin

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| computer_inventory_id | Unknown | PK, FK |
| name | Unknown |  |
| path | Unknown |  |
| version | Unknown |  |

### computer_inventory_certificate

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| computer_inventory_id | Unknown | PK, FK |
| certificate_status | Unknown |  |
| common_name | Unknown |  |
| expiration_date | Unknown |  |
| identities | Unknown |  |
| issued_date | Unknown |  |
| lifecycle_status | Unknown |  |
| serial_number | Unknown |  |
| sha_1_fingerprint | Unknown |  |
| subject_name | Unknown |  |
| username | Unknown |  |

### computer_inventory_local_user_account

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| computer_inventory_id | Unknown | PK, FK |
| admin | Unknown |  |
| azure_active_directory_id | Unknown |  |
| computer_azure_active_directory_id | Unknown |  |
| file_vault_2_enabled | Unknown |  |
| full_name | Unknown |  |
| home_directory | Unknown |  |
| home_directory_size_mb | Unknown |  |
| password_history_depth | Unknown |  |
| password_max_age | Unknown |  |
| password_min_complex_character | Unknown |  |
| password_min_length | Unknown |  |
| password_require_alphanumeric | Unknown |  |
| user_account_type | Unknown |  |
| user_azure_active_directory_id | Unknown |  |
| user_guid | Unknown |  |
| username | Unknown |  |

### computer_inventory_service

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

### computer_inventory_printer

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| computer_inventory_id | Unknown | PK, FK |
| location | Unknown |  |
| name | Unknown |  |
| type | Unknown |  |
| uri | Unknown |  |

### computer_inventory_configuration_profile

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| computer_inventory_id | Unknown | PK, FK |
| display_name | Unknown |  |
| id | Unknown |  |
| last_installed | Unknown |  |
| profile_identifier | Unknown |  |
| removable | Unknown |  |
| username | Unknown |  |

### computer_inventory_disk_portition

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| computer_inventory_disk_id | Unknown | PK, FK |
| computer_inventory_id | Unknown | PK, FK |
| available_mega | Unknown |  |
| bytes | Unknown |  |
| file_vault_2_progress_percent | Unknown |  |
| file_vault_2_state | Unknown |  |
| lvm_managed | Unknown |  |
| name | Unknown |  |
| partition_type | Unknown |  |
| percent_used | Unknown |  |
| size_mega_bytes | Unknown |  |

### computer_inventory_disk

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| computer_inventory_id | Unknown | PK, FK |
| device | Unknown |  |
| model | Unknown |  |
| revision | Unknown |  |
| serial_number | Unknown |  |
| size_mega_bytes | Unknown |  |
| smart_status | Unknown |  |
| type | Unknown |  |

### computer_inventory_application

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| computer_inventory_id | Unknown | PK, FK |
| bundle_id | Unknown |  |
| external_version_id | Unknown |  |
| mac_app_store | Unknown |  |
| name | Unknown |  |
| path | Unknown |  |
| size_megabytes | Unknown |  |
| update_available | Unknown |  |
| version | Unknown |  |

### computer_inventory_file_vault

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| computer_inventory_id | Unknown | PK, FK |
| file_vault_2_enabled_user_name | Unknown |  |

### computer_inventory_group_membership

| Column | Type | Keys |
| --- | --- | --- |
| computer_inventory_id | Unknown | PK, FK |
| id | Unknown | PK, FK |
| group_name | Unknown |  |
| smart_group | Unknown |  |

### computer_inventory_content_caching_data_migration_user_info

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| computer_inventory_id | Unknown | PK, FK |
| key | Unknown |  |
| value | Unknown |  |

### computer_inventory

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| asset_tag | Unknown |  |
| barcode_1 | Unknown |  |
| barcode_2 | Unknown |  |
| boot_partition_encryption_detail_partition_file_vault_2_percent | Unknown |  |
| boot_partition_encryption_detail_partition_file_vault_2_state | Unknown |  |
| boot_partition_encryption_detail_partition_name | Unknown |  |
| content_cache_activated | Unknown |  |
| content_cache_active | Unknown |  |
| content_cache_actual_cache_bytes_used | Unknown |  |
| content_cache_bytes_free | Unknown |  |
| content_cache_bytes_limit | Unknown |  |
| content_cache_bytes_used | Unknown |  |
| content_cache_computer_content_caching_information_id | Unknown |  |
| content_cache_data_migration_completed | Unknown |  |
| content_cache_data_migration_progress_percentage | Unknown |  |
| content_cache_max_cache_pressure_last_1_hour_percentage | Unknown |  |
| content_cache_personal_cache_bytes_free | Unknown |  |
| content_cache_personal_cache_bytes_limit | Unknown |  |
| content_cache_personal_cache_bytes_used | Unknown |  |
| content_cache_port | Unknown |  |
| content_cache_public_address | Unknown |  |
| content_cache_registration_error | Unknown |  |
| content_cache_registration_response_code | Unknown |  |
| content_cache_registration_started | Unknown |  |
| content_cache_registration_status | Unknown |  |
| content_cache_restricted_media | Unknown |  |
| content_cache_server_guid | Unknown |  |
| content_cache_startup_status | Unknown |  |
| content_cache_status | Unknown |  |
| content_cache_tetherator_status | Unknown |  |
| content_cache_total_bytes_are_since | Unknown |  |
| content_cache_total_bytes_dropped | Unknown |  |
| content_cache_total_bytes_imported | Unknown |  |
| content_cache_total_bytes_returned_to_children | Unknown |  |
| content_cache_total_bytes_returned_to_client | Unknown |  |
| content_cache_total_bytes_returned_to_peer | Unknown |  |
| content_cache_total_bytes_stored_from_origin | Unknown |  |
| content_cache_total_bytes_stored_from_parent | Unknown |  |
| content_cache_total_bytes_stored_from_peer | Unknown |  |
| content_caching_data_migration_error_code | Unknown |  |
| content_caching_data_migration_error_domain | Unknown |  |
| declarative_device_management_enabled | Unknown |  |
| disk_encryption_configuration_name | Unknown |  |
| disk_encryption_file_vault_2_eligibility_message | Unknown |  |
| disk_encryption_file_vault_2_enabled | Unknown |  |
| disk_encryption_individual_recovery_key_validity_status | Unknown |  |
| disk_encryption_institutional_recovery_key_present | Unknown |  |
| distribution_point | Unknown |  |
| enrolled_via_automated_device_enrollment | Unknown |  |
| general_enrollment_method_id | Unknown |  |
| general_enrollment_method_object_name | Unknown |  |
| general_enrollment_method_object_type | Unknown |  |
| general_mdm_capable | Unknown |  |
| general_remote_managed | Unknown |  |
| general_remote_management_username | Unknown |  |
| hardware_alt_mac_address | Unknown |  |
| hardware_alt_network_adapter_type | Unknown |  |
| hardware_apple_silicon | Unknown |  |
| hardware_battery_capacity_percent | Unknown |  |
| hardware_ble_capable | Unknown |  |
| hardware_boot_rom | Unknown |  |
| hardware_bus_speed_mhz | Unknown |  |
| hardware_cache_size_kilobytes | Unknown |  |
| hardware_core_count | Unknown |  |
| hardware_mac_address | Unknown |  |
| hardware_make | Unknown |  |
| hardware_model | Unknown |  |
| hardware_model_identifier | Unknown |  |
| hardware_network_adapter_type | Unknown |  |
| hardware_nic_speed | Unknown |  |
| hardware_open_ram_slot | Unknown |  |
| hardware_optical_drive | Unknown |  |
| hardware_processor_architecture | Unknown |  |
| hardware_processor_count | Unknown |  |
| hardware_processor_speed_mhz | Unknown |  |
| hardware_processor_type | Unknown |  |
| hardware_serial_number | Unknown |  |
| hardware_smc_version | Unknown |  |
| hardware_supports_ios_app_install | Unknown |  |
| hardware_total_ram_megabytes | Unknown |  |
| initial_entry_date | Unknown |  |
| is_leased | Unknown |  |
| is_purchased | Unknown |  |
| itunes_store_account_active | Unknown |  |
| jamf_binary_version | Unknown |  |
| last_cloud_backup_date | Unknown |  |
| last_contact_time | Unknown |  |
| last_enrolled_date | Unknown |  |
| last_ip_address | Unknown |  |
| last_reported_ip | Unknown |  |
| management_id | Unknown |  |
| mdm_profile_expiration | Unknown |  |
| name | Unknown |  |
| operating_system_active_directory_status | Unknown |  |
| operating_system_build | Unknown |  |
| operating_system_file_vault_2_status | Unknown |  |
| operating_system_name | Unknown |  |
| operating_system_rapid_security_response | Unknown |  |
| operating_system_software_update_device_id | Unknown |  |
| operating_system_supplemental_build_version | Unknown |  |
| operating_system_version | Unknown |  |
| package_receipt | Json |  |
| platform | Unknown |  |
| purchasing_account | Unknown |  |
| purchasing_apple_care_id | Unknown |  |
| purchasing_contact | Unknown |  |
| purchasing_lease_date | Unknown |  |
| purchasing_life_expectancy | Unknown |  |
| purchasing_po_date | Unknown |  |
| purchasing_po_number | Unknown |  |
| purchasing_price | Unknown |  |
| purchasing_vendor | Unknown |  |
| purchasing_warranty_date | Unknown |  |
| report_date | Unknown |  |
| security_activation_lock_enabled | Unknown |  |
| security_attestation_status | Unknown |  |
| security_auto_login_disabled | Unknown |  |
| security_bootstrap_token_allowed | Unknown |  |
| security_bootstrap_token_escrowed_status | Unknown |  |
| security_external_boot_level | Unknown |  |
| security_firewall_enabled | Unknown |  |
| security_gate_keeper_status | Unknown |  |
| security_last_attestation_attempt | Unknown |  |
| security_last_successful_attestation | Unknown |  |
| security_recovery_lock_enabled | Unknown |  |
| security_remote_desktop_enabled | Unknown |  |
| security_secure_boot_level | Unknown |  |
| security_sip_status | Unknown |  |
| security_x_protect_version | Unknown |  |
| site_id | Unknown |  |
| site_name | Unknown |  |
| storage | Unknown |  |
| supervised | Unknown |  |
| udid | Unknown |  |
| user_and_location_building_id | Unknown |  |
| user_and_location_department_id | Unknown |  |
| user_and_location_email | Unknown |  |
| user_and_location_phone | Unknown |  |
| user_and_location_position | Unknown |  |
| user_and_location_realname | Unknown |  |
| user_and_location_room | Unknown |  |
| user_and_location_username | Unknown |  |
| user_approved_mdm | Unknown |  |

### patch_software_title_configuration_extension

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| patch_software_title_configuration_id | Unknown | PK, FK |
| accepted | Unknown |  |

### patch_software_title_configuration_package

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| patch_software_title_configuration_id | Unknown | PK, FK |
| display_name | Unknown |  |
| version | Unknown |  |

### patch_software_title_configuration

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| category_id | Unknown | FK |
| display_name | Unknown |  |
| email_notification | Unknown |  |
| jamf_official | Unknown |  |
| patch_source_enabled | Unknown |  |
| patch_source_name | Unknown |  |
| site_id | Unknown |  |
| software_title_id | Unknown |  |
| software_title_name | Unknown |  |
| software_title_name_id | Unknown |  |
| software_title_publisher | Unknown |  |
| ui_notification | Unknown |  |

### mapping

| Column | Type | Keys |
| --- | --- | --- |
| user_id | Unknown | PK |
| group_id | Unknown | FK |
| building | Unknown |  |
| department | Unknown |  |
| email | Unknown |  |
| group_name | Unknown |  |
| phone | Unknown |  |
| position | Unknown |  |
| real_name | Unknown |  |
| room | Unknown |  |
| user_name | Unknown |  |

### check_in

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| check_in_frequency | Unknown |  |
| create_hook | Unknown |  |
| create_startup_script | Unknown |  |
| enable_local_configuration_profile | Unknown |  |
| hook_log | Unknown |  |
| hook_policy | Unknown |  |
| startup_log | Unknown |  |
| startup_policy | Unknown |  |
| startup_ssh | Unknown |  |

### patch_policy_log

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| ignored_for_patch_policy_id | Unknown | FK |
| attempt_number | Unknown |  |
| device_id | Unknown |  |
| device_name | Unknown |  |
| status_code | Unknown |  |
| status_date | Unknown |  |
| status_enum | Unknown |  |

### mobile_device_object

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| management_id | Unknown |  |
| model | Unknown |  |
| model_identifier | Unknown |  |
| name | Unknown |  |
| phone_number | Unknown |  |
| serial_number | Unknown |  |
| software_update_device_id | Unknown |  |
| type | Unknown |  |
| udid | Unknown |  |
| username | Unknown |  |
| wifi_mac_address | Unknown |  |

### sso_dependency

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| human_readable_name | Unknown |  |
| hyperlink | Unknown |  |
| name | Unknown |  |

### remote_administration_configuration

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| display_name | Unknown |  |
| site_id | Unknown |  |
| type | Unknown |  |

### ios_configuration

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| branding_name | Unknown |  |
| branding_name_color_code | Unknown |  |
| header_background_color_code | Unknown |  |
| icon_id | Unknown |  |
| menu_icon_color_code | Unknown |  |
| status_bar_text_color | Unknown |  |

### cloud_identity_history

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| date | Instant |  |
| details | Unknown |  |
| note | Unknown |  |
| username | Unknown |  |

### check_in_history

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| date | Instant |  |
| details | Unknown |  |
| note | Unknown |  |
| username | Unknown |  |

### re_enrollment_object

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| flush_mdm_queue | Unknown |  |
| is_flush_extension_attributes_enabled | Unknown |  |
| is_flush_location_information_enabled | Unknown |  |
| is_flush_location_information_history_enabled | Unknown |  |
| is_flush_policy_history_enabled | Unknown |  |

### static_group

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| count | Unknown |  |
| group_name | Unknown |  |
| site_id | Unknown |  |

### enrollment_customization

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| description | Unknown |  |
| display_name | Unknown |  |
| enrollment_customization_branding_setting_background_color | Unknown |  |
| enrollment_customization_branding_setting_button_color | Unknown |  |
| enrollment_customization_branding_setting_button_text_color | Unknown |  |
| enrollment_customization_branding_setting_icon_url | Unknown |  |
| enrollment_customization_branding_setting_text_color | Unknown |  |
| site_id | Unknown |  |

### computer

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| asset_tag | Unknown |  |
| ip_address | Unknown |  |
| is_managed | Unknown |  |
| last_contact_date | Unknown |  |
| last_enrolled_date | Unknown |  |
| last_report_date | Instant |  |
| location_building | Unknown |  |
| location_department | Unknown |  |
| location_email_address | Unknown |  |
| location_phone_number | Unknown |  |
| location_position | Unknown |  |
| location_real_name | Unknown |  |
| location_room | Unknown |  |
| location_username | Unknown |  |
| mac_address | Unknown |  |
| management_id | Unknown |  |
| mdm_access_right | Unknown |  |
| model_identifier | Unknown |  |
| name | Unknown |  |
| operating_system_build | Unknown |  |
| operating_system_rapid_security_response | Unknown |  |
| operating_system_supplemental_build_version | Unknown |  |
| operating_system_version | Unknown |  |
| serial_number | Unknown |  |
| site | Unknown |  |
| udid | Unknown |  |

### api_role_privilege

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| api_role_id | Unknown | PK, FK |
| privilege_id | Unknown |  |

### api_role

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| display_name | Unknown |  |

### authorization_detail_group_id

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| authorization_detail_account_id | Unknown | PK, FK |
| group_id | Unknown | FK |

### authorization_account_group_member

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| authorization_detail_account_group_index | Unknown | PK, FK |
| authorization_detail_account_id | Unknown | PK, FK |
| member_user_id | Unknown |  |

### authorization_detail_account_group

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| authorization_detail_account_id | Unknown | PK, FK |
| access_level | Unknown |  |
| privilege_set | Unknown |  |
| privileges | Unknown |  |
| site_id | Unknown |  |

### authorization_detail_site

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| authorization_detail_account_id | Unknown | PK, FK |
| name | Unknown |  |

### authorization_detail

| Column | Type | Keys |
| --- | --- | --- |
| account_id | Unknown | PK |
| account_access_level | Unknown |  |
| account_current_site_id | Unknown |  |
| account_date_format | Unknown |  |
| account_disable_relative_date | Unknown |  |
| account_email | Unknown |  |
| account_language | Unknown |  |
| account_multi_site_admin | Unknown |  |
| account_privilege_set | Unknown |  |
| account_real_name | Unknown |  |
| account_region | Unknown |  |
| account_timezone | Unknown |  |
| account_username | Unknown |  |
| custom_** |  |  |

### mobile_device_extension_attribute_value

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| mobile_device_detail_extension_attribute_id | Unknown | PK, FK |
| mobile_device_detail_id | Unknown | PK, FK |
| value | Unknown |  |

### mobile_device_detail_extension_attribute

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| mobile_device_detail_id | Unknown | PK, FK |
| extension_attribute_collection_allowed | Unknown |  |
| inventory_display | Unknown |  |
| name | Unknown |  |
| type | Unknown |  |

### mobile_device_detail_application

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| mobile_device_detail_id | Unknown | PK, FK |
| bundle_size | Unknown |  |
| dynamic_size | Unknown |  |
| identifier | Unknown |  |
| management_status | Unknown |  |
| name | Unknown |  |
| short_version | Unknown |  |
| validation_status | Unknown |  |
| version | Unknown |  |

### mobile_device_detail_certificate

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| mobile_device_detail_id | Unknown | PK, FK |
| common_name | Unknown |  |
| expiration_date | Unknown |  |
| identities | Unknown |  |

### mobile_device_detail_profile

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| mobile_device_detail_id | Unknown | PK, FK |
| display_name | Unknown |  |
| identifier | Unknown |  |
| last_installed | Unknown |  |
| removable | Unknown |  |
| version | Unknown |  |

### mobile_device_detail_user_profile

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| mobile_device_detail_id | Unknown | PK, FK |
| display_name | Unknown |  |
| identifier | Unknown |  |
| last_installed | Unknown |  |
| removable | Unknown |  |
| username | Unknown |  |
| version | Unknown |  |

### mobile_device_detail_shared_user

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| mobile_device_detail_id | Unknown | PK, FK |
| data_to_sync | Unknown |  |
| logged_in | Unknown |  |
| managed_apple_id | Unknown |  |

### mobile_device_detail_service_subscription

| Column | Type | Keys |
| --- | --- | --- |
| e_id | Unknown | PK |
| mobile_device_detail_id | Unknown | PK, FK |
| carrier_setting_version | Unknown |  |
| current_carrier_network | Unknown |  |
| current_mobile_country_code | Unknown |  |
| current_mobile_network_code | Unknown |  |
| data_preferred | Unknown |  |
| icc_id | Unknown |  |
| imei | Unknown |  |
| label | Unknown |  |
| label_id | Unknown |  |
| me_id | Unknown |  |
| phone_number | Unknown |  |
| roaming | Unknown |  |
| slot | Unknown |  |
| subscriber_carrier_network | Unknown |  |
| voice_preferred | Unknown |  |

### mobile_device_detail_e_book

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| mobile_device_detail_id | Unknown | PK, FK |
| author | Unknown |  |
| kind | Unknown |  |
| management_state | Unknown |  |
| title | Unknown |  |
| version | Unknown |  |

### mobile_device_detail_provision_profile

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| mobile_device_detail_id | Unknown | PK, FK |
| display_name | Unknown |  |
| expiration_date | Unknown |  |

### mobile_device_detail

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| air_play_password | Unknown |  |
| app_analytics_enabled | Unknown |  |
| asset_tag | Unknown |  |
| cloud_backup_enabled | Unknown |  |
| declarative_device_management_enabled | Unknown |  |
| device_locator_service_enabled | Unknown |  |
| device_ownership_type | Unknown |  |
| device_type | Unknown |  |
| diagnostic_and_usage_reporting_enabled | Unknown |  |
| display_name | Unknown |  |
| do_not_disturb_enabled | Unknown |  |
| enrollment_method_prestage_mobile_device_prestage_id | Unknown |  |
| enrollment_method_prestage_profile_name | Unknown |  |
| enrollment_session_token_valid | Unknown |  |
| exchange_device_id | Unknown |  |
| hardware_available_space_mb | Unknown |  |
| hardware_battery_level | Unknown |  |
| hardware_bluetooth_low_energy_capable | Unknown |  |
| hardware_bluetooth_mac_address | Unknown |  |
| hardware_capacity_mb | Unknown |  |
| hardware_device_id | Unknown |  |
| hardware_model | Unknown |  |
| hardware_model_identifier | Unknown |  |
| hardware_model_number | Unknown |  |
| hardware_modem_firmware_version | Unknown |  |
| hardware_serial_number | Unknown |  |
| hardware_used_space_percentage | Unknown |  |
| hardware_wifi_mac_address | Unknown |  |
| ip_address | Unknown |  |
| is_leased | Unknown |  |
| is_purchased | Unknown |  |
| itunes_store_account_active | Unknown |  |
| languages | Unknown |  |
| last_backup_date | Unknown |  |
| last_cloud_backup_date | Unknown |  |
| last_enrolled_date | Unknown |  |
| last_inventory_update_date | Unknown |  |
| locales | Unknown |  |
| location_services_for_self_service_mobile_enabled | Unknown |  |
| managed | Unknown |  |
| maximum_sharedi_pad_users_stored | Unknown |  |
| mdm_profile_expiration_date | Unknown |  |
| os_build | Unknown |  |
| os_rapid_security_response | Unknown |  |
| os_supplemental_build_version | Unknown |  |
| os_version | Unknown |  |
| purchasing_apple_care_id | Unknown |  |
| purchasing_contact | Unknown |  |
| purchasing_lease_expires_date | Unknown |  |
| purchasing_life_expectancy | Unknown |  |
| purchasing_po_date | Unknown |  |
| purchasing_po_number | Unknown |  |
| purchasing_purchase_price | Unknown |  |
| purchasing_purchasing_account | Unknown |  |
| purchasing_vendor | Unknown |  |
| purchasing_warranty_expires_date | Unknown |  |
| quota_size | Unknown |  |
| resident_users | Unknown |  |
| security_activation_lock_enabled | Unknown |  |
| security_block_level_encryption_capable | Unknown |  |
| security_data_protected | Unknown |  |
| security_file_level_encryption_capable | Unknown |  |
| security_hardware_encryption | Unknown |  |
| security_jail_break_detected | Unknown |  |
| security_last_attestation_attempt_date | Unknown |  |
| security_last_successful_attestation_date | Unknown |  |
| security_lost_mode_enabled | Unknown |  |
| security_lost_mode_foot_note | Unknown |  |
| security_lost_mode_location_altitude_meter | Unknown |  |
| security_lost_mode_location_course_degrees | Unknown |  |
| security_lost_mode_location_horizontal_accuracy_meter | Unknown |  |
| security_lost_mode_location_speed_meters_per_second | Unknown |  |
| security_lost_mode_location_timestamp | Unknown |  |
| security_lost_mode_location_update | Unknown |  |
| security_lost_mode_location_vertical_accuracy_meter | Unknown |  |
| security_lost_mode_message | Unknown |  |
| security_lost_mode_persistent | Unknown |  |
| security_lost_mode_phone_number | Unknown |  |
| security_passcode_compliant | Unknown |  |
| security_passcode_compliant_with_profile | Unknown |  |
| security_passcode_lock_grace_period_enforced_second | Unknown |  |
| security_passcode_present | Unknown |  |
| security_personal_device_profile_current | Unknown |  |
| shared_ipad | Unknown |  |
| site_id | Unknown |  |
| software_update_device_id | Unknown |  |
| supervised | Unknown |  |
| synced_to_computer | Unknown |  |
| temporary_session_only | Unknown |  |
| temporary_session_timeout | Unknown |  |
| tethered | Unknown |  |
| time_zone | Unknown |  |
| udid | Unknown |  |
| user_and_location_building | Unknown |  |
| user_and_location_building_id | Unknown |  |
| user_and_location_department | Unknown |  |
| user_and_location_department_id | Unknown |  |
| user_and_location_email_address | Unknown |  |
| user_and_location_phone_number | Unknown |  |
| user_and_location_position | Unknown |  |
| user_and_location_real_name | Unknown |  |
| user_and_location_room | Unknown |  |
| user_and_location_username | Unknown |  |
| user_session_timeout | Unknown |  |

### computer_prestage_custom_package

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| computer_prestage_id | Unknown | PK, FK |
| package_id | Unknown |  |

### computer_prestaged_installed_profile

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| computer_prestage_id | Unknown | PK, FK |
| profile_id | Unknown |  |

### computer_prestage_anchor_certificate

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| computer_prestage_id | Unknown | PK, FK |
| anchor_certificate | Unknown |  |

### computer_prestage

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_setting_admin_username | Unknown |  |
| account_setting_hidden_admin_account | Unknown |  |
| account_setting_id | Unknown |  |
| account_setting_local_admin_account_enabled | Unknown |  |
| account_setting_local_user_managed | Unknown |  |
| account_setting_payload_configured | Unknown |  |
| account_setting_prefill_account_full_name | Unknown |  |
| account_setting_prefill_account_user_name | Unknown |  |
| account_setting_prefill_primary_account_info_feature_enabled | Unknown |  |
| account_setting_prefill_type | Unknown |  |
| account_setting_prevent_prefill_info_from_modification | Unknown |  |
| account_setting_user_account_type | Unknown |  |
| account_setting_version_lock | Unknown |  |
| authentication_prompt | Unknown |  |
| auto_advance_setup | Unknown |  |
| custom_package_distribution_point_id | Unknown |  |
| default_prestage | Unknown |  |
| department | Unknown |  |
| device_enrollment_program_instance_id | Unknown |  |
| display_name | Unknown |  |
| enable_device_based_activation_lock | Unknown |  |
| enable_recovery_lock | Unknown |  |
| enrollment_customization_id | Unknown |  |
| enrollment_site_id | Unknown |  |
| install_profiles_during_setup | Unknown |  |
| is_leased | Unknown |  |
| is_purchased | Unknown |  |
| keep_existing_location_information | Unknown |  |
| keep_existing_site_membership | Unknown |  |
| languages | Unknown |  |
| location_building_id | Unknown |  |
| location_department_id | Unknown |  |
| location_email | Unknown |  |
| location_id | Unknown |  |
| location_phone | Unknown |  |
| location_position | Unknown |  |
| location_realname | Unknown |  |
| location_room | Unknown |  |
| location_username | Unknown |  |
| location_version_lock | Unknown |  |
| mandatory | Unknown |  |
| mdm_removable | Unknown |  |
| prevent_activation_lock | Unknown |  |
| profile_uuid | Unknown |  |
| purchase_info_apple_care_id | Unknown |  |
| purchase_info_id | Unknown |  |
| purchase_info_lease_date | Unknown |  |
| purchase_info_life_expectancy | Unknown |  |
| purchase_info_po_date | Unknown |  |
| purchase_info_po_number | Unknown |  |
| purchase_info_purchase_price | Unknown |  |
| purchase_info_purchasing_account | Unknown |  |
| purchase_info_purchasing_contact | Unknown |  |
| purchase_info_vendor | Unknown |  |
| purchase_info_version_lock | Unknown |  |
| purchase_info_warranty_date | Unknown |  |
| recovery_lock_password_type | Unknown |  |
| region | Unknown |  |
| require_authentication | Unknown |  |
| rotate_recovery_lock_password | Unknown |  |
| site_id | Unknown |  |
| skip_setup_item_accessibility | Unknown |  |
| skip_setup_item_appearance | Unknown |  |
| skip_setup_item_apple_id | Unknown |  |
| skip_setup_item_biometric | Unknown |  |
| skip_setup_item_diagnostics | Unknown |  |
| skip_setup_item_display_tone | Unknown |  |
| skip_setup_item_file_vault | Unknown |  |
| skip_setup_item_i_cloud_diagnostics | Unknown |  |
| skip_setup_item_i_cloud_storage | Unknown |  |
| skip_setup_item_location | Unknown |  |
| skip_setup_item_payment | Unknown |  |
| skip_setup_item_privacy | Unknown |  |
| skip_setup_item_registration | Unknown |  |
| skip_setup_item_restores | Unknown |  |
| skip_setup_item_screen_time | Unknown |  |
| skip_setup_item_siri | Unknown |  |
| skip_setup_item_terms_of_address | Unknown |  |
| skip_setup_item_tos | Unknown |  |
| support_email_address | Unknown |  |
| support_phone_number | Unknown |  |
| version_lock | Unknown |  |

### computer_inventory_setting_application_path

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| _fivetran_id | Unknown | PK, FK |
| path | Unknown |  |

### computer_inventory_setting_font_path

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| _fivetran_id | Unknown | PK, FK |
| path | Unknown |  |

### computer_inventory_setting_plugin_path

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| _fivetran_id | Unknown | PK, FK |
| path | Unknown |  |

### computer_inventory_setting

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| collect_synced_mobile_device_info | Unknown |  |
| computer_allow_changing_user_and_location | Unknown |  |
| computer_calculate_size | Unknown |  |
| computer_collect_unmanaged_certificate | Unknown |  |
| computer_include_account | Unknown |  |
| computer_include_font | Unknown |  |
| computer_include_hidden_account | Unknown |  |
| computer_include_package | Unknown |  |
| computer_include_plugin | Unknown |  |
| computer_include_printer | Unknown |  |
| computer_include_service | Unknown |  |
| computer_include_software_id | Unknown |  |
| computer_include_software_update | Unknown |  |
| computer_monitor_application_usage | Unknown |  |
| computer_monitor_beacon | Unknown |  |
| computer_update_ldap_info_on_computer_inventory_submission | Unknown |  |
| computer_use_unix_user_path | Unknown |  |

### department

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| name | Unknown |  |

### re_enrollment_object_history

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| date | Instant |  |
| details | Unknown |  |
| note | Unknown |  |
| username | Unknown |  |

### self_service_setting

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| configuration_setting_alert_user_approved_mdm | Unknown |  |
| configuration_setting_bookmarks_name | Unknown |  |
| configuration_setting_default_home_category_id | Unknown |  |
| configuration_setting_default_landing_page | Unknown |  |
| configuration_setting_notifications_enabled | Unknown |  |
| install_automatically | Unknown |  |
| install_location | Unknown |  |
| setting_allow_remember_me | Unknown |  |
| setting_auth_type | Unknown |  |
| setting_user_login_level | Unknown |  |

### computer_group

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| name | Unknown |  |
| smart_group | Unknown |  |

### advanced_search_object_criteria

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| advanced_search_object_id | Unknown | PK, FK |
| and_or | Unknown |  |
| closing_paren | Unknown |  |
| name | Unknown |  |
| opening_paren | Unknown |  |
| priority | Unknown |  |
| search_type | Unknown |  |
| value | Unknown |  |

### advanced_search_object_display_field

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| advanced_search_object_id | Unknown | PK, FK |
| display_field | Unknown |  |

### advanced_search_object

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| name | Unknown |  |
| site_id | Unknown |  |

### mobile_device_detail_network_section

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| network_carrier_setting_version | Unknown |  |
| network_cellular_technology | Unknown |  |
| network_current_carrier_network | Unknown |  |
| network_current_mobile_country_code | Unknown |  |
| network_current_mobile_network_code | Unknown |  |
| network_data_roaming_enabled | Unknown |  |
| network_e_id | Unknown |  |
| network_home_carrier_network | Unknown |  |
| network_home_mobile_country_code | Unknown |  |
| network_home_mobile_network_code | Unknown |  |
| network_iccid | Unknown |  |
| network_imei | Unknown |  |
| network_me_id | Unknown |  |
| network_personal_hotspot_enabled | Unknown |  |
| network_phone_number | Unknown |  |
| network_roaming | Unknown |  |
| network_voice_roaming_enabled | Unknown |  |

### supervision_identity

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| common_name | Unknown |  |
| display_name | Unknown |  |
| expiration_date | Unknown |  |

### category_history

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| date | Instant |  |
| details | Unknown |  |
| note | Unknown |  |
| username | Unknown |  |

### device_enrollment_instance

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| time_stamp | Unknown | PK |
| sync_state | Unknown |  |

### mac_os_configuration

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| application_name | Unknown |  |
| branding_header_image_id | Unknown |  |
| branding_name | Unknown |  |
| branding_name_secondary | Unknown |  |
| icon_id | Unknown |  |

### patch_software_title_configuration_history

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| date | Instant |  |
| details | Unknown |  |
| note | Unknown |  |
| username | Unknown |  |

### device_setting_history

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| date | Instant |  |
| details | Unknown |  |
| note | Unknown |  |
| username | Unknown |  |

### category

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| name | Unknown |  |
| priority | Unknown |  |

### static_user_group

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| name | Unknown |  |

### patch_policy

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| completed | Unknown |  |
| deferred | Unknown |  |
| failed | Unknown |  |
| pending | Unknown |  |
| policy_deployment_method | Unknown |  |
| policy_enabled | Unknown |  |
| policy_name | Unknown |  |
| policy_target_version | Unknown |  |
| software_title | Unknown |  |
| software_title_configuration_id | Unknown |  |

## Relationships

- device_enrollment(supervision_identity_id) → supervision_identity(id)
- server_configuration(mapping_user_id) → mapping(user_id)
- sso_host(sso_id) → sso(id)
- computer_inventory_capable_user(computer_inventory_id) → computer_inventory(id)
- computer_inventory_cache_detail(computer_inventory_id) → computer_inventory(id)
- computer_inventory_alert(computer_inventory_id) → computer_inventory(id)
- computer_value(computer_inventory_extension_index) → computer_inventory_extension(index)
- computer_value(computer_inventory_id) → computer_inventory_extension(computer_inventory_id)
- computer_option(computer_inventory_extension_index) → computer_inventory_extension(index)
- computer_option(computer_inventory_id) → computer_inventory_extension(computer_inventory_id)
- computer_inventory_extension(computer_inventory_id) → computer_inventory(id)
- computer_inventory_parent_local_network(computer_inventory_parent_id) → computer_inventory_parent(id)
- computer_inventory_parent_local_network(computer_inventory_id) → computer_inventory_parent(computer_inventory_id)
- computer_inventory_parent(computer_inventory_id) → computer_inventory(id)
- computer_inventory_software_update(computer_inventory_id) → computer_inventory(id)
- computer_inventory_attachment(computer_inventory_id) → computer_inventory(id)
- computer_inventory_ibeacon(computer_inventory_id) → computer_inventory(id)
- computer_inventory_licensed_software(computer_inventory_id) → computer_inventory(id)
- computer_inventory_font(computer_inventory_id) → computer_inventory(id)
- computer_inventory_plugin(computer_inventory_id) → computer_inventory(id)
- computer_inventory_certificate(computer_inventory_id) → computer_inventory(id)
- computer_inventory_local_user_account(computer_inventory_id) → computer_inventory(id)
- computer_inventory_service(computer_inventory_id) → computer_inventory(id)
- computer_inventory_printer(computer_inventory_id) → computer_inventory(id)
- computer_inventory_configuration_profile(computer_inventory_id) → computer_inventory(id)
- computer_inventory_disk_portition(computer_inventory_disk_id) → computer_inventory_disk(id)
- computer_inventory_disk_portition(computer_inventory_id) → computer_inventory_disk(computer_inventory_id)
- computer_inventory_disk(computer_inventory_id) → computer_inventory(id)
- computer_inventory_application(computer_inventory_id) → computer_inventory(id)
- computer_inventory_file_vault(computer_inventory_id) → computer_inventory(id)
- computer_inventory_group_membership(id) → computer_group(id)
- computer_inventory_group_membership(computer_inventory_id) → computer_inventory(id)
- computer_inventory_content_caching_data_migration_user_info(computer_inventory_id) → computer_inventory(id)
- patch_software_title_configuration_extension(patch_software_title_configuration_id) → patch_software_title_configuration(id)
- patch_software_title_configuration_package(patch_software_title_configuration_id) → patch_software_title_configuration(id)
- patch_software_title_configuration(category_id) → category(id)
- mapping(group_id) → static_group(id)
- patch_policy_log(id) → patch_policy(id)
- patch_policy_log(ignored_for_patch_policy_id) → patch_policy(id)
- cloud_identity_history(id) → cloud_identity(id)
- api_role_privilege(api_role_id) → api_role(id)
- authorization_detail_group_id(group_id) → static_group(id)
- authorization_detail_group_id(authorization_detail_account_id) → authorization_detail(account_id)
- authorization_account_group_member(authorization_detail_account_id) → authorization_detail_account_group(authorization_detail_account_id)
- authorization_account_group_member(authorization_detail_account_group_index) → authorization_detail_account_group(index)
- authorization_detail_account_group(authorization_detail_account_id) → authorization_detail(account_id)
- authorization_detail_site(authorization_detail_account_id) → authorization_detail(account_id)
- mobile_device_extension_attribute_value(mobile_device_detail_id) → mobile_device_detail_extension_attribute(mobile_device_detail_id)
- mobile_device_extension_attribute_value(mobile_device_detail_extension_attribute_id) → mobile_device_detail_extension_attribute(id)
- mobile_device_detail_extension_attribute(mobile_device_detail_id) → mobile_device_detail(id)
- mobile_device_detail_application(mobile_device_detail_id) → mobile_device_detail(id)
- mobile_device_detail_certificate(mobile_device_detail_id) → mobile_device_detail(id)
- mobile_device_detail_profile(mobile_device_detail_id) → mobile_device_detail(id)
- mobile_device_detail_user_profile(mobile_device_detail_id) → mobile_device_detail(id)
- mobile_device_detail_shared_user(mobile_device_detail_id) → mobile_device_detail(id)
- mobile_device_detail_service_subscription(mobile_device_detail_id) → mobile_device_detail(id)
- mobile_device_detail_e_book(mobile_device_detail_id) → mobile_device_detail(id)
- mobile_device_detail_provision_profile(mobile_device_detail_id) → mobile_device_detail(id)
- computer_prestage_custom_package(computer_prestage_id) → computer_prestage(id)
- computer_prestaged_installed_profile(computer_prestage_id) → computer_prestage(id)
- computer_prestage_anchor_certificate(computer_prestage_id) → computer_prestage(id)
- computer_inventory_setting_application_path(_fivetran_id) → computer_inventory_setting(_fivetran_id)
- computer_inventory_setting_font_path(_fivetran_id) → computer_inventory_setting(_fivetran_id)
- computer_inventory_setting_plugin_path(_fivetran_id) → computer_inventory_setting(_fivetran_id)
- advanced_search_object_criteria(advanced_search_object_id) → advanced_search_object(id)
- advanced_search_object_display_field(advanced_search_object_id) → advanced_search_object(id)
- mobile_device_detail_network_section(id) → mobile_device_detail(id)
- category_history(id) → category(id)
- patch_software_title_configuration_history(id) → patch_software_title_configuration(id)