Take the 2-minute tour ×  I am doing an application called as
Invoice Application.For that I have my database is like
this.enter image description here  Now my problem comes when I
am taking the tax part in my database.As I have made tax as an
option where user can add one or two different taxes in an
invoice form.Also I have taken total in invoice_items table to
do calculations.So is this database is fine for doing all the
calculation or I have to take another extra table for doing
calculation and all?Any help regarding to make the database
design simpler will be more appreciable.   Here is the link for
another question little bit similar.So can this question be
solved like this?  share|improve this question add comment  3
Answers  One note on the float issue. Yes it is an issue. Use
DECIMAL instead which gives you arbitrary precision on the math.
MySQL does this internally strings of 9-digit, 32-bit ints. Not
quite as cool as PostgreSQL's base 1000 mapping but it should
work well enough.  DECIMAL are arbitr