# Fone Dynamics schema ERD

Table and field reference for the Fivetran Fone Dynamics connector.

## Table & Field Reference

### available_number

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| country_code | Unknown | FK |
| numbers | Unknown |  |

### message

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| property_sid | Unknown | PK, FK |
| account_sid | Unknown |  |
| created | Unknown |  |
| delivered | Unknown |  |
| delivery_receipt | Unknown |  |
| direction | Unknown |  |
| froms | Unknown |  |
| num_segment | Unknown |  |
| received | Unknown |  |
| scheduled | Unknown |  |
| status | Unknown |  |
| submitted | Unknown |  |
| text | Unknown |  |
| tos | Unknown |  |

### number

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| numbers | Unknown | PK |
| property_sid | Unknown | FK |
| address_requirement | Unknown |  |
| address_sid | Unknown |  |
| capability | Unknown |  |
| city | Unknown |  |
| country_code | Unknown |  |
| end_point_number | Unknown |  |
| friendly | Unknown |  |
| recording | Unknown |  |
| region | Unknown |  |
| routing_method | Unknown |  |
| status | Unknown |  |
| type | Unknown |  |

### query_call

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| attribution_campaign | Unknown |  |
| attribution_content | Unknown |  |
| attribution_medium | Unknown |  |
| attribution_source | Unknown |  |
| call_type | Unknown |  |
| date_start | Unknown |  |
| disposition | Unknown |  |
| duration | Unknown |  |
| endpoint | Unknown |  |
| from_city | Unknown |  |
| from_country_code | Unknown |  |
| from_region | Unknown |  |
| froms | Unknown |  |
| google_adwords_click_id | Unknown |  |
| google_analytics_client_id | Unknown |  |
| note | Unknown |  |
| prompts_key | Unknown |  |
| property_sid | Unknown |  |
| recording_uri | Unknown |  |
| session_conversion_uri | Unknown |  |
| session_keyword | Unknown |  |
| session_landing_uri | Unknown |  |
| session_traffic_type | Unknown |  |
| survey_type | Unknown |  |
| survey_unique_code | Unknown |  |
| survey_value | Unknown |  |
| to_friendly | Unknown |  |
| tos | Unknown |  |

## Relationships

- available_number(country_code) → number(country_code)
- message(property_sid) → number(property_sid)
- number(property_sid) → query_call(property_sid)