is Payment table needed when you have an invoice table like this?
Posted
by EBAGHAKI
on Stack Overflow
See other posts from Stack Overflow
or by EBAGHAKI
Published on 2010-03-29T23:49:38Z
Indexed on
2010/03/29
23:53 UTC
Read the original article
Hit count: 145
this is my invoice table:
Invoice Table:
invoice_id
creation_date
due_date
payment_date
status enum('not paid','paid','expired')
user_id
total_price
I wonder if it's Useful to have a payment table in order to record user payments for invoices.
payment table can be like this:
payment_id
payment_date
invoice_id
price_paid
status enum('successful', 'not successful')
© Stack Overflow or respective owner
