# Upland Software schema ERD

Table and field reference for the Fivetran Upland Software connector.

## Table & Field Reference

### call

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| mconnect_id | Unknown | FK |
| profile_id | Unknown | FK |
| call_status | Unknown |  |
| carrier_name | Unknown |  |
| connection_source | Unknown |  |
| destination_number | Unknown |  |
| duration | Unknown |  |
| email | Unknown |  |
| end_time | Unknown |  |
| handset_number | Unknown |  |
| legislator_district | Unknown |  |
| legislator_first_name | Unknown |  |
| legislator_last_name | Unknown |  |
| legislator_party | Unknown |  |
| legislator_state | Unknown |  |
| profile_status_at_call_time | Unknown |  |
| start_time | Unknown |  |
| transcription | Unknown |  |
| voicemail | Unknown |  |
| voicemail_duration | Unknown |  |
| voip_number | Unknown |  |

### web_click

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| tiny_url_id | Unknown | PK, FK |
| profile_id | Unknown | FK |
| clicked_url | Unknown |  |
| created_at | Unknown |  |
| http_referer | Unknown |  |
| remote_addr | Unknown |  |
| url | Unknown |  |
| user_agent | Unknown |  |

### groups

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| hint | Unknown |  |
| name | Unknown |  |
| size | Unknown |  |
| status | Unknown |  |
| type | Unknown |  |

### tiny_url

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Unknown |  |
| description | Unknown |  |
| host | Unknown |  |
| key | Unknown |  |
| mode | Unknown |  |
| name | Unknown |  |
| url | Unknown |  |

### message

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| campaign_id | Unknown | FK |
| profile | Unknown | FK |
| approved | Unknown |  |
| body | Unknown |  |
| carrier_name | Unknown |  |
| mms | Unknown |  |
| multipart | Unknown |  |
| next_id | Unknown |  |
| previous_id | Unknown |  |
| received_at | Unknown |  |
| template_id | Unknown |  |
| type | Unknown |  |

### mconnect

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| tag_name | Unknown | FK |
| active | Unknown |  |
| autoroute | Unknown |  |
| call_timeout | Unknown |  |
| call_type | Unknown |  |
| crm_alert_id | Unknown |  |
| destination_description | Unknown |  |
| destination_number | Unknown |  |
| failover_number | Unknown |  |
| failover_text | Unknown |  |
| name | Unknown |  |
| nonsubscriber_follow_up | Unknown |  |
| shortcode | Unknown |  |
| subscriber_follow_up | Unknown |  |
| transcribe | Unknown |  |
| voicemail | Unknown |  |
| voip_number | Unknown |  |

### keyword

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| active | Unknown |  |
| created_at | Unknown |  |
| ended_at | Unknown |  |
| name | Unknown |  |
| opted_in_path_id | Unknown |  |
| updated_at | Unknown |  |

### mdata

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| name | Unknown |  |
| type | Unknown |  |
| uuid | Unknown |  |

### profile_subscription

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| campaign_id | Unknown | FK |
| opted_in_path_id | Unknown | FK |
| profile_id | Unknown | FK |
| activated_at | Unknown |  |
| created_at | Unknown |  |
| opted_in_source | Unknown |  |
| opted_out_at | Unknown |  |
| opted_out_source | Unknown |  |
| status | Unknown |  |

### profile_custom_column

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| profile_id | Unknown | FK |
| created_at | Unknown |  |
| name | Unknown |  |
| text | Unknown |  |
| updated_at | Unknown |  |

### profile

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| address_city | Unknown |  |
| address_country | Unknown |  |
| address_postal_code | Unknown |  |
| address_state | Unknown |  |
| address_street_1 | Unknown |  |
| address_street_2 | Unknown |  |
| congressional_district | Unknown |  |
| created_at | Unknown |  |
| email | Unknown |  |
| first_name | Unknown |  |
| integration | Unknown |  |
| last_name | Unknown |  |
| location_city | Unknown |  |
| location_country | Unknown |  |
| location_latitude | Unknown |  |
| location_longitude | Unknown |  |
| location_postal_code | Unknown |  |
| location_precision | Unknown |  |
| location_state | Unknown |  |
| phone_number | Unknown |  |
| source_email | Unknown |  |
| source_id | Unknown |  |
| source_name | Unknown |  |
| source_type | Unknown |  |
| split_district | Unknown |  |
| state_lower_district | Unknown |  |
| state_upper_district | Unknown |  |
| status | Unknown |  |
| updated_at | Unknown |  |

### broadcast_excluded_group

| Column | Type | Keys |
| --- | --- | --- |
| broadcast_id | Unknown | PK, FK |
| group_id | Unknown | PK, FK |

### broadcast_included_group

| Column | Type | Keys |
| --- | --- | --- |
| broadcast_id | Unknown | PK, FK |
| group_id | Unknown | PK, FK |

### broadcast

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| campaign_id | Unknown | FK |
| tag_name | Unknown | FK |
| automated | Unknown |  |
| body | Unknown |  |
| delivery_time | Unknown |  |
| estimated_recipients_count | Unknown |  |
| include_subscriber | Unknown |  |
| localtimes | Unknown |  |
| name | Unknown |  |
| opted_outs_count | Unknown |  |
| replies_count | Unknown |  |
| status | Unknown |  |
| throttled | Unknown |  |

### campaign_subscriber

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| campaign_id | Unknown | FK |
| profile_id | Unknown | FK |
| activated_at | Unknown |  |
| opted_out_at | Unknown |  |

### mdata_entry

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| mdata_id | Unknown | FK |
| created_at | Unknown |  |
| input | Unknown |  |
| output | Unknown |  |

### campaign_tag

| Column | Type | Keys |
| --- | --- | --- |
| campaign_id | Unknown | PK, FK |
| tag_name | Unknown | PK, FK |

### campaign

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| active | Unknown |  |
| description | Unknown |  |
| name | Unknown |  |

### tag_taggable

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| tag_id | Unknown | PK, FK |
| type | Unknown |  |

### tags

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| name | Unknown |  |

## Relationships

- call(mconnect_id) → mconnect(id)
- call(profile_id) → profile(id)
- web_click(profile_id) → profile(id)
- web_click(tiny_url_id) → tiny_url(id)
- message(campaign_id) → campaign(id)
- message(profile) → profile(id)
- mconnect(tag_name) → tags(name)
- profile_subscription(campaign_id) → campaign(id)
- profile_subscription(opted_in_path_id) → keyword(opted_in_path_id)
- profile_subscription(profile_id) → profile(id)
- profile_custom_column(profile_id) → profile(id)
- broadcast_excluded_group(group_id) → groups(id)
- broadcast_excluded_group(broadcast_id) → broadcast(id)
- broadcast_included_group(group_id) → groups(id)
- broadcast_included_group(broadcast_id) → broadcast(id)
- broadcast(campaign_id) → campaign(id)
- broadcast(tag_name) → tags(name)
- campaign_subscriber(profile_id) → profile(id)
- campaign_subscriber(campaign_id) → campaign(id)
- mdata_entry(mdata_id) → mdata(id)
- campaign_tag(tag_name) → tags(name)
- campaign_tag(campaign_id) → campaign(id)
- tag_taggable(tag_id) → tags(id)