# Kandji schema ERD

Table and field reference for the Fivetran Kandji connector.

## Table & Field Reference

### device_activity

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| blueprint_id | Unknown | FK |
| device_id | Unknown | FK |
| action_type | Unknown |  |
| blueprint_is_removed | Unknown |  |
| computer_is_removed | Unknown |  |
| created_at | Unknown |  |
| detail_attempt | Unknown |  |
| detail_command_type | Unknown |  |
| detail_date_completed | Unknown |  |
| detail_date_requested | Unknown |  |
| detail_error_chain | Json |  |
| detail_is_silent | Unknown |  |
| detail_last_pushed | Unknown |  |
| detail_metadata | Json |  |
| detail_priority | Unknown |  |
| detail_profile_name | Unknown |  |
| detail_profile_uuid | Unknown |  |
| detail_request_requires_network_tether | Unknown |  |
| detail_request_type | Unknown |  |
| detail_skip_retry | Unknown |  |
| detail_status | Unknown |  |
| detail_user | Unknown |  |
| detail_username | Unknown |  |
| detail_uuid | Unknown |  |
| external_token | Unknown |  |
| users | Unknown |  |

### device_app

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| device_id | Unknown | FK |
| app_name | Unknown |  |
| app_store_vendable | String |  |
| bundle_id | Unknown |  |
| bundle_size | Unknown |  |
| creation_date | Unknown |  |
| device_based_vpp | String |  |
| modification_date | Unknown |  |
| path | Unknown |  |
| process | Unknown |  |
| signature | Unknown |  |
| source | Unknown |  |
| version | Unknown |  |

### device_library_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| blueprint_id | Unknown | FK |
| device_id | Unknown | FK |
| control_log | Unknown |  |
| control_reported_at | Unknown |  |
| item_id | Unknown |  |
| last_audit_log | Unknown |  |
| last_audit_run | Unknown |  |
| log | Unknown |  |
| name | Unknown |  |
| reported_at | Unknown |  |
| rules_present | Unknown |  |
| status | Unknown |  |
| type | Unknown |  |

### device

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| blueprint_id | Unknown | FK |
| agent_installed | Unknown |  |
| agent_version | Unknown |  |
| asset_tag | Unknown |  |
| first_enrollment | Unknown |  |
| is_missing | Unknown |  |
| is_removed | Unknown |  |
| last_check_in | Unknown |  |
| last_enrollment | Unknown |  |
| lost_mode_status | String |  |
| mdm_enabled | Unknown |  |
| model | Unknown |  |
| name | Unknown |  |
| os_version | Unknown |  |
| platform | Unknown |  |
| serial_number | Unknown |  |
| user_email | Unknown |  |
| user_id | Unknown |  |
| user_is_archived | Unknown |  |
| user_name | Unknown |  |

### blueprint

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| color | Unknown |  |
| computers_count | Unknown |  |
| description | Unknown |  |
| enrollment_code | Unknown |  |
| enrollment_is_active | Unknown |  |
| icon | Unknown |  |
| missing_computers_count | Long |  |
| name | Unknown |  |
| param_** |  |  |

### mdm_device

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| device_associated_token_id | Unknown | PK, FK |
| deferred_install | Unknown |  |
| enrolled_at | Unknown |  |
| enrollment_status | Unknown |  |
| is_missing | Unknown |  |
| is_removed | Unknown |  |
| name | Unknown |  |
| status | Unknown |  |

### device_associated_token

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| blueprint_id | Unknown | FK |
| list_ade_id | Unknown | FK |
| asset_tag | Unknown |  |
| assignment_status_received_at | Unknown |  |
| color | Unknown |  |
| dep_account_id | Unknown |  |
| dep_account_server_name | Unknown |  |
| description | Unknown |  |
| device_assigned_by | Unknown |  |
| device_assigned_date | Unknown |  |
| device_family | Unknown |  |
| failed_assignment_attempts | Unknown |  |
| last_assignment_status | Unknown |  |
| model | Unknown |  |
| os | Unknown |  |
| profile_assign_time | Unknown |  |
| profile_push_time | Unknown |  |
| profile_status | Unknown |  |
| serial_number | Unknown |  |
| users | Unknown |  |

### device_parameter

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| device_id | Unknown | FK |
| category | Unknown |  |
| name | Unknown |  |
| status | Unknown |  |
| subcategory | Unknown |  |

### list_ade

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| access_token_expiry | Unknown |  |
| admin_id | Unknown |  |
| blueprint_id | Unknown |  |
| days_left | Unknown |  |
| default_email | Unknown |  |
| default_phone | Unknown |  |
| device_count_apple_tv | Long |  |
| device_count_ipad | Unknown |  |
| device_count_iphone | Unknown |  |
| device_count_mac | Unknown |  |
| device_count_total | Unknown |  |
| last_device_sync | Unknown |  |
| organization_address | Unknown |  |
| organization_email | Unknown |  |
| organization_name | Unknown |  |
| organization_phone | Unknown |  |
| organization_type | Unknown |  |
| server_name | Unknown |  |
| server_uuid | Unknown |  |
| status | Unknown |  |
| status_reason | String |  |
| status_received_at | Unknown |  |
| stoken_file_name | Unknown |  |

### blueprint_result_template

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| blueprint_result_id | Unknown | PK, FK |
| category | Unknown |  |
| color | Unknown |  |
| description | Unknown |  |
| icon | Unknown |  |
| name | Unknown |  |
| rating | Unknown |  |
| param_** |  |  |

### blueprint_result

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

## Relationships

- device_activity(blueprint_id) → blueprint(id)
- device_activity(device_id) → device(id)
- device_app(device_id) → device(id)
- device_library_item(blueprint_id) → blueprint(id)
- device_library_item(device_id) → device(id)
- device(blueprint_id) → blueprint(id)
- mdm_device(device_associated_token_id) → device_associated_token(id)
- device_associated_token(blueprint_id) → blueprint(id)
- device_associated_token(list_ade_id) → list_ade(id)
- device_parameter(device_id) → device(id)
- blueprint_result_template(blueprint_result_id) → blueprint_result(id)