Microsoft Teams

Explore the interactive ERD

Table & Field Reference

session_media_stream

Column	Type	Keys
`id`	Unknown	PK
`call_id`	Unknown	PKFK
`session_id`	Unknown	PKFK
`session_media_index`	Unknown	PKFK
`audio_codec`	Unknown
`average_audio_degradation`	Unknown
`average_audio_network_jitter`	Unknown
`average_bandwidth_estimate`	Unknown
`average_freeze_duration`	Unknown
`average_jitter`	Unknown
`average_packet_loss_rate`	Unknown
`average_ratio_of_concealed_samples`	Unknown
`average_received_frame_rate`	Unknown
`average_round_trip_time`	Unknown
`average_video_frame_loss_percentage`	Unknown
`average_video_frame_rate`	Unknown
`average_video_packet_loss_rate`	Unknown
`end_date_time`	Unknown
`is_audio_forward_error_correction_used`	Unknown
`low_frame_rate_ratio`	Unknown
`low_video_processing_capability_ratio`	Unknown
`max_audio_network_jitter`	Unknown
`max_jitter`	Unknown
`max_packet_loss_rate`	Unknown
`max_ratio_of_concealed_samples`	Unknown
`max_round_trip_time`	Unknown
`packet_utilization`	Unknown
`post_forward_error_correction_packet_loss_rate`	Unknown
`rms_freeze_duration`	Unknown
`start_date_time`	Unknown
`stream_direction`	Unknown
`video_codec`	Unknown
`was_media_bypassed`	Unknown

session_media

Column	Type	Keys
`index`	Unknown	PK
`call_id`	Unknown	PKFK
`session_id`	Unknown	PKFK
`callee_device_capture_device_driver`	Unknown
`callee_device_capture_device_name`	Unknown
`callee_device_capture_not_functioning_event_ratio`	Unknown
`callee_device_clipping_event_ratio`	Unknown
`callee_device_cpu_insufficient_event_ratio`	Unknown
`callee_device_glitch_event_ratio`	Unknown
`callee_device_howling_event_count`	Unknown
`callee_device_initial_signal_level_rootmean_square`	Unknown
`callee_device_low_speech_level_event_ratio`	Unknown
`callee_device_low_speech_to_noise_event_ratio`	Unknown
`callee_device_mic_glitch_rate`	Unknown
`callee_device_received_noise_level`	Unknown
`callee_device_received_signal_level`	Unknown
`callee_device_render_device_driver`	Unknown
`callee_device_render_device_name`	Unknown
`callee_device_render_mute_event_ratio`	Unknown
`callee_device_render_not_functioning_event_ratio`	Unknown
`callee_device_render_zero_volume_event_ratio`	Unknown
`callee_device_sent_noise_level`	Unknown
`callee_device_sent_signal_level`	Unknown
`callee_device_speaker_glitch_rate`	Unknown
`callee_network_bandwidth_low_event_ratio`	Unknown
`callee_network_basic_service_set_identifier`	Unknown
`callee_network_connection_type`	Unknown
`callee_network_delay_event_ratio`	Unknown
`callee_network_dns_suffix`	Unknown
`callee_network_ip_address`	Unknown
`callee_network_link_speed`	Unknown
`callee_network_mac_address`	Unknown
`callee_network_port`	Unknown
`callee_network_received_quality_event_ratio`	Unknown
`callee_network_reflexive_ip_address`	Unknown
`callee_network_replay_ip_address`	Unknown
`callee_network_replay_port`	Unknown
`callee_network_sent_quality_event_ratio`	Unknown
`callee_network_subnet`	Unknown
`callee_network_trace_route_hops`	Json
`callee_network_transport_protocol`	Unknown
`callee_network_wifi_band`	Unknown
`callee_network_wifi_battery_charge`	Unknown
`callee_network_wifi_channel`	Unknown
`callee_network_wifi_microsoft_driver`	Unknown
`callee_network_wifi_microsoft_driver_version`	Unknown
`callee_network_wifi_radio_type`	Unknown
`callee_network_wifi_signal_stength`	Unknown
`callee_network_wifi_vendor_driver`	Unknown
`callee_network_wifi_vendor_driver_version`	Unknown
`caller_device_capture_device_driver`	Unknown
`caller_device_capture_device_name`	Unknown
`caller_device_capture_not_functioning_event_ratio`	Unknown
`caller_device_clipping_event_ratio`	Unknown
`caller_device_cpu_insufficient_event_ratio`	Unknown
`caller_device_glitch_event_ratio`	Unknown
`caller_device_howling_event_count`	Unknown
`caller_device_initial_signal_level_rootmean_square`	Unknown
`caller_device_low_speech_level_event_ratio`	Unknown
`caller_device_low_speech_to_noise_event_ratio`	Unknown
`caller_device_mic_glitch_rate`	Unknown
`caller_device_received_noise_level`	Unknown
`caller_device_received_signal_level`	Unknown
`caller_device_render_device_driver`	Unknown
`caller_device_render_device_name`	Unknown
`caller_device_render_mute_event_ratio`	Unknown
`caller_device_render_not_functioning_event_ratio`	Unknown
`caller_device_render_zero_volume_event_ratio`	Unknown
`caller_device_sent_noise_level`	Unknown
`caller_device_sent_signal_level`	Unknown
`caller_device_speaker_glitch_rate`	Unknown
`caller_network_bandwidth_low_event_ratio`	Unknown
`caller_network_basic_service_set_identifier`	Unknown
`caller_network_connection_type`	Unknown
`caller_network_delay_event_ratio`	Unknown
`caller_network_dns_suffix`	Unknown
`caller_network_ip_address`	Unknown
`caller_network_link_speed`	Unknown
`caller_network_mac_address`	Unknown
`caller_network_port`	Unknown
`caller_network_received_quality_event_ratio`	Unknown
`caller_network_reflexive_ip_address`	Unknown
`caller_network_replay_ip_address`	Unknown
`caller_network_replay_port`	Unknown
`caller_network_sent_quality_event_ratio`	Unknown
`caller_network_subnet`	Unknown
`caller_network_trace_route_hops`	Json
`caller_network_transport_protocol`	Unknown
`caller_network_wifi_band`	Unknown
`caller_network_wifi_battery_charge`	Unknown
`caller_network_wifi_channel`	Unknown
`caller_network_wifi_microsoft_driver`	Unknown
`caller_network_wifi_microsoft_driver_version`	Unknown
`caller_network_wifi_radio_type`	Unknown
`caller_network_wifi_signal_stength`	Unknown
`caller_network_wifi_vendor_driver`	Unknown
`caller_network_wifi_vendor_driver_version`	Unknown
`label`	Unknown

session

Column	Type	Keys
`id`	Unknown	PK
`call_id`	Unknown	PKFK
`callee_asssociated_identity_display_name`	Unknown
`callee_asssociated_identity_id`	Unknown
`callee_asssociated_identity_odata_type`	Unknown
`callee_asssociated_identity_tenant_id`	Unknown
`callee_cpu_cores_count`	Unknown
`callee_cpu_name`	Unknown
`callee_cpu_processor_spped_in_mhz`	Unknown
`callee_feedback_rating`	Unknown
`callee_identity_acs_application_instance`	Unknown
`callee_identity_acs_user`	Unknown
`callee_identity_application`	Unknown
`callee_identity_application_instance`	Unknown
`callee_identity_device`	Unknown
`callee_identity_encrypted`	Unknown
`callee_identity_guest`	Unknown
`callee_identity_on_premises`	Unknown
`callee_identity_phone_display_name`	Unknown
`callee_identity_phone_id`	Unknown
`callee_identity_phone_tenant_id`	Unknown
`callee_identity_spool_application_instance`	Unknown
`callee_identity_spool_user`	Unknown
`callee_identity_user`	Unknown
`callee_name`	Unknown
`callee_odata_type`	Unknown
`callee_user_agent_application_version`	Unknown
`callee_user_agent_azure_ad_app_id`	Unknown
`callee_user_agent_communication_service_id`	Unknown
`callee_user_agent_header_value`	Unknown
`callee_user_agent_odata_type`	Unknown
`callee_user_agent_platform`	Unknown
`callee_user_agent_product_family`	Unknown
`caller_asssociated_identity_display_name`	Unknown
`caller_asssociated_identity_id`	Unknown
`caller_asssociated_identity_odata_type`	Unknown
`caller_asssociated_identity_tenant_id`	Unknown
`caller_asssociated_identity_user_principal_name`	Unknown
`caller_cpu_cores_count`	Unknown
`caller_cpu_name`	Unknown
`caller_cpu_processor_spped_in_mhz`	Unknown
`caller_feedback_rating`	Unknown
`caller_identity_user_display_name`	Unknown
`caller_identity_user_id`	Unknown
`caller_identity_user_tenant_id`	Unknown
`caller_indentity_acs_application_instance`	Unknown
`caller_indentity_acs_user`	Unknown
`caller_indentity_application`	Unknown
`caller_indentity_application_instance`	Unknown
`caller_indentity_device`	Unknown
`caller_indentity_encrypted`	Unknown
`caller_indentity_guest`	Unknown
`caller_indentity_on_premises`	Unknown
`caller_indentity_phone`	Unknown
`caller_indentity_spool_application_instance`	Unknown
`caller_indentity_spool_user`	Unknown
`caller_name`	Unknown
`caller_odata_type`	Unknown
`caller_user_agent_application_version`	Unknown
`caller_user_agent_azure_ad_app_id`	Unknown
`caller_user_agent_communication_service_id`	Unknown
`caller_user_agent_header_value`	Unknown
`caller_user_agent_odata_type`	Unknown
`caller_user_agent_platform`	Unknown
`caller_user_agent_product_family`	Unknown
`end_date_time`	Unknown
`failure_information`	Unknown
`feedback_token_distorted_sound`	Unknown
`feedback_token_echo`	Unknown
`feedback_token_interruption`	Unknown
`feedback_token_low_value`	Unknown
`feedback_token_no_sound`	Unknown
`feedback_token_noisy`	Unknown
`feedback_token_other_no_sound`	Unknown
`feedback_token_stopped`	Unknown
`is_test`	Unknown
`modalities`	Json
`segment_odata_context`	Unknown
`start_date_time`	Unknown

pstn_call

Column	Type	Keys
`id`	Unknown	PK
`call_duration_source`	Unknown
`call_id`	Unknown
`call_type`	Unknown
`callee_number`	Unknown
`caller_number`	Unknown
`charge`	Unknown
`conference_id`	Unknown
`connection_charge`	Unknown
`currency`	Unknown
`destination_context`	Unknown
`destination_name`	Unknown
`duration`	Unknown
`end_date_time`	Unknown
`inventory_type`	Unknown
`license_capability`	Unknown
`operator`	Unknown
`start_date_time`	Unknown
`tenant_country_code`	Unknown
`usage_country_code`	Unknown
`user_display_name`	Unknown
`user_id`	Unknown
`user_principal_name`	Unknown

channel

Column	Type	Keys
`id`	Unknown	PK
`team_id`	Unknown	PKFK
`created_date_time`	Instant
`description`	Unknown
`display_name`	Unknown
`email`	Unknown
`is_favorite_by_default`	Unknown
`membership_type`	Unknown
`moderation_settings`	Unknown
`web_url`	Unknown

team

Column	Type	Keys
`id`	Unknown	PK
`classification`	Unknown
`created_date_time`	Instant
`description`	Unknown
`discovery_settings`	Unknown
`display_name`	Unknown
`fun_settings`	Unknown
`guest_settings`	Unknown
`internal_id`	Unknown
`is_archived`	Unknown
`is_membership_limited_to_owners`	Unknown
`member_settings`	Unknown
`messaging_settings`	Unknown
`specialization`	Unknown
`summary`	Unknown
`tag_settings`	Unknown
`tenant_id`	Unknown
`visibility`	Unknown
`web_url`	Unknown

chat_message

Column	Type	Keys
`id`	String	PK
`chat_id`	String	PKFK
`attachments`	Json
`body`	Json
`channel_identity`	Json
`created_date_time`	Instant
`deleted_date_time`	Instant
`etag`	String
`event_detail`	Json
`from_application`	Unknown
`from_device`	Unknown
`from_user_display_name`	Unknown
`from_user_id`	Unknown
`from_user_identity_type`	Unknown
`importance`	String
`last_edited_date_time`	Instant
`last_modified_date_time`	Instant
`locale`	String
`mentions`	Json
`message_history`	Json
`message_type`	String
`on_behalf_of`	Json
`policy_violation`	Json
`reactions`	Json
`reply_to_id`	String
`subject`	String
`summary`	String
`web_url`	String

channel_message_reaction

Column	Type	Keys
`reaction_type`	Unknown	PK
`user_id`	Unknown	PK
`channel_id`	Unknown	PKFK
`channel_message_id`	Unknown	PKFK
`team_id`	Unknown	PKFK
`created_date_time`	Instant
`user_display_name`	Unknown
`user_identity_type`	Unknown

channel_message_mention

Column	Type	Keys
`id`	Unknown	PK
`channel_id`	Unknown	PKFK
`channel_message_id`	Unknown	PKFK
`team_id`	Unknown	PKFK
`mention_text`	Unknown
`mentioned_application`	Unknown
`mentioned_conversation`	Unknown
`mentioned_device`	Unknown
`mentioned_user_display_name`	Unknown
`mentioned_user_id`	Unknown
`mentioned_user_identity_type`	Unknown

channel_message_reply_reaction

Column	Type	Keys
`reaction_type`	Unknown	PK
`user_id`	Unknown	PK
`channel_id`	Unknown	PKFK
`channel_message_id`	Unknown	PKFK
`channel_message_reply_id`	Unknown	PKFK
`team_id`	Unknown	PKFK
`created_date_time`	Instant
`user_display_name`	Unknown
`user_identity_type`	Unknown

channel_message_reply_mention

Column	Type	Keys
`id`	Unknown	PK
`channel_id`	Unknown	PKFK
`channel_message_id`	Unknown	PKFK
`channel_message_reply_id`	Unknown	PKFK
`team_id`	Unknown	PKFK
`mention_text`	Unknown
`mentioned_application`	Unknown
`mentioned_device`	Unknown
`mentioned_user_display_name`	Unknown
`mentioned_user_id`	Unknown
`mentioned_user_identity_type`	Unknown

channel_message_reply

Column	Type	Keys
`id`	Unknown	PK
`channel_id`	Unknown	PKFK
`channel_message_id`	Unknown	PKFK
`team_id`	Unknown	PKFK
`attachments`	Json
`body_content`	Unknown
`body_content_type`	Unknown
`channel_identity_channel_id`	Unknown
`channel_identity_team_id`	Unknown
`chat_id`	Unknown
`created_date_time`	Instant
`deleted_date_time`	Instant
`etag`	Unknown
`event_detail`	Json
`from_application`	Unknown
`from_device`	Unknown
`from_user_display_name`	Unknown
`from_user_id`	Unknown
`from_user_tenant_id`	Unknown
`from_user_user_identity_type`	Unknown
`importance`	Unknown
`last_edited_date_time`	Instant
`last_modified_date_time`	Instant
`locale`	Unknown
`message_history`	Json
`message_type`	Unknown
`policy_violation`	Json
`reply_to_id`	Unknown
`subject`	Unknown
`summary`	Unknown
`web_url`	Unknown

channel_message

Column	Type	Keys
`id`	Unknown	PK
`channel_id`	Unknown	PKFK
`team_id`	Unknown	PKFK
`attachments`	Json
`body_content`	Unknown
`body_content_type`	Unknown
`channel_identity_channel_id`	Unknown
`channel_identity_team_id`	Unknown
`chat_id`	Unknown
`created_date_time`	Instant
`deleted_date_time`	Instant
`etag`	Unknown
`event_detail`	Json
`from_application`	Unknown
`from_device`	Unknown
`from_user_display_name`	Unknown
`from_user_id`	Unknown
`from_user_user_identity_type`	Unknown
`importance`	Unknown
`last_edited_date_time`	Instant
`last_modified_date_time`	Instant
`locale`	Unknown
`message_history`	Json
`message_type`	Unknown
`policy_violation`	Json
`reply_to_id`	Unknown
`subject`	Unknown
`summary`	Unknown
`web_url`	Unknown

participant

Column	Type	Keys
`id`	Unknown	PK
`call_id`	Unknown	PKFK
`administrarive_unit_info`	Json
`identity_acs_application_instance`	Unknown
`identity_acs_user`	Unknown
`identity_application`	Unknown
`identity_application_instance`	Unknown
`identity_asserted`	Unknown
`identity_azure_communication_service_user`	Unknown
`identity_device`	Unknown
`identity_encrypted`	Unknown
`identity_endpoint_type`	Unknown
`identity_guest`	Unknown
`identity_on_premises`	Unknown
`identity_phone_display_name`	Unknown
`identity_phone_id`	Unknown
`identity_phone_odata_type`	Unknown
`identity_phone_tenant_id`	Unknown
`identity_spool_application_instance`	Unknown
`identity_spool_user`	Unknown
`identity_user_display_name`	Unknown
`identity_user_id`	Unknown
`identity_user_odata_type`	Unknown
`identity_user_principal_name`	Unknown
`identity_user_tenant_id`	Unknown

users

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

call

Column	Type	Keys
`id`	Unknown	PK
`end_date_time`	Unknown
`join_web_url`	Unknown
`last_modified_date_time`	Unknown
`modalites`	Json
`organizer_administrative_unit_information`	Json
`organizer_data_context`	Unknown
`organizer_id`	Unknown
`organizer_idenity_acs_application_instance`	Unknown
`organizer_idenity_acs_user`	Unknown
`organizer_idenity_application`	Unknown
`organizer_idenity_application_instance`	Unknown
`organizer_idenity_asserted_identity`	Unknown
`organizer_idenity_azure_communication_service_user`	Unknown
`organizer_idenity_device`	Unknown
`organizer_idenity_encrypted`	Unknown
`organizer_idenity_endpoint_type`	Unknown
`organizer_idenity_guest`	Unknown
`organizer_idenity_on_premises`	Unknown
`organizer_idenity_spool_application_instance`	Unknown
`organizer_idenity_spool_user`	Unknown
`organizer_identity_phone_display_name`	Unknown
`organizer_identity_phone_id`	Unknown
`organizer_identity_phone_odata_type`	Unknown
`organizer_identity_phone_tenant_id`	Unknown
`organizer_identity_user_display_name`	Unknown
`organizer_identity_user_id`	Unknown
`organizer_identity_user_odata_type`	Unknown
`organizer_identity_user_principal_name`	Unknown
`organizer_identity_user_tenant_id`	Unknown
`start_date_time`	Unknown
`type`	Unknown
`version`	Unknown

chat

Column	Type	Keys
`id`	String	PK
`users_id`	Unknown	PKFK
`chat_type`	String
`created_date_time`	Instant
`last_updated_date_time`	Instant
`members`	Json
`online_meeting_info`	Json
`tenant_id`	String
`topic`	String
`viewpoint`	Json
`web_url`	String

direct_routing_call

Column	Type	Keys
`id`	Unknown	PK
`call_end_sub_reason`	Unknown
`call_type`	Unknown
`callee_number`	Unknown
`caller_number`	Unknown
`correlation_id`	Unknown
`duration`	Unknown
`end_date_time`	Unknown
`failure_date_time`	Unknown
`final_sip_code`	Unknown
`final_sip_code_phrase`	Unknown
`invite_date_time`	Unknown
`media_bypass_enabled`	Unknown
`media_path_location`	Unknown
`signaling_location`	Unknown
`start_date_time`	Unknown
`successful_call`	Unknown
`trunk_fully_qualified_domain_name`	Unknown
`user_display_name`	Unknown
`user_id`	Unknown
`user_principal_name`	Unknown