# TextUs schema ERD

Table and field reference for the Fivetran TextUs connector.

## Table & Field Reference

### account_phone_number

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| account_id | Unknown | PK, FK |
| phone_number | Unknown |  |

### account

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| brand_status | Unknown |  |
| children_count | Unknown |  |
| contacts_enabled | Unknown |  |
| family_count | Unknown |  |
| has_cumulative_plan | Unknown |  |
| logo | Unknown |  |
| messaging_restricted | Unknown |  |
| multi_user | Unknown |  |
| name | Unknown |  |
| office_hour | Json |  |
| shortened_link_domain | Unknown |  |
| tcr_campaign | Json |  |
| type | Unknown |  |

### user_by_organization

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| account_id | Unknown | FK |
| account_created | Unknown |  |
| account_name | Unknown |  |
| end_date | Unknown |  |
| organization_name | Unknown |  |
| parent_account_name | Unknown |  |
| start_date | Unknown |  |
| user_created | Unknown |  |
| user_name | Unknown |  |
| user_role | Unknown |  |
| custom_** |  |  |

### message_deliverability

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| account_id | Unknown | FK |
| account_name | Unknown |  |
| active_user | Unknown |  |
| delivered_messages | Unknown |  |
| delivered_rate | Unknown |  |
| end_date | Unknown |  |
| failed_messages | Unknown |  |
| failed_rate | Unknown |  |
| organization_name | Unknown |  |
| parent_account_name | Unknown |  |
| received_messages | Unknown |  |
| sent_and_received_ratio | Unknown |  |
| sent_messages | Unknown |  |
| start_date | Unknown |  |
| user_name | Unknown |  |
| custom_** |  |  |

### user_engagement

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| account_id | Unknown | FK |
| account_name | Unknown |  |
| active_conversations | Unknown |  |
| active_conversations_response_rate | Unknown |  |
| active_conversations_with_responses | Unknown |  |
| customer_initiated_conversations | Unknown |  |
| end_date | Unknown |  |
| messages_per_conversation | Unknown |  |
| organization_name | Unknown |  |
| parent_account_name | Unknown |  |
| start_date | Unknown |  |
| total_response_rate | Unknown |  |
| user_name | Unknown |  |
| custom_** |  |  |

## Relationships

- account_phone_number(account_id) → account(id)
- user_by_organization(account_id) → account(id)
- message_deliverability(account_id) → account(id)
- user_engagement(account_id) → account(id)