course-academy - Laravel Schema Designer

users

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

courses

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

topics

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

lessons

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

watched_lessons

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

enrolled_courses

id increments
user_id integer
course_id string
timestamps timestamps

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