fan-academic - Laravel Schema Designer

courses

id increments
name string (255)
description text
hours double
miuntes double
price double
discount_ratio double
expired_at date
image string (255)
video text
order integer
availability tinyInteger
timestamps timestamps

users

id increments
name string (255)
email string (255)
password string (255)
country_id integer
birthdate date
gender tinyInteger
timestamps timestamps

lessons

id increments
name string (255)
description text
image string (255)
video text
order integer
Availability tinyInteger
session_id ^FK integer
timestamps timestamps

properties

id increments
timestamps timestamps
image string (255)
description string (255)
course_id ^FK integer

attachments

id increments
attachment_id integer
attachment_type string (255)
key string
value text
timestamps timestamps

tools

id increments
timestamps timestamps
tool string (255)
course_id ^FK integer

notifications

id increments
timestamps timestamps
type string (255)
notifiable_type string (255)
notifiable_id integer
data text
read_at timestamp

messages

id increments
timestamps timestamps
sender_id integer
receiver_id integer
content text
read_at timestamps

coupons

id increments
timestamps timestamps
coupon string (255)
expired_at date
course_id ^FK integer

seeions

id increments
timestamps timestamps
name string (255)
description text
course_id ^FK integer

categories

id increments
name string (255)
parent_id ^FK integer
level integer
timestamps timestamps

settings

id increments
timestamps timestamps
key string (255)
value text

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