Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| file | varchar | 2147483647 | √ | null |
|
|
Filename |
|||||||
| extension | varchar | 2147483647 | √ | null |
|
|
File extension |
|||||||
| dataset | varchar | 2147483647 | √ | null |
|
|
Dataset name |
|||||||
| assoc | varchar | 2147483647 | √ | null |
|
|
Association name |
|||||||
| parent | varchar | 2147483647 | √ | null |
|
|
Grizli name of parent visit |
|||||||
| awspath | varchar | 2147483647 | √ | null |
|
|
Path to files on AWS |
|||||||
| filter | varchar | 2147483647 | √ | null |
|
|
Instrument filter |
|||||||
| pupil | varchar | 2147483647 | √ | null |
|
|
Intrument pupil wheel value |
|||||||
| mdrizsky | float4 | 8,8 | √ | null |
|
|
Sky level from AstroDrizzle |
|||||||
| exptime | float4 | 8,8 | √ | null |
|
|
Exposure time |
|||||||
| expstart | float4 | 8,8 | √ | null |
|
|
Start time |
|||||||
| sciext | int4 | 10 | √ | null |
|
|
SCI extention number |
|||||||
| instrume | varchar | 2147483647 | √ | null |
|
|
Instrument name |
|||||||
| detector | varchar | 2147483647 | √ | null |
|
|
Instrument detector name |
|||||||
| ndq | int4 | 10 | √ | null |
|
|
Number of DQ > 0 pixels |
|||||||
| expflag | varchar | 2147483647 | √ | null |
|
|
EXPFLAG keyword |
|||||||
| sunangle | float4 | 8,8 | √ | null |
|
|
Angular separation between target and sun |
|||||||
| gsky101 | float4 | 8,8 | √ | null |
|
|
Grism sky 1 |
|||||||
| gsky102 | float4 | 8,8 | √ | null |
|
|
Grism sky 2 |
|||||||
| gsky103 | float4 | 8,8 | √ | null |
|
|
Grism sky 3 |
|||||||
| persnpix | int4 | 10 | √ | null |
|
|
Number of persistence flagged pixels |
|||||||
| perslevl | float4 | 8,8 | √ | null |
|
|
Persistence flag level |
|||||||
| naxis1 | int4 | 10 | √ | null |
|
|
WCS NAXIS1 |
|||||||
| naxis2 | int4 | 10 | √ | null |
|
|
WCS NAXIS2 |
|||||||
| crpix1 | int4 | 10 | √ | null |
|
|
WCS CRPIX1 |
|||||||
| crpix2 | int4 | 10 | √ | null |
|
|
WCS CRPIX2 |
|||||||
| crval1 | float4 | 8,8 | √ | null |
|
|
WCS CRVAL1 |
|||||||
| crval2 | float4 | 8,8 | √ | null |
|
|
WCS CRVAL2 |
|||||||
| cd11 | float4 | 8,8 | √ | null |
|
|
WCS CD1_1 |
|||||||
| cd12 | float4 | 8,8 | √ | null |
|
|
WCS CD1_2 |
|||||||
| cd21 | float4 | 8,8 | √ | null |
|
|
WCS CD2_1 |
|||||||
| cd22 | float4 | 8,8 | √ | null |
|
|
WCS CD2_2 |
|||||||
| ra1 | float4 | 8,8 | √ | null |
|
|
RA of corner 1 |
|||||||
| dec1 | float4 | 8,8 | √ | null |
|
|
Dec of corner 1 |
|||||||
| ra2 | float4 | 8,8 | √ | null |
|
|
RA of corner 2 |
|||||||
| dec2 | float4 | 8,8 | √ | null |
|
|
Dec of corner 2 |
|||||||
| ra3 | float4 | 8,8 | √ | null |
|
|
RA of corner 3 |
|||||||
| dec3 | float4 | 8,8 | √ | null |
|
|
Dec of corner 3 |
|||||||
| ra4 | float4 | 8,8 | √ | null |
|
|
RA of corner 4 |
|||||||
| dec4 | float4 | 8,8 | √ | null |
|
|
Dec of corner 4 |
|||||||
| footprint | path | 2147483647 | √ | null |
|
|
Exposure footprint |
|||||||
| modtime | float4 | 8,8 | √ | null |
|
|
Modification timestamp |
|||||||
| chipsky | float4 | 8,8 | √ | null |
|
|
Extra chip-level sky level |
|||||||
| eid | serial | 10 | √ | nextval('exposure_files_eid_seq'::regclass) |
|
|
Unique identifier |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| exposure_files_pkey | Primary key | Asc | eid |
| exposure_files_dataset_idx | Performance | Asc | dataset |
| exposure_files_eid_detector_expstart_idx | Performance | Asc/Asc/Asc | eid + detector + expstart |
| exposure_files_eid_file_expstart_detector_idx | Performance | Asc/Asc/Asc/Asc | eid + file + expstart + detector |
| exposure_files_eid_filter_idx | Performance | Asc/Asc | eid + filter |
| exposure_files_eid_idx | Performance | Asc | eid |
| exposure_files_eid_idx1 | Performance | Asc | eid |
| exposure_files_eid_idx2 | Performance | Asc | eid |
| exposure_files_file_expstart_detector_idx | Performance | Asc/Asc/Asc | file + expstart + detector |
| exposure_files_file_idx | Performance | Asc | file |
| exposure_files_file_idx1 | Performance | Asc | file |
| exposure_files_parent_idx | Performance | Asc | parent |


