Upland Software
Explore the interactive ERD
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 | PKFK |
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 | PKFK |
group_id | Unknown | PKFK |
broadcast_included_group
| Column | Type | Keys |
|---|---|---|
broadcast_id | Unknown | PKFK |
group_id | Unknown | PKFK |
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 | PKFK |
tag_name | Unknown | PKFK |
campaign
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
active | Unknown | |
description | Unknown | |
name | Unknown |
tag_taggable
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
tag_id | Unknown | PKFK |
type | Unknown |
tags
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
name | Unknown |