# Typeform schema ERD

Table and field reference for the Fivetran Typeform connector.

## Table & Field Reference

### logic_action_history

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| form_id | String | PK |
| logic_fivetran_id | String | PK, FK |
| action | String |  |
| detail_target_type | String |  |
| detail_target_value | String |  |
| detail_to_type | String |  |
| detail_to_value | String |  |
| detail_value_type | String |  |
| detail_value_value | String |  |

### form_logic_history

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| field_ref | String | PK, FK |
| form_id | String | PK, FK |
| type | String |  |

### form_insight

| Column | Type | Keys |
| --- | --- | --- |
| platform | String | PK |
| form_id | String | PK, FK |
| average_time | Long |  |
| completion_rate | Double |  |
| responses_count | Long |  |
| total_visits | Long |  |
| unique_visits | Long |  |

### response_answer

| Column | Type | Keys |
| --- | --- | --- |
| form_id | String | PK |
| field_id | String | PK, FK |
| response_id | String | PK, FK |
| boolean | Boolean |  |
| date | String |  |
| email | String |  |
| file_url | String |  |
| number | Double |  |
| payment_amount | String |  |
| payment_last_4 | String |  |
| payment_name | String |  |
| phone_number | String |  |
| text | String |  |
| type | String |  |
| url | String |  |

### form_history

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| theme_id | String | FK |
| workspace_id | String | FK |
| _language | String |  |
| cui_setting_avatar | String |  |
| cui_setting_is_typing_emulation_disabled | Boolean |  |
| cui_setting_typing_emulation_speed | String |  |
| last_updated_at | Instant |  |
| title | String |  |
| type | String |  |
| variable_price | Float |  |
| variable_score | Int |  |

### form_custom_message

| Column | Type | Keys |
| --- | --- | --- |
| form_id | String | PK, FK |
| block_dropdown_hint | String |  |
| block_dropdown_placeholder | String |  |
| block_dropdown_placeholder_touch | String |  |
| block_file_upload_choose | String |  |
| block_file_upload_drag | String |  |
| block_file_upload_uploading_progress | String |  |
| block_legal_accept | String |  |
| block_legal_reject | String |  |
| block_longtext_hint | String |  |
| block_multiple_choice_hint | String |  |
| block_multiple_choice_other | String |  |
| block_short_text_placeholder | String |  |
| label_action_share | String |  |
| label_button_ok | String |  |
| label_button_review | String |  |
| label_button_submit | String |  |
| label_error_email_address | String |  |
| label_error_expiry_month_title | String |  |
| label_error_expiry_year_title | String |  |
| label_error_incomplete_form | String |  |
| label_error_max_length | String |  |
| label_error_max_value | String |  |
| label_error_min_value | String |  |
| label_error_must_accept | String |  |
| label_error_must_enter | String |  |
| label_error_must_select | String |  |
| label_error_range | String |  |
| label_error_required | String |  |
| label_error_server | String |  |
| label_error_size_limit | String |  |
| label_error_url | String |  |
| label_hint_key | String |  |
| label_no_default | String |  |
| label_no_shortcut | String |  |
| label_preview | String |  |
| label_progress_percent | String |  |
| label_progress_proportion | String |  |
| label_warning_fallback_alert | String |  |
| label_warning_form_unavailable | String |  |
| label_warning_success | String |  |
| label_yes_default | String |  |
| label_yes_shortcut | String |  |

### response

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| form_id | String | PK, FK |
| calculated_score | Float |  |
| landed_at | Instant |  |
| landing_id | String |  |
| response_type | String |  |
| staged_at | Instant |  |
| submitted_at | Instant |  |
| token | String |  |
| metadata_** |  |  |

### response_answer_choice

| Column | Type | Keys |
| --- | --- | --- |
| choice_id | String | PK |
| field_id | String | PK |
| response_id | String | PK, FK |
| choice_text | String |  |
| ranking | Long |  |

### response_variable

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| response_id | String | PK, FK |
| key | String |  |
| number | Double |  |
| text | String |  |
| type | String |  |

### self_notification

| Column | Type | Keys |
| --- | --- | --- |
| recipient | String | PK |
| notification_fivetran_id | String | PK, FK |

### setting_notification

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| form_id | String | PK, FK |
| respondent_** |  |  |
| self_** |  |  |

### form_field_history

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| form_id | String | PK, FK |
| form_parent_field_id | String | FK |
| layout_attachment_href | String |  |
| layout_attachment_property_brightness | Float |  |
| layout_attachment_property_description | String |  |
| layout_attachment_property_focal_point_x | Float |  |
| layout_attachment_property_focal_point_y | Float |  |
| layout_attachment_scale | Float |  |
| layout_attachment_type | String |  |
| layout_placement | String |  |
| layout_type | String |  |
| ref | String |  |
| title | String |  |
| type | String |  |
| property_** |  |  |
| validation_** |  |  |

### workspace_member

| Column | Type | Keys |
| --- | --- | --- |
| email | String | PK |
| workspace_id | String | PK, FK |
| name | String |  |
| role | String |  |

### form_hidden_field_history

| Column | Type | Keys |
| --- | --- | --- |
| field | String | PK |
| form_id | String | PK, FK |

### theme

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| background_brightness | Float |  |
| background_href | String |  |
| background_layout | String |  |
| field_alignment | String |  |
| field_font_size | String |  |
| font | String |  |
| has_transparent_button | Boolean |  |
| name | String |  |
| screen_alignment | String |  |
| screen_font_size | String |  |
| visibility | String |  |
| color_** |  |  |

### form_field_choice_history

| Column | Type | Keys |
| --- | --- | --- |
| form_id | String | PK |
| id | String | PK |
| field_id | String | PK, FK |
| attachment_href | String |  |
| attachment_property_description | String |  |
| attachment_type | String |  |
| label | String |  |
| ref | String |  |

### logic_action_condition_history

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| form_id | String | PK |
| logic_action_fivetran_id | String | PK, FK |
| op | String |  |
| type | String |  |
| value | String |  |

### response_tag

| Column | Type | Keys |
| --- | --- | --- |
| name | String | PK |
| response_id | String | PK, FK |

### form_setting

| Column | Type | Keys |
| --- | --- | --- |
| form_id | String | PK, FK |
| _language | String |  |
| are_uploads_public | Boolean |  |
| facebook_pixel | String |  |
| google_analytics | String |  |
| google_tag_manager | String |  |
| hide_navigation | Boolean |  |
| is_public | Boolean |  |
| is_trial | Boolean |  |
| progress_bar | String |  |
| redirect_after_submit_url | String |  |
| show_progress_bar | Boolean |  |
| show_time_to_complete | Boolean |  |
| show_typeform_branding | Boolean |  |
| meta_** |  |  |

### form_field_insight

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| form_id | String | PK, FK |
| dropoffs | Long |  |
| label | String |  |
| ref | String |  |
| title | String |  |
| type | String |  |
| views | Long |  |

### respondent_notification

| Column | Type | Keys |
| --- | --- | --- |
| reply_to | String | PK |
| notification_fivetran_id | String | PK, FK |

### workspace

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| account_id | String |  |
| default | Boolean |  |
| name | String |  |
| shared | Boolean |  |

## Relationships

- logic_action_history(logic_fivetran_id) → form_logic_history(form_id)
- form_logic_history(form_id) → form_history(id)
- form_logic_history(field_ref) → form_field_history(form_id)
- form_insight(form_id) → form_history(id)
- response_answer(field_id) → form_field_history(form_id)
- response_answer(response_id) → response(form_id)
- form_history(theme_id) → theme(id)
- form_history(workspace_id) → workspace(id)
- form_custom_message(form_id) → form_history(id)
- response(form_id) → form_history(id)
- response_answer_choice(response_id) → response(form_id)
- response_variable(response_id) → response(form_id)
- self_notification(notification_fivetran_id) → setting_notification(form_id)
- setting_notification(form_id) → form_history(id)
- form_field_history(form_id) → form_history(id)
- form_field_history(form_parent_field_id) → form_field_history(form_id)
- workspace_member(workspace_id) → workspace(id)
- form_hidden_field_history(form_id) → form_history(id)
- form_field_choice_history(field_id) → form_field_history(form_id)
- logic_action_condition_history(logic_action_fivetran_id) → logic_action_history(form_id)
- response_tag(response_id) → response(form_id)
- form_setting(form_id) → form_history(id)
- form_field_insight(form_id) → form_history(id)
- respondent_notification(notification_fivetran_id) → setting_notification(form_id)