# Microsoft Teams schema ERD

Table and field reference for the Fivetran Microsoft Teams connector.

## Table & Field Reference

### session_media_stream

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| call_id | Unknown | PK, FK |
| session_id | Unknown | PK, FK |
| session_media_index | Unknown | PK, FK |
| 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 | PK, FK |
| session_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| channel_message_id | Unknown | PK, FK |
| team_id | Unknown | PK, FK |
| created_date_time | Instant |  |
| user_display_name | Unknown |  |
| user_identity_type | Unknown |  |

### channel_message_mention

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| channel_id | Unknown | PK, FK |
| channel_message_id | Unknown | PK, FK |
| team_id | Unknown | PK, FK |
| 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 | PK, FK |
| channel_message_id | Unknown | PK, FK |
| channel_message_reply_id | Unknown | PK, FK |
| team_id | Unknown | PK, FK |
| 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 | PK, FK |
| channel_message_id | Unknown | PK, FK |
| channel_message_reply_id | Unknown | PK, FK |
| team_id | Unknown | PK, FK |
| 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 | PK, FK |
| channel_message_id | Unknown | PK, FK |
| team_id | Unknown | PK, FK |
| 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 | PK, FK |
| team_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 |  |

## Relationships

- session_media_stream(session_id) → session_media(session_id)
- session_media_stream(call_id) → session_media(call_id)
- session_media_stream(session_media_index) → session_media(index)
- session_media(session_id) → session(id)
- session_media(call_id) → session(call_id)
- session(call_id) → call(id)
- channel(team_id) → team(id)
- chat_message(chat_id) → chat(id)
- channel_message_reaction(channel_message_id) → channel_message(id)
- channel_message_reaction(channel_id) → channel_message(channel_id)
- channel_message_reaction(team_id) → channel_message(team_id)
- channel_message_mention(channel_message_id) → channel_message(id)
- channel_message_mention(channel_id) → channel_message(channel_id)
- channel_message_mention(team_id) → channel_message(team_id)
- channel_message_reply_reaction(channel_message_reply_id) → channel_message_reply(id)
- channel_message_reply_reaction(channel_message_id) → channel_message_reply(channel_message_id)
- channel_message_reply_reaction(channel_id) → channel_message_reply(channel_id)
- channel_message_reply_reaction(team_id) → channel_message_reply(team_id)
- channel_message_reply_mention(channel_message_reply_id) → channel_message_reply(id)
- channel_message_reply_mention(channel_message_id) → channel_message_reply(channel_message_id)
- channel_message_reply_mention(channel_id) → channel_message_reply(channel_id)
- channel_message_reply_mention(team_id) → channel_message_reply(team_id)
- channel_message_reply(channel_message_id) → channel_message(id)
- channel_message_reply(channel_id) → channel_message(channel_id)
- channel_message_reply(team_id) → channel_message(team_id)
- channel_message(team_id) → team(id)
- channel_message(channel_id) → channel(id)
- participant(call_id) → call(id)
- chat(users_id) → users(id)