user


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('user_id_seq'::regclass)
action_article.user_id action_article_user_id_foreignR
action_comment.user_id action_comment_user_id_foreignR
action_tag.user_id action_tag_user_id_foreignR
action_user.target_id action_user_target_id_foreignR
action_user.user_id action_user_user_id_foreignR
appreciation.recipient_id appreciation_recipient_id_foreignR
appreciation.sender_id appreciation_sender_id_foreignR
article.author_id article_author_id_foreignR
article_read.user_id article_read_user_id_foreignR
article_read_count.user_id article_read_count_user_id_foreignR
asset.author_id asset_author_id_foreignR
audio_draft.author_id audio_draft_author_id_foreignR
comment.author_id comment_author_id_foreignR
comment_mentioned_user.user_id comment_mentioned_user_user_id_foreignR
customer.user_id customer_user_id_foreignR
draft.author_id draft_author_id_foreignR
feedback.user_id feedback_user_id_foreignR
invitation.recipient_id invitation_recipient_id_foreignR
invitation.sender_id invitation_sender_id_foreignR
log_record.user_id log_record_user_id_foreignR
notice.recipient_id notice_recipient_id_foreignR
notice_actor.actor_id notice_actor_actor_id_foreignR
oauth_access_token.user_id oauth_access_token_user_id_foreignR
oauth_authorization_code.user_id oauth_authorization_code_user_id_foreignR
oauth_client.user_id oauth_client_user_id_foreignR
oauth_refresh_token.user_id oauth_refresh_token_user_id_foreignR
payout_account.user_id payout_account_user_id_foreignR
punish_record.user_id punish_record_user_id_foreignR
push_device.user_id push_device_user_id_foreignR
report.user_id report_user_id_foreignR
search_history.user_id serach_history_user_id_foreignR
transaction.recipient_id transaction_recipient_id_foreignR
transaction.sender_id transaction_sender_id_foreignR
transaction_obsolete.recipient_id transaction_recipient_id_foreignR
transaction_obsolete.sender_id transaction_sender_id_foreignR
user_badge.user_id user_badge_user_id_foreignR
user_boost.user_id user_boost_user_id_foreignR
user_notify_setting.user_id user_notify_setting_user_id_foreignR
user_oauth.user_id user_oauth_user_id_foreignR
username_edit_history.user_id username_edit_history_user_id_foreignR
verification_code.user_id verification_code_user_id_foreignR
uuid uuid 2147483647 null
user_name varchar 255 null
display_name varchar 255 null
description text 2147483647 √ null
avatar int8 19 √ null
asset.id user_avatar_foreignR
email varchar 255 null
email_verified bool 1 √ false
mobile varchar 255 √ null
password_hash text 2147483647 null
read_speed int4 10 √ 500
base_gravity int4 10 0
curr_gravity int4 10 0
language text 2147483647 'zh_hant'::text
role text 2147483647 'user'::text
state text 2147483647 'active'::text
created_at timestamptz 35,6 √ CURRENT_TIMESTAMP
updated_at timestamptz 35,6 √ CURRENT_TIMESTAMP
remark text 2147483647 √ null
agree_on timestamptz 35,6 √ null
liker_id varchar 255 √ null
user_oauth_likecoin.liker_id user_oauth_likecoin_liker_id_foreignR
profile_cover int8 19 √ null
payment_password_hash text 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
user_pkey Primary key Asc id
user_email_unique Must be unique Asc email
user_liker_id_unique Must be unique Asc liker_id
user_state_index Performance Asc state
user_user_name_unique Must be unique Asc user_name
user_uuid_index Performance Asc uuid
user_uuid_unique Must be unique Asc uuid

Check Constraints

Constraint Name Constraint
user_role_check ((role = ANY (ARRAY['user'::text, 'admin'::text])))
user_language_check ((language = ANY (ARRAY['zh_hant'::text, 'zh_hans'::text, 'en'::text])))
user_state_check ((state = ANY (ARRAY['onboarding'::text, 'active'::text, 'banned'::text, 'frozen'::text, 'archived'::text])))

Relationships

Close relationships within degrees of separation