I have a few questions to ask. I already have a table that serves as sign up and login for users; it has email, username and password. Will I have to add three columns like credit_amount, debit_amount and balance_amount (AS INTEGERS DATA TYPE) to the table, that will serve as
credit for deposits (that is positive +)
debit for any service used (that is negative -)
balance for the sum total left
And if so, will there be a way to make the already existing table accept data into fields like email, username and password, with other new fields like credit_amount, debit_amount and balance_amount being empty ? I dont know how to interface with a payemtn gateway and also coding for credit, debit and sum query. Please kindly help. thank you.
What I have tried:
I have not tried anything yet but I am hoping to get some directions towards this before starting my coding