SchemaSpy Analysis of marinedb - 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
  abhab_not_sampled.target_assemblage	photo_plot_target_assemblages.target_assemblage
  abhab_not_sampled_active.target_assemblage	photo_plot_target_assemblages.target_assemblage
  abhab_notes.target_assemblage	photo_plot_target_assemblages.target_assemblage
  abhab_notes_active.target_assemblage	photo_plot_target_assemblages.target_assemblage
  abhab_plot_habitat_info.plot_code	count_size_plot_codes.plot_code
  abhab_plot_habitat_info_active.plot_code	count_size_plot_codes.plot_code
  abhab_plot_physical_info.plot_code	count_size_plot_codes.plot_code
  abhab_plot_physical_info_active.plot_code	count_size_plot_codes.plot_code
  abhab_plots_count_sizes.species_code	form_photo_plot_species_sort.species_code
  abhab_plots_count_sizes_active.species_code	form_photo_plot_species_sort.species_code
  abhab_plots_not_sampled.target_assemblage	photo_plot_target_assemblages.target_assemblage
  abhab_plots_sampled.target_assemblage	photo_plot_target_assemblages.target_assemblage
  abhab_sampled.target_assemblage	photo_plot_target_assemblages.target_assemblage
  abhab_sampled_active.target_assemblage	photo_plot_target_assemblages.target_assemblage
  abhab_segments_count_sizes.species_code	form_photo_plot_species_sort.species_code
  abhab_segments_count_sizes_active.species_code	form_photo_plot_species_sort.species_code
  form_transect_species_sort.species_code	form_photo_plot_species_sort.species_code
  marine_groups.group_code	transect_groups_active.group_code
  marine_species.species_code	form_photo_plot_species_sort.species_code
  migrations.id	users.id
  photo_plot_layer_codes.species_code	form_photo_plot_species_sort.species_code
  recon_group_species_active.species_code	transect_core_species_active.species_code
  seagrass_thickness_active.species_code	form_photo_plot_species_sort.species_code

  23 instances of anomaly detected

• Tables without indexes:
  Anomaly not detected

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

• Tables that contain a single column:

  Table	Column
  collection_qualifiers	collection_qualifier_code
  count_qualifiers	count_qualifier_code
  count_size_methods	method_code
  mussel_depth_qualifiers	qualifier_code
  mussel_size_qualifiers	qualifier_code
  photo_plot_core_species_active	species_code
  photo_plot_groups	group_code
  photo_plot_groups_active	group_code
  photo_plot_methods	method_code
  photo_plot_qualifiers	qualifier_code
  postelsia_methods	method_code
  postelsia_qualifiers	postelsia_qualifier_code
  size_qualifiers	size_qualifier_code
  transect_core_species_active	species_code
  transect_groups	group_code
  transect_groups_active	group_code
  transect_methods	method_code
  transect_qualifiers	transect_qualifier_code

  18 instances of anomaly detected

• Tables with incrementing column names, potentially indicating denormalization:

  Table
  photo_plot_layers_onp

  1 instance 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