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