Users
The users table contains data about users in the organization.
This table can be used to determine which users exist, as well as metadata about the user such as when it was created.
Columns
| Column Name | Description | Type | Nullable |
|---|---|---|---|
| id | The numerical identifier of the object. | INT8 | No |
| The email address the user logs in with. | VARCHAR | No | |
| role | The permission level of the user. One of administrator, lead, organizer, or activist. |
VARCHAR | No |
| first_name | The first name of the user. | VARCHAR | No |
| last_name | The last name of the user. | VARCHAR | No |
| created_at | The UTC timestamp when this object was created. | TIMESTAMP | No |
| updated_at | The UTC timestamp when this object was updated. | TIMESTAMP | No |
| provider | This column is currently unused. Always email. |
VARCHAR | No |
| uid | The email address the user logs in with. | VARCHAR | No |
| encrypted_password | The encrypted password of the user. | VARCHAR | No |
| reset_password_token | The reset password token for the user. | VARCHAR | Yes |
| reset_password_sent_at | The UTC timestamp when the password reset request was sent. | TIMESTAMP | Yes |
| remember_created_at | This column is currently unused and always blank. | TIMESTAMP | Yes |
| sign_in_count | The number of times the user has successfully signed in. | INT4 | No |
| current_sign_in_at | The UTC timestamp when this user most recently signed in. | TIMESTAMP | Yes |
| last_sign_in_at | The UTC timestamp when this user last signed in, before the most recent sign in. | TIMESTAMP | Yes |
| current_sign_in_ip | The IP addressed used by the user on their most recent sign in. | VARCAHR | Yes |
| last_sign_in_ip | The IP addressed used by the user on their last sign in, before the most recent sign in. | VARCAHR | Yes |
| confirmation_token | The confirmation token for the user. | VARCHAR | Yes |
| confirmed_at | The UTC timestamp when this user confirmed their email address on first sign in. | TIMESTAMP | Yes |
| confirmation_sent_at | The UTC timestamp when this user was sent a confirmation email before their first sign in. | TIMESTAMP | Yes |
| unconfirmed_email | This column is currently unused and always blank. | TIMESTAMP | Yes |
| tokens | This column is only relevant to our backend systems. | TEXT | Yes |
| confirmed_at | The UTC timestamp when this user confirmed their email address on first sign in. | TIMESTAMP | Yes |
| invitation_token | The invitation token for the user. | VARCHAR | Yes |
| invitation_created_at | The UTC timestamp when this user's invitation was created. | TIMESTAMP | Yes |
| invitation_sent_at | The UTC timestamp when this user was sent an invitation. | TIMESTAMP | Yes |
| invitation_sent_at | The UTC timestamp when this user's invitation was accepted. | TIMESTAMP | Yes |
| invitation_limit | This column is currently unused and always blank. | INT4 | Yes |
| invited_by_type | The type of object that created the invitation. Always User. |
INT4 | Yes |
| invited_by_id | The numerical identifier of the user who created the invitation. Relates to the id column in the users table. |
INT8 | Yes |
| invitations_count | This column is currently unused. Always 0. |
INT4 | No |
| phone_number | The phone number of the user. | VARACHAR | Yes |
| allow_password_change | This column is currently unused. | BOOL | No |
| deleted_at | The UTC timestamp when this user was disabled. | TIMESTAMP | Yes |
| authentication_token | This column is currently unused. | VARACHAR | Yes |
| api_access | This column is currently unused. | BOOL | Yes |
| disable_on | The UTC timestamp when this user will be disabled, if scheduled to be disabled. | TIMESTAMP | Yes |