batch_all_learners

0 rows


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
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
batch_id VARCHAR 36 √ null
total_count BIGINT 19 √ null
completed_count BIGINT 19 √ null

Relationships

View Definition


Possibly Referenced Tables/Views