Columns
| Column | Type | Children | Parents | Comments |
|---|---|---|---|---|
| id | int8 |
|
|
|
| company_id | int8 |
|
|
Foreign key to the company. @example 123 |
| custom_forms_template_id | int8 |
|
|
Foreign key to the custom form template the summary is for. @example 789 |
| subject_id | int8 |
|
|
Foreign key to the subject the summary is for. @example 456 |
| status | varchar |
|
|
Lifecycle status of the summary. @example “completed” |
| input | jsonb |
|
|
Inputs captured at summary creation time. @example {form_title: “Falls Risk Assessment Tool”} |
| result | jsonb |
|
|
Agent-generated summary of a chronological list of custom form response interpretations. @example {title: “Title of the summary”, summary: “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_history_summaries_pkey | Primary key | Asc | id |
| idx_6c9d9de68a10220afc2f68349371b38f | Performance | Asc | custom_forms_template_id |
| idx_edge_custom_forms_response_history_summaries_company_id | Performance | Asc | company_id |
| idx_edge_custom_forms_response_history_summaries_subject_id | Performance | Asc | subject_id |