Jotform

Explore the interactive ERD

Table & Field Reference

form_file

Column	Type	Keys
`id`	Unknown	PK
`form_id`	Unknown	PKFK
`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	PKFK
`team_form_question_qid`	Unknown	PKFK
`team_id`	Unknown	PKFK
`value`	Unknown

team_form_question

Column	Type	Keys
`qid`	Unknown	PK
`team_form_id`	Unknown	PKFK
`team_id`	Unknown	PKFK
`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	PKFK
`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	PKFK
`team_id`	Unknown	PKFK
`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	PKFK
`team_id`	Unknown	PKFK
`team_submission_id`	Unknown	PKFK
`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	PKFK
`team_id`	Unknown	PKFK
`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	PKFK
`username`	Unknown	PKFK
`access_type`	Unknown
`title`	Unknown
`type`	Unknown

sub_user

Column	Type	Keys
`username`	Unknown	PK
`owner`	Unknown	PKFK
`created_at`	Unknown
`email`	Unknown
`status`	Unknown

team_form

Column	Type	Keys
`id`	Unknown	PK
`team_id`	Unknown	PKFK
`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	PKFK
`username`	Unknown	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`bind_change`	Unknown
`menu`	Unknown
`timeout`	Unknown
`ttl`	Unknown

form_property_thank_you_page

Column	Type	Keys
`index`	Unknown	PK
`form_id`	Unknown	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`form_question_qid`	Unknown	PKFK
`value`	Unknown

form_question

Column	Type	Keys
`qid`	Unknown	PK
`form_id`	Unknown	PKFK
`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