[INSTRM-1009] Add camera_name and module_name columns to sps_camera table. Created: 11/Jun/20 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: | Minor |
| Reporter: | cloomis | Assignee: | Kiyoto Yabe |
| Resolution: | Done | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Description |
|
sps_camera is a static table with one row per camera. One function it provides are canonical identifiers for each camera. To simplify various routines it would be useful to have both a camera_name column, e.g. "b3" and module_name column, e.g. "sm3". I guess we could add a function, but for a 16-row table I don't see the gain. |
| Comments |
| Comment by Kiyoto Yabe [ 16/Jun/20 ] |
|
Do you want to have `module_name` in `sps_camera`? I expect that `sps_module_id` is identical to the SpS module number and I could add `sps_module_name` in `sps_module` for the sake of normalization. If it's necessary, I'm happy to add it in `sps_camera`. |
| Comment by cloomis [ 21/Jun/21 ] |
|
Yes, please add both `camera_name` (e.g. "b3") and `module_name` (e.g. "sm3"). (or `sps_camera_name` and `sps_module_name`. I personally think that the "sps" in the table name is sufficient, but understand that you might want to be explicit). |