Jump to content

Invoice System Database Design


shaunie

Recommended Posts

Hi,

 

I am creating a system that invoices for events. An event will be of a type of service which will have a cost related to it. I had been planning to store all transactions (payments, invoices, refunds, charges etc) in a transactions table. However invoices are different to all other transactions as they will have invoice line items (made up of events). Should I create a separate invoices table or have an invoice id for each event in the event table?

 

I wanted to keep all transactions in one table as I felt this made sense and would be easier for calculating customer balances.

Link to comment
Share on other sites

  • 3 weeks later...
 Should I create a separate invoices table or have an invoice id for each event in the event table?

 

 

Both. You would at least need to store the invoice id and date (and maybe a reference to the customers order number) in an invoice table and then put the invoice id in the transactions covered by that invoice

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.