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 |