MODX Revolution Object Cheat Sheet: modUserProfile

MODX Revolution Object Cheat Sheet: modUserProfile

modUserProfile database table fields, schema definitions, and relationships: aggregate, composite, ancestral. Also provides default object values.

Posted on February 02, 2015 at 13:51:00
Tags: Cheatsheet, modUserProfile
Words: 563
Level: Beginner
Dependencies: None

modUserProfile (2.6.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

MODX:
Website development platform combining security, power, and innovation.