SchemaSpy - Table marinedb.count

MARINe count qualifiers

Generated by
SchemaSpy

Legend:

Primary key columns

Columns with indexes

Implied relationships

Excluded column relationships

< n > number of related tables

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

count_qualifier_code

varchar

abalone_count_sizes.count_qualifier_code	FK_abalone_count_sizes_count_code R
abalone_count_sizes_active.count_qualifier_code	FK_abalone_count_sizes_active_count_code R
abalone_empty_shells.count_qualifier_code	FK_abalone_emptys_count_code R
abalone_empty_shells_active.count_qualifier_code	FK_abalone_emptys_active_count_code R
abhab_plots_count_sizes.count_qualifier_code	FK_abhabplot_count_sizes_count_code R
abhab_plots_count_sizes_active.count_qualifier_code	FK_abhabplot_count_sizes_active_count_code R
abhab_segments_count_sizes.count_qualifier_code	FK_abhab_count_sizes_count_code R
abhab_segments_count_sizes_active.count_qualifier_code	FK_abhab_count_sizes_active_count_code R
cryptochiton_count_sizes.count_qualifier_code	FK_cry_count_sizes_count_qualifier R
cryptochiton_count_sizes_active.count_qualifier_code	FK_cry_count_sizes_active_count_qualifier R
katharina_count_sizes.count_qualifier_code	FK_kat_count_sizes_count_qualifier R
katharina_count_sizes_active.count_qualifier_code	FK_kat_count_sizes_active_count_qual R
lottia_count_sizes.count_qualifier_code	FK_lottia_count_sizes_count_code R
lottia_count_sizes_active.count_qualifier_code	FK_lottia_count_sizes_active_count_code R
sea_star_color_count_sizes.count_qualifier_code	FK_sea_star_colors_count_code R
sea_star_counts.count_qualifier_code	FK_sea_star_count_count_code R
sea_star_disease_count_sizes.count_qualifier_code	FK_sea_star_disease_count_sizes_count_code R
sea_star_disease_count_sizes_active.count_qualifier_code	FK_sea_star_disease_count_sizes_active_count_code R
urchin_count_sizes.count_qualifier_code	FK_urchin_count_sizes_count_code R
urchin_count_sizes_active.count_qualifier_code	FK_urchin_count_sizes_active_count_code R

qualifier_codes.qualifier_code

FK_count_qualifiers_code R

Table contained 2 rows at Thu Apr 03 16:08 PDT 2025

Indexes:

Column(s)	Type	Sort	Constraint Name
count_qualifier_code	Primary key	Asc	PRIMARY