LMS - Laravel Schema Designer

admin_user

id increments
name string
email string
mobile string
password string
role_id integer
is_active tinyInteger
timestamps timestamps
softDeletes softDeletes

staffs

id increments
name string
email string
mobile string
password string
is_active tinyInteger
timestamps timestamps
softDeletes softDeletes

student

id increments
name string
mobile string
email string
password string
dob date
balance_amount decimal (10,2)
is_enrolled tinyInteger
is_active tinyInteger
is_balance tinyInteger
timestamps timestamps
softDeletes softDeletes

category

id increments
name string
slug string
position integer
is_active tinyInteger
timestamps timestamps
softDeletes softDeletes

course

id increments
name string
slug string
cover_image string
description longText
hours integer
certificate_image string
position integer
is_active tinyInteger
created_by integer
created_slug string
timestamps timestamps
softDeletes softDeletes

course_category

id increments
course_id ^FK integer
category_id ^FK integer
timestamps timestamps
softDeletes softDeletes

roles

id increments
name string
slug string
is_active tinyInteger
timestamps timestamps
softDeletes softDeletes

permission

id increments
name string
slug string
is_active tinyInteger
timestamps timestamps
softDeletes softDeletes

role_permission

id increments
role_id ^FK integer
permission_id ^FK integer
timestamps timestamps
softDeletes softDeletes

modules

id increments
course_id ^FK integer
name string
slug string
position integer
is_active tinyInteger
created_by integer
created_slug string
timestamps timestamps
softDeletes softDeletes

type_master

id increments
name string
slug string
is_active tinyInteger
timestamps timestamps
softDeletes softDeletes

lesson

id increments
module_id ^FK integer
name string
slug string
type_id ^FK integer
description longText
position integer
is_active tinyInteger
created_by integer
created_slug string
timestamps timestamps
softDeletes softDeletes

batch

id increments
staff_id ^FK integer
course_id ^FK integer
name string
slug string
start_date string
end_date string
hours string
days text
created_by integer
created_slug string
timestamps timestamps
softDeletes softDeletes

enroll_students

id increments
course_id ^FK integer
batch_id ^FK integer
student_id ^FK integer
type enum
timestamps timestamps
softDeletes softDeletes

payment

id increments
order_id ^FK integer
payment_id string
transaction_id string
status string
created_by integer
created_slug string
timestamps timestamps
softDeletes softDeletes

order

id increments
order_number string
student_id ^FK integer
course_id ^FK integer
batch_id ^FK integer
type enum
total_amount decimal (10,2)
amount_paid decimal (10,2)
amount_balance decimal (10,2)
status string
is_active tinyInteger
created_by integer
created_slug string
timestamps timestamps
softDeletes softDeletes

certificates

id increments
course_id ^FK integer
batch_id ^FK integer
type enum
certificate string
created_by integer
created_slug string
timestamps timestamps
softDeletes softDeletes

education_details

id increments
student_id ^FK integer
slug string
grade string
yop string
image string
is_active tinyInteger
timestamps timestamps
softDeletes softDeletes

doubts

id increments
lesson_id ^FK integer
staff_id ^FK integer
student_id ^FK integer
ques string
ques_image string
answer string
answer_image string
is_active tinyInteger
is_solved tinyInteger
closed_on timestamp
timestamps timestamps
softDeletes softDeletes

feedback

id increments
course_id ^FK integer
batch_id ^FK integer
staff_id ^FK integer
student_id ^FK integer
title string
rating string
review longText
is_active tinyInteger
timestamps timestamps
softDeletes softDeletes

placement

id increments
course_id ^FK integer
job_title string
job_description longText
last_date date
short_description text
image string
is_active tinyInteger
timestamps timestamps
softDeletes softDeletes

students_applied

id increments
timestamps timestamps
softDeletes softDeletes
placement_id ^FK integer
student_id ^FK integer

batch_course

id increments
batch_id ^FK integer
course_id ^FK integer
timestamps timestamps
softDeletes softDeletes

Laravel Schema Designer v0.7.1 follow me on twitter @okyn01