A transaction can either be a debit
or a credit
not both at the same time.
So, why not this :
Table : transactions
Schema :
id:increments
amount:decimal(x,y)
type:string or enum with debit / credit)
date:timestamp
timestamps: (for created_at & updated_at);
Sign in to participate in this thread!
The Laravel portal for problem solving, knowledge sharing and community building.
The community