caredb_orgcore_observation
Columns
| Name | Type | Not null | Description |
|---|---|---|---|
| code | character varying(32) | True | |
| created_at | timestamp without time zone | True | |
| created_by_id | character varying(32) | False | |
| description | character varying(255) | True | |
| diagnostic_report_id | character varying(32) | False | Links to caredb_orgcore_diagnosticreport.id. |
| effective_time | timestamp without time zone | True | |
| encounter_id | character varying(32) | False | Links to caredb_orgcore_encounter.id. |
| external_id | character varying(255) | True | |
| id | character varying(32) | True | |
| individual_group_id | character varying(32) | False | |
| interpretation | character varying(16) | True | |
| is_active | boolean | True | |
| last_modified_at | timestamp without time zone | True | |
| last_modified_by_id | character varying(32) | False | |
| note | character varying(65535) | True | |
| organization_id | character varying(32) | True | |
| patient_id | character varying(32) | True | Links to caredb_core_patient.id. |
| reference_range | character varying(65535) | True | |
| status | character varying(16) | True | |
| value | character varying(65535) | True | |
| video_channel_id | character varying(32) | False | |
| visible | boolean | True |