Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| dataproduct_type | text | 2147483647 | √ | null |
|
|
MAST keyword |
|
| calib_level | int8 | 19 | √ | null |
|
|
MAST keyword |
|
| obs_collection | text | 2147483647 | √ | null |
|
|
MAST keyword |
|
| obs_id | text | 2147483647 | √ | null |
|
|
MAST keyword |
|
| target | text | 2147483647 | √ | null |
|
|
Target name |
|
| ra | float8 | 17,17 | √ | null |
|
|
Right Ascension, deg |
|
| dec | float8 | 17,17 | √ | null |
|
|
Declination, deg |
|
| t_min | float8 | 17,17 | √ | null |
|
|
Observation start time |
|
| t_max | float8 | 17,17 | √ | null |
|
|
Observation end time |
|
| exptime | float8 | 17,17 | √ | null |
|
|
Exposure time |
|
| wavelength_region | text | 2147483647 | √ | null |
|
|
MAST keyword |
|
| filter | text | 2147483647 | √ | null |
|
|
Instrument filter |
|
| em_min | float8 | 17,17 | √ | null |
|
|
||
| em_max | float8 | 17,17 | √ | null |
|
|
||
| target_classification | text | 2147483647 | √ | null |
|
|
Target type |
|
| obs_title | text | 2147483647 | √ | null |
|
|
MAST keyword |
|
| t_obs_release | float8 | 17,17 | √ | null |
|
|
Data release date |
|
| instrument_name | text | 2147483647 | √ | null |
|
|
Instrument |
|
| proposal_pi | text | 2147483647 | √ | null |
|
|
MAST proposal PI |
|
| proposal_id | text | 2147483647 | √ | null |
|
|
MAST proposal ID |
|
| proposal_type | text | 2147483647 | √ | null |
|
|
MAST keyword |
|
| project | text | 2147483647 | √ | null |
|
|
MAST keyword |
|
| sequence_number | int8 | 19 | √ | null |
|
|
MAST keyword |
|
| provenance_name | text | 2147483647 | √ | null |
|
|
MAST keyword |
|
| footprint | text | 2147483647 | √ | null |
|
|
Exposure footprint |
|
| jpegURL | text | 2147483647 | √ | null |
|
|
MAST keyword |
|
| dataURL | text | 2147483647 | √ | null |
|
|
MAST keyword |
|
| dataRights | text | 2147483647 | √ | null |
|
|
MAST keyword |
|
| mtFlag | bool | 1 | √ | null |
|
|
Moving target |
|
| srcDen | float8 | 17,17 | √ | null |
|
|
MAST keyword |
|
| intentType | text | 2147483647 | √ | null |
|
|
MAST keyword |
|
| obsid | text | 2147483647 | √ | null |
|
|
MAST keyword |
|
| objID | text | 2147483647 | √ | null |
|
|
MAST keyword |
|
| visit | text | 2147483647 | √ | null |
|
|
MAST keyword |
|
| area | float8 | 17,17 | √ | null |
|
|
||
| orientat | float8 | 17,17 | √ | null |
|
|
MAST keyword |
|
| assoc_idx | int8 | 19 | √ | null |
|
|
index of query tool |
|
| status | int8 | 19 | √ | null |
|
|
MAST keyword |
|
| parent | text | 2147483647 | √ | null |
|
|
Parent name for the mastquery search |
|
| modtime | float8 | 17,17 | √ | null |
|
|
Processing timestamp |
|
| assoc_name | text | 2147483647 | √ | null |
|
|
Association name for data block |
|
| aid | serial | 10 | √ | nextval('assoc_table_aid_seq'::regclass) |
|
|
Unique identifier index |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| assoc_table_pkey | Primary key | Asc | aid |
Relationships
Close relationships within degrees of separation
