My Pages Table Schema (my_pages)


Extra user pages for the My Moodle system

my_pages table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
userid BIGINT 19 0 Implied Constraint R

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

Table contained -1 rows

my_pages table indexes

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

my_pages table relationships