Tables Relationships Utility Tables Constraints Anomalies Columns Donate

SchemaSpy Analysis of psmops_ps1_mdrm137 - Columns | Generated by SchemaSpy

Generated by SchemaSpy on Thu Apr 21 06:56 HST 2011 |
Legend: |
Primary key columns
Columns with indexes
Related columns Constraint names Comments Legend

psmops_ps1_mdrm137 contains 304 columns - click on heading to sort:

Table | Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments
--- | --- | --- | --- | --- | --- | --- | --- | --- | ---
shapes | a_km | double | 22 | √ |  | null |  |  |
derivedobjects | albedo | double | 22 | √ |  | null |  |  |
ssm | albedo | double | 22 | √ |  | null |  |  |
alerted_tracklets | alert_timestamp | timestamp | 19 |  |  | CURRENT_TIMESTAMP |  |  |
shapes | amp_mag | double | 22 | √ |  | null |  |  |
derivedobjects | amplitude | double | 22 | √ |  | null |  |  |
det_rawattr_v2 | ap_flux | float | 12 | √ |  | null |  |  |
det_rawattr_v2 | ap_flux_sig | float | 12 | √ |  | null |  |  |
det_rawattr_v2 | ap_mag | float | 12 | √ |  | null |  |  |
det_rawattr_v2 | ap_mag_radius | float | 12 | √ |  | null |  |  |
det_rawattr_v2 | ap_mag_raw | float | 12 | √ |  | null |  |  |
orbits | arc_length_days | double | 22 | √ |  | null |  |  |
known | arg_peri | double | 22 |  |  |  |  |  |
orbits | arg_peri | double | 22 |  |  |  |  |  |
ssm | arg_peri | double | 22 |  |  |  |  |  |
residuals | ast_reject | char | 1 | √ |  | null |  |  |
shapes | b_km | double | 22 | √ |  | null |  |  |
shapes | beta_deg | double | 22 | √ |  | null |  |  |
shapes | c_km | double | 22 | √ |  | null |  |  |
det_rawattr_v2 | cal_psf_mag | float | 12 | √ |  | null |  |  |
det_rawattr_v2 | cal_psf_mag_sig | float | 12 | √ |  | null |  |  |
orbits | chi_squared | double | 22 | √ |  | null |  |  |
history_identifications | child_orbit_id | bigint | 20 |  |  |  |  |
orbits.orbit_id | history_identifications_ibfk_4
history_identifications | childobject_id | bigint | 20 |  |  |  |  |
derivedobjects.derivedobject_id | history_identifications_ibfk_1
derivedobjects | classification | char | 1 | √ |  | null |  |  |
history | classification | char | 1 | √ |  | null |  |  |
tracklets | classification | char | 1 | √ |  | null |  |  |
config | config_id | bigint | 20 |  | √ |  |  |  | auto_increment
config | config_text | text | 65535 | √ |  | null |  |  |
orbits | conv_code | varchar | 8 | √ |  | null |  |  |
orbits | cov_01 | double | 22 | √ |  | null |  |  |
orbits | cov_02 | double | 22 | √ |  | null |  |  |
orbits | cov_03 | double | 22 | √ |  | null |  |  |
orbits | cov_04 | double | 22 | √ |  | null |  |  |
orbits | cov_05 | double | 22 | √ |  | null |  |  |
orbits | cov_06 | double | 22 | √ |  | null |  |  |
orbits | cov_07 | double | 22 | √ |  | null |  |  |
orbits | cov_08 | double | 22 | √ |  | null |  |  |
orbits | cov_09 | double | 22 | √ |  | null |  |  |
orbits | cov_10 | double | 22 | √ |  | null |  |  |
orbits | cov_11 | double | 22 | √ |  | null |  |  |
orbits | cov_12 | double | 22 | √ |  | null |  |  |
orbits | cov_13 | double | 22 | √ |  | null |  |  |
orbits | cov_14 | double | 22 | √ |  | null |  |  |
orbits | cov_15 | double | 22 | √ |  | null |  |  |
orbits | cov_16 | double | 22 | √ |  | null |  |  |
orbits | cov_17 | double | 22 | √ |  | null |  |  |
orbits | cov_18 | double | 22 | √ |  | null |  |  |
orbits | cov_19 | double | 22 | √ |  | null |  |  |
orbits | cov_20 | double | 22 | √ |  | null |  |  |
orbits | cov_21 | double | 22 | √ |  | null |  |  |
det_rawattr_v2 | cr_sig | float | 12 | √ |  | null |  |  |
derivedobjects | created | timestamp | 19 |  |  | CURRENT_TIMESTAMP |  |  |
history | d3 | float | 12 | √ |  | null |  |  |
history | d4 | float | 12 | √ |  | null |  |  |
runtime | data | bigint | 20 | √ |  | null |  |  |
runtime | date_submitted | timestamp | 19 |  |  | CURRENT_TIMESTAMP |  |  |
fields | de1 | double | 22 | √ |  | null |  |  |
fields | de10 | double | 22 | √ |  | null |  |  |
fields | de2 | double | 22 | √ |  | null |  |  |
fields | de3 | double | 22 | √ |  | null |  |  |
fields | de4 | double | 22 | √ |  | null |  |  |
fields | de5 | double | 22 | √ |  | null |  |  |
fields | de6 | double | 22 | √ |  | null |  |  |
fields | de7 | double | 22 | √ |  | null |  |  |
fields | de8 | double | 22 | √ |  | null |  |  |
fields | de9 | double | 22 | √ |  | null |  |  |
detections | dec_deg | double | 22 |  |  |  |  |  |
fields | dec_deg | double | 22 |  |  |  |  |  |
residuals | dec_error_deg | float | 12 | √ |  | null |  |  |
residuals | dec_resid_deg | float | 12 | √ |  | null |  |  |
fields | dec_sigma | double | 22 | √ |  | null |  |  |
detections | dec_sigma_deg | float | 12 | √ |  | null |  |  |
aqueue | derivedobject_id | bigint | 20 |  |  |  |  |
derivedobjects.derivedobject_id | aqueue_ibfk_1
derivedobject_attrib | derivedobject_id | bigint | 20 |  |  |  |  |
derivedobjects.derivedobject_id | derivedobject_attrib_ibfk_1
eon_queue | derivedobject_id | bigint | 20 |  |  |  |  |
derivedobjects.derivedobject_id | eon_queue_ibfk_1
history | derivedobject_id | bigint | 20 | √ |  | null |  |
derivedobjects.derivedobject_id | history_ibfk_1
ssm | desc_id | bigint | 20 | √ |  | null |  |
ssm_desc.desc_id | ssm_ibfk_1
ssm_desc | description | varchar | 100 | √ |  | null |  |  |
export_dets | det_export_id | bigint | 20 |  | √ |  |  |  | auto_increment
det_rawattr_v2 | det_id | bigint | 20 | √ |  | null |  |
detections.det_id | det_rawattr_v2_ibfk_1
export_dets | det_id | bigint | 20 | √ |  | null |  |
detections.det_id | export_dets_ibfk_2
residuals | det_id | bigint | 20 |  |  |  |  |
detections.det_id | residuals_ibfk_1
tracklet_attrib | det_id | bigint | 20 |  |  |  |  |
detections.det_id | tracklet_attrib_ibfk_2
detections | det_num | bigint | 20 | √ |  | null |  |  |
fields | diff_id | varchar | 20 | √ |  | null |  |  |
det_rawattr_v2 | diff_r_m | float | 12 | √ |  | null |  |  |
det_rawattr_v2 | diff_r_p | float | 12 | √ |  | null |  |  |
det_rawattr_v2 | diff_sn_m | float | 12 | √ |  | null |  |  |
det_rawattr_v2 | diff_sn_p | float | 12 | √ |  | null |  |  |
export | do_export_id | bigint | 20 | √ |  | null |  |  |
known | e | double | 22 |  |  |  |  |  |
orbits | e | double | 22 |  |  |  |  |  |
ssm | e | double | 22 |  |  |  |  |  |
fields | eb_deg | double | 22 | √ |  | null |  |  |
history_attributions | ephemeris_distance | float | 12 |  |  |  |  |  |
history_precoveries | ephemeris_distance | float | 12 |  |  |  |  |  |
history_attributions | ephemeris_uncertainty | float | 12 | √ |  | null |  |  |
history_precoveries | ephemeris_uncertainty | float | 12 | √ |  | null |  |  |
known | epoch | double | 22 |  |  |  |  |  |
orbits | epoch | double | 22 |  |  |  |  |  |
ssm | epoch | double | 22 |  |  |  |  |  |
detections | epoch_mjd | double | 22 |  |  |  |  |  |
fields | epoch_mjd | double | 22 |  |  |  |  |  |
aqueue | event_id | bigint | 20 |  |  |  |  |
history.event_id | aqueue_ibfk_2
eon_queue | event_id | bigint | 20 |  |  |  |  |
history.event_id | eon_queue_ibfk_2
history_attributions | event_id | bigint | 20 |  |  |  |
runtime.event_id | Implied Constraint
history.event_id | history_attributions_ibfk_2
history_derivations | event_id | bigint | 20 |  |  |  |  |
history.event_id | history_derivations_ibfk_2
history_identifications | event_id | bigint | 20 |  |  |  |  |
history.event_id | history_identifications_ibfk_2
history_precoveries | event_id | bigint | 20 |  |  |  |  |
history.event_id | history_precoveries_ibfk_2
history_removals | event_id | bigint | 20 |  |  |  |  |
history.event_id | history_removals_ibfk_2
moid_queue | event_id | bigint | 20 |  |  |  |  |
history.event_id | moid_queue_ibfk_2
runtime | event_id | bigint | 20 |  | √ |  |  |
history_attributions.event_id | Implied Constraint
| auto_increment
history | event_time | timestamp | 19 |  |  | CURRENT_TIMESTAMP |  |  |
history | event_type | char | 1 |  |  |  |  |  |
fields | exp_id | varchar | 20 | √ |  | null |  |  |
export | export_status | char | 1 | √ |  | null |  |  |
export | export_time | datetime | 19 | √ |  | null |  |  |
tracklets | ext_dec | double | 22 | √ |  | null |  |  |
tracklets | ext_epoch | double | 22 | √ |  | null |  |  |
tracklets | ext_mag | double | 22 | √ |  | null |  |  |
tracklets | ext_ra | double | 22 | √ |  | null |  |  |
det_rawattr_v2 | ext_sig | float | 12 | √ |  | null |  |  |
det_rawattr_v2 | f_pos | float | 12 | √ |  | null |  |  |
detections | field_id | bigint | 20 | √ |  | null |  |
fields.field_id | detections_ibfk_2
history | field_id | bigint | 20 | √ |  | null |  |
fields.field_id | history_ibfk_3
tracklets | field_id | bigint | 20 |  |  |  |  |
fields.field_id | tracklets_ibfk_1
ingest_status | file_id | varchar | 100 |  |  |  |  |  |
ingest_status | file_size | int | 11 |  |  |  |  |  |
ingest_status | file_type | char | 12 | √ |  | null |  |  |
filter_info | filter_desc | varchar | 40 | √ |  | null |  |  |
detections | filter_id | char | 2 |  |  |  |  |
filter_info.filter_id | detections_ibfk_1
fields | filter_id | char | 2 | √ |  | null |  |
filter_info.filter_id | fields_ibfk_1
det_rawattr_v2 | flags | int | 11 | √ |  | null |  |  |
det_rawattr_v2 | flags2 | int | 11 | √ |  | null |  |  |
fields | fov_deg | double | 22 | √ |  | null |  |  |
fields | fpa_id | varchar | 20 | √ |  | null |  |  |
derivedobjects | g | double | 22 | √ |  | null |  |  |
shapes | g | double | 22 | √ |  | null |  |  |
ssm | g | double | 22 | √ |  | null |  |  |
fields | gb_deg | double | 22 | √ |  | null |  |  |
tracklets | gcr_arcsec | float | 12 | √ |  | null |  |  |
ssm | h_ss | double | 22 | √ |  | null |  |  |
known | h_v | double | 22 |  |  |  |  |  |
orbits | h_v | double | 22 |  |  |  |  |  |
ssm | h_v | double | 22 |  |  |  |  |  |
known | i | double | 22 |  |  |  |  |  |
orbits | i | double | 22 |  |  |  |  |  |
ssm | i | double | 22 |  |  |  |  |  |
ingest_status | ingest_date | timestamp | 19 |  |  | CURRENT_TIMESTAMP |  |  |
aqueue | insert_timestamp | timestamp | 19 |  |  | CURRENT_TIMESTAMP |  |  |
eon_queue | insert_timestamp | timestamp | 19 |  |  | CURRENT_TIMESTAMP |  |  |
moid_queue | insert_timestamp | timestamp | 19 |  |  | CURRENT_TIMESTAMP |  |  |
det_rawattr_v2 | ipp_idet | int | 11 | √ |  | null |  |  |
history | is_lsd | char | 1 |  |  |  |  |  |
detections | is_synthetic | char | 1 | √ |  | null |  |  |
tracklets | known_id | bigint | 20 | √ |  | null |  |
known.known_id | tracklets_ibfk_3
known | known_name | varbinary | 50 | √ |  | null |  |  |
det_rawattr_v2 | kron_flux | float | 12 | √ |  | null |  |  |
det_rawattr_v2 | kron_flux_err | float | 12 | √ |  | null |  |  |
det_rawattr_v2 | kron_flux_inner | float | 12 | √ |  | null |  |  |
det_rawattr_v2 | kron_flux_outer | float | 12 | √ |  | null |  |  |
shapes | lambda_deg | double | 22 | √ |  | null |  |  |
history | last_event_id | bigint | 20 | √ |  | null |  |
history.event_id | history_ibfk_5
detections | length_deg | float | 12 | √ |  | null |  |  |
fields | limiting_mag | double | 22 | √ |  | null |  |  |
detections | mag | float | 12 |  |  |  |  |  |
detections | mag_sigma | float | 12 | √ |  | null |  |  |
runtime | message | varchar | 250 |  |  |  |  |  |
orbits | moid_1 | double | 22 | √ |  | null |  |  |
ssm | moid_1 | double | 22 | √ |  | null |  |  |
orbits | moid_2 | double | 22 | √ |  | null |  |  |
ssm | moid_2 | double | 22 | √ |  | null |  |  |
orbits | moid_long_1 | double | 22 | √ |  | null |  |  |
ssm | moid_long_1 | double | 22 | √ |  | null |  |  |
orbits | moid_long_2 | double | 22 | √ |  | null |  |  |
ssm | moid_long_2 | double | 22 | √ |  | null |  |  |
det_rawattr_v2 | moments_r1 | float | 12 | √ |  | null |  |  |
det_rawattr_v2 | moments_rh | float | 12 | √ |  | null |  |  |
det_rawattr_v2 | moments_xx | float | 12 | √ |  | null |  |  |
det_rawattr_v2 | moments_xy | float | 12 | √ |  | null |  |  |
det_rawattr_v2 | moments_yy | float | 12 | √ |  | null |  |  |
derivedobjects | mops_classification | char | 3 | √ |  | null |  |  |
export_dets | mpc_accepted | char | 1 | √ |  | null |  |  |
det_rawattr_v2 | n_frames | int | 11 | √ |  | null |  |  |
det_rawattr_v2 | n_pos | int | 11 | √ |  | null |  |  |
fields | nn | int | 11 | √ |  | null |  |  |
known | node | double | 22 |  |  |  |  |  |
orbits | node | double | 22 |  |  |  |  |  |
ssm | node | double | 22 |  |  |  |  |  |
orbits | o_minus_c | double | 22 | √ |  | null |  |  |
derivedobjects | object_name | varbinary | 32 | √ |  | null |  |  |
detections | object_name | varbinary | 32 | √ |  | null |  |  |
ssm | object_name | varbinary | 32 |  |  |  |  |  |
detections | obscode | char | 3 | √ |  | null |  |  |
fields | obscode | char | 3 | √ |  | null |  |  |
fields | ocnum | int | 11 | √ |  | null |  |  |
history | orbit_code | char | 1 | √ |  | null |  |  |
derivedobjects | orbit_id | bigint | 20 | √ |  | null |  |
orbits.orbit_id | derivedobjects_ibfk_1
history | orbit_id | bigint | 20 | √ |  | null |  |
orbits.orbit_id | history_ibfk_2
moid_queue | orbit_id | bigint | 20 |  |  |  |  |
orbits.orbit_id | moid_queue_ibfk_1
detections | orient_deg | float | 12 | √ |  | null |  |  |
shapes | p | double | 22 | √ |  | null |  |  |
fields | pa_deg | double | 22 | √ |  | null |  |  |
fields | parent_id | bigint | 20 | √ |  | null |  |  |
history_identifications | parent_orbit_id | bigint | 20 |  |  |  |  |
orbits.orbit_id | history_identifications_ibfk_3
det_rawattr_v2 | peak_flux_as_mag | float | 12 | √ |  | null |  |  |
shapes | period_d | double | 22 | √ |  | null |  |  |
shapes | ph_a | double | 22 | √ |  | null |  |  |
shapes | ph_d | double | 22 | √ |  | null |  |  |
shapes | ph_k | double | 22 | √ |  | null |  |  |
derivedobjects | pole_lat | double | 22 | √ |  | null |  |  |
derivedobjects | pole_long | double | 22 | √ |  | null |  |  |
tracklets | pos_ang_deg | double | 22 | √ |  | null |  |  |
ssm_desc | prefix | char | 4 | √ |  | null |  |  |
tracklets | probability | double | 22 | √ |  | null |  |  |
detections | proc_id | bigint | 20 | √ |  | null |  |  |
det_rawattr_v2 | psf_chi2 | float | 12 | √ |  | null |  |  |
det_rawattr_v2 | psf_dof | int | 11 | √ |  | null |  |  |
det_rawattr_v2 | psf_inst_flux | float | 12 | √ |  | null |  |  |
det_rawattr_v2 | psf_inst_flux_sig | float | 12 | √ |  | null |  |  |
det_rawattr_v2 | psf_major | float | 12 | √ |  | null |  |  |
det_rawattr_v2 | psf_minor | float | 12 | √ |  | null |  |  |
det_rawattr_v2 | psf_npix | int | 11 | √ |  | null |  |  |
det_rawattr_v2 | psf_qf_perfect | float | 12 | √ |  | null |  |  |
det_rawattr_v2 | psf_quality | float | 12 | √ |  | null |  |  |
det_rawattr_v2 | psf_theta | float | 12 | √ |  | null |  |  |
known | q | double | 22 |  |  |  |  |  |
orbits | q | double | 22 |  |  |  |  |  |
ssm | q | double | 22 |  |  |  |  |  |
detections | ra_deg | double | 22 |  |  |  |  |  |
fields | ra_deg | double | 22 |  |  |  |  |  |
residuals | ra_error_deg | float | 12 | √ |  | null |  |  |
residuals | ra_resid_deg | float | 12 | √ |  | null |  |  |
fields | ra_sigma | double | 22 | √ |  | null |  |  |
detections | ra_sigma_deg | float | 12 | √ |  | null |  |  |
det_rawattr_v2 | ratio_all | float | 12 | √ |  | null |  |  |
det_rawattr_v2 | ratio_bad | float | 12 | √ |  | null |  |  |
det_rawattr_v2 | ratio_mask | float | 12 | √ |  | null |  |  |
detections | ref_mag | float | 12 | √ |  | null |  |  |
export_dets | removal | char | 1 | √ |  | null |  |  |
orbits | residual | double | 22 |  |  |  |  |  |
export_dets | rev_id | bigint | 20 | √ |  | null |  |
export.revision_id | export_dets_ibfk_1
export | rev_time | datetime | 19 | √ |  | null |  |  |
derivedobjects | rotation_epoch | double | 22 | √ |  | null |  |  |
derivedobjects | rotation_period | double | 22 | √ |  | null |  |  |
detections | s2n | float | 12 | √ |  | null |  |  |
fields | se_deg | double | 22 | √ |  | null |  |  |
shapes | shape_id | bigint | 20 |  | √ |  |  |  | auto_increment
det_rawattr_v2 | sky | float | 12 | √ |  | null |  |  |
det_rawattr_v2 | sky_sigma | float | 12 | √ |  | null |  |  |
derivedobjects | ssm_id | bigint | 20 | √ |  | null |  |
ssm.ssm_id | derivedobjects_ibfk_2
history | ssm_id | bigint | 20 | √ |  | null |  |
ssm.ssm_id | history_ibfk_4
shapes | ssm_id | bigint | 20 |  |  |  |  |
ssm.ssm_id | shapes_ibfk_1
tracklets | ssm_id | bigint | 20 | √ |  | null |  |
ssm.ssm_id | tracklets_ibfk_2
derivedobjects | stable_pass | char | 1 | √ |  | null |  |  |
aqueue | status | char | 1 | √ |  | N |  |  |
derivedobjects | status | char | 1 | √ |  | null |  |  |
detections | status | char | 1 | √ |  | null |  |  |
eon_queue | status | char | 1 | √ |  | N |  |  |
fields | status | char | 1 | √ |  | N |  |  |
ingest_status | status | char | 1 | √ |  | N |  |  |
locks | status | char | 1 | √ |  | N |  |  |
runtime | status | char | 1 | √ |  | null |  |  |
tracklets | status | char | 1 | √ |  | null |  |  |
runtime | subsystem | varchar | 20 |  |  |  |  |  |
fields | survey_mode | varchar | 120 | √ |  | null |  |  |
locks | table_name | varchar | 30 | √ |  | null |  |  |
derivedobjects | taxonomic_type | char | 2 | √ |  | null |  |  |
ssm | taxonomic_type | char | 2 | √ |  | null |  |  |
known | time_peri | double | 22 |  |  |  |  |  |
orbits | time_peri | double | 22 |  |  |  |  |  |
ssm | time_peri | double | 22 |  |  |  |  |  |
fields | time_start | double | 22 | √ |  | null |  |  |
fields | time_stop | double | 22 | √ |  | null |  |  |
export | tracklet_export_id | bigint | 20 | √ |  | null |  |  |
alerted_tracklets | tracklet_id | bigint | 20 |  |  |  |  |
tracklets.tracklet_id | alerted_tracklets_ibfk_1
derivedobject_attrib | tracklet_id | bigint | 20 |  |  |  |  |
tracklets.tracklet_id | derivedobject_attrib_ibfk_2
history_attributions | tracklet_id | bigint | 20 |  |  |  |  |
tracklets.tracklet_id | history_attributions_ibfk_1
history_derivations | tracklet_id | bigint | 20 |  |  |  |  |
tracklets.tracklet_id | history_derivations_ibfk_1
history_precoveries | tracklet_id | bigint | 20 |  |  |  |  |
tracklets.tracklet_id | history_precoveries_ibfk_1
history_removals | tracklet_id | bigint | 20 |  |  |  |  |
tracklets.tracklet_id | history_removals_ibfk_1
residuals | tracklet_id | bigint | 20 |  |  |  |  |
tracklets.tracklet_id | residuals_ibfk_2
tracklet_attrib | tracklet_id | bigint | 20 |  |  |  |  |
tracklets.tracklet_id | tracklet_attrib_ibfk_1
fields | uncorrected_epoch_mjd | double | 22 |  |  |  |  |  |
derivedobjects | updated | timestamp | 19 |  |  | 0000-00-00 00:00:00 |  |  |
tracklets | v_dec | double | 22 | √ |  | null |  |  |
tracklets | v_dec_sigma | double | 22 | √ |  | null |  |  |
tracklets | v_ra | double | 22 | √ |  | null |  |  |
tracklets | v_ra_sigma | double | 22 | √ |  | null |  |  |
tracklets | v_tot | double | 22 | √ |  | null |  |  |
detections | xyidx | int | 11 | √ |  | null |  |  |
fields | xyidx_size | int | 11 | √ |  | null |  |  |
tracklets | tracklet_id | bigint | 20 |  | √ |  |
alerted_tracklets.tracklet_id | alerted_tracklets_ibfk_1
derivedobject_attrib.tracklet_id | derivedobject_attrib_ibfk_2
history_attributions.tracklet_id | history_attributions_ibfk_1
history_derivations.tracklet_id | history_derivations_ibfk_1
history_precoveries.tracklet_id | history_precoveries_ibfk_1
history_removals.tracklet_id | history_removals_ibfk_1
residuals.tracklet_id | residuals_ibfk_2
tracklet_attrib.tracklet_id | tracklet_attrib_ibfk_1
|  | auto_increment
derivedobjects | derivedobject_id | bigint | 20 |  | √ |  |
aqueue.derivedobject_id | aqueue_ibfk_1
derivedobject_attrib.derivedobject_id | derivedobject_attrib_ibfk_1
eon_queue.derivedobject_id | eon_queue_ibfk_1
history.derivedobject_id | history_ibfk_1
history_identifications.childobject_id | history_identifications_ibfk_1
|  | auto_increment
history | event_id | bigint | 20 |  | √ |  |
aqueue.event_id | aqueue_ibfk_2
eon_queue.event_id | eon_queue_ibfk_2
history.last_event_id | history_ibfk_5
history_attributions.event_id | history_attributions_ibfk_2
history_derivations.event_id | history_derivations_ibfk_2
history_identifications.event_id | history_identifications_ibfk_2
history_precoveries.event_id | history_precoveries_ibfk_2
history_removals.event_id | history_removals_ibfk_2
moid_queue.event_id | moid_queue_ibfk_2
|  | auto_increment
orbits | orbit_id | bigint | 20 |  | √ |  |
derivedobjects.orbit_id | derivedobjects_ibfk_1
history.orbit_id | history_ibfk_2
history_identifications.child_orbit_id | history_identifications_ibfk_4
history_identifications.parent_orbit_id | history_identifications_ibfk_3
moid_queue.orbit_id | moid_queue_ibfk_1
|  | auto_increment
ssm | ssm_id | bigint | 20 |  | √ |  |
derivedobjects.ssm_id | derivedobjects_ibfk_2
history.ssm_id | history_ibfk_4
shapes.ssm_id | shapes_ibfk_1
tracklets.ssm_id | tracklets_ibfk_2
|  | auto_increment
detections | 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
filter_info | filter_id | char | 2 |  |  |  |
detections.filter_id | detections_ibfk_1
fields.filter_id | fields_ibfk_1
fields | field_id | bigint | 20 |  | √ |  |
detections.field_id | detections_ibfk_2
history.field_id | history_ibfk_3
tracklets.field_id | tracklets_ibfk_1
|  | auto_increment
export | revision_id | bigint | 20 |  | √ |  |
export_dets.rev_id | export_dets_ibfk_1
|  | auto_increment
ssm_desc | desc_id | bigint | 20 |  | √ |  |
ssm.desc_id | ssm_ibfk_1
|  | auto_increment
known | known_id | bigint | 20 |  | √ |  |
tracklets.known_id | tracklets_ibfk_3
|  | auto_increment