# forum

0 rows

### Description

Forum discussion system. For sample reports see https://docs.moodle.org/en/ad-hoc_contributed_reports#Forum_Activity

### Columns

Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments
--- | --- | --- | --- | --- | --- | --- | --- | ---
id | BIGINT | 19 |  | √ | null |
forum_digests.forum | forudige_for2_fkR
forum_discussion_subs.forum | forudiscsubs_for2_fkR
forum_discussions.forum | forudisc_for2_fkR
forum_grades.forum | forugrad_for2_fkR
forum_read.forumid | forum_read_erd_forum_idR
forum_subscriptions.forum | forusubs_for2_fkR
forum_track_prefs.forumid | Implied ConstraintR
forum_track_prefs.userid | forum_track_prefs_erd_forum_idR
course | BIGINT | 19 |  |  | 0 |  |  |
type | VARCHAR | 20 |  |  | general |  |  |
name | VARCHAR | 1333 |  |  |  |  |  |
intro | LONGTEXT | 2147483647 |  |  | null |  |  |
introformat | SMALLINT | 5 |  |  | 0 |  |  | text format of intro field
duedate | BIGINT | 19 |  |  | 0 |  |  | A due date to show in the calendar. Not used for grading.
cutoffdate | BIGINT | 19 |  |  | 0 |  |  | The final date after which forum posts will no longer be accepted for this forum.
assessed | BIGINT | 19 |  |  | 0 |  |  | Rating aggregate type can be: average, count, maximum, minimum, sum. As integers
assesstimestart | BIGINT | 19 |  |  | 0 |  |  |
assesstimefinish | BIGINT | 19 |  |  | 0 |  |  |
scale | BIGINT | 19 |  |  | 0 |  |  |
grade_forum | BIGINT | 19 |  |  | 0 |  |  |
grade_forum_notify | SMALLINT | 5 |  |  | 0 |  |  |
maxbytes | BIGINT | 19 |  |  | 0 |  |  |
maxattachments | BIGINT | 19 |  |  | 1 |  |  | Number of attachments allowed per post
forcesubscribe | BIT | 1 |  |  | 0 |  |  |
trackingtype | TINYINT | 3 |  |  | 1 |  |  |
rsstype | TINYINT | 3 |  |  | 0 |  |  |
rssarticles | TINYINT | 3 |  |  | 0 |  |  |
timemodified | BIGINT | 19 |  |  | 0 |  |  |
warnafter | BIGINT | 19 |  |  | 0 |  |  |
blockafter | BIGINT | 19 |  |  | 0 |  |  |
blockperiod | BIGINT | 19 |  |  | 0 |  |  |
completiondiscussions | INT | 10 |  |  | 0 |  |  | Nonzero if a certain number of posts are required to mark this forum completed for a user.
completionreplies | INT | 10 |  |  | 0 |  |  | Nonzero if a certain number of replies are required to mark this forum complete for a user.
completionposts | INT | 10 |  |  | 0 |  |  | Nonzero if a certain number of posts or replies (total) are required to mark this forum complete for a user.
displaywordcount | BIT | 1 |  |  | 0 |  |  |
lockdiscussionafter | BIGINT | 19 |  |  | 0 |  |  |

### Indexes

Constraint Name | Type | Sort | Column(s)
--- | --- | --- | ---
PRIMARY | Primary key | Asc | id
foru_cou_ix | Performance | Asc | course

### Relationships