Formstack
Explore the interactive ERD
Table & Field Reference
partial_submission_data
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
partial_submission_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
submission_id | Unknown | PKFK |
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 |