[Answer]-How would this get stored in a database?

by

1👍

✅

Just create a table with X, Y, timestamp and a foreignkey to an entry in an entry table.

Data table:

ID  | Index |  X  |  Y  |  EntryID
0   |   0   | 3.2 | 4.3 |   1
1   |   1   | 2.1 | 1.2 |   1
........
n-1 |   n-1 | xn  | yn  |   1

# The above is from array 1, below from another array

n   |   0   | 2.2 | 2.4 |   2
n+1 |   1   | 2.1 | 1.9 |   2
.........
n+m-1 | m-1 | xm  | ym  |   2

Entry table:

ID | Name          | DateTime
1  | user3043594   | 2013-..
2  | Steinar Lima  | 2012-..

You store all entries from all arrays in this table, and filter them based on entry id. Then you can do a join to get the user name from the user table.

👤Steinar Lima

Leave a comment