ems - Laravel Schema Designer

admins

a_id increments
name string (50)
gender string (10)
blood_type string (10)
email string (50)
dob date
phone_number string (20)
address string (100)
image string (200)
password string

teachers

t_id increments
name string (50)
gender string (10)
blood_type string (10)
email string (50)
dob date
phone_number string (20)
address string (200)
image string (200)
qualification string (200)
password string

students

s_id increments
name string (50)
gender string (10)
blood_type string (10)
email string (50)
dob date
phone_number string (20)
address string (100)
image string (200)
father_name string (50)
mother_name string (50)
gurdian_phone_number string (20)
password string

subjects

sub_id increments
textbook_name string (100)
sub_name string (50)
credit integer

courses

c_id increments
sub_id1 ^FK integer
t_id1 ^FK integer
sub_id2 ^FK integer
t_id2 ^FK integer
sub_id3 ^FK integer
t_id3 ^FK integer
sub_id4 ^FK integer
t_id4 ^FK integer
sub_id5 ^FK integer
t_id5 ^FK integer
sub_id6 ^FK integer
t_id6 ^FK integer
sub_id7 ^FK integer
t_id7 ^FK integer
sub_id8 ^FK integer
t_id8 ^FK integer
sub_id9 ^FK integer
t_id9 ^FK integer
sub_id10 ^FK integer
t_id10 ^FK integer
sub_id11 ^FK integer
t_id11 ^FK integer
sub_id12 ^FK integer
t_id12 ^FK integer
sub_id13 ^FK integer
t_id13 ^FK integer
sub_id14 ^FK integer
t_id14 ^FK integer

attendences

c_id ^FK integer
sub_id ^FK integer
t_id ^FK integer
attend boolean
date date

notices

n_id integer
n_data string
date date

routines

r_id integer
r_data string

lectures

t_id ^FK integer
c_id ^FK integer
sub_id ^FK integer
file string

enrollments

c_id ^FK integer
s_id ^FK integer

exam_infos

e_id increments
sub_id ^FK integer
c_id ^FK integer
e_type string
e_cat string

mcqs

e_id ^FK integer
e_qs string
image string
opt_1 string
opt_2 string
opt_3 string
opt_4 string

results

c_id ^FK integer
s_id ^FK integer
e_id ^FK integer
sub_id ^FK integer
number float

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