0% found this document useful (0 votes)
21 views3 pages

LMS Diagram

Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
21 views3 pages

LMS Diagram

Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 3

announcements

id bigint(20)

announcement_id varchar(255)

title varchar(255)

description text

attachment_url varchar(255)

send_to varchar(255)

user_id varchar(255)

user_type varchar(255)
* campus_id varchar(255)

status tinyint(4)

agents

campuses id bigint(20)

id bigint(20) agent_id varchar(255)


1 campus_id varchar(255) 1 * campus_id varchar(255)

campus_admin_id varchar(255) agent_code varchar(255)

campus_name varchar(255) department_id varchar(255)

campus_code varchar(255) branch_id varchar(255)

type varchar(255) batch_id varchar(255)

email varchar(255) first_name varchar(255)

contact_number varchar(255) last_name varchar(255)

web varchar(255) gender varchar(255)

logo text title varchar(255)

country_id varchar(255) email varchar(255)

state_id varchar(255) contact_number varchar(255)

city varchar(255) licence_no varchar(255)

unit_no varchar(255) licence_expire date

street varchar(255) contact_start date

landmark text contact_end date

post varchar(255) commission_rate int(11)

fees_paid tinyint(4) address varchar(255)

subscription_start date country varchar(255)

subscription_end date state varchar(255)

status tinyint(4) city varchar(255)

unit_no varchar(255)

street varchar(255)

landmark text
assessments
post varchar(255) assignment_student assignments attendances
banners id bigint(20)
marn_doc_id varchar(255) id bigint(20) id bigint(20) id bigint(20)
id bigint(20) assessment_id varchar(255)
email_verified_at timestamp assignment_student_id varchar(255) assignment_id varchar(255) attendance_id varchar(255)
banner_id varchar(255) campus_id varchar(255) *
status tinyint(4) assignment_id varchar(255) campus_id varchar(255) class_id varchar(255)
campus_id varchar(255) * course_id varchar(255)
total_gst int(11) student_id varchar(255) course_id varchar(255) batch_id varchar(255)
title varchar(255) content_id varchar(255)
total_commission int(11) start_at datetime content_id varchar(255) student_id varchar(255)
image_url varchar(255) title varchar(255)
end_at datetime batch_id varchar(255) course_id varchar(255)
file_server varchar(255) attempt int(11)
duration int(11) creator_type varchar(255) date date
display_to varchar(255) pass_marks int(11)
attempt int(11) creator_id varchar(255) time_start time
creator varchar(255) is_shuffle tinyint(4)
total_content int(11) title varchar(255) time_end time
status tinyint(4) is_progress tinyint(4)
finished_content int(11) description longtext
is_single_display tinyint(4)
assignment_mark int(11) assignment_period int(11)
status tinyint(4) branches
achieved_mark int(11) time_limit_status tinyint(4)
total_question int(11) batch_course id bigint(20)
progress int(11) time_limit int(11)
total_marks int(11) id bigint(20) branch_id varchar(255)
correct_answer longtext result_type varchar(255)
batch_course_id varchar(255) campus_id varchar(255)
answer longtext pass_mark longtext
batch_id varchar(255) department_id varchar(255)
evaluate longtext is_shuffle tinyint(4)
course_id varchar(255) batch_student name varchar(255)
assign_status int(11) is_extension tinyint(4)
class_require int(11) id bigint(20) slug varchar(255)
process_status int(11) attempt int(11)
class_done int(11) batch_id varchar(255) status tinyint(4)
complete_status int(11) assign_type tinyint(4)
created_at timestamp student_id varchar(255) deleted_at timestamp
submit_status int(11) modules longtext
updated_at timestamp created_at timestamp created_at timestamp
evaluate_status int(11) show_correct_answer_status tinyint(4)
deleted_at timestamp updated_at timestamp updated_at timestamp
success_status int(11) is_progress tinyint(4)
deleted_at timestamp
grade varchar(255) status tinyint(4)

campus_course score int(11) total_question int(11)

id bigint(20) campus_trainee time_start_at datetime total_marks int(11)

campus_id varchar(255) id bigint(20) feedback text

course_id varchar(255) campus_id varchar(255) submitted_at datetime


batches
created_at timestamp student_id varchar(255)
id bigint(20)
updated_at timestamp total_module int(11)
batch_trainer batch_id varchar(255)
total_content int(11)
id bigint(20) campus_id varchar(255)
finished_content int(11)
classes batch_id varchar(255) name varchar(255)
progress int(11)
id bigint(20) trainer_id varchar(255) description text
content_details longtext
class_id varchar(255) created_at timestamp department_id varchar(255)
created_at timestamp
batch_course_id varchar(255) updated_at timestamp branch_id varchar(255)
updated_at timestamp
batch_id varchar(255) deleted_at timestamp

category_id varchar(255) created_at timestamp


campus_trainer
course_id varchar(255) content_images updated_at timestamp
id bigint(20)
date date id bigint(20)
campus_id varchar(255)
time_start time image_id varchar(255)
trainer_id varchar(255) campus_user
require_attendance int(11) content_id varchar(255)
created_at timestamp id bigint(20)
gain_attendance int(11) campus_id varchar(255)
updated_at timestamp campus_id varchar(255)
created_at timestamp module varchar(255)
user_id varchar(255)
updated_at timestamp file_name varchar(255)
user_type varchar(255)
time_end time content_type varchar(255) course_contents
created_at timestamp
size int(11) id bigint(20)
updated_at timestamp
url text content_id varchar(255)
courses deleted_at timestamp
server text module_id varchar(255)
id bigint(20)
status tinyint(4) type varchar(255)
campus_admins course_id varchar(255)
deleted_at timestamp title text course_enroll
id bigint(20) campus_id varchar(255)
created_at timestamp description text id bigint(20) course_modules
campus_admin_id varchar(255) exam_id varchar(255)
updated_at timestamp image_id varchar(255) course_id varchar(255) id bigint(20)
super_admin_id varchar(255) category_id varchar(255)
as_image tinyint(4) category_id varchar(255) module_id varchar(255)
first_name varchar(255) title varchar(255)
as_slide tinyint(4) student_id varchar(255) parent_id varchar(255)
last_name varchar(255) course_code varchar(255) departments
status tinyint(4) campus_id varchar(255) course_id varchar(255)
title varchar(255) description text id bigint(20)
deleted_at timestamp total_module int(11) name text
email varchar(255) start date department_id varchar(255)
created_at timestamp total_content int(11) description longtext
contact_number varchar(255) end date campus_id varchar(255)
updated_at timestamp finished_content int(11) status tinyint(4)
address varchar(255) course_end_status tinyint(4) name varchar(255)
progress int(11) deleted_at timestamp
gender varchar(255) duration int(11) slug varchar(255)
content_details longtext created_at timestamp
country_id varchar(255) completion_type varchar(255) status tinyint(4) email_templates
completed_at date updated_at timestamp
state_id varchar(255) trainer_id varchar(255) deleted_at timestamp id bigint(20)
complete_status int(11)
city varchar(255) image_id text created_at timestamp template_id varchar(255)
is_start tinyint(4)
unit_no varchar(255) branch_id varchar(255) updated_at timestamp title varchar(255) exams
is_subscribe int(11)
street varchar(255) department_id varchar(255) user_type varchar(255) id bigint(20)
intake_year int(11)
landmark text status tinyint(4) campus_id varchar(255) exam_id varchar(255)
meeting_student enrolled_at date
post varchar(255) total_module int(11) subject varchar(255) campus_id varchar(255)
id bigint(20) schedule varchar(255)
email_verified_at timestamp total_content int(11) description text exam_type varchar(255)
meeting_id varchar(255) installments int(11)
password varchar(255) deleted_at timestamp body longtext title varchar(255)
student_id varchar(255) fee_type varchar(255)
status tinyint(4) created_at timestamp status tinyint(4) description longtext
user_type varchar(255) tuition_fee int(11)
remember_token varchar(100) updated_at timestamp created_at timestamp progress_required tinyint(4)
created_at timestamp material_fee int(11)
deleted_at timestamp updated_at timestamp exam_period int(11)
updated_at timestamp misc_fee int(11)
created_at timestamp deleted_at timestamp start date
invoices course_fee int(11)
updated_at timestamp duration int(11)
id bigint(20) agent_id varchar(255)
question_image start_at datetime
invoice_id varchar(255) meetings enroll_id varchar(255)
id bigint(20) end_at datetime
categories student_id varchar(255) id bigint(20) invoice_id varchar(255)
question_id varchar(255) marks_per_qc longtext
id bigint(20) campus_id varchar(45) meeting_id varchar(255) total_pay int(11)
image_id varchar(255) total_question int(11)
category_id varchar(255) dob date media varchar(255) bad_debt int(11)
created_at timestamp total_mark int(11)
campus_id varchar(45) nationality varchar(255) credentials_one varchar(255) gst int(11)
updated_at timestamp pass_mark int(11)
category_code varchar(255) passport_no varchar(255) credentials_two longtext agent_commission int(11)
student_id varchar(45) answer_view_status tinyint(4)
total_unit int(11) passport_expire varchar(255) credentials_three longtext expiry_at date
reattempt_status tinyint(4)
name varchar(255) visa_no varchar(255) title varchar(255) certificate text
allow_attempt_times int(11)
start date visa_expire varchar(255) description varchar(255) certificate_created_at date
students
reminder_before int(11)
end date certificate_file_id varchar(255) course_id varchar(255) created_at timestamp
id bigint(20)
status tinyint(4)
duration tinyint(4) language_file_id varchar(255) start datetime updated_at timestamp
student_id varchar(255)
created_at timestamp
course_end_status tinyint(4) passport_file_id varchar(255) duration int(11) deleted_at timestamp
campus_id varchar(255)
updated_at timestamp
exam_id varchar(255) other_file_id varchar(255) trainer_id varchar(255)
department_id varchar(255)
created_at timestamp form_step tinyint(4) batch_id varchar(255)
branch_id varchar(255)
exam_student
updated_at timestamp created_at timestamp created_at timestamp notifications
batch_id varchar(255)
id bigint(20)
deleted_at timestamp updated_at timestamp updated_at timestamp id bigint(20)
student_code varchar(255)
exam_id varchar(255)
status tinyint(4) deleted_at timestamp status int(11) notification_id varchar(255)
first_name varchar(255)
student_id varchar(255)
doc_name varchar(45) last_name varchar(255) campus_id varchar(45) temp_title varchar(255)
start_at datetime
completed_at date gender varchar(255) variables longtext
course_trainer duration int(11)
dropout_at int(11) title varchar(255) notifiable_id varchar(255)
id bigint(20) question_set end_at datetime
offer_letter text email varchar(255) notifiable_type varchar(255)
course_id varchar(255) id bigint(20) attempt int(11)
offer_letter_created_at date contact_number varchar(255) body longtext
trainer_id varchar(255) set_id varchar(255) set_id varchar(255)
status tinyint(4) iso_code varchar(255) view_status tinyint(4)
created_at timestamp question_id varchar(255) qc_id longtext
end_at date isd_code varchar(255) created_at timestamp
updated_at timestamp created_at timestamp total_content int(11)
address varchar(255) updated_at timestamp
updated_at timestamp finished_content int(11)
country varchar(255)
payments exam_mark int(11)
feedback state varchar(255)
id bigint(20) achieved_mark int(11) sets
id bigint(20) city varchar(255) trainers
payment_id varchar(255) progress int(11) id bigint(20)
feedback_id varchar(255) unit_no varchar(255) id bigint(20)
invoice_id varchar(255) correct_answer longtext set_id varchar(255)
module_id varchar(255) street varchar(255) trainer_id varchar(255)
student_id varchar(255) answer longtext exam_id varchar(255)
module varchar(255) landmark text campus_id varchar(255)
agent_id varchar(255) result varchar(255) name varchar(255)
message varchar(255) post varchar(255) department_id varchar(255)
campus_id varchar(255) evaluate longtext total_question int(11)
feedbackable_id varchar(255) avatar varchar(255) branch_id varchar(255)
enroll_id varchar(255) assign_status tinyint(4) status tinyint(4)
feedbackable_type varchar(255) email_verified_at timestamp batch_id varchar(255)
tuition_fee int(11) process_status tinyint(4) created_at timestamp
created_at timestamp password varchar(255) first_name varchar(255)
material_fee int(11) complete_status tinyint(4) updated_at timestamp
updated_at timestamp status tinyint(4) last_name varchar(255)
misc_fee int(11) submit_status tinyint(4)
expiry_at date gender varchar(255)
is_fee_schedule tinyint(4) evaluate_status tinyint(4)
paid int(11) title varchar(255)
payment_details commission_rate int(11) success_status tinyint(4)
due int(11) email varchar(255)
id bigint(20) commission int(11) created_at timestamp
remember_token varchar(100) contact_number varchar(255)
payment_details_id varchar(255) installment int(11) updated_at timestamp
deleted_at timestamp iso_code varchar(255)
payment_id varchar(255) fee int(11) exam_student_id varchar(255)
created_at timestamp isd_code varchar(255)
invoice_id varchar(255) total_paid int(11) time_start_at datetime
updated_at timestamp address varchar(255)
enroll_id varchar(255) bad_debt int(11)
country varchar(255)
campus_id varchar(255) gst int(11)
state varchar(255) notes
student_id varchar(255) agent_commission int(11)
city varchar(255) id bigint(20)
agent_id varchar(255) due date
unit_no varchar(255) note_id varchar(255)
paid_at date paid_at date
street varchar(255) campus_id varchar(255)
payment_type tinyint(4) status tinyint(255)
landmark text student_id varchar(255)
payment_status tinyint(4) invoice_letter text
post varchar(255) creator_type varchar(255)
tuition_fee int(11) invoice_letter_created_at date
avatar varchar(255) creator_id varchar(255)
material_fee int(11) created_at timestamp
email_verified_at timestamp message text
enroll_fee int(11) updated_at timestamp
password varchar(255) created_at timestamp
course_fee int(11) category_id varchar(45)
status tinyint(4) updated_at timestamp
gst int(11)
remember_token varchar(100)
commission_rate int(11)
student_enroll deleted_at timestamp
agent_commission int(11) questions
id bigint(20) created_at timestamp
transaction_id varchar(255) id bigint(20)
enroll_id varchar(255) updated_at timestamp
note text question_id varchar(255)
category_id varchar(255)
status int(11) module varchar(255)
student_id varchar(255)
created_at timestamp module_id varchar(255)
campus_id varchar(255)
updated_at timestamp title text
agent_id varchar(255)
type questions_type_enum
intake_year int(11)
question_type varchar(255)
settings enrolled_at date
options longtext
id bigint(20) schedule varchar(255)
answer longtext
setting_id varchar(255) installments int(11)
marks int(11)
user_type varchar(255) fee_type varchar(255)
status tinyint(4)
campus_id varchar(255) tuition_fee int(11)
created_at timestamp
section varchar(255) material_fee int(11)
updated_at timestamp
sub_section varchar(255) misc_fee int(11)

key varchar(255) course_fee int(11)

value text total_pay int(11) user_logs

comments text bad_debt int(11) id bigint(20)

deleted_at timestamp gst int(11) log_id varchar(255)

created_at timestamp agent_commission int(11) campus_id varchar(255)

updated_at timestamp created_at timestamp user_id varchar(255)

updated_at timestamp user_type varchar(255)

deleted_at timestamp module varchar(255)

invoice_id varchar(45) message longtext

expiry_at date created_at timestamp

updated_at timestamp

ip_address varchar(255)

country varchar(255)

country_code varchar(255)

module_id varchar(255)
announcements

id bigint(20)

announcement_id varchar(255)

title varchar(255)

description text

attachment_url varchar(255)

send_to varchar(255)

user_id varchar(255)

user_type varchar(255)
* campus_id varchar(255)

status tinyint(4)

agents

campuses id bigint(20)

id bigint(20) agent_id varchar(255)


1 campus_id varchar(255) 1 * campus_id varchar(255)

campus_admin_id varchar(255) agent_code varchar(255)

campus_name varchar(255) department_id varchar(255)

campus_code varchar(255) branch_id varchar(255)

type varchar(255) batch_id varchar(255)

email varchar(255) first_name varchar(255)

contact_number varchar(255) last_name varchar(255)

web varchar(255) gender varchar(255)

logo text title varchar(255)

country_id varchar(255) email varchar(255)

state_id varchar(255) contact_number varchar(255)

city varchar(255) licence_no varchar(255)

unit_no varchar(255) licence_expire date

street varchar(255) contact_start date

landmark text contact_end date

post varchar(255) commission_rate int(11)

fees_paid tinyint(4) address varchar(255)

subscription_start date country varchar(255)

subscription_end date state varchar(255)

status tinyint(4) city varchar(255)

unit_no varchar(255)

street varchar(255)

landmark text
assessments
post varchar(255) assignment_student assignments attendances
banners id bigint(20)
marn_doc_id varchar(255) id bigint(20) id bigint(20) id bigint(20)
id bigint(20) assessment_id varchar(255)
email_verified_at timestamp assignment_student_id varchar(255) assignment_id varchar(255) attendance_id varchar(255)
banner_id varchar(255) campus_id varchar(255) *
status tinyint(4) assignment_id varchar(255) campus_id varchar(255) class_id varchar(255)
campus_id varchar(255) * course_id varchar(255)
total_gst int(11) student_id varchar(255) course_id varchar(255) batch_id varchar(255)
title varchar(255) content_id varchar(255)
total_commission int(11) start_at datetime content_id varchar(255) student_id varchar(255)
image_url varchar(255) title varchar(255)
end_at datetime batch_id varchar(255) course_id varchar(255)
file_server varchar(255) attempt int(11)
duration int(11) creator_type varchar(255) date date
display_to varchar(255) pass_marks int(11)
attempt int(11) creator_id varchar(255) time_start time
creator varchar(255) is_shuffle tinyint(4)
total_content int(11) title varchar(255) time_end time
status tinyint(4) is_progress tinyint(4)
finished_content int(11) description longtext
is_single_display tinyint(4)
assignment_mark int(11) assignment_period int(11)
status tinyint(4) branches
achieved_mark int(11) time_limit_status tinyint(4)
total_question int(11) batch_course id bigint(20)
progress int(11) time_limit int(11)
total_marks int(11) id bigint(20) branch_id varchar(255)
correct_answer longtext result_type varchar(255)
batch_course_id varchar(255) campus_id varchar(255)
answer longtext pass_mark longtext
batch_id varchar(255) department_id varchar(255)
evaluate longtext is_shuffle tinyint(4)
course_id varchar(255) batch_student name varchar(255)
assign_status int(11) is_extension tinyint(4)
class_require int(11) id bigint(20) slug varchar(255)
process_status int(11) attempt int(11)
class_done int(11) batch_id varchar(255) status tinyint(4)
complete_status int(11) assign_type tinyint(4)
created_at timestamp student_id varchar(255) deleted_at timestamp
submit_status int(11) modules longtext
updated_at timestamp created_at timestamp created_at timestamp
evaluate_status int(11) show_correct_answer_status tinyint(4)
deleted_at timestamp updated_at timestamp updated_at timestamp
success_status int(11) is_progress tinyint(4)
deleted_at timestamp
grade varchar(255) status tinyint(4)

campus_course score int(11) total_question int(11)

id bigint(20) campus_trainee time_start_at datetime total_marks int(11)

campus_id varchar(255) id bigint(20) feedback text

course_id varchar(255) campus_id varchar(255) submitted_at datetime


batches
created_at timestamp student_id varchar(255)
id bigint(20)
updated_at timestamp total_module int(11)
batch_trainer batch_id varchar(255)
total_content int(11)
id bigint(20) campus_id varchar(255)
finished_content int(11)
classes batch_id varchar(255) name varchar(255)
progress int(11)
id bigint(20) trainer_id varchar(255) description text
content_details longtext
class_id varchar(255) created_at timestamp department_id varchar(255)
created_at timestamp
batch_course_id varchar(255) updated_at timestamp branch_id varchar(255)
updated_at timestamp
batch_id varchar(255) deleted_at timestamp

category_id varchar(255) created_at timestamp


campus_trainer
course_id varchar(255) content_images updated_at timestamp
id bigint(20)
date date id bigint(20)
campus_id varchar(255)
time_start time image_id varchar(255)
trainer_id varchar(255) campus_user
require_attendance int(11) content_id varchar(255)
created_at timestamp id bigint(20)
gain_attendance int(11) campus_id varchar(255)
updated_at timestamp campus_id varchar(255)
created_at timestamp module varchar(255)
user_id varchar(255)
updated_at timestamp file_name varchar(255)
user_type varchar(255)
time_end time content_type varchar(255) course_contents
created_at timestamp
size int(11) id bigint(20)
updated_at timestamp
url text content_id varchar(255)
courses deleted_at timestamp
server text module_id varchar(255)
id bigint(20)
status tinyint(4) type varchar(255)
campus_admins course_id varchar(255)
deleted_at timestamp title text course_enroll
id bigint(20) campus_id varchar(255)
created_at timestamp description text id bigint(20) course_modules
campus_admin_id varchar(255) exam_id varchar(255)
updated_at timestamp image_id varchar(255) course_id varchar(255) id bigint(20)
super_admin_id varchar(255) category_id varchar(255)
as_image tinyint(4) category_id varchar(255) module_id varchar(255)
first_name varchar(255) title varchar(255)
as_slide tinyint(4) student_id varchar(255) parent_id varchar(255)
last_name varchar(255) course_code varchar(255) departments
status tinyint(4) campus_id varchar(255) course_id varchar(255)
title varchar(255) description text id bigint(20)
deleted_at timestamp total_module int(11) name text
email varchar(255) start date department_id varchar(255)
created_at timestamp total_content int(11) description longtext
contact_number varchar(255) end date campus_id varchar(255)
updated_at timestamp finished_content int(11) status tinyint(4)
address varchar(255) course_end_status tinyint(4) name varchar(255)
progress int(11) deleted_at timestamp
gender varchar(255) duration int(11) slug varchar(255)
content_details longtext created_at timestamp
country_id varchar(255) completion_type varchar(255) status tinyint(4) email_templates
completed_at date updated_at timestamp
state_id varchar(255) trainer_id varchar(255) deleted_at timestamp id bigint(20)
complete_status int(11)
city varchar(255) image_id text created_at timestamp template_id varchar(255)
is_start tinyint(4)
unit_no varchar(255) branch_id varchar(255) updated_at timestamp title varchar(255) exams
is_subscribe int(11)
street varchar(255) department_id varchar(255) user_type varchar(255) id bigint(20)
intake_year int(11)
landmark text status tinyint(4) campus_id varchar(255) exam_id varchar(255)
meeting_student enrolled_at date
post varchar(255) total_module int(11) subject varchar(255) campus_id varchar(255)
id bigint(20) schedule varchar(255)
email_verified_at timestamp total_content int(11) description text exam_type varchar(255)
meeting_id varchar(255) installments int(11)
password varchar(255) deleted_at timestamp body longtext title varchar(255)
student_id varchar(255) fee_type varchar(255)
status tinyint(4) created_at timestamp status tinyint(4) description longtext
user_type varchar(255) tuition_fee int(11)
remember_token varchar(100) updated_at timestamp created_at timestamp progress_required tinyint(4)
created_at timestamp material_fee int(11)
deleted_at timestamp updated_at timestamp exam_period int(11)
updated_at timestamp misc_fee int(11)
created_at timestamp deleted_at timestamp start date
invoices course_fee int(11)
updated_at timestamp duration int(11)
id bigint(20) agent_id varchar(255)
question_image start_at datetime
invoice_id varchar(255) meetings enroll_id varchar(255)
id bigint(20) end_at datetime
categories student_id varchar(255) id bigint(20) invoice_id varchar(255)
question_id varchar(255) marks_per_qc longtext
id bigint(20) campus_id varchar(45) meeting_id varchar(255) total_pay int(11)
image_id varchar(255) total_question int(11)
category_id varchar(255) dob date media varchar(255) bad_debt int(11)
created_at timestamp total_mark int(11)
campus_id varchar(45) nationality varchar(255) credentials_one varchar(255) gst int(11)
updated_at timestamp pass_mark int(11)
category_code varchar(255) passport_no varchar(255) credentials_two longtext agent_commission int(11)
student_id varchar(45) answer_view_status tinyint(4)
total_unit int(11) passport_expire varchar(255) credentials_three longtext expiry_at date
reattempt_status tinyint(4)
name varchar(255) visa_no varchar(255) title varchar(255) certificate text
allow_attempt_times int(11)
start date visa_expire varchar(255) description varchar(255) certificate_created_at date
students
reminder_before int(11)
end date certificate_file_id varchar(255) course_id varchar(255) created_at timestamp
id bigint(20)
status tinyint(4)
duration tinyint(4) language_file_id varchar(255) start datetime updated_at timestamp
student_id varchar(255)
created_at timestamp
course_end_status tinyint(4) passport_file_id varchar(255) duration int(11) deleted_at timestamp
campus_id varchar(255)
updated_at timestamp
exam_id varchar(255) other_file_id varchar(255) trainer_id varchar(255)
department_id varchar(255)
created_at timestamp form_step tinyint(4) batch_id varchar(255)
branch_id varchar(255)
exam_student
updated_at timestamp created_at timestamp created_at timestamp notifications
batch_id varchar(255)
id bigint(20)
deleted_at timestamp updated_at timestamp updated_at timestamp id bigint(20)
student_code varchar(255)
exam_id varchar(255)
status tinyint(4) deleted_at timestamp status int(11) notification_id varchar(255)
first_name varchar(255)
student_id varchar(255)
doc_name varchar(45) last_name varchar(255) campus_id varchar(45) temp_title varchar(255)
start_at datetime
completed_at date gender varchar(255) variables longtext
course_trainer duration int(11)
dropout_at int(11) title varchar(255) notifiable_id varchar(255)
id bigint(20) question_set end_at datetime
offer_letter text email varchar(255) notifiable_type varchar(255)
course_id varchar(255) id bigint(20) attempt int(11)
offer_letter_created_at date contact_number varchar(255) body longtext
trainer_id varchar(255) set_id varchar(255) set_id varchar(255)
status tinyint(4) iso_code varchar(255) view_status tinyint(4)
created_at timestamp question_id varchar(255) qc_id longtext
end_at date isd_code varchar(255) created_at timestamp
updated_at timestamp created_at timestamp total_content int(11)
address varchar(255) updated_at timestamp
updated_at timestamp finished_content int(11)
country varchar(255)
payments exam_mark int(11)
feedback state varchar(255)
id bigint(20) achieved_mark int(11) sets
id bigint(20) city varchar(255) trainers
payment_id varchar(255) progress int(11) id bigint(20)
feedback_id varchar(255) unit_no varchar(255) id bigint(20)
invoice_id varchar(255) correct_answer longtext set_id varchar(255)
module_id varchar(255) street varchar(255) trainer_id varchar(255)
student_id varchar(255) answer longtext exam_id varchar(255)
module varchar(255) landmark text campus_id varchar(255)
agent_id varchar(255) result varchar(255) name varchar(255)
message varchar(255) post varchar(255) department_id varchar(255)
campus_id varchar(255) evaluate longtext total_question int(11)
feedbackable_id varchar(255) avatar varchar(255) branch_id varchar(255)
enroll_id varchar(255) assign_status tinyint(4) status tinyint(4)
feedbackable_type varchar(255) email_verified_at timestamp batch_id varchar(255)
tuition_fee int(11) process_status tinyint(4) created_at timestamp
created_at timestamp password varchar(255) first_name varchar(255)
material_fee int(11) complete_status tinyint(4) updated_at timestamp
updated_at timestamp status tinyint(4) last_name varchar(255)
misc_fee int(11) submit_status tinyint(4)
expiry_at date gender varchar(255)
is_fee_schedule tinyint(4) evaluate_status tinyint(4)
paid int(11) title varchar(255)
payment_details commission_rate int(11) success_status tinyint(4)
due int(11) email varchar(255)
id bigint(20) commission int(11) created_at timestamp
remember_token varchar(100) contact_number varchar(255)
payment_details_id varchar(255) installment int(11) updated_at timestamp
deleted_at timestamp iso_code varchar(255)
payment_id varchar(255) fee int(11) exam_student_id varchar(255)
created_at timestamp isd_code varchar(255)
invoice_id varchar(255) total_paid int(11) time_start_at datetime
updated_at timestamp address varchar(255)
enroll_id varchar(255) bad_debt int(11)
country varchar(255)
campus_id varchar(255) gst int(11)
state varchar(255) notes
student_id varchar(255) agent_commission int(11)
city varchar(255) id bigint(20)
agent_id varchar(255) due date
unit_no varchar(255) note_id varchar(255)
paid_at date paid_at date
street varchar(255) campus_id varchar(255)
payment_type tinyint(4) status tinyint(255)
landmark text student_id varchar(255)
payment_status tinyint(4) invoice_letter text
post varchar(255) creator_type varchar(255)
tuition_fee int(11) invoice_letter_created_at date
avatar varchar(255) creator_id varchar(255)
material_fee int(11) created_at timestamp
email_verified_at timestamp message text
enroll_fee int(11) updated_at timestamp
password varchar(255) created_at timestamp
course_fee int(11) category_id varchar(45)
status tinyint(4) updated_at timestamp
gst int(11)
remember_token varchar(100)
commission_rate int(11)
student_enroll deleted_at timestamp
agent_commission int(11) questions
id bigint(20) created_at timestamp
transaction_id varchar(255) id bigint(20)
enroll_id varchar(255) updated_at timestamp
note text question_id varchar(255)
category_id varchar(255)
status int(11) module varchar(255)
student_id varchar(255)
created_at timestamp module_id varchar(255)
campus_id varchar(255)
updated_at timestamp title text
agent_id varchar(255)
type questions_type_enum
intake_year int(11)
question_type varchar(255)
settings enrolled_at date
options longtext
id bigint(20) schedule varchar(255)
answer longtext
setting_id varchar(255) installments int(11)
marks int(11)
user_type varchar(255) fee_type varchar(255)
status tinyint(4)
campus_id varchar(255) tuition_fee int(11)
created_at timestamp
section varchar(255) material_fee int(11)
updated_at timestamp
sub_section varchar(255) misc_fee int(11)

key varchar(255) course_fee int(11)

value text total_pay int(11) user_logs

comments text bad_debt int(11) id bigint(20)

deleted_at timestamp gst int(11) log_id varchar(255)

created_at timestamp agent_commission int(11) campus_id varchar(255)

updated_at timestamp created_at timestamp user_id varchar(255)

updated_at timestamp user_type varchar(255)

deleted_at timestamp module varchar(255)

invoice_id varchar(45) message longtext

expiry_at date created_at timestamp

updated_at timestamp

ip_address varchar(255)

country varchar(255)

country_code varchar(255)

module_id varchar(255)
Enum questions_type_enum {
single
multiple
}

You might also like