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
Level:
Beginner
Dependencies: None
modUserProfile (2.8.1-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