[INSTRM-1308] Additional columns in `fiducial_fiber_geometry` Created: 30/Jun/21 Updated: 15/Jul/21 Resolved: 15/Jul/21 |
|
| Status: | Done |
| Project: | Instrument control development |
| Component/s: | spt_operational_database |
| Affects Version/s: | None |
| Fix Version/s: | None |
| Type: | Task | Priority: | Major |
| Reporter: | Kiyoto Yabe | Assignee: | Kiyoto Yabe |
| Resolution: | Done | Votes: | 0 |
| Labels: | opDB | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Description |
|
`fiducial_fiber_geometry` needs additional columns to store information at different elevation and temperature. Add `elevation` and `ambient_temp` to the table. Also, The primery key should be a combination of fiducial_fiber_id and something which specifies (elevation, ambient_temp). Add e.g. `fiducial_fiber_calib_id` making a new table `fiducial_fiber_calib`. |
| Comments |
| Comment by Kiyoto Yabe [ 30/Jun/21 ] |
|
fix pushed.
Table "public.fiducial_fiber_calib" Column | Type | Collation | Nullable | Default -------------------------+-----------------------------+-----------+----------+----------------------------------------------------------------------- fiducial_fiber_calib_id | integer | | not null | nextval('fiducial_fiber_calib_fiducial_fiber_calib_id_seq'::regclass) calibrated_at | timestamp without time zone | | | comments | character varying | | | Indexes: "fiducial_fiber_calib_pkey" PRIMARY KEY, btree (fiducial_fiber_calib_id) Referenced by: TABLE "fiducial_fiber_geometry" CONSTRAINT "fiducial_fiber_geometry_fiducial_fiber_calib_id_fkey" FOREIGN KEY (fiducial_fiber_calib_id) REFERENCES fiducial_fiber_calib(fiducial_fiber_calib_id)
Table "public.fiducial_fiber_geometry" Column | Type | Collation | Nullable | Default -------------------------+---------+-----------+----------+--------- fiducial_fiber_id | integer | | not null | fiducial_fiber_calib_id | integer | | not null | ff_center_on_pfi_x_mm | real | | | ff_center_on_pfi_y_mm | real | | | elevation | real | | | ambient_temp | real | | | Indexes: "fiducial_fiber_geometry_pkey" PRIMARY KEY, btree (fiducial_fiber_id, fiducial_fiber_calib_id) Foreign-key constraints: "fiducial_fiber_geometry_fiducial_fiber_calib_id_fkey" FOREIGN KEY (fiducial_fiber_calib_id) REFERENCES fiducial_fiber_calib(fiducial_fiber_calib_id) "fiducial_fiber_geometry_fiducial_fiber_id_fkey" FOREIGN KEY (fiducial_fiber_id) REFERENCES fiducial_fiber(fiducial_fiber_id)
|