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 Implied Constraint R
timecreated BIGINT 19 null

Table contained -1 rows

comments table indexes

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

comments table relationships

Close relationships within degrees of separation