E-Learning Son + Toan - Laravel Schema Designer

users

id increments
name string (50)
email string
password string (100)
avatar string
role tinyInteger
created_at timestamp
updated_at timestamp
deleted_at timestamp

categories

id increments
name string (50)
description string (255)
created_at timestamp
updated_at timestamp
deleted_at timestamp

words

id increments
content string
category_id ^FK integer
created_at timestamp
updated_at timestamp
deleted_at timestamp

lessons

id increments
name string (100)
category_id ^FK integer
created_at timestamp
updated_at timestamp
deleted_at timestamp

activities

id increments
user_id ^FK integer
content string
created_at timestamp
updated_at timestamp
deleted_at timestamp

lesson_words

id increments
lession_id ^FK integer
word_id ^FK integer
created_at timestamp
updated_at timestamp
deleted_at timestamp

answers

id increments
word_id ^FK integer
content string
is_correct boolean
created_at timestamp
updated_at timestamp
deleted_at timestamp

results

id increments
user_id ^FK integer
lesson_id ^FK integer
answer_id ^FK integer
created_at timestamp
updated_at timestamp
deleted_at timestamp

users_follows

id increments
follower_id ^FK integer
followed_id ^FK integer
created_at timestamp
updated_at timestamp
deleted_at timestamp

socials

id increments
user_id ^FK integer
provider_user_id integer
provider string (255)
created_at timestamps
updated_at timestamp
deleted_at timestamp

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