| projects | Source | Table | Column | Notes |
|---|---|---|---|---|
| project_code | GBTMD | project | propname | PK |
| legacy_id | PST | proposal | legacy_id | ? |
| total_observation_time | rolled up | |||
| opt_project_id | ||||
| title | PST | proposal | title | |
| abstract | PST | proposal | abstract | |
| proprietary_expiration | ||||
| last_addition | ||||
| starttime | ||||
| endtime | ||||
| proprietary_duration |
| authors | Source | Table | Column | Notes |
|---|---|---|---|---|
| execution_blocks | Source | Table | Column | Notes |
|---|---|---|---|---|
| ost_exec_block_id | N/A | |||
| calibration_level | ||||
| telescope | 'GBT' | |||
| configuration | ||||
| scheduling_block_id | ||||
| ngas_fileset_id | ||||
| project_code | AR | projects | project_code | FK |
| starttime | ||||
| endtime | ||||
| calibration_status | ||||
| scheduling_block_type | ||||
| band_code | GBTMD | obsParameter | recBand | ? |
| ingestion_complete | ||||
| segment | GBTMD | session | name |
| scans | Source | Table | Column | Notes |
|---|---|---|---|---|
| min_bandwidth | ||||
| min_frequency | ||||
| ost_scan_id | GBTMD | scan | number | |
| subscans | Source | Table | Column | Notes |
|---|---|---|---|---|
| obstype | GBTMD | obsProcedure | type | |
| starttime | GBTMD | scan | dateObserved | |
| endtime | GBTMD | scan | dateObserved + scanlength | |
| sourcename | GBTMD | scan | object | |
| sourcetype | ||||
| ra | GBTMD | coordinates | RAJ2000 | |
| dec | GBTMD | coordinates | DECJ2000 | |
| exposure_time | GBTMD | scan | scanlength | |
| integration_time | GBTMD | scan | integrationTime | |
| receiver_id | GBTMD | obsParameter | receiver | |
| backend | GBTMD | obsParameter | backend | |
| intent | GBTMD | obsProcedure | name | |
| configuration_id | FK |
| configurations | Source | Table | Column | Notes |
|---|---|---|---|---|
| data_desc | Source | Table | Column | Notes |
|---|---|---|---|---|