[OBSPROC-65] Add allocated_time columns for low-res and mid-res separately Created: 12/Jan/24  Updated: 03/Feb/24  Resolved: 03/Feb/24

Status: Done
Project: PFS observation processing/procedure
Component/s: ets_target_database
Affects Version/s: None
Fix Version/s: None

Type: Task Priority: Normal
Reporter: monodera Assignee: monodera
Resolution: Done Votes: 0
Labels: targetDB
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Epic Link: targetDB

 Description   

As we ask users to fill the observing time request for low-resolution and medium-resolution modes separately, I'd like to modify the contents of the proposal table in the targetdb as follows.

 

Current columns

  • proposal_id
  • group_id
  • pi_first_name
  • pi_last_name
  • pi_middle_name
  • rank
  • grade
  • allocated_time
  • proposal_category_id
  • created_at
  • updated_at

 

Add

  • allocated_time_lowres
  • allocated_time_midres (medres?)

Rename

  • allocated_time --> allocated_time_total

 

allocated_time* are in the unit of fiberhour.

 

Any comments (especially column names) are welcome.

 Comments   
Comment by monodera [ 03/Feb/24 ]

I'll use

  • allocated_time_lr
  • allocated_time_mr

for the low-resolution and medium-resolution modes, respectively.

 

Comment by monodera [ 03/Feb/24 ]

Currently, both allocated_time_lr and allocated_time_mr are set to be nullabe=True  and no default value is assigned. Let's discuss later what will be the right parameters to set.

Generated at Sat Feb 10 16:44:54 JST 2024 using Jira 8.3.4#803005-sha1:1f96e09b3c60279a408a2ae47be3c745f571388b.