SchemaSpy Analysis of export - Columns Generated by
SchemaSpy
Generated by SchemaSpy on Thu Apr 21 06:56 HST 2011
Legend: SourceForge.net
Primary key columns
Columns with indexes
 

export contains 24 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default Children Parents Comments
mpc_sub batch_num bigint 20  √  null
mpc_sub dbname varchar 40  √  null
mpc_sub derivedobject_id bigint 20  √  null
mpc_sub det_id bigint 20  √  null
mpc_sub digest float 12  √  null
mpc_sub discovery char 1  √  null
mpc_sub mpc_desig varbinary 20  √  null
mpc_sub seq_num bigint 20  √  null
batch_seq.seq_num Implied Constraint
mpc_sub spatial_idx bigint 20  √  null
mpc_sub survey_mode varbinary 40  √  null
mpc_sub tracklet_id bigint 20  √  null
mpc_sub dec_deg double 22
mpc_sub desig varbinary 20
mpc_sub disposition char 1
mpc_sub epoch_mjd double 22
mpc_sub filter_id char 1
mpc_sub fpa_id varbinary 20
mpc_sub mag float 12
mpc_sub obscode char 3
mpc_sub ra_deg double 22
batch_seq seq_num bigint 20  √ 
desig_seq.seq_num Implied Constraint
mpc_sub.seq_num Implied Constraint
auto_increment
desig_seq seq_num bigint 20  √ 
batch_seq.seq_num Implied Constraint
auto_increment
mpc_sub submitted timestamp 19 CURRENT_TIMESTAMP
mpc_sub submitter varbinary 20