app_totara_msteams_user

0 rows


Description

Stores user mapping for MS Teams.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('app_totara_msteams_user_id_seq'::regclass)
app_totara_msteams_subscription.msuserid Defined in XML R
teams_id varchar 255 ''::character varying
verified int2 5 0
mschannelid int8 19 null
app_totara_msteams_channel.id Defined in XML R
userid int8 19 null
app_user.id Defined in XML R

Indexes

Constraint Name Type Sort Column(s)
app_totamsteuser_id_pk Primary key Asc id
app_totamsteuser_msc_ix Performance Asc mschannelid
app_totamsteuser_teamsc_uix Must be unique Asc/Asc teams_id + mschannelid
app_totamsteuser_use_ix Performance Asc userid

Relationships

Close relationships within degrees of separation