school - Laravel Schema Designer

schools

id increments
name text
logo text
description text
contact_no text
email text
owner string
address text
registration_no text
pincode string (6)
timestamps timestamps
softDeletes softDeletes

groups

id increments
school_id integer
name string (160)
description text
active tinyInteger
timestamps timestamps
softDeletes softDeletes

subjects

id increments
school_id integer
name string (191)
description text
active tinyInteger
timestamps timestamps
softDeletes softDeletes

notifications

id increments
teacher_id ^FK integer
group_id integer
student_id integer
message text
images text
type enum
timestamps timestamps
subject text
softDeletes softDeletes

teachers

id increments
school_id integer
name string (191)
middle_name string (191)
last_name string (191)
username string (191)
password text
email string (191)
contact_no text
description text
active tinyInteger
timestamps timestamps
softDeletes softDeletes

students

id increments
parent_id integer
general_number string (191)
name string (190)
middle_name string (191)
last_name string (190)
image text
email string (191)
contact_no string (191)
description text
active tinyInteger
timestamps timestamps
softDeletes softDeletes

student_details

id increments
student_id integer
group_id ^FK integer
roll_number string (191)
subjects json
session string (50)
active tinyInteger
timestamps timestamps
softDeletes softDeletes

parents

id increments
father_name text
mother_name text
email string (191)
password text
contact_no string (15)
type enum
active tinyInteger
timestamps timestamps
softDeletes softDeletes

group_subject_teacher

id increments
teacher_id ^FK integer
group_id ^FK integer
subject_id integer
session string (50)
timestamps timestamps
softDeletes softDeletes

parent_teacher_chat

id increments
teacher_id ^FK integer
student_id ^FK integer
message text
images text
type enum
active tinyInteger
timestamps timestamps
softDeletes softDeletes

appreciations

id increments
teacher_id integer
student_id integer
subject_id integer
subject text
message text
images text
timestamps timestamps
softDeletes softDeletes

announcements

id increments
school_id integer
user_id integer
subject text
message text
timestamps timestamps
softDeletes softDeletes

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