school_db - Laravel Schema Designer

students

id increments
name string (255)
gender integer
date_of_birth date
religion string (255)
mobile string
email string
stage_id ^FK integer

guardians

id increments
father_name string
mother_name string
guardian_name string
father_mobile string
mother_mobile string
guardian_mobile string
guardian_email string

employees

id increments
timestamps timestamps
number string
name string
department_id ^FK integer
sallary integer

departments

id increments
timestamps timestamps
name string
parent ^FK integer

moderators

id increments
timestamps timestamps
name string
email string
password string

moderator_departments

id increments
timestamps timestamps
moderator_id ^FK integer
department_id ^FK integer

leaves

id increments
start_from datetime
end_at datetime
employee_id ^FK integer
leave_type ^FK integer
department_id ^FK integer
image string
timestamps timestamps

leaves_types

id increments
timestamps timestamps
name string
note text

payrolls

id increments
timestamps timestamps

rewards

id increments
timestamps timestamps
amount string
note text
status enum
employee_id ^FK integer
moderator_id ^FK integer

borrows

id increments
amount string
note text
employee_id ^FK integer
moderator_id ^FK integer
timestamps timestamps
status enum

discounts

id increments
amount string
note text
employee_id ^FK integer
moderator_id ^FK integer
date timestamps
timestamps timestamps

rates

id increments
rate integer
date timestamps
moderator_id ^FK integer
employee_id ^FK integer
related_type enum
timestamps timestamps
student_id ^FK integer

holidays

id increments
start_from timestamps
ends_at timestamps
note text
department_id ^FK integer
timestamps timestamps
moderator_id ^FK integer

stages

id increments
timestamps timestamps
name string
parent ^FK integer

behaviors

id increments
rate integer
date date
note text
student_id ^FK integer
employee_id ^FK integer
timestamps timestamps

tests_students

id increments
date date
materials json
timestamps timestamps
student_id ^FK integer
finalgrade integer
finalgrade_result integer

account_cats

id increments
type enum
name string
timestamps timestamps

accounts

id increments
amount string
note text
type enum
moderator_id ^FK integer
acccount_cat_id ^FK integer
employee_id ^FK integer
student_id ^FK integer
timestamps timestamps

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