ulesson - Laravel Schema Designer

learners

id increments
firstname string
lastname string
email string
phone string
password string
email_verified_at timestamp
remember_token string (100)
timestamps timestamps
city increments
country increments
dob date
grade_id increments

subjects

id increments
name string
status boolean
grade_id string
timestamps timestamps

chapters

id increments
name string
subject_id increments
status boolean
timestamps timestamps

quests

id increments
name string
chapter_id increments
timestamps timestamps
status boolean

topics

id increments
timestamps timestamps
quest_id increments
name string
status boolean
grade_id increments

questions

id increments
topic_id increments
title string
format enum
level enum
status enum
completion_time integer
timestamps timestamps
grade_id increments
subject_id increments
chapter_id increments
quest_id increments

tests

id increments
timestamps timestamps
name string
board_id increments
testable_id increments
testable_type enum
test_type enum

test_attempts

id increments
timestamps timestamps
learner_id increments
test_id increments
attempted_date timestamp
score integer
practice_id increments
exam_id increments

grades

id increments
timestamps timestamps
name string
is_active boolean

subscriptions

id increments
timestamps timestamps
days integer
amount double

assests

id increments
timestamps timestamps
file_path string
format string
resource_id increments
resource_type string
type string

parents

id increments
timestamps timestamps
name string
email string
phone string
password string
email_verified_at timestamps
remember_token string

boards

id increments
timestamps timestamps
name string
country increments

options

id increments
timestamps timestamps
value string
question_id increments
is_correct boolean

payments

id increments
timestamps timestamps
subscription_id increments
learner_id increments

test_attempts_questions

id increments
timestamps timestamps
question_id increments
attempt_id string
option_id increments

tests_subjects

test_id increments
subject_id increments

facts

id increments
timestamps timestamps
name string

learners_questions

id increments
timestamps timestamps
learner_id increments
question_id increments

users

id increments
timestamps timestamps
softDeletes softDeletes
phone string
email string
role_id integer
password string
remember_token string
lastname string
firstname string

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