SchoolPayment - Laravel Schema Designer

student

id increments
fname string (255)
lname string (255)
gender enum
image text
date_of_birth date
religion enum
blood_group enum
mobile string
email string
guardian_id ^FK integer
address_id ^FK integer
softDelete softDeletes
timestamps timestamps
admission_id string (255)

guardian

id increments
father_name string
mother_name string
guardian_name string
father_occupation string
mother_occupation string
guardian_occupation string
father_mobile string
mother_mobile string
guardian_mobile string
guardian_email string
relation string

address

id increments
address_line_1 text
address_line_2 text
address_line_3 text
timestamps timestamps
softDeletes softDeletes

student_payment

id increments
total_value double
timestamps timestamps
softDeletes softDeletes
discount_id ^FK integer
student_id ^FK integer
state enum

discount

id increments
title string
start_date timestamp
end_date timestamp
value double
static_value boolean
paydiscount boolean
time_based boolean
timestamps timestamps
softDeletes softDeletes

payment

id increments
timestamps timestamps
softDeletes softDeletes
title string
description text
value integer
expiable boolean
expiry_date timestamp
penalty_id ^FK integer

payment_details

id increments
payment_id ^FK integer
discount_id ^FK integer
final_value double
student_payment_id ^FK integer

penalty

id increments
title string
timestamps timestamps
softDeletes softDeletes
value double
static_value boolean
type enum

family

id increments
timestamps timestamps
softDeletes softDeletes
student1 ^FK integer
student2 ^FK integer
relation enum

payment_discount

id increments
timestamps timestamps
softDeletes softDeletes
payment_id ^FK integer
discount_id ^FK integer

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