User To Help for Developers

This contains the information for users of Reg. Username, password, personal colors, etc.

Table: user

bg
RGB values for background
cell
cell phone number
email
email address
expiry_date
the date the password expires
fg
RGB values for foreground
first
first name
hide_mmi
should MMI programs be hidden from you?
id
unique id
last
last name
last_login_date
date of the last time they logged in
link
RGB values for links
locked
is this account locked?
nfails
the number of consecutive password failures
office
office phone number
password
password - in clear text :(
txt_msg_email
email address to send a text message to this person
username
the login name

Relations

rolesuser_role => rolemany_to_many
user_roleuserrolehas_many