# Fillout schema ERD

Table and field reference for the Fivetran Fillout connector.

## Table & Field Reference

### form_metadata_question_option

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| form_metadata_id | Unknown | PK, FK |
| form_metadata_question_id | Unknown | PK, FK |
| label | Unknown |  |
| value | Unknown |  |

### form_metadata_question

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| form_metadata_id | Unknown | PK, FK |
| name | Unknown |  |
| type | Unknown |  |

### form_metadata_calculation

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| form_metadata_id | Unknown | PK, FK |
| name | Unknown |  |
| type | Unknown |  |

### form_metadata_url_parameter

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| form_metadata_id | Unknown | PK, FK |
| name | Unknown |  |

### form_metadata_document

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| form_metadata_id | Unknown | PK, FK |
| name | Unknown |  |

### form_metadata_scheduling

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| form_metadata_id | Unknown | PK, FK |
| name | Unknown |  |

### form_metadata_payment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| form_metadata_id | Unknown | PK, FK |
| name | Unknown |  |

### form_metadata

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

### form

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| name | Unknown |  |
| uuid | Unknown |  |

### submission_question

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| submission_id | Unknown | PK, FK |
| name | Unknown |  |
| type | Unknown |  |
| value | Json |  |

### submission_calculation

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| submission_id | Unknown | PK, FK |
| name | Unknown |  |
| type | Unknown |  |
| value | Unknown |  |

### submission_url_parameter

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| submission_id | Unknown | PK, FK |
| name | Unknown |  |
| value | Unknown |  |

### submission_schedule

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| submission_id | Unknown | PK, FK |
| email | Unknown |  |
| event_end_time | Unknown |  |
| event_id | Unknown |  |
| event_start_time | Unknown |  |
| event_url | Unknown |  |
| full_name | Unknown |  |
| name | Unknown |  |
| reschedule_or_cancel_url | Unknown |  |
| timezone | Unknown |  |

### submission_payment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| submission_id | Unknown | PK, FK |
| currency | Unknown |  |
| discount_code | Unknown |  |
| email | Unknown |  |
| name | Unknown |  |
| payment_id | Unknown |  |
| status | Unknown |  |
| stripe_customer_id | Unknown |  |
| stripe_customer_url | Unknown |  |
| stripe_payment_url | Unknown |  |
| stripe_subscription_id | Unknown |  |
| total_amount | Unknown |  |

### submission

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| form_id | Unknown | PK, FK |
| documents | Json |  |
| last_updated_at | Unknown |  |
| login_email | Unknown |  |
| quiz_max_score | Unknown |  |
| quiz_score | Unknown |  |
| submission_time | Unknown |  |

## Relationships

- form_metadata_question_option(form_metadata_id) → form_metadata(id)
- form_metadata_question_option(form_metadata_question_id) → form_metadata_question(id)
- form_metadata_question(form_metadata_id) → form_metadata(id)
- form_metadata_calculation(form_metadata_id) → form_metadata(id)
- form_metadata_url_parameter(form_metadata_id) → form_metadata(id)
- form_metadata_document(form_metadata_id) → form_metadata(id)
- form_metadata_scheduling(form_metadata_id) → form_metadata(id)
- form_metadata_payment(form_metadata_id) → form_metadata(id)
- form_metadata(id) → form(id)
- submission_question(submission_id) → submission(id)
- submission_calculation(submission_id) → submission(id)
- submission_url_parameter(submission_id) → submission(id)
- submission_schedule(submission_id) → submission(id)
- submission_payment(submission_id) → submission(id)
- submission(form_id) → form(id)