# Microsoft Entra ID schema ERD

Table and field reference for the Fivetran Microsoft Entra ID connector.

## Table & Field Reference

### directory_role_member

| Column | Type | Keys |
| --- | --- | --- |
| directory_role_id | Unknown | PK, FK |
| user_id | Unknown | PK, FK |

### channel

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| team_id | Unknown | PK, FK |
| created_date_time | Unknown |  |
| description | Unknown |  |
| display_name | Unknown |  |
| membership_type | Unknown |  |

### directory_audit_target_resource_modified_property

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| directory_audit_id | Unknown | PK, FK |
| directory_audit_target_resource_index | Unknown | PK, FK |
| display_name | Unknown |  |
| new_value | Unknown |  |
| old_value | Unknown |  |

### directory_audit_target_resource

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| directory_audit_id | Unknown | PK, FK |
| display_name | Unknown |  |
| group_type | Unknown |  |
| id | Unknown |  |
| type | Unknown |  |
| user_principal_name | Unknown |  |

### directory_audit

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| initiated_by_user_id | Unknown | FK |
| activity_date_time | Unknown |  |
| activity_display_name | Unknown |  |
| category | Unknown |  |
| correlation_id | Unknown |  |
| initiated_by_app | Unknown |  |
| logged_by_service | Unknown |  |
| result | Unknown |  |
| result_reason | Unknown |  |
| custom_** |  |  |

### group_owner

| Column | Type | Keys |
| --- | --- | --- |
| group_id | Unknown | PK, FK |
| user_id | Unknown | PK, FK |

### sign_in_applied_conditional_access_policy

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| sign_in_id | Unknown | PK, FK |
| display_name | Unknown |  |
| enforced_grant_control | Json |  |
| enforced_session_control | Json |  |
| result | Unknown |  |

### sign_in

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_id | Unknown | FK |
| app_display_name | Unknown |  |
| app_id | Unknown |  |
| client_app_used | Unknown |  |
| conditional_access_status | Unknown |  |
| correlation_id | Unknown |  |
| created_date_time | Unknown |  |
| geo_coordinate_altitude | Unknown |  |
| geo_coordinate_latitude | Unknown |  |
| geo_coordinate_longitude | Unknown |  |
| ip_address | Unknown |  |
| is_interactive | Unknown |  |
| resource_display_name | Unknown |  |
| resource_id | Unknown |  |
| risk_detail | Unknown |  |
| risk_event_type | Json |  |
| risk_level_aggregated | Unknown |  |
| risk_level_during_sign_in | Unknown |  |
| risk_state | Unknown |  |

### user_registration_detail

| Column | Type | Keys |
| --- | --- | --- |
| user_id | Unknown | PK, FK |
| is_admin | Unknown |  |
| is_mfa_capable | Unknown |  |
| is_mfa_registered | Unknown |  |
| is_passwordless_capable | Unknown |  |
| is_sspr_enabled | Unknown |  |
| is_sspr_registered | Unknown |  |
| is_system_preferred_authentication_enabled | Unknown |  |
| last_updated_date_time | Unknown |  |
| methods_registered | Json |  |
| system_preferred_authentication_methods | Json |  |
| user_preferred_secondary_authentication_method | Unknown |  |

### manager

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_id | Unknown | PK, FK |
| business_phones | Json |  |
| display_name | Unknown |  |
| given_name | Unknown |  |
| job_title | Unknown |  |
| mail | Unknown |  |
| mobile_phone | Unknown |  |
| office_location | Unknown |  |
| preferred_language | Unknown |  |
| surname | Unknown |  |
| user_principal_name | Unknown |  |

### team_member_role

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| team_member_id | Unknown | PK, FK |
| role | Unknown |  |

### team_member

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| team_id | Unknown | PK, FK |
| user_id | Unknown | FK |
| display_name | Unknown |  |
| email | Unknown |  |
| odata_type | Unknown |  |

### group_proxy_address

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

### group_type

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

### group_resource_provisioning_option

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

### group_resource_behaviour_option

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

### group_on_premise_provisioning_error

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

### group_creation_option

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

### groups

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| allow_external_senders | Unknown |  |
| assigned_labels | Unknown |  |
| assigned_licenses | Unknown |  |
| auto_subscribe_new_members | Unknown |  |
| classification | Unknown |  |
| created_date_time | Unknown |  |
| deleted_date_time | Unknown |  |
| description | Unknown |  |
| display_name | Unknown |  |
| expiration_date_time | Unknown |  |
| hide_from_address_lists | Unknown |  |
| hide_from_outlook_clients | Unknown |  |
| is_archived | Unknown |  |
| is_assignable_to_role | Unknown |  |
| is_subscribed_by_mail | Unknown |  |
| license_processing_state | Unknown |  |
| mail | Unknown |  |
| mail_enabled | Unknown |  |
| mail_nickname | Unknown |  |
| membership_rule | Unknown |  |
| membership_rule_processing_state | Unknown |  |
| on_premises_domain_name | Unknown |  |
| on_premises_last_sync_date_time | Unknown |  |
| on_premises_net_bios_name | Unknown |  |
| on_premises_sam_account_name | Unknown |  |
| on_premises_security_identifier | Unknown |  |
| on_premises_sync_enabled | Unknown |  |
| preferred_data_location | Unknown |  |
| preferred_language | Unknown |  |
| renewed_date_time | Unknown |  |
| security_enabled | Unknown |  |
| security_identifier | Unknown |  |
| service_provisioning_error | Unknown |  |
| theme | Unknown |  |
| visibility | Unknown |  |

### team

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

### application_template_category

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| application_template_id | Unknown | PK, FK |
| category | Unknown |  |

### application_template_sso_mode

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| application_template_id | Unknown | PK, FK |
| sso_mode | Unknown |  |

### application_template_endpoint

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| application_template_id | Unknown | PK, FK |
| endpoint | Unknown |  |

### application_template_provisioning_type

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| application_template_id | Unknown | PK, FK |
| provisioning_type | Unknown |  |

### application_template

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| deprecation_date | Unknown |  |
| description | Unknown |  |
| display_name | Unknown |  |
| home_page_url | Unknown |  |
| is_entra_integrated | Unknown |  |
| last_modified_date_time | Instant |  |
| logo_url | Unknown |  |
| publisher | Unknown |  |
| risk_factors | Json |  |
| risk_score_compliance | Unknown |  |
| risk_score_legal | Unknown |  |
| risk_score_provider | Unknown |  |
| risk_score_security | Unknown |  |
| risk_score_total | Unknown |  |

### user_provisioned_plan

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| user_id | Unknown | PK, FK |
| capability_status | Unknown |  |
| provisioning_status | Unknown |  |
| service | Unknown |  |

### user_assigned_license

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_id | Unknown | PK, FK |
| disabled_plan | Json |  |

### user_assigned_plan

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_id | Unknown | PK, FK |
| assigned_date_time | Unknown |  |
| capability_status | Unknown |  |
| service | Unknown |  |

### user_identity

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| user_id | Unknown | PK, FK |
| id | Unknown |  |
| issuer | Unknown |  |
| sign_in_type | Unknown |  |

### user_license_assignment_state

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| user_id | Unknown | PK, FK |
| assigned_by_group | Unknown |  |
| disabled_plan | Json |  |
| error | Unknown |  |
| last_updated_date_time | Unknown |  |
| state | Unknown |  |

### on_premise_attribute_custom

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| user_id | Unknown | PK, FK |
| value | Unknown |  |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| about_me | Unknown |  |
| account_enabled | Unknown |  |
| age_group | Unknown |  |
| birthday | Unknown |  |
| business_phones | Unknown |  |
| city | Unknown |  |
| company_name | Unknown |  |
| consent_provided_for_minor | Unknown |  |
| country | Unknown |  |
| created_date_time | Instant |  |
| creation_type | Unknown |  |
| deleted_date_time | Unknown |  |
| department | Unknown |  |
| display_name | Unknown |  |
| employee_hire_date | Unknown |  |
| employee_id | Unknown |  |
| employee_leave_date_time | Unknown |  |
| employee_org_data | Unknown |  |
| employee_type | Unknown |  |
| external_user_state | Unknown |  |
| external_user_state_change_date_time | Unknown |  |
| fax_number | Unknown |  |
| given_name | Unknown |  |
| hire_date | Unknown |  |
| im_addresses | Unknown |  |
| interests | Unknown |  |
| is_resource_account | Unknown |  |
| job_title | Unknown |  |
| last_password_change_date_time | Unknown |  |
| legal_age_group_classification | Unknown |  |
| mail | Unknown |  |
| mail_nick_name | Unknown |  |
| mobile_phone | Unknown |  |
| my_site | Unknown |  |
| office_location | Unknown |  |
| on_premises_distinguished_name | Unknown |  |
| on_premises_domain_name | Unknown |  |
| on_premises_immutable_id | Unknown |  |
| on_premises_last_sync_date_time | Unknown |  |
| on_premises_provisioning_errors | Unknown |  |
| on_premises_sam_account_name | Unknown |  |
| on_premises_security_identifier | Unknown |  |
| on_premises_sync_enabled | Unknown |  |
| on_premises_user_principal_name | Unknown |  |
| other_mails | Json |  |
| password_policies | Unknown |  |
| past_projects | Unknown |  |
| postal_code | Unknown |  |
| preferred_data_location | Unknown |  |
| preferred_language | Unknown |  |
| preferred_name | Unknown |  |
| profile_force_change_password_next_sign_in | Unknown |  |
| profile_force_change_password_next_sign_in_with_mfa | Unknown |  |
| profile_password | Unknown |  |
| proxy_addresses | Json |  |
| refresh_tokens_valid_from_date_time | Unknown |  |
| responsibilities | Unknown |  |
| schools | Unknown |  |
| show_in_address_list | Unknown |  |
| sign_in_sessions_valid_from_date_time | Unknown |  |
| skills | Unknown |  |
| state | Unknown |  |
| street_address | Unknown |  |
| surname | Unknown |  |
| usage_location | Unknown |  |
| user_principal_name | Unknown |  |
| user_type | Unknown |  |

### license_service_plan

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| license_id | Unknown | PK, FK |
| applies_to | Unknown |  |
| provisioning_status | Unknown |  |
| service_plan_name | Unknown |  |

### license

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_id | Unknown | PK, FK |
| sku_id | Unknown |  |
| sku_part_number | Unknown |  |

### directory_role

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| deleted_date_time | Unknown |  |
| description | Unknown |  |
| display_name | Unknown |  |
| role_template_id | Unknown |  |

### group_member

| Column | Type | Keys |
| --- | --- | --- |
| group_id | Unknown | PK, FK |
| user_id | Unknown | PK, FK |

### device_install_status_by_app

| Column | Type | Keys |
| --- | --- | --- |
| application_id | Unknown | PK |
| device_id | Unknown | PK |
| user_id | Unknown | FK |
| app_install_state | Unknown |  |
| app_install_state_details | Unknown |  |
| app_version | Unknown |  |
| assignment_filter_ids_exist | Unknown |  |
| device_name | Unknown |  |
| error_code | Unknown |  |
| hex_error_code | Unknown |  |
| install_state | Unknown |  |
| install_state_details | Unknown |  |
| last_modified_date_time | Unknown |  |
| platform | Unknown |  |
| user_name | Unknown |  |
| user_principal_name | Unknown |  |

## Relationships

- directory_role_member(user_id) → users(id)
- directory_role_member(directory_role_id) → directory_role(id)
- channel(team_id) → team(id)
- directory_audit_target_resource_modified_property(directory_audit_id) → directory_audit_target_resource(directory_audit_id)
- directory_audit_target_resource_modified_property(directory_audit_target_resource_index) → directory_audit_target_resource(index)
- directory_audit_target_resource(directory_audit_id) → directory_audit(id)
- directory_audit(initiated_by_user_id) → users(id)
- group_owner(user_id) → users(id)
- group_owner(group_id) → groups(id)
- sign_in_applied_conditional_access_policy(sign_in_id) → sign_in(id)
- sign_in(user_id) → users(id)
- user_registration_detail(user_id) → users(id)
- manager(user_id) → users(id)
- team_member_role(team_member_id) → team_member(id)
- team_member(user_id) → users(id)
- team_member(team_id) → team(id)
- group_proxy_address(group_id) → groups(id)
- group_type(group_id) → groups(id)
- group_resource_provisioning_option(group_id) → groups(id)
- group_resource_behaviour_option(group_id) → groups(id)
- group_on_premise_provisioning_error(group_id) → groups(id)
- group_creation_option(group_id) → groups(id)
- application_template_category(application_template_id) → application_template(id)
- application_template_sso_mode(application_template_id) → application_template(id)
- application_template_endpoint(application_template_id) → application_template(id)
- application_template_provisioning_type(application_template_id) → application_template(id)
- user_provisioned_plan(user_id) → users(id)
- user_assigned_license(user_id) → users(id)
- user_assigned_plan(user_id) → users(id)
- user_identity(user_id) → users(id)
- user_license_assignment_state(id) → license(sku_id)
- user_license_assignment_state(user_id) → users(id)
- on_premise_attribute_custom(user_id) → users(id)
- license_service_plan(license_id) → license(id)
- license(user_id) → users(id)
- group_member(user_id) → users(id)
- group_member(group_id) → groups(id)
- device_install_status_by_app(user_id) → users(id)