caredb_orgcore_appointment
Columns
| Name | Type | Not null | Description |
|---|---|---|---|
| comment | character varying(65535) | True | |
| created_at | timestamp without time zone | True | |
| created_by_id | character varying(32) | False | |
| description | character varying(65535) | True | |
| end_time | timestamp without time zone | True | |
| external_id | character varying(255) | True | |
| id | character varying(32) | True | |
| is_active | boolean | True | |
| last_modified_at | timestamp without time zone | True | |
| last_modified_by_id | character varying(32) | False | |
| location | character varying(65535) | True | |
| organization_id | character varying(32) | True | |
| patient_instruction | character varying(65535) | True | |
| practitioner_id | character varying(32) | True | |
| reminder_hours_before_start_time | bigint | True | |
| reminder_scheduler_id | character varying(32) | False | |
| start_time | timestamp without time zone | True | |
| status_id | character varying(32) | False | Links to caredb_orgcore_appointmentstatus.id. |
| subject_id | character varying(32) | True | Links to caredb_core_patient.id. |
| type_id | character varying(32) | False | Links to caredb_orgcore_appointmenttype.id. |
| video_channel_id | character varying(32) | False | |
| video_channel_join_start | timestamp without time zone | False |