framgia_elearning - Laravel Schema Designer

words

id increments
content string
category_id ^FK integer
timestamps timestamps

users

id increments
name string
email string
password string
avatar string
timestamps timestamps

categories

id increments
title string
description text
timestamps timestamps

word_answers

id increments
content string
word_id ^FK integer
is_correct boolean
timestamps timestamps

lessons

id increments
user_id ^FK integer
category_id ^FK integer
result integer
timestamps timestamps

lesson_words

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

user_relationships

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

user_activities

id increments
name string
user_id ^FK integer
subject_type string
subject_id integer
timestamps timestamps

user_role

id increments
user_id ^FK integer
role_id ^FK integer
timestamps timestamps

roles

id increments
timestamps timestamps
name string

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