Columns
| Column | Type | Children | Parents | Comments |
|---|---|---|---|---|
| id | int8 |
|
|
|
| company_id | int8 |
|
|
Foreign key to the company. @example 123 |
| custom_forms_response_id | int8 |
|
|
Foreign key to the custom form response being interpreted. @example 789 |
| status | varchar |
|
|
Lifecycle status of the interpretation. @example “completed” |
| input | jsonb |
|
|
Inputs captured at interpretation creation time. @example {custom_forms_response_id: 1} |
| result | jsonb |
|
|
Agent-generated interpretation of a custom form response. @example {interpretation: “Summary of form response findings.”} |
| created_at | timestamp |
|
|
|
| updated_at | timestamp |
|
|
|
| created_at_in_company_tz | timestamp |
|
|
|
| updated_at_in_company_tz | timestamp |
|
|
|
| company_timezone | varchar |
|
|
The company timezone. E.g. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| edge_custom_forms_response_interpretations_pkey | Primary key | Asc | id |
| idx_2ef79da0dbdc471f872c1bdbbd5c4a71 | Performance | Asc | custom_forms_response_id |
| idx_edge_custom_forms_response_interpretations_company_id | Performance | Asc | company_id |