Tables Relationships Utility Tables Constraints Anomalies Columns Donate

Table export.mpc_sub | Generated by SchemaSpy

Implied relationships Related columns Constraint names Comments Legend |
Legend: |
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: