Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| root | text | 2147483647 | √ | null |
|
|
Field rootname |
|
| id | int8 | 19 | √ | null |
|
|
Object id |
|
| objid | int8 | 19 | √ | null |
|
|
Master object id in photometry_apcorr table |
|
| filter | text | 2147483647 | √ | null |
|
|
FILTER keyword of parent exposure |
|
| pupil | text | 2147483647 | √ | null |
|
|
PUPIL keyword of the parent exposure |
|
| pa | int8 | 19 | √ | null |
|
|
Position angle of the increasing-wavelength dispersion axis, degrees |
|
| instrument | text | 2147483647 | √ | null |
|
|
Instrument naame |
|
| fwcpos | text | 2147483647 | √ | null |
|
|
FWCPOS of parent exposure (i.e., JWST/NIRISS) |
|
| order | text | 2147483647 | √ | null |
|
|
Name of the extracted order, e.g., 1st order is usually A |
|
| parent | text | 2147483647 | √ | null |
|
|
Parent dataset name |
|
| parent_ext | text | 2147483647 | √ | null |
|
|
File extension of the parent exposure used |
|
| ccdchip | int8 | 19 | √ | null |
|
|
CCDCHIP keyword of parent exposure |
|
| sci_extn | int8 | 19 | √ | null |
|
|
HDU in the parent exposure of the science data used |
|
| exptime | float8 | 17,17 | √ | null |
|
|
Exposure time, seconds |
|
| origin_x | int8 | 19 | √ | null |
|
|
x coordinate of lower left corner of the cutout |
|
| origin_y | int8 | 19 | √ | null |
|
|
y coordinate of lower left corner of the cutout |
|
| pad | int8 | 19 | √ | null |
|
|
Padding of the parent image before cutout, i.e., x = origin_x - pad |
|
| nx | int8 | 19 | √ | null |
|
|
x size of the 2D cutout |
|
| ny | int8 | 19 | √ | null |
|
|
y size of the 2D cutout |
|
| sregion | text | 2147483647 | √ | null |
|
|
WCS footprint of the 2D cutout |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| b_objid | Performance | Asc | objid |
Relationships
Close relationships within degrees of separation
