comlink_telehealth_appointment_session


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
user_id BIGINT 19 null

Foreign key reference to users.id
pc_eid INT UNSIGNED 10 null

Foreign key reference to openemr_postcalendar_events.pc_eid
encounter BIGINT 19 null

Foreign key reference to forms.encounter
pid BIGINT 19 null

Foreign key reference to patient_data.pid
provider_start_time DATETIME 19 √ current_timestamp()

Provider start time
provider_last_update DATETIME 19 √ NULL

Provider last communication timestamp
patient_start_time DATETIME 19 √ NULL

Patient join time
patient_last_update DATETIME 19 √ NULL

Last communication timestamp with patient
pid_related BIGINT 19 √ NULL

Foreign key reference to patient_data.pid for related patient
patient_related_start_time DATETIME 19 √ NULL

Related Patient join time
patient_related_last_update DATETIME 19 √ NULL

Last communication timestamp with related patient

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id

Relationships

Close relationships within degrees of separation