Ortto
Explore the interactive ERD
Table & Field Reference
organization
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
fields_employee_count | Unknown | |
fields_industry | Unknown |
person_tag
| Column | Type | Keys |
|---|---|---|
person_id | Unknown | PKFK |
tag_id | Unknown | PKFK |
person
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
organization_id | Unknown | FK |
birthday | Unknown | |
email | Unknown | |
email_subscribe_action | Unknown | |
email_subscription_permision | Unknown | |
email_unsubscribe_action | Unknown | |
external_id | Unknown | |
first_name | Unknown | |
gdpr | Unknown | |
job_title | Unknown | |
last_name | Unknown | |
phone_number | Unknown | |
phone_number_code | Unknown | |
postal | Unknown | |
sms_subscribe_action | Unknown | |
sms_subscription_permission | Unknown | |
sms_unsubscribe_action | Unknown | |
tag_ids | Unknown | |
tags | Unknown |
person_location
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
person_id | Unknown | FK |
id | Unknown | |
latitude | Unknown | |
longitude | Unknown | |
name | Unknown | |
type | String |
person_audience
| Column | Type | Keys |
|---|---|---|
audience_id | Unknown | PKFK |
person_id | Unknown | PKFK |
android_opted_in | Unknown | |
android_permissions | Unknown | |
email_permissions | Unknown | |
error | Unknown | |
ios_opted_in | Unknown | |
ios_permissions | Unknown | |
member_from | Unknown | |
person_status | Unknown | |
sms_opted_out_from | Unknown | |
sms_permissions | Unknown | |
subscribed | Unknown | |
subscribed_from | Unknown | |
unsubscribed_from | Unknown | |
web_opted_in | Unknown | |
web_permissions | Unknown |
audience
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
added_last_30_days | Unknown | |
building | Unknown | |
created | Unknown | |
created_by_name | Unknown | |
data_source_id | Unknown | |
destinations | Unknown | |
edited_at | Unknown | |
engagement | Unknown | |
exit_selection | Unknown | |
filter | Json | |
filter_sha | Unknown | |
icon_id | Unknown | |
instance_id | Unknown | |
is_cold | Unknown | |
is_public | Unknown | |
last_built_at | Unknown | |
last_used | Unknown | |
member_count | Unknown | |
name | Unknown | |
new_exit_criteria_filter | Unknown | |
new_filter | Unknown | |
new_filter_sha | Unknown | |
position | Unknown | |
public_description | Unknown | |
public_name | Unknown | |
ready | Unknown | |
revenue | Unknown | |
sms_is_public | Unknown | |
sms_opted_in | Unknown | |
sms_public_description | Unknown | |
sms_public_name | Unknown | |
subscribers | Unknown | |
template_id | Unknown | |
type | Unknown |
tag
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
instance_id | Unknown | FK |
count | Unknown | |
created_at | Unknown | |
created_by_email | Unknown | |
created_by_name | Unknown | |
last_used | Unknown | |
name | Unknown | |
sms_opted_in | Unknown | |
source | Unknown | |
subscribers | Unknown | |
type | Unknown |