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
roles | user_role => role | many_to_many |
user_role | userrole | has_many |