devhunt - Laravel Schema Designer

pages

id increments
title string (255)
slug string
description text
meta_description text
meta_keywords text
created_by ^FK bigInteger
updated_by ^FK bigInteger
softDeletes softDeletes
timestamps timestamps

users

id increments
name string
email string
email_verified_at timestamp
password string
rememberToken rememberToken
gender enum
address text
date_of_birth date
city string
state string
softDeletes softDeletes
timestamps timestamps

settings

id increments
website_name string
logo string
phone_no string
email string
footer_text text
open_close_time string
address string
labels text
options text
timestamps timestamps

categories

id increments
name string
slug string
description text
logo string
priority bigInteger
enable_homepage boolean
parent_id ^FK bigInteger
timestamps timestamps

courses

id increments
title string
slug string
banner string
is_free boolean
price float
offer_price float
description text
meta_description text
meta_keywords text
total_view bigInteger
total_enrolled bigInteger
avg_rating float
category_id ^FK bigInteger
created_by ^FK bigInteger
updated_by ^FK bigInteger
external_enroll_link text
start_date date
end_date date
status text
timestamps timestamps

chapters

id increments
course_id ^FK bigInteger
title string
slug string
priority bigInteger
created_by ^FK bigInteger
updated_by ^FK bigInteger
banner string
description text
meta_description text
meta_keywords text
status text
timestamps timestamps

lessons

id increments
title string
course_id ^FK bigInteger
chapter_id ^FK bigInteger
created_by ^FK bigInteger
updated_by ^FK bigInteger
meta_description text
meta_keywords text
deleted_by ^FK bigInteger
description text
priority bigInteger
slug string
type enum
is_free boolean
status boolean
labels enum
is_live boolean
video_url string
embedded_url string
total_view bigInteger
timestamps timestamps

assignments

id increments
total_mark float
course_id ^FK bigInteger
timestamps timestamps
user_id ^FK bigInteger

lesson_attachments

id increments
title string
url string
lesson_id ^FK bigInteger
softDeletes softDeletes
timestamps timestamps

reviews

id increments
rating float
description text
user_id ^FK bigInteger
course_id ^FK bigInteger
softDeletes softDeletes
timestamps timestamps

assignment_submissions

id increments
assignment_id ^FK bigInteger
user_id ^FK bigInteger
description text
result float
reviewed_by ^FK bigInteger
review_description text
timestamps timestamps
softDeletes softDeletes

enrolls

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

payments

id increments
enroll_id ^FK bigInteger
course_id ^FK bigInteger
user_id ^FK bigInteger
status enum
parent_payment_id ^FK bigInteger
details text
note text
softDeletes softDeletes
timestamps timestamps

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