Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| obs_id | text | 2147483647 | √ | null |
|
|
MAST association ID |
||||
| target | text | 2147483647 | √ | null |
|
|
Target name |
||||
| target_ra | float8 | 17,17 | √ | null |
|
|
Target RA, deg |
||||
| target_dec | float8 | 17,17 | √ | null |
|
|
Target Dec., deg |
||||
| t_min | float8 | 17,17 | √ | null |
|
|
Visit start time, mjd |
||||
| t_max | float8 | 17,17 | √ | null |
|
|
Visit end time, mjd |
||||
| exptime | float8 | 17,17 | √ | null |
|
|
Total assoc exposure time, pulled separately from MAST |
||||
| wavelength_region | text | 2147483647 | √ | null |
|
|
General wavelength classification |
||||
| filter | text | 2147483647 | √ | null |
|
|
Filter name |
||||
| em_min | float8 | 17,17 | √ | null |
|
|
Minimum wavelength of the filter passband, nm |
||||
| em_max | float8 | 17,17 | √ | null |
|
|
Maximum wavelength of the filter passband, nm |
||||
| target_classification | text | 2147483647 | √ | null |
|
|
Target classification keywords |
||||
| obs_title | text | 2147483647 | √ | null |
|
|
Observation title |
||||
| t_obs_release | float8 | 17,17 | √ | null |
|
|
Dataset release date, mjd |
||||
| instrument_name | text | 2147483647 | √ | null |
|
|
Instrument name |
||||
| proposal_pi | text | 2147483647 | √ | null |
|
|
Proposal principle investigator |
||||
| proposal_id | int8 | 19 | √ | null |
|
|
Proposal identifier |
||||
| proposal_type | text | 2147483647 | √ | null |
|
|
Proposal category |
||||
| sregion | text | 2147483647 | √ | null |
|
|
Footprint SREGION |
||||
| dataRights | text | 2147483647 | √ | null |
|
|
|||||
| mtFlag | bool | 1 | √ | null |
|
|
|||||
| obsid | int8 | 19 | null |
|
|
Unique observation identifier |
|||||
| objID | int8 | 19 | √ | null |
|
|
|||||
| visit | text | 2147483647 | √ | null |
|
|
Unique visit identifier |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| mast_query_pk | Primary key | Asc | obsid |
Relationships
Close relationships within degrees of separation
