users

25 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
access_logs.user_id access_logs_user_id_fkey N
admin_notifications.user_id admin_notifications_user_id_fkey R
auction_bids.user_id auction_bids_ibfk_2 R
auction_winners.user_id auction_winners_ibfk_2 R
block_history.action_by block_history_action_by_fkey R
cart_items.user_id cart_items_user_id_fkey R
comment_history.action_by comment_history_action_by_fkey R
coordinates.staff_id coordinates_staff_id_fkey R
favorite_notifications.user_id favorite_notifications_ibfk_1 R
favorites.user_id favorites_ibfk_1 R
follows.user_id follows_ibfk_1 R
gift_transactions.user_id gift_transactions_ibfk_1 R
live_comments.user_id live_comments_user_id_fkey R
live_kicks.kicked_by live_kicks_kicked_by_fkey R
live_kicks.user_id live_kicks_user_id_fkey R
live_likes.user_id live_likes_user_id_fkey R
live_ratings.user_id live_ratings_user_id_fkey R
live_staffs.staff_id live_staffs_staff_id_fkey R
live_viewers.user_id live_viewers_user_id_fkey R
message_threads.user_id message_threads_user_id_fkey R
notification_settings.user_id notification_settings_user_id_fkey R
notification_targets.user_id notification_targets_user_id_fkey R
orders.user_id orders_ibfk_1 R
pinned_comments.pinned_by pinned_comments_pinned_by_fkey R
promotion_purchases.user_id promotion_purchases_user_id_fkey R
raffle_entries.user_id raffle_entries_ibfk_2 R
raffle_winners.user_id raffle_winners_ibfk_2 R
reports.reporter_id reports_reporter_id_fkey R
return_messages.sender_id return_messages_sender_id_fkey R
reviews.streamer_id reviews_streamer_id_fkey N
reviews.user_id reviews_user_id_fkey R
search_histories.user_id search_histories_user_id_fkey R
shipping_addresses.user_id shipping_addresses_user_id_fkey R
shop_coupon_uses.user_id shop_coupon_uses_user_id_fkey R
shop_staffs.user_id shop_staffs_ibfk_2 R
social_accounts.user_id social_accounts_ibfk_1 R
tutorial_skip_logs.user_id tutorial_skip_logs_user_id_fkey R
user_blocks.blocked_user_id user_blocks_blocked_user_id_fkey R
user_blocks.user_id user_blocks_user_id_fkey R
user_coupons.user_id user_coupons_user_id_fkey R
user_devices.user_id user_devices_user_id_fkey R
user_follows.follower_id user_follows_follower_id_fkey R
user_follows.following_id user_follows_following_id_fkey R
user_sessions.user_id user_sessions_ibfk_1 R
user_suspensions.user_id user_suspensions_user_id_fkey R
user_tutorial_status.user_id user_tutorial_status_user_id_fkey R
video_views.user_id video_views_user_id_fkey R
videos.staff_id videos_staff_id_fkey R
email VARCHAR 255 null
password VARCHAR 255 null
username VARCHAR 20 √ null
avatar VARCHAR 255 √ null
is_active BIT 1 0
last_login_at DATETIME 19 √ null
created_at DATETIME 19 CURRENT_TIMESTAMP
deleted_at DATETIME 19 √ null
updated_at DATETIME 19 CURRENT_TIMESTAMP
status enum('ACTIVE', 'SUSPENDED', 'DELETED') 9 ACTIVE
suspended_at DATETIME 23 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
email Must be unique Asc email
username Must be unique Asc username

Relationships

Close relationships within degrees of separation