bigbluebuttonbn_logs

0 rows


Description

The bigbluebuttonbn table to store meeting activity events

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
courseid BIGINT 19 null
course.id Implied ConstraintR
bigbluebuttonbnid BIGINT 19 null
bigbluebuttonbn.id Implied ConstraintR
userid BIGINT 19 null
timecreated BIGINT 19 0
meetingid VARCHAR 256
log VARCHAR 32
meta LONGTEXT 2147483647 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
bigblogs_cou_ix Performance Asc courseid
bigblogs_coubig_ix Performance Asc/Asc courseid + bigbluebuttonbnid
bigblogs_coubiguselog_ix Performance Asc/Asc/Asc/Asc courseid + bigbluebuttonbnid + userid + log
bigblogs_log_ix Performance Asc log
bigblogs_uselog_ix Performance Asc/Asc userid + log

Relationships