LMS Diagram
LMS Diagram
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)
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)
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)
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)
updated_at timestamp
ip_address varchar(255)
country varchar(255)
country_code varchar(255)
module_id varchar(255)
Enum questions_type_enum {
single
multiple
}