E-Learning - Laravel Schema Designer

users

id increments
name string (50)
email string (255)
password string (60)
avatar string (255)
roles tinyInteger
created_at timestamps
updated_at timestamps
deleted_at timestamps

categories

id increments
name string (20)
introduction string (100)
image string (255)
created_at timestamps
updated_at timestamps
deleted_at timestamps

words

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

lessons

id increments
category_id ^FK integer
name string (255)
created_at timestamps
updated_at timestamps
deleted_at timestamps

relationships

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

activities

id increments
target_id integer
user_id ^FK integer
action_type tinyInteger
created_at timestamps
updated_at timestamps
deleted_at timestamps

user_words

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

word_answers

id increments
word_id ^FK integer
content string (255)
correct tinyInteger
created_at timestamps
updated_at timestamps
deleted_at timestamps

lesson_results

id increments
user_id ^FK integer
lesson_id ^FK integer
result integer
created_at timestamps
updated_at timestamps
deleted_at timestamps

lesson_words

id increments
lesson_id ^FK integer
word_id ^FK integer
created_at timestamps
updated_at timestamps
deleted_at timestamps

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