# Jotform schema ERD

Table and field reference for the Fivetran Jotform connector.

## Table & Field Reference

### form_file

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| form_id | Unknown | PK, FK |
| submission_id | Unknown | FK |
| username | Unknown | FK |
| date | Unknown |  |
| name | Unknown |  |
| size | Unknown |  |
| type | Unknown |  |
| uploaded | Unknown |  |
| url | Unknown |  |

### team_form_question_sublabel

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| team_form_id | Unknown | PK, FK |
| team_form_question_qid | Unknown | PK, FK |
| team_id | Unknown | PK, FK |
| value | Unknown |  |

### team_form_question

| Column | Type | Keys |
| --- | --- | --- |
| qid | Unknown | PK |
| team_form_id | Unknown | PK, FK |
| team_id | Unknown | PK, FK |
| allow_other | Unknown |  |
| auto_fixed | Unknown |  |
| button_align | Unknown |  |
| button_style | Unknown |  |
| calc_value | Unknown |  |
| clear | Unknown |  |
| clear_text | Unknown |  |
| cols | Unknown |  |
| compound_hint | Unknown |  |
| default_value | Unknown |  |
| description | Unknown |  |
| encrypt_icon | Unknown |  |
| entry_limit | Unknown |  |
| entry_limit_min | Unknown |  |
| header_image | Unknown |  |
| header_type | Unknown |  |
| hidden | Unknown |  |
| hint | Unknown |  |
| image_align | Unknown |  |
| input_text_mask | Unknown |  |
| label_align | Unknown |  |
| max_selection | Unknown |  |
| maxsize | Unknown |  |
| mde | Unknown |  |
| middle | Unknown |  |
| min_selection | Unknown |  |
| name | Unknown |  |
| option | Unknown |  |
| order_no | Unknown |  |
| other_text | Unknown |  |
| prefix | Unknown |  |
| prefix_choice | Unknown |  |
| print | Unknown |  |
| print_text | Unknown |  |
| readonly | Unknown |  |
| required | Unknown |  |
| rows | Unknown |  |
| selected | Unknown |  |
| shrink | Unknown |  |
| size | Unknown |  |
| special | Unknown |  |
| spread_col | Unknown |  |
| sub_header | Unknown |  |
| sub_label | Unknown |  |
| suffix | Unknown |  |
| text | Unknown |  |
| text_align | Unknown |  |
| type | Unknown |  |
| validation | Unknown |  |
| vertical_text_align | Unknown |  |
| width | Unknown |  |
| wysiwyg | Unknown |  |

### sub_label_form

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| label_id | Unknown | FK |

### usage

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| api | Unknown |  |
| form_count | Unknown |  |
| mobile_submissions | Unknown |  |
| payments | Unknown |  |
| pdf_attachment_submissions | Unknown |  |
| signed_documents | Unknown |  |
| ssl_submissions | Unknown |  |
| submissions | Unknown |  |
| total_submissions | Unknown |  |
| uploads | Unknown |  |
| views | Unknown |  |

### team_asset

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| team_id | Unknown | PK, FK |
| archived | Unknown |  |
| asset_type | Unknown |  |
| count | Unknown |  |
| created_at | Unknown |  |
| favorite | Unknown |  |
| height | Unknown |  |
| is_new | Unknown |  |
| last_submission | Unknown |  |
| status | Unknown |  |
| title | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |
| url | Unknown |  |
| username | Unknown |  |

### team_submission_answer

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| form_id | Unknown | PK, FK |
| team_id | Unknown | PK, FK |
| team_submission_id | Unknown | PK, FK |
| answer | Json |  |
| name | Unknown |  |
| order_no | Unknown |  |
| pretty_format | Unknown |  |
| scale_amount | Unknown |  |
| text | Unknown |  |
| type | Unknown |  |

### team_submission

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| form_id | Unknown | PK, FK |
| team_id | Unknown | PK, FK |
| created_at | Unknown |  |
| ip | Unknown |  |
| new_no | Unknown |  |
| status | Unknown |  |
| updated_at | Unknown |  |

### sub_user_permission

| Column | Type | Keys |
| --- | --- | --- |
| resource_id | Unknown | PK |
| owner | Unknown | PK, FK |
| username | Unknown | PK, FK |
| access_type | Unknown |  |
| title | Unknown |  |
| type | Unknown |  |

### sub_user

| Column | Type | Keys |
| --- | --- | --- |
| username | Unknown | PK |
| owner | Unknown | PK, FK |
| created_at | Unknown |  |
| email | Unknown |  |
| status | Unknown |  |

### team_form

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| team_id | Unknown | PK, FK |
| username | Unknown | FK |
| archived | Unknown |  |
| asset_type | Unknown |  |
| count | Unknown |  |
| created_at | Unknown |  |
| favorite | Unknown |  |
| height | Unknown |  |
| last_submission | Unknown |  |
| new_no | Unknown |  |
| status | Unknown |  |
| title | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |
| url | Unknown |  |

### sub_label

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| parent_label_id | Unknown | FK |
| id | Unknown |  |

### label

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| owner | Unknown | FK |
| color | Unknown |  |
| name | Unknown |  |
| orders | Unknown |  |
| parent_label_id | Unknown |  |

### team_member

| Column | Type | Keys |
| --- | --- | --- |
| team_id | Unknown | PK, FK |
| username | Unknown | PK, FK |
| account_lockout | Unknown |  |
| account_type | Unknown |  |
| avatar | Unknown |  |
| created_at | Unknown |  |
| email | Unknown |  |
| is_data_only_user | Unknown |  |
| is_owner | Unknown |  |
| job_title | Unknown |  |
| last_seen | Unknown |  |
| name | Unknown |  |
| updated_at | Unknown |  |

### team

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| creator | Unknown | FK |
| owner | Unknown | FK |
| cover_bg_color | Unknown |  |
| cover_bg_image_crop_info | Unknown |  |
| cover_bg_image_url | Unknown |  |
| cover_title_color | Unknown |  |
| created_at | Unknown |  |
| default_member_role | Unknown |  |
| do_not_clone | Unknown |  |
| invitation_sent | Unknown |  |
| login_to_get_submission | Unknown |  |
| login_to_view_submission_rss | Unknown |  |
| login_to_view_uploaded_file | Unknown |  |
| member_count | Unknown |  |
| name | Unknown |  |
| primary_smtp_config | Unknown |  |
| privacy | Unknown |  |
| show_cover_image | Unknown |  |
| slug | Unknown |  |
| team_avatar_emoji_id | Unknown |  |
| team_avatar_icon | Unknown |  |
| team_avatar_icon_bg_color | Unknown |  |
| team_avatar_icon_color | Unknown |  |
| team_avatar_icon_svg_ref | Unknown |  |
| team_avatar_url | Unknown |  |
| teamspace_id | Unknown |  |
| time_format | Unknown |  |
| time_zone | Unknown |  |
| updated_at | Unknown |  |
| workspace_visibility | Unknown |  |

### users

| Column | Type | Keys |
| --- | --- | --- |
| username | Unknown | PK |
| ab_myforms_import | Unknown |  |
| ab_test_key | Unknown |  |
| account_type | Unknown |  |
| allow_auto_delete_submission | Unknown |  |
| allow_board | Unknown |  |
| allow_digest | Unknown |  |
| allow_encryption_v_2 | Unknown |  |
| allow_new_condition | Unknown |  |
| allow_prefill | Unknown |  |
| allow_show_alternate_hipaa_badge | Unknown |  |
| allow_sign | Unknown |  |
| allow_workflow_feature | Unknown |  |
| avatar_url | Unknown |  |
| billing_payment_method | Unknown |  |
| card_form | Unknown |  |
| ccpa | Unknown |  |
| company | Unknown |  |
| create_asset_popover_menu | Unknown |  |
| created_at | Unknown |  |
| disable_view_limit | Unknown |  |
| do_not_clone | Unknown |  |
| do_not_show_branding_21_lightbox | Unknown |  |
| dont_show_preview_tip | Unknown |  |
| email | Unknown |  |
| fcm_unsubscribed | Unknown |  |
| folder_layout | Unknown |  |
| form_listing_test_user | Unknown |  |
| hipaa_compliance_answer_on_upgrade | Unknown |  |
| industry | Unknown |  |
| is_verified | Unknown |  |
| languages | Unknown |  |
| name | Unknown |  |
| new_report_user_group | Unknown |  |
| notification_center_enabled | Unknown |  |
| payment_new_product_management | Unknown |  |
| pdf_designer_group | Unknown |  |
| promote_ndt | Unknown |  |
| region | Unknown |  |
| security_answer | Unknown |  |
| security_question | Unknown |  |
| show_jot_form_powered | Unknown |  |
| show_myform_information_modal | Unknown |  |
| sign_beta_user | Unknown |  |
| status | Unknown |  |
| stripe_active | Unknown |  |
| stripe_id | Unknown |  |
| stripe_source | Unknown |  |
| stripe_subscription | Unknown |  |
| submission_inbox_group | Unknown |  |
| table_intro_video_shown | Unknown |  |
| tax_data | Unknown |  |
| teams_beta_user | Unknown |  |
| time_zone | Unknown |  |
| unread_support_answer_count | Unknown |  |
| updated_at | Unknown |  |
| usage | Unknown |  |
| webhook | Unknown |  |
| website | Unknown |  |

### form

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| username | Unknown | FK |
| archived | Unknown |  |
| count | Unknown |  |
| created_at | Unknown |  |
| favorite | Unknown |  |
| height | Unknown |  |
| last_submission | Unknown |  |
| new_no | Unknown |  |
| status | Unknown |  |
| title | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |
| url | Unknown |  |

### submission_answer

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| submission_id | Unknown | PK, FK |
| answer | Json |  |
| name | Unknown |  |
| order_no | Unknown |  |
| pretty_format | Unknown |  |
| scale_amount | Unknown |  |
| text | Unknown |  |
| type | Unknown |  |

### submission

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| form_id | Unknown | FK |
| created_at | Unknown |  |
| ip | Unknown |  |
| new_no | Unknown |  |
| status | Unknown |  |
| updated_at | Unknown |  |

### form_property_condition

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| form_id | Unknown | PK, FK |
| action | Unknown |  |
| execution_index | Unknown |  |
| id | Unknown |  |
| link | Unknown |  |
| priority | Unknown |  |
| terms | Unknown |  |
| type | Unknown |  |

### form_property_email

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| form_id | Unknown | PK, FK |
| body | Unknown |  |
| branding_21_email | Unknown |  |
| dirty | Unknown |  |
| disabled | Unknown |  |
| emai_from | Unknown |  |
| email_to | Unknown |  |
| hide_empty_field | Unknown |  |
| html | Unknown |  |
| last_question_id | Unknown |  |
| name | Unknown |  |
| pdf_attachment | Unknown |  |
| reply_to | Unknown |  |
| send_on_edit | Unknown |  |
| send_on_submit | Unknown |  |
| subject | Unknown |  |
| type | Unknown |  |
| unique_id | Unknown |  |
| upload_attachment | Unknown |  |

### form_property_autofill

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| form_id | Unknown | PK, FK |
| bind_change | Unknown |  |
| menu | Unknown |  |
| timeout | Unknown |  |
| ttl | Unknown |  |

### form_property_thank_you_page

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| form_id | Unknown | PK, FK |
| image_src | Unknown |  |
| redirect_link | Unknown |  |
| sub_title | Unknown |  |
| title | Unknown |  |
| type | Unknown |  |

### form_property_welcome_page

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| form_id | Unknown | PK, FK |
| button_text | Unknown |  |
| is_active | Unknown |  |
| logo | Unknown |  |
| show_question_count | Unknown |  |
| sub_title | Unknown |  |
| title | Unknown |  |

### form_property

| Column | Type | Keys |
| --- | --- | --- |
| form_id | Unknown | PK, FK |
| owner | Unknown | FK |
| active_redirect | Unknown |  |
| alignment | Unknown |  |
| allow_submission_edit | Unknown |  |
| assign_link_expire_date | Unknown |  |
| assign_link_expire_timezone | Unknown |  |
| assign_slug | Unknown |  |
| background | Unknown |  |
| clear_field_on_hide | Unknown |  |
| creation_language | Unknown |  |
| datetime_migration_includes_birth_date | Unknown |  |
| datetime_migration_status | Unknown |  |
| default_auto_responder_email_assigned | Unknown |  |
| default_email_assigned | Unknown |  |
| default_theme | Unknown |  |
| empty_submission_fixed | Unknown |  |
| expire_date | Unknown |  |
| font | Unknown |  |
| font_color | Unknown |  |
| font_size | Unknown |  |
| form_owner_account_type | Unknown |  |
| form_owner_name | Unknown |  |
| form_string_alphabetic | Unknown |  |
| form_string_alphanumeric | Unknown |  |
| form_string_changed | Unknown |  |
| form_string_confirm_clear_form | Unknown |  |
| form_string_confirm_email | Unknown |  |
| form_string_email | Unknown |  |
| form_string_grading_score_error | Unknown |  |
| form_string_incomplete_fields | Unknown |  |
| form_string_input_carret_error_a | Unknown |  |
| form_string_input_carret_error_b | Unknown |  |
| form_string_less_than | Unknown |  |
| form_string_max_digits_error | Unknown |  |
| form_string_numeric | Unknown |  |
| form_string_please_wait | Unknown |  |
| form_string_require_every_row | Unknown |  |
| form_string_require_one | Unknown |  |
| form_string_required | Unknown |  |
| form_string_submission_limit | Unknown |  |
| form_string_upload_extension | Unknown |  |
| form_string_upload_filesize | Unknown |  |
| form_type | Unknown |  |
| form_width | Unknown |  |
| hash | Unknown |  |
| height | Unknown |  |
| hide_empty_submission_field | Unknown |  |
| hide_mail_empty_field | Unknown |  |
| hide_non_input_submission_field | Unknown |  |
| hide_submission_header | Unknown |  |
| highlight_line | Unknown |  |
| icon_prediction | Unknown |  |
| inject_css | Unknown |  |
| integrations | Json |  |
| is_encrypted | Unknown |  |
| is_eu_form | Unknown |  |
| is_hipaa | Unknown |  |
| is_payment_store_in_basic_field | Unknown |  |
| is_unique | Unknown |  |
| label_width | Unknown |  |
| last_question_id | Unknown |  |
| limit_submission | Unknown |  |
| line_spacing | Unknown |  |
| message_of_limited_form | Unknown |  |
| mobile_go_button | Unknown |  |
| option_color | Unknown |  |
| page_title | Unknown |  |
| page_title_changed | Unknown |  |
| prevent_cloning_form | Unknown |  |
| responsive | Unknown |  |
| send_post_data | Unknown |  |
| show_jot_form_logo | Unknown |  |
| show_progress_bar | Unknown |  |
| slug | Unknown |  |
| status | Unknown |  |
| style | Unknown |  |
| style_json | Unknown |  |
| submission_header | Unknown |  |
| submission_settings | Json |  |
| submit_error | Unknown |  |
| thanktext | Unknown |  |
| theme_designer | Unknown |  |
| theme_id | Unknown |  |
| title | Unknown |  |
| type | Unknown |  |
| unique_field | Unknown |  |
| uses_new_pdf | Unknown |  |

### form_question_sublabel

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| form_question_form_id | Unknown | PK, FK |
| form_question_qid | Unknown | PK, FK |
| value | Unknown |  |

### form_question

| Column | Type | Keys |
| --- | --- | --- |
| qid | Unknown | PK |
| form_id | Unknown | PK, FK |
| allow_other | Unknown |  |
| auto_fixed | Unknown |  |
| button_align | Unknown |  |
| button_style | Unknown |  |
| calc_value | Unknown |  |
| clear | Unknown |  |
| clear_text | Unknown |  |
| cols | Unknown |  |
| compound_hint | Unknown |  |
| default_value | Unknown |  |
| description | Unknown |  |
| encrypt_icon | Unknown |  |
| entry_limit | Unknown |  |
| entry_limit_min | Unknown |  |
| header_image | Unknown |  |
| header_type | Unknown |  |
| hidden | Unknown |  |
| hint | Unknown |  |
| image_align | Unknown |  |
| input_text_mask | Unknown |  |
| label_align | Unknown |  |
| max_selection | Unknown |  |
| maxsize | Unknown |  |
| mde | Unknown |  |
| middle | Unknown |  |
| min_selection | Unknown |  |
| name | Unknown |  |
| option | Unknown |  |
| order_no | Unknown |  |
| other_text | Unknown |  |
| prefix | Unknown |  |
| prefix_choice | Unknown |  |
| print | Unknown |  |
| print_text | Unknown |  |
| readonly | Unknown |  |
| required | Unknown |  |
| rows | Unknown |  |
| selected | Unknown |  |
| shrink | Unknown |  |
| size | Unknown |  |
| special | Unknown |  |
| spread_col | Unknown |  |
| sub_header | Unknown |  |
| sub_label | Unknown |  |
| suffix | Unknown |  |
| text | Unknown |  |
| text_align | Unknown |  |
| type | Unknown |  |
| validation | Unknown |  |
| vertical_text_align | Unknown |  |
| width | Unknown |  |
| wysiwyg | Unknown |  |

## Relationships

- form_file(username) → users(username)
- form_file(submission_id) → submission(id)
- form_file(form_id) → form(id)
- team_form_question_sublabel(team_form_question_qid) → team_form_question(qid)
- team_form_question_sublabel(team_form_id) → team_form_question(team_form_id)
- team_form_question_sublabel(team_id) → team_form_question(team_id)
- team_form_question(team_form_id) → team_form(id)
- team_form_question(team_id) → team(id)
- sub_label_form(id) → form(id)
- sub_label_form(label_id) → label(id)
- team_asset(id) → form(id)
- team_asset(team_id) → team(id)
- team_submission_answer(team_submission_id) → team_submission(id)
- team_submission_answer(form_id) → team_submission(form_id)
- team_submission_answer(team_id) → team_submission(team_id)
- team_submission(form_id) → team_form(id)
- team_submission(team_id) → team(id)
- sub_user_permission(owner) → sub_user(owner)
- sub_user_permission(username) → sub_user(username)
- sub_user(owner) → users(username)
- team_form(username) → users(username)
- team_form(team_id) → team(id)
- sub_label(parent_label_id) → label(id)
- label(owner) → users(username)
- team_member(username) → users(username)
- team_member(team_id) → team(id)
- team(owner) → users(username)
- team(creator) → users(username)
- form(username) → users(username)
- submission_answer(submission_id) → submission(id)
- submission(form_id) → form(id)
- form_property_condition(form_id) → form_property(form_id)
- form_property_email(form_id) → form_property(form_id)
- form_property_autofill(form_id) → form_property(form_id)
- form_property_thank_you_page(form_id) → form_property(form_id)
- form_property_welcome_page(form_id) → form_property(form_id)
- form_property(owner) → users(username)
- form_property(form_id) → form(id)
- form_question_sublabel(form_question_qid) → form_question(qid)
- form_question_sublabel(form_question_form_id) → form_question(form_id)
- form_question(form_id) → form(id)