Home
LMS
Fork
Export all
Schema
Model
Controller
Seeding
Form
Laravel 4.2
Add to favorites
Comments (0)
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
×
Comments for LMS
No comments have been made yet.
Laravel Schema Designer v0.7.1
follow me on twitter
@okyn01