e_learning - Laravel Schema Designer

user

id increments
name string (50)
admin integer
email string (80)
password string (30)
remember_token string (100)
avatar string (100)
created_at timestamps
updated_at timestamp
deleted_at timestamp

word

id increments
content string
category_id ^FK integer
created_at timestamp
updated_at timestamp
deleted_at timestamp

category

id increments
name string
created_at timestamp
updated_at timestamp
deleted_at timestamp

lesson

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

lesson_word

id increments
lesson_id ^FK integer
word_id ^FK integer
word_answer_id ^FK integer
created_at timestamp
updated_at timestamp
deleted_at timestamp

word_answer

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

activity

id increments
content string
user_id ^FK integer
target_id integer
action string
created_at timestamp
updated_at timestamp
deleted_at timestamp

relationship

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

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