> ## Documentation Index
> Fetch the complete documentation index at: https://docs.superoffice.com/llms.txt
> Use this file to discover all available pages before exploring further.

# form_submission table

> A form submission

## form\_submission Table (489)

A form submission

## Fields

| Name                         | Description                                                 | Type                                                          | Nullable |
| ---------------------------- | ----------------------------------------------------------- | ------------------------------------------------------------- | :------: |
| form\_submission\_id         | Primary key                                                 | PK                                                            |    No    |
| form\_id                     | The id of the parent form.                                  | FK [form](./form.mdx)                                         |    No    |
| when\_submitted              | The time of the submit.                                     | DateTime                                                      |    Yes   |
| contact\_id                  | The optional id of the contact of the person who submitted. | FK [contact](./contact.mdx)                                   |    No    |
| person\_id                   | The optional id of the person who submitted.                | FK [person](./person.mdx)                                     |    No    |
| email\_address               | The email address of the person who submitted               | String(255)                                                   |    Yes   |
| response\_shipment\_addr\_id | The id of the s\_shipment\_addr that is the response mail   | FK [s\_shipment\_addr](./s-shipment-addr.mdx)                 |    No    |
| response                     | The JSON-formatted response from this form                  | Clob                                                          |    Yes   |
| status                       | What is the status of this submission                       | Enum [FormSubmissionStatus](./enums/formsubmissionstatus.mdx) |    No    |
| processing\_log              | A log of what happened during processing                    | String(4000)                                                  |    Yes   |

<img src="https://mintcdn.com/superofficeas/6OcOTPa_ISkjXJg4/media/loc/en/database/tables/form_submission.png?fit=max&auto=format&n=6OcOTPa_ISkjXJg4&q=85&s=001fc8cb6ecaf135a8b86ebf716fc4ce" alt="form_submission table relationship diagram" width="831" height="768" data-path="media/loc/en/database/tables/form_submission.png" />

## Indexes

| Fields                       | Types | Description |
| ---------------------------- | ----- | ----------- |
| form\_id                     | FK    | Index       |
| contact\_id                  | FK    | Index       |
| person\_id                   | FK    | Index       |
| response\_shipment\_addr\_id | FK    | Index       |

## Relationships

| Table                                    | Description                                                                              |
| ---------------------------------------- | ---------------------------------------------------------------------------------------- |
| [contact](./contact)                     | Companies and Organizations.                                                             |
| [form](./form)                           | A form which can be published on a webpage and submitted by visitors                     |
| [form\_field\_value](./form-field-value) | Form field values saved in a searchable format                                           |
| [person](./person)                       | Persons                                                                                  |
| [s\_shipment\_addr](./s-shipment-addr)   | Addresses that are ready to be sent in a shipment.                                       |
| [ticket](./ticket)                       | This table contains the tickets (requests) of the system. Its purpose should be evident. |
| [utm\_parameters](./utm-parameters)      | Table for utm parameters collected from visits and formsubmissions                       |

## Replication Flags

* None

## Security Flags

* No access control via user's Role.


## Related topics

- [FormSubmission](/en/api/archive-providers/reference/formsubmission.md)
- [FormSubmissionSelectionV2](/en/api/archive-providers/reference/formsubmissionselectionv2.md)
- [form table](/en/database/tables/form.md)
- [FormSubmissionSelectionCombinedV2](/en/api/archive-providers/reference/formsubmissionselectioncombinedv2.md)
- [FormSubmissionShadowSelectionV2](/en/api/archive-providers/reference/formsubmissionshadowselectionv2.md)
- [FormSubmissionStaticSelectionV2](/en/api/archive-providers/reference/formsubmissionstaticselectionv2.md)