Doubt to create mysql table with monthly and quarterly values

Question

Doubt to create mysql table with monthly and quarterly values

Navigation

#1 by (2 votes)

1

I need to create a table called "evaluation" in which once a month must enter values of a simple formula a / b, that is, a field for a, another for b and a third for the result. First, the table would look like this: idEvaluacion,idProducto,fecha,denominador(a),numerador(b),resultado .

The problem is that I do not know if this structure works, because in addition I must store (or calculate dynamically, there is my doubt) the totals quarterly throughout the year. I planned to make a large table with one field for each month and between half another field for each quarter.

I have only two tables for this:

productos
------------
idProducto int,
nombre varchar

evaluacion
-----------------
idEvaluacion int ai,
fk_idProducto int,
fecha datetime,
denominador int,
numerador int,
resultado int

Any advice?

mysql

asked by daniel2017- 30.03.2017 в 20:08

source

1 answer

Get records between two DATETIME in SQL Server Can there be an image inside a header? seo

score 2 · Answer 1

Your structure fits perfectly for what you want to do.

The other problem that you mention, about how to show the results is a problem of the view and not of the database.

Your data can be resolved quarterly with a query grouped by quarters (you could have a column year-quarter or calculate it in the same query) and from there in your view go mixing the data.