auth.users
| # | Name | Type | Nullable | Default | PK |
|---|---|---|---|---|---|
| 1 | instance_id | uuid | YES | — | |
| 2 | id | uuid | NO | — | PK |
| 3 | aud | character varying | YES | — | |
| 4 | role | character varying | YES | — | |
| 5 | email | character varying | YES | — | |
| 6 | encrypted_password | character varying | YES | — | |
| 7 | email_confirmed_at | timestamp with time zone | YES | — | |
| 8 | invited_at | timestamp with time zone | YES | — | |
| 9 | confirmation_token | character varying | YES | — | |
| 10 | confirmation_sent_at | timestamp with time zone | YES | — | |
| 11 | recovery_token | character varying | YES | — | |
| 12 | recovery_sent_at | timestamp with time zone | YES | — | |
| 13 | email_change_token_new | character varying | YES | — | |
| 14 | email_change | character varying | YES | — | |
| 15 | email_change_sent_at | timestamp with time zone | YES | — | |
| 16 | last_sign_in_at | timestamp with time zone | YES | — | |
| 17 | raw_app_meta_data | jsonb | YES | — | |
| 18 | raw_user_meta_data | jsonb | YES | — | |
| 19 | is_super_admin | boolean | YES | — | |
| 20 | created_at | timestamp with time zone | YES | — | |
| 21 | updated_at | timestamp with time zone | YES | — | |
| 22 | phone | text | YES | NULL::character varying | |
| 23 | phone_confirmed_at | timestamp with time zone | YES | — | |
| 24 | phone_change | text | YES | ''::character varying | |
| 25 | phone_change_token | character varying | YES | ''::character varying | |
| 26 | phone_change_sent_at | timestamp with time zone | YES | — | |
| 27 | confirmed_at | timestamp with time zone | YES | — | |
| 28 | email_change_token_current | character varying | YES | ''::character varying | |
| 29 | email_change_confirm_status | smallint | YES | 0 | |
| 30 | banned_until | timestamp with time zone | YES | — | |
| 31 | reauthentication_token | character varying | YES | ''::character varying | |
| 32 | reauthentication_sent_at | timestamp with time zone | YES | — | |
| 33 | is_sso_user | boolean | NO | false | |
| 34 | deleted_at | timestamp with time zone | YES | — | |
| 35 | is_anonymous | boolean | NO | false |
Indexes
| Name | Definition | Unique | Primary | Size |
|---|---|---|---|---|
| confirmation_token_idx | CREATE UNIQUE INDEX confirmation_token_idx ON auth.users USING btree (confirmation_token) WHERE ((confirmation_token)::text !~ '^[0-9 ]*$'::text) | ✓ | 8192 bytes | |
| email_change_token_current_idx | CREATE UNIQUE INDEX email_change_token_current_idx ON auth.users USING btree (email_change_token_current) WHERE ((email_change_token_current)::text !~ '^[0-9 ]*$'::text) | ✓ | 8192 bytes | |
| email_change_token_new_idx | CREATE UNIQUE INDEX email_change_token_new_idx ON auth.users USING btree (email_change_token_new) WHERE ((email_change_token_new)::text !~ '^[0-9 ]*$'::text) | ✓ | 8192 bytes | |
| reauthentication_token_idx | CREATE UNIQUE INDEX reauthentication_token_idx ON auth.users USING btree (reauthentication_token) WHERE ((reauthentication_token)::text !~ '^[0-9 ]*$'::text) | ✓ | 8192 bytes | |
| recovery_token_idx | CREATE UNIQUE INDEX recovery_token_idx ON auth.users USING btree (recovery_token) WHERE ((recovery_token)::text !~ '^[0-9 ]*$'::text) | ✓ | 8192 bytes | |
| users_email_partial_key | CREATE UNIQUE INDEX users_email_partial_key ON auth.users USING btree (email) WHERE (is_sso_user = false) | ✓ | 8192 bytes | |
| users_instance_id_email_idx | CREATE INDEX users_instance_id_email_idx ON auth.users USING btree (instance_id, lower((email)::text)) | 8192 bytes | ||
| users_instance_id_idx | CREATE INDEX users_instance_id_idx ON auth.users USING btree (instance_id) | 8192 bytes | ||
| users_is_anonymous_idx | CREATE INDEX users_is_anonymous_idx ON auth.users USING btree (is_anonymous) | 8192 bytes | ||
| users_phone_key | CREATE UNIQUE INDEX users_phone_key ON auth.users USING btree (phone) | ✓ | 8192 bytes | |
| users_pkey | CREATE UNIQUE INDEX users_pkey ON auth.users USING btree (id) | ✓ | ✓ | 8192 bytes |
Constraints
| Name | Type | Definition |
|---|---|---|
| users_email_change_confirm_status_check | CHECK | CHECK (((email_change_confirm_status >= 0) AND (email_change_confirm_status <= 2))) |
| users_pkey | PRIMARY KEY | PRIMARY KEY (id) |
| users_phone_key | UNIQUE | UNIQUE (phone) |