Typeform
Explore the interactive ERD
Table & Field Reference
logic_action_history
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
form_id | String | PK |
logic_fivetran_id | String | PKFK |
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 | PKFK |
form_id | String | PKFK |
type | String |
form_insight
| Column | Type | Keys |
|---|---|---|
platform | String | PK |
form_id | String | PKFK |
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 | PKFK |
response_id | String | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
choice_text | String | |
ranking | Long |
response_variable
| Column | Type | Keys |
|---|---|---|
index | Int | PK |
response_id | String | PKFK |
key | String | |
number | Double | |
text | String | |
type | String |
self_notification
| Column | Type | Keys |
|---|---|---|
recipient | String | PK |
notification_fivetran_id | String | PKFK |
setting_notification
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
form_id | String | PKFK |
respondent_** | ||
self_** |
form_field_history
| Column | Type | Keys |
|---|---|---|
id | String | PK |
form_id | String | PKFK |
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 | PKFK |
name | String | |
role | String |
form_hidden_field_history
| Column | Type | Keys |
|---|---|---|
field | String | PK |
form_id | String | PKFK |
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 | PKFK |
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 | PKFK |
op | String | |
type | String | |
value | String |
response_tag
| Column | Type | Keys |
|---|---|---|
name | String | PK |
response_id | String | PKFK |
form_setting
| Column | Type | Keys |
|---|---|---|
form_id | String | PKFK |
_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 | PKFK |
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 | PKFK |
workspace
| Column | Type | Keys |
|---|---|---|
id | String | PK |
account_id | String | |
default | Boolean | |
name | String | |
shared | Boolean |