user

2858 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
userid varchar 64 null
block_user.blocked_by_user_id block_user_blocked_by_user_id_fkey R
block_user.blocked_user_id block_user_blocked_user_id_fkey R
bookmark.user_id bookmark_user_id_fkey R
bot.user_id bot_user_id_fkey R
calendar.user_id calendar_user_id_fkey R
calendar_event.user_id calendar_event_user_id_fkey R
call_insights_qna.asked_by call_insights_qna_asked_by_fkey R
campaign.created_by campaign_created_by_fkey R
comment.user_id comment_user_id_fkey R
comment_likes.user_id comment_likes_user_id_fkey R
contact.user_id contact_user_id_fkey R
course.created_by course_created_by_fkey R
device.user_id device_user_id_fkey R
dislike.user_id dislike_user_id_fkey R
draft_course.created_by draft_course_created_by_fkey R
draft_poll.created_by draft_poll_created_by_fkey R
draft_poll_question.created_by draft_poll_question_created_by_fkey R
draft_video.owner_id draft_video_owner_id_fkey R
follow.influencer_id follow_influencer_id_fkey R
follow.user_id follow_user_id_fkey R
follow_topic.user_id follow_topic_user_id_fkey R
group.creator_id group_creator_id_fkey R
group_membership.approved_by group_membership_approved_by_fkey R
group_membership.user_id group_membership_user_id_fkey R
integrated_folders_google_drive.user_id integrated_folders_google_drive_user_id_fkey R
integration_file_upload_store.user_id integration_file_upload_store_user_id_fkey R
integration_settings_calendar.user_id integration_settings_calendar_user_id_fkey R
integration_settings_gong.admin_user_id integration_settings_gong_admin_user_id_fkey R
integration_settings_google_drive.user_id integration_settings_google_drive_user_id_fkey R
integration_settings_one_drive.user_id integration_settings_one_drive_user_id_fkey R
integration_settings_slack.user_id integration_settings_slack_user_id_fkey R
integration_settings_teams.user_id integration_settings_teams_user_id_fkey R
like.user_id like_user_id_fkey R
manual_video_review.admin_id manual_video_review_admin_id_fkey R
member.user_id member_user_id_fkey R
moderation.admin_id moderation_admin_id_fkey R
pin_video.pinned_by pin_video_pinned_by_fkey R
poll.created_by poll_created_by_fkey R
poll_question.created_by poll_question_created_by_fkey R
poll_question_response.user_id poll_question_response_user_id_fkey R
report_comment.reporter_id report_comment_reporter_id_fkey R
report_user.reported_user_id report_user_reported_user_id_fkey R
report_user.reporter_id report_user_reporter_id_fkey R
report_video.reporter_id report_video_reporter_id_fkey R
sales_copilot_qna.asked_by sales_copilot_qna_asked_by_fkey R
sales_copilot_response_feedback.user_id sales_copilot_response_feedback_user_id_fkey R
sales_deleted_library_content.deleted_by sales_deleted_library_content_deleted_by_fkey R
sales_library_content.posted_by sales_library_content_posted_by_fkey R
share_activity_data.shared_by share_activity_data_shared_by_fkey R
share_recording.shared_by_id share_recording_shared_by_id_fkey R
share_recording.shared_with_id share_recording_shared_with_id_fkey R
user_deletion.user_id user_deletion_user_id_fkey R
user_integration.user_id user_integration_user_id_fkey R
user_notification.action_owner_user_id user_notification_action_owner_user_id_fkey R
user_poll_attempt_score.user_id user_poll_attempt_score_user_id_fkey R
usertopic.user_id usertopic_user_id_fkey R
video.owner_id video_owner_id_fkey R
video_share.user_id video_share_user_id_fkey R
video_watch.user_id video_watch_user_id_fkey R
username varchar 128 null
display_name varchar 64 null
password varchar 128 √ null
fb_uuid varchar 256 null
fb_id_token varchar 8192 √ null
fb_messaging_token varchar 1024 √ null
email varchar 128 null
is_active bool 1 √ null
is_bot bool 1 √ null
date_joined timestamptz 35,6 √ null
phone varchar 32 √ null
profile_image varchar 256 √ null
thumbnail varchar 256 √ null
about_me varchar 1024 √ null
gender varchar 2 √ null
interests varchar 1024 √ null
num_followers int4 10 √ null
num_followings int4 10 √ null
num_blocks int4 10 √ null
num_reports int4 10 √ null
designation varchar 64 √ null
team varchar 64 √ null
department varchar 64 √ null
user_type varchar 64 √ null
last_login timestamptz 35,6 √ null
marked_for_deletion bool 1 √ null
customer_id varchar 8 √ null
customer.id user_customer_id_fkey1 R
created_at timestamptz 35,6 √ now()
updated_at timestamptz 35,6 √ now()
interest_ids _varchar 2147483647 √ null
user_onboarded bool 1 null
integrated_apps _varchar 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
user_pkey Primary key Asc userid
user_fb_uuid_key Must be unique Asc fb_uuid
user_username_key Must be unique Asc username

Relationships

Close relationships within degrees of separation