course-academy - Laravel Schema Designer

users

id increments
timestamps timestamps
first_name string
last_name string (255)
username string (25)
password string
e-mail string (255)
image_pathname string
is_admin boolean
bio text

courses

id increments
timestamps timestamps
title string (60)
duration smallInteger
difficulty enum
description text
summary string
image_pathname ^FK integer
created_by integer
updated_by integer
video_id string
is_promoted boolean

topics

id increments
video_id string
timestamps timestamps
title string (60)
image_pathname string
content text
created_by integer
updated_by integer

lessons

id increments
timestamps timestamps
title string
summary string
video_id string
created_by integer
updated_by integer
note text

watched_lessons

id increments
timestamps timestamps
user_id ^FK integer
lesson_id ^FK integer
stopped_watching_at integer

enrolled_courses

id increments
timestamps timestamps
user_id integer
course_id string

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