# Attentive schema ERD

Table and field reference for the Fivetran Attentive connector.

## Table & Field Reference

### catalog_upload_error

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| catalog_upload_upload_id | Unknown | PK, FK |
| error_message | Unknown |  |
| error_type | Unknown |  |
| line_num | Unknown |  |

### catalog_upload

| Column | Type | Keys |
| --- | --- | --- |
| upload_id | Unknown | PK |
| expires | Unknown |  |
| last_updated | Unknown |  |
| products_processed | Unknown |  |
| products_received | Unknown |  |
| status | Unknown |  |
| upload_url | Unknown |  |
| validate_only | Unknown |  |

### sms_email_subscribed

| Column | Type | Keys |
| --- | --- | --- |
| subscriber_external_id | Unknown | PK |
| subscription_type | Unknown | PK |
| timestamps | Unknown | PK |
| company_display_name | Unknown |  |
| company_id | Unknown |  |
| creative_name | Unknown |  |
| creative_subtype | Unknown |  |
| creative_type | Unknown |  |
| subscriber_email | Unknown |  |
| subscriber_phone | Unknown |  |
| type | Unknown |  |
| custom_** |  |  |

### sms_sent

| Column | Type | Keys |
| --- | --- | --- |
| message_id | Unknown | PK |
| timestamps | Unknown | PK |
| subscriber_external_id | Unknown | PK, FK |
| company_display_name | Unknown |  |
| company_id | Unknown |  |
| message_channel | Unknown |  |
| message_text | Unknown |  |
| message_type | Unknown |  |
| subscriber_email | Unknown |  |
| subscriber_phone | Unknown |  |
| type | Unknown |  |
| custom_** |  |  |

### email_opened

| Column | Type | Keys |
| --- | --- | --- |
| timestamps | Unknown | PK |
| message_id | Unknown | PK, FK |
| subscriber_external_id | Unknown | PK, FK |
| company_display_name | Unknown |  |
| company_id | Unknown |  |
| message_channel | Unknown |  |
| message_name | Unknown |  |
| message_type | Unknown |  |
| type | Unknown |  |

### sms_email_unsubscribed

| Column | Type | Keys |
| --- | --- | --- |
| subscription_type | Unknown | PK |
| subscriber_external_id | Unknown | PK, FK |
| company_display_name | Unknown |  |
| company_id | Unknown |  |
| subscriber_email | Unknown |  |
| subscriber_phone | Unknown |  |
| timestamps | Unknown |  |
| type | Unknown |  |
| custom_** |  |  |

### email_sent

| Column | Type | Keys |
| --- | --- | --- |
| message_id | Unknown | PK |
| timestamps | Unknown | PK |
| subscriber_external_id | Unknown | PK, FK |
| company_display_name | Unknown |  |
| company_id | Unknown |  |
| message_channel | Unknown |  |
| message_from_email | Unknown |  |
| message_subject | Unknown |  |
| message_to_email | Unknown |  |
| subscriber_email | Unknown |  |
| subscriber_phone | Unknown |  |
| type | Unknown |  |
| custom_** |  |  |

### sms_inbound

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| subscriber_external_id | Unknown | FK |
| company_id | Unknown |  |
| message_text | Unknown |  |
| message_to_phone | Unknown |  |
| message_type | Unknown |  |
| timestamps | Unknown |  |
| type | Unknown |  |
| custom_** |  |  |

### custom_attribute

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| subscriber_external_id | Unknown | FK |
| company_display_name | Unknown |  |
| company_id | Unknown |  |
| subscriber_email | Unknown |  |
| subscriber_phone | Unknown |  |
| timestamps | Unknown |  |
| type | Unknown |  |
| user_property_id | Unknown |  |
| user_property_name | Unknown |  |
| user_property_value | Unknown |  |
| custom_** |  |  |

### sms_message_link_click

| Column | Type | Keys |
| --- | --- | --- |
| message_link_click_link_id | Unknown | PK |
| message_link_click_message_id | Unknown | PK |
| subscriber_external_id | Unknown | PK |
| timestamps | Unknown | PK |
| company_display_name | Unknown |  |
| company_id | Unknown |  |
| message_link_click_channel | Unknown |  |
| message_link_click_link_target | Unknown |  |
| message_link_click_message_type | Unknown |  |
| type | Unknown |  |

### email_message_link_click

| Column | Type | Keys |
| --- | --- | --- |
| message_link_click_link_id | Unknown | PK |
| message_link_click_message_id | Unknown | PK |
| subscriber_external_id | Unknown | PK |
| timestamps | Unknown | PK |
| company_display_name | Unknown |  |
| company_id | Unknown |  |
| message_link_click_channel | Unknown |  |
| message_link_click_link_target | Unknown |  |
| message_link_click_message_type | Unknown |  |
| type | Unknown |  |

## Relationships

- catalog_upload_error(catalog_upload_upload_id) → catalog_upload(upload_id)
- sms_sent(subscriber_external_id) → sms_email_subscribed(subscriber_external_id)
- email_opened(subscriber_external_id) → email_sent(subscriber_external_id)
- email_opened(message_id) → email_sent(message_id)
- sms_email_unsubscribed(subscriber_external_id) → sms_email_subscribed(subscriber_external_id)
- email_sent(subscriber_external_id) → sms_email_subscribed(subscriber_external_id)
- sms_inbound(subscriber_external_id) → sms_sent(subscriber_external_id)
- custom_attribute(subscriber_external_id) → sms_email_subscribed(subscriber_external_id)