CODEWITHSUNDEEP
phpmysqldatabasepayment
aabreu
aabreu

Reputation: 335

Track monthly payments database structure

So I need to track user's monthly payments.

I have a table for the users with all their info.

I'm guessing I'll need another table with all the months since 2010.

I don't know, how is this done? it would also need to add new months as time passes...

I don't really need help with code, just the database structure.

Upvotes: 2

Views: 1485

Answers (1)

Randy
Randy

Reputation: 16677

you need another table for PAYMENT

something like 

PAYMENT
-------------
payment_id
amount
payment_date
user_id

Upvotes: 6

Related Questions