exposure_files

310203 rows


Description

Processed exposure information

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
mast_products.dataset Implied Constraint R

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)
exposure_saturated.eid exposure_saturated_eid_fkey R
mosaic_tiles_exposures.expid fk_tile_exposures R

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

Relationships

Close relationships within degrees of separation