Chat table / chat - Moodle LMS 3.9 Database schema / Zoola Analytics

chat table columns

Related columns Constraint Comments

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

id

BIGINT

19

√

null

chat_messages.chatid	chatmess_cha2_fk R
chat_messages_current.chatid	chatmesscurr_cha2_fk R
chat_users.chatid	chatuser_cha2_fk R

course

BIGINT

19

0

name

VARCHAR

255

intro

LONGTEXT

2147483647

null

introformat

SMALLINT

5

0

text format of intro field

keepdays

BIGINT

19

0

studentlogs

SMALLINT

5

0

chattime

BIGINT

19

0

schedule

SMALLINT

5

0

timemodified

BIGINT

19

0

Showing 1 to 10 of 10 entries

Table contained -1 rows

chat table indexes

Search:

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

Showing 1 to 2 of 2 entries

Chat Table Schema (chat)

Description

chat table columns

chat table indexes

chat table relationships

Close relationships within degrees of separation