fels_160 - Laravel Schema Designer

users

id increments
email string (255)
name string (255)
password string (20)
avatar string
is_admin boolean
timestamps timestamps

lessons

id increments
category_id ^FK integer
timestamps timestamps

categories

id increments
name string (255)
timestamps timestamps

words

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

lesson_words

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

word_answers

id increments
word_id ^FK integer
content string (255)
timestamps timestamps

activities

id increments
user_id ^FK integer
activity string
timestamps timestamps

user_relationships

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

user_lessons

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

user_lesson_results

id increments
user_id ^FK integer
word_id ^FK integer
user_lesson_id ^FK integer
word_answer_id ^FK integer
is_correct boolean
timestamps timestamps

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