Table psmops_ps1_mdrm137.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 20  √ 
det_rawattr_v2.det_id det_rawattr_v2_ibfk_1
export_dets.det_id export_dets_ibfk_2
residuals.det_id residuals_ibfk_1
tracklet_attrib.det_id tracklet_attrib_ibfk_2
auto_increment
field_id bigint 20  √  null
fields.field_id detections_ibfk_2
ra_deg double 22
dec_deg double 22
epoch_mjd double 22
mag float 12
ref_mag float 12  √  null
filter_id char 2
filter_info.filter_id detections_ibfk_1
s2n float 12  √  null
ra_sigma_deg float 12  √  null
dec_sigma_deg float 12  √  null
mag_sigma float 12  √  null
orient_deg float 12  √  null
length_deg float 12  √  null
object_name varbinary 32  √  null
obscode char 3  √  null
is_synthetic char 1  √  null
det_num bigint 20  √  null
status char 1  √  null
xyidx int 11  √  null
proc_id bigint 20  √  null

Table contained 1,190,529 rows at Thu Apr 21 06:56 HST 2011

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  within of separation: