Table atlas_T08.detections 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
det_id bigint 19  √ 
det_rawattr_v2.det_id Implied Constraint R
det_rawattr_v3.det_id Implied Constraint R
det_sig.det_id Implied Constraint R
export_dets.det_id Implied Constraint R
manual_detections.det_id Implied Constraint R
residuals.det_id Implied Constraint R
tracklet_attrib.det_id Implied Constraint R
Auto-defined MOPS internal detection ID
field_id bigint 19  √  null
fields.field_id Implied Constraint R
Source field ID containing this detection
ra_deg double 22 RA, deg
dec_deg double 22 Dec, deg
epoch_mjd double 22 Exact time of detection acquistion, not necessarily constant across field
mag float 12 Apparent magnitude of detection
ref_mag float 12  √  null Reference magnitude before shape modulation applied (for synth dets)
filter_id char 2
filter_info.filter_id Implied Constraint R
Filter used for this detection
s2n float 12  √  null Detection signal-to-noise
ra_sigma_deg float 12  √  null Working 1-sigma uncertainty in RA, deg
dec_sigma_deg float 12  √  null Working 1-sigma uncertainty in Dec, deg
mag_sigma float 12  √  null Uncertainty in magnitude
orient_deg float 12  √  null Orientation of detection, deg; 0 => N, + toward E
length_deg float 12  √  null Length of detection, deg
object_name varbinary 32  √  null Originating SSM object name, if synthetic
obscode char 3  √  null MPC observatory code
is_synthetic char 1  √  null efficiency marker; indicates detection is synthetic
det_num bigint 19  √  null zero-based detection number in source IPP FITS file
status char 1  √  null efficiency marker; indicates detection was detected (not lost in chip gap, etc.)
xyidx int 10  √  null XY spatial index number within field
proc_id bigint 19  √  null opaque IPP processing identifier (usually DIFFIM_ID)
dev_x float 12  √  null device X coordinate
dev_y float 12  √  null device Y coordinate
dev_id bigint 19  √  null device ID

Table contained 32,735,723 rows at Fri Jul 12 15:38 HST 2024

Indexes:
Column(s) Type Sort Constraint Name
det_id Primary key Asc PRIMARY
epoch_mjd Performance Asc epoch_mjd
field_id Performance Asc field_id
field_id + xyidx Performance Asc/Asc field_id_2
filter_id Performance Asc filter_id
object_name Performance Asc object_name

Close relationships: