This website uses cookies We use cookies on this website to provide services, features and to analyze our traffic. You consent to our cookies if you continue to use our website. Accept Cookies Find out more

Table: user_account

KB60 Last reviewed 27 November 2013
A description of the user_account table within the Camino CMS database schema.

Stores user account data.

Field Type Null Key Default Description
user_id int(10) No Primary
creator_uid int(10) No The ID of the user account that created this account
organisation_id int(10) No 0 The primary organisation (see organisation table) for this user
primary_usergroupid int(10) No 0 Depreciated - will be removed in DB Cleanup in Camino CMS 0.6
user_username varchar(100) No Multiple The user's username
user_password varchar(50) No Multiple The encrypted user password
user_activationcode varchar(255) No The activation code for this account. This will be updated on account security actions.
user_uuid varchar(40) No user_uuid The unique ID string for the user
user_firstname varchar(100) No The user's first name
user_lastname varchar(100) No The user's last name or surname
user_title varchar(50) No The user's title
user_namesuffix varchar(100) No Any title or accreditations usually displayed after a user's name
user_displayname varchar(200) No The name commonly used for the user. Normally a composite of first name and last name
user_email varchar(100) No The user's e-mail address
user_jobtitle varchar(100) No The user's job title or position
user_referralcode varchar(100) No Any referral code that applies to this account
user_gender varchar(10) No The user's gender
user_accountstate tinyint(2) No user_login 0 0, 1 or 2 - indicates whether an account is active or not. 1 = active
user_permitinteractivelogon tinyint(2) No user_login 0 1 or 0 - used to permit/deny a user account logon privileges irrespective of their account state
user_agreedtoterms tinyint(2) No user_login 0 1 or 0 - indicates whether the user has agreed to the site's terms and conditions of use
user_agreedtoalerts tinyint(2) No user_login 0 1 or 0 - indicates whether the user has agreed to receive email alerts from the site
user_agreedtonewsletter tinyint(2) No user_login 0 1 or 0 - indicates whether the user has agreed/declined to receive newsletter emails from the site
user_cookiesaccepeted tinyint(2) No 0 1 or 0 - indicates whether a user has agreed/declined to accept site cookies. This is included as part of the EU Cookies Directive
user_accountexpirydate datetime No user_login 0000-00-00 00:00:00 The MySQL timestamp when this account will expire (this date may be altered)
user_disablenotes mediumtext Yes Contains any notes that may have been submitted if the account is disabled
user_signature mediumtext Yes The signature that will appear in messages sent by the user within the site
user_passwordremindercount int(10) No 0 The number of times the user has requested a password reset
user_activationcodedate datetime No 0000-00-00 00:00:00 The MySQL timestamp of the last occasion on which the user's activation code (see above) was changed
user_created datetime No 0000-00-00 00:00:00 The MySQL timestamp of when the user account was created
user_lastmodified datetime No 0000-00-00 00:00:00 The MySQL timestampe of when the user account was last updated or edited.

Indexes

Keyname Type Cardinality Field(s) Description
PRIMARY PRIMARY 0 user_id
user_username Index n/a user_username
username_password Index n/a user_username, user_password
user_login Index n/a user_username, userpassword, user_accountstate, user_permitinteractivelogon, user_agreedtoterms, user_agreedtoalerts, user_agreedtonewsletter, user_accountexpirydate
user_uuid FullText n/a user_uuid
3
 Loading ...
Copyright © 2011 - 2017 Calzada Media Limited. All Rights Reserved.