my_pages

0 rows


Description

Extra user pages for the My Moodle system

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
userid BIGINT 19 0
user.id my_pages_erd_useridR

The user who owns this page or 0 for system defaults

name VARCHAR 200

The page name (freeform text)

private BIT 1 1

Whether or not the page is private (dashboard) or public (profile)

sortorder MEDIUMINT 7 0

The order of the pages for a user

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
mypage_usepri_ix Performance Asc/Asc userid + private

Relationships