E-Learning - Laravel Schema Designer

users

id increments
timestamps timestamps
softDeletes softDeletes
name string (255)
pass string (255)
email string (255)
avatar string
role tinyInteger
percent_skill smallInteger

categories

id increments
timestamps timestamps
softDeletes softDeletes
image string (255)

words

id increments
timestamps timestamps
softDeletes softDeletes
category_id ^FK integer
content string (255)

word_answers

id increments
timestamps timestamps
softDeletes softDeletes
word_id ^FK integer

languages

id increments
timestamps timestamps
softDeletes softDeletes
iso_code string (2)

word_answer_locales

id increments
timestamps timestamps
softDeletes softDeletes
language_id ^FK integer
word_answer_id ^FK integer
content string (255)
notes text

category_locales

id increments
timestamps timestamps
softDeletes softDeletes
title string
summary string (255)
language_id ^FK integer
category_id ^FK integer

lessons

id increments
timestamps timestamps
softDeletes softDeletes
category_id ^FK integer

lesson_locales

id increments
timestamps timestamps
softDeletes softDeletes
language_id ^FK integer
lesson_id ^FK integer
title string (255)

lesson_words

id increments
timestamps timestamps
lesson_id ^FK integer
word_id ^FK integer
softDeletes softDeletes

relationships

id increments
timestamps timestamps
softDeletes softDeletes
follower_id ^FK integer
following_id ^FK integer

user_lessons

id increments
timestamps timestamps
softDeletes softDeletes
user_id ^FK integer
lesson_id ^FK integer
total_correct smallInteger

user_lesson_result

id increments
timestamps timestamps
softDeletes softDeletes
user_lesson_id ^FK integer
word_id ^FK integer
list_word_answer_id string
word_answer_id ^FK integer
word_answer_correct_id ^FK integer
is_correct tinyInteger

activities

id increments
timestamps timestamps
softDeletes softDeletes
user_id ^FK integer
user_lesson_id ^FK integer

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