school_management_system - Laravel Schema Designer

users

id increments
name string (50)
dob date
address string (100)
email string (30)
contact_number string (17)
guardian_name string (50)
gurdian_phone_number string (17)
guardian_email string (50)
timestamps timestamps
softDeletes softDeletes
password string (200)
image string (100)
qualification string (100)
blood_type string (10)
gender string (10)
roles string (15)

subjects

sub_id increments
cb_id ^FK integer
sub_name string (100)
textbook_name string (100)
timestamps timestamps

class_branches

cb_id increments
name string (50)
year date
timestamps timestamps

teacher_assigns

sub_id ^FK integer
cb_id ^FK integer
id ^FK integer
timestamps timestamps

enrollments

timestamps timestamps
id ^FK integer
cb_id ^FK integer

attendences

timestamps timestamps
id ^FK integer
date date
attend boolean

files

timestamps timestamps
f_id increments
file_path string (100)
date date
type string (20)
id ^FK integer

results

timestamps timestamps
id ^FK integer
sub_id ^FK integer
e_id ^FK integer

exam_infos

timestamps timestamps
e_id increments
type string (50)

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