Table atlas_T08.fields Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
field_id bigint 19  √ 
detections.field_id Implied Constraint R
history.field_id Implied Constraint R
runs.field_id Implied Constraint R
tracklets.field_id Implied Constraint R
Auto-assigned internal MOPS field ID
epoch_mjd double 22 Time (epoch) of field acquisition, MJD, UTC
uncorrected_epoch_mjd double 22 Uncorrected epoch of field acquisition, MJD, UTC
ra_deg double 22 RA, deg, of field center
dec_deg double 22 Dec, deg, of field center
survey_mode varchar 120  √  null PS-defined survey mode, e.g. ESS, MSS, 3PI, CAL
time_start double 22  √  null Time of field start acquisition, MJD, UTC
time_stop double 22  √  null Time of field stop acquisition, MJD, UTC
filter_id char 2  √  null
filter_info.filter_id Implied Constraint R
Filter used for acquisition, g/r/i/z/y/w
limiting_mag double 22  √  null Field limiting magnitude
ra_sigma double 22  √  null Uncertainty in RA
dec_sigma double 22  √  null Uncertainty in Dec
obscode char 3  √  null MPC observatory code
de1 double 22  √  null IPP-defined detection efficiency 1
de2 double 22  √  null IPP-defined detection efficiency 2
de3 double 22  √  null IPP-defined detection efficiency 3
de4 double 22  √  null IPP-defined detection efficiency 4
de5 double 22  √  null IPP-defined detection efficiency 5
de6 double 22  √  null IPP-defined detection efficiency 6
de7 double 22  √  null IPP-defined detection efficiency 7
de8 double 22  √  null IPP-defined detection efficiency 8
de9 double 22  √  null IPP-defined detection efficiency 9
de10 double 22  √  null IPP-defined detection efficiency 10
ocnum int 10  √  null pre-computed observing cycle number
nn int 10  √  null pre-comptued night number
fpa_id varchar 20  √  null IPP EXP_NAME (camera ID)
exp_id varchar 20  √  null IPP EXP_ID (full exposure ID)
diff_id varchar 20  √  null IPP DIFF_ID (image diff ID)
pa_deg double 22  √  null Boresight position angle, 0=North
fov_deg double 22  √  null Field-of-view (diameter [circular] or side [rect], degrees
xyidx_size int 10  √  null num of bins in each direction of X/Y index
se_deg double 22  √  null Solar elongation of field center, degrees
eb_deg double 22  √  null Ecliptic latitude (eb) of field center, degrees
gb_deg double 22  √  null Galactic latitude (gb) of field center, degrees
imfile varchar 1024  √  null Image filename
status char 1  √  N processing status of field
parent_id bigint 19  √  null ID of master (final) parent in tuple; NULL to indicate master

Table contained 1,364,317 rows at Fri Jul 12 15:38 HST 2024

Indexes:
Column(s) Type Sort Constraint Name
field_id Primary key Asc PRIMARY
epoch_mjd Performance Asc epoch_mjd
filter_id Performance Asc filter_id
fpa_id Performance Asc fpa_id
nn Performance Asc nn

Close relationships: