Microsoft Entra ID

Explore the interactive ERD

Table & Field Reference

directory_role_member

Column	Type	Keys
`directory_role_id`	Unknown	PKFK
`user_id`	Unknown	PKFK

channel

Column	Type	Keys
`id`	Unknown	PK
`team_id`	Unknown	PKFK
`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	PKFK
`directory_audit_target_resource_index`	Unknown	PKFK
`display_name`	Unknown
`new_value`	Unknown
`old_value`	Unknown

directory_audit_target_resource

Column	Type	Keys
`index`	Unknown	PK
`directory_audit_id`	Unknown	PKFK
`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	PKFK
`user_id`	Unknown	PKFK

sign_in_applied_conditional_access_policy

Column	Type	Keys
`id`	Unknown	PK
`sign_in_id`	Unknown	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`role`	Unknown

team_member

Column	Type	Keys
`id`	Unknown	PK
`team_id`	Unknown	PKFK
`user_id`	Unknown	FK
`display_name`	Unknown
`email`	Unknown
`odata_type`	Unknown

group_proxy_address

Column	Type	Keys
`index`	Unknown	PK
`group_id`	Unknown	PKFK
`proxy_address`	Unknown

group_type

Column	Type	Keys
`index`	Unknown	PK
`group_id`	Unknown	PKFK
`group_type`	Unknown

group_resource_provisioning_option

Column	Type	Keys
`index`	Unknown	PK
`group_id`	Unknown	PKFK
`resource_provisioning_option`	Unknown

group_resource_behaviour_option

Column	Type	Keys
`index`	Unknown	PK
`group_id`	Unknown	PKFK
`resource_behaviour_option`	Unknown

group_on_premise_provisioning_error

Column	Type	Keys
`index`	Unknown	PK
`group_id`	Unknown	PKFK
`on_premises_provisioning_errors`	Unknown

group_creation_option

Column	Type	Keys
`index`	Unknown	PK
`group_id`	Unknown	PKFK
`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	PKFK
`category`	Unknown

application_template_sso_mode

Column	Type	Keys
`index`	Unknown	PK
`application_template_id`	Unknown	PKFK
`sso_mode`	Unknown

application_template_endpoint

Column	Type	Keys
`index`	Unknown	PK
`application_template_id`	Unknown	PKFK
`endpoint`	Unknown

application_template_provisioning_type

Column	Type	Keys
`index`	Unknown	PK
`application_template_id`	Unknown	PKFK
`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	PKFK
`capability_status`	Unknown
`provisioning_status`	Unknown
`service`	Unknown

user_assigned_license

Column	Type	Keys
`id`	Unknown	PK
`user_id`	Unknown	PKFK
`disabled_plan`	Json

user_assigned_plan

Column	Type	Keys
`id`	Unknown	PK
`user_id`	Unknown	PKFK
`assigned_date_time`	Unknown
`capability_status`	Unknown
`service`	Unknown

user_identity

Column	Type	Keys
`index`	Unknown	PK
`user_id`	Unknown	PKFK
`id`	Unknown
`issuer`	Unknown
`sign_in_type`	Unknown

user_license_assignment_state

Column	Type	Keys
`id`	Unknown	PKFK
`user_id`	Unknown	PKFK
`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	PKFK
`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	PKFK
`applies_to`	Unknown
`provisioning_status`	Unknown
`service_plan_name`	Unknown

license

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

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