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 10 null
userid bigint 10 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 6 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