users

1002770 rows


Description

Stores users details

Columns

Column Type Size Nulls Auto Default Children Parents Comments
program_id VARCHAR 36 √ null
old_data_id INT 10 √ null
id VARCHAR 36 null
batches.created_by batches_ibfk_3 R
centre_user.user_id centre_user_ibfk_1 R
communities.user_id communities_ibfk_1 R
maintenance_logs.created_by maintenance_logs_created_by_foreign R
maintenance_logs.updated_by maintenance_logs_updated_by_foreign R
ple_analytics.created_by ple_analytics_created_by_foreign R
ple_analytics.user_id ple_analytics_user_id_foreign R
ple_assessment_options.created_by ple_assessment_options_created_by_foreign R
ple_assessment_pages.created_by ple_assessment_pages_created_by_foreign R
ple_assessment_questions.created_by ple_assessment_questions_created_by_foreign R
ple_assessment_response_keys.created_by ple_assessment_response_keys_created_by_foreign R
ple_assessment_responses.created_by ple_assessment_responses_created_by_foreign R
ple_assessment_responses.user_id ple_assessment_responses_user_id_foreign R
ple_assessments.created_by ple_assessments_created_by_foreign R
ple_avatar_categories.created_by avatar_categories_created_by_foreign R
ple_avatar_user.created_by ple_avatar_user_created_by_foreign R
ple_avatar_user.user_id ple_avatar_user_user_id_foreign R
ple_avatars.created_by ple_avatars_created_by_foreign R
ple_career_path_user.created_by job_type_user_created_by_foreign R
ple_career_path_user.user_id job_type_user_user_id_foreign R
ple_career_paths.created_by job_types_created_by_foreign R
ple_course_skill.created_by course_skill_created_by_foreign R
ple_course_skill.updated_by course_skill_updated_by_foreign R
ple_credits.created_by credits_created_by_foreign R
ple_day_streak_user.created_by day_streak_user_created_by_foreign R
ple_day_streak_user.user_id day_streak_user_user_id_foreign R
ple_guide_book_user.created_by guide_book_user_created_by_foreign R
ple_guide_book_user.user_id guide_book_user_user_id_foreign R
ple_guide_books.created_by guide_books_created_by_foreign R
ple_image_assets.created_by ple_image_assets_created_by_foreign R
ple_job_card_career_path.created_by job_card_job_type_created_by_foreign R
ple_job_card_user.created_by job_card_user_created_by_foreign R
ple_job_card_user.user_id job_card_user_user_id_foreign R
ple_job_cards.created_by job_cards_created_by_foreign R
ple_skill_trade.created_by ple_skill_trade_created_by_foreign R
ple_skill_trade.updated_by ple_skill_trade_updated_by_foreign R
ple_skill_user.created_by skill_user_created_by_foreign R
ple_skill_user.user_id skill_user_user_id_foreign R
ple_skills.created_by skills_created_by_foreign R
ple_success_stories.created_by success_stories_created_by_foreign R
ple_user_onboardings.created_by ple_user_onboardings_created_by_foreign R
ple_user_onboardings.user_id ple_user_onboardings_user_id_foreign R
ple_video_assets.created_by ple_video_assets_created_by_foreign R
state_user.user_id state_user_ibfk_1 R
email VARCHAR 255 √ null
email_verified_at DATETIME 19 √ null
name VARCHAR 255 null
mobile VARCHAR 15 √ null
password VARCHAR 255 null
adm_type VARCHAR 3 √ 0
type TINYINT 3 null

1-Admin,2-Facilitator,3-Learner,4-Alumni
status BIT 1 √ 1

0:Inactive,1:Active
organisation_id VARCHAR 36 √ null
centre_id VARCHAR 36 √ null
project_id VARCHAR 36 √ null
remember_token VARCHAR 100 √ null
image VARCHAR 255 √ profilepic/1.svg
otp INT 10 √ null
otp_timestamp DATETIME 19 √ null
tenant_id VARCHAR 36 null
fcm_id VARCHAR 255 √ null
gender VARCHAR 10 √ null
created_platform TINYINT 3 √ null
created_at DATETIME 19 √ null
updated_at DATETIME 19 √ null
deleted_at TIMESTAMP 19 √ null
is_super_facilitator TINYINT 3 √ 0

0:No,1:Yes
is_master_trainer TINYINT 3 √ 0

0:No,1:Yes
reference_id INT 10 √ null

Depends on roles.This can be id from centre,org,project and program
reg_status TINYINT 3 √ 1
is_logged_in TINYINT 3 √ null

1:Yes
is_reg_mail_send TINYINT 3 √ null

0:No,1:Yes
is_quest_employee TINYINT 3 √ null

0:No,1:Yes
state VARCHAR 36 √ null
created_by VARCHAR 36 √ null
is_approved TINYINT 3 √ 1

0:No,1:Yes
approval_group VARCHAR 36 √ null
approved_by VARCHAR 36 √ null
is_email_verified TINYINT 3 √ null
isksdc_user INT 10 0
sidp_candidate_id BIGINT 19 √ null
learning_activities_archive_log.id Implied Constraint R
issidp_user INT 10 √ null
is_student TINYINT 3 √ 0
is_leader TINYINT 3 √ 0
is_primary_teacher TINYINT 3 √ 0
is_secondary_teacher TINYINT 3 √ 0
is_govt_official TINYINT 3 √ 0
is_ple TINYINT 3 √ 0
is_finance_lead TINYINT 3 √ 0
is_state_lead TINYINT 3 √ 0

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
composit Performance Asc/Asc/Asc/Asc/Asc centre_id + organisation_id + tenant_id + type + deleted_at
deleted_at Performance Desc deleted_at
fk_users_1_idx Performance Asc centre_id
fk_users_2_idx Performance Asc organisation_id
fk_users_3_idx Performance Asc program_id
fk_users_4_idx Performance Asc project_id
idx_users_centre_tenant_del_status_platform_gender_type_org Performance Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc centre_id + tenant_id + deleted_at + status + created_platform + gender + type + organisation_id
idx_users_centre_type_created_del Performance Asc/Asc/Asc/Asc/Asc centre_id + type + created_at + deleted_at + id
idx_users_issidp_id Performance Asc/Asc issidp_user + id
idx_users_search_order1 Performance Desc created_at
idx_users_tenant_type_deleted_org_centre Performance Asc/Asc/Asc/Asc/Asc tenant_id + type + deleted_at + organisation_id + centre_id
idx_users_tenant_type_flags_deleted_org_centre Performance Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc tenant_id + type + is_student + is_govt_official + is_secondary_teacher + is_primary_teacher + is_leader + deleted_at + organisation_id + centre_id
idx_users_type_platform Performance Asc/Asc type + created_platform
name Performance Asc name
type Performance Asc/Asc type + tenant_id
users_centre_id_IDX Performance Asc/Asc/Asc/Asc/Asc centre_id + type + status + is_ple + deleted_at
users_created_at_IDX Performance Asc created_at
users_email_IDX Performance Asc email
users_is_approved_ten_ty_org_del_IDX Performance Asc/Asc/Asc/Asc/Asc is_approved + tenant_id + type + organisation_id + deleted_at
users_mobile_IDX Performance Asc mobile
users_organisation_id_te_ty_im_de_cr_IDX Performance Asc/Asc/Asc/Asc/Asc/Asc/Asc organisation_id + tenant_id + type + is_master_trainer + id + deleted_at + created_at
users_status_IDX Performance Asc status
users_tenant_id_type_ism_id_IDX Performance Asc/Asc/Asc/Asc tenant_id + type + is_master_trainer + id
users_type_st_c_del_IDX Performance Asc/Asc/Asc/Asc type + status + centre_id + deleted_at

Relationships

Close relationships within degrees of separation