Table export.mpc_sub 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
seq_num bigint 20  √  null
batch_seq.seq_num Implied Constraint
batch_num bigint 20  √  null
fpa_id varbinary 20
epoch_mjd double 22
ra_deg double 22
dec_deg double 22
filter_id char 1
mag float 12
obscode char 3
desig varbinary 20
digest float 12  √  null
spatial_idx bigint 20  √  null
survey_mode varbinary 40  √  null
dbname varchar 40  √  null
det_id bigint 20  √  null
tracklet_id bigint 20  √  null
derivedobject_id bigint 20  √  null
submitter varbinary 20
submitted timestamp 19 CURRENT_TIMESTAMP
disposition char 1
discovery char 1  √  null
mpc_desig varbinary 20  √  null

Table contained 351,773 rows at Thu Apr 21 06:56 HST 2011

Indexes:
Column(s) Type Sort Constraint Name
batch_num Performance Asc batch_num
desig Performance Asc desig
discovery Performance Asc discovery
disposition Performance Asc disposition
epoch_mjd Performance Asc epoch_mjd
fpa_id Performance Asc fpa_id
mpc_desig Performance Asc mpc_desig
submitter Performance Asc submitter
survey_mode Performance Asc survey_mode

Close relationships: