Reorganize data model

[bregeon]

New data model is to have separate tables for geometry, beam configuration and beam spots data. Beam spots data have only ids to refer to the geometry and beam configuration used in the simulation.

• geom module is ready
• beam module needs to be setup as geom module (but is simpler)
• beam spots data frame needs to be reviewed to remove beam information, and add geom id

[bregeon]

beam spots data frame

  | beam_id | geom_id | index | name | pos_x | std_x | pos_y | std_y | width_x | width_y | radius | radius_err | surface | pixel_signal
-- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | --
20001 | 0 | 0 | (L1_exit, L1_entrance) | 0.044617 | 0.000288 | -0.000023 | 0.000288 | 0.001069 | 0.001054 | 0.001061 | 0.000008 | 3.539160 | 560.020741
20001 | 0 | 1 | (L2_exit, L1_entrance) | 0.142133 | 0.000918 | -0.000072 | 0.000918 | 0.003402 | 0.003356 | 0.003379 | 0.000023 | 35.870392 | 50.965061
20001 | 0 | 2 | (L2_exit, L1_exit) | 0.218244 | 0.001417 | -0.000111 | 0.001417 | 0.005251 | 0.005154 | 0.005203 | 0.000049 | 85.033240 | 22.385551
20001 | 0 | 3 | (L2_entrance, L1_entrance) | 0.003181 | 0.000019 | -0.000002 | 0.000019 | 0.000070 | 0.000075 | 0.000072 |  

spots match data frame

 | beam_id_1 | geom_id_1 | beam_id_2 | geom_id_2 | ghost_1 | ghost_2_2d | distance_2d | distance_2d_err | ghost_2_3d | distance_3d | distance_3d_err
-- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | --
1 | 0 | 20001 | 0 | 0 | 0 | 0.000041 | 0.000572 | 0 | 0.000424 | 0.000578
1 | 0 | 20001 | 0 | 1 | 1 | 0.000130 | 0.001821 | 1 | 0.001350 | 0.001836
1 | 0 | 20001 | 0 | 2 | 2 | 0.000200 | 0.002811 | 2 | 0.002077 | 0.002854
1 | 0 | 20001 | 0 | 3 | 3 | 0.000003 | 0.000037 | 3 | 0.000029 | 0.000057
1 | 0 | 20001 | 0 | 4 | 4 | 0.000050 | 0.000708 | 4 | 0.000525 | 0.000714
1 | 0 | 20001 | 0 | 5 | 5 | 0.000151 | 0.002143 | 5 | 0.001576 | 0.002212

[bregeon]

beams data frame

 | beam_id | wl | n_photons | radius | x_offset | y_offset | z_offset | theta | phi
-- | -- | -- | -- | -- | -- | -- | -- | -- | --
10000 | 5.000000e-07 | 1000 | 0.00125 | 0.00 | 0 | 0 | 0.0 | 0.0
10001 | 5.000000e-07 | 1000 | 0.00125 | 0.05 | 0 | 0 | 0.0 | 0.0
10002 | 5.000000e-07 | 1000 | 0.00125 | 0.10 | 0 | 0 | 0.0 | 0.0
10003 | 5.000000e-07 | 1000 | 0.00125 | 0.15 | 0 | 0 | 0.0 | 0.0
10004 | 5.000000e-07 | 1000 | 0.00125 | 0.20 | 0 | 0 | 0.0 | 0.0
20000 | 5.000000e-07 | 100 | 0.00125 | 0.10 | 0 | 0 | 0.0 | 0.0
20001 | 5.000000e-07 | 100 | 0.00125 | 0.10 | 0 | 0 | 5.0 | 0.0
20002 | 5.000000e-07 | 100 | 0.00125 | 0.10 | 0 | 0 | 10.0 | 0.0

[bregeon]

geometry data frame

geom_id | L1 | L2 | L3 | Filter | Detector
-- | -- | -- | -- | -- | --
10018 | [0.0, 0.0, 0.0] | [0.0, 0.0, 0.0] | [0.0, 0.0, 0.0] | [0.0, 0.0, 0.0] | [0.0, 0.0, 0.0]
10019 | [0.09, 0, 0] | [0.0, 0.0, 0.0] | [0.0, 0.0, 0.0] | [0.0, 0.0, 0.0] | [0.0, 0.0, 0.0]
10019 | [0.0, 0.0, 0.0] | [0.0, 0.0, 0.0] | [0.0, 0.0, 0.0] | [0.0, 0.0, 0.0] | [0.0, 0.0, 0.0]
10020 | [0.1, 0, 0] | [0.0, 0.0, 0.0] | [0.0, 0.0, 0.0] | [0.0, 0.0, 0.0] | [0.0, 0.0, 0.0]
10020 | [0.0, 0.0, 0.0] | [0.0, 0.0, 0.0] | [0.0, 0.0, 0.0] | [0.0, 0.0, 0.0] | [0.0, 0.0, 0.0]