users

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
user_id serial 10 √ nextval('users_user_id_seq'::regclass)
banned_users_per_streamer.banned_by banned_users_per_streamer_banned_by_fkey R
banned_users_per_streamer.streamer_id banned_users_per_streamer_streamer_id_fkey R
banned_users_per_streamer.user_id banned_users_per_streamer_user_id_fkey R
chat_messages.user_id chat_messages_user_id_fkey R
refresh_tokens.user_id refresh_tokens_user_id_fkey R
sessions.user_id sessions_user_id_fkey R
streams.streamer_id streams_streamer_id_fkey R
subscribers.streamer_id subscribers_streamer_id_fkey R
subscribers.user_id subscribers_user_id_fkey R
user_roles.streamer_id user_roles_streamer_id_fkey N
user_roles.user_id user_roles_user_id_fkey R
email citext 2147483647 null
username citext 2147483647 null
password text 2147483647 null
created_at timestamp 26,3 CURRENT_TIMESTAMP
avatar text 2147483647 ''::text
profile_banner text 2147483647 ''::text
description text 2147483647 'Default description'::text
is_banned bool 1 false
ban_reason text 2147483647 √ null
ban_expires_at timestamp 26,3 √ null
stream_token text 2147483647 √ ''::text

Indexes

Constraint Name Type Sort Column(s)
users_pkey Primary key Asc user_id
users_created_at_idx Performance Asc created_at
users_email_key Must be unique Asc email
users_user_id_key Must be unique Asc user_id
users_username_key Must be unique Asc username

Relationships

Close relationships within degrees of separation