Comments Table Schema (comments)


Description

moodle comments module

comments table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
contextid BIGINT 19 null
context.id Implied Constraint R
component VARCHAR 255 √ null

The plugin this comment belongs to.
commentarea VARCHAR 255
itemid BIGINT 19 null
content LONGTEXT 2147483647 null
format TINYINT 3 0
userid BIGINT 19 null
user.id comm_use2_fk R
timecreated BIGINT 19 null

Table contained -1 rows

comments table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
comm_concomite_ix Performance Asc/Asc/Asc contextid + commentarea + itemid
comm_use_ix Performance Asc userid

comments table relationships

Close relationships within degrees of separation