MODX Revolution Object Cheat Sheet: modUserProfile

modUserProfile (2.8.3-pl)

Table Fields


    [id] =>
    [internalKey] =>
    [fullname] =>
    [email] =>
    [phone] =>
    [mobilephone] =>
    [blocked] => 0
    [blockeduntil] => 0
    [blockedafter] => 0
    [logincount] => 0
    [lastlogin] => 0
    [thislogin] => 0
    [failedlogincount] => 0
    [sessionid] =>
    [dob] => 0
    [gender] => 0
    [address] =>
    [country] =>
    [city] =>
    [state] =>
    [zip] =>
    [fax] =>
    [photo] =>
    [comment] =>
    [website] =>
    [extended] =>

Validation Rules




Index Meta


    [PRIMARY] =>
            [alias] => PRIMARY
            [primary] => 1
            [unique] => 1
            [type] => BTREE
            [columns] =>
                    [id] =>
                            [length] =>
                            [collation] => A
                            [null] =>

    [internalKey] =>
            [alias] => internalKey
            [primary] =>
            [unique] => 1
            [type] => BTREE
            [columns] =>
                    [internalKey] =>
                            [length] =>
                            [collation] => A
                            [null] =>

Field Aliases




Table Construction meta defined in schema


    [id] =>
            [dbtype] => INTEGER
            [phptype] => integer
            [null] =>
            [index] => pk
            [generated] => native
            [attributes] => unsigned

    [internalKey] =>
            [dbtype] => int
            [precision] => 10
            [phptype] => integer
            [null] =>
            [index] => unique

    [fullname] =>
            [dbtype] => varchar
            [precision] => 100
            [phptype] => string
            [null] =>
            [default] =>

    [email] =>
            [dbtype] => varchar
            [precision] => 100
            [phptype] => string
            [null] =>
            [default] =>

    [phone] =>
            [dbtype] => varchar
            [precision] => 100
            [phptype] => string
            [null] =>
            [default] =>

    [mobilephone] =>
            [dbtype] => varchar
            [precision] => 100
            [phptype] => string
            [null] =>
            [default] =>

    [blocked] =>
            [dbtype] => tinyint
            [precision] => 1
            [attributes] => unsigned
            [phptype] => boolean
            [null] =>
            [default] => 0

    [blockeduntil] =>
            [dbtype] => int
            [precision] => 11
            [phptype] => integer
            [null] =>
            [default] => 0

    [blockedafter] =>
            [dbtype] => int
            [precision] => 11
            [phptype] => integer
            [null] =>
            [default] => 0

    [logincount] =>
            [dbtype] => int
            [precision] => 11
            [phptype] => integer
            [null] =>
            [default] => 0

    [lastlogin] =>
            [dbtype] => int
            [precision] => 11
            [phptype] => integer
            [null] =>
            [default] => 0

    [thislogin] =>
            [dbtype] => int
            [precision] => 11
            [phptype] => integer
            [null] =>
            [default] => 0

    [failedlogincount] =>
            [dbtype] => int
            [precision] => 10
            [phptype] => integer
            [null] =>
            [default] => 0

    [sessionid] =>
            [dbtype] => varchar
            [precision] => 100
            [phptype] => string
            [null] =>
            [default] =>

    [dob] =>
            [dbtype] => int
            [precision] => 10
            [phptype] => integer
            [null] =>
            [default] => 0

    [gender] =>
            [dbtype] => int
            [precision] => 1
            [phptype] => integer
            [null] =>
            [default] => 0

    [address] =>
            [dbtype] => text
            [phptype] => string
            [null] =>
            [default] =>

    [country] =>
            [dbtype] => varchar
            [precision] => 191
            [phptype] => string
            [null] =>
            [default] =>

    [city] =>
            [dbtype] => varchar
            [precision] => 191
            [phptype] => string
            [null] =>
            [default] =>

    [state] =>
            [dbtype] => varchar
            [precision] => 25
            [phptype] => string
            [null] =>
            [default] =>

    [zip] =>
            [dbtype] => varchar
            [precision] => 25
            [phptype] => string
            [null] =>
            [default] =>

    [fax] =>
            [dbtype] => varchar
            [precision] => 100
            [phptype] => string
            [null] =>
            [default] =>

    [photo] =>
            [dbtype] => varchar
            [precision] => 191
            [phptype] => string
            [null] =>
            [default] =>

    [comment] =>
            [dbtype] => text
            [phptype] => string
            [null] =>
            [default] =>

    [website] =>
            [dbtype] => varchar
            [precision] => 191
            [phptype] => string
            [null] =>
            [default] =>

    [extended] =>
            [dbtype] => text
            [phptype] => json
            [null] => 1
            [index] => fulltext
            [indexgrp] => extended

Aggregate Relations


    [User] =>
            [class] => modUser
            [local] => internalKey
            [foreign] => id
            [cardinality] => one
            [owner] => foreign

Composite Relations




Ancestors


    [0] => modUserProfile
    [1] => xPDOSimpleObject
    [2] => xPDOObject