Hi, some week's ago i was having a querying problem, it was i nightmare.
Now i'm i have the same modeling problem. But his time i've stopped to
think before.
Right Here we go:
It's 'simple'. I have a simple datagrid (5 columns x 50 rows). Each row
have a label and the 5 columns values.How can i store this values in an SQL
DB?
I mean (the standart html output):
a1 | a2 | a3
| a4b | a5
Consumption Edge [3,4] [32,34] [113,40] [32,4]
[4,21]
Consumption Out of Edge [3,4] [32,34] [113,40] [32,4]
[4,21]
Demand Edge [3,4] [32,34] [113,40] [32,4]
[4,21]
Demand Out of Edge [3,4] [32,34] [113,40] [32,4]
[4,21]
Total Billed [3,4] [32,34] [113,40]
[32,4] [4,21]
.
.
.
.
.
.
The actual modeling is a table with columns:
*cosumption_edge_a1*,*cosumption_edge_a2 *... etc;
*cosumption_out_edge_a1*,*cosumption_out_edge_a2*. etc ...
But i'm thinking in a diferent model: like this: a table with the values (
5 columns(a1,a2,a3,a4,a5) ), and another with the values. so the first
table will have 5 foreign keys pointing to the values in the other talbe?
What do you think?
Thanks!
