SchemaSpy Analysis of atlas_T08 - Anomalies

Generated by SchemaSpy

Things that might not be 'quite right' about your schema:

• Columns whose name and type imply a relationship to another table's primary key:

  Child Column	Implied Parent Column
  derivedobject_attrib.derivedobject_id	eon_queue.derivedobject_id
  derivedobject_attrib.tracklet_id	tracklets.tracklet_id
  derivedobjects.derivedobject_id	eon_queue.derivedobject_id
  derivedobjects.orbit_id	moid_queue.orbit_id
  derivedobjects.ssm_id	ssm.ssm_id
  det_rawattr_v2.det_id	detections.det_id
  det_rawattr_v3.det_id	detections.det_id
  det_sig.det_id	detections.det_id
  detections.field_id	fields.field_id
  detections.filter_id	filter_info.filter_id
  eon_queue.event_id	history_attributions.event_id
  export_dets.det_id	detections.det_id
  fields.filter_id	filter_info.filter_id
  history.derivedobject_id	eon_queue.derivedobject_id
  history.event_id	history_attributions.event_id
  history.field_id	fields.field_id
  history.orbit_id	moid_queue.orbit_id
  history.ssm_id	ssm.ssm_id
  history_attributions.tracklet_id	tracklets.tracklet_id
  history_derivations.event_id	history_attributions.event_id
  history_derivations.tracklet_id	tracklets.tracklet_id
  history_identifications.event_id	history_attributions.event_id
  history_precoveries.event_id	history_attributions.event_id
  history_precoveries.tracklet_id	tracklets.tracklet_id
  history_removals.event_id	history_attributions.event_id
  manual_detections.det_id	detections.det_id
  moid_queue.event_id	history_attributions.event_id
  orbits.orbit_id	moid_queue.orbit_id
  residuals.det_id	detections.det_id
  residuals.tracklet_id	tracklets.tracklet_id
  runs.field_id	fields.field_id
  runtime.event_id	history_attributions.event_id
  shapes.ssm_id	ssm.ssm_id
  ssm.desc_id	ssm_desc.desc_id
  tracklet_attrib.det_id	detections.det_id
  tracklet_attrib.tracklet_id	tracklets.tracklet_id
  tracklets.field_id	fields.field_id
  tracklets.known_id	known.known_id
  tracklets.ssm_id	ssm.ssm_id

  39 instances of anomaly detected

• Tables without indexes:

  Table	Rows
  locks	1

  1 instance of anomaly detected

• Columns that are flagged as both 'nullable' and 'must be unique':
  Anomaly not detected

• Tables that contain a single column:
  Anomaly not detected

• Tables with incrementing column names, potentially indicating denormalization:

  Table
  det_rawattr_v2
  fields
  history
  orbits
  ssm

  5 instances of anomaly detected

• Columns whose default value is the word 'NULL' or 'null', but the SQL NULL value may have been intended:
  Anomaly not detected