online course website - Laravel Schema Designer

Admin

id increments
timestamps timestamps
softDeletes softDeletes
fullname string (30)
email string (30)
password string (40)

User

id increments
timestamps timestamps
softDeletes softDeletes
fullname string (30)
email string (30)
password string (40)

Course

id increments
timestamps timestamps
softDeletes softDeletes
title string (40)
price float
duration smallInteger
description text
summery string (140)
is_promoted boolean
category_id ^FK integer

Super_Admin

id increments
timestamps timestamps
softDeletes softDeletes

Teacher

id increments
timestamps timestamps

Category

id increments
timestamps timestamps
softDeletes softDeletes

Enrolled_course

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

Lessons

id increments
title string (140)
summery text
course_id ^FK integer
timestamps timestamps
softDeletes softDeletes

Watched_Lessons

id increments
timestamps timestamps
softDeletes softDeletes

Video

id increments
timestamps timestamps
softDeletes softDeletes
duration time
name string (100)
video_path string

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