school - Laravel Schema Designer

pupils

id increments
name string (255)
admno string (20)
admdate datetime
dateofbirth date
parent_id ^FK integer
branch_id ^FK integer
created_by ^FK integer
timestamps timestamps
updated_by ^FK integer
softDeletes softDeletes

subjects

id increments
subjectname string (255)
subjectcode string (50)
timestamps timestamps
softDeletes softDeletes

classes

id increments
classname string (255)
created_by ^FK integer
timestamps timestamps
updated_by ^FK integer
softDeletes softDeletes

teacherSubjects

id increments
teacher_id ^FK integer
subject_id ^FK integer
class_id ^FK integer
timestamps timestamps
softDeletes softDeletes

tests

id increments
testname string (50)
timestamps timestamps
softDeletes softDeletes

branches

id increments
branchname string (255)
timestamps timestamps
softDeletes softDeletes

terms

id increments
term string (100)
timestamps timestamps
softDeletes softDeletes

roles

id increments
rolename string (255)
timestamps timestamps
softDeletes softDeletes

permissions

id increments
pname string (255)
slugname string (255)
timestamps timestamps
softDeletes softDeletes

permissionRole

id increments
role_id ^FK integer
permission_id ^FK integer
timestamps timestamps

performances

id increments
classpupil_id ^FK integer
subject_id ^FK integer
class_id ^FK integer
teacher_id ^FK integer
test_id ^FK integer
branch_id ^FK integer
term_id ^FK integer
timestamps timestamps
softDeletes softDeletes

users

id increments
name string (255)
email string (255)
username string (255)
password string (255)
timestamps timestamps
role_id ^FK integer
softDeletes softDeletes

classPupil

id increments
pupil_id ^FK integer
class_id ^FK integer
year date
timestamps timestamps
softDeletes softDeletes

parent

id increments
parent string (100)
mother string (100)
phoneno string (20)
email string (50)
created_by ^FK integer
timestamps timestamps
updated_by ^FK integer
softDeletes softDeletes

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