Tables Relationships Utility Tables Constraints Anomalies Columns Donate

SchemaSpy Analysis of psmops_ps1_mdrm137 - Constraints | Generated by SchemaSpy

43 Foreign Key Constraints: |

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