# Ortto schema ERD

Table and field reference for the Fivetran Ortto connector.

## 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 | PK, FK |
| tag_id | Unknown | PK, FK |

### 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 | PK, FK |
| person_id | Unknown | PK, FK |
| 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 |  |

## Relationships

- person_tag(tag_id) → tag(id)
- person_tag(person_id) → person(id)
- person(organization_id) → organization(id)
- person_location(person_id) → person(id)
- person_audience(audience_id) → audience(id)
- person_audience(person_id) → person(id)
- tag(instance_id) → audience(instance_id)