Table psmops_ps1_mdrm137.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 20  √ 
detections.field_id detections_ibfk_2
history.field_id history_ibfk_3
tracklets.field_id tracklets_ibfk_1
auto_increment
epoch_mjd double 22
uncorrected_epoch_mjd double 22
ra_deg double 22
dec_deg double 22
survey_mode varchar 120  √  null
time_start double 22  √  null
time_stop double 22  √  null
filter_id char 2  √  null
filter_info.filter_id fields_ibfk_1
limiting_mag double 22  √  null
ra_sigma double 22  √  null
dec_sigma double 22  √  null
obscode char 3  √  null
de1 double 22  √  null
de2 double 22  √  null
de3 double 22  √  null
de4 double 22  √  null
de5 double 22  √  null
de6 double 22  √  null
de7 double 22  √  null
de8 double 22  √  null
de9 double 22  √  null
de10 double 22  √  null
ocnum int 11  √  null
nn int 11  √  null
fpa_id varchar 20  √  null
exp_id varchar 20  √  null
diff_id varchar 20  √  null
pa_deg double 22  √  null
fov_deg double 22  √  null
xyidx_size int 11  √  null
se_deg double 22  √  null
eb_deg double 22  √  null
gb_deg double 22  √  null
status char 1  √  N
parent_id bigint 20  √  null

Table contained 490 rows at Thu Apr 21 06:56 HST 2011

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

Close relationships  within of separation: