[INSTRM-1063] Add timestamp in `pfs_visit` table Created: 01/Sep/20 Updated: 10/Nov/20 Resolved: 10/Nov/20 |
|
| Status: | Done |
| Project: | Instrument control development |
| Component/s: | spt_operational_database |
| Affects Version/s: | None |
| Fix Version/s: | None |
| Type: | Task | Priority: | Normal |
| Reporter: | Kiyoto Yabe | Assignee: | Kiyoto Yabe |
| Resolution: | Done | Votes: | 0 |
| Labels: | opDB | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Reviewers: | michitaro |
| Description |
|
Add a column for timestamp when `pfs_visit_id` is issued so that we can easily find out pfs_visit_ids for a certain period of observations so on... |
| Comments |
| Comment by Kiyoto Yabe [ 10/Nov/20 ] |
|
Added `issued_at` column and close this ticket. Talking to Koike-san, using SQLAlchemy's server_default is another option but should be considered in a separate ticket if necessary. |