Table "public.user"
             Column             |          Type           | Collation | Nullable |             Default              | Storage  | Compression | Stats target | Description
--------------------------------+-------------------------+-----------+----------+----------------------------------+----------+-------------+--------------+-------------
 id                             | bigint                  |           | not null | nextval('user_id_seq'::regclass) | plain    |             |              |
 lower_name                     | character varying(255)  |           | not null |                                  | extended |             |              |
 name                           | character varying(255)  |           | not null |                                  | extended |             |              |
 full_name                      | character varying(255)  |           |          |                                  | extended |             |              |
 email                          | character varying(255)  |           | not null |                                  | extended |             |              |
 keep_email_private             | boolean                 |           |          |                                  | plain    |             |              |
 email_notifications_preference | character varying(20)   |           | not null | 'enabled'::character varying     | extended |             |              |
 passwd                         | character varying(255)  |           | not null |                                  | extended |             |              |
 passwd_hash_algo               | character varying(255)  |           | not null | 'argon2'::character varying      | extended |             |              |
 must_change_password           | boolean                 |           | not null | false                            | plain    |             |              |
 login_type                     | integer                 |           |          |                                  | plain    |             |              |
 login_source                   | bigint                  |           | not null | 0                                | plain    |             |              |
 login_name                     | character varying(255)  |           |          |                                  | extended |             |              |
 type                           | integer                 |           |          |                                  | plain    |             |              |
 location                       | character varying(255)  |           |          |                                  | extended |             |              |
 website                        | character varying(255)  |           |          |                                  | extended |             |              |
 rands                          | character varying(32)   |           |          |                                  | extended |             |              |
 salt                           | character varying(32)   |           |          |                                  | extended |             |              |
 language                       | character varying(5)    |           |          |                                  | extended |             |              |
 description                    | character varying(255)  |           |          |                                  | extended |             |              |
 created_unix                   | bigint                  |           |          |                                  | plain    |             |              |
 updated_unix                   | bigint                  |           |          |                                  | plain    |             |              |
 last_login_unix                | bigint                  |           |          |                                  | plain    |             |              |
 last_repo_visibility           | boolean                 |           |          |                                  | plain    |             |              |
 max_repo_creation              | integer                 |           | not null | '-1'::integer                    | plain    |             |              |
 is_active                      | boolean                 |           |          |                                  | plain    |             |              |
 is_admin                       | boolean                 |           |          |                                  | plain    |             |              |
 is_restricted                  | boolean                 |           | not null | false                            | plain    |             |              |
 allow_git_hook                 | boolean                 |           |          |                                  | plain    |             |              |
 allow_import_local             | boolean                 |           |          |                                  | plain    |             |              |
 allow_create_organization      | boolean                 |           |          | true                             | plain    |             |              |
 prohibit_login                 | boolean                 |           | not null | false                            | plain    |             |              |
 avatar                         | character varying(2048) |           | not null |                                  | extended |             |              |
 avatar_email                   | character varying(255)  |           | not null |                                  | extended |             |              |
 use_custom_avatar              | boolean                 |           |          |                                  | plain    |             |              |
 num_followers                  | integer                 |           |          |                                  | plain    |             |              |
 num_following                  | integer                 |           | not null | 0                                | plain    |             |              |
 num_stars                      | integer                 |           |          |                                  | plain    |             |              |
 num_repos                      | integer                 |           |          |                                  | plain    |             |              |
 num_teams                      | integer                 |           |          |                                  | plain    |             |              |
 num_members                    | integer                 |           |          |                                  | plain    |             |              |
 visibility                     | integer                 |           | not null | 0                                | plain    |             |              |
 repo_admin_change_team_access  | boolean                 |           | not null | false                            | plain    |             |              |
 diff_view_style                | character varying(255)  |           | not null | ''::character varying            | extended |             |              |
 theme                          | character varying(255)  |           | not null | ''::character varying            | extended |             |              |
 keep_activity_private          | boolean                 |           | not null | false                            | plain    |             |              |
Indexes:
    "user_pkey" PRIMARY KEY, btree (id)
    "IDX_user_created_unix" btree (created_unix)
    "IDX_user_is_active" btree (is_active)
    "IDX_user_last_login_unix" btree (last_login_unix)
    "IDX_user_updated_unix" btree (updated_unix)
    "UQE_user_lower_name" UNIQUE, btree (lower_name)
    "UQE_user_name" UNIQUE, btree (name)
Access method: heap