form_submission Table (485)
Some tooltip text!
• 2 minutes to read
• 2 minutes to read
A form submission
Fields
| Name | Description | Type | Null |
|---|---|---|---|
| form_submission_id | Primary key | PK | |
| form_id | The id of the parent form. | FK form | |
| when_submitted | The time of the submit. | DateTime | ● |
| contact_id | The optional id of the contact of the person who submitted. | FK contact | |
| person_id | The optional id of the person who submitted. | FK person | |
| email_address | The email address of the person who submitted | String(255) | ● |
| response_shipment_addr_id | The id of the s_shipment_addr that is the response mail | FK s_shipment_addr | |
| response | The JSON-formatted response from this form | Clob | ● |
| status | What is the status of this submission | Enum FormSubmissionStatus | |
| processing_log | A log of what happened during processing | String(4000) | ● |
Indexes
| Fields | Types | Description |
|---|---|---|
| form_submission_id | PK | Clustered, Unique |
| form_id | FK | Index |
| contact_id | FK | Index |
| person_id | FK | Index |
| response_shipment_addr_id | FK | Index |
Relationships
| Table | Description |
|---|---|
| contact | Companies and Organizations. This table features a special record containing information about the contact that owns the database. |
| form | A form which can be published on a webpage and submitted by visitors |
| form_field_value | Form field values saved in a searchable format |
| person | Persons in a company or an organizations. All associates have a corresponding person record |
| s_shipment_addr | Addresses that are ready to be sent in a shipment. |
| ticket | This table contains the tickets (requests) of the system. Its purpose should be evident. |
Replication Flags
- None
Security Flags
- No access control via user's Role.