fels_136 - Laravel Schema Designer

users

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

categories

id increments
name string (50)
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

word_answers

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

lesson_results

id increments
user_id ^FK integer
lession_id ^FK integer
result integer
created_at timestamp
updated_at timestamp
deleted_at timestamp

user_relationships

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

learned_words

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

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