studentsgospel - Laravel Schema Designer

roles

id increments
timestamps timestamps
softDeletes softDeletes
name string (20)

users

id increments
timestamps timestamps
softDeletes softDeletes
role_id ^FK bigInteger
classe_id ^FK bigInteger
name string
email_verified_at datetime
first_name string
last_name string
email string
password string
mobile_number integer
address string
school_name string
gender enum
date_of_birth date

classes

id increments
timestamps timestamps
softDeletes softDeletes
name string

questions

id increments
timestamps timestamps
softDeletes softDeletes
question_type_id ^FK bigInteger
classe_id ^FK bigInteger
subject_id ^FK bigInteger
chapter_id ^FK bigInteger
exam_type_id ^FK bigInteger
board_id ^FK bigInteger
question string
option1 string
option2 string
option3 string
option4 string
answer1 string
answer2 string
answer1_image string
answer2_image string
Exaplaination string
answer3 string

question_types

id increments
timestamps timestamps
softDeletes softDeletes
name string

subjects

id increments
timestamps timestamps
softDeletes softDeletes
name string
board_id ^FK bigInteger
classe_id ^FK bigInteger

chapters

id increments
timestamps timestamps
softDeletes softDeletes
board_id ^FK bigInteger
classe_id ^FK bigInteger
subject_id ^FK bigInteger
name string

boards

id increments
timestamps timestamps
softDeletes softDeletes
name string

exam_types

id increments
timestamps timestamps
softDeletes softDeletes
classe_id ^FK bigInteger
name bigInteger

quizes

id increments
timestamps timestamps
softDeletes softDeletes
name string
classe_id ^FK bigInteger
subject_id ^FK bigInteger
chapter_id ^FK bigInteger
board_id ^FK bigInteger
exam_type ^FK bigInteger
description string
featured_image string
duration_min integer
quiz_instruction string
difficulty_level string
number_of_question integer
marks_per_question integer
passing_marks integer
total_marks integer

quizes_questions

id increments
timestamps timestamps
softDeletes softDeletes
quiz_id ^FK bigInteger
question_id ^FK bigInteger
classe_id ^FK bigInteger
subject_id ^FK bigInteger

user_quiz

id increments
timestamps timestamps
softDeletes softDeletes
user_id ^FK bigInteger
quiz_id ^FK bigInteger

quiz_results

id increments
timestamps timestamps
softDeletes softDeletes
quiz_id ^FK bigInteger
user_id ^FK bigInteger
quiz_status enum
marks_obtained integer
number_of_correct_answers integer
number_of_attempted_questions integer

quiz_user_answers

id increments
timestamps timestamps
softDeletes softDeletes
quiz_id ^FK bigInteger
question_id ^FK bigInteger
given_answers string
quiz_started_time datetime
quiz_ended_time datetime
user_id ^FK bigInteger
quizresult_id ^FK bigInteger

textbooks

id increments
timestamps timestamps
softDeletes softDeletes
name string
board_id ^FK bigInteger
classe_id ^FK bigInteger
subject_id ^FK bigInteger
file_location string

guides

id increments
timestamps timestamps
softDeletes softDeletes
board_id ^FK bigInteger
classe_id ^FK bigInteger
subject_id ^FK bigInteger
name string

guides_questions

id increments
timestamps timestamps
softDeletes softDeletes
guides_id ^FK bigInteger
question_type_id ^FK bigInteger
chapter_id ^FK bigInteger
question string
answer string
present_in_textbook enum
marks integer

videos

id increments
timestamps timestamps
softDeletes softDeletes
board_id ^FK bigInteger
classe_id ^FK bigInteger
subject_id ^FK bigInteger
chapter_id ^FK bigInteger
name string
video_url string

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