# Formstack schema ERD

Table and field reference for the Fivetran Formstack connector.

## Table & Field Reference

### partial_submission_data

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| partial_submission_id | Unknown | PK, FK |
| field | Unknown | FK |
| value | Unknown |  |

### partial_submission

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| form_id | Unknown | FK |
| date_timestamp | Unknown |  |
| latitude | Unknown |  |
| longitude | Unknown |  |
| remote_addr | Unknown |  |
| user_agent | Unknown |  |

### form_field

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| form_id | Unknown | PK, FK |
| default_value | Unknown |  |
| description | Unknown |  |
| hidden | Unknown |  |
| hide_label | Unknown |  |
| label | Unknown |  |
| name | Unknown |  |
| options | Json |  |
| read_only | Unknown |  |
| required | Unknown |  |
| show_initial | Unknown |  |
| show_middle | Unknown |  |
| show_prefix | Unknown |  |
| show_suffix | Unknown |  |
| text_size | Unknown |  |
| type | Unknown |  |
| uniq | Unknown |  |
| custom_** |  |  |

### form

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| folder_id | Unknown | FK |
| last_submission_id | Unknown | FK |
| can_access_1_q_feature | Unknown |  |
| can_edit | Unknown |  |
| created | Unknown |  |
| data_url | Unknown |  |
| db | Unknown |  |
| deleted | Unknown |  |
| edit_url | Unknown |  |
| encrypted | Unknown |  |
| has_approvers | Unknown |  |
| html | Unknown |  |
| inactive | Unknown |  |
| is_workflow_form | Unknown |  |
| is_workflow_published | Unknown |  |
| javascript | Unknown |  |
| language_code | Unknown |  |
| last_submission_time | Unknown |  |
| name | Unknown |  |
| num_columns | Unknown |  |
| permission | Unknown |  |
| progress_meter | Unknown |  |
| should_display_one_question_at_a_time | Unknown |  |
| submissions_today | Unknown |  |
| submissions_unread | Unknown |  |
| submit_button_title | Unknown |  |
| summary_url | Unknown |  |
| thumbnail_url | Unknown |  |
| timezone | Unknown |  |
| updated | Unknown |  |
| url | Unknown |  |
| v_4_html | Unknown |  |
| version | Unknown |  |
| view_key | Unknown |  |
| views | Unknown |  |

### form_submission_data

| Column | Type | Keys |
| --- | --- | --- |
| field | Unknown | PK, FK |
| submission_id | Unknown | PK, FK |
| value | Unknown |  |

### form_submission

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| form_id | Unknown | FK |
| approval_status | Unknown |  |
| date_timestamp | Unknown |  |
| latitude | Unknown |  |
| longitude | Unknown |  |
| payment_status | Unknown |  |
| portal_form_name | Unknown |  |
| portal_name | Unknown |  |
| portal_participant_email | Unknown |  |
| pretty_field_id | Unknown |  |
| read | Unknown |  |
| remote_addr | Unknown |  |
| user_agent | Unknown |  |

### sub_folder

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| parent_id | Unknown | FK |
| name | Unknown |  |
| permission | Unknown |  |

### folder

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| parent_id | Unknown | FK |
| name | Unknown |  |
| permission | Unknown |  |

## Relationships

- partial_submission_data(field) → form_field(id)
- partial_submission_data(partial_submission_id) → partial_submission(id)
- partial_submission(form_id) → form(id)
- form_field(form_id) → form(id)
- form(folder_id) → folder(id)
- form(last_submission_id) → form_submission(id)
- form_submission_data(field) → form_field(id)
- form_submission_data(submission_id) → form_submission(id)
- form_submission(form_id) → form(id)
- sub_folder(parent_id) → folder(id)
- folder(parent_id) → folder(id)