courseSystem - Laravel Schema Designer

subjects

id increments
name string (191)
active boolean
timestamps timestamps

courses

id increments
subject_id ^FK bigInteger
teacher_id ^FK bigInteger
lecture_type enum
price tinyInteger
start_date date
end_date date
total_lectures tinyInteger
active boolean
timestamps timestamps

users

id increments
timestamps timestamps
username string (191)
password string (191)
email string

admins

id increments
user_id ^FK bigInteger
timestamps timestamps

administratives

id increments
user_id ^FK bigInteger
timestamps timestamps

course_lectures

id increments
course_id ^FK bigInteger
lecture_upload_video string (191)
lecture_url_video string
lecture_thumbnail string (191)
timestamps timestamps

course_schedules

id increments
course_id ^FK bigInteger
day date
timestamps timestamps

teachers

id increments
timestamps timestamps
user_id ^FK bigInteger

lecture_materials

id increments
course_lecture_id ^FK bigInteger
type enum
file_upload string (191)
end_date datetime
timestamps timestamps

students

id increments
user_id ^FK bigInteger
timestamps timestamps

student_course_request

id increments
student_id ^FK bigInteger
course_id ^FK bigInteger
status enum
timestamps timestamps

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