common.telehealth_sessions

Field Type Null Default Key Extra Comment
ths_id int(11) NO PRI auto_increment
ths_cus_id int(11) NO MUL
ths_cli_id int(11) NO MUL
ths_session_id varchar(255) NO MUL OpenTok session ID
ths_archive_id varchar(40) YES OpenTok Archive ID for the archived video
ths_duration time NO 00:00:00 How long was the call
ths_summed_duration time NO 00:00:00 Duration sumed from every single participant (2 participants for 5 minutes = 600 seconds)
ths_modified timestamp YES CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
ths_created timestamp YES CURRENT_TIMESTAMP

References

Local Column References
ths_id
TableColumn
_1.appointmentsapt_ths_id
_1188.appointmentsapt_ths_id
_1218.appointmentsapt_ths_id
_1548.appointmentsapt_ths_id
_435.appointmentsapt_ths_id
_436.appointmentsapt_ths_id
_436_archive_testing.appointmentsapt_ths_id
_437.appointmentsapt_ths_id
_8.appointmentsapt_ths_id
_81.appointmentsapt_ths_id
_999.appointmentsapt_ths_id
common.telehealth_duration_trackingthd_ths_id