SchemaSpy Analysis of psmops_ps1_mdrm137 - Constraints Generated by
SchemaSpy
43 Foreign Key Constraints:
SourceForge.net

Constraint Name Child Column Parent Column
alerted_tracklets_ibfk_1 alerted_tracklets.tracklet_id tracklets.tracklet_id
aqueue_ibfk_1 aqueue.derivedobject_id derivedobjects.derivedobject_id
aqueue_ibfk_2 aqueue.event_id history.event_id
derivedobject_attrib_ibfk_1 derivedobject_attrib.derivedobject_id derivedobjects.derivedobject_id
derivedobject_attrib_ibfk_2 derivedobject_attrib.tracklet_id tracklets.tracklet_id
derivedobjects_ibfk_1 derivedobjects.orbit_id orbits.orbit_id
derivedobjects_ibfk_2 derivedobjects.ssm_id ssm.ssm_id
det_rawattr_v2_ibfk_1 det_rawattr_v2.det_id detections.det_id
detections_ibfk_1 detections.filter_id filter_info.filter_id
detections_ibfk_2 detections.field_id fields.field_id
eon_queue_ibfk_1 eon_queue.derivedobject_id derivedobjects.derivedobject_id
eon_queue_ibfk_2 eon_queue.event_id history.event_id
export_dets_ibfk_1 export_dets.rev_id export.revision_id
export_dets_ibfk_2 export_dets.det_id detections.det_id
fields_ibfk_1 fields.filter_id filter_info.filter_id
history_attributions_ibfk_1 history_attributions.tracklet_id tracklets.tracklet_id
history_attributions_ibfk_2 history_attributions.event_id history.event_id
history_derivations_ibfk_1 history_derivations.tracklet_id tracklets.tracklet_id
history_derivations_ibfk_2 history_derivations.event_id history.event_id
history_ibfk_1 history.derivedobject_id derivedobjects.derivedobject_id
history_ibfk_2 history.orbit_id orbits.orbit_id
history_ibfk_3 history.field_id fields.field_id
history_ibfk_4 history.ssm_id ssm.ssm_id
history_ibfk_5 history.last_event_id history.event_id
history_identifications_ibfk_1 history_identifications.childobject_id derivedobjects.derivedobject_id
history_identifications_ibfk_2 history_identifications.event_id history.event_id
history_identifications_ibfk_3 history_identifications.parent_orbit_id orbits.orbit_id
history_identifications_ibfk_4 history_identifications.child_orbit_id orbits.orbit_id
history_precoveries_ibfk_1 history_precoveries.tracklet_id tracklets.tracklet_id
history_precoveries_ibfk_2 history_precoveries.event_id history.event_id
history_removals_ibfk_1 history_removals.tracklet_id tracklets.tracklet_id
history_removals_ibfk_2 history_removals.event_id history.event_id
moid_queue_ibfk_1 moid_queue.orbit_id orbits.orbit_id
moid_queue_ibfk_2 moid_queue.event_id history.event_id
residuals_ibfk_1 residuals.det_id detections.det_id
residuals_ibfk_2 residuals.tracklet_id tracklets.tracklet_id
shapes_ibfk_1 shapes.ssm_id ssm.ssm_id
ssm_ibfk_1 ssm.desc_id ssm_desc.desc_id
tracklet_attrib_ibfk_1 tracklet_attrib.tracklet_id tracklets.tracklet_id
tracklet_attrib_ibfk_2 tracklet_attrib.det_id detections.det_id
tracklets_ibfk_1 tracklets.field_id fields.field_id
tracklets_ibfk_2 tracklets.ssm_id ssm.ssm_id
tracklets_ibfk_3 tracklets.known_id known.known_id

Check Constraints:

Table Constraint Name Constraint
None detected