Fee Structure and Fee Collection Module - PaperLessEdu/schoolerp-web-ui GitHub Wiki

Ref: Orbis School Fee Structure

Table Name: fee_master

Field	Description
fee_master_id	Primary key
standard_id	Foreign key of standard table
gender	Male / Female
totalFee	Total fee for that Standard

Table Name: fee_installment

Field	Description
fee_installment_id	Primary key
fee_master_id	Foreign key of Fee Master table
type	Type can be Installment / OneTime
amount	Amount of the installments
payableDate

Table Name: fee_installments_breakdown

Field	Description
fee_installment_breakdown_id	Primary key
fee_installment_id	Foreign key of Fee Installment table
name
amount

Table Name: fee_collection

Field	Description
fee_collection_id	Primary key
student_id	Foreign key of Student table
fee_installments_id	Foreign key of Fee Installment table
amount	Collected Amount
collectionDate	Date on which Fee has collected
collectionType	Collection type can be Cash / Check / OnlinePayment
comment	In comment admin can mention check number, Bank Name, Online Payment Reference etc.