Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| file | text | 2147483647 | √ | null |
|
|
DJA filename |
||||
| srcid | int8 | 19 | √ | null |
|
|
Source ID from APT plan |
||||
| ra | float8 | 17,17 | √ | null |
|
|
RA from APT plan |
||||
| dec | float8 | 17,17 | √ | null |
|
|
Dec from APT plan |
||||
| grating | text | 2147483647 | √ | null |
|
|
NIRSpec grating |
||||
| filter | text | 2147483647 | √ | null |
|
|
Blocking filter |
||||
| effexptm | float4 | 8,8 | √ | null |
|
|
Effective exposure time of each exposure |
||||
| nfiles | int8 | 19 | √ | null |
|
|
Number of files combined in final spectrum |
||||
| dataset | text | 2147483647 | √ | null |
|
|
Filename of first exposure |
||||
| msamet | text | 2147483647 | √ | null |
|
|
MSA metadata file |
||||
| msaid | int8 | 19 | √ | null |
|
|
MSA metadata ID |
||||
| msacnf | int8 | 19 | √ | null |
|
|
MSA metadata config |
||||
| dithn | int8 | 19 | √ | null |
|
|
Dither number |
||||
| slitid | int8 | 19 | √ | null |
|
|
MSA plan slit ID |
||||
| root | text | 2147483647 | √ | null |
|
|
DJA program + mask rootname |
||||
| npix | int8 | 19 | √ | null |
|
|
Number of pixels in the 2D spectrum |
||||
| ndet | int8 | 19 | √ | null |
|
|
Number of detectors contributing to output |
||||
| wmin | float4 | 8,8 | √ | null |
|
|
Minimum wavelength of the combined spectrum |
||||
| wmax | float4 | 8,8 | √ | null |
|
|
Maximum wavelength of the combined spectrum |
||||
| wmaxsn | float4 | 8,8 | √ | null |
|
|
Wavelength of maximum signal to noise |
||||
| sn10 | float4 | 8,8 | √ | null |
|
|
10th percentile SN |
||||
| flux10 | float4 | 8,8 | √ | null |
|
|
Flux at sn10 |
||||
| err10 | float4 | 8,8 | √ | null |
|
|
Uncertainty at sn50 |
||||
| sn50 | float4 | 8,8 | √ | null |
|
|
50th percentile SN |
||||
| flux50 | float4 | 8,8 | √ | null |
|
|
Flux at sn50 |
||||
| err50 | float4 | 8,8 | √ | null |
|
|
Uncertainty at sn90 |
||||
| sn90 | float4 | 8,8 | √ | null |
|
|
90th percentile SN |
||||
| flux90 | float4 | 8,8 | √ | null |
|
|
Flux at sn90 |
||||
| err90 | float4 | 8,8 | √ | null |
|
|
Uncertainty at sn90 |
||||
| xstart | int8 | 19 | √ | null |
|
|
Starting detector x coordinate of 2D cutout |
||||
| ystart | int8 | 19 | √ | null |
|
|
Starting detector y coordinate of 2D cutout |
||||
| xsize | int8 | 19 | √ | null |
|
|
x size of 2D cutout |
||||
| ysize | int8 | 19 | √ | null |
|
|
y size of 2D cutout |
||||
| slit_pa | float4 | 8,8 | √ | null |
|
|
Estimated PA of the slitlet |
||||
| pa_v3 | float4 | 8,8 | √ | null |
|
|
Estimated PA of the spacecraft V3 axis |
||||
| srcypix | float4 | 8,8 | √ | null |
|
|
Location of the source in the 2D spectrum |
||||
| profcen | float4 | 8,8 | √ | null |
|
|
Profile offset relative to the expected center |
||||
| profsig | float4 | 8,8 | √ | null |
|
|
Derived profile width in pixels added to PSF |
||||
| ctime | float8 | 17,17 | √ | null |
|
|
UNIX time when file was generated |
||||
| version | varchar | 64 | √ | null |
|
|
MSAEXP code version |
||||
| exptime | float4 | 8,8 | √ | null |
|
|
Estimated total exposure time |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| nirspec_extractions_msamet_msaid_dithn_slitid_idx | Performance | Asc/Asc/Asc/Asc | msamet + msaid + dithn + slitid |
| nirspec_extractions_msamet_msaid_slitid_idx | Performance | Asc/Asc/Asc | msamet + msaid + slitid |
| nirspec_extractions_ra_dec_idx | Performance | Asc/Asc | ra + dec |
Relationships
Close relationships within degrees of separation
